by Hugh Johnson, Posted on 4/19/2018 9:16:56 AM
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.
|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|
The BISupplierCurrencies table in the OData feed is related to the BISuppliers table via the [SupplierCurrencyID].
To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?