This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all
Is it possible to make a formula in a saved search to get beginning inventory quantity on hand and beginning inventory average cost for inventory item per location?

if it is possible in a saved search formula, I'm confident in saying it won't be very beginner friendly, sorry.
You'd probably need to do a summary search with SQL analytic functions (using <https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/comment-page-1/&amp;cd=3&amp;hl=en&amp;ct=clnk&amp;gl=nz#:~:text=By%20placing%20a%20SQL%20comment%20in%20the%20formula%20field%2C%20NetSuite%20does%20not%20assume%20you%20are%20doing%20an%20aggregate%20and%20passes%20the%20string%20to%20the%20underlying%20Oracle%20database%20to%20do%20the%20work%20we%20need.|the SQL comment trick>[<https://webcache.googleusercontent.com/search?q=cache:6fYbdM6K9LYJ:https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/comment-page-1/&amp;cd=3&amp;hl=en&amp;ct=clnk&amp;gl=nz#:~:text=By%20placing%20a%20SQL%20comment%20in%20the%20formula%20field%2C%20NetSuite%20does%20not%20assume%20you%20are%20doing%20an%20aggregate%20and%20passes%20the%20string%20to%20the%20underlying%20Oracle%20database%20to%20do%20the%20work%20we%20need.|cached>]). Read <https://blog.prolecto.com/2022/05/07/understand-netsuites-intraday-inventory-ledger-costing-impacts/|this>[<https://webcache.googleusercontent.com/search?q=cache:KCu2pAERbh4J:https://blog.prolecto.com/2022/05/07/understand-netsuites-intraday-inventory-ledger-costing-impacts/&amp;cd=9&amp;hl=en&amp;ct=clnk&amp;gl=nz|cached>] and "related articles"

_* the prolecto blog (wordpress) is down at time of writing, I have included google-cached pages for your reference_

if it's not a hard requirement to do it in a saved search, the regular <https://system.netsuite.com/app/reporting/reportrunner.nl?cr=-298|stock ledger report> does this already, and I'd encourage you to use that.
And I'm sure one of the brainiacs in <#C01FBBZ8PQC|> are capable of writing a SQL query to do it (but again, not the easiest to pull off)