The example is for a PL credit note which is to be batched, and it allows you to upload multi-line transactions to more than one supplier at a time for different currencies.
Every time you rebuild the template it populates with all suppliers and analysis codes along with the defaults - but once the sheet is populated, the data in those fields can be removed or changed to the required values.
In Excel, click the Access tab.
Select Templates.
Click Setup Update Template.
Select New Template, then click Next.
Select Purchase Ledger.
Select Purchase Credit Notes - Batch, then click Next.
Add the Available Fields with defaults as required and set the Cell Range as follows (the results will expand to show all items for the fields so ranges do not have to be large):
|
|
|
|
After the fields have been added please do the following:
Click Next.
Filter if necessary.
Click Next.
Save the template if required.
Click Insert.
Note: Every time you rebuild the template it populates with all suppliers (depending on the Filter) and analysis codes along with the defaults, but once populated you can delete unwanted Supplier rows and Analysis columns, over type with your own data or add extra fields at the ends of arrays if required. So if you populate using a single supplier code (which returns only one row) you could enter more rows below for that supplier or others using different Trans References, VAT Codes, Currencies etc. You can also overwrite the analysis codes with the ones you want - clearing the rest, and once done enter the relevant value in the cell below that analysis for the relevant supplier.