Bobbi Rakowski

We have a client that needs to be able to have up to 35,000 different delivery addresses on one sales order. They don't get the distribution list up front when the customer places the order. The customer can order something like the below:

Item A - 3,000 ea

Item B - 4000 ea

Item C - 5000 ea

They will use master planning to create the planned production and purchase orders to start producing at the beginning of the month. A week before the items ship, the customer has solidified the distribution list and gives it to them. Since master planning has used the original lines to create the orders, there is a link. We are also using WMS, so the sales order lines will drive the shipments and loads. We need a way to break out the ordered quantities to different delivery addresses without breaking the system functionality. The thousands of sales order lines will also drive sales tax as they ship all over the US.

Current setup:

Using Advanced Warehouse Management with Mobile Device

Using Quality Management

Issue: When we create a Sales Order for a part that we purchase to resell, a planned purchase order is generated. The planned purchase order is firmed to a Purchase Order. When the item is received, a quality order is generated. The user completes the quality check but cannot "Validate" the quality order because the system throws the error of unavailable inventory. This issue is due to the original sales order having the same inventory reserved ("Ordered reserved").

Microsoft said their engineering team triaged the bug and determined it was an issue but could not fix it via hotfix. It is a design limitation and will require a change in the underlying design which they cannot take on at this time.

The only way around this is to manually unreserve the inventory on the Sales Order (which quality doesn't have access to do), Validate the Quality Order and then re-reserve the inventory on the Sales Order. This is very time consuming and has to involve multiple users.