The sample code below shows how to retrieve the DataSet of Outstanding Purchase Order.
This sample does not filter the result.
public System.Data.DataSet GetOutstandingPODataSet(AutoCount.Authentication.UserSession userSession)
{
System.Data.DataSet dsOutStandingPO = new System.Data.DataSet("Outstanding PO DataSet");
System.Data.DataTable dtMaster = new System.Data.DataTable("Master");
System.Data.DataTable dtDetail = new System.Data.DataTable("Detail");
dsOutStandingPO.Tables.Add(dtMaster);
dsOutStandingPO.Tables.Add(dtDetail);
AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutstandingReportCommand cmd = AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutstandingReportCommand.Create(userSession);
AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutStandingReportingCriteria crit = new AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutStandingReportingCriteria();
cmd.BasicSearch(crit, "DocNo,DocDate,CreditorCode,CreditorName", dsOutStandingPO, "");
//Create a new DataRelation to Master and Detail tables in dsOutstandingDO
dsOutStandingPO.Relations.Add("MasterDetailRelation", dtMaster.Columns["DocKey"], dtDetail.Columns["DocKey"], false);
return dsOutStandingPO;
}