BICategories - Sage 50 Accounts Nominal Categories


by Hugh Johnson, Posted on 4/19/2018 2:45:46 PM

 OData, Sage 50 Accounts

BICategories - Sage 50 Accounts Nominal Categories

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 that you have set up as one of your Power BI data sources.  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

ColumnTypeDescription
CategoryIDWhole NumberUnique ID
CategoryTextCategory number (e.g. 4 = "Overheads")
ChartWhole NumberChart of Accounts reference
SortOrderWhole NumberSort order for display in reports
NameTextCategory name e.g. "Motor Expenses"
HighTextUpper bound for nominal accounts
LowTextLower bound for nominal accounts

BICategories relationships

The BICategories table in the OData feed is related to the BICharts 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]