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.

    Screenshot 2024-08-13 at 11.13.56.png

  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.

    Screenshot 2024-08-13 at 11.15.15.png

  7. Map the headers in your CSV document.
  8. Click Save to continue.

    Screenshot 2024-08-13 at 11.22.12.png
  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:

    Screenshot 2024-08-20 at 09.27.39.png

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

Was this article helpful?
0 out of 0 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.