Programmer:Outstanding Sales Order (19)

From AutoCount Resource Center
Jump to navigation Jump to search

References of AutoCount Accounting version 1.8 / 1.9

BCE.AutoCount.dll
BCE.AutoCount.CommonAccounting.dll
BCE.AutoCount.MainEntry.dll
BCE.Utils.dll
BCE.Utils.UI.dll
BCE.AutoCount.Invoicing.dll
BCE.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 OutstandingSalesOrderData(BCE.Data.DBSetting dbSetting)
{
    //Create the object of SalesOrdersOutstandingReportCommand
    BCE.AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand rptCmd =
        BCE.AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand.Create(dbSetting);

    //Prepare the DataSet of Master table and Detail table
    System.Data.DataTable dtMaster = new System.Data.DataTable("Master");
    System.Data.DataTable dtDetail= new System.Data.DataTable("Detail");
    System.Data.DataSet dsOutstandingSO = new System.Data.DataSet();
    dsOutstandingSO.Tables.Add(dtMaster);
    dsOutstandingSO.Tables.Add(dtDetail);

    //Add the criterias that require to retrieve the data
    //Such as add filter to result
    BCE.AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutStandingReportingCriteria crit =
        new BCE.AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutStandingReportingCriteria();

    //Define addition fields of DocNo, DocDate, DebtorCode, DebtorName.
    //Programmer may add more fieldname to the DataTable of Master Table. 
    rptCmd.BasicSearch(crit, "DocNo,DocDate,DebtorCode,DebtorName", dsOutstandingDO, "");

    //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
AP
Stock
Sales
Purchase

Go to menu

IconAC81.png Go to top
ProgrammerGo.jpg Resources For AutoCount Software Developers