Order cost evaluation
- Description
- Accrual period
- Evaluation types
- Audit options
- Functionality
- Mark receipts as settled
- Recalculate actual costs
- Related topics
- Technical documentation
Description
This module is part of the final costing. The actual costs incurred for the sales orders can be listed according to the invoicing status (not invoiced/partially invoiced/invoiced) of the respective sales order and the stock orders can be listed according to the processing status (stored, provided, production order, etc.). The setting for the selection of the sales and stock orders are initialised so that the current "Unfinished products" are listed.
The sales orders can also be listed together with the internal work orders assigned to them. Pre-selection by order type is also possible.
All actual costs up to the selected accrual period are listed; a from - to periods list is also possible. Orders without costs can be hidden.
IMPORTANT!
Before calling up the job cost evaluation, the suppressed errors of the individual database operations must have been checked and corrected. Only in this way can the correct result be determined. Missing data in parts can lead to these not being taken into account in the order cost evaluation. Whether all documents assigned to the order have been posted can be checked with the context menu"Display all successors".
If the order items are for a part with the staging type Kanban, no disposition, manual warehouse without main warehouse management or Kanban semi-finished product, the cost value on the order item is displayed in the ACTUAL costs column "Warehouse purchased parts".
Orders are always assigned to a cost unit, i.e. the costs posted to an order are also posted to the cost unit and can be viewed via the cost unit totals list or the cost type evaluation per cost unit. However, it may well be that costs are only posted to cost units - without specifying an order - which is why there may be differences between the details of the costs in this order cost evaluation and those in the above-mentioned other cost unit lists.
Accrual period
The accrual period defines up to which point in time or from which period costs are to be used for the calculation of order costs in the list.
The accrual period is not used to select the orders directly, i.e. you can use it to select orders that were created in a specific period.
If the "from-to period" checkbox is not set, all bookings with costs up to the accounting period are taken into account.
If the "from-to-period" checkbox is set, only bookings with costs that were booked between the two accounting periods are taken into account.
Evaluation types
Evaluation | Settings |
---|---|
Current "Work in progress" sales orders | Set current accrual period. Checkbox "Sales order" must be set. In the status window "Sales order", select the status "Not invoiced" and "Partially invoiced". |
Current "Work in progress" for all internal orders that are currently being processed. | Set the current accrual period. Checkbox "Int. order" must be set. Select the status "Production order" on the "Other filters" tab in the status window. Select the combo boxes "Type" and "Cumulate" as required. |
Select "Work in progress" sales orders at the end of a specific period. | Select the accrual period for which the statistics for "work in progress" are to be created. (e.g. "March 2013" - 31.3.2013 is used for the statistics). Checkbox "Sales order" must be set. In the status window "Sales order", select the status "invoiced", "not invoiced" and "partially invoiced". Checkbox "Invoice date" must be set and the period may only go up to the selected period. (e.g. "April 2013 - ") |
Select "Work in progress" internal orders at the end of a specific period. | Period - Select the period for which the statistics for "work in progress" are to be compiled. (e.g. "March 2013" - 31.3.2013 is used for the statistics). Checkbox "Int. order" must be set. Select all statuses on the "Other filters" tab in the status window.... Checkbox "Storage date" must be set and the period may only go up to the selected period. (e.g. "April 2013 - ") |
Follow-up costs of sales orders | Checkbox "Sales order" must be set. Select the status "Invoiced" in the status window "Sales order". As the accrual period, you must select a period (from - to) that is after that of the final invoice. |
Costs for invoiced sales orders | Checkbox "Sales order" must be set. In the status window "Sales order", select the status "Invoiced". Set the desired accrual period for the costs to be taken into account. Set the "Invoice date" checkbox and enter the date range for invoicing (e.g. January 2012 - December 2012 for all orders invoiced in 2012). |
Costs for stored internal orders | Checkbox "Int. order" must be set. On the "Other filters" tab in the status window, select the status "Stored". Set the desired accrual period for the costs to be taken into account. Set the checkbox "Storage date" and enter the date range for the storage (e.g. January 2012 - December 2012 for all orders that were stored in 2012). |
Check options
Various options are available for checking the order cost evaluation via the context menu (right mouse button) of the list (see).
Display of recalculated actual documents
Documents are automatically entered for the final costing when they are posted. The current costs are determined from the standard value of the order part or the material and labour costs of the production part. If costs could be determined, the document is displayed with the list "posted documents". In the case of missing costs or other errors due to incomplete or incorrect data, the document is listed with the suppressed errors.
Display of all subsequent documents (from document history).
Display of all documents that were posted with the order and normally contain actual costs for costing. You can output this list "posted documents" selected according to documents with and without costs. Documents without costs were not posted in the final costing and must be checked and posted via the module "suppressed errors". The unposted vouchers can be corrected in the selection "Displayvouchers without costs" via the context menu of the list"Display suppressed errors for voucher".
Display of recalculated actual material costs
A list of all parts that were posted for the order in the cost estimate with actual costs.
Total costs
Displays the sum of the actual costs for the selected rows.
Functionality
Menu item | Description |
---|---|
Edit | - |
: Create evaluation | Customer and/or stock orders are selected on the basis of the settings/filters and output in the list |
: Display evaluation again | If customer and/or warehouse orders have already been selected once and output in the list, you can output these orders again in the list with the new values after changing the results analysis period |
: List entries | - |
: : select all | All entries in the list are selected |
: : deselect all | All entries are deselected |
: : remove selected | The selected entries are removed |
: context menu list | Starting from a selected list entry, you can navigate to the order or project data or list the individual documents that have led to the actual costs listed. |
: : Order data | Displaying the order in the sales or warehouse order module. |
: : Project data | Displaying the project data |
: : Display of recalculated actual documents | See |
: : Display of recalculated actual material costs | see |
: : Display of all follow-up (document history) | see |
: : Total costs | see |
: : Remove selected entries | Removes the selected lines from the current list. |
: Post calculation | |
: : recalculation of actual costs | See |
: Close | Close window |
Select | - |
: sales order | Individual customer orders can be selected directly and dragged and dropped into the list. |
: Stock order | Individual storage orders can be selected directly and dragged and dropped into the list. |
: Cost unit | Individual cost units can be selected directly and dragged and dropped into the list, whereby all documents assigned to the cost unit are displayed in the list. |
Icon | Description |
---|---|
Create evaluation (see menu) | |
Display evaluation again (see menu) | |
The list is copied to the clipboard | |
Calling up the document history of the order selected in the list |
Fields
Field | Description |
---|---|
Filter | |
: accrual year | Financial year of the accrual period of the accrued actual costs. |
: accrual period | Business period of the accrual period of the accrued actual costs. |
: from - to period | If this field is selected, a "to" accrual period can be specified, the "accrual period" field then defines the "from" period |
: Display, even if no (expected) costs have been incurred. | Orders for which no costs or expected costs have been incurred in the specified accrual period should also be displayed. If an order item is to be ordered, the costs for the order are posted to the order as pure expected costs. If the purchase invoice is now received for this order, these are the actual costs. |
: Output currency | Output currency for value fields |
: sales orders | If this field is selected, the invoicing status of the sales orders to be selected for the evaluation can be selected. You can also select their order types and specify whether the internal plant orders assigned to a selected order should also be listed. |
incl. int. follow-up orders | If this check mark is set, a check is made for all orders found as to whether other internal (follow-up) orders are booked to the same cost unit and these are also output. |
: Int. orders | If this field is selected, the disposition status of the internal orders can be selected, which are used in the evaluation. (This tick corresponds to the same tick on the next tab: Further filters (see below)). |
: Advance requirement (offers) | Search for advance requirement documents that have only one quotation as a predecessor, as these are not taken into account in the normal evaluation of sales and stock orders. |
: Sales orders | |
: : | Order status - "invoiced", "partially invoiced" and "not invoiced". |
: : Order type | The filter on the sales order type. If none is selected, all sales order types are evaluated. Multiple selection is possible |
: : Billing date | If the invoicing status "Invoiced" is selected, a period can be specified here. Periods that are to be open forwards or backwards are marked with a "-": e.g. "-31.12.2012" means until 31.12.2012 and "31.12.2012-" means from 31.12.2012. Invoices outside this period are treated as not invoiced. Thus, orders that have already been invoiced can be included in "work in progress" evaluations if their invoicing period is after the period to be evaluated. |
Further filters | |
: Internal orders | Display of the disposition statuses that an internal order item can have. Select the statuses for which you want to create a recalculation. "Order header without item" is not an MRP status. This selection includes all internal orders that have no items but to which costs have been posted. |
: : Type | Selection filter for the order type of the internal orders. Only those internal orders are displayed that are assigned to one of the selected types. |
: : Cumulate | Order types of internal orders for which the order items of the internal orders are not displayed in the list, but the order header with the totals of all order items. If, for example, only the header is to be displayed for intercompany orders, the order type "Intercompany" must be selected here. All intercompany orders are then displayed cumulatively. |
: Storage date | If the status "stored" is selected for internal orders, a period can be specified here. Periods that are to be open forwards or backwards are marked with a "-": e.g. "-31.12.2012" means until 31.12.2012 and "31.12.2012-" means from 31.12.2012. Only internal orders stored within this period are taken into account. In this way, finished, stored order items can be included in evaluations of "unfinished products"/"work in progress" if their storage period is after the period to be evaluated. |
Order header with direct costs | The post-calculation of internal orders normally refers only to the items. Costs are normally posted to the items. If this checkbox is selected, costs that were posted to the header of the internal order are also taken into account. This option is always active for internal orders that are selected directly or inserted by "drag and drop". |
Projects | Here you can filter the orders according to the project type. Only the orders and internal orders to which a project/cost unit with the type selected here is assigned are then taken into account. |
: Cost centres | Here you can filter the orders according to the cost centres assigned to them. If a cost centre is selected, you can determine in the next field whether orders with an assignment to subordinate cost centres should also be selected. |
: incl. subordinate cost centres | Specifies whether orders with an assignment to subordinate cost centres are also to be selected from the cost centre selected in the previous field. |
Message columns | |
---|---|
Customer/internal order | Output of the type and number of the order. |
Unbooked | "X" - sales order is not yet booked. You can double-click on the item to open the sales order and check why it has not yet been posted. "F" - Documents that normally contain actual costs for the final costing have not been correctly posted in the final costing. In the context menu of the list you can check which documents are without costs with"Display all follow-up documents (from document history)". "C" - Order is set to invoiced but no invoice has been defined as the final invoice. Check the last invoice of the order and set the check in the checkbox "Final invoice". |
Type | In the case of a sales order, the order type (e.g. new creation) is output here; in the case of an internal order, the item number within the internal order is output here. |
Agent | Processor of the order (in the case of a sales order, it is the commercial processor). |
K-beam | Number of the cost unit assigned to the order. |
Customer/part | In the case of a customer order, the number of the customer is output, in the case of an internal order, the number of the part is output |
Name | In the case of a sales order, the name of the customer is output, in the case of an internal order, the name of the part is output |
Order value | Order value (only for a sales order) |
Target2 cost | Target2 costs (only for a sales order) |
Planned-actual (optional column) | Planned-actual costs (only for a sales order) |
Degree (optional column) | Fulfilment degree of processing (only for a sales order) |
Billing/Completed Status | In the case of a sales order, the current billing status is output, in the case of an internal order, the current disposition status is output. |
Invoiced | The sum of the value billed on a sales order using outgoing invoices, corrected for any credit notes. |
Invoice date debit | For a sales order, output of the billing date from the order header. |
Closing period | In the case of a sales order, output of the statistics period of the final invoice |
Stock of purchased parts | Value of the withdrawn purchased parts kept in stock without overhead costs. If order items are parts with the staging type Kanban, no staging, manual stock without main stock management or Kanban semi-finished product, then the cost value standing on the order item is displayed in the ACTUAL costs column "Stock purchased parts". | |
Stock purchased parts GMK | Additionally considered overhead costs for withdrawn purchased parts kept in stock. | |
Stock finished parts material | Material value of withdrawn, stock-managed production parts without overhead costs | |
Stock finished parts material GMK | Additionally considered overhead costs for withdrawn, stock-managed production parts | |
Stock of production parts Wage | Wage costs of withdrawn, stock-managed production parts without overhead costs | |
Stock production parts wage GMK | Additionally considered overhead costs of the wage share of withdrawn, stock-managed production parts | |
BDE Wage costs | Cost of logged off times of order-related manufactured parts without overhead costs (cost = logged off time * hourly rate of the resource). | |
BDE labour costs GMK | Additionally considered overhead costs of the wage share of order-related manufactured parts | |
BDE hours | Total logged off time of order-related manufactured parts | |
Outside labour | BDE external work (extended workbench) without GMK (Only if the external work sequence is logged off via a BDE document. Not if the external work sequence is deregistered via a goods receipt). | |
External work GMK | Overhead cost share of the external work sequences deregistered via BDE time ticket recording. | |
Construction costs | Construction costs recorded for the order via time recording. Overhead costs are not added here, so there are no overhead costs for construction costs. | |
Construction hours | Construction hours that were recorded via the hours recording for the order. | |
Merchandise (ER) | The value entered via purchase invoices for material that was ordered directly for an order item and is itself included as an order item in the order, i.e. has not gone via production or the warehouse. Attention: credit notes on receipt reduce this value! | |
Services (ER) | The value recorded via A/P invoices for services, text items and assemblies, on order items and in production. Attention: Receipt credits reduce this value! | |
Purchased parts (ER) | The value entered via incoming invoices for material that is required for the production of the goods ordered by the customer or has been marked as an additional order. There are no order items for these purchased parts, they are only included in production bills of materials for parts manufactured to order (exceptions are additional orders!). Attention: Input credits reduce this value! | |
Purchased parts (ER without order) | The values recorded via incoming invoices for which there were no purchase orders. Attention: Input credits reduce this value! | |
Merchandise (expected from stock) | The expected value entered via purchase orders for material that was ordered directly for an order item and is itself contained as an order item in the order, i.e. has neither gone via production nor via the warehouse. | |
Services (expected from stock) | The expected value entered via purchase orders for services, text articles and assemblies, on order items and in production. | |
Purchased parts (expected from stock) | The expected value entered via purchase orders for material that is required for the production of the goods ordered by the customer or has been marked as a supplementary order. There are no order items for these purchased parts; they are only included in production bills of materials for parts manufactured to order (exceptions are additional orders!). | |
Assembly costs | Total assembly costs recorded for the order. | |
Assembly hours | Total time recorded for the order for the assembly certificates | |
FiBu costs | Financial accounting documents posted for the order - total costs incl. overhead costs
| |
FiBu Revenues | Financial accounting documents of the types A/R invoice and A/R credit note posted for the order. If the revenue of the outgoing invoices predominates in a period, the amount is shown negatively. If, on the other hand, the revenue from the A/R credit memos predominates, the amount is shown as positive. | |
Fibu var.costs | Sum of all FIBU costs of the cost type "variable". Only FIBU cost documents that can be assigned to the order or cost object are taken into account. Stock postings and PDC postings have no FIBU documents and are therefore not taken into account as costs here. | |
Fibu fixed costs | Sum of all FIBU costs of the cost type "fixed". Stock postings and PDC postings do not have any FIBU documents and are therefore not considered as costs here. | |
Total | Total of all orders | |
Down payments | Total of all down payments made for this cost object or order | |
Invoices issued | Total of all invoices issued | |
Difference of invoices issued | Difference between the invoices issued and the total. If the sum of the invoices issued is greater than the sum Is, the value negative | |
Invoices issued percentage | Proportion of invoices issued to the total as a percentage. | |
Target2 costs | Sum of the cost value of the items, which are determined according to the logistics indicator on the basis of the order role or production role of the items. | |
Target2 Costs Margin | Margin between the target2 costs and the total as a percentage value. | |
Planned-actual | Summer of the items based on the gozzino, i.e. orders already placed and production planning are taken into account in the calculation. | |
Plan-actual margin | Margin between the planned-actual and the total as a percentage value. | |
Order numbers | All numbers of orders separated by commas that are assigned to the cost order. | |
Actual costs | Sum of all posted costs incl. overhead share. | |
Actual marginal costs | Sum of all posted costs without overhead share |
Buttons
Button | Description |
---|---|
Close | The window is closed. |
Mark receipts as settled
Field | Description |
---|---|
Calculation | If the receipts are to be assigned to an invoice, the invoice or its item can be selected via this button. The selected invoice is then visible in the adjacent box. |
Voucher list | All vouchers that are to be linked to this invoice or marked as not chargeable. |
Button | Description |
---|---|
Assign invoice | If no receipt is selected in the list, all receipts are linked to the selected invoice, otherwise only the selected ones. After successful linking, the receipts are removed from the list. |
Not billable | If no voucher is marked in the list, all vouchers are marked as 'not billable', otherwise only the selected ones. After successful marking, the vouchers are removed from the list. |
Close | The window is closed. |
Recalculate actual costs
Here you can recalculate the actual costs of the stock movements (i.e. stock removal and stock placements), the exploded parts lists (e.g. JIT, KANBAN parts and manual stock) and the PDC working times for the orders selected in the list box. Normally, only the documents that are already taken into account in the final costing are recalculated. However, by setting the checkbox "Check successor documents not taken into account", you can ensure that all successor documents are checked. Each document is booked out of the recalculation and booked in again as selected with the valid costs on the document date or the validity date that can be entered in the mask.
The new actual costs are immediately written into the documents and thus into the post-calculation of the order. By recalculating the documents with the document date, you only have the possibility to approximate the old status. Therefore, the call of this function should be carried out with care, preferably in a test environment first. For tracking purposes, all changes to the actual costs of the recalculation are written to the file "NeuBerechnungIstKosten_Datum.log" in the temporary directory.
Hint:
Note that the system-wide validity date is changed when recalculating.
Field | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Period | A period of the document to be reposted.
| ||||||||
Validity date | If the checkbox is selected, a validity date can be entered for the calculation, if not, the voucher date is taken as the validity date. | ||||||||
Stock movements | Storage and retrieval | ||||||||
resolved parts lists | JIT, KANBAN parts, manual storage, etc. | ||||||||
PDA working times | Booked actual working times | ||||||||
Check succession documents not taken into account | Not only the already posted documents are checked, but all follow-up documents of the order. Documents without a value when entered are not posted in the post-calculation. These documents are now checked again and another attempt is made to post them in the final costing. | ||||||||
Post ignored receipts as well | For documents that have been selected as to be ignored, e.g. in the case of suppressed errors, an attempt is made to post them in the final costing. |
Button | Description |
---|---|
Take over system date | The current system date is written into the input field for the validity date. |
Start | The recalculation is started. There is an additional security prompt ! |
Cancel | The window is closed. |
Options window
Menu item | Description |
---|---|
Edit | - |
: Set default settings | all changed settings are reset to default |
Field | Description |
---|---|
General options | |
: Load list contents completely immediately | If the option is deactivated, only the items that are currently displayed on the screen are loaded. Advantage : the list appears faster on the screen Disadvantage : the system loads the items first when scrolling through the list and there are delays as a result. If this option is activated, the complete list is loaded into the memory. |
: Display with planned-actual costs | Show "planned-actual" and "degree" column in the list. |
: Check suppressed errors | A check is made to see whether suppressed errors exist for an order; if so, an "F " is entered in the " Unbooked" column. If there are a lot of unprocessed "suppressed errors", the display of the orders slows down massively. Therefore, a maximum of 2500 "suppressed errors" is set for this function, i.e. if you have more than 2500 errors, the check is deactivated. |
Default settings | |
Global preferences | Global default settings can be saved for the client and the cost centre. These are displayed here as well as the current default options that each module has. To create a global preset, a user preset must first be saved. Right-clicking on this user setting and selecting the context menu item "Edit user-defined setting" opens an editing window for this setting, on which the assignment from employee / user to a client or cost centre can be changed. ("Level" button) |
: User Preferences | Each user can save as many presettings as desired. The only thing to note is that if several settings are found, the first one found is used as the default setting. The name of the setting can be changed with a double click. |
Button | Description |
---|---|
OK | The settings are saved and the window closes. |
Related topics
- Cost Object Totals List Cost unit totals list
- Cost element evaluation per cost unit
- Outgoing invoice book
- Technical documentation Columns Post-calculation
- Suppressed errors
- Calculation
- Index
Technical documentation
Order cost evaluation basic module
Module name
statwprg.mod
Classes
-
Security
In addition to restricting access rights via the class and its data fields, the module can be restricted in its use via some of the received messages.
Message | Parameter | Function | Security |
---|---|---|---|
BUSINESS_YEAR_SELECTED | |||
REPORT_WORK_IN_PROGRESS |
Message | Parameters | Function | Receive module |
---|---|---|---|
SHOW_PREVIEW | Widget | Print preview | Print preview |
Technical description
- Document identification
- Online posting of receipts - principles
- Existing messages for document types
- Macros (night run)
- Which costs in the final costing are written to which data fields on the documents, preceding documents and accounts?
Document identification
- realEnd.counter[1] = Everything booked in correctly, does not need to be recalculated!realEnd.counter[1] = Everything posted correctly, no need to recalculate!
- realEnd.counter[2 ] = Already run (at least) once through recalculation (successful or unsuccessful). In addition, this also controls when the document is posted; if the bit is not set, the document is not posted immediately but only by the night run.realEnd.counter[2] = Already run (at least) once through recalculation (successful or unsuccessful). In addition, this also controls when the document is posted; if the bit is not set, the document is not posted immediately but only by the night run.
- realEnd.counter[3 ] = state (1 = booked in and 0 = booked out)realEnd.counter[3] = state (1 = booked in and 0 = booked out)
- realEnd.counter[5 ] = 1 = permanently ignore for post-calculation = document will never be reposted for post-calculation again, even during normal saving.realEnd.counter[5] = 1 = permanently ignore for post-calculation = document is never reposted again for post-calculation, even during normal storage
- realEnd.actionNumber0 = 1 = force calculation of cost for putaway documents.realEnd.actionNumber[0] = 1 = force calculation of cost for storage removal documents.
If a document is found in the post-calculation that has the flag realEnd.counter2 = 1 AND realEnd.counter3 = 1, then this document must first be booked out!If a document is found in the post-calculation that has the flag realEnd.counter[2] = 1 AND realEnd.counter[3] = 1, then this document must first be booked out!
Explanation regarding night runs: As soon as a document has bit 1, 2 or 5, it is no longer used for the night run. If such documents are booked out and in, the calculation is booked immediately.
During operation, each document to be booked out must be checked to see whether it must also be booked out of the calculation. The module recognises this at the realEnd.counter3=1. If the item is now booked out, changed and booked in again by the normal booking, the module recognises at the realEnd.counter2 that this document must be booked back into the post-calculation. The realEnd.counter2 is never deleted from the document once it has been set. It is the indicator that the document has already been posted once in the post-calculation.During operation, each document to be booked out must be checked to see whether it must also be booked out of the calculation. The module recognises this by the realEnd.counter[3]=1. If the item is now booked out, changed and booked in again by the normal booking, the module recognises by the realEnd.counter[2] that this document must be booked back into the post-calculation. The realEnd.counter[2] is never deleted from the document once it has been set. It is the indicator that the document has already been posted once in the post-calculation.
If the realEnd.counter5 is set on a document, it does not need to be booked out of the post-calculation before normal posting and it does not need to be booked in again! However, this module takes care of this check, it does not need to be checked in any other module!If the realEnd.counter[5] is set on a document, it does not need to be booked out of the post-calculation before normal posting and it also does not need to be booked in again!!! But this module takes care of this check, it does not need to be checked in any other module!
Online posting of vouchers - principles
If the voucher has already been posted to the final costing, it must be booked out beforehand.
This is usually implemented via the BookItem and UnbookItem macros of the respective module.
Here, before the document is posted out of its normal posting, it is first checked whether bit 3 of the realEnd.counter is set, i.e. whether the document is also posted in the post-calculation:
transaction Copy(realEnd.counter3) iftransaction Copy(realEnd.counter[3]) if {
}
After posting via the normal update, it must then also be checked whether the document is to be posted to the final costing: Bit 2 of the realEnd.counter s provides information about this.
transaction Copy(realEnd.counter2) iftransaction Copy(realEnd.counter[2]) if {
}
Existing messages for document types
Message | Description |
LOAD_STOCK_WITHDRAWAL_ITEM | Swap document items. Several items can be transferred in a vector or collection. However, they must all belong to one document. |
LOAD_DELIVERY_NOTE_ITEM | Delivery note item, only applies to delivery notes with an order as predecessor that are directly outsourced. Several items can be transferred in a vector or collection. However, they must all belong to one document. |
LOAD_STOCK_INPUT_ITEM | Putaway document items. Several items can be transferred in a vector or collection. However, they must all belong to one document. |
LOAD_RECEIVING_ITEM | Goods receipt item |
LOAD_PURCHASE_INVOICE_ITEM | Goods receipt invoice item |
LOAD_PURCHASE_ORDER_ITEM | Order items |
LOAD_DOWN_PAYMENT_REQUEST_SUPPLIER | Down payment request of a supplier |
LOAD_NO_DISPOSITION_ITEM | Post KABAN, JIT or manual stock parts of a production order or an exploded BOM to the final costing. |
LOAD_INSTALLATION_CHARGES_ITEM | Installation record |
LOAD_PRODUCTION_DATA_CAPTURE_ITEM | PDC posting |
LOAD_COSTS_BOOKING_ITEM | Cost and service booking |
LOAD_FINANCIAL_BOOKING_ITEM | Financial accounting |
LOAD_JOB_RECORD_ITEM | Time sheet |
LOAD_ESTIMATED_STOCK_COSTS_ITEM | Target values of the material costs for a part request |
LOAD_ESTIMATED_JOB_COSTS_ITEM | Target values of the labour costs for a production order item |
LOAD_ESTIMATED_TASK_COSTS_ITEM | Target values of labour costs for work orders |
Macros (night run)
- The following macros are called for the night run, these are described in the module statwprg.lod:
- LoadStockWithdrawalData
Searches for all stock removal documents with "realEnd.counter=0". Then the items are posted to the post-calculation and "realEnd.counter1=1" is set. Searches for all stock removal documents with "realEnd.counter=0". Then the items are posted to the post-calculation and "realEnd.counter[1]=1" is set. - LoadStockInputData
Searches all putaway documents with "realEnd.counter=0". The items are then posted to the final costing and "realEnd.counter1=1" is set. Searches all putaway documents with "realEnd.counter=0". Then the items are posted to the final costing and "realEnd.counter[1]=1" is set. - LoadNoDispositionItems
All production orders that are finished, staged or stopped and have "realEnd.counter=0" are searched for. And for these, the actual values for the "non-planned parts" (JIT, KANBAN) are written to the costing. - LoadInstallationCharges
Searches for all assembly items with "realEnd.counter1=0". Then the items are posted to the final costing and "realEnd.counter1=1" is set. Searches all assembly documents with "realEnd.counter[1]=0". Then the items are posted to the final costing and "realEnd.counter[1]=1" is set. - LoadCapturedData
Searches all PDC postings with "realEnd.counter=0". The items are then posted to the final costing. - LoadPurchaseOrders
- CX_PURCHASE_INVOICE LoadPurchaseInvoices / CX_PURCHASE_CREDIT_NOTE LoadPurchaseInvoices
- LoadCostsBooking
Searches all actual cost documents(accounted.settings0=0) with "realEnd.counter=0" with cost unit or order and posts them to the final costing. Searches all actual cost documents(accounted.settings[0]=0) with "realEnd.counter=0" with cost unit or order and posts them to the post-calculation. - LoadJobRecords
Search all timesheets with "realEnd.counter=0". The items are then posted to the final costing. - LoadEstimatedStockCosts
Read in target values for the post-calculation of material costs. - LoadEstimatedJobCosts
Read in target values for the post-calculation of wage costs - LoadFinancialBookings
Searches for all FiBu postings with "realEnd.counter=0" that have a cost object, order and costs and are not an incoming invoice/credit note or order of the predecessor. - LoadDownPaymentRequestsSupplier
Searches for all down payment requests of a supplier that have not been posted and posts them to the final costing.
- LoadStockWithdrawalData
Which costs in the final costing are written to which data fields on the documents, preceding documents and accounts?
|
| Written directly on the document at the time of attachment | Post-calculation (also online posting) |
Voucher | Data field | TARGET1 | ACTUAL (STANDARD) |
|
| landed = SOLL1 | captured = ACTUAL |
Order item |
|
|
|
| Total cost price | purchase.pricePer |
|
Goods Off-Shelf |
|
|
|
| Material without GMK | material.capturedCosts | material.capturedCosts |
| Material GMK | material.capturedFixedOverheadCosts | material.capturedFixedOverheadCosts |
| Wage without GMK | wages.capturedCosts | wages.capturedCosts |
| Wages GMK | wages.capturedFixedOverheadCosts | wages.capturedFixedOverheadCosts |
| Purchased parts - material without GMK | stocked.capturedCosts | stocked.capturedCosts |
| Purchased parts - material GMK | stocked.capturedFixedOverheadCosts | stocked.capturedFixedOverheadCosts |
StockedOverheadCosts |
|
|
|
| Material without GMK | material.capturedCosts | material.capturedCosts |
| Material GMK | material.capturedFixedOverheadCosts | material.capturedFixedOverheadCosts |
| Wage without GMK | wages.capturedCosts | wages.capturedCosts |
| Wages GMK | wages.capturedFixedOverheadCosts | wages.capturedFixedOverheadCosts |
| Purchased parts - material without GMK | stocked.capturedCosts | stocked.capturedCosts |
| Purchased parts - material GMK | stocked.capturedFixedOverheadCosts | stocked.capturedFixedOverheadCosts |
Non-disposable parts |
|
|
|
| Material without GMK |
| material.capturedCosts |
| Material GMK |
| material.capturedFixedOverheadCosts |
| Wage without GMK |
| wages.capturedCosts |
| Wages GMK |
| wages.capturedFixedOverheadCosts |
| Purchased parts - material without GMK |
| stocked.capturedCosts |
| Purchased parts - material GMK |
| stocked.capturedFixedOverheadCosts |
Expected material costs |
|
|
|
| Material without GMK |
| material.estimatedCosts |
| Material GMK |
| material.estimatedFixedOverheadCosts |
| Wage without GMK |
| wages.estimatedCosts |
| Wages GMK |
| wages.estimatedFixedOverheadCosts |
| Purchased parts - material without GMK |
| stocked.estimatedCosts |
| Purchased parts - material GMK |
| stocked.estimatedFixedOverheadCosts |
Expected labour costs (dissolved labour pl.) |
|
|
|
| Planned PDC time |
| estimated.jobTime |
| Planned PDC wage costs without GMK |
| confirmed.estimatedCosts |
| Planned PDC labour costs GMK only |
| confirmed.estimatedFixedOverheadCosts |
Expected construction costs (work orders) |
|
|
|
| Planned work order time |
| requested.jobTime |
| Planned job cost |
| requested.estimatedCosts |
Assembly proofs |
|
|
|
| Total duration |
| reported.jobTime |
| Total costs incl. GMK |
| reported.capturedCosts |
BDE Hours |
|
|
|
| Total duration |
| captured.jobTime |
| Wage costs without GMK |
| confirmed.capturedCosts |
| Wage costs GMK |
| confirmed.capturedFixedOverheadCosts |
| Cost ext. AFO without GMK |
| supplied.capturedCosts |
| Cost ext. AFO GMK |
| supplied.capturedFixedOverheadCosts |
FiBu costs | CX_COSTS_BOOKING |
|
|
| FiBu total costs incl. GMK |
| booked.capturedCosts |
FiBu costs | CX_FINANCIAL_BOOKING Booking condition: Only if cost object AND order predecessor exist and the document has neither order, incoming invoice nor incoming credit memo predecessor, it is booked. |
|
|
| FiBu total costs incl. GMK |
| current.capturedCosts |
| If type outgoing invoice/credit note |
| out.capturedCosts |
Construction costs |
|
|
|
| Total duration in hours |
| technical.jobTime |
| Total costs incl. GMK |
| technical.capturedCosts |
Expected order costs (purchase orders) |
|
|
|
| Merchandise level 0 |
| transferred.estimatedCosts |
| Assemblies/services/text articles Level 0 + Level > 0 |
| assembled.estimatedCosts |
| Purchased parts for production level > 0 and additional orders |
| purchase.estimatedCosts |
Incoming invoices / |
|
|
|
| Merchandise level 0 |
| transferred.capturedCosts |
| Assemblies/services/text items level 0 + level > 0 |
| assembled.capturedCosts |
| Purchased parts for production level > 0 and additional orders |
| purchase.capturedCosts |
| ER without BE with AU predecessor |
| general.capturedCosts |
Down payment request from a supplier |
|
|
|
| Amount paid |
| requested.payments |