Go to main content
1/42
Contents
List of Figures
Title and Copyright Information
Preface
Audience
JD Edwards EnterpriseOne Products
JD Edwards EnterpriseOne Application Fundamentals
Documentation Accessibility
Related Documents
Conventions
1
Introduction to JD Edwards EnterpriseOne Multicurrency Processing
1.1
JD Edwards EnterpriseOne Multicurrency Processing Overview
1.2
JD Edwards EnterpriseOne Multicurrency Processing Integrations
1.3
JD Edwards EnterpriseOne Multicurrency Processing Implementation
1.3.1
JD Edwards EnterpriseOne Multicurrency Processing Implementation Steps
1.4
Business Interface Integration Objects
2
Understanding Multicurrency Processing
2.1
Multicurrency Transaction Processing
2.2
Multicurrency Features and Functionality
3
Changing from a Non-Currency to a Multicurrency Environment
3.1
Understanding Non-Currency and Multicurrency Environments
3.1.1
Prerequisites
3.2
Updating Domestic Currency Codes
3.2.1
Domestic Currency Code Updates
3.2.2
Running the Load Domestic Currency Code Programs
3.2.3
After Running the Load Domestic Currency Code Programs
4
Understanding Multicurrency Setup
4.1
Setup for Basic Multicurrency
4.2
Setup for Exchange Rates
4.3
Setup for AAI Unrealized Gains and Losses
4.4
Setup for Posting Balances by Currency
4.5
Setup for Multicurrency Intercompany Settlements
4.6
Setup for Detailed Currency Restatement
4.7
Setup for Balance Restatement
4.8
Setup for As If Restatement
5
Setting Up General Accounting for Multicurrency Processing
5.1
Understanding Multicurrency Setup for General Accounting
5.2
Setting Up Multicurrency Constants
5.2.1
Understanding Multicurrency Constants Setup
5.2.1.1
Multicurrency Conversion Constant
5.2.1.2
Multicurrency Intercompany Transactions and Settlements Constants
5.2.2
Forms Used to Set Up Multicurrency Constants
5.2.3
Setting Up Multicurrency Constants
5.3
Setting Up Currency Codes
5.3.1
Understanding Currency Codes
5.3.1.1
How Currency Decimals Are Managed
5.3.2
Forms Used to Set Up a Currency Code
5.3.3
Setting Up a Currency Code
5.4
Setting Up Companies for Multicurrency Processing
5.4.1
Understanding Company Setup for Multicurrency Processing
5.4.1.1
Balances by Currency Versus Summarized Balances
5.4.1.2
How the System Updates Currency Fields in the F0902 Table
5.4.2
Forms Used to Set Up Companies for Multicurrency Processing
5.4.3
Setting Up a Company for Multicurrency Processing
5.4.3.1
Currency
5.5
Setting Up Multicurrency AAIs for General Accounting
5.5.1
Understanding Multicurrency AAIs for General Accounting
5.5.2
Setting Up AAIs for Unrealized Gains and Losses on Monetary Bank Accounts
5.5.3
Setting Up AAIs for Posting Balances by Currency
5.5.3.1
Example: PBCxx Setup
5.5.4
Setting Up AAIs for Multicurrency Intercompany Settlements
5.6
Setting Up Monetary Accounts
5.6.1
Understanding Monetary Accounts
5.6.2
Forms Used to Set Up Monetary Accounts
5.7
Setting Up Multicurrency Ledger Types
6
Setting Up Exchange Rates
6.1
Understanding Exchange Rates
6.1.1
Spot Rates
6.1.2
Calculation Methods
6.2
Setting Up Exchange Rates for the Inverse Method
6.2.1
Understanding the Inverse Method
6.2.2
Examples: Inverse Method
6.2.2.1
Inverse with Multiplier Conversion Method
6.2.2.2
Inverse with Divisor Conversion Method
6.2.3
Forms Used to Set Up Exchange Rates for the Inverse Method
6.2.4
Setting Processing Options for Currency Exchange Rate Entry (P0015A)
6.2.4.1
Limits
6.2.4.2
Display
6.2.5
Setting Up an Exchange Rate for the Inverse Method
6.3
Setting Up Exchange Rates for the No Inverse Method
6.3.1
Understanding the No Inverse Method
6.3.2
Example: No Inverse Method
6.3.3
Forms Used to Set Up Exchange Rates for the No Inverse Method
6.3.4
Setting Up an Exchange Rate for the No Inverse Method
6.4
Setting Up Exchange Rates for the Triangulation Method
6.4.1
Understanding the Triangulation Method
6.4.1.1
Example: Triangulation Method
6.4.2
Form Used to Set Up Exchange Rates for the Triangulation Method
6.4.3
Setting Up Exchange Rates for Triangulation
6.5
Setting Up Multiple Exchange Rates for a Single Currency
6.5.1
Understanding Multiple Exchange Rate Setup
6.5.2
Forms Used to Set Up Multiple Exchange Rates for a Single Currency
6.5.3
Setting Up Multiple Exchange Rates for a Single Currency
6.6
Uploading Exchange Rates from an External Source
6.6.1
Understanding the Upload Process for External Exchange Rates
6.6.2
Understanding External Exchange Rate Revisions
6.6.3
Forms Used to Revise Unprocessed External Exchange Rates
6.6.4
Revising Unprocessed Exchange Rates
6.7
Processing External Exchange Rates
6.7.1
Understanding the External Exchange Rate Processor Program
6.7.2
Running the External Exchange Rate Processor Program
6.7.3
Setting Processing Options for External Exchange Rate Processor (R0015Z1)
6.7.3.1
Options
6.7.4
Purging External Exchange Rate Records
6.7.5
Setting Processing Options for External Currency Exchange Rates Purge (R0015Z1P)
6.7.5.1
Options
6.8
Setting Up Currency Cross-Rate Relationships
6.8.1
Understanding Currency Cross-Rate Relationships
6.8.2
Forms Used to Set Up Currency Cross-Rate Relationships
6.8.3
Setting Up Currency Cross-Rate Relationships
6.9
Calculating Currency Cross-Rates
6.9.1
Understanding Currency Cross-Rate Calculations
6.9.1.1
Exact Date Match Processing Option
6.9.2
Prerequisite
6.9.3
Running the Calculate Cross Currency Rates Program
6.9.4
Setting Processing Options for Calculate Cross Currency Rates (R11153)
6.9.4.1
Mode
6.9.4.2
Creation Date
6.9.4.3
Tolerance
7
Setting Up Detailed Currency Restatement
7.1
Understanding the Detailed Currency Setup Program
7.2
Setting Up Detailed Currency Restatement
7.2.1
Forms Used to Set Up Detailed Currency Restatement
7.2.2
Setting Up Constants for Detailed Currency Restatement
7.2.3
Setting Up Companies for Detailed Currency Restatement
7.3
Setting Up Ledger Types for Detailed Currency Restatement
7.3.1
Understanding Ledger Types Used for Detailed Currency Restatement
7.3.2
Prerequisites
7.3.3
Forms Used to Set Up Ledger Types Rules
7.3.4
Setting Up Ledger Type Rules For Detailed Currency Restatement
7.4
Setting Up AAIs for Detailed Currency Restatement
7.4.1
Understanding AAIs for Detailed Currency Restatement
7.4.1.1
AAI Item CRxx (Required)
7.4.1.2
AAI Item CR (Optional)
8
Setting Up Balance Restatement and As If Restatement
8.1
Setting Up Balance Restatement
8.2
Setting Up the Ledger Type and Rules for Balance Restatement
8.2.1
Forms Used to Set Up Ledger Type Rules for Balance Restatement
8.2.2
Setting Up the Ledger Type Rules for Balance Restatement
8.3
Setting Up Restatement Rates for Balance Restatement
8.3.1
Understanding Balance Restatement Rates
8.3.2
Prerequisite
8.3.3
Form Used to Set Up Restatement Rates for Balance Restatements
8.3.4
Setting Processing Options for Currency Restatement Rates (P1113)
8.3.4.1
Limits
8.3.5
Setting Up Restatement Rates
8.4
Setting Up Computations for Balance Restatement
8.4.1
Understanding Computations for Balance Restatement
8.4.1.1
Primary Information Used in Computations
8.4.1.2
Rate Types
8.4.1.3
Calculation Methods
8.4.1.4
Example: Method 1 (Cumulative Balance Calculation)
8.4.1.5
Example: Method 0 (Net Period Calculation)
8.4.1.6
Translation Adjustment Accounts
8.4.1.7
Computations for Balance Restatement
8.4.1.8
Computation IDs
8.4.2
Prerequisite
8.4.3
Forms Used to Set Up Computations for Balance Restatement
8.4.4
Setting Up Computations
8.4.4.1
Header Fields
8.4.4.2
Detail Fields
8.4.5
Assigning a Computation ID to a Company
8.5
Setting Up As If Restatement
8.5.1
Prerequisite
8.5.2
Forms Used to Set Up the Ledger Type and Rules for As If Restatement
8.5.3
Setting Up the Ledger Type Rules for As If Restatement
9
Setting Up Accounts Receivable for Multicurrency Processing
9.1
Setting Up Customer Records for Multicurrency Processing
9.1.1
Form Used to Assign Currency Codes to a Customer Record
9.1.2
Setting Multicurrency Processing Options for the Customer Master Information Program (P03013)
9.1.2.1
Defaults
9.1.3
Assigning Currency Codes to a Customer Record
9.1.3.1
Invoices
9.2
Converting Customer Master Currency Codes
9.2.1
Understanding Customer Currency Conversions
9.2.2
Understanding the Address Book Conversion Programs
9.2.2.1
Exceptions Report
9.2.2.2
Example: Converting Customer Amounts from Canadian Dollars to the Euro
9.2.2.3
Before Converting Customer Amounts
9.2.2.4
After Converting Customer Amounts
9.2.2.5
Example: Converting Parent/Child Structure with Different Currencies
9.2.2.6
Before Converting Currency Codes
9.2.2.7
After Converting Currency Codes
9.2.3
Running the Address Book Conversion Program - F03012
9.2.4
Setting Processing Options for Address Book Conversion - F03012 (R8903012E)
9.2.4.1
Update
9.2.4.2
Currency
9.2.4.3
Rounding
9.3
Setting Up Multicurrency AAIs for Accounts Receivable
9.3.1
Understanding Multicurrency AAIs for Accounts Receivable
9.3.2
Setting Up AAIs for Receivable Bank Accounts in Foreign Currencies
9.3.3
Setting Up AAIs for Receivable Trade Accounts in Foreign Currencies
9.3.3.1
Example: AAI Search Sequence with a GL Offset
9.3.3.2
Example: AAI Search Sequence without a GL Offset
9.3.4
Setting Up AAIs for Unrealized Gains and Losses on Foreign Currency Invoices
9.3.5
Setting Up AAIs for Realized Gains and Losses on Foreign Currency Receipts
9.3.6
Setting Up AAIs for Realized Gains and Losses on Alternate Currency Receipts
9.3.7
Setting Up AAIs for the Rounding Account for Foreign and Alternate Currency Receipts
9.3.8
Setting Up AAIs for the Clearing Account for Alternate Currency Receipts
9.4
Setting Up Credit and Collection Policies for Multicurrency Processing
9.4.1
Understanding Multicurrency Credit and Collections Setup
9.4.2
Prerequisite
9.4.3
Forms Used to Set Up Credit and Collection Policies by Currency Code
9.4.4
Setting Up Currency Codes for Insurance Premiums
9.4.5
Setting Up Notification Instructions
9.4.6
Setting Up Fee Instructions
10
Setting Up Accounts Payable for Multicurrency Processing
10.1
Setting Up Supplier Records for Multicurrency Processing
10.1.1
Form Used to Assign Currency Codes to a Supplier Record
10.1.2
Setting Multicurrency Processing Options for Supplier Master Information (P04012)
10.1.2.1
Defaults
10.1.3
Assigning Currency Codes to a Supplier Record
10.2
Converting Supplier Master Currency Codes
10.2.1
Understanding Supplier Currency Conversion
10.2.2
Understanding the Address Book Conversion Program
10.2.2.1
Exceptions Report
10.2.2.2
Example: Converting Supplier Amounts from U.S. Dollars to Canadian Dollars
10.2.2.3
Before Converting Supplier Currency Codes
10.2.2.4
After Converting Supplier Currency Codes
10.2.2.5
Example: Converting Parent/Child Structure with Different Currencies
10.2.2.6
Before Converting Currency Codes
10.2.2.7
After Converting Currency Codes
10.2.3
Running the Address Book Conversion - F0401 Program
10.2.4
Setting Processing Options for Address Book Conversion - F0401 (R890401E)
10.2.4.1
Update
10.2.4.2
Currency
10.2.4.3
Rounding
10.3
Setting Up Multicurrency AAIs for Accounts Payable
10.3.1
Understanding Multicurrency AAIs for Accounts Payable
10.3.2
Setting Up AAIs for Payable Bank Accounts
10.3.2.1
Monetary Bank Account
10.3.2.2
Non-Monetary Bank Account
10.3.3
Setting Up AAIs for Payable Trade Accounts
10.3.4
Setting Up AAIs for Unrealized Gain and Losses on Foreign Currency Vouchers
10.3.5
Setting Up AAIs for Realized Gains and Losses on Foreign Currency Payments
10.3.6
Setting Up AAIs for Realized Gains and Losses on Alternate Currency Payments
10.3.7
Setting Up AAIs for the Clearing Account for Alternate Currency Payments
10.4
Setting Up Payment Translation Codes
10.5
(MEX) Setting Up Payment Translation Codes
10.5.1
Understanding How to Print Currency Descriptions
10.5.2
Setting Processing Options for Convert Numeric Values to Words - Spanish (P00500S2)
10.5.2.1
Printing
11
Entering and Processing Foreign Currency Journal Entries
11.1
Understanding Journal Entries in a Foreign Currency
11.2
Understanding Intercompany Journal Entries in a Foreign Currency
11.2.1
Revisions to Intercompany Journal Entries with Multiple Currencies
11.2.2
Example: Multicurrency Intercompany Settlement
11.2.2.1
Journal Entry
11.2.2.2
Adjusting Entry and the Post
11.2.2.3
Intercompany Settlement and the Post
11.2.2.4
T-Accounts for Multicurrency Intercompany Settlements
11.3
Understanding Batch Journal Entries in a Foreign Currency
11.4
Entering Journal Entries in a Foreign Currency
11.4.1
Understanding Foreign Currency Journal Entries
11.4.2
Forms Used to Enter Journal Entries in a Foreign Currency
11.4.3
Setting Multicurrency Processing Options for Journal Entry MBF (P0900049)
11.4.3.1
Currency
11.4.4
Entering a Journal Entry in a Foreign Currency
11.4.4.1
Related Tasks for Journal Entries
11.5
Posting Journal Entries in a Foreign Currency
11.5.1
Understanding the Post Process for Journal Entries in a Foreign Currency
11.5.1.1
Post Reports
11.5.2
Understanding How Balance Amounts Are Stored in the F0902 Table
11.5.2.1
Example: Balance by Currency
11.5.2.2
Example: Summarized Balances
11.5.2.3
Example: Monetary Accounts
11.5.2.4
Example: Non-Monetary Accounts
11.5.3
Posting Journal Entries in a Foreign Currency
12
Using Multicurrency Inquiries for General Accounting
12.1
Understanding Multicurrency Inquiries for General Accounting
12.1.1
As If Currency Processing
12.2
Reviewing Accounts in Domestic, Foreign, and As If Currencies
12.2.1
Understanding How to Review Accounts In Domestic, Foreign, and As If Currencies
12.2.2
Forms Used to Review Accounts in Domestic, Foreign, and As If Currencies
12.2.3
Reviewing Accounts in Domestic And Foreign Currencies
12.2.4
Reviewing Accounts with Domestic and As If Currency Amounts
12.2.5
Reviewing Accounts With Domestic Amounts in an As If Currency
12.2.6
Reviewing Accounts With Foreign Amounts in an As If Currency
12.2.7
Reviewing Account Balances by Currency
13
Entering and Processing Foreign Currency Invoices
13.1
Understanding Foreign Currency Invoices
13.1.1
Understanding Domestic Versus Foreign Currency Invoices
13.1.1.1
Domestic Currency Invoices
13.1.1.2
Foreign Currency Invoices
13.1.2
Understanding Rounding Versus Soft Rounding
13.1.2.1
Rounding
13.1.2.2
Soft Rounding
13.1.3
Understanding How Domestic Amounts Are Calculated on Foreign Invoices Without Taxes
13.1.3.1
Example: Foreign Invoice Split into Multiple Pay Items
13.1.3.2
Example: Foreign Invoice Entered with Multiple Pay Items (No Split Payment Terms)
13.1.4
Understanding How Domestic Amounts Are Calculated on Foreign Invoices with Taxes
13.1.4.1
Example: Foreign Invoice with Taxes
13.1.5
Understanding Multicurrency Batch Totals
13.1.6
Understanding How to Process Foreign Currency Batch Invoices
13.2
Entering Invoices in a Foreign Currency
13.2.1
Understanding Foreign Currency Invoice Entry
13.2.1.1
Foreign Currency Invoice Revisions
13.2.1.2
Foreign Currency Code Changes
13.2.1.3
Foreign Currency Recurring Invoices
13.2.1.4
AID Field Updated During Invoice Entry
13.2.2
Prerequisite
13.2.3
Forms Used to Enter Invoices in a Foreign Currency
13.2.4
Setting Multicurrency Processing Options for the Standard Invoice Entry Program (P03B11)
13.2.4.1
Display
13.2.5
Setting Multicurrency Processing Options for Invoice Entry MBF (P03B0011)
13.2.5.1
Taxes
13.2.5.2
Currency
13.2.6
Entering an Invoice in a Foreign Currency
13.3
Reviewing Invoices in a Foreign and As If Currency
13.3.1
Understanding Multicurrency Invoice Inquiry
13.3.1.1
Dates That Affect the Invoice Amounts
13.3.1.2
As If Currency Invoices
13.3.2
Prerequisite
13.3.3
Form Used to Review Invoices in a Foreign and As If Currency
13.3.4
Setting Multicurrency Processing Options for Customer Ledger Inquiry (P03B2002)
13.3.4.1
Currency
13.3.5
Reviewing Invoices in a Foreign and As If Currency
13.4
Posting Foreign Currency Invoices
13.4.1
Understanding the Post Process for Foreign Currency Invoices
13.4.2
Posting Foreign Currency Invoices
14
Processing Foreign and Alternate Currency Receipts
14.1
Understanding Foreign and Alternate Receipts Entry
14.1.1
Programs to Enter Foreign and Alternate Currency Receipts and Foreign Drafts
14.1.2
Understanding Domestic Currency Receipts
14.1.3
Understanding Foreign Currency Receipts
14.1.4
Understanding Alternate Currency Receipts
14.1.4.1
Example: T-Accounts for Alternate Currency Receipts
14.1.5
Understanding Multicurrency and Receipt Types
14.1.5.1
General Ledger Receipts
14.1.5.2
Balance Forward Receipts
14.1.6
Understanding Multicurrency Fields Updated During Receipt and Draft Entry
14.2
Prerequisites
14.3
Entering Manual Receipts in Foreign and Alternate Currencies
14.3.1
Forms Used to Enter Receipts in a Foreign Currency
14.3.2
Setting Multicurrency Processing Options for Standard Receipt Entry (P03B102)
14.3.2.1
Display
14.3.2.2
Currency
14.3.3
Entering Receipts in a Foreign Currency
14.3.4
Loading Open Invoices for Receipt Application
14.3.5
Selecting Open Invoices for Receipt Application
14.4
Processing Automatic Receipts and Automatic Debits in Foreign Currencies
14.4.1
Understanding How to Process Automatic Receipts in a Foreign Currency
14.4.1.1
Write-Off Tolerance Amounts
14.4.2
Understanding How to Process Automatic Debits in a Foreign Currency
14.4.3
Prerequisites
14.4.4
Forms Used to Process Receipts in a Foreign Currency
14.4.5
Processing Automatic Debits in a Foreign Currency
14.5
Generating Credit Reimbursements in Foreign Currencies
14.5.1
Understanding Credit Reimbursements in a Foreign Currency
14.5.1.1
Example: Data Selection for Credit Reimbursements
14.5.2
Generating Credit Reimbursements in a Foreign Currency
14.6
Processing Accounts Receivable Drafts in Foreign Currencies
14.6.1
Understanding Accounts Receivable Drafts in a Foreign Currency
14.6.1.1
Manual Receipt Drafts in a Foreign Currency
14.6.1.2
Automatic Receipt Drafts in a Foreign Currency
14.6.1.3
Foreign Currency Drafts with Contingent Liability
14.6.1.4
Foreign Currency Drafts and Processing Options
14.7
Posting Foreign and Alternate Currency Receipts
14.7.1
Understanding the Post Process for Foreign and Alternate Currency Receipts
14.7.1.1
Posting Receipts to Monetary Bank Accounts
14.7.1.2
Slight Rounding Differences Recorded by the Receipt Post
14.7.1.3
Example: Slight Rounding Differences Recorded by the Receipt Post
14.7.1.4
Multicurrency Journal Entries Created by the Receipt and Draft Post
14.7.1.5
Multicurrency Automatic Entries Created by the Receipt and Draft Post
14.7.2
Posting Foreign and Alternate Currency Receipts
15
Managing Credit and Collections for Multiple Currencies
15.1
Generating and Reviewing Multicurrency Statements
15.1.1
Understanding Multicurrency Statements
15.1.2
Forms Used to Review Multicurrency Statements
15.1.3
Generating Multicurrency Statements
15.1.4
Setting Multicurrency Processing Options for Statement Notification Refresh (R03B500X)
15.1.4.1
Aging
15.1.5
Reviewing Multicurrency Statements
15.1.6
Running the Credit Analysis Refresh Program
15.2
Generating and Reviewing Multicurrency Delinquency Notices
15.2.1
Understanding Multicurrency Delinquency Notices
15.2.2
Forms Used to Review Multicurrency Delinquency Notices
15.2.3
Printing Delinquency Notices in Multiple Currencies
15.2.4
Set Multicurrency Processing Options for A/R Delinquency Notices Print (R03B20) and Tiered Delinquency Notice Print (R03B21)
15.2.4.1
Print
15.2.5
Review Multicurrency Delinquency Notices
15.3
Generating and Reviewing Multicurrency Delinquency Fees
15.3.1
Understanding Multicurrency Delinquency Fees
15.3.2
Forms Used to Review Multicurrency Delinquency Fees
15.3.3
Generating Multicurrency Delinquency Fees
15.3.4
Setting Multicurrency Processing Options for Generate Delinquency Fees (R03B525)
15.3.4.1
Fees
15.3.5
Reviewing Multicurrency Delinquency Fees
15.4
Reviewing Customer Accounts in Multiple Currencies
15.4.1
Understanding the Collection Management Review Programs
15.4.2
Form Used to Review Customer Accounts in Multiple Currencies
15.4.3
Reviewing Customer Accounts in Multiple Currencies
16
Processing Currency Gains and Losses for Accounts Receivable
16.1
Understanding Currency Gains and Losses
16.1.1
Realized Gain/Loss Calculations
16.1.1.1
Example: Realized Gain/Loss on Foreign Currency Invoices and Receipts
16.1.1.2
Standard Gain/Loss
16.1.1.3
Example: Realized Gain/Loss on a Foreign Invoice and Alternate Currency Receipt
16.1.1.4
Standard Gain/Loss
16.1.1.5
Alternate Currency Gain/Loss
16.1.2
Unrealized Gain/Loss Calculations
16.2
Prerequisites
16.3
Generating the A/R Unrealized Gain/Loss Report
16.3.1
Understanding the A/R Unrealized Gain/Loss Report
16.3.1.1
Example: Unrealized Gain/Loss on a Foreign Currency Invoice
16.3.1.2
Unrealized Gain/Loss
16.3.2
Running the A/R Unrealized Gain/Loss Report
16.3.3
Setting Processing Options for A/R Unrealized Gain/Loss Report (R03B426)
16.3.3.1
Process
17
Entering and Processing Foreign Currency Vouchers
17.1
Understanding Foreign Vouchers
17.1.1
Understanding Domestic Versus Foreign Currency Transactions
17.1.1.1
Domestic Currency Vouchers
17.1.1.2
Foreign Currency Vouchers
17.1.2
Understanding Rounding Versus Soft Rounding
17.1.2.1
Rounding
17.1.2.2
Soft Rounding
17.1.3
Understanding How Domestic Amounts Are Calculated on Foreign Vouchers without Taxes
17.1.3.1
Example: Foreign Voucher Split into Multiple Pay Items
17.1.3.2
Example: Foreign Voucher Entered with Multiple Pay Items (No Split Payment Terms)
17.1.4
Understanding How Domestic Amounts Are Calculated on Foreign Vouchers with Taxes
17.1.4.1
Example: Foreign Voucher with Taxes
17.1.5
Understanding Multicurrency Batch Totals
17.1.6
Understanding How to Process Foreign Batch Vouchers
17.1.7
Understanding How to Process Foreign Inbound EDI Vouchers
17.2
Entering Vouchers in a Foreign Currency
17.2.1
Understanding Foreign Currency Voucher Entry
17.2.1.1
Recycling Foreign Currency Recurring Vouchers
17.2.1.2
Correcting Error Messages That Occur When Updating Year-To-Date Voucher Amounts
17.2.2
Prerequisites
17.2.3
Forms Used to Enter Vouchers in a Foreign Currency
17.2.4
Setting Multicurrency Processing Options for Voucher Entry MBF (P0400047)
17.2.4.1
Currency
17.2.5
Entering a Voucher in a Foreign Currency
17.2.6
Revising a Voucher in a Foreign Currency
17.2.6.1
Revising, Deleting, and Voiding Foreign Currency Vouchers
17.2.6.2
Changing the Currency Code on a Foreign Currency Voucher
17.3
Reviewing Vouchers in Foreign and As If Currencies
17.3.1
Understanding How To Inquire on Foreign Currency Vouchers
17.3.1.1
Dates That Affect the Voucher Amounts
17.3.1.2
Understanding As If Currency Processing
17.3.2
Prerequisite
17.3.3
Forms Used to Review Multicurrency Vouchers
17.3.4
Setting Multicurrency Processing Options for Supplier Ledger Inquiry (P0411)
17.3.4.1
Currency
17.3.5
Reviewing Vouchers in a Foreign and an As If Currency
17.4
Posting Foreign Currency Vouchers
17.4.1
Understanding the Post Process for Foreign Currency Vouchers
17.4.2
Posting Foreign Currency Vouchers
18
Entering Manual Foreign and Alternate Currency Payments
18.1
Understanding Multicurrency Payments
18.1.1
Programs to Enter Foreign and Alternate Currency Payments and Foreign Drafts
18.1.2
Understanding Domestic Currency Payments
18.1.3
Understanding Foreign Currency Payments
18.1.4
Understanding Alternate Currency Payments
18.2
Entering Manual Payments
18.2.1
Understanding Manual Payments in a Foreign Currency
18.2.1.1
Speed Payment Entry Program
18.2.2
Understanding Manual Payments in an Alternate Currency
18.2.2.1
Speed Payment Entry Program
18.2.3
Prerequisites
18.2.4
Forms Used to Enter Manual Payments in a Foreign or Alternate Currency
18.2.5
Setting Multicurrency Processing Options for A/P Manual Payments (P0413M)
18.2.5.1
Processing
18.2.5.2
Currency
18.2.6
Entering a Manual Payment in a Foreign Currency
18.2.7
Entering a Manual Payment in an Alternate Currency
18.3
Entering Accounts Payable Drafts in Foreign Currencies
18.3.1
Understanding Accounts Payable Drafts in a Foreign Currency
18.3.1.1
Manual Payment Drafts in a Foreign Currency
18.3.2
Prerequisites
18.3.3
Forms Used to Process Foreign Currency Manual Drafts
18.3.4
Entering a Manual Draft in a Foreign Currency
19
Processing Automatic Payments in a Foreign or an Alternate Currency
19.1
Understanding Automatic Payments in a Foreign or an Alternate Currency
19.1.1
Currency Symbols on Automatic Payments
19.1.2
Dates and Exchange Rates for Automatic Payments
19.1.3
Automatic Payment Drafts in a Foreign Currency
19.2
Creating Payment Groups in a Foreign and an Alternate Currency
19.2.1
Understanding Payment Groups in a Foreign or an Alternate Currency
19.2.1.1
Alternate Currency Error Messages
19.2.1.2
Currency Methods for Automatic Payments
19.2.1.3
Bank Account's Monetary Unit
19.2.1.4
Voucher Domestic Currency
19.2.1.5
Voucher Foreign Currency
19.2.1.6
Current Domestic Amount
19.2.1.7
Alternate Currency Amount
19.2.2
Prerequisites
19.2.3
Creating Payment Groups in a Foreign or Alternate Currency
19.2.4
Setting Data Sequence for Create Payment Control Groups
19.2.5
Setting Multicurrency Processing Options for Create Payment Control Groups (R04570)
19.2.5.1
Amounts
19.2.5.2
Printing
19.3
Writing and Updating Foreign and Alternate Currency Payment Groups
19.3.1
Understanding Multicurrency Payment Groups
19.3.1.1
Updating the Accounts Payable Ledger
19.3.2
Forms Used to Work With Payments in a Foreign or Alternate Currency
19.3.3
Setting Multicurrency Processing Options for Work with Payment Groups (P04571)
19.3.3.1
Display
19.3.3.2
Currency
19.3.4
Writing and Updating Payments in a Foreign or Alternate Currency
19.4
Posting Foreign and Alternate Currency Payments
19.4.1
Understanding the Post Process for Foreign and Alternate Currency Payments
19.4.1.1
Slight Rounding Differences Recorded by the Payment Post
19.4.1.2
Example: Slight Rounding Differences Recorded by the Payment Post
19.4.2
Posting Foreign and Alternate Currency Payments
20
Processing Currency Gains and Losses for Accounts Payable
20.1
Understanding Currency Gains and Losses
20.1.1
Realized Gain/Loss Calculations
20.1.1.1
Example: Realized Gain/Loss on Foreign Currency Voucher and Payment
20.1.1.2
Standard Gain/Loss
20.1.1.3
Example: Realized Gain/Loss on Foreign Voucher and Alternate Currency Payment
20.1.1.4
Standard Gain/Loss
20.1.1.5
Alternate Currency Gain/Loss
20.1.2
Unrealized Gain/Loss Calculations
20.2
Prerequisites
20.3
Generating the A/P Unrealized Gain/Loss Report
20.3.1
Understanding the A/P Unrealized Gain/Loss Report
20.3.1.1
Example: Unrealized Gain/Loss on a Foreign Currency Voucher
20.3.1.2
Unrealized Gain/Loss
20.3.2
Running the A/P Unrealized Gain/Loss Report
20.3.3
Setting Processing Options for A/P Unrealized Gain/Loss Report (R04425)
20.3.3.1
Process
21
Processing Bank Statements Manually in Multiple Currencies
21.1
Multicurrency Considerations for Manual Bank Statement Processing
21.1.1
CA Ledger Amounts Are the Same
21.1.2
CA Ledger Amounts Are Different
21.2
Examples: Currencies and the Bank Statement Entry Program
21.2.1
Example: Different Company Currency
21.2.2
Example: Different Bank Account Currency
21.2.3
Example: Different Transaction Currency
21.2.4
Example: Different Company, Bank Account, and Transaction Currencies
21.3
Entering Multicurrency Bank Statements
21.3.1
Forms Used to Enter Multicurrency Bank Statements
21.3.2
Entering a Bank Statement in a Foreign Currency
22
Performing Monetary Account Valuation
22.1
Understanding Monetary Valuation for Bank Accounts
22.1.1
Example: Monetary Account Valuation
22.2
Understanding Monetary Valuation for Open Invoices and Vouchers
22.3
Calculating Unrealized Gains and Losses on Monetary Accounts
22.3.1
Understanding the Monetary Account Valuation Program
22.3.2
Prerequisites
22.3.3
Calculating Unrealized Gains and Losses on Monetary Accounts
22.3.4
Setting Data Selection for Monetary Account Valuation
22.3.5
Setting Processing Options for Monetary Account Valuation (R09415)
22.3.5.1
LOD
22.3.5.2
Period
22.3.5.3
Print
22.3.5.4
Subledger
22.3.5.5
As Of
22.3.5.6
Journal Entries
22.3.5.7
Errors
23
Understanding Currency Restatement Methods
23.1
Currency Restatement Methods
23.1.1
Example: Currency Restatement
24
Performing Detailed Currency Restatement
24.1
Understanding Detailed Currency Restatement
24.1.1
Example: Detailed Currency Restatement and Ledgers Used
24.1.2
Understanding Detailed Currency Restatement Gains and Losses on Domestic Transactions
24.1.2.1
Example: Detailed Currency Restatement Gain/Loss on a Domestic Transaction
24.1.3
Understanding Detailed Currency Restatement Gains and Losses on Foreign Transactions
24.1.3.1
Example: Detailed Currency Restatement Gains/Losses on a Foreign Transaction
24.2
Working With Journal Entries for Detailed Currency Restatement
24.2.1
Forms Used to Work with Detailed Currency Restatement
24.2.2
Overriding Exchange Rates and Preventing XA Records from Being Created
24.2.3
Reviewing and Approving Detailed Currency Restatement Transactions
24.3
Processing Detailed Currency Restatement
24.3.1
Understanding the Detailed Currency Restatement Program
24.3.1.1
Transactions Processed by Detailed Currency Restatement
24.3.1.2
Common Error Messages and Causes
24.3.2
Setting Data Selection and Sequence for Detailed Currency Restatement
24.3.3
Setting Processing Options for Detailed Currency Restatement (R11411)
24.3.3.1
Ledgers
24.3.3.2
Post
24.3.3.3
Automatic JEs
24.3.3.4
Exchange Rate
24.3.4
Running the Detailed Currency Restatement Program From the Menu
24.3.5
Running the Detailed Currency Restatement Program From the Post Program
24.4
Posting Detailed Currency Restatement Transactions
25
Performing Balance Restatement
25.1
Understanding Balance Restatement
25.1.1
Prerequisite
25.2
Calculating Restated Balances for Balance Restatement
25.2.1
Understanding the Compute Restated Balances Program
25.2.1.1
How the Balance Restatement Program Works
25.2.1.2
Manual Journal Entries in the AC Ledger
25.2.1.3
Calculating Retained Earnings for the AC Ledger
25.2.2
Running the Compute Restated Balances Program
25.2.3
Setting Processing Options for Compute Restated Balances (R11414A)
25.2.3.1
Mode
25.2.3.2
Period or YTD
25.2.3.3
Zero Balance
25.2.3.4
Computation ID
25.2.3.5
Ledger
25.2.3.6
Exchange Rate
25.2.3.7
Adjustments
26
Performing As If Restatement
26.1
Understanding As If Restatement
26.1.1
Prerequisites
26.2
Calculating Balances for As If Restatement
26.2.1
Understanding the As If Repost Program
26.2.2
Running the As If Repost Program
26.2.3
Setting Data Selection for As If Repost
26.2.4
Setting Processing Options for As If Repost (R11415)
26.2.4.1
Conversion Date
26.2.4.2
Mode
26.2.4.3
Ledger Type
27
Working with Multisite Consolidations in Multiple Currencies
27.1
Understanding Multisite Consolidations with Multiple Currencies
27.1.1
Example: Multisite Consolidations with Multiple Currencies
27.2
Understanding the Basic Steps for Multisite Consolidations with Multiple Currencies
27.2.1
Example: Basic Steps for Multisite Consolidations with Multiple Currencies
27.2.2
Source Site
27.2.3
Target Site
27.3
Setting Up Consolidation Rules for Multiple Currencies
27.3.1
Understanding Consolidation Rules for Multiple Currencies
27.3.2
Form Used to Set Up Consolidation Rules for Multiple Currencies
27.3.3
Defining Consolidation Rules for Multiple Currencies
27.3.3.1
Additional Setup
28
Understanding Cash Forecasting in Multiple Currencies
28.1
Cash Forecasting Programs for Multiple Currencies
28.1.1
Multicurrency Considerations
29
Changing from Summarized Balances to Balances by Currency
29.1
Understanding How to Post Balances by Currency
A
Mapping Requirements for Processing External Exchange Rates
A.1
Mapping Multicurrency Fields in the F0015Z1 Workfile
A.1.1
Required Fields in the F0015Z1 Workfile
A.1.2
Optional Fields in the F0015Z1 Workfile
A.1.3
System-Supplied Field Values in the F0015Z1 Workfile
A.1.4
Unused Fields in the F0015Z1 Workfile
B
Mapping Requirements for Processing Multicurrency Batch Journal Entries
B.1
Mapping Requirements for Multicurrency Journal Entries
B.1.1
Prerequisite
B.1.2
Guidelines for Amount, Exchange Rate, and Currency Mode Fields for Batch Journal Entries
B.1.3
Multicurrency Fields Required in the F0911Z1 Table
C
Mapping Requirements for Processing Multicurrency Batch Invoices
C.1
Mapping Requirements for Processing Foreign Batch Invoices
C.1.1
Prerequisite
C.1.2
Guidelines for Amount, Exchange Rate, and Currency Mode Fields for Batch Invoices
C.1.3
Multicurrency Fields Required in the F03B11Z1 and F0911Z1 Tables
C.1.3.1
Multicurrency Fields Required in the F03B11Z1 Table
C.1.3.2
Multicurrency Fields Required in the F0911Z1 Table
D
Mapping Requirements for Processing Multicurrency Automatic Receipts
D.1
Multicurrency Fields Required in the F03B13Z1 Table
E
Mapping Requirements for Processing Multicurrency Batch Vouchers
E.1
Mapping Requirements for Multicurrency Batch Vouchers
E.1.1
Prerequisite
E.1.2
Guidelines for Amount, Exchange Rate, and Currency Mode Fields for Batch Vouchers
E.1.3
Multicurrency Fields Required in the F0411Z1 and F0911Z1 Tables
E.1.3.1
Multicurrency Fields Required in the F0411Z1 Table
E.1.3.2
Multicurrency Fields Required for F0911Z1
F
Mapping Requirements for Processing Multicurrency Inbound EDI Vouchers
F.1
Mapping Requirements for Multicurrency Inbound EDI Vouchers
F.1.1
Multicurrency Fields Required in the F47041 Table
F.1.2
Multicurrency Fields Required in the F47042 Table
F.1.3
Multicurrency Fields Required in the F47044 Table
G
JD Edwards EnterpriseOne Multicurrency Reports
G.1
Multicurrency Reports
G.2
JD Edwards EnterpriseOne Multicurrency Reports: A to Z
G.3
JD Edwards EnterpriseOne Selected Multicurrency Reports
G.3.1
R03B413B - Open A/R Detail - Summarized with Currency
G.3.2
Processing Options for Open A/R Detail - Summarized with Currency Report (R03B413B)
G.3.2.1
Aging
G.3.2.2
Aging Categories
G.3.2.3
Age Credits
G.3.2.4
Print Options
G.3.3
R03B4201A - Open A/R Detail with Remarks Report
G.3.4
R03B4201B - Open A/R Detail with Aging Report
G.3.5
R03B429A - Currency Detail - Foreign and Domestic
G.3.6
Processing Options for Currency Detail - Foreign and Domestic (R03B429A)
G.3.6.1
Print
G.3.7
R03B429B - Currency Detail - Aging
G.3.8
Processing Options for Currency Detail - Aging (R03B429B)
G.3.8.1
Aging
G.3.8.2
Print
G.3.9
R03B429C - Currency - Foreign/Domestic with Aging
G.3.10
Processing Options for Currency - Foreign/Domestic with Aging (R03B429C)
G.3.11
R04413A, R04413C, and R04413D - Open Accounts Payable Summary Reports for Multicurrency
G.3.12
Processing Options for Open Accounts Payable Summary Reports (R04413A, R04413C, and R04413D)
G.3.12.1
Aging
G.3.12.2
Print
G.3.13
Data Sequence for Open Accounts Payable Summary Reports
G.3.14
R04427A, R04427B, R04427C, R04427D, R04427E, and R04427F - Open Accounts Payable with Foreign Amounts Reports
G.3.15
Data Sequence for Open A/P with Foreign Amounts Reports
G.3.16
Processing Options for Open Accounts Payable with Foreign Amounts Reports (R04427A and R04427D)
G.3.16.1
Print
G.3.17
Processing Options for Open Accounts Payable with Foreign Amounts Reports (R04427B, R04427C, R04427E, and R04427F)
G.3.18
R04428C - A/P Detail by Approver with Foreign Currency Aging
G.3.19
Processing Options for A/P Detail By Approver with Foreign Currency Aging (R04428C)
G.3.19.1
Aging
G.3.20
R04431 - Cash Requirements Report
G.3.21
Intercompany Accounts in Balance (R097011)
G.3.22
Processing Options for Intercompany Accounts in Balance (R097011)
G.3.22.1
Ledger Type
G.3.23
R09707 - Foreign Account Balances
G.3.24
Processing Options for Foreign Account Balances (R09707)
G.3.24.1
Mode
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.