Programmer:Outstanding Sales Order (20): Difference between revisions
Content added Content deleted
No edit summary |
No edit summary |
||
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"); |
||
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.SalesOrderOutstandingReportCommand cmd = AutoCount.Invoicing.Sales.SalesOrder.SalesOrderOutstandingReportCommand.Create(userSession); |
||
Line 20: | Line 20: | ||
cmd.BasicSearch(crit, "DocNo,DocDate,DebtorCode,DebtorName", |
cmd.BasicSearch(crit, "DocNo,DocDate,DebtorCode,DebtorName", dsOutStandingSO, ""); |
||
//Create a new DataRelation to Master and Detail tables in |
//Create a new DataRelation to Master and Detail tables in dsOutstandingSO |
||
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 top
|
Resources For AutoCount Software Developers
|