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) / Item History Inquiry s...
Microsoft Dynamics GP (Archived)

Item History Inquiry screen does not reflect true numbers for sales Qty

(0) ShareShare
ReportReport
Posted on by Syrus 4,156

When I go to Item inquiry for Inventory and then do Item History, I see the numbers in Current year/ Last year boxes ( Sales Qty, Sales Cost and Sales amoount) not reflecting true numbers (SUM) from the number from bottom monthly sales numbers and can also be modified .

I am expecting and assuming that top 6 boxes should show me the aggregation/sum of numbers at the bottom; not that anyone can change these numbers amking up own Totals.

Why is that ?

 

 

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at
    Re: Item History Inquiry screen does not reflect true numbers for sales Qty

    Viol-8-r,

    Cilck the Help button when in this window - I think reading Help will assist you in understanding the data displayed in the window.

    Hope this helps,

  • Syrus Profile Picture
    Syrus 4,156 on at
    Re: Item History Inquiry screen does not reflect true numbers for sales Qty

    Dear Frank, Thank for your reply but,

    That is my question. What I am expecting to see is;  that under current year I should see the Total Sales, let's say until today and then I can compare it with previous year.

    Why would I bother to enter the sales # by myself and how? How do I know what I sold and how much,  out of my 6,000 products and what is the benefit of using an ERP if I had to calculate and input manually.

    Last but not least what I see until is 72 item sold where as if see under Month of January  it show me 176 and 86 for Feb where I have never touch the number on top and I don't want to.

    am I looking at wrong place for what I am looking for ?

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at
    Re: Item History Inquiry screen does not reflect true numbers for sales Qty

    You're provided the option to enter historical information in the window in case you're moving from a legacy system to GP so that you can see prior years' data in GP.  I'm not sure why GP doesn't provide a separate Inquiry window that you can't update so you can maintain the integrity of the data.

    Again, I suggest you read the Help files if you haven't had a chance to so you have a very complete understanding of the data displayed in this window and how it's calculated.  It could be you're looking at a different period in the Current window above than what is being displayed in the lower scrolling window.

  • Suggested answer
    Dennis Sisnarine Profile Picture
    Dennis Sisnarine 155 on at
    Re: Item History Inquiry screen does not reflect true numbers for sales Qty

    Viol-8-r-

    The numbers in the History will only show you accurate numbers if you have done an Inventory year end close. If the inventory year end is not close the sales are combined from last year and this year. Also you can chose the view the Sales Report- SOP Document Analysis. This will allow you to see sales by  any Date Range or by Item range.

    Hope this helps

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