 |
 |
|
|
This view shows the fees postings that correspond to the invoices, credit notes and write offs by period, date, client and categorisation for the current calender year.
The basic figures are VAT inclusive, but the VAT amount is available within the view.
Since this view is steered by the presence of postings, after any aggregation there will be no rows present for accounts and/or period combinations that have no postings present. The absence of an expected row should be taken as the figures being zero.
This view is to be used by those users wanted access to the fees postings.
This view inherits columns from the view:
Year |
Fees posting year |
Period |
Fees posting period in year |
Posting |
The unique posting number in the period (to support logical primary keys for reporting services). |
Date |
Posting date |
CalendarYear |
Calendar year independent of the period structure on ledger |
CalendarMonth |
Calendar month (1 = Jan, 2 = Feb etc) |
Type |
The posting type (invoice, credit note etc). |
PostTypeDesc |
Posting type in human readable form |
AffectsWIP |
'Y' if the posting affects the WIP |
Amount |
Posting amount (credit negative) |
Matched |
Current amount matched (same sign convention) |
Outstanding |
Current amount outstanding (unmatched) (same sign convention) |
VAT |
Amount of VAT (same sign convention, but note that this reflects what the user said and, if cash accounting this will appear on both the invoice and the receipt). |
NumVATPostings |
The number of separate VAT postings associated with the Fees posting. |
HighestVATRate |
The highest VAT rate associated with the Fees posting. |
Reference1 |
Reference 1 from the posting |
Reference2 |
Reference 2 from the posting |
CrossReference |
Cross reference from the posting |
Narrative |
User narrative from the posting |