Power BI with your accounting data

BIMetaData - Sage 50 Accounts - data about your data

Posted by Hugh Johnson on 19-Apr-2018 16:41:44

Sage 50 Accounts OData feed for Power BI

The BIMetaData table is part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table provides data about your Sage 50 dataset and your Suntico subscription.  Use this table to determine how up-to-date your Sage 50 dataset is in Power BI.

Read More

Topics: Power BI Desktop, OData, metadata, Sage 50 Accounts

BIDepartments - Sage 50 Accounts - Departments list

Posted by Hugh Johnson on 19-Apr-2018 16:23:34

Sage 50 Accounts OData feed for Power BI

This article describes the BIDepartments table that forms part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.    The table provides a list of all of your Sage 50 Departments.

It is related to the BITransSplits so that if you can produce Departmental Profit & Loss reports if this is how you are using Sage 50 Departments.  You can also use this table to produce a list of Departments used in your Sage 50 system. 

Read More

Topics: Power BI Desktop, OData, Sage 50 Accounts, Departments

BINominalBudgets - Sage 50 Accounts Nominal Budgets

Posted by Hugh Johnson on 19-Apr-2018 15:44:22

Sage 50 Accounts OData feed for Power BI

This article describes the BINominalBudgets table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table provides a list of all of the nominal budgets for each of the nominal accounts and for each accounting period 1 thru 12.  Note that these periods refer to the months of the currently open financial year in Sage 50 and may not necessarily be the same as the periods of the current financial year if the company (for example it the previous year has not yet been closed off in Sage 50 Accounts).

This table is essential if you want to compare actual vs budgeted performance by nominal code.  This table does not hold the breakdown on nominal code budgets by department.

Read More

Topics: Power BI Desktop, OData, nominal records, Sage 50 Accounts, nominal budgets

BINominalRecords - Sage 50 Accounts Nominal Records

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

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.  

Read More

Topics: Power BI Desktop, OData, nominal records, Sage 50 Accounts

BIPurchaseOrderLines - Sage 50 Accounts Purchase Orders Lines table

Posted by Hugh Johnson on 19-Apr-2018 14:15:41

Sage 50 Accounts OData feed for Power BI

This article describes the BIPurchaseOrderLines table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.   This table is derived from the underlying Sage 50 Accounts POP_ITEM ODBC table. 

This table is essential if you want to analyse your Sage 50 Purchase Orders at the product line item level.

Read More

Topics: ODBC, Power BI Desktop, OData, purchase orders, Sage 50 Accounts

BISupplierCurrencies - Sage 50 Accounts Supplier Currencies table

Posted by Hugh Johnson on 19-Apr-2018 10:34:35

Sage 50 Accounts OData feed for Power BI

This article describes the BISupplierCurrencies table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.    This table is a duplicate of the BICurrencies table and included to avoid relational ambiguity between BISuppliers, BICustomers and BITransSplits.

This table is essential if you want to analyse your Sage 50 purchases by currency.

Read More

Topics: Power BI Desktop, OData, currencies, suppliers, Sage 50 Accounts

BISuppliers - Sage 50 Accounts Suppliers table

Posted by Hugh Johnson on 18-Apr-2018 21:57:11

Sage 50 Accounts OData feed for Power BI

This article describes the BISuppliers table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  The table is derived from the underlying Sage 50 Accounts PURCHASE_LEDGER ODBC table. 

This table is essential if you want to analyse your Sage 50 purchases by supplier or currency.

Read More

Topics: ODBC, Power BI Desktop, OData, suppliers, Sage 50 Accounts

BISalesOrders - Sage 50 Accounts Sales Orders table

Posted by Hugh Johnson on 18-Apr-2018 21:11:17

Sage 50 Accounts OData feed for Power BI

The Suntico BI OData feed turns your Sage 50 Accounts system into an online business intelligence data source for tools like Microsoft Power BI.  This article describes the BISalesOrders table.  This table is derived from a number of underlying Sage 50 Accounts SALES_ORDER ODBC table. 

This table is essential if you want to analyse your Sage 50 Sales Orders.

Read More

Topics: ODBC, Power BI Desktop, OData, sales orders, Sage 50 Accounts

BIStocks - Sage 50 Accounts Stocks (Products) table

Posted by Hugh Johnson on 18-Apr-2018 19:19:07

Sage 50 Accounts OData feed for Power BI

This article describes the BIStocks table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table is derived from the Sage 50 Accounts "STOCK" ODBC table.

This table is essential if you want to analyse sales and margin by stock category or to analyse stock levels.

Read More

Topics: Power BI Desktop, OData, stock, Sage 50 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