Open Forum

Expand all | Collapse all

SmartList - where can I find the Inventory Items List Prices

  • 1.  SmartList - where can I find the Inventory Items List Prices

    Posted 13 days ago
    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
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: SmartList - where can I find the Inventory Items List Prices

    TOP CONTRIBUTOR
    Posted 12 days ago
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role