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 now 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

The Adjustment Entry (ICE210) program does not allow exiting an item that is in a Radio Beacon controlled warehouse if the adjusted quantity does not sum to zero. All quantity adjustments should be done in Radio Beacon. 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

How to manually adjust on-hand quantities