Inventory: Adjust Inventory Quantity of Raw Materials or Supplies (Read Time: 3 Minutes) – FIVE x 5 Support

Background: When users with batch costing enabled receive new Raw Material or Supply inventory, the expectation is that these items are received via a Dx5 Purchase Order. A resource on creating Purchase Orders can be found here: Inventory: Create Supplier Purchase Order (Read Time: 3 mins).

In the case where one-off adjustments need to be made to Raw Materials or Supplies in batch costing enabled systems, Manual Adjustments can be performed. These adjustments to Inventory will effect the Average Unit Cost of the item. Dx5 applies GAAP principles to these adjustments and will decrease an Item's Average Unit Cost in the event of an Addition, and increase an Item's Average Unit Cost in the event of a Depletion.

If a revaluation is needed after a Manual Adjustment, follow the steps at the bottom of this article. Manual Adjustments to Dx5 Inventory should only be performed after a physical inventory, and in response to correcting Dx5's displayed Inventory level.

To Adjust the Quantity of a Raw Material or Supply Item:

Navigate to Inventory > Overview and click the Raw Materials or Supplies tab based on the type of Inventory requiring an adjustment
- Locate the Inventory Item from the list, then click the blue arrows to the right to expand the Quick Actions menu. Select Adjust Quantity:
On the Adjust Quantity Form:
- Enter the Adjustment Date/Time for the transaction.
- Select the Adjustment Type:
  - Addition: use in the event of Found Inventory
  - Depletion: use in the event of Lost Inventory
  - Recalibration: allows a Recalibration of an Item's entire Quantity, versus an Addition or Depletion. This option should not be used by Batch Costing users.
- Enter the Quantity and Container type of the Adjustment.
- Choose a PDF File to upload in the BOL Document Upload field if desired; this field is Optional.
- Also Optional is the Note field; enter any details on this Adjustment that you may wish to keep on file. Typical Notes reference the reason for Adjustment, any details which should be attached to the Adjustment, etc. Notes are great for record-keeping purposes and will display in Dx5.
Once the form is completed, users will see a pop-up box regarding Average Unit Cost changes. No action needs to be taken; this Note is informational only:

To confirm and finalize the Adjustment, click the Perform Adjustment button at the bottom of the form
As needed, adjust the Total Inventory Value of this Raw Material or Supply by following the instructions outlined here: Inventory: Adjust Total Inventory Values for Raw Materials/Supplies

Related articles