Announcements
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
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 !
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
Can you tell or provide the path to the posting in your blog that has this " Internal Inventory Reconciliation"
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,
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
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
