PO00 Audit Settings

Hi,

Does anyone currently have the Audit Vendor Items and Audit Vendor Agreements settings set to Y? Our system is currently setup to not track this audit information but we are quickly finding that we need to be to help ensure data integrity.

Our concern is, we are unable to see the POPCGAUDIT (PO61) or the POPIVAUDIT (PO69) tables in our SQL database tool. Does anyone have any experience with a system where these settings were set to N and you changed them to Y? We are trying to figure out what the system impact would be regarding performance and memory requirements.

Thanks for the feedback, John

Find more posts tagged with

Infor Lawson Supply Chain Group - Discussion

Comments

moellerg

We have both Items and Agreements set to Yes. I can see both of those tables in my SQL tool... Are you using SQL Server Management Studio or some other tool. Either way, are you sure you have permissions to see those tables?

unknown

Hey, we use SSMS as well and as far as I know, we have full access to all PO tables. We can see other POP*** tables, just not the audit ones. Not sure if that's because we have never had these settings turned on or if it's a different issue. Since we can't see those tables we are hesitant to turn on those settings in case their is an access issue with those two particular tables. Thoughts on that?

moellerg

I guess I'd get access (or verify access) first... even if the table is empty it should show up in the tool.

Copyright © 2025 Infor. All rights reserved.