Business View ibvFeesBalanceSOPLCPC

Description

This view shows the outstanding Fees balance at start of a period by job internal id and period for the lates closed period plus the same period from the previous year.

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

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 the current period and the previous period is in reconciliation 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. All account period combinations are represented, even for these circumstances.

 

For use by

This view is suitable for any user wanting access to the client fees ledger start balances.

 

Columns

ClientObjectType

The object type of the client job that the balance is for.

ClientInternalId

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

Year

Fees ledger year

Period

Fees ledger period in year

Balance

The actual balance

 

  •