The AP Open Interface requires an Amount for each Distribution and also the Total Amount for each Invoice.
There are three options to assist with calculation of the Invoice Total. These are:
(a)Manual - Enter the total or use a formula. AP Invoice Wizard calculates the total of the Distributions and errors the Invoice upload if the values do not match.
(b)Use ‘Calc’ button on Invoice Header form - There is a button on the form to populate the Invoice Total.
(c)Calc option in Invoice Total column - If ‘CALC’ is typed instead of the numeric total in the Invoice Total field, AP Invoice Wizard will automatically pass the total of the Distributions into the AP Open Interface. ‘Calc’ can also be typed into the ‘Invoice Header’ form instead of the actual total.
This total can be a simple addition of the distributions. However if you have the Supplier Site Tax calculation level set to ‘Line’ or ‘Tax Code’, AP will be calculating Tax and adding separate Distributions. AP Invoice Wizard takes this into account and works out the new total based on the Tax rate stored against the Tax Code.
