170
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
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:
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
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 Options
IV00108 -- Item Price List
IV00113 -- Item Price List Details.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (