Inventory: Adjust Total Inventory Value for Finished Products (Read Time: 2 mins)

In Dx5 systems with Batch Costing turned on, a Total Inventory Value can be manually assigned to Finished Products with existing inventory. If the Finished Product has no existing inventory, the value will be generated after the first Bottling run performed in Dx5. Finished Product costs are calculated using the values of the Bulk Spirit and Supplies used in Bottling, so it is critical to make sure that those costs are correct to calculate an accurate Average Unit Cost when performing Bottling runs in Dx5.

If a Finished Product's Total Inventory Value or Average Unit Cost becomes inaccurate, the Total Inventory Value can be adjusted by following the steps below:

• Navigate to Inventory > Overview
• Locate the Finished Product in need of adjustment, and click the Gold Product Size to enter the product's Item Overview page
• From the Item Overview page, navigate to Item Actions > Edit Size
  • This action can also be found on the Inventory > Overview page via the blue arrows to the far right of the Finished Product - see screenshot:
    
• Click the "Adjust Total Inventory Value" box under the "Wholesale Unit Price" field
  
• Enter the new Total Inventory Value for the Finished Product inventory you have on-hand.
• Save the new Total Inventory Value; Dx5 will calculate and display the new Average Unit Cost based on this Total Inventory Value.