- 2 Posts
- 15 Views
Preventing Pick by Pallet Line Splits
We pick by pallet and have a custom tag file to consolidate lines prior to ship confirm to prevent line splitting in the F4211. We only allow splitting for different lots or product cuts. This custom file is causing multiple issues. Does anyone have alternative ways to handle line splitting in F4211.
@Leslie Stephenshaw Hi there. We had the same issue and we solved with a custom UBE. Here is an excerpt from our design doc that may help.
Create a custom UBE to consolidate sales order lines with the following criteria
A parent sales order line has a whole number value (i.e. 1.000)
A child sales order line has a fractional value (i.e. 1.001 - 1.999)
A child line (i.e. 1.001 - 1.999) must have a corresponding parent line (i.e. 1.000) whole number
A child line must have the same order number, type and key company of the parent line
A child line must have the same item, branch, location, lot of the parent line
A child line must have the same ship-to, and line type of the parent line
A child line must have the same related order of the parent line (if line type W)
Parent and child lines must have the same commitment status (both soft or both hard)
A child line must have the same shipment number of the parent line
A parent line must NOT have an invoice number assigned
Omit parent or child line that has been Ship Confirmed (i.e. OnHand Flag set on)
Omit certain line types
Billable Freight (F, FT)
When a child line meets the criteria to be consolidated with the parent line
The child sales order line quantities, weight, volume and extended cost/price amounts will be added to the parent sales order line
An audit trail will be written showing the updated values of the parent line (i.e. sales ledger record)
The child sales order line will be canceled
An audit trail will be written showing the cancel of the child line (i.e. sales ledger record)
If the child line is on a different shipment number than the parent line,
The child line shipment quantities, weight, volume and extended cost/price amounts will be added to the parent line shipment information
The child detail line will be deleted/removed from its shipment
If no more sales order lines exist for the child shipment after the line has been deleted/removed, then the child shipment status will be updated to canceled