Inventory Adjustment

Inventory Adjustment

Inventory adjustments are required to:

  • Correct inventory quantities, if the quantity in the Inventory Manager is different than the quantity on hand determine by a physical count. This type of difference can occur due to data entry mistakes when purchasing or selling inventory items or due to shrinkage.
  • Correct inventory cost price, if the cost price in the Inventory Manager is different than the current cost price. This type of difference can occur due to data entry errors or due to a change in the market price for an item.  The procedures for inventory cost adjustments are covered in the Post for 'Manage Inventory items'.

Inventory adjustments have accounting implications. By using the Inventory Adjustment module, you will be able to adjust either the inventory quantity or the inventory cost price and the appropriate G/L entries will be made automatically.

Content

Interface

To launch the Inventory Adjustment application, click on Inventory Adjustment in the Payable & Inventory group.

Tool Bar

The Tool Bar, outlined in red above contains buttons for:

  • Category Expand All
  • Category Collapse All
  • Adjust Quantity
  • Import Change List
  • Edit Adjustment
  • Delete Adjustment
  • Commit Adjustments

Category Type Filter

The Category Type Filter, outlined in light blue, will filter the view of the Inventory Manager, outlined in orange below it, to display only the category types selected.

Inventory Count Date/Time

Inventory Count Date/Time, outlined in green, is the date and time of the inventory account.

Inventory Manager

The Inventory Manager, outlined in orange is a tree view which displays the categories and items to be selected for adjustment.

Inventory item List

The Inventory item List, outlined in purple is a list of the items available for adjustment which are in the category which has been selected in the Inventory Manager.

Adjustment List

The Adjustment List, outlined in dark blue, lists all of the items which have been provisionally selected for adjustment

Search

The search box, outlined in brown, will quickly find all items, based on the item description you enter.

Back to Top

Manage Adjustments

Bulk Adjustments

The recommended way to process inventory adjustments, is to upload a csv file with the desired inventory adjustments.  The file requires at a minimum, 2 columns, which are the ItemID or SKU of the item and the count.

Step 1: Upload Adjustment File

To upload the file for adjustment, click on the  the Tool Bar.

  1. Select the file which contains the inventory count
  2. Complete the First Row Contains field
  3. Map the item ID column and the New Quantity Column.
  4. Lastly, click on Load 

Step 2: Set the Inventory Count Date/Time

Recommendation: Set the time of the adjustment to a time prior to 11:59 PM.  This will allow subsequent adjustments (in order to remedy errors or recounts) on the same time at a time later that the prior adjustment.

Note:  Do not do multiple adjustments for the same Inventory Count Date/Time, unless the subsequent adjustments are for a different group of items

Step 3: Review Adjustment List

Review the Adjustment List in the lower panel, outlined in dark blue above.  Any problem lines will be highlighted in red. You can edit or delete a line item by right clicking on the line or by clicking on the line and selecting the edit or delete buttons from the Tool Bar.

Step 4:  Commit Adjustments

Click on the the Commit Adjustments button on the Tool Bar to finalize the adjustments.

Back to Top

Individual Adjustments

You can adjust the quantity on hand for one or more items, directly from the application by following the steps below:

Step 1: Find and Select the Item

You can find and select an item in one of two ways.

  1. Using the Search Box, type the description of the item.  The Inventory Item List, outlined in purple above, will populate, based on the criteria in the Search Box
  2. Using the Inventory Manager tree view, outlined in orange above, navigate to the category which contains the item you wish to adjust and then clicking on the category.  The Inventory Item List will populate with all of the items in the category.

Step 2:  Add Item to Adjustment List

To add an item to the Adjustment List, click on the item in the Inventory Item List and then click on the Adjust Quantity button on the Tool Bar or right click on the line and select Adjust Quantity

Enter the value for the New Quantity and then click Add.

Repeat steps 1 and 2 as required.

Step 3: Review Adjustment List

Review the Adjustment List in the lower panel, outlined in dark blue above.  Any problem lines will be highlighted in red. You can edit or delete a line item by right clicking on the line or by clicking on the line and selecting the edit or delete buttons from the Tool Bar.

Step 4:  Commit Adjustments

Click on the the Commit Adjustments button on the Tool Bar to finalize the adjustments.

Back to Top


Adjustment History
 

You may view the adjustment history for a selected item by right clicking on it in the Inventory Item List or the Adjustment List.

The following window will appear:

Back to Top