BIPurchaseOrders - Sage 50 Accounts Purchase Orders table

by Hugh Johnson, Posted on 4/19/2018 10:45:49 AM

 OData, Sage 50 Accounts

BIPurchaseOrders - Sage 50 Accounts Purchase Orders table

Sage 50 Accounts OData feed for Power BI

This article describes the BIPurchaseOrders 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 PURCHASE_ORDER ODBC table. 

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

BIPurchaseOrders table

AmountPrepaidDecimal NumberPrepaid amount on the PO
CurrencyUsedCodeTextCurrency used code
DateIDTextInternal Date ID to link to the BIDates table
ForeignRateDecimal numberExchange rate over base currency
OrderDateDate/TimeDate of the purchase order
ItemsNetDecimal NumberNet amount of the line items
OrderNumberTextPurchase Order number
PostedCodeTextWhether a Purchase Invoice has been posted for this PO. 
Status 0 = no invoice,
Status 1 = partly invoiced,
Status 2 = fully invoiced
PurchaseOrderIDWhole NumberLink to Purchase Order lines
StatusTextStatus of the PO. "On Order" indicates that the PO has been placed on the supplier and not all items have been received yet.
TakenByText"TakenBy" field from Sage. By default this is the Sage user who created the PO
SupplierIDTextLink to BISuppliers table

BIPurchaseOrders relationships

The BIPurchaseOrders table in the OData feed is related to the BISuppliers table via the [SupplierID} and the BIPurchaseOrderLines table via the [PurchaseOrderID].  The Dates table shown in the diagram below is not part of the OData feed, but I would recommend that you create one and link it to the BIPurchaseOrders table.  

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]