BISalesOrderLines - Sage 50 Accounts Sales Order Lines table


by Hugh Johnson, Posted on 4/18/2018 9:13:19 PM

 ODBC, Power BI Desktop, OData, sales orders

BISalesOrderLines - Sage 50 Accounts Sales Order Lines table

Sage 50 Accounts OData feed for Power BI

This article describes the BISalesOrderLines table in the Suntico Sage 50 Accounts OData feed for the Power BI Sage 50 Accounts integration.  This table is derived from the underlying Sage 50 Accounts SOP_ITEM ODBC table. 

This table is essential if you want to analyse your Sage 50 Sales Orders at the product line item level.

BISalesOrderLines table

ColumnTypeDescription
SalesOrderItemIDTextUnique internal ID for the record
SalesOrderIDTextUnique ID to link to BISalesOrders table
StockIDWhole NumberLink to the BIStocks table
DeliveryDateDate/TimeDespatch date for this line item
NetAmountDecimal NumberNet sales amount for this line item
QtyAllocatedDecimal NumberQuantity allocated from stock to this line
QtyDeliveredDecimal NumberQuantity despatched from this line
QtyDespatchDecimal NumberQuantity undespatched from this line
QtyOrderDecimal NumberQuantity ordered
UnitPriceDecimal NumberNet unit sales amount

BISalesOrderLines relationships

The BISalesOrderLines table in the OData feed is related to the BIStocks (Products) table via the [StockID] and the BISalesOrders table via the [SalesOrderID]. 

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,
Dublin,
Ireland

+353 1 567 4069

[email protected]