Revision as of 04:08, 8 August 2019 by DanielY(talk | contribs)(Created page with "==References of AutoCount Accounting version 2.0== {{BaseReferenceAC20}} '''AutoCount.Invoicing.dll''' '''AutoCount.Invoicing.Purchase.dll''' ==Extract data of Outstanding...")
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;}