Report on History

[ImIronMan]

Hi,

Is there way to get a report on what has been modified, who done it and when against each purchase record.

In purchase order properties > History > > we can see this information , but we cant download for all purchase orders at once. I've checked in reports section as well, but "history" column doesn't seem to be present.

In the compliance database as well, I've observed created date/updated date/creation user/updated user only but there is no history description (what has been modified).

How to fetch a complete history report for all purchases in fnms ?

Regards

Rajesh

[DAWN]

The underlying Table\View you're looking for is ComplianceHistory. This table has the details and links back to the various objects and lookup tables to keep it as small as possible, so you will have to link back to the PO\PO Detail tables as well as the TYPE of update lookup tables to get a complete picture.

[ImIronMan]

@DAWN , thanks for your quick reply. I just tried looking in compliance history table. But it seem to be too complex and above my level. Could you please give me a query that can pull this information.

[mfranz · Accepted solution]

Please find an example attached.

[ChrisG]

For another thread with some further discussion about a similar question to what is discussed here, see: Report on History tab