Manual Adjustment of Inventory

The manual method of inventory adjustment should really only  be used when setting up your existing program for the first time.  The menu option is in the IFM menu, "Load Inventory Cost/QTY Data".  After picking the program, (for example: MIKE), the system prompts you to enter an item number.  Once you enter the item number, the cursor moves to the average cost field, you can manually adjust and override the average cost field. Average cost updates the next time you purchase, ship, receive the item.  Pressing the enter key moves the cursor to the Quantity On Hand field.  Pressing the enter key without any other input keeps the current settings. 

Changes to these fields should not be done hastily.  Changing values represents changes to the data files where this information is stored with no audit or record of when it was changed, why, or by who.  It is good practice to print the "fulfillment/inv. stock status report" before making any changes. Furthermore, changes here do not effect the G/L and are not traceable.  It is good practice to do a screen print here after making your changes and file the screen print as a paper trail.  Security access to this menu option should be set at the highest level (like 7, 8, or 9).

Billable Quantity On Hand is quantity yet to be invoiced.  A negative BQOH means there are quantities yet to be vouched (more sales than purchases).  To evaluate if this number is wrong due to improper original entry values, utilize the reports Inventory Purchase Audit Report and Sales Audit Report.  These are two separate reports show the purchases and sales for an item (see the report section for details).