Solved

Are Balance sheets and Income statements possible in Acumatica with Power BI?

  • 15 November 2021
  • 3 replies
  • 145 views
A
Rank
Userlevel 1
Badge

Hi all. Are Balance sheets and Income statements possible in Acumatica with Power BI?

icon

Best answer by vkumar 17 November 2021, 07:19

View original
Andre Aysen

3 replies

V
Rank
Userlevel 7
Badge +11

Hi @andre89 

You can pull existing Generic Inquires on PowerBI using Odata connection. I don't see a possibility to pull Financial report information using Generic Inquiry (there are no out of the box Generic inquiry as well). Hence, I don't see an option to get the information on Power BI at present. 

 

Regards
 

VijayKumarU
C
Rank
Userlevel 7
Badge +9

Hi @andre89 This is in addition to the details from @vkumar.

Please try the below approach and verify if this works.

The data required for the Financial Statements should be in the GLTran table. You can try creating a generic Inquiry with data from the GLTran table, and by enabling the ODATA checkbox.

This generic Inquiry can be pulled into Power BI and have the Balance Sheets reports designed in Power BI. 

Thanks

 

Chandra M
A
Rank
Userlevel 1
Badge

Done and dusted!!

Andre Aysen

Reply


Terms & ConditionsCookie settings
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