Sigma Online User Manual
Ex VAT vs Net Charge
GB - ExVATvsNetCharge.xml
Checks the excluding VAT charges on the bill match the net charges on the Tax Entry tab.
This is designed for checking Accounts Links, where the charges must match to the penny, therefore it includes a percentage tolerance
Validator Set Up
Variables
Variable | Description |
---|---|
Tolerance limit (Pence) | Enter a percentage figure that you want the value to be within, for example 3 (for 3p) |
Bill Entry screen
Failure Prompt
Your bill exVAT charges are not within the tolerances of the net charges onthe TaxEntry tab: FAILED -The name of the Validator
'billedNetLower=199.97 - The figure entered in the Net charge field, minus 3p (as per the Validator) £200.00 - 3p = £199.97
'CalcNet=225.00' - The figure in the Taxable total field
'TaxEntryFlag=1.00' - Confirms there is a 1 in the Apply VAT field
'billedNetUpper=200.03' - The figure entered in the Net charge field, + 3p (as per the Validator) £200.00 + 3p = £200.03
'exVATvsNetCharge=25.00' - The figure in the Taxable total field (225.00) minus the Net Charge field (200.00, - 25.00
@ Copyright TEAM - Energy Auditing Agency Limited Registered Number 1916768 Website: www.teamenergy.com Telephone: +44 (0)1908 690018