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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Accrued Purchases Aging Report - Like the payable aging but specific to Purchases GL Account Number

(0) ShareShare
ReportReport
Posted on by 210

It was recently asked to see if we can create a report that is similar to the accounts payable aging but more specific to our accrued purchasing account = In SQL.

Summary:
It shows items received but not invoiced. Once the invoice is received and vouchered, the items come off the accrued purchases balance and moves to accounts payable. This report provides all of the activity of the GL Account, but ideally we'd like to see a list of all open received not invoiced transactions that are sitting in the account as of the end of any month. Ideally we'd like them to age just like an accounts payable aging.

Goal:
A great tool for managing older open received not invoiced transactions. Example, anything that sits in this account for more than 10-15 days is usually a problem....

Anyone create something like this before?

Jeffrey

*This post is locked for comments

I have the same question (0)

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans