Skip to main content

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

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
 

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

 

Done and dusted!!

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