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) / Total Quantity Sold
Microsoft Dynamics GP (Archived)

Total Quantity Sold

(0) ShareShare
ReportReport
Posted on by TCCAnalyst 1,320

Can anyone please tell me where I can find the total quantity sold of an item? I found info in receipts but it goes invoice by invoice. I am looking for a total for the life of the product. Thanks!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    There is no table that stores a total quantity sold for an item.  You'll have to summarize all the transactions to get that number.  Try the IV10201 table.  -Trevor

  • Tim W Profile Picture
    Tim W 2,925 on at

    This is held at both a summary and per site level in the IV00102 table.  Where Record Type = 0 you get a summary, where Record Type = 1 you will get by site (pretty sure, not looking at my system).

    If you open the Item Inquiry window you will see this displayed in the Sold field.  This window reads that value from the IV00102 table.  I believe you can re-build these values through the Inventory Reconcile but I have not ever had to do that.  Available on quite a few Smartlists also though you have to add the field.

  • Community Member Profile Picture
    Community Member on at

    Tim, that one gets reset when the year end close is run.  Jason was asking for a life-to-date field.  Still relevant, though, in case Jason wasn't quantifying the need well.  -Trevor

  • Tim W Profile Picture
    Tim W 2,925 on at

    You are correct, as we just have service items in GP I've actually never closed the module so mine are LTD by luck not by process.

    Thanks for the reply.

  • L Vail Profile Picture
    L Vail 65,271 on at

    HI Tim, et al,

    Visit Victoria Yudin's site, she has a view that will give you inventory quantities sold by item by year. And, of course the Grand total.

    I think you could easily modify this to get what you need. Victoria is awesome, there are so many goodies on her site. Check it out:

    victoriayudin.com/.../sql-view-for-sales-quantities-by-item-by-year-2

    Kind regards,

    Leslie

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