How You Delete Pending Transactions

You can delete a pending inventory transaction if the transaction is no longer wanted or needed. Once you delete the pending transactions, the quantities return to the inventories that they came from. All associated transactions revert to the setups prior to the creation of the transactions.

You can purge transactions directly from the Manage Pending Transactions page, or you can use the Purge Inventory Transactions Interface scheduled process.

Manage Pending Transactions

Use the Manage Pending Transaction pages to delete pending transactions:

1. On the Manage Pending Transactions page, click the View Pending Transactions button.

2. On the View Pending Transactions page, search for the records that you want to delete. You can search by organization, processing status, transaction date, transaction type, and more.

3. Select each transaction row that you want to delete. You can select up to 500 rows to delete at one time.

4. Click the Delete icon. You can also select Delete from the Actions menu.

This deletes the transactions from the Inventory Transactions Interface table (INV_TRANSACTIONS_INTERFACE).

Note: To delete a pick pending transaction, you must remove the pick transactions using the Confirm Pick Slip pages instead of the Manage Pending Transaction pages. From the Confirm Pick Slip page, search by order number and pick 0 for the pick lines that you want to delete.

Purge Inventory Transactions Interface Scheduled Process

Use the Purge Inventory Transactions Interface scheduled process to delete a large volume of pending or error transactions from the inventory interface tables.

1. Navigate to the Scheduled Processes work area.

2. Click the Schedule New Process button.

3. Search for the Purge Inventory Transactions Interface process.

4. Click OK.

5. Enter the process details including the Load Request ID or Error number.

6. Submit the process