Programmer:Outstanding Sales Order (20)

References of AutoCount Accounting version 2.0

AutoCount.Accounting.dll
AutoCount.Accounting.UI.dll
AutoCount.dll
AutoCount.MainEntry.dll
AutoCount.UI.dll
AutoCount.Invoicing.dll
AutoCount.Invoicing.Sales.dll

Extract data of Outstanding Sales Order with API

The sample code below shows how to retrieve the DataSet of Outstanding Sales Order. This sample does not filter the result.

public System.Data.DataSet GetOutstandingSODataSet(AutoCount.Authentication.UserSession userSession)
{
    System.Data.DataSet dsOutStandingSO = new System.Data.DataSet("Outstanding SO DataSet");
    System.Data.DataTable dtMaster = new System.Data.DataTable("Master");
    System.Data.DataTable dtDetail = new System.Data.DataTable("Detail");
    dsOutStandingSO.Tables.Add(dtMaster);
    dsOutStandingSO.Tables.Add(dtDetail);
    AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand cmd = AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand.Create(userSession);

    AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutStandingReportingCriteria crit = new AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutStandingReportingCriteria();


    cmd.BasicSearch(crit, "DocNo,DocDate,DebtorCode,DebtorName", dsOutStandingSO, "");

    //Create a new DataRelation to Master and Detail tables in dsOutstandingSO
    dsOutStandingSO.Relations.Add("MasterDetailRelation", dtMaster.Columns["DocKey"], dtDetail.Columns["DocKey"], false);

    return dsOutStandingSO;
}

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