Reports and Utilities
This chapter includes information on master table audit reports, system cross-references, which let you identify how and where fields and tables are used, application server definitions, operating system commands, and delete/archive utilities. The Statutory-Currency Utility is also described.
Generating Auditing ReportsDiscusses auditing and other reports.
Setting Up Application ServersDiscusses the process AppServer, including how to define one, and gives an example of using the AppServer to run MRP.
Using Operating System CommandsDescribes different operating system commands and how to use them.
Using Delete/Archive UtilitiesExplains how to use Audit Detail Delete/Archive and GL Transaction Delete/Archive.
Statutory-Currency UtilityDescribes how you can use a utility to change the statutory currency of a domain, even after transactions have been posted.
Command Line Application ControlExplains how to use the application control program.
Generating Auditing Reports
You can review modifications to tracked master tables using Master Data Audit Report (36.17.1), which prints changed records in master tables. The report includes the database table name, current version of the changed record, user ID of the person who made the change, and date.
The system offers other auditing functions:
• Auditing information for unposted general ledger (GL) transactions is maintained when GL Transaction Audit Trail is selected in GL Operational Transaction Control (36.9.13). When selected, any changes made in Unposted GL Trans Correction (25.13.16) are logged.
• GL Trans Correction Audit Report (25.13.17) shows changes made to unposted GL transactions (accounts, sub-accounts, cost centers, and projects) using Unposted GL Trans Correction
• Use Change Tracking Maintenance (36.2.22) to track changes to sales order detail fields. See
Tracking Changes.
Other Reports
Use Master Comments Report (36.17.5) to print the text of master comments selected by a range of references and by type and language.
Use Control Tables Report (36.17.6) to generate a report listing the current values defined for all control tables in the system. This report is especially important during implementation. It enables you to verify that settings are appropriate for your business environment.