Business View ibvWIPBalanceEOPLCPYC

Description

This view presents the outstanding WIP balance at end of period by job internal id and period.

The balance is deduced from the period totals. The opening balance and movements are used directly if available, failing that the period posting totals are summed.

Pending postings are not included in the balance.

 

This view may appear complex at first sight, especially in respect of the 'all periods' table to drive it. The reason is that, if it is used for open periods then, not only is no opening balance set but there will be no totals information AT ALL for that period for any account for which there were no postings in the period.

The cross join ensures all account period combinations are represented, even for pending periods with no postings. The join onto this cross join (as a derived table) will produce nulls for such account period combinations and they will revert to using the account totals by type aggregation. If this also produces nulls the coalesce function will convert this to zero.

Type = End user business view, incorporating business logic

 

Columns

JobInternalId

The internal identifier of the client job that the balance is for. The balance is as at the end of the period specified by the next two columns

Year

Time ledger year

Period

Time ledger period in year

Balance

The actual balance

 

  •