You’re offline. This is a read only version of the page.
385
The HITB and the historical stock status report do not have equal balance for many items and there are bad records are showing in the HITB report.
How can I fix this?
Thanks
Hello Jozy and Angela ,
As per Lucas from Microsoft Support; There is bug in SSRS Report that's why it is not matching. Please find my Post below: community.dynamics.com/.../ssrs-hitb-and-gp-historical-inventory-tb-not-matching
I have requested the work around ; no reply yet. Request you to please provide the work around to resolve this issue asap.
Thanks much
Sandip
Hello Angela,
Thank you for your wiriting and as you said "The HSSR is really only recommended to look at from a quantity perspective at a point in the past but why even quanity is not matched with same past date in both reports?
Hi Jozy,
The HITB and the Historical Stock status report (HSSR) pull from two completely different tables so you could actually have different balances. And some types of cost adjustments are not recorded in the IV history table, but are in the HITB table.
HSSR was really the only tool we had back on older version to tie to GL. But as we added more and more functionality and added the IV10201 IV outflow table and the addition of the SEE30303 HITB table in version 10.0 and forward, the whole purposed was to build a report that would allow us to track EVERY in and out that touched inventory. So that is why we recommend using the HITB moving forward to look at your true costs and quantities of inventory.
The HSSR is really only recommended to look at from a quantity perspective at a point in the past and you should be using the HITB for both Qty and Cost perspective at a point in the past.
Hope this helps explains things.
Thanks for using Microsoft Dynamics communities!
Warmest Regards,
Angela Ebensteiner
Sr. Technical Advisor
Microsoft Dynamics GP
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (