Power BI with your accounting data

BISalesOrderLines - Sage 50 Accounts Sales Order Lines table

Posted by Hugh Johnson on 18-Apr-2018 21:29:25

Sage 50 Accounts OData feed for Power BI

This article describes the BISalesOrderLines table in the Suntico Sage 50 Accounts OData feed for the Power BI Sage 50 Accounts integration.  This table is derived from the underlying Sage 50 Accounts SOP_ITEM ODBC table. 

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

Read More

Topics: Power BI Desktop, ODBC, OData, sales orders

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: Power BI Desktop, ODBC, OData, sales orders, Sage 50 Accounts

BIProductSales - Sage 50 Accounts Sales Invoices table

Posted by Hugh Johnson on 18-Apr-2018 17:28:56

Sage 50 Accounts OData feed for Power BI

This article describes the BIProductSales table in the Suntico Sage 50 Accounts OData feed in the Suntico Power BI Sage 50 Accounts integration.  This table is derived from a number of underlying Sage 50 Accounts ODBC tables and provides details of all of the sales transactions created through the Sales Orders or Invoices & Credits modules in Sage 50.  It is essentially Sage 50 Accounts Sales Invoices with all the line item information and some further enrichments, for example to include gross margin of a transaction line item.

This table is essential if you want to analyse sales and margin by product code over time.

Read More

Topics: Power BI Desktop, ODBC, OData, sales invoices, product sales, sales orders

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