 |
 |
|
|
This view returns time ledger write out/back postings and joins them to the instruction that gave rise to them. Write off postings are also included.
The 'billed' amount associated with the posting is deduced by apportioning the billed amount on the instruction by the ratio of the posting amount to the total instruction write out. This, of course, means that it can be subject to rounding errors.
It is also important to understand that the billed amount can change if more WIP is subsequently matched to the parent instruction. Consider an invoice for 1000 (ex VAT) that writes out an initial 250 each to two jobs A and B. At this stage the billed amount for each job shows 500 (half the total). If, later, a further 500 of WIP on job A is matched to the bill then the billed amount for job A will total 750, but this will be split over two postings, the first (which now shows a billed amount of 250) and the new write out (representing the second matching action) which shows a billed amount of 500.
Correspondingly, the billed amount for job B now shows 250, even though there has been no change to job B at all. Billed figures on these postings are only fixed once the parent instruction has ceased to be 'current' AND no further manual matching is to be done. (This statement could always be applied to ANY recovery figures, so, in reality, is not that revolutionary. However, take care that you understand this before basing any period reconciliation on these billed amounts.)
Pending postings are not included in the results.
Cancelled and contra postings are included in the results. This is primarily because the contra may be in a different period to the cancelled posting, and the cancelled posting might have been included in last month's figures before it was cancelled. If we now didn't show the contra it would be difficult to reconcile.
This view is restricted to the current ledger year as determined by current ledger period.
Type = End user business view, incorporating business logic
JobInternalId |
The internal identifier of the client job that the posting is for. |
Year |
Time posting year |
Period |
Time posting period in year |
Posting |
Unique posting number in period (to support logical primary keys for reporting services). |
CalendarYear |
Calendar year independant of period structure on ledger |
CalendarMonth |
Calendar month (1 = Jan, 2 = Feb etc) |
Date |
The date of the posting |
Type |
The type of the posting (see idvTimePostingType) |
PostTypeDesc |
The type of the posting in human readable form |
Contra |
'Y' if the posting is a contra. This allows you to distinguish between a bill and a bill cancellation for example (other than by the sign of the amount). |
Amount |
The posting write out amount as credit positive (i.e. a write out or off is positive, a write back is negative) |
Matched |
The amount currently matched to the posting (same sign convention as the posting amount) |
Billed |
The billed amount associated with the posting. This is calculated by apportionment of the billed amount of the instruction according to the write out of the posting relative to the instruciton. It is therefore subject to rounding errors. This amount is positive for a bill, and negative for a credit note. |
Reference |
Any reference on the posting |
Narrative |
Any narrative on the posting |
InstructionYear |
The time ledger year that the originating instruction is in |
InstructionPeriod |
The time ledger period within year that the originating instruction is in |
InstructionCalendarYear |
Calendar year for the instruction independant of period structure on ledger |
InstructionCalendarMonth |
Calendar month for the instruction (1 = Jan, 2 = Feb etc) |
InstructionDate |
The date of the time ledger instruction |
InstructionType |
The type of the time ledger instruction (see idvTimePostingType) |
InstructionBilled |
The total billed for the instruction, positive for a bill, negative for a credit note |
InstructionWriteOut |
The total write out for the instruction, positive for a write out, negative for a write back |