Financials Fundamentals 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
QAD Financials Concepts
Overview
Business Model
Four Levels of Data
Shared Sets
Data Setup Scenario Example
Profiles
Business Relation
Business Relation Hierarchy
Accounting Layers
Accounting Layers and Reporting
Daybooks
GL Account Create
GL Analytical Coding Segments
Supplementary Analysis Fields (SAFs)
Dual Base Currency
Definitions
Example of Dual Base Currency Use
UI Navigation and Browsing
Overview
Login and Welcome Screens
Toolbar
Menu Search: Four Options
Menu Properties
Messaging and Workflow
Creating a Workflow
Favorites
Direct Menu Access: GoTo
Direct Menu Access: Context Menu
Document Linking
Process Maps
Lower-Level Process Maps
Application Integration
XML Integration
XML Integration
Advanced Excel Integration
Browse Export to Excel
Browse Highlights
Browse Features
Rearrange Display
Browse Features
Chart Designer
US and EMEA Exercise: UI Navigation
Setting Up Financial Foundations
Objectives
Overview—Continued
Financial Structure Setup
Currency-Related Data
Shared Set Codes
Shared Set Data Setup
Shared Set Types
Shared Set Data Setup with Profiles
Profiles
Profiles Setup
Profile Types
Accounting Layers
Accounting Layers—Continued
Daybooks
Daybook Process
Daybook Groups
Daybook Groups—Continued
Daybook Create
Operational Daybooks
Default Daybook Maintenance
Daybook Sets
Setting Up AR Daybook Sets
Setting Up AP Daybook Sets
US Exercise: Daybook Setup
EMEA Exercise: Daybook Setup
Domain Creation Process Flow
Domain Create
Link Domain to Shared Sets
Domain-Level Data
Entity Setup
Address-Related Data
Business Relations Setup
Business Relation Create
Business Relation Features
Entity Create
Security Setup
Roles
Users
User Access
Link All Together
Tax Setup: Global Tax Management
Tax Attributes
Credit Terms Data Setup
Invoice Status Codes
Invoice Status Code Attributes
US and EMEA Exercise: Domain Setup
Domain and Entity Creation
Security Setup
Complete the Domain Setup
Other Domain Foundations Setup
Banking Setup
Banking Setup Overview
Setting Up a Bank Account
Bank Payment Formats
Bank Format Setup Flow
Payment Format Maintenance
Customer Setup
Customer Setup Overview
Customer Setup Flow
Customer Setup Details
Customer Data Setup
Customer Type
Customer Credit Rating Code
Mandatory Customer Setup Components
Customer Address Setup
Business Relation Addresses
Customer Create
Customer Ship-To Scenarios
Creating Ship-To Create
Defining End Users
End User Creation Scenarios
End User Create
Modifying a Shared End User Address
Reassigning a Shared End User Address
Managing Customer Credit
US Exercise: Payment Status
EMEA Exercise: Payment Status
US Exercise: Customer Setup
EMEA Exercise: Customer Setup
Sales Process
Overview
Functional Overview
SO Process Flow
Setup Prerequisites: Customer
Business Relation Attributes
Customer Attributes
Setup Prerequisites: Other
Invoicing: Sources of Customer Invoices
Sources of Customer Invoices
Customer Invoicing Process
Key Invoicing Points
US Exercise: Sales Process
EMEA Exercise: Sales Process
AR Process
AR Process Overview
Sales Flow Variants
US Exercise: Sales Flow Variant—Customer Invoice/ Correction Invoice
US Exercise: Sales Flow Variant—Service Fees/Trailer Charges
EMEA Exercise: Sales Flow Variant—Customer Invoice/ Correction Invoice
EMEA Exercise: Sales Flow Variant—Service Fees/Trailer Charges
Customer Invoice Record
General Tab
Address Tab—Key Fields
Financial Info Tab—Key Fields
Operational Tab—Key Fields
CI Posting Tab
Modifiable Customer Invoice Data
US Exercise: Sales Flow Variant—Credit Note
EMEA Exercise: Sales Flow Variant—Credit Note
AR Management Overview
Overview
Credit Management Key Points
Views and Reports
Customer Activity Dashboard
Customer Aging Analysis Current Report
Customer Statement of Account Report
Reminder Letter Report
AR Payments
Customer Payment Instruments
Customer Payment Status Codes
Customer Payment Status Flow
Customer Payment Status Create
Customer Payment Create
Customer Payment—Allocate
Check Payment (Short Flow)
Check Payment (Multiple PIP)
Supplier-Initiated Drafts
Direct Debit
Other Payment Instruments
Finance Charge Key Features
Finance Charge Setup
US Exercise: AR Payment
EMEA Exercise: AR Payment
Deductions
Overview
Business Requirement
Deduction Types
Business Process
Deduction Setup
Creating Deduction Categories
Creating Profiles
Specifying a Customer Deduction Profile
Associating a Profile with a Bank Account
Creating a Deduction Daybook
Exercise: Setting Up Deductions (US and EMEA)
Setting Deduction Credit Terms
Specifying a Deduction Profile for Customers
Creating Deduction Categories
Creating Deductions
Customer Payment Create
Deduction Details
Deduction Transactions
Banking Entry Create and Petty Cash Create
Pending Deductions
Exercise: Recording Deductions (US)
Creating Invoices
Recording Payment and Deductions
Exercise: Recording Deductions (EMEA)
Creating Invoices
Recording Payment and Deductions
Auto Write-Off Deductions
Exercise: Auto Write-Off (US)
Exercise: Auto Write-Off (EMEA)
Reviewing Deductions
Deduction Review
Deduction Status Transitions
Deduction Details, Right-Click Menu
Deduction Review, Deduction Details
Approving Deductions for Write-Off
Approving Deductions for Credit
Rejecting Deductions
Exercises: Deduction Review (US)
Reviewing Deductions
Adjusting a Credit Note against a Deduction
Exercises: Deduction Review (EMEA)
Reviewing Deductions
Adjusting a Credit Note against a Deduction
Deduction Information in Reports
Customer Activity Dashboard
Reporting Overview
Overview
QAD Financials Reports
QAD Reporting Framework (QRF)
QRF History
Reports Converted to QRF
QRF Reports - Selection Criteria
QRF Reports - Viewer
Customizing QRF Reports
QRF Report Settings
QRF Report Filters
User-Defined Fields for QRF Reports
US and EMEA Exercise: QRF Customization
Crystal Reports
Crystal Reports Selection Screen
Crystal Reports Output
Customizing Crystal Reports
Usage Customization—Crystal Reports
Crystal Report Variants
Crystal Report Variants—Continued
Introduction to Financial Report Writer
Benefits
Main Features
Financial Report Writer Components
Supplier Setup
Overview
Supplier Setup Flow
Supplier Setup Details
Mandatory Data for Supplier Setup
Supplier Type
Supplier Setup
US and EMEA Exercise: Invoice Status
Purchasing Process
Overview
Requisition to Shipment Flow
Supplier Invoice Flow
Receiver Matching vs Financial Matching
Supplier Invoice Flows with Invoice Status
US Exercise: Purchasing Process
EMEA Exercise: Purchasing Process
AP Process
Overview
Supplier Invoice Basic Processing Flow
Supplier Invoice Scenarios
Initial Supplier Invoices
Supplier Invoice Template
Supplier Corrections and Credit Notes
Supplier Invoice Reverse, Replace
Update Taxes in Receiver Matching
Allocation Flow
Allocation and Approval: Alternative Flows
US Exercise: Purchasing—Alternative Flows
EMEA Exercise: Purchasing—Alternative Flows
AP Payment Process
AP Payments
AP Payment Flow
Supplier Payment Groups
Checks
AP Check Payment (with PIP)
AP Check Payment (no PIP)
Electronic Transfer
AP Electronic Transfer
Other Payment Instruments
Supplier Payment
Prepayment using Banking Entry
US Exercise: AP Payment—Prepayment
AP Payment Selection
EMEA Exercise: AP Payment—Prepayment
AP Payment—Electronic
AP Reporting
Supplier Activity Dashboard
Supplier Open Item Extended Report
Supplier Aging Analysis Current
Banking Entries
Overview
Banking Flow
Bank Statement Allocation
Bank Statement Allocation Prerequisites
Bank Statement Allocation Menu Flow
Bank Statement Allocation Variants
Bank Statement Updates and Deletion
Banking Entries and Foreign Currency
Bank Statement Related Reports
US Exercise: Banking Entry
EMEA Exercise: Banking Entry
Netting and Open Items
Overview
Open Item Definitions
Reports
Supplier Open Item Extended Report
Netting and Open Item Adjustment
Netting and Open Item Adjustment—Continued
Customer/Supplier Netting
Open Item Adjustment Modify
US Exercise: Netting and Open Item Adjustments
EMEA Exercise: Netting and Open Item Adjustments
GL Open Item Reconciliation
Objectives
Overview
Allocation Key
Process Flow
GL Open Item Reconciliation
Example
GL Open Item Initialization
Reports and Views
GL Open Item View
US and EMEA Exercise: GL Open Item Reconciliation
Exercise 1: Create Journal Entries for GL Open Item Account
Exercise 2: Reconcile Unallocated Transactions on a GL Open Item Account
Exercise 3: Delete a Transient Posting
Exercise 4: Reconcile Allocated Transactions on a GL Open Item Account
Exercise 5: Initialize a GL Open Item Account
General Ledger Setup
Overview
General Ledger Setup Flow
GL Account Structure
GL Account Features
Types of GL Accounts
System Accounts
GL Account Create
Validating Transactions COA Mask
Sub-Account COA Mask
Cost Center COA Mask
Project COA Mask
Sub-Account Features
Cost Center Features
Project Features
Supplementary Analysis Fields (SAFs)
SAF Setup
SAF Example
GL Calendar and GL Periods Setup
Operational Accounting Defaults
US Exercise: Create GL Accounts
EMEA Exercise: Create GL Accounts
GL Period Closing Process
Closing Functionality Overview
Period Status and Period Marks
Period Marks
Application Areas
Period Closing Process Flow
Consistency Checks
Consistency Checks Execute
Consistency Check Results
Period Lock
Lock by Application Areas—Example
Period Report
Period Report—Gateways
Conditions for Period Status Change
GL Calendar Year Closing
Manual Postings to Tax Accounts
Basic Rule
Business Case for Accrual and Payment of Taxes
Possible Approaches
Additional Offset Accounts
Dummy Tax Code
Best Practice: Dummy Tax Code
Set Up Tax Parameters
Tax Parameters
Report on Tax Account Balances
Clear Out Tax Account Balances
Transaction Posting Basics
Overview
Transactions Posting Flow
Journal Entry Posting
Journal Entry Posting Features
Journal Entry Create
Posting Transactions from Operational Modules
Setup Prerequisites
Process Flow
Work Order Posting
Overview
Work Order for Assembly
Setup
Business Case Scenario
Detailed Scenario
Journal Entry View
SAF Code Transaction Detail
Related Views
Foreign Currency Revaluation
Overview
Currency Revaluation Concepts
Currency Conversion
Currency Exchange Rates
Exchange Rate Types
Posting Accounts
Currency Revaluation Setup
GL Account Create, Revaluation Settings
GL Account Create, Revaluation Method
Revaluation Method and Rate
Revaluation Results Analysis Structure
Daybooks
GL Periods
Currency Revaluation Activities
Revaluation Simulate
Revaluation Post
US Exercise: Revaluation
EMEA Exercise: Revaluation
Mirror Accounting
Overview
Business Requirement
Scope
Mirror Accounting Across Versions
Mirror Accounting Flow
Mirror Accounting Setup Flow
Mirror Accounting Setup
Requirements for Execution
Transactions Example
Transaction Example—Split
Exercise: Mirror Accounting (EMEA Only)
General Ledger Transactions
Objective
General Ledger Transactions
GL Transactions Processing Activities
General Ledger Transactions Flow
Journal Entry
Journal Entry Posting Process
Journal Entry Creation
JE Posting: Progressive Disclosure
Progressive Disclosure—Continued
US Exercise: Journal Entry Basics
EMEA Exercise: Journal Entry Basics
Journal Entry Templates
Journal Entry Templates—Continued
Journal Entry Template Flow
Create Template
US Exercise: JE Templates
EMEA Exercise: JE Templates
Reversing Entries
Reversing Entries—Continued
Reversing Entries Process
Correction JE Reversal
Journal Entry Reverse
Reversing Entry Creation Flow
Automatic Reversal of Journal Entries
Reversing Journal Create
US Exercise: Reversing Entries
Automatic Journal Entry Reversal
EMEA Exercise: Reversing Entries
Automatic Journal Entry Reversal
Recurring Entries
Recurring Entries Process
Recurring Entry
Recurring Entry Create/Post
US Exercise: Recurring Entries
EMEA Exercise: Recurring Entries
Intercompany and Cross-Company Postings
Cross-Company vs Intercompany
Intercompany Transactions Process
Cross-Company Transactions Process
Cross-Company Transactions Overview
Concepts
Intercompany Accounts
Cross-Company Transaction Types
Cross-Company Transaction Setup
Setup Requirements
Cross-Company Transaction Example
US Exercise: Cross-Company Posting
EMEA Exercise: Cross-Company Posting
Mass Layer Transfer
Layer Transfer Process
Mass Layer Transfer
Mass Layer Transfer Execute
General Ledger Transaction Reporting
General Ledger Reporting Features
GL Transactions Reports
GL Transaction Report—Example
GL Transactions by Account/Sub-Account Reports—Examples
GL Transactions Views
GL Transactions View Extended
Trial Balance View
Review
US Exercise: Complete Financial Business Flow
EMEA Exercise: Complete Financial Business Flow
Financials Fundamentals Change Summary
General Ledger Transaction Reporting
BReportingJournalModify
BJournalGroupDelete
BCOAMaskDiv
BCOAMaskCC
BCOAMaskProj