Programmer:Debtor Statement (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 Debtor Statement with API

The sample code below shows how to retrieve DataSet of Debtor Statement.

public System.Data.DataSet GetDebtorStatement(BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.ARAP.DebtorStatement.DebtorStatement statement =
        BCE.AutoCount.ARAP.DebtorStatement.DebtorStatement.Create(dbSetting);

    BCE.AutoCount.ARAP.DebtorStatement.DebtorStatementCriteria crit = new
        BCE.AutoCount.ARAP.DebtorStatement.DebtorStatementCriteria();

    //Set filter by date range
    crit.FromDate = new DateTime(2018, 10, 1);
    crit.ToDate = new DateTime(2018, 10, 31);

    //Load statement data
    statement.Inquire(crit);

    return statement.ResultDataSet;
}

Export Debtor Statement to PDF

This sample uses class of DebtorStatement and method of ExportReportByName to generate PDF File.

//filepath =  @"C:\Temp\MyExportName.pdf"
public void ExportToPdfByDebtor(string debtorCode, string filepath, BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.ARAP.DebtorStatement.DebtorStatement statement =
        BCE.AutoCount.ARAP.DebtorStatement.DebtorStatement.Create(dbSetting);

    BCE.AutoCount.ARAP.DebtorStatement.DebtorStatementCriteria crit = new
        BCE.AutoCount.ARAP.DebtorStatement.DebtorStatementCriteria();
    BCE.AutoCount.ReportFilter.StringFilter filterDebtor = new BCE.AutoCount.ReportFilter.StringFilter();

    //Set filter by date range
    crit.FromDate = new DateTime(2018, 10, 1);
    crit.ToDate = new DateTime(2018, 10, 31);

    //Only one debtor in one document.
    filterDebtor.ByOne(debtorCode);
    crit.DebtorFilter = filterDebtor;

    //Load statement data
    statement.Inquire(crit);

    //Export to PDF
    //"Debtor Statement" is the name of the Report Template
    BCE.AutoCount.Report.ReportTool.ExportReportByName("Debtor Statement",
        statement.GetReportDataSource(), dbSetting,
        new BCE.AutoCount.BasicReportOption(),
        new BCE.AutoCount.Report.ReportInfo("", "", "", ""),
        filepath,
        BCE.AutoCount.Report.ExportFormat.Pdf);
}

See Also Report API

Category	Reporting
AR	AR Debtor Aging-[1.8, 1.9] [2.1] AR Debtor Statement-[1.8, 1.9] [2.1]
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