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

• 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 ...

• Can the 'Design Your Own Picking Ticket' Feature Print in Pick Sequence?

  Q - I use the Design Your Own (DYO) Picking Ticket feature because I need the pick ticket format to be different from the standard pick ticket layout. When I print the DYO Pick Ticket, it always prints by the line item sequence order instead of the ...

• CP0200 Customer Order Processing Print Pick/Pack Tickets and Ship Labels

  Print Pick/Pack Tickets & Ship Labels Application Overview Picking Tickets are documents that list all the items in the order that are eligible to be taken from stock (picked) and shipped from a particular warehouse. These items are listed in order ...

• Clarify Laser Forms Line Item Level Barcode Printing

  Q - What options should be used to print barcodes on line items on a laser form? I can easily print a barcode at the top or bottom of the page, but line item barcode options have confused me. A - Let's explain this by using a pick ticket, which has a ...

• ARCUSMNT Accounts Receivable Customer File Maintenance

  Customer File Maintenance Application Overview The Customer File is a very important file. It stores the basic information about every customer you do business with. Almost every major application in the A/R package uses the Customer file to ensure ...