Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

SSRS HITB and GP Historical Inventory TB not matching

Posted on by 18,252

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:
  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    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)
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,252 on at
    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 Profile Picture
    sandipdjadhav 18,252 on at
    RE: SSRS HITB and GP Historical Inventory TB not matching

    Hello Pam,

    Inventory Valuation method is : FIFO Perpetual.

    Thanks much

    Sandip

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS HITB and GP Historical Inventory TB not matching

    What valuation method are you using?

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,252 on at
    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 Profile Picture
    Richard Wheeler 75,730 on at
    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 Profile Picture
    Lucas Reuss on at
    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 Profile Picture
    Lucas Reuss on at
    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 Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator on at
    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 Profile Picture
    sandipdjadhav 18,252 on at
    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

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans