Sale Order wise On hand quantity tracking in Oracle Inventory
My client requires its finished stock to be maintained according to customer sale order. They want to view report at each period to view their closing stock along with with sale orders. I tried to use the reservation feature of oracle inventory but im not able to fulfill client requirments due to few reasons.
1. There is no transaction date in reservations table nor there is any link with mtl_material_transactions mmt table.
2. Reservations data gets deleted after dispatch.
Can somebody help me with this scenario.
Regards.
AFF