ATP for manufactured and procured materials

[Former Member]

We have a scenario that we have essentially a make-to-order process but occassionally, due to setup costs, manufacture more than what is needed to satisfy the sales order line item that triggered the planned/production order.

In other words, when sales order ATP executes, we would like to first check for unrestricted inventory to supply the order. If there is available inventory, it should be used on the sales order line item.

If there is no inventory on hand, we want MRP to run and create an order using the Make-to-order process.

Can someone help wtih this?

Thank you,

bak

[Former Member]

Hi

This can be acheived by user exit. MV45AFZB - userexit_check_vbep

Here logic would be - maintain one z-table & maintain the material for which you would like to apply this logic.

Check for the ATP stock. If it is Zero, change item category from MTO item cat to MTS item cat..

By changing item category, you can achieve the desired results.

thanks

[Former Member]

Hi Bak,

The only way i have seen this done in the past is to create two materials codes for the sames material one is the stock item and the second is MTO, so when you have stock you can use the stock material code or there is none in stock to use the MTO material code.

The second option is too have one material that is MTO but when the order is placed to check if there is available stock and then to do a Stock to sales order stock material transfer. then when you run the ATP check the stock is available and no production is generated