Updating Items Already Received

In the Stores Inventory system, the dependency on the sequence of events is important when deciding how to make changes. Unlike the General Ledger system where the client can post DR and CR on any day of the month, SI depends on the sequence of events (for instance, the user cannot issue something until the item has received it). Using the Undo utility on old jobs can cause problems because the transaction is being pulled from the past. This is especially important with AVG pricing since the AVG price is derived from the price of the new receipt and the price at the current time. A general rule to remember is, do not change anything in the past because the price may be affected in the future.

There are three options for changing items that have already been received.

Option 1
If the receipt is recent and no stock has been issued, adjust the cost of the receipt using SIUPTR:

1. Find the product and specific RC transaction that needs to be changed.
2. Enter the new dollar value into the Amount field.
3. Update the cost field (for an RC transaction, these values should be the same).

If some of this lot has already been issued, the value can be changed but the expense charged for the issued stock will not be adjusted. Look at the stock quantity and quantity in stock fields to see if any stock has been issued from a given RC transaction. The quantity in stock field decreases as stock is issued.

Option 2
Take all the stock out of inventory, and enter the correct value. This can be done with an order for the total quantity on hand, then receiving a set to put it back at the correct price.

Option 3
Use the SIUTMP utility to update RC transactions to match the price on the PO. Use caution when running this utility; it is best if used soon after the initial receipt. 

1. Adjust the price on the PO.
2. Run the utility for the specific PR that was just changed.