web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,848 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)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: GP 2010 Edit PO List

    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.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,613 Super User 2025 Season 2 on at
    Re: GP 2010 Edit PO List

    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.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans