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

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) / Receipt QTYs do not ma...
Microsoft Dynamics GP (Archived)

Receipt QTYs do not match IV QTYs -IV HITB Reset Tool Validation Report

(0) ShareShare
ReportReport
Posted on by Community Member

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

mik@gumcorp.com

 

 

 

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at

    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.

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

    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

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans