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