Skip to main content
Solved

Inter-Tenant Reporting

  • October 27, 2025
  • 3 replies
  • 137 views
  • Translate All
Freshman II

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

View original

3 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+14

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

Translate
I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
    Freshman II

    Thank you for the insight!

    Best regards,

    John Kihiu

    Translate
    Freshman II

    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

    Translate
      Terms & ConditionsAccessibility statement
      About Acumatica ERP system
      Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
      © 2008 — 2024  Acumatica, Inc. All rights reserved