Programmer:Get Stock Cost v2

References of AutoCount Accounting version 2.0

AutoCount.Accounting.dll
AutoCount.Accounting.UI.dll
AutoCount.dll
AutoCount.MainEntry.dll
AutoCount.UI.dll
AutoCount.StockMaint.dll
AutoCount.Stock.dll

Standard Cost

Get Standard Cost with ItemRecord

public decimal GetItemStandardCostWithItemRecord(AutoCount.Data.DBSetting dbSetting, string itemCode, string uom)
{
    AutoCount.Data.ItemRecord itemRec = AutoCount.Data.RecordUtils.GetItem(dbSetting, itemCode, uom);
    return itemRec == null ? 0 : itemRec.Cost ?? 0;
}

Get Standard Cost with StockHelper

public decimal GetItemStandardCostWithStockHelper(AutoCount.Data.DBSetting dbSetting, string itemCode, string uom)
{
    AutoCount.Stock.StockHelper stkHelper = AutoCount.Stock.StockHelper.Create(dbSetting);
    return stkHelper.GetFixedCost(itemCode, uom);
}

Most Recent Cost

• BatchNo can be assigned as null, if there is no BatchNo

public decimal GetRecentStockCost(AutoCount.Data.DBSetting dbSetting, string itemCode, string uom, string loc, string batchNo)
{
    AutoCount.Stock.UTDCostHelper costHelper =
        AutoCount.Stock.UTDCostHelper.Create(dbSetting, itemCode, uom, loc, batchNo, DateTime.Today.Date);

    //BatchNo can be assigned as null, if there is no BatchNo
    //AutoCount.Stock.UTDCostHelper costHelper =
    //    AutoCount.Stock.UTDCostHelper.Create(dbSetting, itemCode, uom, loc, null, DateTime.Today.Date);
    return costHelper.GetMostRecentlyCost().Cost;
}

Up-to-date Cost

public decimal GetUpToDateUnitCost(AutoCount.Data.DBSetting dbSetting, string itemCode, string uom, string location, string batchNo, decimal qty, DateTime date)
{
    AutoCount.Stock.StockHelper stkHelper = AutoCount.Stock.StockHelper.Create(dbSetting);
    return stkHelper.GetUpToDateUnitCost(itemCode, uom, location, batchNo, qty, date);
}

Items' Stock Balance, Quantity and Costing Table

public System.Data.DataTable GetStockBalanceCostTable(AutoCount.Authentication.UserSession userSession)
{
    AutoCount.Stock.StockBalance.StockBalanceHelper sbHelper = new AutoCount.Stock.StockBalance.StockBalanceHelper(userSession);
    sbHelper.Inquire(DateTime.Today.Date);

    return sbHelper.ResultTable;
}

Stock Balance Table with Quantity and Cost Balance (Ref of version 1.8 / 1.9)

See Also

• Item Group
• Stock Item (Item Maintenance)
• Stock Adjustment
• Stock Transfer
• Stock Assembly
• Stock Balance with Costing - [1.8, 1.9] [2.0]
• Item Opening Balance Maintenance - [1.8, 1.9] [2.0]

See Also Report API

Category	Reporting
AR	AR Debtor Aging-[1.8, 1.9] [2.1] AR Debtor Statement-[1.8, 1.9] [2.1]
AP
Stock	Stock Balance with Costing-[1.8, 1.9] [2.0] Stock Status Report - [1.9] [2.0]
Sales	Outstanding Sales Order - [1.8, 1.9] [2.0] Outstanding Delivery Order-[1.8, 1.9] [2.0] Search/Load Sales Invoice - [1.8, 1.9] [2.0]
Purchase	Outstanding Purchase Order - [1.8, 1.9] [2.0]

Go to menu

Go to top

Resources For AutoCount Software Developers