Sage 50 Accounts OData feed for Power BI
This article describes the BIPurchaseOrderLines table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI. This table is derived from the underlying Sage 50 Accounts POP_ITEM ODBC table.
This table is essential if you want to analyse your Sage 50 Purchase Orders at the product line item level.
|PurchaseOrderItemID||Text||Unique internal ID for the record|
|PurchaseOrderID||Text||Unique ID to link to BIPurchaseOrders table|
|NetAmount||Decimal Number||Net purchase amount for this line item. This is the [UnitPrice] * [QtyOrder]|
|QtyAllocated||Decimal Number||Quantity placed on order with the supplier but not yet delivered for this line item. Note that if the Purchase Order has not yet been placed with the Supplier then the QtyAllocated will be zero. Also if the goods have been received in full against the Purchase Order then the QtyAllocated will also be zero.|
|QtyDelivered||Decimal Number||Quantity delivered against this line|
|QtyDespatch||Decimal Number||Quantity to form next despatch from the supplier against this line item. This will typically be the same as QtyAllocated|
|QtyOrder||Decimal Number||Total quantity in the PO for this line|
|UnitPrice||Decimal Number||Unit cost price on the PO|
|StockID||Whole Number||Link to the BIStocks table|
To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?