Business View ibvTimeWriteOutPostingsLCPC

Description

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.

Type = End user business view, incorporating business logic

 

Columns

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

 

  •