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) / Inventory Reconcile In...
Microsoft Dynamics GP (Archived)

Inventory Reconcile Insists on Adding Quantity

(0) ShareShare
ReportReport
Posted on by Tim Foster 8,515

A receipt for quantity 32 of a particular Item was processed.  My user tells me something strange happened during the process.  They returned 32.  There were zero on hand.  Then I reconciled Inventory.  GP is adding 32 more to the receipt.  Which leaves an erroneous 32 on hand.

I have checked the receipt and return and everything matches.  I have checked Inventory Transaction and they look correct.  I have scoured every SQL table that contains relevant data.  I traced (in SQL Profiler) the Inventory Reconcile process but because the scripts are encrypted, I can't see anything.

Does anyone have any ideas about how to fix this?  I have run out.

Thanks

Tim

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,854 Moderator on at

    What does your purchase receipts file show for this item? Does it also show 32 on hand? The IV10200 is the table for purchase receipts.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,854 Moderator on at

    I actually meant to say Purchase Receipts Report which uses the purchase receipts table.

    Reports->Inventory->Activity->Purchase Receipts

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I will suggest that you take a look either at the receipt or the return posting, and pay special attention to the sequence numbers, sometimes by "magic" dual postings occur, you can easily spot because sequences have a tendency of being multiples of 16384 if for some reason you have like a 16385 then that is the invalid record driving your mismatch.

    Have a great day

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 July 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