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

VariableDescription
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