Power BI with your accounting data

BICategories - Sage 50 Accounts Nominal Categories

Posted by Hugh Johnson on 19-Apr-2018 15:07:06
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

This article describes the BICategories table that forms part of the Suntico Sage 50 Accounts OData feed for Power BI.  This table provides a list of all of the nominal categories for each chart of accounts that you have defined in Sage 50 Accounts.

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

BICategories table

 

Column Type Description
CategoryID Whole Number Unique ID
Category Text Category number (e.g. 4 = "Overheads")
Chart Whole Number Chart of Accounts reference
SortOrder Whole Number Sort order for display in reports
Name Text Category name e.g. "Motor Expenses"
High Text Upper bound for nominal accounts
Low Text Lower bound for nominal accounts

BICategories relationships

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

 

BICategories table 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, Accounting, Reporting, Power BI Pro, Power BI Desktop, accountants, ODBC, power bi datasources, OData, nominal records, nominal categories