 |
 |
|
|
This view shows the outstanding Fees balance at end of a fees period by job internal id and by fees period for the current ledger 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.
This view is suitable for any user wanting access to the client fees ledger balances.
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 |