Customer - Change Log

Hello Everyone,

I created a BAQ to display changes made to the Customer Table. But the report is only showing some of the changes and not all of them. See my setup below.

Please let me know what I am missing. FYI, I am on E9.

Thanks in advance.

Miguel

What is your criteria on the chglog table? what does the relationship look like?

Did you create a data directive to first track the changes on the Customer table? If so, then the ChgLog table you can filter it on the Table Name without needing to link it to the Customer table in your BAQ.

1 Like

This translates to BAM (business activity manager) in 9

1 Like

Sorry, yes you are correct BAM.

1 Like

Hello Joshua,
Here is my criteria I have TableName = Customer
and >= DateStamp
and <= DateStamp
See Below:

Thank you.
Miguel

Can you give me an example of a data directive? and where is that entered? I am not familiar with data directive.

Thank you.

Miguel

Hello Everyone,

I found the error, I had the Table relations between ChgLog and Customer with Customer and CustID instead of CustNum. I made the change and it works as expected.

Thanks to everyone to attempted to assist me.

Miguel