E!: 48S/52: WorkFile Generation Pulls In the Incorrect Currency Amount When Journal Entry Has Multiple Currencies (R48120, F4812)

(Doc ID 2329806.1)

Last updated on NOVEMBER 20, 2017

Applies to:

JD Edwards EnterpriseOne Contract and Service Billing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When a user creates a journal entry that crosses companies (business units/accounts) with multiple currencies, the Workfiles generation (R48120) is incorrectly bringing in the wrong currency amount into the workfile table (F4812).  This is noted when the journal entry is entered for Company with CURR 1 but the first line in the journal entry is for Company with CURR 2.  The journal entry is entered with the currency code for the first entry line.  The post correctly records the amounts for each currency.  However, when the R48120 runs over the F0911 table for the billable amounts, it is bringing over the wrong currency amount (Brings the amount over without regard to exchange rate).

This can duplicated with the following steps:

  1. Using two companies - USD (co 50) and CAD (co 77)
  2. Using Jobs under each company - BU 6100 (CO 50, USD) and BU 7100 (Co 77, CAD)
  3. Create two accounts for each BU. 6100.7310 and 7100.7310
  4. Create contract 149 for BU 7100 (CAD)
  5. TEST 1: Create Journal Entry with USD account as first line for CAD Company and Post. Expect 18975.00 CAD to come into CSB.
  6. TEST 2: Create Journal Entry with USD account as first line for USD Company and Post. Expect 18975.00 CAD to come into CSB.
  7. TEST 3: Create Journal Entry with CAD account first for CAD Company and Post. Expect 8250.00 CAD to come into CSB.
  8. TEST 4: Create Journal Entry with CAD account first for USD Company and Post. Expect 8250.00 CAD to come into CSB.
  9. Run R48120 for each batch individually. (I.e. run R48120 four times using data selection where F0911.ICU=Batch number from test).
  10. Review Workfile Revisions showing incorrect amounts from what is expected based upon Journal Entries. Test 1 brings in 8250 CAD for contract 149
  11. ANALYSIS:
Analysis
BATCH Test Expected CAD Amt (Post) Workfile Amount
10137074 1 18975.00 8250.00 (wrong)
10137075 2 18975.00 18975.00
10137077 3 8250.00 8250.00
10137078 4 8250.00 8250.00

 

 



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms