View source for Programmer:Outstanding Sales Order (19)

==References of AutoCount Accounting version 1.8 / 1.9==
{{BaseReferenceAC18}}
 '''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.
<syntaxhighlight lang="csharp">
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;
}
</syntaxhighlight>
{{SeeAlsoAPIReport}}
[[Category:Programmer]]
[[Category:API]]
[[Category:Integrate]]
[[Category:Plug-In]]
{{NavigateDeveloper}}