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

Notifications

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) / 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

I have the same question (0)
  • Verified answer
    26P2ER Profile Picture
    26P2ER 1,775 on at

    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

  • Josh P Profile Picture
    Josh P 2,895 on at

    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
    L Vail Profile Picture
    L Vail 65,271 on at

    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

  • Verified answer
    Josh P Profile Picture
    Josh P 2,895 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans