Hi:
In Dynamics GP 2018 (2021) I am working with Smartlist Designer (the out of the box Smartlist product) and in the inventory, pre packaged smartlist.
I am trying to build a Smartlist that is basically the Stock Status Report (Inventory>Reports>Activity>Stock Status)
In the Smartlist Inventory reports which table can I link to to get the "Inventory Value" Column that is in the Stock Status Report?
Thank You
Clay Tait
Hello Clay,
This field is not pulled from a specific table. It is a calculation.
Please see the kb below on how this field is calculated.
How the inventory value on the Stock Status report is calculated in Microsoft Dynamics GP
I hope this helps!
Thank you!
Brandon Jarrett | Microsoft Support Engineer
Hi Brandon Jarrett
Thank you for the response. I guest as it is a calculated field, it is going to very difficult to balance a Smartlist to the Stock Status report. Oh-Well.
Also one other thing I am having a difficult time finding for Inventory in Smartlist is the the Inventory Items "List Price". Can that be found somewhere in SmartList?
Thanks again
Hey Clay,
You can do calculated fields in Smartlist Designer. You access this by clicking the Sun/Moon icon.
Regarding the List Price, are you referring to the item Price List Maintenance window? If so, the tables you would want to look at are below.
IV00107 --Item Price List OptionsIV00108 -- Item Price List IV00113 -- Item Price List Details.
Brandon Jarrett | Microsoft Support Engineer.
Hi Clay-
You could also replicate the Stock Status report using a SQL view. I posted on my blog about replacing a lot of the built-in GP reports with SQL Server Reporting Services reports.
Have built reports and SQL views for a Stock Status equivalent in SmartList. Here's the link to the post:
josephmarkovich.com/.../
They are pretty customized, so some tweaks will be necessary or I can rewrite it for you.
Also, here the Microsoft support article on how to use a SQL view with SmartList Designer:
docs.microsoft.com/.../how-to-create-smartlist-designer-report-using-sql-view
I hope this helps you out.
Joe
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 696 Super User 2025 Season 2
CA Neeraj Kumar 569
Martin Dráb 551 Most Valuable Professional
