Programmer:Stock Status Report
References of AutoCount Accounting version 1.9
BCE.AutoCount.dll BCE.AutoCount.CommonAccounting.dll BCE.AutoCount.MainEntry.dll BCE.Utils.dll BCE.Utils.UI.dll BCE.AutoCount.StockMaint.dll BCE.AutoCount.Stock.dll
Get all tables in the DataSet of Stock Status
public DataSet GetStockStatusDataSet(BCE.Data.DBSetting dbSetting)
{
BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(dbSetting);
//No filter, warning without filter will load all data
ssHelper.Inquire();
return ssHelper.ResultDataSet;
}
- The DataSet consists of 3 tables, below are the table names:
- Master - Contains basic data of item
- Detail - Stock Status of the item
- SubDetail - Documents for reference
Get the Table of Stock Status with filter
public DataTable GetStockStatusTable(BCE.Data.DBSetting dbSetting)
{
BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(dbSetting);
//Filter Stock Location
BCE.AutoCount.Stock.StockStatus.StockStatusCriteria crit = ssHelper.Criteria;
crit.LocationFilter.Type = BCE.AutoCount.SearchFilter.FilterType.ByRange;
crit.LocationFilter.From = "HQ";
crit.LocationFilter.To = "HQ";
ssHelper.Inquire();
return ssHelper.ResultDataSet.Tables["Detail"];
}
Add a column of expression to stock status table
This example shows how to add a column "ReadyStock" and calculate the value using two existing values.
public DataTable GetStockStatusTableWithColumnExpression(BCE.Data.DBSetting dbSetting)
{
BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(dbSetting);
//Filter Stock Location
BCE.AutoCount.Stock.StockStatus.StockStatusCriteria crit = ssHelper.Criteria;
crit.LocationFilter.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual;
crit.LocationFilter.Add("HQ");
ssHelper.Inquire();
DataTable dtDtl = ssHelper.ResultDataSet.Tables["Detail"];
if (!dtDtl.Columns.Contains("ReadyStock"))
{
dtDtl.Columns.Add("ReadyStock", typeof(decimal), "OnHandQty - CSGNBalQty");
}
return dtDtl;
}
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 |
| |||
AP |
| |||
Stock |
| |||
Sales |
| |||
Purchase |
|
Go to top
|
Resources For AutoCount Software Developers
|