EGL9+: Journal Edit Creates Intercompany Lines On Multi-BU Journal Instead Of Balancing It Using The Rounding Adjustment. (Doc ID 1476455.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

****Checked for Currency on July-03-2014****

Symptoms

  On :  9 version, Journal Edit

 

  ENVIRONMENT
  --------------------------
  - 9.0 bundle #7
  - Multibook ledger. Anchor BU has translate. Non-anchor BU has primary ledger only.
  - Currency Balance Option: Balance by All Currencies.
  - Rounding Adjustment: Adjust Last Journal lines


 
  ACTUAL BEHAVIOR  
  ----------------------------
  If the journal is entered/uploaded with foreign currency amount only, Journal edit creates interunit balancing lines rather than adding rounding adjustment

 
  EXPECTED BEHAVIOR
  ---------------------------------
  After journal edit creating base amounts and secondary ledger lines, user expects rounding adjustment to be added per currency rounding adjustment setup, ie last line adjustment.
 

  TEST STEPS
  -----------------------
  The issue can be reproduced at will with the following steps:
 

  1. Set up 2 business units as below

   - CAD01 in base CAD - Multiple ledgers ACTLCL (CAD ledger) and ACTUSD ( USD translate ledger)
   - USD01 in base USD - Singel ledger ACTUSD (USD ledger).
 

  2. Upload a spreadsheet journal with balanced foreign amount as below.

   - USD01 is header/anchor BU. Journal lines are entered in USD (Foreign currency = Base currency USD) to ACTUSD ledger.
   - CAD01 is non-anchor BU. Journal lines are entered in foreign currency USD to ACTLCL ledger (CAD ledger)
   - Since exchange rate is CAD 1.00 = USD 0.30, we expect round adjustment.

 

USD01 ACTUSD 640001 USD 1.00
USD01 ACTUSD 100002 USD -1.00
CAD01 ACTLCL 640001 USD 1.00
CAD01 ACTLCL 640002 USD 1.00
CAD01 ACTLCL 640003 USD 1.00
CAD01 ACTLCL 100002 USD -3.00


  3. Run batch journal edit.
 

  4. Additional interunit line is created for both primary ledger and secondary ledger although user expect these lines are created as rounding adjustment instead.
 

Primary ledger lines.

USD01 ACTUSD 640001 USD 1.00 USD 1.00  
USD01 ACTUSD 100002 USD -1.00 USD -1.00  
CAD01 ACTLCL 640001 USD 1.00 CAD 3.33  
CAD01 ACTLCL 640002 USD 1.00 CAD 3.33  
CAD01 ACTLCL 640003 USD 1.00 CAD 3.33  
CAD01 ACTLCL 100002 USD -3.00 CAD -10.00  
CAD01 ACTLCL 100100 USD 0.00 CAD 0.01 USD01

Secondary ledger lines

CAD01 ACTUSD 640001 CAD 3.33 USD 1.00  
CAD01 ACTUSD 640002 CAD 3.33 USD 1.00  
CAD01 ACTUSD 640003 CAD 3.33 USD 1.00  
CAD01 ACTUSD 100002 CAD -10.00 USD -3.00  
CAD01 ACTUSD 100100 CAD 0.01 USD 0.00 USD01

 

   WHAT IS WORKING
  ----------------------
  Last line rounding works in below scenario with same replication data/steps:
  - both anchor and non-anchor BU have same base currency CAD.
  - spreadsheet journal is entered with line amounts in foreign currency USD.
  - journal lines are balanced in foreign currency for both BU before edit.
  - After edit, since one BU is balanced in both base (CAD) and foreign currency (USD), there is no rounding adjustment expected
  - Another BU is balanced in foreign currency only hence rounding adjustment is expected. After edit, Rounding adjustment is added as expected either to the last line or as additional lines to balance the journal in base amount.


 
  BUSINESS IMPACT
  -----------------------
  The issue has the following business impact:
  Due to this issue, users has to manually correct the journal entry.

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