Dear all,
Hope you are in good health.
I would like to request you to give solution to a a problem
1. Recieot QTYS do not match IV QTYs which was encountered during execution of IV HITB Reset tool validation report.
2. This transaction has been assigned to a batch that has been marked for posting
Can any body provide assistance in solving the above noted problem.
I will be gratefull for your prompt possitive response.
Thanks and Kind Regards
MIK
*This post is locked for comments
One of the most common errors that has been populated about running the HITB reset is the following; “Receipt Qty’s do not match IV Qty’s”. This is to indicate that the receipt quantity at Purchase Receipt Work [ IV10200 ] doesn't match that quantity on hand at Item Quantity Master [ IV00102 ].
You can simply check whether quantities are matched by calculating the quantity on hand with a simple SQL script from IV10200 and comparing it to the quantity on hand field in IV00102.
In case there were any variances, run a reconcile and check if the variances were corrected. If not, please refer to a solution provided by MVP Mohammad Daoud to correct variances.
mohdaoud.blogspot.com/.../inventory-reset-average-item-receipt_6057.html
As for the second issue, check MKDTOPST and BCHSTTUS fields on SY00500, in case they were not equal to (zero), you need to correct them by running the following script.
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'
Before running the script, please check the following tables;
- DYNAMICS..SY00800
- DYNAMICS..SY00801
- DYNAMICS..ACTIVITY
- TEMPDB..DEX_LOCK
- TEMPDB..DEX_SESSION
The first thing I would do is check if there are any un-posted transactions that affect inventory quantities. These should be posted before you run the IV reset tool. Also check the batch recovery window to see if there is anything there that needs to be recovered.
Then make sure you run an Inventory reconcile.
If this does not resolve - I would then clear out logins and temp tables - follow the blog post at:
dynamicsgp.wordpress.com/.../batch-stuck-in-posting-receiving-busy-etc-etc
The next port of call would be a checklinks against POP/SOP and Inventory transaction tables.
Ian.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,253
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
