BISalesOrders - Sage 50 Accounts Sales Orders table

by Hugh Johnson, Posted on 4/18/2018 8:29:42 PM

 ODBC, Power BI Desktop, OData, sales orders, Sage 50 Accounts

BISalesOrders - Sage 50 Accounts Sales Orders table

Sage 50 Accounts OData feed for Power BI

The Suntico BI OData feed turns your Sage 50 Accounts system into an online business intelligence data source for tools like Microsoft Power BI.  This article describes the BISalesOrders table.  This table is derived from a number of underlying Sage 50 Accounts SALES_ORDER ODBC table. 

This table is essential if you want to analyse your Sage 50 Sales Orders.

BISalesOrders table

CustomerIDTextUnique ID to link to the BICustomers table
SalesOrderIDTextLink to the BISalesOrderLines table
OrderNumberTextSage 50 sales order number
DateIDTextLink to the BIDates table by order date
DespatchStatusTextSales order despatch status
InvoiceNumberTextRelated sales invoice number
TakenByTextTaken By field from the Sage sales order
InvoiceNetDecimal NumberNet items amount for the sales order
ForeignRateDecimal NumberExchange rate for the sales order
Analysis1TextCustom field for the sales order
Analysis2TextCustom field for the sales order
Analysis3TextCustom field for the sales order
TypeTextOrder type - e.g. product order or quote
DespatchDateDate/TimeDespatch date for the sales order

BISalesOrders relationships

The BISalesOrders table in the OData feed is related to the BICustomers table via the [CustomerID] and the related Sage 50 Accounts Sales Order Lines are in the BISalesOrderLines table via the [SalesOrderID].  The Dates table shown is also part of the OData feed.  

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



Copyright © 2019,
Accounting Insights Ltd.
All Rights Reserved.

Our Office :
Unit 4, Roof Garden Offices,
Clarehall Shopping Centre,

+353 1 567 4069

[email protected]