Power BI

BISalesOrderLines - Sage 50 Accounts Sales Order Lines table

ODBC, Power BI Desktop, OData, sales orders

Hugh Johnson @4/18/2018 9:29:25 PM

BISalesOrderLines - Sage 50 Accounts Sales Order Lines table


Here are the BISalesOrderLines table details in the Suntico Sage 50 Accounts OData feed for Power BI. This table contains the Sage 50 Accounts Sales Order Lines - is the line item information for all of your Sales Orders and Quotes in your Sage 50 SOP module. Why not try it now?


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.


Power BI

BISalesOrders - Sage 50 Accounts Sales Orders table

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

Hugh Johnson @4/18/2018 9:11:17 PM

BISalesOrders - Sage 50 Accounts Sales Orders table


Details of the BISalesOrders table in the Suntico Sage 50 Accounts OData feed for Power BI. This table is the header information for all of your Sage 50 Accounts Sales Orders and Quotes from your Sage 50 SOP module. Why not try it now?


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.


Power BI

BIProductSales - Sage 50 Accounts Sales Invoices table

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

Hugh Johnson @4/18/2018 5:28:56 PM

BIProductSales - Sage 50 Accounts Sales Invoices table


Sage 50 Accounts Sales Invoices data with the sales invoice headers, line item details, historic line item margin, delivery address. Everything you need to analyse your product sales in Power BI. Why not try it now?


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.


  • 1-10

Copyright © 2019,
Accounting Insights Ltd.
All Rights Reserved.

Our Office :
Unit 4, Roof Garden Offices,
Clarehall Shopping Centre,
Dublin,
Ireland

+353 1 567 4069