Importing Sales Invoices

Importing sales invoices allow you to import sales invoices from an external CSV file. This can be useful if you have multiple sales invoices 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 is headers.
2. Column 2 is the Issue date.
3. Column 3 is the Customer code.
4. Column 4 is the Billing address.
5. Column 5 is the Shipping address.
6. Columns 6 is the Payment term and should be defined by d = days, w = weeks, m = months
   e.g. 7 D, 4 W, 1 M.
7. Column 7 is the Reference.
8. Columns 8 is the Discount and should be defined as a numerical value for money or as a percentage '%'.
   e.g. 2 for a two-pound discount, or 2% for a 2 percent discount.
9. Column 9 is the Description.
10. Column 10 is the Bank account.
11. Column 11 is for FAO.
12. Column 12 is the Catalogue no.
13. Column 13 is the Item description.
14. Columns 14 is the Quantity.
15. Column 15 is the Price.
16. Column 16 is the Line discount and should be defined as a numerical value for money or as a percentage '%'.
    e.g. 2 for a two-pound discount, or 2% for a 2 percent discount.
17. Column 17 is the VAT code.
18. Columns 18 is the Analysis code.
19. Column 19 is the Budget code.

Please check the structure before importing.

Importing Sales invoices

1. From the Transactions menu choose Sales > 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 to the analysis fields and type the mapping name for future use of this mapping.
   Note:- only map the fields you want to import, you do not have to do them all!
8. Click Save to continue.
   
   
9. The Validation summary will detail if any lines have errors in. The summary report will detail the errors (blue link on page to access this).
10. If you need to change anything click Cancel or click Complete import to proceed.
11. Valid lines will be imported and you will see the completed successfully message as per below: