Sage 50 Accounts OData feed for Power BI
This article describes the BIDepartments table that forms part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI. The table provides a list of all of your Sage 50 Departments.
It is related to the BITransSplits so that if you can produce Departmental Profit & Loss reports if this is how you are using Sage 50 Departments. You can also use this table to produce a list of Departments used in your Sage 50 system.
|DeptID||Whole Number||Internal ID|
|DeptRef||Text||Dept Ref link to BITransSplits|
The BIDepartments table in the OData feed is by default related to the BITransSplits table as shown below. I have assumed that if you are using Sage 50 Departments to the fullest extent intended, then this is where you would want the relationship. If you need to you can edit this in Power BI Desktop.
In the Suntico BI OData feed for Sage 50 Accounts, Department information is contained in the following tables:
- BITransSplits - Sage 50 Accounts transactions
- BIStocks - Sage 50 Accounts stock records
- BICustomers - Sage 50 Accounts customers
- BISuppliers - Sage 50 Accounts suppliers
To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?