Accounts Payable (AP) & Accounts Receivable (AR) batch import

This document outlines the steps to import an Accounts Payable (AP) or Accounts Receivable (AR) batch.

1. Download the template (link: https://asamcofileshare.blob.core.windows.net/general/Customers%2FAR%20Batch%20import%20template.csv)
2. Open Sage Evolution.
3. Go to the AR or AP module.
   
   1. Transactions
   2. Accounts Receivable (or Payable) batches
   3. Open the batch you want to import the lines in.
      
      
      
      
4. After opening the batch, click on "Batch" and subsequently on "Import.."
   
   
   
   
5. Go to the second tab ("Field mapping")
6. Map the fields in your Excel to the field in this window.
7. Use the tick boxes to exclude a field or include a field.
8. Use the "Move up" or "Move down" to ensure the right sequence (the sequence of the columns in the Excel MUST MATCH the sequence here)
   
   
   
   
   
9. After completing the mapping, go back to the first tab ("Import file")
10. Check the the following options:
    1. "Header record" → when you leave the columns headers in the Excel (CSV) file, make sure that this checkbox is ticked.
    2. "Field delimiter" → make sure that you save your Excel file as (CSV - comma separated values()
    3. "Date format" → Ensure that the option "Windows Format" is selected.
       
       
       
       
11. Lastly, select the location where you have stored your CSV file to upload.
12. Make sure that the Excel file is closed when you want to start uploading.
13. Once done uploading, a confirmation message will be shown, optionally you can view the log file.
14. Your batch lines will be visible.