Power BI with your accounting data

BISuppliers - Sage 50 Accounts Suppliers table

Posted by Hugh Johnson on 18-Apr-2018 21:57:11
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

This article describes the BISuppliers table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  The table is derived from the underlying Sage 50 Accounts PURCHASE_LEDGER ODBC table. 

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

BISuppliers table

 

Column Type Description
SupplierID Text Link to related tables
AccountOnHold True/False Whether the account is on hold
AccountRef Text Supplier Account Ref from Sage 50
AccountStatus Text Supplier Account Status from Sage 50
Address1 Text Supplier address line 1
Address2 Text Supplier address line 2
Address3 Text Supplier address line 3
Address4 Text Supplier address line 4
Address5 Text Supplier address line 5
Balance Decimal Number Account balance
CreditLimit Decimal Number Account credit limit
DefNomCode Text Default nominal code
FirstInvoice Date/Time Date of first invoice
LastInvDate Date/Time Date of last invoice
LastPayDate Date/Time Date of last payment
Name Text Supplier name
CountryCode Text 2-alpha country code
DeptName Text Default supplier department
SupplierCurrencyID Text Link to BISupplierCurrencies table
PaymentDueDays Whole Number Default due days for supplier invoices
DeptNumber Text Default supplier department number

BISuppliers relationships

The BISuppliers table in the OData feed is related to the BISupplierCurrencies table via the [SupplierCurrencyID], the BITransSplits table via the [SupplierID], aand the BIPurchaseOrders table via the [SupplierID].

 BISuppliers 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, ODBC, OData, suppliers, Sage 50 Accounts