Totalling by account and currency

Chez

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.

 

<?for-each-group:G_1;./ACCOUNT?><?sort:current-group()/ACCOUNT;'ascending';data-type='text'?><?sort:current-group()/CURRENCY;'ascending';data-type='text'?>

 

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

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

Tam

YGUTTIKONDA

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

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

YGUTTIKONDA

Tam,

Are you trying to group by just the ACCOUNT ? As your template indicates the same .. so you will get one record of the Account

And there are multiple records for Company ex:1432 has all the records on the output.. its not clear what your requirement / issue is.. can you clarify ..

or send the mock up of what you are looking for..

--YG