WIP totals calculation
The table below shows for each field when it is updated.
Field |
Origin |
When |
Production |
Actual costing, charge = Y |
When adding and/or changing an actual costing line |
Production from hours |
Actual costing, charge = Y Item type = Work type |
When adding and/or changing an actual costing line |
Production not from hours |
Item type = Work type |
When adding and/or changing an actual costing line |
Added |
Draft line with processing method = Written off (B), where (line amount * -1) > 0 And Draft line with processing method = Invoiced plus line (Q), with (line amount) > 0 And Invoice lines for an invoice with integration type <> "01" and |
When adding and/or changing a draft line.
When adding and/or changing a project revenue line, where the invoice is checked to see if it is an advance note. |
Written off |
Draft line with processing method = Written off (B), where (line amount * -1) < 0 And Draft line with processing method = Invoiced plus line (Q), with (line amount) < 0 Draft processing date falls within period And FA Invoice line for an invoice with integration type <> "01" and |
When adding and/or changing a draft line.
When adding and/or changing a project revenue line, where the invoice is checked to see if it is an advance note. |
Transferred from |
Draft processing method = Transferred (O). The processing date falls within the period |
When completing the Detail lines action in an entry layout with draft lines.
|
Transferred to |
Draft, the draft source field is not blank. The creation date falls within the period. |
When completing the Detail lines action in an entry layout with draft lines
|
Invoiced |
The invoice date falls in the period |
When creating a project revenue line |
Settled advances |
Invoice, advance note = Y The invoice date falls in a period |
When creating a project revenue line, with the invoice being checked to see if it is an advance note |
Advances (to be settled) |
Draft, source line = 5, processing method = Invoiced (G), Written off (B). |
When processing during Invoice drafts function for the lines of the draft type. |
Advances (to be settled) |
Draft, source line = 4, processing method = To be transferred (W). The processing date falls within the period. |
When processing during Invoice drafts function for the lines of the draft type. |
Settled advances |
Draft, source line = 6, processing method = Invoiced advance line (W) and Written off (B). The processing date falls within the period |
When processing during Invoice drafts function for the lines of the draft type. |