Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Reconciliati...
Microsoft Dynamics GP (Archived)

Inventory Reconciliation - Using GP Manufacturing

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We are currently using GP 2013 with Manufacturing and SOP. Before and after upgrade to 2013 we notice quantities and allocations being out of sync.

Running Inventory Reconciliation appears to correct the issue. Sometimes we only run reconciliation for inventory and other times we run reconciliation for all modules in the sequence suggested.

My questions are:

1. When we run reconciliation should we always run all modules or is it fine to just run the one for inventory?

2. Is there any potential harm in running reconciliation on a regular basis? I have read on this forum that some users, especially those using Manufacturing, run it weekly and some even run it nightly.

3. Is there a guide or some direction to trace the corrected errors in the reconciliation logs to a possible human data entry/transaction cause by our users?

Thank you in advance

*This post is locked for comments

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Inventory Reconciliation - Using GP Manufacturing

    Reconciliation is fine to run frequently.  There are some issues with both SOP and manufacturing that affect allocations.  For example, if 10 of an item are allocated and only 8 are used, the remaining 2 stay allocated after the MO is closed.

    I have a script that MS provided that identifies ALL records that need to be addressed to correct allocations. Sometimes reconciliation just does not do it.  Email me at rwhaley@accoladepublications.com and I will send you a copy of the script.  Use it with caution!

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Reconciliation - Using GP Manufacturing

    It's better to run reconciliation for all the modules, although you're just fine to run the Inventory Reconciliation alone as it is not dependent upon other modules reconciliation.

    There are no negative ramifications at all for the reconciliation process at all, and it is highly recommended to be scheduled to run on a regular base. As for the timing, the system doesn't allow you to run an inventory reconciliation; for instance, in case any of the user is working on any window related to IV Module. Therefore, you would better run it at night with the report saved to be read thoroughly later on.

    As for the errors, Reconciliation mainly re-calculates the quantity on hand from purchase receipt work and detail tables [ IV10200 ] [ IV10201 ]. On the other hand, receipt details are checked against receipt work, and RECON documents are thrown in the  [ IV10201 ] table specifically. Moreover, allocations are recalculated by the process. I don't believe these are use errors, they are mostly errors related to server or network performance, or third party solutions that improperly implemented.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans