DTS | Adminstrative Action

When a user has incorrectly entered multiple restocks and attempted to resolve the issue themselves.

Ex.

• Transaction 1: incorrect unit cost

• Transaction 2: negative unit cost and negative quantity

Resulting in extreme inaccurate unit cost and quantity

Do research of Inventory Item

Step 1 - Check audit log of Inventory Item

Look for the audit log record that was before the accidental restock entry. Take notes on these fields and what values were there.

Example:

• Unit Cost - $799.0000

• Previous Unit Cost - 0.0000

• Re-stock Unit Cost - 799.0000

• Previous Quantity On-Hand - 0

• RESTOCK_QUANTITY_TRANSLATOR - 475

Identify which records need to be deleted

Step 2 - Document the Cost History line items and the Transactions

Example:

• Remove Cost History:

  • 670

  • 671

• Remove Transactions:

  • 47059

  • 47122

Remove Cost History and Transaction line item records

Step 3 - Go to tables "inventory_transaction" and "inventory_item_unit_costs"

• Delete Unit Cost records

• Delete Transaction records

Correct Inventory Items

Step 4 - Go to "inventory_items" table

Update fields to roll back the Unit Cost and Quantity On-Hand from before the error

• Unit Cost - $799.0000

• Previous Unit Cost - 0.0000

• Re-stock Unit Cost - 799.0000

• Previous Quantity On-Hand - 0

• RESTOCK_QUANTITY_TRANSLATOR - 475

Review Unit Cost and Inventory Item Details that all values are matching

Step 5 - Review Inventory Item Details page to see if values have been reverted

Test Restock form (but don't actually submit)

Step 6 - Click "Restock", and add "1" quanity to see if the Unit Costs remains the same as the reverted Unit Cost