Financials Change Summary
Introduction to QAD Financials
User Interface Features
Business Model
Domains
Entities
Shared Sets
Profiles
Business Relations
Multiple Currencies
General Ledger
Supplementary Analysis Fields
Intercompany
Daybooks and Accounting Layers
Other GL Features
General Ledger Transactions
GL Consolidation
COA Cross Reference
Accounts Receivable
Accounts Payable
Evaluated Receipts Settlement
Banking and Cash Management
Budgeting
Financial Reporting
Financial Report Writer
General Ledger Report Writer
Internationalization
Bank Formats
Journal Entries Corrections
Advanced GL Numbering
Specialized Chinese Accounting Practices
Unicode and UTF-8 Code Page
Multiple Languages
Alternate Chart of Accounts (COA)
Setting Up Financial Foundations
Introduction
Data Levels
Setting Up Shared Set Codes
COA Mask Shared Sets
Shared Set Merge
Setting Up Domains
Domain Concepts
Domain Prerequisites
System Domain
Active and Inactive Domains
Domain Code Page
Confirming Domains
Creating and Confirming Domains
General Tab
Shared Sets Tab
Operational Tab
Cross-Company Tab
Invoice Numbering Tab
Changing the Current Domain
Setting Up Profiles
Profile Types
Creating Profiles
Setting Up Entities
General Tab
Shared Sets Tab
Additional GL Numbering Tab
Taxes Tab
Setting Up Multi-Entity Processing
Default System Domain Data
Setting Up Multiple Currencies
Overview
Statutory Currency
Statutory-Currency Utility
Rounding Methods
Currencies
Exchange Rate Types
Exchange Rates
Advanced Exchange Rates
Inventory Exchange Rate
Derived Exchange Rates
Derived Exchange Rate Example 1
Derived Exchange Rate Example 2
Realized Gain/Loss Accounts
Purchase Gain/Loss Accounts
Currency Display
Setting Up General Ledger
Overview
General Ledger Flow
General Ledger Components
Setting Up the Chart of Accounts
GL Account Types
System Accounts
Account Analysis
Creating GL Accounts
Posting Tab
Currency Tab
Analysis Tab
Report Link Tab
Banking Tab
Cash Tab
Defaults Tab
Related Views and Reports
Sub-Accounts
Cost Centers
Projects
Project Groups
Project Statuses
Creating Projects
GL Account Unit of Measure
Alternate Chart of Accounts
Chinese Alternate COA
Creating Alternate COA Groups
Creating an Alternate COA Structure
Copying an Alternate COA Structure
Alternate COA Excel Integration
COA Cross-References
COA Cross-Reference Types
Grid Mapping Options
Creating COA Cross-References
Grid Fields
Search Order for COA Cross-Reference Mappings
COA Cross Reference Excel Integration
Copying COA Cross-References
Validating Accounts
COA Masks
Implementing COA Masks
Sub-Account COA Mask
Cost Center COA Mask
Project COA Mask
COA Mask Validation
COA Mask Copy
COA Mask Browses
COA Mask Excel Integration
GL Implementation Considerations
Supplementary Analysis Fields
System SAF Concepts
User-Defined SAF Concepts
Creating SAF Concepts
Creating SAF Codes
Creating SAF Structures
SAF Defaulting
SAF Reporting and Related Views
Setting Up GL Correction Control
Correction Example
Configuring Transactions in GL Correction Control
Accounting Layers
Transient Layer
Management Layer
Official Layer
Creating GL Layers
Using Daybooks
Daybook Reporting Groups
Defining Daybooks
Financial Daybooks
Operational Daybooks
Defining Default Daybooks
Daybook Security
Defining Daybook Sets
External Daybooks
Modifying Reporting Daybooks
Defining the GL Calendar
Year-End Closing
Period Types
Period Statuses
Application Areas
Defining a Domain GL Calendar Year
Modifying Entity GL Periods
Period Marks
Daybook Masks
Running GL Consistency Checks
Running the Checks
Results
Consistency Checks Report
Reporting a Period
Defining Operational Defaults
Operational Accounting Controls
Domain/Account Control
Setting Up Allocations
Operational Allocation Codes
Financial Allocations
Setting Up Business Relations
Overview
Segregation of Duties
Entity Addresses
E-Mail Notification
Setting Up Base Address Data
Language
Country
State
County
Corporate Group
Address Type
Autonumbering Sequences
Creating Business Relations
Address Information Tab
Tax Information Tab
Contact Persons Tab
General Tab
Defaults Tab
General Data for Customers and Suppliers
Invoice Status Codes
Sample Invoice Status Codes
Creating Invoice Status Codes
Credit Terms
Types of Credit Terms
Creating Credit Terms
Normal Tab
Discount Tab
Staged Payments Tab
Creating Credit Terms with Fixed Due Dates
Prepayment Credit Terms
Deduction Credit Terms
Payment Formats
Payment Format Setup Workflow
SEPA
Payment Format Maintenance
Bank File Format Import
Linking Payment Formats to Bank Accounts
Associating Your Bank with Customers or Suppliers
BLWI Groups
Setting Up Customer Data
Customer Type
Customer Credit Rating
Bank Account Numbers
Creating Customer Records
Business Relation Tab
Accounting Tab
Payment Tab
Banking Tab
Defaults Tab
Credit Limit Tab
Tax Info Tab
Comments Tab
Creating Customer Ship-To Addresses
Creating a New Ship-To Code and Address
Using Another Customer or End-User Address as the Ship-To
Modifying a Shared Ship-To Address
Reassigning a Shared Ship-To Address
Setting an Existing Address as the Ship-To
Deleting a Ship-To
Creating End Users
Creating a New End-User Code and Address
Setting a Ship-To Address as an End User
Setting an Existing Address as an End User
Modifying a Shared End User Address
Reassigning a Shared End User Address
Deleting an End User
Customer Opening Balance
Customer Opening Balance and Invoice Numbering
Setting Up Supplier Data
Supplier Type
Purchase Type
Payment Group
Creating Supplier Records
Business Relation Tab
Accounting Tab
Payment Tab
Banking Tab
Defaults Tab
Tax Info Tab
Comments Tab
Withholding Tax Tab
Supplier Opening Balance
Supplier Opening Balance and Invoice Numbering
Creating Employees
Business Relation Tab
General Ledger Transactions
Overview
GL Transaction Activities
Posting Transactions from Other Modules
Journal Entry
Posting Lines
Currency
Quantity
Intercompany
Cost Center
Project
SAF
GL Open Item
Tax Details
Journal Entry Auto Balancing
Transient Journal Entries
Journal Entries and Daybook Security
Additional GL Numbering
Setting Up Additional GL Numbering
Sequence Number for Posted Transactions
Numbering Date
GL Sequence Renumber Report
GL Numbering Report
Numbering Examples
Verifying and Approving Transactions
Defining Status Transitions
Verifying Transactions
Approving Transactions
GL Open Item Reconciliation
Deallocating an Allocated Item
Viewing Source Transactions
GL Open Item Initialization
GL Open Item Reports and Views
Revaluation
Accounts Subject to Revaluation
Setting Up Revaluation
Revaluation Example
Revaluation Methods and Rates
Revaluation Postings
GL Periods
Simulating Revaluation
Open Item Adjustment
Setting Up Open Item Adjustment
Adjust Open Items
Adjusting Open Items
Allocate GL
Modifying Open Item Adjustments
Viewing Open Item Adjustments
Posting Templates
Creating a Posting Template
Using a Posting Template
Journal Entry Template View
Recurring Entry
Entry Grid
Posting Recurring Entries
Reversing Transactions
Manual Reversal
Automatic Reversal
Modifying Reversing Journal Entries
Deleting Reversing Journal Entries
Running Allocations
Defining Allocation Batches
GL Allocation Batch Run
Proportional Fraction Allocation Example
Mass Layer Transfer
Mass Layer Transfer for Periodic Costing
Intercompany and Cross-Company Transactions
Intercompany Transactions
Cross-Company Transactions
Daybook Security and Cross-Company Postings
Journal Entry Excel Cross-Company Integration
Downloading the Template
Journal Entry Levels
Importing from Excel
Validation
Defaulting
Mirror Accounting
Triggering Mirror Accounting Using Analysis
Setting up Mirror Accounting
Defining Source and Mirror Accounts
Mirror Accounting Report
Year-End Transactions
Set Up Year-End Closing
Year-End Closing Checks
Running Year-End Closing
Records and Postings
Validation Reports
Exporting Accounting Data
Specifying Export Destination
Accounting Data Export
Reviewing Posted Transactions
GL Transactions View Extended
Trial Balance View
Accounts Receivable
Overview
Customer Invoices
Deductions
Customer Invoice Functions
Sales-Related Invoices
Draft Customer Invoices
Creating Customer Invoices
Navigating Customer Invoice Create
General Tab
Addresses Tab
Financial Info Tab
Operational Info Tab
Tax Tab
CI Posting Tab
Comments Tab
Suspended Tax on Customer Invoices
Invoice Certification
Shipment Certification
Setting Up Invoice Certification
Generating the Signatures
Viewing the Signatures
Exporting the Signatures
Processing Receivables
Customer Payments
Setting Up Customer Payments
Customer Payment Instruments
Customer Payment Statuses
Payment Processing Examples
Credit Card Payments
Creating Customer Payment Status Codes
Creating Customer Payments
Allocating a Customer Payment
Creating a Deduction
Creating a Prepayment
Customer Payments and Open Items
Allocation Discounts
Allocation and Currencies
Modifying Customer Payments
Modifying Bank Details on a Customer Payment
Customer Payment Mass Change
Creating Customer Payment Selections
Customer Payment Selection Modify
Customer Payment Selection View
Customer Payment Selection Execute
Printing Customer Payments
Processing Deductions
Setting Up Deductions
Creating and Modifying Deductions
Reviewing Deductions
Changing the Status of a Payment with Deductions
Collecting Receivables
Managing Customer Credit
Maintaining Credit Limit
Credit Limits and Invoice Status Codes
Credit Reporting and Views
Customer Activity Dashboard
Credit Details Tab
Activities Tab
Invoices Tab
Payments Tab
Comments Tab
Realized Gain and Loss
Reminding Customers of Outstanding Balances
Reminder Levels
Selecting Customers for the Reminder Letter
Sample Reminders
Finance Charges on Overdue Payments
Calculating Finance Charges
Draft Finance Charges
Customer Aging Reports
Customer Aging Analysis Current Report
Customer Aging History Across Domains Report
Customer Aging By Bill History Report
Self‑Billing
Overview
Reviewing Traditional Self-Billing
Customer-Initiated Payments
Self-Bill Documents
Self-Billing Programs
Preparing to Use Self‑Billing
Setting Up Customers
Capturing Self-Billing Data
Creating Self‑Bills
Using Self Bill Auto Create
Maintaining Self-Bills
Importing Self-Bills
Creating a Self-Bill in Self-Bill Maintenance
Working with Self-Bill Lines
Matching Adjustment Self-Bill Lines
Deleting Self-Bills
Confirming Self-Bills
Using Self-Bill Confirm
Unconfirming Self-Bills
Self-Billing Reports and Inquiries
Self-Bill Report
Invoice AR Balance Report
Self-Bill Discrepancy Report
Shipment-Invoice Cross-Reference Report
Self-Bill Delete/Archive
Customer Billing
Overview
Customer Billing Screens
Financial Holiday Maintenance
Customer Billing Workflow
Billing Schedule Create
Billing Schedule View
Billing Schedule Modify
Billing Schedule Delete
Linking Billing Schedules To Customers
Set Bill Date
Bill Create
Bill View
Bill Modify
Bill Delete
Bill Print
Recording Bill Payments
Accounts Payable
Overview
Supplier Invoices
Receiver Matching
Financial Matching
Releasing Invoices for Payment
Supplier Invoice Functions
Using the Scan Daemon to Create Invoices
Supplier Invoice Control Settings
Invoice Allocation and Approval
Types of Supplier Invoice
Supplier Invoice Create
Navigating Supplier Invoice Create
General Tab
Addresses Tab
Financial Info Tab
Tax Tab
SI Posting Tab
Matching Posting Tab
Withholding Tax Tab
Modifying a Supplier Invoice
Financial Matching and Daybook Security
Delayed Tax
Allocating, Approving, and Releasing for Payment
Allocating Supplier Invoices
Approving Supplier Invoices
Supplier Invoice Status Activities
Reversing and Replacing Supplier Invoices
GL Correction Control Settings
Attachments and Workflow
Supplier Invoice Reverse
Replacing Supplier Invoices
Creating Initial Supplier Invoices
Modifying an Initial Invoice
Receiver Matching
System Effects of Matching
Matching Postings
Cross-Company Postings
Partial Matching
Variances
Cost Updates
Intrastat Updates
Foreign Currency PO Receipts
Tax Calculation During Matching
Reversing Tax Postings after Recalculation
Types of Receiver
Managing the Matching Process
Using Invoice Status Codes
Matching Standard Invoices to Receivers
Standard Invoices and Taxes
Matching Initial Invoices to Receivers
Initial Invoices and Taxes
Matching Logistics Supplier Invoices to Pending Invoices
Starting Receiver Matching
Receiver Matching Create
Pro-Rating of Logistics Charges
Matching Grid
Manual Posting
Update Invoice Amount
Modifying Receiver Matching
Receiver Matching and Daybook Security
Sample Matching Postings
PO for Inventory Item with Tax Accrued at Receipt
PO for Inventory Item with Rate Variance
PO for Inventory Item with Rate and Usage Variance
PO for Inventory Item with Tax Rate Change
Matching Accrued Duty and Freight for a PO Receipt
Matching an Accrued Freight Pending Invoice
Statutory Currency and Receiver Matching
Payables
Other AP Functions
Supplier Payments
Supplier Payment Instruments
Setting Up Supplier Payments
Supplier Payment Statuses
Creating Supplier Payment Status Codes
Creating Supplier Payment Groups
Creating Supplier Payments
Modifying Bank Details on a Supplier Payment
Supplier Payment Mass Change
Supplier Payment Selections
Payment Selection Processing Examples
Creating Supplier Payment Selections
Creating a Prepayment on a Payment Selection
Changing Bank Accounts on a Payment Selection
Changing Payment Attributes on a Selection
Changing Payment Formats and Supplier Invoices
Changing Payment Formats and Supplier Records
Supplier Payment Selection Confirm
Supplier Payment Selection Unconfirm
Supplier Payment Selection Execute
Supplier Payment Selection Re-execute
AP Bank Charges
Setting Up AP Bank Charges
Paying an Invoice Subject to Bank Charges
Realized Gain and Loss
Printing Supplier Payment Instruments
Printing Supplier Checks
Printing and Voiding Supplier Checks
Supplier Activity Dashboard
Summary Tab
Activity Tab
Invoices Tab
Payments Tab
Comments Tab
Supplier Reports
Supplier Invoice Register Report
Aging Reports
Evaluated Receipts Settlement
Introduction
Benefits of ERS
Set Up ERS
Run ERS Conversion
Set Up ERS Control
Set Up ERS for Suppliers, Sites, and Items
ERS and Ordering
Purchase Orders with ERS
Blanket Orders with ERS
Scheduled Orders with ERS
ERS-Eligible Shipper Receipts
Receiving a Purchase Order with ERS
ERS and Fiscal Receiving
ERS Processor
Processor Flow for Receipts
Invoice Status Code
Process Flow for Legal Documents
ERS and PO Returns for Legal Documents
ERS and Reversing Legal Documents
ERS and Tax Calculation
ERS Postings
Multiple Sites and Entities
ERS Audit Report
ERS Invoice Certification
ERS Fields Summary
Banking and Cash Management
Overview
Set Up Banking
Using Banking Functions
Electronic Processing
EDI Advanced Banking for Accounts Receivable
Petty Cash
Cash Flow Reporting
Banking Setup
Define Bank Account Formats
Define Own Bank Number
Using Banking Functions
Bank Statements and Banking Entries
Creating Bank Statements
Allocating Statement Lines
Posting Bank Statements
Banking Entry
Banking Entry Create Function
Banking Entry Flow
Allocating Bank Entry Lines
Allocate to Invoice
Currency Details
Allocate as a Prepayment
Allocate to Payment Selection
Allocate to Payment
Allocate to GL Account
Reference Details
Value Details
Realized Gains and Losses in Banking Entry
Banking Entry Allocate
Electronic Banking Setup
Bank File Format Import
Linking Payment Formats to Bank Accounts
Mapping Transaction Codes
Check Bank File Extensions
Electronic Processing
Loading Bank Files
Processing Incoming Bank Files
Process Incoming Bank Files Function
Errors in Transaction Processing
Multiple Invoice Lines
New AR Payments
Processing Existing AR Payments
Processing Existing AP Payments
Imported Bank File Report
EDI Advanced Banking for Accounts Receivable
Setting Up Interest Accounts
Creating a Payment Selection with the Initial Status
Sending Notification to the Bank
Receiving Confirmation or Rejection from the Bank
Modifying Executed Payment Selections
Receiving Instructions
Receiving Payment Notification from the Bank
Posting Interest and Discount Amounts
Customer Payment Selection Extended View
EDI Advanced Banking for Accounts Payable
Updating the Supplier Payment Reference
Scanning the Boleto Bancário Barcode
Updating the Interest Amount Manually
Posting the Interest
Viewing the Interest
Notifying the Bank of Interest and Stage Details
Using Petty Cash
Petty Cash Create
Setting Up Petty Cash
Creating Cash Entries
Petty Cash Options
Petty Cash Allocate
Cash Flow Reporting
Creating Cash Groups
Creating Cash Reports
Budgeting
Overview
Report Structures, Allocations, and Financial Report Writer
Setting Up Budgets
Budget Groups
Budget Report Periods
Creating Budgets
General Tab
Budget Period Tab
Levels Tab
Structures Tab
Defining Topic Properties
Versions Tab
Budget Activities
Modifying Budgets
Copying Budgets
Rebuilding Budgets
Linking with Excel
Budget Reports
Budget Overview
Budget Detail
Consolidation
Overview
Consolidation and Currency Translation
Setting Up Consolidation
Creating COA Cross-References
Creating a Consolidation Cycle
Consolidation Cycle and Daybook Security
Consolidation Period Cross-Reference
Set Up Intercompany Eliminations
Creating a Consolidation
Consolidation Cycle List
Reporting
Intercompany Elimination Postings
Special Considerations for Staged Consolidations
Consolidation Period Closing View
Financial Reports
Overview
Reporting Framework
Financial Report Writer
GL Reports
Report Detail
Master Data Reports
GL Transaction Activity Reports
GL Transaction Activity Views
Analytical Transaction Reports
Analytical Transaction Views
GL Closing Reports
Accounts Receivable Reports
Customer Reports
Self-Billing Reports
Customer Views
Accounts Payable Reports
Supplier Activity Reports
Receiver Matching Reports
Supplier Views
Banking and Cash Management Reports
Financial Statements
Running the QRF Version of a Report
Running QRF Reports
QRF Scheduling
Customizing QRF Reports
Settings
Filters
Adding User-Defined Fields to Financials QRF Reports
Customizing Crystal Reports
Changing Crystal Report Settings and Defaults
Server Output Processing
Running the Crystal Version of a Report
Report Schedule
Report Execute
Regional Report Settings
Report Daemon
Structured Reports
Creating a Report Structure
System Accounts
Executing Structured Reports
Financial Report Writer
Overview
Financial Report Writer Concepts
Financial Report Writer versus Consolidation
Setting Up Financial Report Writer
Setting Up the Report Chart
Setting Up COA Cross-References
Define Report Cube
Generating Cubes
Cube Trial Balance View
Cube Daemon
Report Analysis Codes
Report Analysis Code Example
Create a Report Analysis Code
Other Report Analysis Code Functions
Report Trees
Report Tree Maintenance
Report Tree Excel Integration
Creating the Excel File
Importing from Excel
Exporting to Excel
Report Column Group
Moving and Resequencing Columns
Calculations using a Report Analysis Code
Maintaining Report Masters
Financial Report Run
Using Budgets in Financial Reports
Designing a Budget Structure
Creating a Budget
Financial Report Analysis
Report Tree View Create
Report Tree Drill Down
General Ledger Report Writer
Introduction
Implementing GL Report Writer
Create GL Accounts
Set Range of Periods
Define Reporting Units
Rounding Methods
Set Up Control Settings
Synchronize Tables
Set Security
Setting Up Report Components
Planning Reports
Analysis Codes
Row Groups
Creating Text Rows
Creating Data Rows
Creating a Calculation Row
Print Control in Rows
Column Groups
Creating an Actual Column
Creating a Budget Column
GLRW Budgets
Creating GLRW Budget Data
Deleting GLRW Budgets
Calculating GLRW Budgets
Defining Reports
Using Controlling Hierarchies
Using Global Queries
Titles and Footers
Report Base Period Maintenance
Running Reports
Checking Reports for Errors
Invalid Formulas
Content Detail
Redundant Components or Omissions
Managing Report Images
Product Information Resources
Financials Change Summary
Product Information Resources
SharedSetCreate
BSharedSetMerge
DomainCreate
ProfileCreate
EntityCreate
RoundingMethodCreate
CurrencyCreate
ExchangeRateTypeCreate
ExchangeRateCreate
ExchangeRateDerive
GLAccountCreate
SubAccountCreate
CostCenterCreate
ProjectGroupCreate
ProjectStatusCreate
ProjectCreate
GLAccountUMCreate
BAltCOAGroup
BAltCOAStruct
BCOACrossRef
BCOAMaskDiv
BCOAMaskCC
BCOAMaskProj
BCOAMaskDivCopy
BCOAMaskCCCopy
BCOAMaskProjCopy
COAMaskGOTOCOAMaskAll
SAFConceptCreate
SAFCodeCreate
SAFStructureCreate
LayerCreate
BJournalGroupCreate
BJournalGroupDelete
DaybookCreate
BReportingJournalModify
DomainGLPeriodCreate
EntityGLPeriod
PeriodMarkView
GLAllocation
Language
Country
State
County
CorporateGroup
AddressType
BusinessRelationAutonumber
Autonumber
BusinessRelationCreate
InvoiceStatusCode
CreditTerms
PaymentFormatMaintenance
BLWIGroup
CustomerType
CustomerCreditRating
BankNumExcelInt
CustomerCreate
CustomerShipTo
EndUser
CustomerOpeningBalanceCreate
SupplierType
PurchaseType
SupplierPaymentGroup
SupplierCreate
SupplierOpeningBalance
EmployeeCreate
JournalEntryCreate
JETransient
VerifyStatusTransitionMaintain
ApprovalStatusTransitionMaintain
JournalEntryVerify
JournalEntryApprove
Revaluation
RevaluationPost
RecurringEntry
RecurringEntryPost
JETransientReverse
AutoReversalCreate
GLAllocationBatch
GLAllocationBatchRun
MassLayerTransferExecute
MirrorDaybook
MirrorAccounting
YearEndClosing
GLGOTOPostingLineSelectExt
GLGOTOTrialBalanceSelect
CustomerPaymentStatusCreate
CustomerPaymentCreate
CustomerPaymentStatusChange
CustomerPaymentSelectionCreate
CustomerPaymentSelectionExecute
CreditLimitMaintain
CustomerActivityDashboard
FinanceChargeCreate
CustomerInvoiceCreate
SupplierInvoice
SupplierInvoiceApprove
SIReleaseforPayment
SIPrepareAllocation
SupplierInvoiceAllocate
SupplierInvoiceReverseReplace
SupplierInvoiceReverse
SupplierInvoiceReplace
SupplierInvoiceInitial
ReceiverMatching
SupplierPayStatus
SupplierPayment
SupplierPayMassChange
SupplierPaySel
SupplierPaySelConfirm
SupplierPaySelExec
SupplierPaySelReExec
SupplierActivityDashboard
BERSProcessor
BankAccountFormatMaintain
BankingEntryCreate
BankingEntryAllocate
BankPaymentFormatLink
BankFileFormatMaint
ProcessBankFiles
PettyCashCreate
CashGroup
CashFlowReportCreate
BudgetGroupCreate
ReportingPeriodCreate
BudgetCreate
BudgetCopy
ConsolidationCycle
ConsolidationCreate
ConsCycleList
ConsolidationPeriodCrossReference
ConsolidationGLCrossReference