Power BI Desktop, OData, stock, Sage 50 Accounts
Hugh Johnson @4/18/2018 7:19:07 PM
BIStocks - Sage 50 Accounts Stocks (Products) table
The BIStocks table in the Suntico Sage 50 Accounts OData feed for Power BI provides stock (product) information inlcluding costs, selling prices and stock levels. Why not try it now?
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.