IN-K  Adjust Physical Levels

Purpose of Program

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

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, it is strongly recommended that you NOT change the cost here for parts that have an on hand quantity but instead 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.

If you are doing a series of items in item number sequence, you will find the use of the F8 key (or the Next button) very helpful.  Pressing F8 (or clicking on the Next button) advances to the next item number without having to key it in each time.