Material Transactions issue
We have a peculiar problem with respect to Material Transactions.
We have a Custom subinventory to track In Transit materials.
When we create a Sales order we do a Miscellaneous Receipt programatically and increase the quantities In - Transit . When the destination Org receives the PO we do a Miscellaneous issue programatically to deplete the In-Transit quantities.
While we do a deplete In transit transaction sometimes the transaction is recorded in the MTL_MATERIAL_TRANSACTIONS but the quantities do not get knocked off from the In Transit sub Inventory in the MTL_ONHAND_QUANTITIES.
MTL_TRANSACTIONS_INTERFACE does not have any error records nor does MTL_MATERIAL_TRANSACTIONS_TEMP have any records.