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

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) / PO's that are clos...
Microsoft Dynamics GP (Archived)

PO's that are closed but not moved to history

(0) ShareShare
ReportReport
Posted on by baxter05

Dynamics GP 2010

I have been asked by my supervisor to come up with a few reports for him.

1) A report to show all Purchase Orders that have not been fulfilled that are older than 60-days

2) A report to show all Purchase Orders that are fulfilled but not invoiced

3) A report to show all Purchase Orders that have been fulfilled and invoiced but have not been moved to history.

We have SmartList Builder and it would be best to do these reports there so my supervisor can run them via SmartList any time he wants.

I believe I could probably figure out the first and second request, but am not sure how to structure them to the easiest possible method for my supervisor.

As to the third request, I cannot find anything that will give me a clue as to how to structure this one.

Any assistance would be greatly appreciated.

Thank you,

*This post is locked for comments

I have the same question (0)
  • Verified answer
    0e42d30f6d6b44fa91b5d578ca54d66a Profile Picture
    0e42d30f6d6b44fa91b... 25 on at

    Hello Pam,

    Please find reply below. It may help you .

    1) POP10100- work table, has document date and Posting Status you can create aging report.

    2) Report Purchasing Analysis Received not Invoiced

    3) POP30100 – Historical table

    Thanks

    Sandip

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    POs are received, not fulfilled unless you are talking about customer POs entered into SO's.  Please clarify and we can help you.

  • baxter05 Profile Picture
    baxter05 on at

    Richard,

    You are correct - I spend more time in SOP than I do POP -

    Replace the word "fulfilled" above with "RECEIVED" - this would also apply to POs that are dropped shipped and we've not had an invoice from the vendor to verify shipment to the customer.

  • Verified answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    For the Received not Invoiced, follow the suggestion above to get to the Received Not Invoiced Report.

    For POs that are completed but not moved to history, this happens for two reasons.  One is the Received Not Invoiced situation above.  The second is, for example, you order 10 pieces, receive 9, invoice match the 9, then calcel the 1.  The cancel process will not move the PO to history.  There is a process to do this that has no financial impact and I suggest that you do that regularly.  Then the only completed POs not in history will be the RNI ones.  This process is in Purchasing -> Routines -> Remove Completed Purchase Orders.  Make sure that POP Setup Maintain History all the flags are checked.

    We have books on POP, report writing from GP, and Information Flow and Posting that helps you track data through the maze of tables.  Check out our web site.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans