Finance | Project Operations, Human Resources, ...

SSRS HITB and GP Historical Inventory TB not matching

(0) Share

Report

Posted on by sandipdjadhav

18,265

Hello Team,

My SSRS HITB and Dynamics GP Historical Inventory Trial Balance is not matching. I given the same kind of report parameters to SSRS and GP report but both shows different results.

Not sure what it is causing it? Any help on this is highly appreciable.

Thanks much
Sandip

Categories:

Microsoft Dynamics GP

All responses (11)

Answers (0)

Suggested answer

Terry R Heley Microsoft Employee on at

Like (0)

Report

RE: SSRS HITB and GP Historical Inventory TB not matching

This is fixed in the January 2022 hotfix released on 1/21/2022 (18.4.1434)

(99+) Microsoft Dynamics GP January 2022 Hotfix Now Available - Microsoft Dynamics GP Community
sandipdjadhav 18,265 on at

Like (0)

Report

RE: SSRS HITB and GP Historical Inventory TB not matching

Hello Lucas, Sorry to bother you. Any luck to me? Request you to please forward me the workaround to rectify this issue.

Thanks much

Sandip
sandipdjadhav 18,265 on at

Like (0)

Report

RE: SSRS HITB and GP Historical Inventory TB not matching

Hello Pam,

Inventory Valuation method is : FIFO Perpetual.

Thanks much

Sandip
Community Member Microsoft Employee on at

Like (0)

Report

RE: SSRS HITB and GP Historical Inventory TB not matching

What valuation method are you using?
sandipdjadhav 18,265 on at

Like (0)

Report

RE: SSRS HITB and GP Historical Inventory TB not matching

Hello Lucas,

I am not able to open support request as client does not have it. May I request you to please give me the work around to resolve the issue.

Thanks much

Sandip
Richard Wheeler 75,730 on at

Like (1)

Report

RE: SSRS HITB and GP Historical Inventory TB not matching

Sandip, if you do not mind I would like to know what the work around for this is.
Lucas Reuss on at

Like (0)

Report

RE: SSRS HITB and GP Historical Inventory TB not matching

Hello Sandip,

You are running into a known issue with the SSRS version of the HITB report. I would recommend opening a support case if you have not already and we can provide you with the workaround to this issue to get you up and running again.

Thank you,
Lucas Reuss on at

Like (1)

Report

RE: SSRS HITB and GP Historical Inventory TB not matching

Hello Beat,

It is still being worked on being corrected in a future update.

Regards,
Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

RE: SSRS HITB and GP Historical Inventory TB not matching

Hi Lucas,

Was this bug fixed in the Fall 2021 release with the SSRS reports ?
sandipdjadhav 18,265 on at

Like (0)

Report

RE: SSRS HITB and GP Historical Inventory TB not matching

Hello Lucas,

Much appreciated for your reply. Below is my answer.

1. What version of Dynamics GP are you running? (Help | About Microsoft Dynamics GP)

GP 18.2.1060 (2019)

2. Do you receive any information when running the SSRS version of the report? No error or other information.

3. What parameters are you using in each version of the report? Date parameter e.g. 09/30/2021 for all items. or 1 specific item.

Please let me know what need to do to rectify this issue.

Thanks much

Sandip