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) / GL distribution summar...
Microsoft Dynamics GP (Archived)

GL distribution summary report

(0) ShareShare
ReportReport
Posted on by Jim Schmerbeck 195

HI, When my client runs checks in payables managemnt and posts the check batch the GL distribution summary amounts on the report are different than what actually post to the gl, Does anybody have any idea what would be the cause of this, support doesnt really understand why this is happening, any thoughts on what to check, please help,

Thank You

Jim Empower Business Solutions

*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Are the actual individual amounts different or could you be missing an account in GL?

    If you pull the detail distribution does it match the summary distribution?

    Does the summary match what you expect to be posted (based on the payroll run) or are the actual numbers posted correct?

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Jim,

    Below are a number of questions to help track this down:

    Are there any customizations, report modifications or 3rd party products installed? 

    What version and build of GP? 

    Can this be reproduced?  By a different GP user?  On a different computer?  Directly on the server?  In a different GP company? 

    To repeat one of Richard's questions - which is incorrect, the report, or the GL entries?  If the GL entries, what are the posting settings for the payables check transactions?  Is it possible that there is more than one GL entry generated by the payables batch posting?  Is it possible that one of the checks didn't post because there was an error?  Is the difference something that you can identify, for example the amount of one of the checks?

    Also, what is the name of the report you're looking at for the totals?

  • Jim Schmerbeck Profile Picture
    Jim Schmerbeck 195 on at

    Hi Victoria,

     

    Thank you for your response, I am looking at the gl distribution summary that prints when you post checks, It appears the differneces are in the discounts.

    Customer is on GP 10 this seems to happen to any user on any machine

    When we go and look in journal entry inquiry we see that the amounts in there are different than what is in gp distribution summary report that prints when we post checks, it seems to happen jsut about every other day we have a srs check register we run, but it does not happen every day just sporatic throughout the month, we can't seem to fiqure it out

     

    If you have any thoughts on what to lok for that would be great, Thanks

     

    Jim 

     

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Jim,

    So is the report wrong?  Or the GL entries?  Does this only happen when there are discounts? 

    Are there any customizations, report modifications or 3rd party products installed? 

  • Jim Schmerbeck Profile Picture
    Jim Schmerbeck 195 on at

    Victoria,

    This only happens with discounts, We think the GL entries are correct, as the stock gp report is wrong but we are not sure, the only 3rd party application is kwiktag doc scanning.

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