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

Leave a Reply

Your email address will not be published. Required fields are marked *