Inventory Valuation Summary quantity on hand difference
planned
C
Cindy de Lange
I have found that there is a difference in inventory quantities if I switch between the Modern and Classic View for Inventory Valuation Summary report.
THE OVERALL INVENTORY COST REMAINS THE SAME, THE QUANTITY ON HAND CHANGES AS WELL AS THE AVERAGE COST PER PRODUCT/SERVICE.
I have worked through the below troubleshoot steps with no resolution.
- Review Adjustments: Go to Vendors > Inventory Activities > Adjust Quantity/Value on Hand to check if any adjustments were made incorrectly or incompletely.
- Verify Dates: Ensure the adjustment date is accurate and within the report's date range.
- Examine Report Filters: Confirm that the Inventory Valuation Summary report filters are set up correctly. Check the date range and other filters that might be excluding certain transactions.
- Balance Sheet: The Balance Sheet also reflects inventory value. Compare the inventory value on the Balance Sheet to the Inventory Valuation Summary to identify any discrepancies.
A
Alexandra Preston
I am having the same issue on my client. The inventory valuation report is showing a quantity for certain sku's with a $0.00 asset value. When you drill down into each sku it then shows the quantity as 0.00.
Subhanan Sahoo
Cindy de Lange Could we have a short connect for 15 mins as per your convenience, such that you could help by sharing your and replicating the issue. I can get my lead engineers on the call to help resolve this at the earliest.
cc: Nipun Bhatia
Subhanan Sahoo
marked this post as
planned
C
Cindy de Lange
Currently experiencing an additional issue now with the Classic Report. The quantity on hand is not taking into account the depletion of stock over some time, this has resulted in year end reporting having to build manual inventory valuation summaries for our clients. Multiple accountants at our firm have encountered this issue, for some it has resolved on its own.
This post was marked as
under review