Solved

Generic Inquiry - How can i create a GI which should display the Budgets for Revenue A/C (40000) and Sub A/C combination by Period

Budgets for Revenue A/C (40000) and Sub A/C combination by Period

Userlevel 7

+5

Hi @nasirh85

Please refer to the screenshots and attached .xml file.

Best Regards,

NNT

Hi Everyone. If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*

Userlevel 3

And for the Same if i want to display the company ID and tenant ID which table and relation i can use it?

Userlevel 7

+5

Hi @nasirh85

You need to do a few additional operations: left join Organization DAC and cross join Company DAC.

Best Regards,

NNT

Sign up