Contents
1 Introduction to JD Edwards EnterpriseOne Multicurrency Processing
- JD Edwards EnterpriseOne Multicurrency Processing Overview
- JD Edwards EnterpriseOne Multicurrency Processing Integrations
- JD Edwards EnterpriseOne Multicurrency Processing Implementation
- Business Interface Integration Objects
2 Understanding Multicurrency Processing
3 Changing from a Non-Currency to a Multicurrency Environment
4 Understanding Multicurrency Setup
- Setup for Basic Multicurrency
- Setup for Exchange Rates
- Setup for AAI Unrealized Gains and Losses
- Setup for Posting Balances by Currency
- Setup for Multicurrency Intercompany Settlements
- Setup for Detailed Currency Restatement
- Setup for Balance Restatement
- Setup for As If Restatement
5 Setting Up General Accounting for Multicurrency Processing
- Understanding Multicurrency Setup for General Accounting
- Setting Up Multicurrency Constants
- Setting Up Currency Codes
- Setting Up Companies for Multicurrency Processing
- Setting Up Multicurrency AAIs for General Accounting
- Setting Up Monetary Accounts
- Setting Up Multicurrency Ledger Types
6 Setting Up Exchange Rates
- Understanding Exchange Rates
- Setting Up Exchange Rates for the Inverse Method
- Setting Up Exchange Rates for the No Inverse Method
- Setting Up Exchange Rates for the Triangulation Method
- Setting Up Multiple Exchange Rates for a Single Currency
- Uploading Exchange Rates from an External Source
- Processing External Exchange Rates
- Understanding the External Exchange Rate Processor Program
- Running the External Exchange Rate Processor Program
- Setting Processing Options for External Exchange Rate Processor (R0015Z1)
- Purging External Exchange Rate Records
- Setting Processing Options for External Currency Exchange Rates Purge (R0015Z1P)
- Setting Up Currency Cross-Rate Relationships
- Calculating Currency Cross-Rates
7 Setting Up Detailed Currency Restatement
- Understanding the Detailed Currency Setup Program
- Setting Up Detailed Currency Restatement
- Setting Up Ledger Types for Detailed Currency Restatement
- Setting Up AAIs for Detailed Currency Restatement
8 Setting Up Balance Restatement and As If Restatement
- Setting Up Balance Restatement
- Setting Up the Ledger Type and Rules for Balance Restatement
- Setting Up Restatement Rates for Balance Restatement
- Setting Up Computations for Balance Restatement
- Setting Up As If Restatement
9 Setting Up Accounts Receivable for Multicurrency Processing
- Setting Up Accounts Receivable for Multicurrency Processing
- Setting Up Customer Records for Multicurrency Processing
- Converting Customer Master Currency Codes
- Setting Up Multicurrency AAIs for Accounts Receivable
- Understanding Multicurrency AAIs for Accounts Receivable
- Setting Up AAIs for Receivable Bank Accounts in Foreign Currencies
- Setting Up AAIs for Receivable Trade Accounts in Foreign Currencies
- Setting Up AAIs for Unrealized Gains and Losses on Foreign Currency Invoices
- Setting Up AAIs for Realized Gains and Losses on Foreign Currency Receipts
- Setting Up AAIs for Realized Gains and Losses on Alternate Currency Receipts
- Setting Up AAIs for the Rounding Account for Foreign and Alternate Currency Receipts
- Setting Up AAIs for the Clearing Account for Alternate Currency Receipts
- Setting Up Credit and Collection Policies for Multicurrency Processing
10 Setting Up Accounts Payable for Multicurrency Processing
- Setting Up Accounts Payable for Multicurrency Processing
- Setting Up Supplier Records for Multicurrency Processing
- Converting Supplier Master Currency Codes
- Understanding Supplier Currency Conversion
- Understanding the Address Book Conversion Program
- Exceptions Report
- Example: Converting Supplier Amounts from U.S. Dollars to Canadian Dollars
- Before Converting Supplier Currency Codes
- After Converting Supplier Currency Codes
- Example: Converting Parent/Child Structure with Different Currencies
- Before Converting Currency Codes
- After Converting Currency Codes
- Running the Address Book Conversion - F0401 Program
- Setting Processing Options for Address Book Conversion - F0401 (R890401E)
- Setting Up Multicurrency AAIs for Accounts Payable
- Understanding Multicurrency AAIs for Accounts Payable
- Setting Up AAIs for Payable Bank Accounts
- Setting Up AAIs for Payable Trade Accounts
- Setting Up AAIs for Unrealized Gain and Losses on Foreign Currency Vouchers
- Setting Up AAIs for Realized Gains and Losses on Foreign Currency Payments
- Setting Up AAIs for Realized Gains and Losses on Alternate Currency Payments
- Setting Up AAIs for the Clearing Account for Alternate Currency Payments
- Setting Up Payment Translation Codes
- (MEX) Setting Up Payment Translation Codes
11 Entering and Processing Foreign Currency Journal Entries
- Understanding Journal Entries in a Foreign Currency
- Understanding Intercompany Journal Entries in a Foreign Currency
- Understanding Batch Journal Entries in a Foreign Currency
- Entering Journal Entries in a Foreign Currency
- Posting Journal Entries in a Foreign Currency
12 Using Multicurrency Inquiries for General Accounting
- Understanding Multicurrency Inquiries for General Accounting
- Reviewing Accounts in Domestic, Foreign, and As If Currencies
- Understanding How to Review Accounts In Domestic, Foreign, and As If Currencies
- Forms Used to Review Accounts in Domestic, Foreign, and As If Currencies
- Reviewing Accounts in Domestic And Foreign Currencies
- Reviewing Accounts with Domestic and As If Currency Amounts
- Reviewing Accounts With Domestic Amounts in an As If Currency
- Reviewing Accounts With Foreign Amounts in an As If Currency
- Reviewing Account Balances by Currency
13 Entering and Processing Foreign Currency Invoices
- Understanding Foreign Currency Invoices
- Understanding Domestic Versus Foreign Currency Invoices
- Understanding Rounding Versus Soft Rounding
- Understanding How Domestic Amounts Are Calculated on Foreign Invoices Without Taxes
- Understanding How Domestic Amounts Are Calculated on Foreign Invoices with Taxes
- Understanding Multicurrency Batch Totals
- Understanding How to Process Foreign Currency Batch Invoices
- Entering Invoices in a Foreign Currency
- Understanding Foreign Currency Invoice Entry
- Prerequisite
- Forms Used to Enter Invoices in a Foreign Currency
- Setting Multicurrency Processing Options for the Standard Invoice Entry Program (P03B11)
- Setting Multicurrency Processing Options for Invoice Entry MBF (P03B0011)
- Entering an Invoice in a Foreign Currency
- Reviewing Invoices in a Foreign and As If Currency
- Posting Foreign Currency Invoices
14 Processing Foreign and Alternate Currency Receipts
- Understanding Foreign and Alternate Receipts Entry
- Programs to Enter Foreign and Alternate Currency Receipts and Foreign Drafts
- Understanding Domestic Currency Receipts
- Understanding Foreign Currency Receipts
- Understanding Alternate Currency Receipts
- Understanding Multicurrency and Receipt Types
- Understanding Multicurrency Fields Updated During Receipt and Draft Entry
- Prerequisites
- Entering Manual Receipts in Foreign and Alternate Currencies
- Processing Automatic Receipts and Automatic Debits in Foreign Currencies
- Generating Credit Reimbursements in Foreign Currencies
- Processing Accounts Receivable Drafts in Foreign Currencies
- Posting Foreign and Alternate Currency Receipts
- Understanding the Post Process for Foreign and Alternate Currency Receipts
- Posting Receipts to Monetary Bank Accounts
- Slight Rounding Differences Recorded by the Receipt Post
- Example: Slight Rounding Differences Recorded by the Receipt Post
- Multicurrency Journal Entries Created by the Receipt and Draft Post
- Multicurrency Automatic Entries Created by the Receipt and Draft Post
- Posting Foreign and Alternate Currency Receipts
- Understanding the Post Process for Foreign and Alternate Currency Receipts
15 Managing Credit and Collections for Multiple Currencies
- Generating and Reviewing Multicurrency Statements
- Generating and Reviewing Multicurrency Delinquency Notices
- Understanding Multicurrency Delinquency Notices
- Forms Used to Review Multicurrency Delinquency Notices
- Printing Delinquency Notices in Multiple Currencies
- Set Multicurrency Processing Options for A/R Delinquency Notices Print (R03B20) and Tiered Delinquency Notice Print (R03B21)
- Review Multicurrency Delinquency Notices
- Generating and Reviewing Multicurrency Delinquency Fees
- Reviewing Customer Accounts in Multiple Currencies
16 Processing Currency Gains and Losses for Accounts Receivable
- Understanding Currency Gains and Losses
- Prerequisites
- Generating the A/R Unrealized Gain/Loss Report
17 Entering and Processing Foreign Currency Vouchers
- Understanding Foreign Vouchers
- Understanding Domestic Versus Foreign Currency Transactions
- Understanding Rounding Versus Soft Rounding
- Understanding How Domestic Amounts Are Calculated on Foreign Vouchers without Taxes
- Understanding How Domestic Amounts Are Calculated on Foreign Vouchers with Taxes
- Understanding Multicurrency Batch Totals
- Understanding How to Process Foreign Batch Vouchers
- Understanding How to Process Foreign Inbound EDI Vouchers
- Entering Vouchers in a Foreign Currency
- Reviewing Vouchers in Foreign and As If Currencies
- Posting Foreign Currency Vouchers
18 Entering Manual Foreign and Alternate Currency Payments
- Understanding Multicurrency Payments
- Entering Manual Payments
- Understanding Manual Payments in a Foreign Currency
- Understanding Manual Payments in an Alternate Currency
- Prerequisites
- Forms Used to Enter Manual Payments in a Foreign or Alternate Currency
- Setting Multicurrency Processing Options for A/P Manual Payments (P0413M)
- Entering a Manual Payment in a Foreign Currency
- Entering a Manual Payment in an Alternate Currency
- Entering Accounts Payable Drafts in Foreign Currencies
19 Processing Automatic Payments in a Foreign or an Alternate Currency
- Understanding Automatic Payments in a Foreign or an Alternate Currency
- Creating Payment Groups in a Foreign and an Alternate Currency
- Writing and Updating Foreign and Alternate Currency Payment Groups
- Posting Foreign and Alternate Currency Payments
20 Processing Currency Gains and Losses for Accounts Payable
- Understanding Currency Gains and Losses
- Prerequisites
- Generating the A/P Unrealized Gain/Loss Report
21 Processing Bank Statements Manually in Multiple Currencies
- Processing Bank Statements Manually in Multiple Currencies
- Multicurrency Considerations for Manual Bank Statement Processing
- Examples: Currencies and the Bank Statement Entry Program
- Entering Multicurrency Bank Statements
22 Performing Monetary Account Valuation
- Understanding Monetary Valuation for Bank Accounts
- Understanding Monetary Valuation for Open Invoices and Vouchers
- Calculating Unrealized Gains and Losses on Monetary Accounts
23 Understanding Currency Restatement Methods
24 Performing Detailed Currency Restatement
- Understanding Detailed Currency Restatement
- Working With Journal Entries for Detailed Currency Restatement
- Processing Detailed Currency Restatement
- Understanding the Detailed Currency Restatement Program
- Setting Data Selection and Sequence for Detailed Currency Restatement
- Setting Processing Options for Detailed Currency Restatement (R11411)
- Running the Detailed Currency Restatement Program From the Menu
- Running the Detailed Currency Restatement Program From the Post Program
- Posting Detailed Currency Restatement Transactions
25 Performing Balance Restatement
- Understanding Balance Restatement
- Calculating Restated Balances for Balance Restatement
26 Performing As If Restatement
27 Working with Multisite Consolidations in Multiple Currencies
- Understanding Multisite Consolidations with Multiple Currencies
- Understanding the Basic Steps for Multisite Consolidations with Multiple Currencies
- Setting Up Consolidation Rules for Multiple Currencies
28 Understanding Cash Forecasting in Multiple Currencies
29 Changing from Summarized Balances to Balances by Currency
30 Appendix A - Mapping Requirements for Processing External Exchange Rates
31 Appendix B - Mapping Requirements for Processing Multicurrency Batch Journal Entries
32 Appendix C - Mapping Requirements for Processing Multicurrency Batch Invoices
33 Appendix D - Mapping Requirements for Processing Multicurrency Automatic Receipts
34 Appendix E - Mapping Requirements for Processing Multicurrency Batch Vouchers
35 Appendix F - Mapping Requirements for Processing Multicurrency Inbound EDI Vouchers
36 Appendix G - JD Edwards EnterpriseOne Multicurrency Reports
- Multicurrency Reports
- JD Edwards EnterpriseOne Multicurrency Reports: A to Z
- JD Edwards EnterpriseOne Selected Multicurrency Reports
- R03B413B - Open A/R Detail - Summarized with Currency
- Processing Options for Open A/R Detail - Summarized with Currency Report (R03B413B)
- R03B4201A - Open A/R Detail with Remarks Report
- R03B4201B - Open A/R Detail with Aging Report
- R03B429A - Currency Detail - Foreign and Domestic
- Processing Options for Currency Detail - Foreign and Domestic (R03B429A)
- R03B429B - Currency Detail - Aging
- Processing Options for Currency Detail - Aging (R03B429B)
- R03B429C - Currency - Foreign/Domestic with Aging
- Processing Options for Currency - Foreign/Domestic with Aging (R03B429C)
- R04413A, R04413C, and R04413D - Open Accounts Payable Summary Reports for Multicurrency
- Processing Options for Open Accounts Payable Summary Reports (R04413A, R04413C, and R04413D)
- Data Sequence for Open Accounts Payable Summary Reports
- R04427A, R04427B, R04427C, R04427D, R04427E, and R04427F - Open Accounts Payable with Foreign Amounts Reports
- Data Sequence for Open A/P with Foreign Amounts Reports
- Processing Options for Open Accounts Payable with Foreign Amounts Reports (R04427A and R04427D)
- Processing Options for Open Accounts Payable with Foreign Amounts Reports (R04427B, R04427C, R04427E, and R04427F)
- R04428C - A/P Detail by Approver with Foreign Currency Aging
- Processing Options for A/P Detail By Approver with Foreign Currency Aging (R04428C)
- R04431 - Cash Requirements Report
- Intercompany Accounts in Balance (R097011)
- Processing Options for Intercompany Accounts in Balance (R097011)
- R09707 - Foreign Account Balances
- Processing Options for Foreign Account Balances (R09707)