 |
 |
|
|
This view combines the basic posting view (icvFeesPostingWithVAT) with the details of which jobs are to have WIP adjusted and the way that this is apportioned across the bill (icvFeesPostingBilled).
This view will return more than one row per fees posting in general. If the fees posting writes out to the time ledger there will be one row for each job written out to, and the basic information for the posting (including the amount) will be duplicated on each row.
If the posting does not update the time ledger (e.g. a receipt) there will be just the single row, with BilledJobInternalId = null and BilledAmountExVAT = 0.
If a bill writes out time, but also includes an element that does not write out time, then the BilledAmountExVAT values will not add up to the ExVAT amount of the posting, because there is no write out entry present for the 'non WIP' portion of the bill. The difference between The fees posting amount (less the VAT element) and the aggregate of the BilledAmountExVAT across the posting gives the ex VAT part of the bill that didn't write out WIP. For historical reasons this is not a always represented in the 'Non WIP' columns of the basis Fees Posting information.
The BilledAmountIncVAT is calculated by apportionment. Since it rounds to pence it is subject to a rounding error. Within any code reading this view this will make itself felt if there is no 'non WIP' portion of the bill. In these circumstances the aggregate of the BilledAmountExVAT across the posting will accurately match the posting amount less the VAT amount.
However, the aggregate of the BilledAmountIncVAT across the posting may differ from the posting amount because of rounding errors. Direct use of this view should be prepared to accept this. Use of this view within code should be prepared to distribute the rounding error around the targetted jobs so that the numbers do add up.
The system allows cross billing. It is not necessarily true that the client referred via the affected job is the same client as the fees posting itself refers to.
This view is only suitable for advanced users. Amalgamation view - pulls together data from disparate sources for a prime entity.
Inherits columns from view icvFeesPostingWithVAT plus:
BilledJobInternalId |
The internal identifier of the job whose WIP is to be adjusted. This will be NULL on postings that do not affect WIP |
BilledAmountExVAT |
The amount of the bill that is to count against the WIP adjustment for the specified job. This column is normalised to obey the same sign convention as the amounts on the fees posting itself. This will be zero on postings that do not affect WIP. |
BilledAmountIncVAT |
The amount of the bill that is to count against the WIP adjustment for the specified job, but inclusive of VAT. This amount is calculated by apportionment, so may be subject to rounding errors |