Understanding Audit Records

Audit records show transaction amounts before and after the base currency conversion and the conversion rate used to calculate the new base currency amount. All programs for the base currency conversion automatically create audit records for each table and write the records to the F0086 table, although the conversion programs do not require that you create audit records.

If you want the system to create audit records for all tables in a plan, skip the task Preventing the Creation of Audit Records. When the Audit Record Y/N File - Euro table (F0085) contains no record for a plan, the conversion programs automatically create audit records.

If you do not want the system to create audit records for all tables, you must complete the task Preventing the Creation of Audit Records and create a record for the plan. When the F0085 table contains a record for a plan, the conversion programs search the table and determine whether to create audit records. You can create audit records for some tables and not others.

Important: Creating audit records during the base currency conversion can require a substantial amount of disk space.

See Sizing Impacts on the F0911, F0902, and F0086 Tables.

Carefully consider whether you need to create audit records for a table. Consult your auditors to find out which audit records are required by your company, if applicable, and the country in which you conduct business.

To produce a report, you can create and run a query or batch program over the F0086 table. To do this, you need the composite key for each table converted. If you decide to run a batch program, create the report based on the F0086 Audit Report Model program (R0086) that appears on the Setup and Conversion menu (G97UE9A).

See Composite Keys for JD Edwards EnterpriseOne Systems.