You’re offline. This is a read only version of the page.
75,730
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
Leslie,
I am fairly new to GP - how do you access POP10500?
Thank you Leslie, that has also answered my query too.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (