Adjustment Entry (ICE210)

How to

Use this program to make all necessary manual adjustments to inventory on hand quantities and, without using the purchase orders or sales orders systems, can be used to post receipts and record sales.

An adjustment code indicating the general type of adjustment (e.g., RC-for receipts, DM-for damaged in shipment, etc.) is entered for each transaction. These adjustment codes are user-defined through the Adjustment Code F/M program. A memo may be entered for further clarification of the transaction. Adjustment types (A-adjustment, R-receipt or S-sale) are also set up to indicate where to post adjustments in general ledger. (See Adjustment Code F/M program.)

Updating the on-hand quantity based upon the adjustment amount occurs immediately as the transaction is recorded. If the adjustment type is an R-receipt, the unit cost is also entered and the current cost updated according to the costing flag is the IC static control record. If the adjustment type is an S-sale, the sales dollars (dollar amount of sales) are also entered. If the adjustment type is an A-adjustment, the cost is also entered. The Adjustment Register should be run periodically to give a hard copy of all adjustment and repackaging transactions and update general ledger.

You have the ability to cost serial and lot items by the system cost (costing method for the module). The feature provides for GAAP compliance. For the FACTS SO, IC and MC modules, you can decide if the cost for serial and lot items will be averaged actual (as it has always operated in the past) or system cost (costing method for the module). The default setting for each Static Control F/M is A-Averaged Actual (same behavior as they have before the monthly is applied). Users who want to take advantage of this change will need to change the option to S-System Cost for each of the applicable modules. The net result of selecting S-System Cost is that serial/lot items will be costed like non-serial/lot items. The results of this program are affected by this selection.

Lead Time: If the adjustment type is "R" for receipt and the restocking warehouse is direct from the vendor, the lead-time is set to abnormal only if the item is stocked and the replenishment flag (located on the Main view of Warehouse/Item F/M) is Y. Otherwise, the lead-time flag is blank.

EWMS processing note

If you specify a WMS-controlled warehouse and you are not a WMS administrator, the message: WMS Warehouse – Adjustment must net zero is displayed at the top of the screen. Only WMS administrators can adjust quantities for items in a WMS-controlled warehouse. Non-WMS administrators cannot exit Adjustment Entry (ICE210) for an item that is in a WMS-controlled warehouse if the adjusted quantity does not sum to zero.

When non-net-zero quantity exists and the user is not the WMS administrator, a dialog box is displayed with the first item that is the problem and a login prompt for the WMS Admin user and password to override the net zero requirement. Once the WMS Admin user and password is entered, the non-wms-admin user will not be prompted again (while remaining in ICE210) if any line (for any warehouse) is not net zero.

Note that all quantity adjustments are typically done in Accellos. The only reason this program should be used is to adjust costs, so you can adjust one out at one cost and back in another. The net effect on inventory quantity is zero.

Access this program by clicking Inventory Control>Adjustments>Adjustment Entry.

A scrolling feature displays the most recent transactions recorded at the bottom portion of the screen. This provides additional safeguards against user error due to oversight or transaction duplication.

Click field descriptions for information on each field.

See also

Manually adjusting on-hand quantities