In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   Cloud ERP  |   Home  |   qad.com



  •     QAD Glossary

  • 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.