mtl_transactions_interface gives negative balances not allowed error
Dear Expertise,
We are currently in the testing stage of interfacing a third party system to Oracle interface inventory module. In the transaction few entries are been error out, "Negative balances are not allowed".
All transactions are processing when the on hand quantity is available in the system. But when transactions related to on hand updating with prior interfaced entries, system gives the error.
Example : successfully interfaced
Transaction 01
On hand quantity 1000
Subinventory : location 01
Item - Test 01
Transfer subinventory: location 02
transfer quantity : 1000
location 01 (quantity -1000)--> location02 (quantity 1000)
Example 02 : Unsuccessfully interfaced
Subinventory : location 02
item : Test 01
transfer subinventory : location 03
transfer quantity : 500
location 02 (quantity -500) --> location 03 (quantity +500)