Physical Inventory Adjustments Stuck in Pending Transactions!
Summary:
Physical Inventory Adjustment transactions stuck in Pending Transactions with error: inv_tm_txns.process_lot_serial-6 procedure. Error: User-Defined Exception. Items are lot controlled but not serial controlled. Lot quantities match transaction quantities. Tried purging but issue persists.
Content (please ensure you mask any confidential information):
We have Physical Inventory Adjustment transactions stuck in Manage Pending Transactions.
Error Message:
You can't process the transaction because an error occurred in the inv_tm_txns.process_lot_serial-6 procedure. Error: User-Defined Exception.
Error Code: INV_MATRX_INT_SQLCODE
Transaction Details:
- Transaction Temp ID: 300002282413242, Item: 03-50-964-07405-51548, Qty: 30, Lot: LOT21501, Subinventory: HOP_OPPH
0