Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Reconcile transactions across modules in GP

Posted on by Microsoft Employee

This is my first GP project and I need help!  

What is the process to reconcile transactions/records across the various (SOP, POP, RM, PM, INV, GL) modules?  We are finding records that have a part of the transaction that was voided.  For example, the RM was voided but the SOP record was not voided.   What is the general data flow for GP = SOP > RM > POP > PM > INV ?  Is there a way to identify orphaned records?  (IE. From the data flow - only the POP record was voided BUT it's only partially voided since the other records sitting in the other modules are still intact. There are no cascading transactions to fully void the record.)

*This post is locked for comments

  • Tim Wappat Profile Picture
    Tim Wappat 5,701 on at
    RE: Reconcile transactions across modules in GP

    Generally in GP if you have data integrity issues, you start with running check links on all the modules, then reconcile for each of the transaction types IV/POP/SOP etc.

    You really need to have a backup before you do this, and read the reports of what has been done to check for unintended consequences.

    Google these terms in relation to GP for more info.

    If you still have problems, I'd reach out to an experienced GP consultant to help you get going. There are resources for transaction flows and posting data flows, but this might be a bit much to take in as a first project. 

    See GP SDK and publications like those at  www.accoladepublications.com

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans