Go to main content
1/60
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Information
Conventions
1
Overview to Multi-Currency
1.1
What Are the Features of Multi-Currency?
1.2
What Is the Multi-Currency Process?
1.3
Where Is Information Stored?
1.3.1
Ledger Information
1.3.2
Balance Information
1.4
Before You Set Up Multi-Currency
1.4.1
Which Currency Restatement Method Should You Use?
1.4.2
What Ledger Types Does the System Use?
1.4.3
How Do You Post Balances by Currency?
1.5
Multi-Currency Setup Comparison
1.5.1
General Constants F0009
1.5.2
Company Numbers and Names (or Designate Company Currency) F0010
1.5.3
Set Up UDC Tables
1.5.4
Exchange Rate Setup
1.5.5
Automatic Accounting Instructions
1.5.6
General Ledger Post
Part I Understand Multi-Currency
2
Set Up Multi-Currency
2.1
Overview
2.2
Activating Multi-Currency
2.2.1
What You Should Know About
2.3
Defining Currency Codes
2.3.1
How Are Currency Decimals Handled?
2.3.2
What You Should Know About
2.4
Assigning a Domestic Currency to a Company
2.5
Assigning Currency Codes to Monetary Accounts
2.6
Assigning Currency Codes to Customers and Suppliers
2.6.1
Processing Options
2.7
Setting Up AAIs for Multi-Currency
2.7.1
AAIs for Revaluation
2.7.2
AAIs for Balances by Currency
3
Work with Currency Codes and Decimals
3.1
Updating Domestic Currency Codes
3.1.1
What You Should Know About
3.1.2
Processing Options
3.2
Changing Currency Decimals
3.2.1
Example: Currency Decimals for Data Item AA
3.2.2
What You Should Know About
3.2.3
Processing Options
4
Exchange Rate Methods
4.1
Overview
4.1.1
Multiplier Method
4.1.2
Divisor Method
4.1.3
No Inverse Method
4.2
Triangulation and No Inverse Conversion Methods
4.3
Triangulation in a Multi-Company Environment
4.3.1
What You Should Know About
5
Work with Exchange Rates
5.1
Defining a Single Currency Exchange Rate
5.1.1
What You Should Know About
5.1.2
Processing Options
5.2
Defining Multiple Currency Exchange Rates
5.2.1
What You Should Know About
5.2.2
Processing Options
5.3
Defining Currency Relationships
5.3.1
Creating Currency Cross-Rate Relationships
5.3.1.1
Example: Creating a Currency Cross-Rate Relationship
5.3.2
What You Should Know About
5.4
Reviewing Currency Cross-Rate Relationships
5.4.1
What You Should Know About
5.4.2
Calculating Currency Cross-Rate Relationships
5.4.3
Processing Options
5.5
Defining Currency Relationships Using Triangulation
5.5.1
Set Up Triangulation Relationships
5.5.2
Triangulation and Spot Rates
Part II Journal Entries with Foreign Currency
6
Work with Journal Entries with Foreign Currency
6.1
Entering Journal Entries with Foreign Currency
6.1.1
What You Should Know About
6.1.2
Processing Options
6.2
Locating Journal Entries with Foreign Currency
7
Multi-Currency Intercompany Settlements for Journal Entries
7.1
What General Accounting Constants Do You Need to Set Up?
7.2
How Are Journal Entries Processed?
7.2.1
Entering Multiple Currencies
7.2.2
Posting Multiple Currencies
7.3
Example: Intercompany Settlements for Multi-Currency
7.4
Example: T Accounts
7.5
Account Ledger Inquiry (P09200)
7.5.1
What You Should Know About
8
Account Balance by Currency
8.1
Overview
8.2
Activating Account Balance by Currency
8.3
Setting Up Account Balance by Currency
8.3.1
Example of Account Balance by Currency:
Part III Currency Gains and Losses for A/P
9
Overview to Currency Gains and Losses for A/P
9.1
Objectives
9.2
Overview
9.3
What Are the Types of Gains and Losses?
9.3.1
Example: Gain/Loss for a Foreign Voucher
9.3.1.1
Voucher and Payment
9.3.1.2
Journal Entries
9.3.2
Example: Gain/Loss for a Domestic Voucher - Detailed Restatement
9.3.2.1
Voucher and Payment
9.3.2.2
Journal Entries
9.4
Which Ledgers Are Used to Calculate Gains and Losses?
9.5
How Are Gains and Losses Calculated?
10
Set Up AAIs for A/P Gains and Losses
10.1
Overview
10.2
Which AAIs Are Used to Calculate Realized Gains and Losses?
10.3
Which AAIs Are Used to Calculate Unrealized Gains and Losses?
11
Calculate Unrealized A/P Gains and Losses
11.1
Overview
11.1.1
Before You Begin
11.1.2
What You Should Know About
11.1.3
Processing Options
Part IV Currency Gains and Losses for A/R
12
Overview to Currency Gains and Losses for A/R
12.1
Objectives
12.2
Overview
12.3
What Are the Types of Gains and Losses?
12.3.1
Example: Gain/Loss for a Foreign Invoice
12.3.1.1
Invoice and Receipt
12.3.1.2
Journal Entries
12.3.2
Example: Gain/Loss for a Domestic Invoice
12.3.2.1
Journal Entries
12.4
Which Ledgers Are Used to Calculate Gains and Losses?
12.5
How Are Gains and Losses Calculated?
13
Understand AAIs for A/R Gains and Losses
13.1
Overview
13.2
Which AAIs Are Used to Calculate Realized Gains and Losses?
13.3
Which AAIs Are Used to Calculate Unrealized Gains and Losses?
14
Calculate Unrealized A/R Gains and Losses
14.1
Overview
14.1.1
Before You Begin
14.1.2
What You Should Know About
14.1.3
Processing Options
Part V Enter Multi-Currency Invoices and Vouchers
15
Enter Multi-Currency Invoices
15.1
Overview
15.1.1
Before You Begin
15.1.2
What You Should Know About
15.1.3
Processing Options
16
Enter Multi-Currency Vouchers
16.1
Overview
16.1.1
Before You Begin
16.2
Entering a Multi-Currency Voucher
16.2.1
What You Should Know About
16.2.2
Processing Options
17
Intercompany Settlements for Multi-Currency - Invoices and Vouchers
17.1
Posting Multiple Currencies - Intercompany Journal Entries
17.2
Entering Multiple Currencies
17.2.1
General Accounting Constants
17.2.1.1
Example
17.2.2
What You Should Know About
18
View Amounts in "As If" Currency
18.1
Overview
18.1.1
Before You Begin
18.2
Dates that Affect the "As If" Amounts
18.3
Viewing "As If" Amounts
18.3.1
Processing Options
18.3.2
Processing Options
18.3.3
Processing Options
Part VI Manual and Alternate Currency Receipts for Multi-Currency
19
Multi-Currency for Manual Receipts
19.1
Overview
19.1.1
Before You Begin
19.1.1.1
Example
19.1.2
What You Should Know About
19.1.3
Before You Begin
19.1.4
Processing Options
20
Setup Alternate Currency Receipt
20.1
Setup Requirements for Alternate Currency Receipts
20.2
Alternate Currency Receipt Clearing Account and AAI (R7)
20.3
Alternate Currency Receipt Gain/Loss Accounts and AAls (RY/RZ)
20.4
Processing Options for Alternate Currency Receipts
20.4.1
Processing Options
20.5
Purpose of an Alternate Currency Clearing Account
20.6
How Gains/Losses Are Calculated on Alternate Currency Receipts
21
Processing Alternate Currency Receipts
21.1
Entering Invoice Match Receipts
21.1.1
Partial Receipts
21.1.2
Spot Rates
21.1.3
Error Messages and Troubleshooting
21.1.4
Creating Chargebacks
21.2
T-Accounts for Alternate Currency Receipt Processing
21.2.1
Example: Canadian Company Receives USD for a CAD Invoice
21.2.2
Example: Canadian Company Receives JPY for USD Invoice
21.2.3
Calculations
Part VII Automatic and Alternate Currency Payments for Multi-Currency
22
Automatic Payments for Multi-Currency
22.1
Overview
22.1.1
Before You Begin
22.2
Grouping Vouchers for Automatic Payments
22.2.1
Create Payment Groups (P04570)
22.2.1.1
Bank Account Monetary Unit
22.2.1.2
Voucher Domestic Currency
22.2.1.3
Voucher Foreign Currency
22.2.1.4
Current Domestic Amount
22.2.2
What You Should Know About
22.2.3
Processing Options
22.3
Work with Payment Groups (P04257)
22.3.1
Processing Options
23
Setup Alternate Currency Payment
23.1
Setup Requirements for Alternate Currency Payments
23.1.1
Work with Payment Groups (P04257)
23.1.2
Processing Options
23.1.3
Alternate Currency Clearing Account and AAI (P7)
23.1.4
Alternate Currency Payment Gain/Loss Accounts and AAls (PY/PZ)
23.1.5
Processing Options
23.2
Purpose of an Alternate Currency Clearing Account
23.2.1
How Gains/Losses Are Calculated on Alternate Payments
24
Processing Alternate Currency Payments
24.1
Alternate Currency Payment Records
24.2
Creating Automatic Payments in an Alternate Currency
24.2.1
Create Payment Groups (P04570)
24.2.1.1
Error Messages
24.2.2
Work with Payment Groups (P04257)
24.2.2.1
Error Messages
24.3
Creating Manual Payments in an Alternate Currency
24.4
How Alternate Currency Payment Amounts Are Calculated
24.4.1
Example: Canadian Company Pays USD Voucher in JPY
24.4.2
Calculations
25
Print Open A/R or A/P Reports with Foreign Amounts
25.1
Overview
25.2
Printing the Open A/R Foreign Amounts Report
25.2.1
Processing Options
25.3
Printing the Open A/P Foreign Amounts Report
25.3.1
Processing Options
Part VIII Monthly Valuation and Financial Restatement
26
Setting Up Exchange Rate Differences
26.1
Overview
26.1.1
Process A/R Gains/Losses (P098651)
26.1.2
Process A/P Gains/Losses (P098652)
26.2
Exchange Rate Difference Accounting
26.3
Set Up AAIs for Exchange Rate Difference Accounting
26.3.1
What You Should Know About
26.3.2
Setting Up Exchange Rate Differences for A/R
26.3.3
Processing Options
26.3.4
Setting Up Exchange Rate Differences for A/P
26.3.5
Processing Options
26.3.6
Setting Up Exchange Rate Processing by Company
26.3.7
Setting Up Exchange Rate Differences User Defined Codes
26.4
Voiding E1 Vouchers/Payments
26.5
Voiding E2 Invoices/Receipts
27
Overview to Monthly Valuation and Financial Restatement
27.1
Objectives
27.2
Overview
27.2.1
What Are the Types of Monthly Valuations?
27.2.2
What Are the Types of Financial Restatement?
27.2.3
Which Ledgers Are Used for Financial Restatement?
27.2.4
What Are the SFAS 52 Requirements?
28
Understand Monetary Account Valuation
28.1
How Are Unrealized Gains and Losses Calculated?
28.2
How Are Unrealized Gains and Losses Recorded?
28.2.1
AAIs for Automatic Journal Entries
29
Calculate Unrealized Gains and Losses
29.1
Overview
29.1.1
Before You Begin
29.1.2
Example: Journal Entry for Unrealized Gain or Loss
29.1.3
What You Should Know About
29.1.4
Processing Options
29.1.5
Data Selection for Monetary Account Valuation
30
Understand Balance Currency Restatement
30.1
Overview
30.2
What Information Does the System Need for Calculations?
30.2.1
Rate Type
30.2.2
Calculation Method
30.2.3
Example: Net Period Calculation - Method 0
30.2.4
Example: Cumulative Balance Calculation - Method 1
30.2.5
Translation Adjustment Accounts
30.3
How Are Restated Balances Calculated?
31
Define Restatement Rates
31.1
Overview
31.1.1
Before You Begin
31.1.2
What You Should Know About
31.1.3
Processing Options
32
Work with Calculations for Balance Restatement
32.1
Overview
32.1.1
Before You Begin
32.2
Defining Calculations
32.2.1
What You Should Know About
32.3
Reviewing Calculations
32.3.1
What You Should Know About
33
Calculate Restated Balances
33.1
Overview
33.1.1
Before You Begin
33.1.2
What You Should Know About
33.1.3
Processing Options
34
Understand Detailed Currency Restatement
34.1
Overview
34.2
Which Ledgers Are Used to Calculate Gains and Losses?
34.2.1
Example: Gain or loss for a Domestic Voucher
34.2.1.1
Voucher and Payment
34.2.1.2
Journal Entries
34.3
How Are Gains and Losses Calculated on a Foreign Transaction?
34.4
What Happens If You Use Alternate Ledgers?
34.5
What Steps Are Required for Detailed Currency Restatement?
34.6
What Transactions Are Processed?
34.7
What Happens with Reviewing and Posting?
35
Set Up Detailed Currency Restatement
35.1
Overview
35.1.1
What You Should Know About
35.1.2
Processing Options
35.2
Setting Up Constants for Detailed Currency Restatement
35.2.1
Setting Up General Accounting Constants
35.2.2
Setting Up Accounts Receivable and Accounts Payable Constants
35.3
Setting Up Companies for Detailed Currency Restatement
35.3.1
What You Should Know About
35.4
Setting Up Currency Codes for Detailed Currency Restatement
35.4.1
What You Should Know About
35.5
Setting Up Ledger Types for Detailed Currency Restatement
35.5.1
What You Should Know About
35.6
Setting Up AAIs for Detailed Currency Restatement
35.6.1
What You Should Know About
35.7
Working with Exchange Rates for Detailed Currency Restatement
35.7.1
Defining Exchange Rates for Detailed Currency Restatement
35.7.2
What You Should Know About
35.7.3
Processing Options
35.7.4
Overriding the Exchange Rate for a Journal Entry
36
Calculate Detailed Currency Restatement
36.1
Overview
36.1.1
Before You Begin
36.1.2
Common Error Messages and Their Causes
36.1.3
Processing Options
37
Review/Approve Detailed Currency Transactions
37.1
Overview
37.2
Reviewing Detailed Currency Transactions
37.2.1
Reviewing a List of Detailed Currency Batches
37.2.2
What You Should Know About
37.2.3
Reviewing Detailed Information
37.3
Approving Detailed Currency Batches for Posting
37.3.1
What You Should Know About
38
Post the Detailed Currency Journal
38.1
Overview
38.1.1
Before You Begin
38.2
Posting a Batch of Detailed Currency Transactions
38.2.1
What You Should Know About
38.3
Verifying the Post of Detailed Currency Transactions
38.3.1
Posting Edit Report
38.3.1.1
Common Error Messages and Their Causes
38.3.2
Posting Journal
38.3.3
What You Should Know About Processing Options
39
Work with "As If" Currency Reposting
39.1
Overview
39.2
Defining the Exchange Rate for Reposting
39.2.1
What You Should Know About
39.3
Calculating and Posting "As If" Currency Restatement
39.3.1
Before You Begin
39.3.2
What You Should Know About
39.3.3
Data Selection for Compute ”As If” Balances
39.3.4
Processing Options
Part IX Processing Options
40
General Multi-Currency Processing Options
40.1
Supplier Master Information (P01054)
40.2
Customer Master Information (P01053)
40.3
Update Address Book Amount Currency (P11801)
40.4
Data Display Decimal Update for F9800 (P98DEC)
40.5
Currency Exchange Rates (P00151)
40.6
Speed Transactions Rate Entry (P11154)
40.7
Calculate Currency Cross Rates (P11153)
40.8
AR Functional Server (XT0311Z1)
40.9
AP Functional Server (XT0411Z1)
40.10
Supplier Ledger Inquiry (P042003)
40.11
Customer Ledger Inquiry with SQL (P032002)
40.12
Open Orders Inquiry (P430301)
40.13
Journal Entry (P09101)
40.14
Journal Entry Functional Server (XT0911Z1)
40.15
Currency Gains & Losses (P04425)
40.16
AAIs - Accounts Receivable (P00121)
40.17
Gains & Losses on Foreign Currency (P03426)
41
Account Ledger Processing Options
41.1
Account Ledger Inquiry (P09200)
42
Manual and Alternate Currency Receipts Processing Options
42.1
Receipts Entry (P03103)
43
Automatic and Alternate Currency Payments Processing Options
43.1
Create Payment Groups (P04570)
43.2
A/P Payments - Work with Payment Groups (P04257)
43.3
Manual with Match Check Processing (P04102)
44
Print A/R and A/P Detail Reports Processing Options
44.1
A/R Currency Detail (P03429)
44.2
Currency Detail Report (P04427)
45
Monthly Valuation and Financial Restatement Processing Options
45.1
Monetary Account Valuation (P09415)
45.2
Exchange Rate Diff - A/R Gain/Loss/Proof (P098651)
45.3
Exchange Rate Difference - A/P Gain/Loss (P098652)
45.4
Exchange Rate Table (P1113)
45.5
Detailed Currency Setup (P11410)
45.6
Currency Exchange Rates (P00151)
45.7
Detailed Currency Restatement XA YA ZA (P11411)
45.8
Currency Restatement (P11414)
45.9
As If Repost (P11415)
A
Currency Codes and Decimals
A.1
Multi-Currency Option "Off"
A.2
Multi-Currency Option "On"
A.2.1
"Units" Ledgers
A.2.2
"Amounts" Ledgers
A.2.3
Totals on Reports
A.2.4
Monetary (Currency-Specific) Accounts
A.2.5
Technical Considerations
A.2.6
Detailed Posting by Currency
A.2.7
Summary Posting by Currency
Index
Scripting on this page enhances content navigation, but does not change the content in any way.