WIP totals calculation

The table below shows for each field when it is updated.

Field

Origin

When

Production

Actual costing, charge = Y
Execution date falls within the period

When adding and/or changing an actual costing line

Production from hours

Actual costing, charge = Y

Item type = Work type
Execution date falls within the period

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
Draft processing date falls in period

And

Draft line with processing method = Invoiced plus line (Q), with (line amount) > 0
Draft processing date falls within period

And

Invoice lines for an invoice with integration type <> "01" and
Advance = "N" and
Line amount > 0
Invoice date falls within period
Here you find the absolute value of the line amount

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
Draft processing date falls within period

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
Advance = "N" and
Line amount < 0 Invoice date falls within period
Here you find the absolute value of the line amount

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).
The processing date falls within the period.

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.