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 / Finance | Project Operations, Human Resources, ... / Reporting Options, Inv...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Reporting Options, Inventory Current vs. Historical Information

(1) ShareShare
ReportReport
Posted on by SunGirl 5

Hello,

I am seeking a way to generate a report or SmartList that includes information already stored in GP. If I go to Inventory > History > [item number], I can see a lot of useful information, ie) historical data for quantity sold, item cost, and what the item sold for:

pastedimage1637011842925v1.png

The only way I can currently see this information is by putting each item number in this section and getting the above box. I need to see this information for all inventory - with historical data - in one report. Is this even possible? It seems like it should since the data is present.

Thanks.

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Dean Marty Profile Picture
    Dean Marty on at

    Good Day

    That information is contained on the Inventory Sales Summary History report.

    { Reports | Inventory | History - Sales Summary }

    You can create any number of report options, either for single item, all items, or a range of items.

    Thanks!

    Dean

  • SunGirl Profile Picture
    SunGirl 5 on at

    Thank you. You have restored my hope!

    I may be somewhat ignorant in this area of GP. When I went to Reports | Inventory I was unable to find History - Sales Summary. Could you break down your instruction more, or point me to another source?

    Those report options sound just like what I am looking for.

  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at

    In GP, navigate to REPORTS >> INVENTORY >> HISTORY, and select the report named "Sales summary".

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans