IN-K  Adjust Physical Levels

Purpose of Program

Use this program to enter beginning stock balances and average costs, or to overlay existing counts with new physical counts.

General Program Operation

Type in the item number or select one from a pop-up window by pressing the F2 key (or clicking on the Lookup button).

The current units on hand and average cost will be displayed in the header area of the screen.

The cursor stops at the New Last Cost per Unit field.  You may enter a new Last Cost, if applicable.  You can also change your Average Cost in the New Avg Cost per Unit field.  If your costing default in SD-H, Inventory Defaults, is set for either FIFO or LIFO costing, you will not be allowed to change the Last Cost or the Average Cost.  Instead, you should go to IN-L-H  Edit FIFO/LIFO Buckets and change the bucketed costs in that program.  If your costing method is Standard or Average, you can only change the Average cost here for parts that have no on hand quantity.  To correct an invalid cost of an item that has an on hand quantity, use IN-C  Enter Inventory Adjustments and adjust the stock back to 0 on hand at the current incorrect cost and then make a positive adjustment to put it back in at the correct cost.  This will provide an audit trail of what was done and maintain the integrity of the item Book Value.

Next, current inventory status is displayed in the main section of the screen for each Location.

Before changing the quantity, the cursor stops at the Reference field, where you can enter a short note that indicates the reason for the adjustment.  You may enter a new quantity in the New Units column.  After entering the new quantity, the system will indicate how much the General Ledger asset account for this item will go up or down in dollars.

You may accept the entry or you can indicate no and exit the screen.