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?

Create Suntico BI Trial Account 

 

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

Power BI with your accounting data

Time-saving tips, tricks, templates and tutorials

Subscribe to this blog for practical shortcuts to driving real insights from your accounting data with Power BI.

Expect:

  • How-to videos
  • Example reports
  • Sample formulae
  • Data modeling tips
  • Free Power BI templates
  • Tips for optimising Sage 50cloud

Subscribe to Email Updates

Recent Posts