BAQ to compile all changes listed in the PO Change Log

Kinetic ERP
1

Hello,
First, I don’t even know that this is possible. I’m hoping so. Is there a way to create a BAQ that takes all the change log details from the PO and compiles it into a data table?

We would like to be able to run a BAQ and flag unauthorized changes.

Thanks!

2

@lbradbury Yes it is possible and a lot will depend on how much data you track and how clean you need the presentation. All of the data is in the LogText field.

You will need to remove line feeds from the log with something like below.

(replace(replace(ChgLog.LogText, CHAR(10)+CHAR(10),' '), CHAR(10),' '))