 |
 |
|
|
This view summarises idvFeesTotalsByType splitting amounts out to separate columns, suitable for combined fees and WIP summarier, by client and period.
This view aggregates the totals information by client and period.
This view is restricted to the latest closed ledger period plus earlier periods in same ledger year plus the same set of periods in the previous ledger year.
Type = End user business view, incorporating business logic
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. |
Year |
Fees ledger year |
Period |
Fees ledger period in year |
InvoicedExVAT |
The total amount invoiced in the period (final and interim) with VAT elements removed. The difference between this and the corresponding billed values from the time ledger (assuming fees and time ledger periods are fully aligned) corresponds to the amount of invoicing that is not WIP related. This is credit negative (i.e. an invoice is positive) |
Invoiced |
The total amount invoiced in the period VAT inclusive. This is credit negative (i.e. an invoice is positive) |
CreditNotesExVAT |
The total amount of credit notes in the period with VAT elements removed. This is credit negative (i.e. a credit note is negative) |
CreditNotes |
The total amount of credit notes in the period with VAT elements included. This is credit negative (i.e. a credit note is negative) |
Cash |
Net receipts less refunds (credit negative, i.e. normally negative) |
OtherFees |
Net credit negative total of any postimgs that don't fall within the other categories (e.g. write offs, opening balance postings etc) |