Release Date: 4/12/2024Version: 8.5 and Up
Background
This feature is a continuous running update to the 3rd Party Logistic Warehouse Management System. For more details on the main article, click here.
Pick ticket printing is a critical feature in Elliott for warehouse management. As a byproduct of pick ticket printing, a user can set up Elliott such that it exports pick tickets in the form of a delimited file to a user-specified folder. This feature was developed for those using third-party WMS (Warehouse Management System) or 3PL (third party logistic) services who would like to automate their pick ticketing process by sending a delimited file to their WMS or 3PL systems. The following image is a delimited file in raw text format.
This raw format is difficult to read, so we converted the above delimited file into a spreadsheet so it is visually convenient to explain.
Column 1 features various record types, such as (but not limited to) PH and PD, representing Pick Header and Pick Detail. This column indicates whether the row contains details about the order header or the order line items, respectively. For more details on the PH and PD columns,
refer to the main article on 3PL WMS. This article is about a new record type that is being added to the delimited file, called PB: Pick Bin.
Feature
When exporting a pick ticket to delimited file format, Elliott now supports a new record type: PB, or Pick Bin. This record type contains information about an order line item's bin location. Note that each PB record prints directly underneath a PD record. The PB records are associated with the PD line item above it. When this feature is active and you print a pick ticket, a delimited file will be exported with PB records. The below image assumes the user is using multi-bin, which is why there are multiple PB records.
If you are not using multi-bin, the following output will occur instead. Because the user is not using multi-bin, there is only one PB record associated for every one PD record.
PB records support up to 9 columns of information, detailed below.
|
Index
|
Field
|
Example Data
|
Constraints
|
Description
|
|
1
|
Record Type
|
PB
|
2 characters
max
|
Constant Value
“PB”
|
|
2
|
Warehouse
Location
|
BR
|
2 characters
max
|
Elliott
Warehouse/Location Code
|
|
3
|
Product Code
|
RU1022RB
|
15 characters
max
|
Elliott Item
Number
|
|
4
|
Bin Number
|
A01-01-1
|
8 characters
max
|
Bin Number
|
|
5
|
Quantity On
Hand
|
1
|
8 (no
decimals)
|
Bin Quantity
On Hand from Bin Inventory Field 6
|
|
6
|
Quantity
Allocated
|
1
|
8 (no
decimals)
|
Bin Quantity
Allocated from Bin Inventory Field 7 (can be zero) (Combined both Qty
Allocated & Temp Qty Allocated)
|
|
7
|
Stock Bin
|
Y
|
1 character
|
Y or N
depending on Bin Master field 3. Default “Y”
|
|
8
|
Priority
|
20010101
|
8 (no
decimals)
|
YYYYMMDD
value determined by Bin Inventory (IMBININV).
(if not multi-bin, default to blank)
|
|
9
|
Job Number
|
STOCK
|
6 characters
max
|
Usually
“STOCK.” Determined by Bin Inventory
field 4 (if not multi-bin, default to blank)
|
Setup
To turn on this feature, go to System Utilities > Utility > Global Setup > add-Ons > 3rd Party WMS Interface. Access Field 10 and set "Interface Bin Record (PB) with Pick Ticket?" to "Y." Naturally, this assumes that the user has enabled Field 1, "Enable 3rd Party WMS Interface?".
Multi-bin is supported with this feature. If multi-bin is already enabled in your version of Elliott, you can skip this step. To turn on multi-bin, go to System Utilities > Utility > Global Setup > add-Ons > Multi-bin control and enable Field 1, "Use Multi-Bin Control ?". That said, setting up multi-bin is slightly more intensive than just enabling this flag. If your warehouse doesn't support multi-bin already and you would like to transition to it, please contact Netcellent for support.
Programs Modified: CP02P1, NSCTLINI, NSCTL3PL, NSCTLFIL.W37
AWK
