Programmer:Outstanding Purchase Order (19)

Revision as of 09:05, 14 January 2019 by DanielY (talk | contribs) (Created page with "==References of AutoCount Accounting version 1.8 / 1.9== {{BaseReferenceAC18}} '''BCE.AutoCount.Invoicing.dll''' '''BCE.AutoCount.Invoicing.Purchase.dll''' ==Extract data o...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

References of AutoCount Accounting version 1.8 / 1.9

BCE.AutoCount.dll
BCE.AutoCount.CommonAccounting.dll
BCE.AutoCount.MainEntry.dll
BCE.Utils.dll
BCE.Utils.UI.dll
BCE.AutoCount.Invoicing.dll
BCE.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 OutstandingPurchaseOrderData(BCE.Data.DBSetting dbSetting)
{
    //Create the object of PurchaseOrdersOutstandingReportCommand
    BCE.AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutstandingReportCommand rptCmd =
        BCE.AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutstandingReportCommand.Create(dbSetting);

    //Prepare the DataSet of Master table and Detail table
    System.Data.DataTable dtMaster = new System.Data.DataTable("Master");
    System.Data.DataTable dtDetail = new System.Data.DataTable("Detail");
    System.Data.DataSet dsOutstandingPO = new System.Data.DataSet();
    dsOutstandingPO.Tables.Add(dtMaster);
    dsOutstandingPO.Tables.Add(dtDetail);

    //Add the criterias that require to retrieve the data
    //Such as add filter to result
    BCE.AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutStandingReportingCriteria crit =
        new BCE.AutoCount.Invoicing.Purchase.PurchaseOrder.PurchaseOrderOutStandingReportingCriteria();

    //Define addition fields of DocNo, DocDate, CreditorCode, CreditorName.
    //Programmer may add more fieldname to the DataTable of Master Table. 
    rptCmd.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;
}

Go to menu

  Go to top
  Resources For AutoCount Software Developers