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

GP 2010 Edit PO List

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,854 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

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,633 Moderator 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,854 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans