Power BI with your accounting data

BICharts - Sage 50 Accounts - Charts of Accounts

Posted by Hugh Johnson on 19-Apr-2018 15:20:58
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

This article describes the BICharts table in the Suntico Sage 50 Accounts OData feed for Microsoft Power BI.  This table provides a list of all of your Sage 50 Charts of Accounts.

This table is essential if you want to perform profit & loss or balance sheet analysis at the nominal account (nominal code) category level for a given Chart of Accounts.

BICharts table

 

Column Type Description
Chart Whole Number Chart number link to BICategories
Name Text Category name e.g. "Motor Expenses"
Ref Whole Number Internal reference

BICharts relationships

The BICharts table in the OData feed is related to the BICategories table as shown below.

BICharts relationships in Sage 50 Accounts

 

 

To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?

Use free for 30 days 

 

Topics: Sage 50, Power BI Desktop, OData, chart of accounts