Released by

I need to create a report showing the identity of the user who released a po.

I can drill on this information, but can't find the table where the user id is stored.

Does anyone know what table this field is stored on?

Find more posts tagged with

Comments

jon-athey

USER_ID in the PURCHORDER table.

0912140849182145.pdf

Legacy Contributor

Thanks for pointing me to the User_ID Field.

Our Auditor is also looking for a report on PO's that has multiple revisions. This report would show the user who released the revision, and the date it was released.

jon-athey

That may be a little more difficult. Unfortunately, that USER_ID field only shows the user that originally released the PO. Lawson doesn't track the user id for each revision release. You could use POAUDIT to see who created or made changes to each PO revision and assume that the user that made the changes was the one that released the revision but there's no way to know 100% who actually released each revision.

Copyright © 2025 Infor. All rights reserved.