Totalling by account and currency

Question

Summary Totalling by account and currency Content Good morning Guru's I am building a template that should display segment1, segment4, segment5 (of the ccid), entered dr, entered cr and currency. It should give me totals for each group of segment1, segment4, segment5 and currency. The script has delivered the xml by G_1 as per attached xml. So if in each G_1 the segment1, segment4, segment5 and currency is the same I want the output to give me one record totalling the columns of entered dr and entered cr. I have started off with the following in column 1 which is segment1. Refer attached template for details. For some reason it is missing some records. It seems as if it is only picking the first record for each group of segment1, segment4, segment5 and currency? Any help would be very much appreciated. Thanks Tam

Chez · Answer

Thank you YG that script looks promising... will check it out tomorrow.... :-)

Tam

YGUTTIKONDA · Answer

Tam,

I would suggest to post it in EBS group ... see below link if it may help

https://erp-integrations.com/2017/01/23/query-to-check-gl-balances-with-je-lines-balances-compare-period_balance-with-li…

--YG

Chez · Answer

Hi YG,

I was trying to group by ACCOUNT and then by CURRENCY. I have now been able to get this working correctly. Thank you very much for your quick reponse.

I am now however battling to bring in the beginning balances for a custom report from gl. The beginning balances as far as I can see is sititng on the gl_balances table but my data is predominantly coming from the gl_je_headers and gl_je_lines tables as I require to extract data relevant to entered amount and accounted amount which lies on the journal lines table.

Regards,

Tam