Programmer:Stock Status Report 2

References of AutoCount Accounting version 2.1

Nuget package: AutoCount2.Stock

Assemblies  :

• AutoCount.dll
• AutoCount.Accounting.dll
  • AutoCount.MainEntry.Startup
• AutoCount.UI.dll
• AutoCount.Image100p.dll
• AutoCount.Image125p.dll
• AutoCount.Image150p.dll
• AutoCount.Image175p.dll
• AutoCount.Image200p.dll
• AutoCount.Image500p.dll
• AutoCount.Images.dll
• AutoCount.Accounting.UI.dll
  • AutoCount.MainEntry.UIStartup
• AutoCount.Inquiry.dll
• AutoCount.Invoicing.dll
• AutoCount.Stock.dll

Get all tables in the DataSet of Stock Status

public DataSet GetStockStatusDataSet(AutoCount.Authentication.UserSession userSession)
{
    AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new AutoCount.Stock.StockStatus.StockStatusHelper(myUserSession);

    //No filter, warning without filter will load all data

    ssHelper.Inquire();
    return ssHelper.ResultDataSet;
}

• The DataSet has 3 tables, below are the table names:
  1. Master - Contains basic data of item
  2. Detail - Stock Status of the item
  3. SubDetail - Documents for reference

• 

  Master Table in ResultDataSet

• 

  Detail Table in ResultDataSet

• 

  SubDetail Table in ResultDataSet

Get the Table of Stock Status with filter

public DataTable GetStockStatusTable(AutoCount.Authentication.UserSession userSession)
{
    AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new AutoCount.Stock.StockStatus.StockStatusHelper(userSession);

    //Filter Stock Location
    AutoCount.Stock.StockStatus.StockStatusCriteria crit = ssHelper.Criteria;
    crit.LocationFilter.Type = AutoCount.SearchFilter.FilterType.ByRange;
    crit.LocationFilter.From = locationFrom;
    crit.LocationFilter.To = locationTo;

    ssHelper.Inquire();
    DataTable tblResult = ssHelper.ResultDataSet.Tables["Detail"];
    return tblResult;
}

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(AutoCount.Authentication.UserSession userSession)
{
    AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new AutoCount.Stock.StockStatus.StockStatusHelper(userSession);

    //Filter Stock Location
    AutoCount.Stock.StockStatus.StockStatusCriteria crit = ssHelper.Criteria;
    crit.LocationFilter.Type = 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	AR Debtor Aging-[1.8, 1.9] [2.0] AR Debtor Statement-[1.8, 1.9] [2.0]
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