Programmer:Outstanding Purchase Order (20)
Jump to navigation
Jump to search
References of AutoCount Accounting version 2.0
AutoCount.Accounting.dll AutoCount.Accounting.UI.dll AutoCount.dll AutoCount.MainEntry.dll AutoCount.UI.dll AutoCount.Invoicing.dll 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.
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;
}
See Also Report API
Category | Reporting | |||
---|---|---|---|---|
AR |
| |||
AP |
| |||
Stock |
| |||
Sales |
| |||
Purchase |
|
![]() |
Go to top
|
![]() |
Resources For AutoCount Software Developers
|