Business View ibvFeesBalanceEOPLCPY

Description

This view shows the outstanding Fees balance at end of a fees period by job internal id and by fees period for the latest closed period plus all periods up to that one in the same year.

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.

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.

 

For use by

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

 

Columns

ClientObjectType

The object type of the client job that the balance is for (person, business or trust)

ClientInternalId

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

Fees ledger year

Period

Fees ledger period in year

Balance

The actual balance

 

  •