User Tools

Site Tools


2.3.17. Interface for PMX Advance Shipping Notice Importer and Exporter

Extension: Advance Shipping Notice Interface - Default

CSV custom header

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)
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
implementation/wms/interfaceasn.txt · Last modified: 2022/07/20 20:14 by vise