Feature - Pick Ticket Printing Supports Bin Records in Delimited File Format Exports

Release Date: 4/12/2024

Version: 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

• Related Articles

• Feature - Pick Ticket FFL Address Mismatch Event

  Release Date: 3/5/2018 In the Elliott firearms industry vertical solution, the user can import the FFL master database from the BATF website. The Elliott system can then match the customer, ship-to and order address against this FFL master database. ...

• Feature - Pick Ticket Printing for Not Equal to Customer Type

  Release Date: 10/18/2022 Version: 8.5 & Up In Pick Ticket Printing, the system allows printing of pick tickets to a particular customer type or all customer types. With this new feature, the system now allows printing of pick tickets that are not ...

• Feature - Not Allowing All Customers When Printing Pick Ticket

  Release Date: 4/14/17 Certain users control the printing of pick tickets by customer. Therefore, they enter "All" for order range, and specify the customer number in the customer number range. From time to time, a user can make a mistake and print ...

• Feature - Expanded Laser Picking Ticket

  Release Date: 6/14/23 Version: 8.6 and Above The standard picking ticket is hard coded and does not allow the user to customize the layout. The standard pick ticket prints 5-6 items per page resulting in documents that can be 75-100 pages in some ...

• Common Reasons Why Pick Ticket Does Not Print

  A - When I try to print a pick ticket, I keep on getting the message "Nothing in Range." I know the order number I specified is correct, and I can't find any reason why the pick ticket does not print. Please help. Q - In additional to the more ...