Programmer:Outstanding Purchase Order (20)

From AutoCount Resource Center
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 menu

IconAC81.png Go to top
ProgrammerGo.jpg Resources For AutoCount Software Developers