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
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.
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.
#1
André Arnaud de Cal...
292,575
Super User 2025 Season 1
#2
Martin Dráb
231,493
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
