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

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, ... / Total Quantities
Finance | Project Operations, Human Resources, ...
Suggested Answer

Total Quantities

(0) ShareShare
ReportReport
Posted on by ElleK 10

Is there a report or window that will show total qty received, total qty sold and total qty returned since inception?  We are looking at sales info on the life of an item and don't see that this is available.

thank you!

Elle

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

    I am not sure if there is a report that can provide that level of detail since you are really looking for Purchasing and Sales detail - two different functions in the system.

    However, if you are able to work in SQL Management Studio, then I would suggest that you start with Victoria Yudin's report on Inventory Details - victoriayudin.com/.../ - but you will have make modifications to include the Purchasing Details.  As I figured it so far the report looks at the sales of an item - but does not include the purchase details.

    Victoria uses the

    SOP30200 – Historical Transactions (header)  – one record per posted sales transaction

    SOP30300 – Historical Transactions (line detail)  – one record per line item on posted sales transactions (for kits, there will be one record per kit component)

    You might need to add the Purchasing module equivalents -

    POP30300 - Receipts History (Header)

    POP30310 - Receipts Line History (line detail)

    And from the Inventory Module the

    IV10200 - Purchase Receipts (header)

    IV10201 - Purchase Receipts Detail (line detail)

    Not saying you need all that data, but there are likely parts in the various tables that will contain the detail you are looking for.

    This is a starting point - not a solution - but it should get you well down the road.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 692

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 532 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 478

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans