Open Forum

We are on Dyn GP 2018  18.3.1200 (2020) and have used SmartList for years (Since Dyn GP 2015).       1) When doing SmartLists (out of the box) for Inventory Items Reports that we do, we have never been able to "Add" (find) a "Column" that has the List Price, is it in the SmartList somewhere that I am missing it?  If so where? and if not, is there a way that I can access it?              2)  Also, It seems we still have the original SmartList reports that GP 2015 came with even though we keep our Dynamics Updated at every Calendar Year End (we are now on Dyn GP 2018 (2020), has Dynamics GP added more SmartList reports over the years that I can access and then import?  If so, how is that done?

------------------------------
Clay Tait
Tait Distributors
Edmonton AB
------------------------------

Clay,

I think your challenge is with the design that each item can have multiple list prices (one for every currency).  You can see the list price(s) for the item by going to cards > inventory > item > select item > go to > item currency.

We wouldn't want the base smartlist to return a row for every item-currency combination.  You will have to write a custom one to give you the results you're looking for (even if you are only using one currency).

I hope this helps.

Chris

------------------------------
Chris Donnelly
Sr Mgr of Info Systems and Financial Reporting
Healthmark Industries
------------------------------

Original Message:
Sent: Feb 18, 2021 12:10 PM
From: Clay Tait
Subject: SmartList - where can I find the Inventory Items List Prices

We are on Dyn GP 2018  18.3.1200 (2020) and have used SmartList for years (Since Dyn GP 2015).       1) When doing SmartLists (out of the box) for Inventory Items Reports that we do, we have never been able to "Add" (find) a "Column" that has the List Price, is it in the SmartList somewhere that I am missing it?  If so where? and if not, is there a way that I can access it?              2)  Also, It seems we still have the original SmartList reports that GP 2015 came with even though we keep our Dynamics Updated at every Calendar Year End (we are now on Dyn GP 2018 (2020), has Dynamics GP added more SmartList reports over the years that I can access and then import?  If so, how is that done?

------------------------------
Clay Tait
Tait Distributors
Edmonton AB
------------------------------