Is there any report or module we can use to retrieve all the PO Approval Activity data ?
example: to check the open status for the PO
You may check the Open Purchase Order Report for this purpose…
I recently got asked this during an external audit by one of the big 5.
I wasn’t able to find a built in report, but you can get the data using the [EpicorERP].[Erp].[POApvMsg] table.
The approval activity is appended into a single field called MsgText.
It’s not easy to strip down as there is no delimiter (e.g ~) between the approval activity, and this may be why there is no canned report.
In the end I had to produce a report manually based a few PO’s, but the auditor walked away happy.
1 Like
ok need to customize a report for this. I thought epicor standard would have one. Thanks