When I run an inventory valuation report, and inspect the on-hand quantity for a location, why don't the numbers match the results from the following SuiteQL query?

select BUILTIN.DF(location) location, sum(quantityonhand) onhand from aggregateitemlocation group by BUILTIN.DF(location)

AI generated answer (using internal Slack threads):

The discrepancy between the "Total Quantity On Hand" in the "Inventory Valuation" report and the total quantity on hand shown on the item page itself could be due to several reasons: 1. Units of Measure: If the units of measure are different in the report and the item page, the quantities may not match. 2. Location-Based Quantities: The quantities could be different based on the location. If the inventory valuation report isn't filtered to any location, it would include all locations, whereas the item page might be showing the quantity for a specific location. 3. Missing Location in Item Fulfillments: If there are item fulfillments missing location, NetSuite doesn’t factor those into the quantity on hand count. 4. Multi-location Inventory: If you have multi-location inventory turned on, the quantities could be different based on the location. As for the SuiteQL query, it's important to note that the query is summing up the quantity on hand for each location. If there are discrepancies in the data (like missing locations in item fulfillments), the results of the query might not match the "Total Quantity On Hand" in the "Inventory Valuation" report. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******