SAP Business One audit trail report

[star_zcb0807]

            Our B1 users are asking for an audit trail report from B1 for local legal requirement, which can view all change logs and exactly tell the field change with old value and new value among each log instance. Does anyone create it before? If yes, possible to share the query? If not, any other work-around methods? Any ideas/thoughts, please let me know. Thanks!

SAP Business One 

[SonTran]

Hi,

You can upgrade your system to Ver 10 SP 2408 to have Audit Trail Report.

3458114 - Audit Trail report and additional settings for history / log are available - SAP for Me

Hope this helps,

SonTran

[star_zcb0807]

Okie. Thanks for your updates. I will note down. But at present, we are using B1 10 (FP2105). Under this version, does it mean we need customize the audit trail report by ourselves? User need the report can show the same column in "Differences" window. But how to write the query which can list the changes compared with last log instance number for all columns in ADOC table?