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) / Received / Not invoiced
Microsoft Dynamics GP (Archived)

Received / Not invoiced

(0) ShareShare
ReportReport
Posted on by Community Member

A new client has issued POs for a few years in GP and recorded a receivings transaction for the receipt of goods (Shipment).  Then they would enter the vendor's invoice in payables transactions.  Now they have a Received/Not Invoiced report that suggests an accrual of over $900,000 when really accrued purchases should be about $200,000.

Does anyone have a method of:  1. determining what the report should show using the PO and receiving tables (or are manual paper records the only place to recreate an accurate accrual) ; and 2  method of fixing the report?

Thanks for any suggestions,

George

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,623 Super User 2025 Season 2 on at

    There's no easy way to fix this situation.  The way I would do it would be to manually close the POs using 'Edit Purchase Orders' that have been fully received.  First, make sure that posting is to to Post To and not Post Through to GL so that a batch is created that can then be modified to debit and credit the Accrued Purchases account so there is no GL impact.  This method will also prevent a payable being created to the vendors, as would be the case if you were to match invoices to each open receipt.

  • Community Member Profile Picture
    Community Member on at

    Hello Frank,

    I was thinking, could I not run the Purchase Order Status report marking only 'Received'. The report should then show "received not invoiced" information.  Examine this report identifying items that were really received; then, as you suggest using the Edit PO Status, close the "bad" (received POs).  Re-run the report and this should give a correct "Recieved not Invoiced" total.  Now run the Received not Invoiced report and identify all of the "junk" POs that must be closed manually - via the Edit PO.  Now the Received not Invoice report should be "clean" and support the Accrued Purchases account (as should the PO Status report having marked only the Received box).

    thoughts?

    And thanks.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,623 Super User 2025 Season 2 on at

    George, when they processed the payables transactions to record the invoices, did they happen to enter the PO number in the transaction?  If so, someone with some decent SQL skills could put together a little query of the POP and PM tables to indicate which payables invoices should match up to the appropriate POs.  That would tell you which POs should be closed based on invoices processed.

    The PO Status report could work for you but it's pretty ugly - as are most legacy GP reports.  You might find it easier to create a SmartList to replicate the info on the PO Status Report.

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
Community Member Profile Picture

Community Member 2

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

#2
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans