Audit Log Reporting

I am not familiar with reporting in FSM so am hoping someone can give me some direction. I need to report off the audit log for Payables Invoice. Specifically I need to pull all invoices with a status of 'Amended' along with the new distribution date. An example is below.

Is this possible and if so, can someone advise on how to get there and what to do?

Please and thank you,

Lisa

Find more posts tagged with

Accepted answers

All comments

Dr. Awesome

So you don't need the Payables Invoices currently in Amended status (and their distribution dates)? Instead, you need to know whenever a Payables Invoice maybe have entered into the Amended status (regardless of it's current status) and what the distribution date was at the time it entered into Amended?

Lisa Callahan

Yes, the client would like to see distribution dates that are amended from one month to another.

andy

There is a Payables Invoice Audit List (PayablesInvoice.InvoiceAuditList) but the default search form doesn't include "Status". You could add it to the search form, but performance-wise you might see gateway timeouts searching on that list, depending on your criteria and volume in the PayablesInvoice business class. I'm not sure how filtering audit log data is processed on the backend, but I believe audit log data is stored in XML blobs, so conceivably filtering against that could be pretty taxing performance-wise.

You might be better off creating a replication set for the Payables Invoice Audit Log data and consuming it in an external reporting tool. Creating a columnar rep set of the audit log data might be an option as well.

udavidovic

Lisa,

there is a separate BC that contains the Invoice audit information; I believe, unlike other BCs, there is a transactional audit BC that can be viewed without the need to look through various iterations of the record - it should have the status included in it, so you can essentially query it and look for changes in the distribution date, along with previous status, as a filter. Hope that helps. Should be something like PayablesInvoiceAudit, if I recall correctly.

Uros

Lisa Callahan

After reading your response I was very optimistic that this delivered BC could get me what I was after. However, after doing additional research (and a little hair-pulling) not all transactions in the individual audit logs are in the payablesinvoiceaudit BC. And I am not sure why. My best guess is that the BC is not intended for a full audit but more for tracking along the approval route.

For example, here is the audit log for invoice 2574581237 when I click on 'View Audit Log' from the invoice itself -

There are 16 entries with the one I am after highlighted in red with a status of 'Amended. But when access the BC and enter the same invoice number I only get 4 entries.

In addition, the Action (which I am pretty sure is status) does not even reconcile with the 2/29/2024 distribution date Status entries from the above screen shot.

So at the end of the day, I am not sure I can get what I am after.

Ugh....

udavidovic

This will be another answer that falls short of actually addressing the details, but... there is a screen in Infor that drives what events are logged to this BC; you can make the logging more verbose, if you choose to do so, and that may help capture additional events. I will try to find it and respond, but it is a configuration you can toggle, to an extent.

udavidovic

Actually, that is the Purchase Order auditing - so, no, no way that I know, other than examination of the audit log itself.

Lisa Callahan

That is what I was afraid of

But I really do appreciate you help!

andy

You are correct. The PayablesInvoiceAudit is more germane to Invoice Approvals (e.g. Invoice is submitted, rejected, approved, matched, etc.). You'll notice its the "Approval Information" tab on the main invoice form and if you look in the PayablesInvoice business class you can see where the invocations occur that create those records. Adding PayablesInvoice.DistributionDate to that list is going to show you the current value of the DistributionDate, which doesn't seem like what you want.

If you want the Distribution Date from the Payables Invoice at the time the Payables Invoice Status changed to Amended, you're going to need to parse the Audit Log.

Have you tried creating a Columnar replication set for the Payables Invoice audit log? You might be able to create a Columnar list that meets your needs.

Dr. Awesome

The InvoiceAuditList seems like a good place to start. Also, you could create a new report and use the Audit Log Data Source option. With this, in the filter you can say:

((CreateDate > current date - 30 days) and (old Status != Status and Status = "Amended"))

I kinda just psuedo-coded that so check the syntax. This should find where Status has changed, and changed to Amended, but only for invoices created in the last 30 days.

Copyright © 2025 Infor. All rights reserved.