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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Quantity sold in vario...
Microsoft Dynamics GP (Archived)

Quantity sold in various sales and inventory reports

(0) ShareShare
ReportReport
Posted on by Community Member

I'm looking at a couple of different inventory items and seeing some strange things happening with the inquiry windows, smartlists and reports in various modules. Anyone have any ideas?

The quantity on hand and quantity available buckets match between the Item Stock Inquiry and Item Inquiry, however the quantity sold does not. When I look at the reports that I've built in the sales module (which all tie to the data in the SOP30300/30200 tables) I see that the quantity sold ties to what is in the Item Stock Inquiry screen. Additionally, the Inventory Transactions SmartList ties to the Item Inquiry screen (showing the wrong quantity sold). I've looked at the data in the IV30300 table, and it ties to the data in the sales tables.



*This post is locked for comments

I have the same question (0)
  • Rosemary Profile Picture
    Rosemary 10 on at
    RE: Quantity sold in various sales and inventory reports

    Hi,

    Do you have drop ship items?

  • Community Member Profile Picture
    Community Member on at
    RE: Quantity sold in various sales and inventory reports

    I found that the quantity sold column in the Item Quantities Master (IV00102) table is out of sync with the data in the SOP30300 table. I've tried dropping and recreating the table, and everything is still the same. I think I've run every utility in GP, LOL.

  • Community Member Profile Picture
    Community Member on at
    RE: Quantity sold in various sales and inventory reports

    Hey Rosemary, I've got examples of both items that do add up and ones that don't. I've also ran check links against entire inventory module, sales module and purchasing module as well as ran inventory reconcile, sales reconcile and remove and purchasing reconcile. Also, this issue is present in two company databases.

  • Rosemary Profile Picture
    Rosemary 10 on at
    RE: Quantity sold in various sales and inventory reports

    Hi,

    Have you looked at any one item number where the quantities do not add up? as opposed to one that is.

    If you are confident that the Item inquiry and item quantities are incorrect have you done an Inventory Reconcile?

    Regards,

    Rosemary

  • Community Member Profile Picture
    Community Member on at
    RE: Quantity sold in various sales and inventory reports

    Yes, there are voids in the sales module, however they're filtered out on the sales reports and don't make it into the inventory module. It seems to me that the item inquiry and item quantities smartlist are both incorrect.

  • Gene Levasseur Profile Picture
    Gene Levasseur on at
    RE: Quantity sold in various sales and inventory reports

    Do you ever VOID sales transactions?  If so, are you filtering those quantities out of the calculation?

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans