Programmer:Outstanding Sales Order (20): Difference between revisions

From AutoCount Resource Center
Content added Content deleted
(Created page with "==References of AutoCount Accounting version 2.0== {{BaseReferenceAC20}} '''AutoCount.Invoicing.dll''' '''AutoCount.Invoicing.Sales.dll''' ==Extract data of Outstanding Pur...")
 
No edit summary
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
'''AutoCount.Invoicing.Sales.dll'''
'''AutoCount.Invoicing.Sales.dll'''


==Extract data of Outstanding Purchase Order with API==
==Extract data of Outstanding Sales Order with API==
The sample code below shows how to retrieve the DataSet of Outstanding Purchase Order.
The sample code below shows how to retrieve the DataSet of Outstanding Sales Order.
This sample does not filter the result.
This sample does not filter the result.
<syntaxhighlight lang="csharp">
<syntaxhighlight lang="csharp">
Line 13: Line 13:
System.Data.DataTable dtMaster = new System.Data.DataTable("Master");
System.Data.DataTable dtMaster = new System.Data.DataTable("Master");
System.Data.DataTable dtDetail = new System.Data.DataTable("Detail");
System.Data.DataTable dtDetail = new System.Data.DataTable("Detail");
dsOutStandingPO.Tables.Add(dtMaster);
dsOutStandingSO.Tables.Add(dtMaster);
dsOutStandingPO.Tables.Add(dtDetail);
dsOutStandingSO.Tables.Add(dtDetail);
AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand cmd = AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand.Create(userSession);
AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand cmd = AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand.Create(userSession);


Line 20: Line 20:




cmd.BasicSearch(crit, "DocNo,DocDate,DebtorCode,DebtorName", dsOutStandingPO, "");
cmd.BasicSearch(crit, "DocNo,DocDate,DebtorCode,DebtorName", dsOutStandingSO, "");


//Create a new DataRelation to Master and Detail tables in dsOutstandingDO
//Create a new DataRelation to Master and Detail tables in dsOutstandingSO
dsOutStandingPO.Relations.Add("MasterDetailRelation", dtMaster.Columns["DocKey"], dtDetail.Columns["DocKey"], false);
dsOutStandingSO.Relations.Add("MasterDetailRelation", dtMaster.Columns["DocKey"], dtDetail.Columns["DocKey"], false);


return dsOutStandingSO;
return dsOutStandingSO;

Latest revision as of 04:17, 8 August 2019

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.Sales.dll

Extract data of Outstanding Sales Order with API

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;
}

See Also Report API

Category Reporting
AR
AP
Stock
Sales
Purchase

Go to menu

Go to top
Resources For AutoCount Software Developers


Retrieved from "https://wiki.autocountsoft.com/wiki/Programmer:Outstanding_Sales_Order_(20)?oldid=12982"