Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Identify changed distr...
Microsoft Dynamics GP (Archived)

Identify changed distributions in GL from SOP posting

(0) ShareShare
ReportReport
Posted on by Josh P 2,895

Hi Community,

I have a scenario where users have put in SOP invoices, and posted them. After posting the invoices, they changed the distributions on the GL batch created due to transaction posting. This has caused a problem due to the financials being over/understated based on the AR balances. 

The question is, has anyone here been able to come up with a process that will identify differences between S/L and G/L distributions between the SOP > RM > GL modules?

Thanks.

*This post is locked for comments

  • Verified answer
    Josh P Profile Picture
    Josh P 2,895 on at
    RE: Identify changed distributions in GL from SOP posting

    Thanks Leslie,

    Yes, the users should not be changing the distributions per their process, and asked us to help identify them. I ended up opening an MS case to see if we could fix the distributions through SQL. In the end, we at least identified them, and the users had to void the transactions, and re-enter them. 

    Thank you for the replies All.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Identify changed distributions in GL from SOP posting

    Joshua,

    You've got the tables, now you need to build some SQL views that will compare the distributions to see where or if they have changed.

    As I understand it, you want to see if the accounts set in the SOP Invoice, actually posted to the GL. The entries, as you know, can be changed before they are posted to the GL and no record is made in sop. The SOP Invoice is usually a credit to sales and a debit to accounts receivable. There is not a separate entry made when it turns into a receivable. When the receivable is paid, it's typically a credit the A/R and a debit to Cash. Are you concerned that the distributions on the SOP invoice are not making it in tact to the GL? Changing the accounts on the RM transactions would result in either cash or A/R not reconciling, so that would be fairly obvious.

    Unfortunately, I have not gone through this exercise, but it's a great idea. Perhaps one of our SQL experts will come forward with a statement.

    Kind regards,

    Leslie

  • Josh P Profile Picture
    Josh P 2,895 on at
    RE: Identify changed distributions in GL from SOP posting

    Yes, unfortunately, the issue is not only from AR to GL. In some instances, the AR and GL distribution records are valid in terms of data, but the sales invoice distributions do not match. The process I am looking for would be to match SOP distributions to AR distributions to GL.

    A scenario would be to ensure the consistency between these tables:

    SOP10102  (SOP)

    RM10101 / RM30301  (RM)

    GL10001 / GL20000 / GL30000  (GL)

    Thanks

  • Verified answer
    26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: Identify changed distributions in GL from SOP posting

    Hello Joshua:

    Have you tried running the reconcile to GL routine for RM from Financials |Routines|Reconcile to GL?

    This routine will yield an excel that may be a great starting point for what you are shooting for.

    This has happened to us several times that sometimes, I almost wish we had the "allow account entry" check box unchecked for these control accounts.

    Best of luck

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans