 |
 |
|
|
This view exposes aggregates idvFeesTotalsByType over all types to be just by Account and period.
Refer to view idvFeesTotalsByType for a discussion of why subtracting the Ex VAT total from the grand total will not necessarily give the VAT total. (Fundamentally it's because VAT elements may be recorded on invoices AND receipts to allow working with ex VAT values.) Because of the potential confusion inherent in this mode of working the VAT period total is not included in this view.
Rows in this view are not guaranteed to cover all combinations of accounts and periods. In particular, if the period has no opening balance (for example, because the previous period is in reconciliation rather than closed), and there has been no activity on the account in the new period, then no row will be present for that account/period combination.
Other circumstances that can give rise to absent rows include transient ones, such as an account being posted to at the time that the last close period was run.
Type = Base view suitable for advanced end user use
| 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 |
| Total | Amount total - see idvFeestotalsByType |
| ExVATTotal | Ex VAT total - see idvFeestotalsByType |
| ItemCount | Total number of items - see idvFeestotalsByType |
This view is directly inherited by the following views: