 |
 |
|
|
This view aggregates rows in idvFeesTotalsByType so that there is only one row per period/account/type combination.
Because VAT totals are always stored in nominal conventions (and the complications this gives rise to when VAT is registered on a receipt) aggregations of VAT are not meaningful, so the VAT total is omitted.
Ex VAT figures are given and are accurate in as much as the information has been entered. Ex VAT figures for invoices and credit notes will normally always be entered. Ex VAT figures for receipts will be accurate if the VAT element was entered when the receipt was posted. There are never any VAT elements of refunds.
Since all real cash flow on the fees ledger includes VAT the only figures that can be guaranteed to cross cast correctly (and reconcile with balances) are the VAT inclusive figures. You can use the ex VAT figures in restricted circumstances if you are happy to do so and understand what the figures mean, and the difficulties of reconciling them.
This view is only suitable for advanced users. Aggregation view of fees posting type totals.
ClientObjectType |
The object type of the client object that the account is for |
ClientInternalId |
The internal id of the client object that the account is for |
Year |
The year part of the fees period |
Period |
The fees period number within the year |
Type |
The type of postings - see idvFeesPostingType |
PostCategory |
The category of posting - see idvFeesPostingCategory |
Total |
The fees total for postings of this type for this account and period. This is VAT inclusive and follows fees conventions (i.e. invoice = DR, receipt = CR, credit negative). |
ExVATTotal |
As Total but with VAT elements removed. |
ItemCount |
The number of items of this type for this account and period. |