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.