Scenario
User noticed that there is a COGS Adjustment entry for the Assembly Build record.
Solution
The COGS Adjustment on may be correct, as prior to the creation of the record based on the quantity available for the affected item. Hence, when the assembly was built, it is only correct to zero-out both the quantity available as well as the cost associated to the quantity, to arrive at 0 qty available and 0 cost.
To confirm the above findings, run an Inventory Valuation report for the specific item and I filtered it to the affected location. Below are the steps I followed:
- Reports > Inventory/Item > Inventory Valuation > Customize Detail
- Enter report name as preferred
- Under the Edit Columns tab > click on the Qty column > scroll down and locate Add Running Balance Column checkbox > check this box
- Under the Filters tab > Expand the Inventory Item field on the left side of the screen > find Name field and click on it > add item name on the field below Equal to
- Save the report. This report is now filtered to one item
- On the report footers > click on More > this will reveal the Location filter > filter the location by selecting the affected location on the dropdown
- On the report footers > change the custom period > Your Desired Period
- Click Refresh
With this, you can verify the quantity balance for the item. Accordingly, when the assembly build was created, it is only correct that the quantity and cost will now zero out, since effectively, these quantities and costs had already been transferred to other locations through inventory transfers. The ending balance of the item is correct with 0 quantity and 0 cost.
-----
If you find this information useful, let us know by reacting or commenting on this post!
