BICharts - Sage 50 Accounts Charts of Accounts


by Hugh Johnson, Posted on 4/19/2018 3:11:16 PM

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

BICharts - Sage 50 Accounts Charts of Accounts

Sage 50 Accounts OData feed for Power BI

This article describes the BICharts table in the Suntico Sage 50 Accounts OData feed in the Suntico Power BI Sage 50 integration.  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 specified Chart of Accounts.

BICharts table

ColumnTypeDescription
ChartWhole NumberChart number link to BICategories
NameTextCategory name e.g. "Motor Expenses"
RefWhole NumberInternal reference

BICharts relationships

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

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

 

 


Copyright © 2019,
Accounting Insights Ltd.
All Rights Reserved.

Our Office :
Unit 4, Roof Garden Offices,
Clarehall Shopping Centre,
Dublin,
Ireland

+353 1 567 4069

[email protected]