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

  • Release Notes for Release 3.8.2
    QAD Business Intelligence Version: 3.8.2
    Date: July 2013
    New Feature Summary
    The QAD BI 3.8.2 maintenance release resolves issues with the Common and Financial modules.
    Upgrade Instructions
    Contact QAD Services for upgrade information.
    Data Warehouse Tables Changed
    The following section lists the Data Warehouse tables that have been changed, added, or deleted.
    Note: The tables on the Modified list may have been changed structurally. For example:
    Columns added or deleted
    Indexes added or deleted
    Changes made to business display names
    Changes to visibility of particular columns in the BI Portal
    Any combination of these modifications
    The procedure that populates the table has changed
    List of Tables Modified
    Common Module Modified Tables
     
    dim_credit_term
    load_tr_hist_history
    stage_transaction_hist
    load_tr_hist
    perm_transaction_hist
     
    Financials Module Modified Tables
     
    extract_ee_customer_invoice
    perm_ee_posting_saf
    permsup_ee_posting_line
    extract_ee_customer_invoice_stage
    perm_ee_posting_saf_combined
    permsup_ee_posting_saf
    extract_ee_posting_line
    perm_ee_posting_saf_combined
    permsup_ee_posting_saf
    extract_ee_supplier_invoice
    perm_ee_supplier_invoice
    stage_ee_ap_supplier_invoice
    perm_ee_customer_invoice
    perm_ee_supplier_invoice
    stage_ee_ap_supplier_invoice
    perm_ee_customer_invoice
    perm_ee_supplier_invoice_movement
    stage_ee_ap_supplier_invoice1
    perm_ee_customer_invoice_movement
    perm_ee_supplier_invoice_movement
    stage_ee_ar_customer_invoice_hist
    perm_ee_customer_invoice_movement
    perm_ee_supplier_invoice_posting
    stage_ee_ar_customer_invoice1
    perm_ee_customer_invoice_opinfo
    perm_ee_supplier_invoice_posting
    stage_ee_customer_invoice_perm
    perm_ee_customer_invoice_opinfo
    perm_ee_supplier_invoice_stage
    stage_ee_gl_transaction1
    perm_ee_customer_invoice_stage
    perm_ee_supplier_invoice_stage
    stage_ee_posting_line_perm
    perm_ee_customer_invoice_stage
    permsup_ee_posting_line
    stage_ee_supplier_invoice_perm
    perm_ee_posting_saf
     
     
     
    Tables Added to Existing Modules
    Common Module Added Tables
    For the 3.8.2 release, no tables were added to the Common Module.
    Financials Module Added Tables
     
    stage_ee_ap_supplier_invoice_hist1
    stage_ee_ap_supplier_invoice_history2
    stage_ee_ar_customer_invoice_hist1
    stage_ee_ap_supplier_invoice_hist1
    stage_ee_ap_supplier_invoice_history2
    stage_ee_ar_customer_invoice_history
    stage_ee_ap_supplier_invoice_history0
    stage_ee_ap_supplier_invoice_history3
    stage_ee_ar_customer_invoice_history0
    stage_ee_ap_supplier_invoice_history0
    stage_ee_ap_supplier_invoice_history3
    stage_ee_ar_customer_invoice_history1
    stage_ee_ap_supplier_invoice_history1
    stage_ee_ap_supplier_invoice_history4
    stage_ee_ar_customer_invoice_history2
    stage_ee_ap_supplier_invoice_history1
    stage_ee_ap_supplier_invoice_history4
    stage_ee_ar_customer_invoice_history3
    List of Tables Deleted
    For the 3.8.2 release, no tables were deleted.
    Fixes
     
    Table 3 BI 3.8.2 Fixes  
    Component
    QAD Issue
    Description
    Metadata
    (EE Financials)
    QBI-2187
    BI 3.8.2 fixes some calculation errors for the Financials EE History and Snapshot fact tables. Invoices with payments spread over multiple dates could have double-counted payments or missing payments on some history and snapshot records.
    The data that ends up in the fact tables is now correct. The actual changes are to several of the stage tables leading up to these fact tables. The following fact tables are affected:
    fact_ee_ap_supplier_invoice_history
    fact_ee_ap_supplier_invoice_snapshot
    fact_ee_ar_customer_invoice_history
    fact_ee_ar_customer_invoice_snapshot
     
    QBI-3352
    BI 3.8.2 fixes a rare set of circumstances, where stage_ap_voucher_chk_match would go into an infinite loop but the audit log would reveal single record inserts. Sometimes it would reveal 2 and then 1 insert.
     
    QBI-2956
    In BI 3.8.1, dim_credit_term ceased to function as a slowly changing dimension. There was no start and end effective dates for the credit terms records. BI 3.8.2 fixes this issue and dim_credit_term is again a slowly changing dimension, and the history of credit terms changes is preserved.
     
    QBI-2816 QBI-2817 QBI-3219 QBI-3227 QBI-3235
    BI 3.8.2 makes various internal improvements to the EE Financials processing and should have no effect on the fact table results. This improvement:
    Allows you to run upgrades in the future
    Allows you to reload a fact table from the perm tables without requiring any re-running of data loads from the source
    Improves performance of history loads