View source for Programmer:Outstanding Purchase Order (19)

==References of AutoCount Accounting version 1.8 / 1.9==
{{BaseReferenceAC18}}
 '''BCE.AutoCount.Invoicing.dll'''
 '''BCE.AutoCount.Invoicing.Purchase.dll'''

==Extract data of Outstanding Purchase Order with API==
The sample code below shows how to retrieve the DataSet of Outstanding Purchase Order.
This sample does not filter the result.
<syntaxhighlight lang="csharp">
public System.Data.DataSet OutstandingPurchaseOrderData(BCE.Data.DBSetting dbSetting)
{
    //Create the object of PurchaseOrdersOutstandingReportCommand
    BCE.AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutstandingReportCommand rptCmd =
        BCE.AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutstandingReportCommand.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 dsOutstandingPO = new System.Data.DataSet();
    dsOutstandingPO.Tables.Add(dtMaster);
    dsOutstandingPO.Tables.Add(dtDetail);

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

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

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

    return dsOutstandingPO;
}
</syntaxhighlight>

{{SeeAlsoAPIReport}}
[[Category:Programmer]]
[[Category:API]]
[[Category:Integrate]]
[[Category:Plug-In]]
{{NavigateDeveloper}}