Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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
  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: Reporting Options, Inventory Current vs. Historical Information

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

  • SunGirl Profile Picture
    SunGirl 5 on at
    RE: Reporting Options, Inventory Current vs. Historical Information

    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.

  • Suggested answer
    Dean Marty Profile Picture
    Dean Marty on at
    RE: Reporting Options, Inventory Current vs. Historical Information

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans