Discussions
What is the behavior of Average Cost column on Inventory Valuation Summary Report?
We are using a customized Inventory Valuation Summary report by location for monthly review. I have read through SuiteAnswers documentation and many Q&A threads in this community to find what I think is are simple clarifications data on report. I have not found any guidance, so appreciate if someone in this community can help to clarify. Thanks!
Questions (we use AVG COST)
When a specific location is selected in footer filter and AS OF date for prior month; how is the Inv. Value figure derived? Is it calculated using the Location AVG Cost existing on the AS OF date OR the Item's Total AVG Cost across all Locations on the AS OF date? Assumption is that the On Hand Qty is Qty on AS OF date.