SmartList – where can I find the Inventory Items List Prices

  • SmartList – where can I find the Inventory Items List Prices

    Posted by Clay Tait on February 18, 2021 at 12:10 pm
    • Clay Tait

      Member

      February 18, 2021 at 12:10 PM

      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
      ——————————

    • Chris Donnelly

      Member

      February 19, 2021 at 7:25 AM

      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
      ——————————
      ——————————————-

    Clay Tait replied 5 years, 3 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘SmartList – where can I find the Inventory Items List Prices’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!