Order number generation logic in WMS — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Order number generation logic in WMS

edited Aug 24, 2025 6:39PM in Warehouse Management 1 comment

Summary: Duplicate Orders are being created in WMS whenever a requested ship date for a particular line is changed in Order management.


Content (please ensure you mask any confidential information):

we have built a shipment request integration that is creating orders in WMS. For the WMS order number logic, we have used the ERP Source order concatenated with Requested ship date (ex. ORD1001-20250819). This way we are able to group the multiple lines of same shipment date into a single order.

The problem with this integration is whenever requested ship date is updated in ERP, instead of updating the existing order, a new order is being created in WMS. Instead of following the standard approach of create order number as ERP_Order_Nbr - ERP_Order_Line_Nbr - ERP_Fulfillment_Line_Nbr which will create a different order in WMS for each fulfillment line, is there a way to group the fulfillment lines based on shipment date and create a single order in WMS

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!