Business View ibvFeesTotalsToColumnsLCPY

Description

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.

Type = End user business view, incorporating business logic.

 

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.

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)

 

  •