Troubleshooting & Best Practices

Re-Stock Item

This allows a user to add a Re-stock Quantity

Re-stock Unit Cost and also calculates the New Unit Cost

Adjustment Transaction

Allows the user to select an Item, Quantity and Location with a field to enter your reason for the adjustment.

This is primarily use for quantity adjustments.

Work Arounds

Use when revising an incorrect unit cost

Incorrectly entered due to

• Financial documentation error

• User error

• minimize future errors

Revising Incorrect Unit Costs

If "inventory item" had an existing quantity before the incorrect transaction

Scenario where we're trying to change a unit cost AND quantity to zero.

• Add restock quantity record

  • Add real unit cost on "Re-Stock Unit Cost" field

• Add restock quantity record

  • Add negative quantity to "Restock Quantity" field

• Results will be that the quantity will be corrected and the revised unit price cost will be corrected

If "inventory item" had a ZERO quantity before the incorrect transaction. This requires DTS Assistance and backend changes to the system!

Scenario where we're trying to remove a unit cost AND quantity to zero.

• Document Previous Unit Cost

• Delete Cost History record

• Delete Transaction record

• Update Inventory Item transaction

  • "Unit Cost" field to previous Unit Cost Amount

  • "Re-stock Unit Cost" field to "0"

  • "PURCHASE ORDER NUMBER_TRANSLATOR" if a Purchase Order was included, remove information in this field

  • "RESTOCK_QUANTITY_TRANSLATOR" field

• Results will be that the quantity will be corrected to ZERO and the revised unit price cost will be corrected to previous unit cost