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?

Create Suntico BI Trial Account 

 

Topics: ODBC, Power BI Desktop, OData, 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