Finance | Project Operations, Human Resources, ...

Reporting Options, Inventory Current vs. Historical Information

(1) Share

Report

Posted on by SunGirl

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:

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)

All responses (3)

Answers (0)

Sort by

Suggested answer

Dean Marty Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
SunGirl 5 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Cheryl Waswick Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No