Skip to main content
Answer

Inter-Tenant Reporting

  • October 27, 2025
  • 3 replies
  • 56 views

Hello , 

I would like to inquire if it is possible to create a consolidated financial report for GL Transactions for multiple tenants using report designer. I think since all tenants share the same db this is possible to achieve? Any insights on this would be really helpful. Thanks

Best answer by nhatnghetinh

Hi ​@johnkihiu60 

The answer is yes but you need to create new DACs to get the tenants data to pull up the consolidated report.

 

Best Regards,

NNT

3 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • Answer
  • October 27, 2025

Hi ​@johnkihiu60 

The answer is yes but you need to create new DACs to get the tenants data to pull up the consolidated report.

 

Best Regards,

NNT


  • Author
  • Freshman II
  • October 27, 2025

Thank you for the insight!

Best regards,

John Kihiu


  • Author
  • Freshman II
  • October 30, 2025

Hello @nhatnghetinh ,

Thank you for your feedback on the previous question. I would like to follow up with another question, 

When creating the new DAC’s , Do I need to create new Views in the DB so as to generate the DACs or do I create DACs for the existing tables and exclude the Company ID?  

Thanks,

John Kihiu