• Advanced Financials Change Summary
•  About This Course
  •  Course Description
    • Course Objectives
    • Audience
    • Prerequisites
    • Course Credit and Scheduling
    • Virtual Environment Information
  •  Additional Resources
    • QAD Learning Center
    • QAD Document Library
    • QAD Support
•  GL Coding Structures
  • Objectives
  •  GL Analytical Coding Segments
    • GL Analytical Coding Segments Update
  •  Automatically Populated SAFs
    • SAF Features
    • System SAFs
    • User-Defined SAFs
    • Creating User-Defined SAFs
    • SAF Defaulting
    • SAF Defaulting Example
    • SAF Reporting
  •  Hands-On Exercise
    • Exercise: Supplementary Analysis Fields
•  Daemons
  • Objectives
  • Overview
  •  Daemons in QAD Enterprise Applications
    • Daemon Functions
    • XML Daemon Configuration
    • Creating XML Files in Financials
  •  Hands-On Exercises
    • Exercise 1: Dump and Load XML Files
    • Exercise 2: Scan Daemon
•  Excel Integration
  • Objectives
  • Overview
  • Excel Integration Uses
  •  Chart of Accounts
    • Load Data for Export to Excel for Maintenance
  •  Business Relations
    • Create an Empty Grid and Load Data
  •  Customer Data
    • Export Data to Excel
  •  Supplier Data
    • Import Modified Data from Excel
    • Create a Template for Use in Excel Integration
  •  Bank Numbers
    • Load Bank Numbers
    • Existing Record Field in Excel Grid
  •  Opening Balance Create
    • Journal Entries
    • Journal Entries, Segregation of Duties
    • JE Cross-Company Excel Integration
    • JE Excel Integration Repair
  •  Hands-On Exercises
    • Exercise 1: GL Account Excel Integration
    • Exercise 2: Business Relation Excel Integration
    • Exercise 3: Supplier Excel Integration
    • Exercise 4: Supplier Bank Number Excel Integration
    • Exercise 5: Supplier Open Items
    • Exercise 6: Journal Entries
    • Exercise 7: Journal Entry Cross-Company Excel Integration
•  ERS
  • Objective
  •  Overview
    • ERS Benefits
    • ERS Key Features
  •  ERS Process
    • ERS Process from Purchase Order to Supplier Invoice
    • ERS High Level Process Overview
  •  ERS Setup
    • ERS Control
    • ERS Maintenance and ERS Browse
    • ERS – Purchase Order Maintenance
    • ERS Processor
•  Logistics Accounting
  •  Overview
    • Definitions
    • Inbound versus Outbound Logistics
    • Logistics Charge Accruals Process
    • Logistics Charge Accruals Process Highlights
    • Benefits
  •  General Setup
    • Setting Up GL Accounts
    • Setting Up NRM Sequence Numbers
    • Setting Up the Control Programs
    • Defining Logistics Charge Codes
    • Defining Detailed Logistics Accounts
    • Setting Up Inbound Logistics Accounting
    • Creating Cost Elements
    • Updating Logistics Charge Code
    • Updating Item Costs
    • Defining Terms of Trade
    • Assigning Terms of Trade to Suppliers
  •  Setting Up Outbound Logistics Accounting
    • Updating Freight Terms
    • Setting Up Default Customer Freight Data
    • Set Up Freight Lists
    • Defining Item Ship Weight
    • Setting Up Trailer Codes
  •  Inbound Logistics Charges Accrual
    • Purchase Order Maintenance
    • PO Shipper Maintenance
    • PO and PO Shipper Receipts
    • GL Effect
  •  Outbound Logistics Charges Accrual
    • Sales Order Maintenance
    • Logistics Accounting Details
    • Sales Order Shipments
    • Sales Order Shippers
    • GL Effect
  •  Processing Logistics Charges
    • Logistics Charge Pending Invoice
    • Logistics Supplier Invoice
    • Matching Logistics Charges
    • GL Effect
  • Logistics Accounting Reporting
•  Budgeting
  • Objectives
  • Overview
  • Budgeting
  •  Budget Process
    • Budget Groups
    • Budget Report Periods
    • Budget Create
    • Budget Create Header Fields
    • General Budget Data
    • Budget Periods
    • Budget Levels
    • Budget Structures
  •  Creating a Budget Structure
    • Creating the Structure Manually in the Grid
    • Creating a Structure using an Excel Hotlink
  •  Topic Properties
    • Linking Topics
    • Budget Versions
  •  Budget Activities
    • Modifying Budgets
    • Copying Budgets
    • Rebuilding Budgets
    • Deleting Budgets
  • Budget Daemon
  • Updating Budget Data
  •  Hands-On Exercises
    • Exercise 1: Create a New Budget using the Excel Hotlink
    • Exercise 2: Create and Copy a Budget
•  Budget Reports
  • Objectives
  • Budget Reports: Definitions
  • Budget Overview Report
  • Budget Detail Report
  •  Hands-On Exercises
    • Exercise 1: Budget Overview
    • Exercise 2: Budget vs Actuals
    • Exercise 3: Budget Detail Report
•  Report Customization
  • Objectives
  • QAD Reporting Framework (QRF)
  • Customizing QRF Reports
  •  Changing QRF Report Settings
    • General Tab
    • Date Tab
    • Decimal Tab
  •  Creating a New Filter
    • Saving the Filter
  • Loading an Existing Filter
  • Maintaining Filters
  •  Crystal Report Variants
    • Managing Filter Fields
    • Report Options
  • Report Variant Reuse
  •  Hands-On Exercises
    • Exercise 1: QRF Customization
    • Exercise 2: SAF Code Report Variant
    • Exercise 3: Customer Account Summary Report Variant
•  Financials Report Writer
  • Overview
  • Benefits
  • Financial Report Writer — Main Features
  • Financial Report Writer Components
  • Harmonized Data in a Report Cube
  • Report Chart and Report Cube
  •  Set Up Financial Report Writer
    • Report Chart of Account Maintenance
    • Create COA Cross References
  •  Hands-On Exercises
    • Exercise 1: Creating a Report COA
    • Exercise 2: Creating Report COA for Different Shared Sets
    • Define Report Cubes
  •  Hands-On Exercise
    • Exercise 3: Creating a Report Cube
  •  Building and Running Reports Process Map
    • Real-Time Update of Report Cube
    • Generate Report Cube Data
    • Building and Running Reports
    • Report Analysis Codes
    • Report Analysis Code Create/Modify
  •  Hands-On Exercise
    • Exercise 4: Creating Report Analysis Codes
    • Report Tree
    • Ways to Create a Report Tree
    • Report Tree for a Sales Report
    • Report Tree Maintenance
    • Report Tree Excel Integration
  •  Hands-On Exercise
    • Exercise 5: Creating a Report Tree
    • Report Column Groups
  •  Hands-On Exercise
    • Exercise 6: Creating Report Columns
    • Report Master Create
  •  Hands-On Exercises
    • Exercise 7: Defining the Report Master
    • Financial Report Run
  •  Budgets in Financial Reports
    • Budget Create, FRW Budget
    • Creating an FRW Budget, Budget Period Tab
    • Creating an FRW Budget, Levels Tab
    • Creating an FRW Budget, Structure Tab
    • FRW Budgets, Additional Steps
    • FRW Report with Budget Column
  •  Report Tree Drill Down
    • Prerequisites for Report Tree Drill Down
    • Report Tree View Create
  •  Report Tree Drill Down
    • Detailed Balances Level
    • Detailed Balances, Total by GL
    • Subtotal by Entity
    • Export Hierarchical Data to Excel
    • Summarize Transactions
    • View for Summarized Transactions
    • Detailed Transactions in Source Entity
•  Allocations
  • Objectives
  • Overview
  •  Allocations
    • Operational Allocations
    • Op Allocation Code Maintenance
    • Financial Allocations
    • Types of Financial Allocations
    • Defining Allocation Structures
    • GL Allocation Create
  • Allocation Transactions
  • Create Allocation Batches
  •  Run Allocation Batch
    • Allocation Batch Execution
  •  Demo Case 1
    • Demo Case 1: Accounts Involved
    • Demo Case 1: Source
    • Demo Case 1: Target Template
    • Demo Case 1: Allocation
    • Demo Case 1: Target Posting
  •  Demo Case 2: Allocate Manufacturing Costs
    • Demo Case 2: Source and Fraction
    • Demo Case 2: Target Template
    • Demo Case 2: Allocation
    • Demo Case 2: Batch Run
    • Demo Case 2: Target Posting
  •  Hands-On Exercises (US)
    • Exercise 1: Constant Value Source
    • Exercise 2: Allocation using WBS Source 10USACO
    • Exercise 3: Proportional Allocation
  •  Hands-On Exercises (EMEA)
    • Exercise 1: Constant Value Source (EMEA)
    • Exercise 2: Allocation using WBS Source (EMEA)
    • Exercise 3: Proportional Allocation (EMEA)
•  COA Mask
  • Objectives
  • Overview
  • Definition
  • Process Map
  • Domain COA Mask Settings
  • COA Element without Mask Setting
  • COA Mask Shared Sets
  • COA Masks and Account Analysis
  • Sub-Account COA Mask
  •  Cost Center COA Mask
    • Assigning Masks
  •  Project COA Mask
    • Assigning Masks
  • COA Mask Implementation Considerations
  • Scenario 1: Complete Sharing
  • Scenario 2: Complete Segregation
  • Scenario 3: Combination of Shared and Segregated
  • COA Mask Validation
  • Validation Example
  • Postings and Validation
  • Hands-On Exercise
•  User-Defined Fields
  • Objective
  • Overview
  • Characteristics of User-Defined Fields
  • Creating a User-Defined Field
  • Adding a User-Defined Field to the UI
  • Adding a User-Defined Field to a Report or View
  • Modifying User-Defined Fields
•  Screen Customization
  • Objectives
  • Scope
  • Screen Customization Prerequisites
  •  General Process Flow
    • Moving Fields to Other Tabs
    • Field Properties
    • Field Properties, Events Tab
  •  Hands-On Exercises
    • Exercise 1: Rearrange Fields in Customer Modify
    • Exercise 2: Make a Field Read-Only
    • Exercise 3: Create a User-Defined Field
    • Exercise 4: Create a Second User-Defined Field
•  Self-Billing
  • Objectives
  • Introduction to Self-Billing
  •  Self-Billing Work Flow
    • Non-Traditional Self-Bill Process
  • Self-Billing Process Map
  • Self-Billing Options
  • Self-Billing—Prerequisite Data
  • Activating Self-Billing
  •  Setting Up Self-Billing for Customers
    • Designate Customer Bank Account for Use with Self-Billing
  • Self-Billing Data
  • Self-Bill Auto Create
  • Self-Bill Auto Create — Workbench
  • Self-Bill Auto Create — Report
  • Importing Self-Bills
  • Self-Bill Maintenance
  • Self-Bill Maintenance — New Self-Bill
  • Self-Bill Maintenance — Modifying an Existing Self-Bill
  • Deleting Self-Bills
  •  Applying Payments to Self-Bills
    • Payment Created by Confirming Self-Bill
  • Reversing Self-Bills
  • Report and Inquiries
•  Consolidation
  • Objectives
  • Overview
  • Consolidation Benefits
  • Current Scope
  •  Key Features
    • Key Features — Continued
  • Consolidation Process
  • Consolidation Hierarchy Example
  •  Consolidation Process Flow
    • Consolidation Steps Detail
  •  Setup Prerequisites
    • Consolidation (Target) Entity
    • Creating COA Cross-References
  • Combined vs Separate GL Dimensions Types
  • Creating a Consolidation Cycle
  • Eliminating Intercompany Transactions from the Consolidation Entity
  • Consolidation Process
  •  Intercompany Elimination Postings
    • Special Considerations for Staged Consolidations
  •  Hands-On Exercises (US)
    • General Information
    • Exercise 1: Consolidation Setup (US)
    • Exercise 2: Consolidation Run (US)
  •  Hands-On Exercises (EMEA)
    • General Information
    • Exercise 1: Consolidation Setup (EMEA)
    • Exercise 2: Consolidation Run (EMEA)
•  Advanced Banking Setup
  • Objectives
  • Business Case
  • Overview
  • Functional Setup Flow
  • Bank File Format Import
  • Transaction Flow
  • Transaction Results
  •  Changing Bank and Payment Format Details
    • Overview
    • Change Own Bank Details on Supplier Payment Selection
    • Payment Format Attribute Restrictions
    • Payment Mass Change
•  Process Incoming Bank Files
  • Objectives
  • Prerequisites
  • Bank File Format Maintain
  • EC Subsystem Definition
  • Electronic Processing
  • Bank Files Process Flow
  •  Loading Files: Document Import
    • Loading Bank Payment Files
  • Loading Files: Session Report
  •  Transactions: Process Incoming Bank Files
    • Processing Incoming Bank Files (31.1.6)
    • Transactions: Process Incoming Bank Files
  • Transaction Results: Processed Customer Payments
  • Examples of Worldwide Bank File Processing
  • US Processing: Lockbox
  •  Lockbox Checks Processing
    • US Bank File: New AR Payments
  • US Bank File: Collected AR Payments
  • Benefits of Lockbox
  • European Processing: SWIFT MT940
  • Demo Scenario