EGL9.2: Journal Generator is not Populating Rate Type for Student Financials Journals When How Specified Option = 'Summarize to All Chartfields' for Journal Generator Template SF/GL.

Last updated on DECEMBER 27, 2016

Applies to:

Symptoms

On : 9.2 version, Journal Generator

ACTUAL BEHAVIOR
---------------
Rate Type is missing in journals generated from Student Financials through Journal Generator when How Specified Option = 'Summarize to All Chartfields' for Journal Generator Template SF/GL.
Rate Type field is populated in PS_SF_ACCTG_LN but not loaded to journal by Journal Generator.

EXPECTED BEHAVIOR
-----------------------
Rate Type should be populated in journals generated from Student Financials through Journal Generator when How Specified Option = 'Summarize to All Chartfields' for Journal Generator Template SF/GL.

WHAT IS WORKING?
-----------------------
Rate Type is populated in journals generated from Student Financials through Journal Generator when How Specified Option = ‘Retain Detail’ for Journal Generator Template SF/GL.

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

Test 1: How Specified Option = 'Summarize to All Chartfields' for Journal Generator Template SF/GL.

1. In Student Financials the business unit base currency is USD and in General Ledger the business unit base currency is PKR.
2. In Student Financials create some transactions and generate accounting entries (transaction currency and base currency are both USD).
3. Move Student Financials accounting entries to general Ledger (PS_SF_ACCTG_LN is populated). Record PS_SF_ACCTG_LN contains transactions where transaction currency and base currency is USD. (MONETARY_AMOUNT = 2500, CURRENCY_CD = USD, FOREIGN_AMOUNT = 2500, FOREIGN_CURRENCY = USD, RT_TYPE = CRRNT, RATE_DIV = 1 and RATE_MULT = 1)
4. Navigate to General Ledger > Journals > Subsystem Journals > Generate Journals and run Journal Generator to create a journal.
5. Review PS_JRNL_LN. At this moment MONETARY_AMOUNT = 2500, CURRENCY_CD = USD, FOREIGN_AMOUNT = 2500, FOREIGN_CURRENCY = USD, RT_TYPE = blank, RATE_DIV = 1 and RATE_MULT = 1. Please note RT_TYPE is blank, this is the source of the problem!
6. Navigate to General Ledger > Journals > Process Journals > Edit Journals. Make sure to check ‘Recalc Exchange Rates’ and run the batch journal edit process.
7. Review PS_JRNL_LN, only CURRENCY_CD is changed from USD to PKR. However, the MONETARY_AMOUNT and RATE_MULT are not changed. This is wrong because the RATE_MULT should be updated with rate from market rates table and the MONETARY_AMOUNT should be recalculated.

Test 2: How Specified Option = ‘Retain Detail’ for Journal Generator Template SF/GL.

1. In Student Financials the business unit base currency is USD and in General Ledger the business unit base currency is PKR.
2. In Student Financials create some transactions and generate accounting entries (transaction currency and base currency are both USD).
3. Move Student Financials accounting entries to General Ledger (PS_SF_ACCTG_LN is populated). Record PS_SF_ACCTG_LN contains transactions where transaction currency and base currency is USD. (MONETARY_AMOUNT = 2500, CURRENCY_CD = USD, FOREIGN_AMOUNT = 2500, FOREIGN_CURRENCY = USD, RT_TYPE = CRRNT, RATE_DIV = 1 and RATE_MULT = 1)
4. Navigate to General Ledger > Journals > Subsystem Journals > Generate Journals and run Journal Generator to create a journal.
5. Review PS_JRNL_LN. At this moment MONETARY_AMOUNT = 2500, CURRENCY_CD = USD, FOREIGN_AMOUNT = 2500, FOREIGN_CURRENCY = USD, RT_TYPE = CRRNT, RATE_DIV = 1 and RATE_MULT = 1. Please note this time RT_TYPE is populated, like it should be.
6. Navigate to General Ledger > Journals > Process Journals > Edit Journals. Make sure to check ‘Recalc Exchange Rates’ and run the batch journal edit process.
7. Review PS_JRNL_LN, field CURRENCY_CD is changed from USD to PKR, RATE_MULT is updated with rate from market rates table and MONETARY_AMOUNT is recalculated. Results are correct.

Test 3: First How Specified Option = 'Summarize to All Chartfields' and after 1st run change How Specified Option = ‘Retain Detail’ for for Journal Generator Template SF/GL.

1. Run the steps from Test 1 with How Specified Option = 'Summarize to All Chartfields' and after noticing the issue that the RT_TYPE is blank,
2. Change the Journal Generator Template SF/GL with How Specified Option = ‘Retain Detail’
3. Navigate to General Ledger > Journals > Process Journals > Edit Journals. Make sure to check ‘Recalc Exchange Rates’ and run the batch journal edit process.
4. When reviewing the results, process goes to No success with user is receiving a message error:
"RT_TYPE Rate Type 104 9 TSE Prompt table edit; value not found in prompt table"

BUSINESS IMPACT

-----------------------
The issue has the following business impact:
Due to this issue, journals have wrong monetary amount in General Ledger. The ledger is updated with wrong numbers!

Cause