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) / GP 2010 Edit PO List
Microsoft Dynamics GP (Archived)

GP 2010 Edit PO List

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,850 Moderator

Is there anyway to get a list of every time a user processes an Edit PO? I am trying to reconcile the GP IV balance versus the Historical IV TB and Purchase Receipts reports and I believe the differences are due to Edit PO's occurring. I do not see any report in GP the would give me a list every time an Edit PO was done. Is there a table in SQL I can query and what field can I filter on to give me this list?

*This post is locked for comments

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

    Richard, there's a 'Last Edit Date' in PO SmartList but it doesn't differentiate between using the Edit PO Status and making a change directly in the PO.  Both types of change update the Last Edit Date.  I think they would have to have Audit Trails installed and activated to get that level of data.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Thanks Frank, that is of which I was afraid. I just tried one and they had received but not invoiced. I just cancelled the PO and all it did was change the PO status. So now the acrual purchases GL account has a value that will never be relieved. There was no posting of any kind. I think I will work on a query that will list provide a list of all items where the shipped received amount does not equal the invoiced received amount plus one where the costs are different. I need to isolate what is causing the difference between the GL IV account and the IV HITB and PR reports.

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
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans