audit reports for IC11 and IC12

unknown

Can anyone tell me if there are audit reports for IC11 and IC12 to see what change was made and who made it? Thanks.

Find more posts tagged with

Infor Lawson Technology Group - Discussion

Comments

unknown

We use a Crystal Report against the ICAUDIT table.

unknown

Take a look at IC191 and IC192.

unknown

I use Crystal also...below is simple sql you can use in Crystal or sql mgr. You would need to change the PROD10 to whatever your product line is named.

SELECT "ICAUDIT"."ITEM", "ICAUDIT"."BEFORE_IMAGE", "ICAUDIT"."AFTER_IMAGE", "ICAUDIT"."OPERATOR_ID", "ITEMMAST"."DESCRIPTION"

FROM "PROD10"."dbo"."ITEMMAST" "ITEMMAST" INNER JOIN "PROD10"."dbo"."ICAUDIT" "ICAUDIT" ON ("ITEMMAST"."ITEM_GROUP"="ICAUDIT"."ITEM_GROUP") AND ("ITEMMAST"."ITEM"="ICAUDIT"."ITEM")

moellerg

It looks like you can narrow down T.Kole's response to just the past 24 hours by adding:

WHERE R_DATE > getdate() - 1

Or you could do the last 48 hours by

WHERE R_DATE > getdate() - 2

0904080939293831.xls

dechevar

I would recommend combining the query with the ICDICT table (Outer Join). You can then filter the report based on the field changed.

SELECT ICAUDIT.ITEM_GROUP,

ICAUDIT.COMPANY,

ICAUDIT.LOCATION,

ICAUDIT.ITEM,

ICAUDIT.GL_CATEGORY,

ICAUDIT.R_DATE,

ICAUDIT.R_TIME,

ICAUDIT.FLD_NBR,

ICDICT.FLD_NAME,

ICAUDIT.BEFORE_IMAGE,

ICAUDIT.AFTER_IMAGE,

ICAUDIT.OPERATOR_ID

FROM LSLMDB.ls_apps.ICAUDIT ICAUDIT

LEFT OUTER JOIN LSLMDB.ls_apps.ICDICT ICDICT

ON (ICAUDIT.FLD_NBR = ICDICT.FLD_NBR)

WHERE (ICAUDIT.R_DATE = calendar__gregorian__last_week__)

Field Number 0 is used for adds and deletions and does not have a FLD_NAME.

Copyright © 2025 Infor. All rights reserved.