Import Purchase Order

Importing purchase orders allow you to import purchase orders from an external CSV file into Arbor Finance. This can be useful if you have multiple purchase orders to be recorded at any one time and can save re-entering similar details.

File format for Importing

The CSV file should be structured as follows

1. Column 1 First row IsHeader
2. Column 2 is the Date
3. Column 3 is the Supplier code
4. Column 4 is the Description
5. Column 5 is the FAO
6. Column 6 is the User order no
7. Column 7 is the Bank account
8. Column 8 is the Ship to address
9. Column 9 is the Supplier note
10. Column 10 is the Catalogue No
11. Column 11 is for Item description
12. Column 12 is the Quantity
13. Column 13 is the Price
14. Column 14 is the VAT code
15. Column 15 is S16
16. Column 16 is the Analysis code
17. Column 17 is the Budget
18. Column 18 is the Funding stream
19. Column 19 is the Cost centre

Please check the structure before importing.

Importing Purchase Orders

1. From the Transactions menu choose Expenditure > Search/Process.
2. Click the Import button on the right-hand side.
   
   
   
   
3. To select your file to import click Choose file, navigate to the file and click Open.
4. The Header line defines which line in your CSV file the headers are on.
5. If you are uploading the file for a second or third time and have a mapping stored then select it from the menu.
6. Click Start import to continue.
   
   
   
   
7. Map the headers in your CSV document.
8. Click Save to continue.
   
   
9. The Validation summary will detail if any lines have errors. The summary report will detail the errors (blue link on page to access this). If you need to make changes, click the link to see the errors and correct them accordingly in your spreadsheet. Once correct, attempt the import process again.
10. If you need to change anything click Cancel or click Complete import to proceed.
11. For those lines that are valid they will be imported and you will see the completed successfully message as per below:
    
    
    

The new purchase order will be visible in the Search/Process screen where you can post, edit or delete it.