Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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.
0