...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
GB - ExVATvsNetCharge.xml
EDI BILLS ONLY?
The excluding VAT charges on the bill do not 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 'Allow Tolerance' option has been added to this validator.
BUT THE BUREAU SET UP IS 3 (3P)?? WILL THAT STILL BE OK FOR THE ACCOUNTS LINK, OR IS THE ABOVE SAYING SOME ACCOUNTS LINK NEED TO BE TO THE PENNY
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 3%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=291199.49 97 - The figure entered in the Net charge field WHERE IS THIS FIGURE FROM?field, minus 3p (as per the Validator) £200.00 - 3p = £199.97
'CalcNet=296225.4300' - The figure in the Taxable total field
'TaxEntryFlag=1.00' - Confirms there is a 1 in the Apply VAT field
'billedNetUpper=291200.55' - WHERE IS THIS FIGURE????????03' - The figure entered in the Net charge field, + 3p (as per the Validator) £200.00 + 3p = £200.03
'exVATvsNetCharge=425.9100' - The figure in the Calc'd exVAT - NetChg field EXPLAINthe Taxable total field (225.00) minus the Net Charge field (200.00, - 25.00