2.3.17. Interface for PMX Advance Shipping Notice Importer and Exporter
Extension: Advance Shipping Notice Interface - Default
The CSV file
The CSV file is received from a supplier and from the file goods that are received against purchase orders and purchase invoices can be imported to SAP Business One with the Produmex Interfacing Tool.
The CSV file must contain 14 columns with predefined column names that can be present in any order and it can contain two additional optional columns (see table below).
CSV Custom Header
If the supplier sets different column names in the header of the CSV file (for example Object Type instead of ObjType, Document Number instead of DocNum, etc.), the Interfacing Tool is not able to match the columns to the correct fields. In this case the header of the CSV file is overwritten by the CSV Custom Header.
- If the supplier lists the columns in an order different from the default order in the CSV Custom Header field, you can change the order of the columns in the field.
While customizing the order of the columns in the CSV Custom Header field, make sure that you do not change the column names and do not remove any value from the field
- If the supplier lists the columns with different names, you can change the names of the columns in the field wihout changing their order.
| Column name (case sensitive) | Description |
|---|---|
| ObjType | The object type of the document, it is either a purchase order or a purchase invoice. |
| DocNum | The document number of the purchase order/purchase invoice |
| LineNum | The correct line of the item in the purchase order |
| ItemCode | The item code of the product |
| Quantity | The quantity of the item to be received |
| SSCC | The SSCC of the logistic unit |
| MasterSSCC | The SSCC number of the master logistic unit |
| Batch | The batch number of the product |
| Batch2 | The second batch number of the product |
| BBD | The best before date of the product |
| SerialNumber | The serial number of the product |
| UF1 | User information |
| UF2 | User information |
| UF3 | User information |
| BeasItemVersion (optional column) | Item version number in case of Produmex WMS - Beas Manufacturing integration |
| SupplierRefNo (optional column) | Supplier reference number |