Reference
- Full file template: download file template / See in Google Drive
- Data flow: from ERP to LNB
- Data types: sales document
- File naming: see sales documents in the flat files automation instructions
File requirements
If a row does not meet all these constrains, it will be ignored:
- the document number must be unique, only the first row will be processed
- category must be valid (refer to valid values in file schema)
- type must be valid (refer to valid values in file schema)
- shipper reference must be valid (refer to valid values in file schema)
File processing rules
Sales documents import via CSV files works in "create or update" mode:
- if the document number code is registered in your Le New Black data, it is updated. If not, it is created.
File schema / Main fields (full schema: see in Google Drive)
| Field | Description | Type | Required |
| Document number | The sales document number (identifier) | string | ✓ |
|
Category
|
The category name (from list) | string | ✓ |
| Type | The type name (from list) | string | ✓ |
| Name | A short description | string | |
| Issued on |
The date of document / Date time ISO-8601
|
date | |
| Due on | The payment date for document of invoicing type / Date time ISO-8601 | date | |
| Delivery end on | Delivery window end / Date time ISO-8601 | string | |
| Amount | number | ||
| Currency code | string | ||
| Shipper ref | string | ||
| File URL | string |
Comments
0 comments
Please sign in to leave a comment.