We are implementing rules-based ATP for location substitution with consolidation and are having some issues with the standard functionality. Consider the following scenario...
Rules-based ATP is configured for location substitution with consolidation in plant A.
100 units of material XYZ in plant A
100 units of material XYZ in plant B
We create a sales order for 150 units against plant A. The system creates the following lines on the sales order...
Line 10 - TAPA line for 150 units from plant A (this represents the original order quantity)
Line 12 - TAN line for 100 units from plant A
Line 14 - TAN line for 50 units from plant A (consolidation will create a purchase requisition to move 50 units from B to A)
This causes a problem with our follow-on documents. For example, the resulting delivery, bill of lading, order acknowledgement, order confirmation, invoice, etc will all include lines 12 and 14. But there is no real difference between lines 12 and 14; they were created only because of the location substitution.
We would rather have the system create a single TAN line with multiple schedule lines to represent the different delivery dates. Has anyone had any experience with location substitution and consolidation? Does anyone know how to accomplish this?
Thanks in advance for your thoughts.