Adjust Inventory Values

From Opentaps Wiki
Jump to navigationJump to search

This screen allows you to adjust the value of inventory items owned by the current organization.

To access this screen from the Main Navigation screen proceed as follows:

*  Click: Financials Icon > Ledger Tab > [Adjust Inventory Values] button
*  The screen opens to display two sections.

Find Inventory Items to Adjust

The top half of the screen can be used to look up the inventory items that need value adjustments. The search fields are:

  • Warehouse -- Select from a warehouse where the inventory is held, or leave blank to search across all warehouses.
  • Product -- Enter or Lookup a Product ID that needs inventory value adjustment.
  • Default Cost -- Select whether you want to use Standard Cost or Actual Costs when you enter the New Unit Cost values. This will default to standard costs if your organization has been set up to use Standard Costing.
  • Received Date between ... and -- Enter the date range in which the inventory items to be adjusted were received.
*  Click:[Find] -- to see a table of inventory items that match your search criteria. 

Adjust Inventory Item Values

The table presents the following fields:

  • Warehouse -- Warehouse where this item is held
  • Product -- Internal name and ID of the product
  • Item ID -- Unique ID identifying this particular inventory item. Click on this link to view a history of the inventory value for the item.
  • Received - Date and time when this item was received
  • QOH - Quantity of this item on hand.
  • Unit Cost - Current unit cost of this item.
  • New Unit Cost -- a Field for entering the New Unit Cost adjustment that is needed. A Check Box is for indicating that all items are to be adjusted at once.
  • Check Box -- for selecting the individual line items that will actually be adjusted when you click [Adjust Values] at the bottom of the table.

To adjust inventory values:

*  Change the New Unit Cost from the old value to the desired value.
*  Click: the Check Box next to it.  
*  Click [Adjust Values] button at the bottom of the table.  

The system will update the unit costs of all checked inventory items, record it in the inventory value history, and post ledger entries.

Note: About Missing Historical Inventory Values

If you experience an error after clicking the [Adjust Values] button, it may be because the inventory items are missing historical values. This might happen if you imported inventory data from another source. Click on the Item ID links to verify that this is the case, and if so, inform your system administrator. A script is available in opentaps to fill in missing historical values for inventory items. Using this script requires Technical System Administrator skills.