General Ledger Setup > Supplementary Analysis Fields (SAFs)
  PPT
Supplementary Analysis Fields (SAFs)
The system provides sub-account, cost center, project, and SAF analysis to be used for additional analytical reporting on transactions. SAF analysis is optional, but lets you create detailed views of data.
Using SAFs, you can analyze a single account in many different ways by filtering based on the SAF codes included in the postings to the account. A carefully planned set of SAF structures avoids the need to set up separate COA elements for individual reporting.
SAF analysis can be applied to all standard GL accounts, except for bank, closing, and tax accounts. SAF analysis is not supported for system accounts, except for Purchase Order Receipts. You can apply SAF analysis to both revenue and expenses, and you would normally create a separate SAF structure for each of these types of transaction.
SAF Setup
SAF analysis is managed through a combination of three elements:
SAF concepts identify the type of analysis required.
SAF codes define the analysis details. Associate the codes with an existing concept.
SAF structures contain a selection of concepts in a logical sequence.
You associate the structure with a GL account, cost center, or project.
Seven SAF concepts are predefined and provided with the system. The predefined SAF concepts are designed to interact with operational transactions, and capture key analysis details used to report the GL effects of operations such as sales by region, sales to OEM customers, or work orders by item type.
The following system concepts are provided:
Product Line
This concept captures values created in Product Line Maintenance (1.2.1) and associated with items used in operational transactions.
Site
This concept captures values created in Site Maintenance (1.1.13) and associated with items involved in operational transactions.
Item Type
This concept captures generalized code values created in Generalized Codes Maintenance (36.2.13) and associated with items in Item Master Maintenance (1.4.1) when those items are used in operational transactions.
Item Group
This concept captures generalized code values created in Generalized Codes Maintenance (36.2.13) and associated with items in Item Master Maintenance (1.4.1) when those items are used in operational transactions.
Region
This concept captures generalized code values created in Generalized Codes Maintenance (36.2.13) and associated with customers in Customer Data Maintenance (2.1.1) when those customers are referenced on operational transactions.
Customer Type
This concept captures codes created in Customer Type Create (27.20.4.1) and associated with customers in Customer Create (27.20.1.1) when those customers are referenced on operational transactions.
Supplier Type
This concept captures codes created in Supplier Type Create (28.20.4.1) and associated with suppliers in Supplier Create (28.20.1.1) when those suppliers are referenced on operational transactions.
While the system concepts are specifically designed to capture the details of operational transactions, you can use a combination of system- and user-defined concepts in the same structure, if required.
System concepts cannot be deleted, but can be disabled by clearing the Active field. Data is captured for a concept only when it is active. Since system concepts have a predefined meaning, you cannot modify other fields in the concept or create new system concepts.
Creating SAF Concepts
Use the SAF Concept activities (25.3.7.1) to create, view, modify, and delete SAF concepts. Changing concepts has the following restrictions:
You cannot delete a system SAF concept. You cannot delete a user-defined SAF concept if it has already been used in a transaction.
You cannot create system concepts.
The only value you can modify for a system concept is the Active setting.
You cannot deactivate a concept if it is linked to an active SAF structure.
Creating SAF Codes
Use the SAF Code Activities (25.3.7.2) to create the values that you assign to an SAF concept. SAF codes generally correspond to the individual item that requires analysis. For example, you can track transactions relating to a particular vehicle belonging to the organization by creating an SAF code of the vehicle registration number.
Every SAF concept must have at least one default SAF code, defined in the SAF structure where it is used; you can link any number of codes to the same concept.
Build SAF analysis for an account by creating an SAF code for each type of transaction that updates the account.
Creating SAF Structures
Use SAF Structure activities (25.3.7.4) to combine up to five SAF concepts in a sequence. You then link the structure to general ledger accounts, cost centers, or projects. You can only associate one SAF structure with a GL account, cost center, or project.
When an SAF structure is associated with a project, cost center, or GL account and a transaction updates that element, the SAF concepts and default codes are displayed in the transaction posting lines.
For system concepts based on operational transactions, values are retrieved automatically.
When user-defined concepts have more than one value, you must select the value to use when you create the transaction.
SAF structures are independent of the entity and domain, and can contain both system and user-defined concepts.
Each structure must contain a minimum of one concept, up to a maximum of five concepts. Each concept must have one and only one default value, which is used to supply a value based on the defaulting logic. Other defaults are optional, but the one associated with the structure is required and used when more specific defaults have not been defined.
After an SAF structure has been used in a transaction, you cannot delete any of the associated SAF concepts.
SAF Reporting and Related Views
The following reports provide detailed and summarized information on transactions, filtered by specific SAF codes or concepts.
SAF Code Transactions Detail (25.15.3.6)
SAF Code Transactions Summary (25.15.3.5)
The Transactions by SAF Related View (25.15.4.4) gives an on screen summary of transactions filtered by SAF code.
SAF Example
The example shows a work order material variance posting and the SAF information carried for the item, product line, and site.
This example is discussed in more detail in Chapter 19, “Work Order Posting” on page 489.
GL Calendar and GL Periods Setup
The financial calendar consists of user-defined GL calendar years and GL periods.
By default, the GL calendar year consists of twelve monthly GL periods. Each GL period does not have to correspond to a calendar month. You can define custom start and end dates for each GL period to correspond with your accounting cycles, and the GL calendar year can exceed twelve calendar months in length. The GL calendar year is defined at the domain level; all entities within a domain use the same GL calendar year definition.The system contains two functions related to GL calendars and periods:
Use Domain GL Period activities (25.4.1.1) to create, modify, and view the GL calendar year and its related GL periods for a specific domain. The GL periods defined at the domain level are copied to all entities linked to the current domain.
Entity GL Period activities (25.4.2) let you apply GL period settings to individual entities and lets you lock, unlock, report, and undo reporting for GL periods per entity. We will learn about this function in more detail in a separate section of this training class.
Two other system functions can be used to define specialized calendars:
Use Tax Period Create (25.4.5.1) to define entity-based calendars for tax reporting periods. When defined, closing a tax period prevents additional tax transactions from being posted.
Use Budget Report Period Create (25.4.5.1) to define reporting periods used within the budgeting area. The Budget functionality is discussed in detail in Training Guide: QAD Advanced Financials.
Operational Accounting Defaults
As part of the initial system implementation, set up values in the various control programs on the Operational Acct Controls menu (36.9). The settings in each control program affect operations within a specific business area. Typically, these settings represent a subset of all the settings that affect the related business area. These control settings have been separated because they have a financial effect on all modules, and should be defined only by a financial analyst with security access to this function.
This separation facilitates the segregation of responsibility so that financial personnel can manage the settings that reflect financial and accounting decisions
US Exercise: Create GL Accounts
1 Log in to 10USACO and create the following GL accounts using GL Account Create (25.3.13.1).
The GL Account Create fields are listed in the leftmost column.
The subsequent columns list the field values for each GL account to create.
 
General
 
 
 
 
 
GL Account
1000
1250
1505
1675
2100
GL Description
Petty cash USD
Current Bank GBP
Sundry Inventory
Sundry transfers
Suppliers Exp notes
GL Type
Cash
Bank
Inventory Control
Open items
Supplier control
System Type
 
 
 
 
 
Active
Yes
Yes
Yes
Yes
Yes
Budget Group
 
 
 
 
 
Budget Enabled
Yes
Yes
Yes
Yes
Yes
Category
Asset
Asset
Asset
Asset
Liability
Postings Tab
 
 
 
 
 
Balance/P&L
Balance
Balance
Balance
Balance
Balance
Debit/Credit
Debit
Debit
Debit
Debit
Credit
Auto/Manual
Manual
Manual
Auto
Manual
Auto
Intercompany Account
No
No
No
No
No
Default Intercompany
 
 
 
 
 
Fixed Intercompany
 
 
 
 
 
Quantity
No
No
No
No
No
GL Account Unit of Measure
 
 
 
 
 
Currency Tab
 
 
 
 
 
Base Currency Only
 
 
 
 
 
Currency Code
USD
GBP
 
 
 
Revaluation GL
 
 
 
 
 
TC Revaluation in BC
None
Revaluation Rate
None
None
None
Rate Type for Revaluation in BC
 
 
 
 
 
TC Revaluation in SC
None
Revaluation Rate
None
None
None
Rate Type for Revaluation in SC
 
 
 
 
 
Consolidation Method
Current exchange Rate
Current exchange rate
Current exchange rate
Current exchange rate
Current exchange rate
Exchange Rate Type
 
 
 
 
 
Analysis Tab
 
 
 
 
 
Sub-Account Analysis
No
No
No
No
Yes
Default Sub-Account
 
 
 
 
DefSubAct
Cost Center Analysis
No
No
No
No
No
Project Analysis
 
No
No
No
No
No
Analysis Limitation
None
None
None
None
None
Default Cost Center
 
 
 
 
 
Default Project
 
 
 
 
 
Default SAF Structure
 
 
 
 
 
SAF Analysis
No
No
No
No
No
SAF Structure Code
 
 
 
 
 
Report Link Tab
 
 
 
 
 
GL Account
 
 
 
 
 
Shared Set Code
 
 
 
 
 
GL Description
 
 
 
 
 
Banking Tab
 
 
 
 
 
Entity Code
 
10USACO
 
 
 
Default
 
Yes
 
 
 
Bank Format
 
XX
 
 
 
Bank Account No
 
99887766
 
 
 
Business Relation Code
 
 
 
 
 
Active
 
Yes
 
 
 
SWIFT Code
 
 
 
 
 
Branch
 
 
 
 
 
Own GL Account
 
 
 
 
 
Banking Daybook Profile
 
BEGBP
 
 
 
Deduction Daybook Profile
 
DedDaybookProfile
 
 
 
AP Discount Account
5700
5700
 
 
 
AR Discount Account
4220
4220
 
 
 
Cash Tab
 
 
 
 
 
Cash Recv Daybook Profile
CASHIN
 
 
 
Cash Paid Daybook Profile
CASHOUT
 
 
 
General
 
 
 
 
GL Account
2402
2525
4050
7100
GL Description
Sundry sales tax
PO receipt non inventory
Sundry sales
Training expenses
GL Type
Tax
System
Standard
Standard
System Type
 
PO receipt
Active
Yes
Yes
Yes
Yes
Budget Group
 
 
 
 
Budget Enabled
Yes
Yes
Yes
Yes
Category
Liability
Liability
Income
Expense
Postings Tab
 
 
 
 
Balance/P&L
Balance
Balance
P&L
P&L
Debit/Credit
Credit
Credit
Credit
Debit
Auto/Manual
Manual
Auto
Manual
Manual
Intercompany Account
No
No
Yes
Yes
Default Intercompany
 
 
10-USA-CO
10-USA-CO
Fixed Intercompany
 
 
 
 
Quantity
No
No
No
Yes
GL Account Unit of Measure
 
 
 
HRS
Currency Tab
 
 
 
 
Base Currency Only
 
 
 
 
Currency Code
 
 
 
 
Revaluation GL
 
 
 
 
TC Revaluation in BC
None
None
None
None
Rate Type for Revaluation in BC
 
 
 
 
TC Revaluation in SC
None
None
None
None
Rate Type for Revaluation in SC
 
 
 
 
Consolidation Method
Current exchange rate
Current exchange rate
Current exchange rate
Current exchange rate
Exchange Rate Type
 
 
 
 
Analysis Tab
 
 
 
 
Sub-Account Analysis
No
No
Yes
Yes
Default Sub-Account
 
 
DefSubAct
DefSubAct
Cost Center Analysis
No
No
Yes
Yes
Project Analysis
 
No
No
Yes
Yes
Analysis Limitation
 
 
Excluding each Other
Excluding each Other
Default Cost Center
 
 
Adm
Adm
Default Project
 
 
 
 
Default SAF Structure
 
 
Sales
 
SAF Analysis
No
No
No
No
SAF Structure Code
 
 
 
 
Report Link Tab
 
 
 
 
GL Account
 
 
 
 
Shared Set Code
 
 
 
 
GL Description
 
 
 
 
Banking Tab
 
 
 
 
Entity Code
 
 
 
 
Default
 
 
 
 
Bank Format
 
 
 
 
Bank Account No
 
 
 
 
Business Relation Code
 
 
 
 
Active
 
 
 
 
SWIFT Code
 
 
 
 
Branch
 
 
 
 
Own GL Account
 
 
 
 
Banking Daybook Profile
 
 
 
 
Deduction Daybook Profile
 
 
 
 
AP Discount Account
 
 
 
 
AR Discount Account
 
 
 
 
Cash Tab
 
 
 
 
Cash Received Daybook Profile
 
 
 
 
Cash Paid Daybook Profile
 
 
 
 
EMEA Exercise: Create GL Accounts
1 Change domain to 22UK -> 22UKCO and create the following GL accounts.
The GL Account Create fields are listed in the leftmost column.
The subsequent columns list the field values for each GL account to create.
 
General
 
 
 
 
 
GL Account
12000
12250
30005
35075
15010
GL Descriptions
Petty cash GBP
Current Bank EUR
Sundry Inventory
Sundry transfers
Suppliers Exp notes
GL Type
Cash
Bank
Inventory
Open item
Supplier control
System Type
 
 
 
 
 
Active
Yes
Yes
Yes
Yes
Yes
Budget Group
 
 
 
 
 
Budget Enabled
Yes
Yes
Yes
Yes
Yes
Category
Asset
Asset
Asset
Asset
Liability
Posting Tab
 
 
 
 
 
Balance/P&L
Balance
Balance
Balance
Balance
Balance
Debit/Credit
Debit
Debit
Debit
Debit
Credit
Auto/Manual
Manual
Manual
Auto
Manual
Auto
Intercompany Account
No
No
No
No
No
Default Intercompany
 
 
 
 
 
Fixed Intercompany
 
 
 
 
 
Quantity
No
No
No
No
No
GL Account UM
 
 
 
 
 
Currency Tab
 
 
 
 
 
Base Currency Only
 
 
 
 
 
Currency Code
GBP
EUR
 
 
 
Revaluation GL
 
 
 
 
 
TC Revaluation in BC
None
Revaluation Rate
None
None
None
Rate Type for Revaluation in BC
 
 
 
 
 
TC Revaluation in SC
None
Revaluation Rate
None
None
None
Rate Type for Revaluation in SC
 
 
 
 
 
Consolidation Method
Current exchange Rate
Current exchange rate
Current exchange rate
Current exchange rate
Current exchange rate
Exchange Rate Type
 
 
 
 
 
Analysis Tab
 
 
 
 
 
Sub-Account Analysis
No
No
No
No
Yes
Default Sub-Account
 
 
 
 
DefSubAct
Cost Center Analysis
No
No
No
No
No
Project Analysis
 
No
No
No
No
No
Analysis Limitation
None
None
None
None
None
Default Cost Center
 
 
 
 
 
Default Project
 
 
 
 
 
Default SAF Structure
 
 
 
 
 
SAF Analysis
No
No
No
No
No
SAF Structure Code
 
 
 
 
 
Report Link
 
 
 
 
 
GL Account
 
 
 
 
 
Shared Set Code
 
 
 
 
 
GL Description
 
 
 
 
 
Banking
 
 
 
 
 
Entity Code
 
22UKCO
 
 
 
Default
 
Yes
 
 
 
Bank Format
 
XX
 
 
 
Bank Account No
 
888777
 
 
 
Business Relation Code
 
 
 
 
 
Active
 
Yes
 
 
 
SWIFT Code
 
 
 
 
 
Branch
 
 
 
 
 
Own GL Account
 
 
 
 
 
Banking Daybook Profile
 
BEEUR
 
 
 
Deduction Daybook Profile
 
DedDaybookProfile
 
 
 
AP Discount Account
5700
5700
 
 
 
AR Discount Account
4220
4220
 
 
 
Cash
 
 
 
 
 
Cash Recv Daybook Profile
CASHIN
 
 
 
Cash Paid Daybook Profile
CASHOUT
 
 
 
General
 
 
 
 
GL Account
17102
19625
80500
41000
GL Description
Sundry sales tax
PO receipt non inventory
Sundry sales
Training expenses
GL Type
Tax
System
Standard
Standard
System Type
 
PO receipt
Active
Yes
Yes
Yes
Yes
Budget Group
 
 
 
 
Budget Enabled
Yes
Yes
Yes
Yes
Category
Liability
Liability
Income
Expense
Posting Tab
 
 
 
 
Balance/P&L
Balance
Balance
P&L
P&L
Debit/Credit
Credit
Credit
Credit
Debit
Auto/Manual
Manual
Auto
Manual
Manual
Intercompany Account
No
No
Yes
Yes
Default Intercompany
 
 
22UKCO
22UKCO
Fixed Intercompany
 
 
 
 
Quantity
No
No
No
Yes
GL Account UM
 
 
 
HRS
Currency Tab
 
 
 
 
Base Currency Only
 
 
 
 
Currency Code
 
 
 
 
Revaluation GL
 
 
 
 
TC Revaluation in BC
None
None
None
None
Rate Type for Revaluation in BC
 
 
 
 
TC Revaluation in SC
None
None
None
None
Rate Type for Revaluation in SC
 
 
 
 
Consolidation Method
Current exchange rate
Current exchange rate
Current exchange rate
Current exchange rate
Exchange Rate Type
 
 
 
 
Analysis Tab
 
 
 
 
Sub-Account Analysis
No
No
Yes
Yes
Default Sub-Account
 
 
DefSubAct
DefSubAct
Cost Center Analysis
No
No
Yes
Yes
Project Analysis
 
No
No
Yes
Yes
Analysis Limitation
None
None
Excluding each other
Excluding each other
Default Cost Center
 
 
Adm
Adm
Default Project
 
 
 
 
Default SAF Structure
 
 
Sales
 
SAF Analysis
 
 
 
 
SAF Structure Code
 
 
 
 
Report Link
 
 
 
 
GL Account
 
 
 
 
Shared Set Code
 
 
 
 
GL Description
 
 
 
 
Banking Tab
 
 
 
 
Entity Code
 
 
 
 
Default
 
 
 
 
Bank Format
 
 
 
 
Bank Account No
 
 
 
 
Business Relation Code
 
 
 
 
Active
 
 
 
 
SWIFT Code
 
 
 
 
Branch
 
 
 
 
Own GL Account
 
 
 
 
Banking Daybook Profile
 
 
 
 
AP Discount Account
 
 
 
 
AR Discount Account
 
 
 
 
Cash Tab
 
 
 
 
Cash Recv Daybook Profile
 
 
 
 
Cash Paid Daybook Profile