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.
publicSystem.Data.DataSetGetOutstandingPODataSet(AutoCount.Authentication.UserSessionuserSession){System.Data.DataSetdsOutStandingPO=newSystem.Data.DataSet("Outstanding PO DataSet");System.Data.DataTabledtMaster=newSystem.Data.DataTable("Master");System.Data.DataTabledtDetail=newSystem.Data.DataTable("Detail");dsOutStandingPO.Tables.Add(dtMaster);dsOutStandingPO.Tables.Add(dtDetail);AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutstandingReportCommandcmd=AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutstandingReportCommand.Create(userSession);AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutStandingReportingCriteriacrit=newAutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutStandingReportingCriteria();cmd.BasicSearch(crit,"DocNo,DocDate,CreditorCode,CreditorName",dsOutStandingPO,"");//Create a new DataRelation to Master and Detail tables in dsOutstandingDOdsOutStandingPO.Relations.Add("MasterDetailRelation",dtMaster.Columns["DocKey"],dtDetail.Columns["DocKey"],false);returndsOutStandingPO;}