Reports and Utilities
  
Reports and Utilities
This chapter includes information on master table audit reports, delete/archive utilities, and operating system commands.
Generating Master Data Reports
Explains how to generate audit trail reports, auditing reports, and other reports.
Using Delete/Archive Utilities
Explains how to use Audit Detail Delete/Archive (36.23.1) and GL Transaction Delete/Archive (36.23.2).
Using Operating System Commands
Explains how to use the Operating System Commands menu to access the operating system and execute commands directly from QAD applications.
Generating Master Data Reports
Use the Master Data Reports (36.17) menu to generate audit trail reports showing modifications to master tables, as well as reports showing master comments and control program settings.
Auditing Reports
Use audit trails to track and log which users have made changes to fields in master tables. The system tracks high-level information for changes to all master tables.
To maintain detailed information for a critical subset of master tables, set Audit Trail to Yes in Domain/Account Control (36.1). Audited Tables lists the database tables that the system tracks:

Audited Tables
 
Table
Description
 
Table
Description
ad_mstr
Addresses
 
plsd_det
Product Line Sales
bk_mstr
Banks
 
plt_det
Product Line Taxes
bom_mstr
Bills of Material
 
pl_mstr
Product Lines
cm_mstr
Customers
 
ps_mstr
Product Structures
cp_mstr
Customer Items
 
ptp_det
Item Planning
ct_mstr
Credit Terms
 
ptr_det
Item Routings
cu_mstr
Currency
 
pts_det
Item Substitutes
dpt_mstr
Departments
 
ptt_det
Item Taxes
ea_mstr
Earnings
 
pt_mstr
Items
ecm_mstr
Engineering Changes
 
slr_mstr
Site Linking Rules
emp_mstr
Employees
 
slrd_det
Site Linking Details
eu_mstr
End Users
 
spd_det
Salesperson Commissions
exr_rate
Exchange Rates
 
spt_det
Cost Simulation Items
is_mstr
Inventory Status
 
tax_mstr
Taxes
mu_mstr
Monetary Union
 
vd_mstr
Suppliers
pac_mstr
Purchase Approval Codes
 
vp_mstr
Supplier Items
pc_mstr
Price Lists
 
wc_mstr
Work Centers
pld_det
Product Lines
 
 
 
The audit record contains the user ID, table name, field name, and old and new data values.
Review modifications to tracked master tables with either of the following:
• Use Master Data Audit Report (36.17.1) to print 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.
• Use Master Table Audit Detail Report (36.17.2) to show details about audited changes when Audit Trail is Yes in Domain/Account Control. The report includes current and previous versions of the record, with the time and date of any changes.
The system offers other auditing functions:
• Auditing information for unposted general ledger (GL) transactions is maintained when GL Transaction Audit Trail is Yes in the General Ledger Control (25.24). This data also displays on the Master Data Audit Detail Report.
• 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.