Hello,

We have incorrectly allocated HST on a large number of invoices that were imported into the AP module. Is there a way to import an adjustment batch to correct this such that we can apply the adjustment to the correct invoice? If so, can you provide me with the adjustment import template or a list of the fields that are required for the adjustment batch? If not, do you have any suggestions for how best to fix this without having to do a couple hundred manual adjusments?

Thank you,
Tanja

Hi, Tanja,

AP imports invoices and manual cheques not adjustments. The invoice import also enables you to import credit notes and debit notes which would be applied to the original invoice. The type of document being imported is indicated in the Det-Transaction Type field.

AP ships with sample import templates and sample import files (the files are stored in sample data located in x:\Softrak\APWIN\Samdata (where 'x' is the mapped drive your Adagio software is installed to)). The online Help topic in AP for Importing and Exporting contains a link to detailed Import and Export Format Notes for Invoices/Checks which should also be useful.

This is often the sort of task that it's best to get your Adagio consultant involved with rather than trying to accomplish over a forum such as this.

Tanja:

We could assist you with creating an import file by reading out the invoices and using formulas to create the necessary amounts to change.