Programmer:Debtor Aging (19)

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

Extract data of AR Debtor Aging with API

The sample code below shows how to retrieve DataSet or DataTable of Debtor Aging. It filters result of:

1. Up to Today's date;
2. Debtor code range of "300-A001" and "300-C999";
3. and does not include debtor whom the balance is zero.

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.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);

    //DataSet consists of many tables, and "Master" table
    return aging.ResultDataSet;

    //If only the master table is needed, programmer can return only DataTable of the master table
    //tblAging table and aging.ResultDataTable are the same
    //return tblAging;
    //return aging.ResultDataTable;
}

• Tables in Aging DataSet

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

• Columns in Aging.Detail Table.

See Also Report API

Category	Reporting
AR	AR Debtor Aging-[1.8, 1.9] [2.0] AR Debtor Statement-[1.8, 1.9] [2.0]
AP
Stock	Stock Balance with Costing-[1.8, 1.9] [2.0] Stock Status Report - [1.9] [2.0]
Sales	Outstanding Sales Order - [1.8, 1.9] [2.0] Outstanding Delivery Order-[1.8, 1.9] [2.0] Search/Load Sales Invoice - [1.8, 1.9] [2.0]
Purchase	Outstanding Purchase Order - [1.8, 1.9] [2.0]

Go to menu

Go to top

Resources For AutoCount Software Developers