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

(0) Share

Report

Posted on by jland555

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:

Microsoft Dynamics GP

All responses (13)

Answers (2)

Verified answer

jland555 75 on at

Like (1)

Report

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 720 on at

Like (0)

Report

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 75 on at

Like (0)

Report

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 75 on at

Like (0)

Report

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 720 on at

Like (0)

Report

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 75 on at

Like (0)

Report

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 720 on at

Like (0)

Report

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 75 on at

Like (0)

Report

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?

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

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:

(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 720 on at

Like (0)

Report

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:

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 75 on at

Like (0)

Report

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.