Power BI with your accounting data

BINominalRecords - Sage 50 Accounts Nominal Records

Posted by Hugh Johnson on 19-Apr-2018 14:41:03
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

The BINominalRecords table is part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table provides a list of all of the nominal accounts (sometimes called "general ledger accounts") that form the company's chart of accounts.

This table is essential if you want to perform profit & loss or balance sheet analysis.  

BINominalRecords table

 

Column Type Description
NominalRecordID Text Link to the BITransSplits table
BudgetID Text Link to the BINominalBudgets table
AccountRef Text Account reference / nominal code
AccountType Text "Normal", "Control", or "Bank"
Balance Decimal Number Account balance
Name Text Name of the nominal account

BINominalRecords relationships

The BINominalRecords table in the OData feed is related to the BITransSplits table and the BINominalBudgets table as shown below.

Nominal Records 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: Power BI Desktop, OData, nominal records, Sage 50 Accounts