GL_BALANCES Table to fetch YTD balance for non-functional currencies inquiry
Hi Gurus,I just want to confirm my understand on the table GL_BALANCES which will be my source of data.
We need a report that will capture per periods YTD balance sheets of accounts for currencies not in company's functional currency.
My idea is to look into GL_BALANCES table and look for records that the TRANSLATED_FLAG = 'R' (Revaluation) and to calculate the YTD balance of the non-functional currency is = (BEGIN_BALANCE_DR – BEGIN_BALANCE_CR + PERIOD_NET_DR – PERIOD_NET_CR).
Could someone please verify the above, feel free to let me know if I'm missing something. TIA!
We need a report that will capture per periods YTD balance sheets of accounts for currencies not in company's functional currency.
My idea is to look into GL_BALANCES table and look for records that the TRANSLATED_FLAG = 'R' (Revaluation) and to calculate the YTD balance of the non-functional currency is = (BEGIN_BALANCE_DR – BEGIN_BALANCE_CR + PERIOD_NET_DR – PERIOD_NET_CR).
Could someone please verify the above, feel free to let me know if I'm missing something. TIA!
1