BIStocks - Sage 50 Accounts Stocks (Products) table


by Hugh Johnson, Posted on 4/18/2018 6:50:22 PM

 Power BI Desktop, OData, stock, Sage 50 Accounts

BIStocks - Sage 50 Accounts Stocks (Products) table

Sage 50 Accounts OData feed for Power BI

This article describes the BIStocks table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table is derived from the Sage 50 Accounts "STOCK" ODBC table.

This table is essential if you want to analyse sales and margin by stock category or to analyse stock levels.

BIStocks table

ColumnTypeDescription
StockIDTextUnique ID for that record
StockCodeTextThe alphanumeric Product Code from Sage
DescriptionTextProduct description
SalesPriceDecimal NumberList unit sales price for the product
AverageCostPriceDecimal NumberAverage unit cost price (FIFO method)
LastPurchasePriceDecimal NumberLast PO purchase price for the product
QtyInStockDecimal NumberQuantity in stock
QtyOnOrderDecimal NumberQuantity on Purchase Order
QtyAllocatedDecimal NumberQuantity Allocated
StockCatWhole NumberStock Category Number
StockCatNameTextStock category
InactiveFlagTrue/FalseItem has manually been marked inactive
PurchaseNominalCodeTextDefault purchase nominal code
NominalCodeTextDefault sales nominal code
DeptNameTextDefault product department
DeptNumberTextDefault product department number

BIStocks relationships

The BIStocks table in the OData feed is related to the BIProductSales, BISalesOrderLines and BIPurchaseOrderLines tables via the [StockID].  

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]