Programmer:Debtor Aging (19): Difference between revisions
Content added Content deleted
(Created page with "==References of AutoCount Accounting version 1.8 / 1.9== {{BaseReferenceAC18}} '''BCE.AutoCount.ARAP.dll''' ==Extract data of AR Debtor Aging with API== The sample code belo...") |
No edit summary |
||
Line 9: | Line 9: | ||
#Debtor code range of "300-A001" and "300-C999"; |
#Debtor code range of "300-A001" and "300-C999"; |
||
#and does not include debtor whom the balance is zero. |
#and does not include debtor whom the balance is zero. |
||
<syntaxhighlight lang="csharp"> |
<syntaxhighlight lang="csharp"> |
||
public System.Data.DataSet |
public System.Data.DataSet DebtorAgingDataSet(BCE.Data.DBSetting dbSetting) |
||
{ |
{ |
||
BCE.AutoCount.ARAP.DebtorAging.DebtorAging aging = BCE.AutoCount.ARAP.DebtorAging.DebtorAging.Create(dbSetting); |
BCE.AutoCount.ARAP.DebtorAging.DebtorAging aging = BCE.AutoCount.ARAP.DebtorAging.DebtorAging.Create(dbSetting); |
||
Line 32: | Line 33: | ||
} |
} |
||
</syntaxhighlight> |
</syntaxhighlight> |
||
* Tables in Aging DataSet |
|||
[[File:Prog.AR.AgingDataSet.png]] |
|||
<br/><br/> |
|||
<syntaxhighlight lang="csharp"> |
|||
public System.Data.DataTable DebtorAgingTable(BCE.Data.DBSetting dbSetting) |
|||
{ |
|||
BCE.AutoCount.ARAP.DebtorAging.DebtorAging aging = BCE.AutoCount.ARAP.DebtorAging.DebtorAging.Create(dbSetting); |
|||
BCE.AutoCount.ARAP.DebtorAging.DebtorAgingCriteria crit = new BCE.AutoCount.ARAP.DebtorAging.DebtorAgingCriteria(); |
|||
//There are many more criteria to filter the result |
|||
crit.ReportDate = DateTime.Today.Date; |
|||
crit.DebtorFilter.ByRange("300-A001", "300-C999"); |
|||
crit.IncludeZeroBalance = false; |
|||
//The return table is "Master" |
|||
DataTable tblAging = aging.Inquire(crit); |
|||
return aging.ResultDataSet.Tables["Detail"]; |
|||
} |
|||
</syntaxhighlight> |
|||
* Columns in Aging.Detail Table. |
|||
[[File:Prog.AR.AgingDetailTable.png|link=]] |
|||
{{SeeAlsoAPIReport}} |
{{SeeAlsoAPIReport}} |
||
[[Category:Programmer]] |
[[Category:Programmer]] |