 |
 |
|
|
This view presents summary unmatched fees postings by period, date, job and categorisation. Basic figures are VAT exclusive, but the VAT amount is available within the view.
Each row returned by this view represents a posting against one job. The 'Total' columns represent the amounts on the fees ledger posting and will be replicated on each job that arises from the same fees invoice.
Therefore you should be cautious about any aggregation functions you apply to them. Postings that don't influence the time ledger at all (for example, receipts) will still be present. In this case there will be just one row for the fees posting and the job columns in the row will be missing.
This view obtains job based figures by apportionment. It will differ from the sum total debtors position by the amount of any bill that has not been allocated against WIP (or, indeed any bills that have been posted as not affecting the time ledger). It can also differ because of rounding discrepancies resulting from the apportionment of the billed amount across jobs that it writes time out for.
If all your bills write out time, and each one writes out to only one job, then figures should agree.
You can use view ibvFeesPostingFullRounding
to establish the magnitude of discrepancies of this form.
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. Absence of an expected row should be taken as implying zero figures.
Type = End user business view, incorporating business logic
Inherits columns from view ibvClientCategorisation plus
Inherits columns from view ibvJobCategorisation plus
Year |
Fees posting year |
Period |
Fees posting period in year |
Posting |
Unique posting number in period (to support logical primary keys for reporting services). |
Date |
Posting date |
Type |
Posting type |
PostTypeDesc |
Posting type in human readable form |
PostCategory |
Posting category |
PostCatDesc |
Posting category in human readable form |
TotalIncVAT |
The overall VAT inclusive total for the fees posting |
TotalMatched |
The overall VAT inclusive matched amount for the fees posting |
TotalOutstanding |
The overall VAT inclusive unmatched amount for the fees posting |
TotalExVAT |
The overall VAT exclusive total for the fees posting |
TotalVAT |
The overall VAT total for the fees posting |
TotalNumVATPostings |
The number of separate VAT postings associated with the Fees posting. |
TotalHighestVATRate |
The highest VAT rate associated with the Fees posting. |
AgeInDays |
Posting age (in days) from today. |
AgeInMonths |
Posting age (in months) from today. 0 = current month, 1 = last month etc. There is no cutoff in the number of bands |
AgeBandDays |
As AgeInDays, but expressed as a string and with a cutoff of four bands (less than 30, less than 60, less than 90, greater than or equal to 90) |
AgeBandMonths |
As AgeInMonths, but expressed as a string and with a cutoff of four bands (less than 1, less than 2, less than 3, greater than or equal to 3) |
JobBilledIncVAT |
Amount billed to the job, including VAT. Note that this figure will be subject to rounding errors as a result of apportionment |
JobMatchedIncVAT |
Amount matched to the job, including VAT. Note that this figure will be subject to rounding errors as a result of apportionment |
JobOutstandingIncVAT |
Amount outstanding for the job, including VAT. Note that this figure will be subject to rounding errors as a result of apportionment |
JobBilledExVAT |
Amount billed to the job, excluding VAT |
JobMatchedExVAT |
Amount matched to the job, excluding VAT. Note that this figure will be subject to rounding errors as a result of apportionment |
JobOutstandingExVAT |
Amount outstanding for the job, excluding VAT. Note that this figure will be subject to rounding errors as a result of apportionment |
Reference1 |
Reference 1 from the posting |
Reference2 |
Reference 2 from the posting |
CrossReference |
Cross reference from the posting |
Narrative |
User narrative from the posting |