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 Accrued purchases b...
Microsoft Dynamics GP (Archived)

GL Accrued purchases balance versus PO Shipped not Received report

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,850 Moderator

Is there any way to tie a PO shipped receipt or PO Invoice receipt entry to a ledger entry going against the accrued purchases account? I have scripts that can do that in a summary way but I am struggling with trying to look for an exact match. I am trying to find out why there is currently a difference between the balance in the GL versus the received not invoiced report.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Richard,

    Did you ever find a way to do this?  I have a similar issue with a client of mine where there is a difference between the GL Balance against the Received/Not Invoiced Report.

    Kind Regards

    Kevin

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi Richard,

    I normally look at the POP10500 table to find out what the real balance should be in the Accrued purchases account. Then, I look at the transactions in the GL that are in that account and match the ins and outs (I actually use the Transaction Matching feature of GP to keep track of this). This process identifies to me which documents persist in the Accrued Purchases account. I then compare the documents that are rightly in the Accrued Purchases account with the information in the Receipts table. The most frequent error I have found that makes up for the irregularities in the balances is when the vendor invoice isn't matched to the PO, but rather entered into the payables transaction entry window. The client would cancel/close the PO, but no GL entry was made to reduce the balance in the accrued purchases account. This action leaves my accrued purchases account overstated. It was because of this that I wanted GP to add the warning if someone tried to enter an A/P trx against a vendor with an outstanding PO.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at

    Thank you Leslie, that has also answered my query too.

  • Community Member Profile Picture
    Community Member on at

    Leslie, 

    I am fairly new to GP - how do you access POP10500?

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