by Hugh Johnson, Posted on 4/19/2018 2:45:46 PM
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.
|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|
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?