Table of Contents
...
Stock tran item is sales order line or po line join - so use vbi purchase order to stock tran item table (key on order id). Stock Tran item works for both PO and SO.
vbi_item for sale = can be service or stock item, v_bi item for sale = generic both goods and services have in common, vbi_article is stock item
Microsoft Power Bi process
...
The ideal place for this database is in SQL Azure - it is cheap and in the same place as Power Bi Online so data does not travel across your network for designing and refreshing the report data.
- For those that like excel it can also connect to Azure... https://blogs.technet.microsoft.com/office_online_support_blog/2015/10/29/excel-online-refreshing-data-to-a-sql-azure-database/ and https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/
...