web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Microsoft Dynamics GP ...
Microsoft Dynamics GP (Archived)

Microsoft Dynamics GP Inventory Report

(0) ShareShare
ReportReport
Posted on by Kenny Libby 35

I have been trying to create a simple report using Smart Reports to generate an item list that shows Item Number, Item Description, Current Cost and Price.  I have been able to create the report with everything but the price and have reviewed many different ways to try and come up with this information.

Does anyone have any experience with creating this type of report and would you be willing to share with me?

 

Thanks,

Kenny 

*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    To do that in SmartList you need the SmartList Builder module.  Most of the information you need is in the Item Master table (IV00101) but the price is actually in IV00106 and this table is not part of the Inventory Smartlists delivered with the default collection.  If you have SLB, you can easily link the tables and pull the data together.

     

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at

     Hello Kenny,

     Sorry in advance if the translation if it's somewhat of blur( my application is in Spanish) but we had this same problem at the office and did the following procedure.

    Go to:

    Reports>inventory>item (article)

    in the reports column choose list of item price then press new in options write the name or small detail of the report (example: multiquip) then in the intervals choose article number, then pick the range of the item numbers if you want to pick them all just go right ahead ( i picked 002-001 to 002-235, because i want the information of only the multiquip items we have) then press insert, then press destination and select screen or if you later want to also open it in excel then also put a check mark on file, then click on the folder and choose the destination where you want to save it, save as type: file delimited by commas in file format: be sure it says delimited by commas and then select replace and ok then save it and then print it.

     But if the way the information on this report is displayed you don't like it you have got 2 options:

    1.- modify the report ( not recommended if newbee to Dynamics GP)

    2.- Use smartlist to custom make your report. ( don't know how to include price in the smartlist columns only current cost)

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    If you're looking to build your own report, you may find this SQL code useful: http://victoriayudin.com/2009/06/18/sql-view-for-inventory-quantities-on-hand/.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans