Skip to main content
Microsoft Dynamics GP forum
Answered

Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

editSubscribe (0) ShareShare
ReportReport
Posted on by 75

I have a client who uses the historical stock status report, and after the 2019 year-end update to GP version 18.2.1036, the report doesn't total correctly.  Here are some screenshots:  

Here's what the report used to look like on their version 18.00.0704 (they have a test environment and we were able to test it:

18.00.0704-Old.png

Here's what it looks like now:  Every item is subtotaling.

18.2.1036-New.png

I believe this is a bug - I know most clients don't use this report, but this one client does.  I have confirmed the report settings are the same between the two environments, and neither is using a custom report format.

Categories:
  • Verified answer
    jland555 Profile Picture
    jland555 75 on at
    RE: Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

    Hey there - 

    First, thank you for all of the time you spent corresponding with me on this issue.  I wanted to follow up because we opened a case with Microsoft.

    For some reason, the year-end update corrupted something in the installation of GP2018.  We found this out by renaming the GP2018 program files folder, then repairing Dynamics GP.  Once we did that, the reports started totaling correctly again.  We then added in the 3rd party product, testing the report each time, and the issue didn't come back.  So, as far as a fix, the answer is to rename the folder in C:\Program Files(x86)\Microsoft Dyamics\GP\ to something other than "GP", then go into Add and Remove Programs and repair Dynamics GP.

  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,965 on at
    RE: Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

    Strange.  It sounds like you have definitely isolated it as an environment issue.  It seems like there is something with the System-Level Account Framework, perhaps related to it being a single segment.  Microsoft would be the best resource.  

  • jland555 Profile Picture
    jland555 75 on at
    RE: Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

    So, the issue with the HITB reset tool was a break in the last build.  Microsoft sent over a new .cnk file, and so I was able to reset it.  But now, I have the same subtotaling issue with the HITB, where it's inserting a subtotal by account between each item.  So, I don't know what choice I have but to open a case with Microsoft to get to the bottom of this....it's weird it was one report, but now it's two reports.

  • jland555 Profile Picture
    jland555 75 on at
    RE: Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

    I did try this on my working enviornment as well, and I'm betting you're right - it's not compatible yet.  I hope they hurry up!  ;-)

    Thank you!

  • Verified answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,965 on at
    RE: Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

    They will really like HITB!  And if you like SQL, you will LOVE the SEE30303 table.

    Regarding the Reset error, I would look into the Account Framework tables to see if there is something amiss there.

    [Did you try the HITB Reset tool on your working environment?  Perhaps it is not compatible with 18.2 yet.]

  • jland555 Profile Picture
    jland555 75 on at
    RE: Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

    Sadly, adding another segment didn't fix the report.  I don't have the issue on my local machine, so it has to be something with their environment (but even the Fabrikam database is producing the faulty report, so I'm not so sure it's data related.)  It just didn't happen prior to the year-end update.

    At this point, they've decided they'd rather use the HITB reset tool and get that back in line.  So now I'm focused on trying to fix that :-(  I did run the Grant.SQL, and ran GP as Administrator.  I captured an SQL profile, but I don't see the error in the profile.  

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,965 on at
    RE: Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

    The blank Sorting Options is to be expected with a single account segment.  (It dates back to a frustrating decision made  around version 3.0 to not allow a sort on the first segment in the Account Framework.)

    If you have access to a test company on the client's server, add a second segment to the account framework and see if (1) there is a sort defined in Account Framework for the second segment and (2) if the HSS report stops subtotaling after every item.

    The results

    [I'm not familiar with the HITB error.  I'd run Grant.SQL and make sure to launch GP with Run as Administrator and log in as sa to troubleshoot.  If that doesn't clear it, a SQL trace or debugger may provide more clues.]

  • jland555 Profile Picture
    jland555 75 on at
    RE: Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

    They really do only have one GL account segment.  There is no sort order specified - could that be the problem?

    AccountSetup.png

    I did run the report on Fabrikam on their server, and I'm getting the same kind of funky results there as well.  

    StockStatus1.png

    StockStatus2.png

    Just to confirm, I also tested this on my own local test instance for the same version.  My results matched yours - not the client's.

    And, to make matters even stranger, I installed the GP 2018 HITB reset tool, and when I try to run it, I get this error when launching it through GP:

    HITB-Reset-Issue.png

    (I think I'll start a second thread on this one after seeing if I can find the answer through some searches.

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,965 on at
    RE: Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

    How about trying the report from TWO (Fabrikam) sample company?  I get the data subtotaled by account when I run it from there (18.2.1036).  For example:
    pastedimage1578963986688v1.png

    I'm thinking it may have something to do with your Sort Order on the Account Format.  Do you really have only one segment in your account?  Is the Sort set to that account?  (I can't tell if you have a segment named "Account Number" or if you have a one-segment account.) 

    Check Links on the Account Master will update the Main Segment based on that sort.

  • jland555 Profile Picture
    jland555 75 on at
    RE: Historical Stock Status Bug in 2019 Year-End Update - No longer totals by account

    I did compare the two reports, and at the table and sorting levels, I see no difference.  In fact, there are no sort options at the table level.  The section options between the two reports matched as well.  I did see some changes in the upgraded report where the visibility was turned off for some fields in the item footer.  Just to make sure, I created a custom report on the non-upgraded test machine - I made no changes, just opened the report in report writer.  I then moved this report into the reports.dic for the upgraded server by copying the reports.dic from the old machine and then importing that one report into the reports.dic of the upgraded server.  I still got the same result.  Whatever was changed appears to have been changed at a code level that I can't see.  

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans