
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)