Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

GL Balances / Currencies - trial balance summary

sahar.zdOct 16 2020 — edited Oct 16 2020

Dear All,
i'm having a trouble differentiate between the entered currency & the functional Currency in GL_balances
how can get the amount entered in the entered currency i wrote this query but when it comes to the entered currency that is the same as the functional it gives the functional amount :
please check the blow query :
"
select
SUM( NVL(period_net_dr,0) ) PERIOD_DR,
SUM( NVL(period_net_cr,0) ) PERIOD_CR,
currency_code
from GL_BALANCES BAL, GL_CODE_COMBINATIONS CC
where BAL.ACTUAL_FLAG = 'A'
AND BAL.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID
AND CC.SEGMENT3 BETWEEN NVL(:P_FROM_GL_ACCOUNT,CC.SEGMENT3) AND NVL(:P_TO_GL_ACCOUNT,CC.SEGMENT3)
and CC.CHART_OF_ACCOUNTS_ID = :STRUCT_NUM
AND CC.TEMPLATE_ID IS NULL
AND BAL.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID
AND BAL.ledger_id = :P_SET_OF_BOOKS_ID
AND BAL.ACTUAL_FLAG = 'A'
AND BAL.PERIOD_NUM BETWEEN :FROM_PERIOD_NUM AND :TO_PERIOD_NUM
AND BAL.PERIOD_YEAR BETWEEN :FROM_PERIOD_YEAR AND :TO_PERIOD_YEAR
group by currency_code,BAL.PERIOD_NUM,BAL.PERIOD_YEAR,BAL.ACTUAL_FLAG,BAL.TRANSLATED_FLAG
"

thank you in advance

Comments
Post Details
Added on Oct 16 2020
1 comment
538 views