Order number generation logic in WMS
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