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
- Header / Character / The word “Header”
- Document Number / Character / 8 characters maximum, ignored when importing
- Deleted / Character / Y=Deleted, <space>=not deleted, ignored when importing
- Print Status / Character / Y=Printed, <space>=not printed
- Customer Code / Character / 6 characters maximum
- Period Number / Numeric / 2 characters maximum
- Date / Character / DD-MM-YYYY
- Order Number / Character / 15 characters maximum
- Inc-Exc / Character / Y=Inclusive, N=Exclusive
- Discount / Numeric / 4 characters maximum
- Invoice Message 1-3 / Character / 3 separate fields of 30 characters maximum each
- Delivery Address 1-5 / Character / 5 separate fields of 30 characters maximum each
- Sales Analysis Code / Character / 5 characters maximum
- Settlement Terms Code / Numeric / 00-32
- Cost Code / Character / 5 characters maximum
- Closing Date-Payment Due / Character / DD-MM-YYYY, quotes=expiry date, orders=delivery date, invoices=payment due date
- Telephone / Character / 16 characters maximum
- Fax Number / Character / 16 characters maximum
- Contact Person / Character / 16 characters maximum
- Exchange rate / Numeric / 1 in foreign currency, 16 characters maximum (rounding to 4 digits)
- 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
- Detail / Character / The word “Detail”
- Cost Price / Numeric / Unit cost price
- Quantity / Numeric / Number of items
- Unit Selling Price / Numeric / Exclusive selling price per unit
- Inclusive Price / Numeric / Inclusive selling price per unit
- Unit / Character / 4 characters maximum
- Tax Type / Character / 00-30
- Discount Type / Character / 0=None, 1=Settlement, 2=Invoice, 3=Both
- Discount Percentage / Character / 4 characters, omit decimals, e.g. 12.5% = 1250
- Code / Character / 15 characters maximum, inventory or GL
- Description / Character / 40 characters maximum
- Line Type / Character / 4=Inventory, 6=GL, 7=Remarks