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?

Create Suntico BI Trial Account 

 

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

Power BI with your accounting data

Time-saving tips, tricks, templates and tutorials

Subscribe to this blog for practical shortcuts to driving real insights from your accounting data with Power BI.

Expect:

  • How-to videos
  • Example reports
  • Sample formulae
  • Data modeling tips
  • Free Power BI templates
  • Tips for optimising Sage 50cloud

Subscribe to Email Updates

Recent Posts