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 GetOutstandingSODataSet(AutoCount.Authentication.UserSession userSession)
{
System.Data.DataSet dsOutStandingSO = new System.Data.DataSet("Outstanding SO DataSet");
System.Data.DataTable dtMaster = new System.Data.DataTable("Master");
System.Data.DataTable dtDetail = new System.Data.DataTable("Detail");
dsOutStandingSO.Tables.Add(dtMaster);
dsOutStandingSO.Tables.Add(dtDetail);
AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand cmd = AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand.Create(userSession);
AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutStandingReportingCriteria crit = new AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutStandingReportingCriteria();
cmd.BasicSearch(crit, "DocNo,DocDate,DebtorCode,DebtorName", dsOutStandingSO, "");
//Create a new DataRelation to Master and Detail tables in dsOutstandingSO
dsOutStandingSO.Relations.Add("MasterDetailRelation", dtMaster.Columns["DocKey"], dtDetail.Columns["DocKey"], false);
return dsOutStandingSO;
}