Power BI with your accounting data

BISupplierCurrencies - Sage 50 Accounts Supplier Currencies table

Posted by Hugh Johnson on 19-Apr-2018 10:34:35
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

This article describes the BISupplierCurrencies table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.    This table is a duplicate of the BICurrencies table and included to avoid relational ambiguity between BISuppliers, BICustomers and BITransSplits.

This table is essential if you want to analyse your Sage 50 purchases by currency.

BISupplierCurrencies table

 

Column Type Description
SupplierCurrencyID Text Link to BISuppliers table
SupplierCode Text 3-alpha currency code
Name Text Currency descriptive name
Rate Decimal Number Exchange Rate (currency(/(base currency)
BaseCurrency True/False Whether the currency is the base currency

BISupplierCurrencies relationships

The BISupplierCurrencies table in the OData feed is related to the BISuppliers table via the [SupplierCurrencyID].

 BISupplierCurrencies relationships Sage 50 Accounts

To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?

Use free for 30 days 

 

Topics: Power BI Desktop, OData, suppliers, currencies, Sage 50 Accounts