web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / HITB report issue
Microsoft Dynamics GP (Archived)

HITB report issue

(0) ShareShare
ReportReport
Posted on by Jitendra Verma 1,240

After Inventory reconcilation, inventory has been overstated in sub ledgers by million dolllars. My issue is with HITB reports which displays incorrect data. After inventory wiped out and then added new quantity, system didn't wiped out HITB tables. I need to show correct inventory on HITB report. How could I do that?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Sounds like you need to run the HITB reset tool, here is a prior post, related to this subject:

    http://mahmoudsaadi.blogspot.com/2013/10/hitb-essentials-series-hitb-reset-tool.html

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    I will stand at one specific statement :

    "After Inventory reconciliation, Inventory has been overstated in sub ledgers by million dollars." 

    How did you come to figure out this finding ?

    In case you considered the HITB report as the source of comparison (before and after the IV reconciliation), then it should not change as it is not touched at all by the reconciliation process. Please provide further details regarding this point specifically. 

    Harry's point is precise, running the HITB reset tool will reset your HITB records as retrieved from the purchase receipt layers (IV10200). In this essence, I may recommend running what I usually call "Internal Inventory Reconciliation" which main purpose is to match the inventory tables (SEE30300 with IV10200 and IV10201) . In case the unmatched records are few and clear, you can manually insert these records in the SEE table. 

    To do what's called the internal inventory reconciliation, you can simply run a simple SQL script matching both (IV10200 and IV10201) with SEE30303. I am quite sure I have previously provided such script on the community.

    Although the question remains, do you have the technical know-how to deal with Dynamics GP tables and SQL as well ?

    Your feedback is highly appreciated, 

  • Community Member Profile Picture
    Community Member on at

    Can you tell or provide the path to the posting in your blog that has this " Internal Inventory Reconciliation"

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Mahmoud is referring to the process of reconciling the Inventory data contained in the various tables.  Here is a blog post on this process, the potential problems you should be looking for and resolutions to these causes.

    redbeardblogging.blogspot.com/.../hitb-quanity-on-hand-vs-inventory.html

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Harry is definitely right, I am referring to matching the inventory tables internally which would potentially have variances. It seems I have not published the script which matches inventory tables, I will ensure to do so soon

    By the way, nice article Harry !

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans