Set up a Purchase Credit Note upload template

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):

Single Cell Fields Date - B3	Row Fields Purchase Analysis - G6 - K6
Column Fields Supplier Code - C7 - C20 Trans Reference - D7 - D20 Vat Code - E7 - E20 Currency Code - F7 - F20 And other desired fields in the same way, such as Description or Detail, etc.	Data Default

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. Once populated, you can delete unwanted rows, over-type with your own data, or add extra fields at the ends of arrays if required.