GP 2010 Edit PO List

(0) Share

Report

Posted on by Richard Wheeler

75,730

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

All responses (2)

Answers (0)

Richard Wheeler 75,730 on at

Like (0)

Report

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... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

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.