Presales Import
1. Receipt File Name: CSV file name to be imported. Defaults to SH*.CSV. Press F1 to change import directory. Press F2 to reset the import directory to the default path defined in Presales Interface Global Setup. Press F7 to search for *.CSV files in the import directory.
2. Vessel Comment - Enter default vessel comment or default the information from the import file.
3. Receiver - Enter the receiver/vendor number or default the information from the import file.
4. Inv/Doc# - Enter the invoice/document number or default the information from the import file.
5. Arrival Date - Enter the estimated arrival date or default the information from the import file.
6. Include Header - Enter Y if the CSV file has a header row.
The import supports the following fields:
(Column A): Vessel ID (Leave it Blank)
(Column B): Vessel Comment (Vendor# + ShippedDate + Tracking#) build if not provided
(Column C): Vessel Receiver/Vendor (Receiver/Vendor#)
(Column D): Vessel Inv/Doc No. (Inv/Doc No.)
(Column E): Vessel Shipped Date (Optional)
(Column F): Vessel Arrival Date (Optional)
(Column G): Trx PO Number (Required)
(Column H): Trx Line Number Optional
(Column I): Trx Item Number (Required)
(Column J): Trx Quantity (Required)
(Column K): Trx Unit Cost Optional - ignore
(Column L): Trx Comment Optional - ignore
(Column M): Trx Receiver Optional - ignore
(Column N): Trx Inv/Doc No Optional - ignore
(Column O): Item Description Optional - ignore
(Column P): Close PO Line Item Optional - ignore
(Column Q): Serial Number (Required for Serialized Items)
(Column R): Box ID (UCC-128 Barcode)
Note the length for some of the fields are different between warehouse receiving CSV import:
Column | WH Receiving Import | Max Length | Presales Import | Max Length |
C | Vessel Receiver | 3 | Vessel Vendor | 6 |
D | Vessel Invoice/Doc No | 8 | Vessel BOL# |
|
R | Box ID | 8 | UCC-128 | 30 |
Invalid PO Number
Order Header Not On File
Blanket Order
Order Has Been Cancelled
Order Has Been Closed
Order Not Printed Yet
Vendor XXXXXX Does Not Support ASN
No Corresponding Presales Transfer Loc Defined
Inv/Doc Number Is Blank
Serial Lot Exceeds Maximum Length of 15
Serial or Lot Must be Entered for Serialized Item
Quantity Must be 1 for Serialized Item
Serial Lot XXXXXXXXXXXXXXX Already Exists in IMLSTRXS
Serial Lot XXXXXXXXXXXXXXX Already Exists in POPTXSER (Already Interfaced)
Item Number Cannot Be Blank
Invalid Item Number (UPC, GTIN, Mfg Item)
Item Number Not On File
Order Line Item Number Mismatch
Order Line Cancelled
Order Line Not Printed
Order Line Closed
Order Line Cancel Pending
Order Line Item Not Found
Quantity Required
An event is available if any error is encountered during the import process.
Program: POPTXIMP
Type: PSIMPERR
File: IMITMFIL
Description: Presales Import Error
Var 1: Item Number
Var 2: Item Description 1
Var 3: Item Description 2
Var 4: Import File
Var 5: Presales Qty
Var 6: Location
Var 7: Vendor No
Var 8: PO No
Var 9: Serial Number
Var 10: Error Message