Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

Image Added GB - ExVATvsNetCharge.xml Image Added

EDI BILLS ONLY?

...

Excerpt

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

...

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

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 3%3p)

Bill Entry screen

Image Added

Image Added

Failure Prompt

...

Image Added

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