Import Setup For Pastel

You can import a CSV (comma-seperated-value) for customer(s) invoices.

You can import a CSV (comma-seperated-value) for supplier(s) invoices.

There are two types of records:

·               Headers

·               Details.

 

The header appears first. The header tells Pastel that this is a new document and that the line below this will be the details relating to the header.

Next the header is followed by the detail(s) for that invoice.

Header Record Format

Header records are imported with the following layout:

 

Ref. / Field Type / Format

1. Header / Character / The word “Header”
2. Document Number / Character / 8 characters maximum, ignored when importing
3. Deleted / Character / Y=Deleted,  <space>=not deleted, ignored when importing
4. Print Status / Character / Y=Printed, <space>=not printed
5. Customer Code / Character / 6 characters maximum
6. Period Number / Numeric / 2 characters maximum
7. Date / Character / DD-MM-YYYY
8. Order Number / Character / 15 characters maximum
9. Inc-Exc / Character / Y=Inclusive, N=Exclusive
10. Discount / Numeric / 4 characters maximum
11. Invoice Message 1-3 / Character / 3 separate fields of 30 characters maximum each
12. Delivery Address 1-5 / Character / 5 separate fields of 30 characters maximum each
13. Sales Analysis Code / Character / 5 characters maximum
14. Settlement Terms Code / Numeric / 00-32
15. Cost Code / Character / 5 characters maximum
16. Closing Date-Payment Due / Character / DD-MM-YYYY, quotes=expiry date, orders=delivery date, invoices=payment due date
17. Telephone / Character / 16 characters maximum
18. Fax Number / Character / 16 characters maximum
19. Contact Person / Character / 16 characters maximum
20. Exchange rate / Numeric / 1 in foreign currency, 16 characters maximum (rounding to 4 digits)
21. Additional Costs / Character / Y=Additional, N=Normal. Note This only applies to supplier invoices

Detail Record Format

Detail records are imported with the following layout:

Ref. / Field Type / Format

1. Detail / Character / The word “Detail”
2. Cost Price / Numeric / Unit cost price
3. Quantity / Numeric / Number of items
4. Unit Selling Price / Numeric / Exclusive selling price per unit
5. Inclusive Price / Numeric / Inclusive selling price per unit
6. Unit / Character / 4 characters maximum
7. Tax Type / Character / 00-30
8. Discount Type / Character / 0=None, 1=Settlement, 2=Invoice, 3=Both
9. Discount Percentage / Character / 4 characters, omit decimals, e.g. 12.5% = 1250
10. Code / Character / 15 characters maximum, inventory or GL
11. Description / Character / 40 characters maximum
12. Line Type / Character / 4=Inventory, 6=GL, 7=Remarks