Dear experts, Please suggest how to call AR Aged Receivables Report on custom button click (Script Editor).
I have added the below mentioned code on button click
private void btnReport_Click(object sender, System.EventArgs args)
{
ARAgedRecReportAdapter objAdapter = new ARAgedRecReportAdapter(oTrans);
objAdapter.BOConnect();
//Get Paramters
objAdapter.GetNewParameters();
//Set Parameters
objAdapter.ReportData.ARAgedRecReportParam[0].AgingDate = DateTime.Now.AddYears(-1);
objAdapter.ReportData.ARAgedRecReportParam[0].CurrencyCode = “OMR”;
objAdapter.ReportData.ARAgedRecReportParam[0].SelectBy = “”;
objAdapter.ReportData.ARAgedRecReportParam[0].AgeBy = “”;
objAdapter.ReportData.ARAgedRecReportParam[0].CustNum = “”;
objAdapter.ReportData.ARAgedRecReportParam[0].AgingFormatCode = “”;
objAdapter.ReportData.ARAgedRecReportParam[0].ReportStyleNum = 1001;
objAdapter.ReportData.ARAgedRecReportParam[0].AutoAction = “PREVIEW”;
objAdapter.ReportData.ARAgedRecReportParam[0].SSRSRenderFormat = “PDF”;
objAdapter.ReportData.ARAgedRecReportParam[0].AgentID = “SystemTaskAgent”;
objAdapter.ReportData.ARAgedRecReportParam[0].WorkstationID = Ice.Lib.Report.EpiReportFunctions.GetWorkStationID((Ice.Core.Session)oTrans.Session);
objAdapter.ReportData.ARAgedRecReportParam[0].ArchiveCode = 7;
//Submit to Agent
objAdapter.SubmitToAgent(“SystemTaskAgent”,0,0);
}
but system is throwing error
’Erp.Rpt.ARAgedRecReportDataSet.ARAgedRecReportParamRow’ does not contain a definition for ‘CustNum’ and no extension method ‘CustNum’ accepting a first argument of type ‘Erp.Rpt.ARAgedRecReportDataSet.ARAgedRecReportParamRow’ could be found (are you missing a using directive or an assembly reference?)
We have done some chnages in above code. After that report preview is coming but data is not showing refere to below screen
ARAgedRecReportAdapter objAdapter = new ARAgedRecReportAdapter(oTrans);
objAdapter.BOConnect();
//Get Paramters
objAdapter.GetNewParameters();
//Set Parameters
objAdapter.ReportData.ARAgedRecReportParam[0].SelectBy = “ApplyDate”;//Apply Date- ApplyDate, Invoice Date- Date
objAdapter.ReportData.ARAgedRecReportParam[0].AgeBy = “DueDate”; //Due Date- DueDate, Invoice Date- InvDate
objAdapter.ReportData.ARAgedRecReportParam[0].AgingDate = DateTime.Now; //DateTime.Now.AddYears(-1);
objAdapter.ReportData.ARAgedRecReportParam[0].SummaryOnly = false;
objAdapter.ReportData.ARAgedRecReportParam[0].CurrencyCode = “OMR”;
objAdapter.ReportData.ARAgedRecReportParam[0].PrintLegNum = false;
// Created by AR configuration- ARSyst, Aged Recivables - ARG2
objAdapter.ReportData.ARAgedRecReportParam[0].AgingFormatCode = “ARSyst”;
objAdapter.ReportData.ARAgedRecReportParam[0].CustType = “B”;//S- Sold To, B-Bill To
objAdapter.ReportData.ARAgedRecReportParam[0].SortBy = “Customer Name/Invoice”;
objAdapter.ReportData.ARAgedRecReportParam[0].SortGLControlType = “AR Account”;
objAdapter.ReportData.ARAgedRecReportParam[0].CustList = “1189”;
objAdapter.ReportData.ARAgedRecReportParam[0].ReportStyleNum = 2;
objAdapter.ReportData.ARAgedRecReportParam[0].AutoAction = “SSRSPREVIEW”;
objAdapter.ReportData.ARAgedRecReportParam[0].SSRSRenderFormat = “PDF”;
objAdapter.ReportData.ARAgedRecReportParam[0].AgentID = “SystemTaskAgent”;
objAdapter.ReportData.ARAgedRecReportParam[0].ArchiveCode = 0;
objAdapter.ReportData.ARAgedRecReportParam[0].WorkstationID = Ice.Lib.Report.EpiReportFunctions.GetWorkStationID((Ice.Core.Session)oTrans.Session);
//Submit to Agent
objAdapter.SubmitToAgent(“SystemTaskAgent”,0,0);
Could you please suggest what value to be passed in CustList parameter CustID or CustNum?
I would start off by tracing running that report from it’s normal menu item - if you use the new tool provided by Jose that it will show you what data is being amended in the dataset, and you can then replicate that in your custom code.
Thanks markdamen, We trace the Aged Receivable report and preview the report on custom button click successful by passing below parameters
private void PreviewAgedReceivableReport(string CustNum)
{
try
{
ARAgedRecReportAdapter objAdapter = new ARAgedRecReportAdapter(oTrans);
objAdapter.BOConnect();
objAdapter.GetNewParameters();
objAdapter.ReportData.ARAgedRecReportParam[0].SelectBy = "ApplyDate";//Apply Date- ApplyDate, Invoice Date- Date
objAdapter.ReportData.ARAgedRecReportParam[0].AgeBy = "DueDate"; //Due Date- DueDate, Invoice Date- InvDate
objAdapter.ReportData.ARAgedRecReportParam[0].AgingDate = DateTime.Now; //DateTime.Now.AddYears(-1);
objAdapter.ReportData.ARAgedRecReportParam[0].CustList = CustNum;
objAdapter.ReportData.ARAgedRecReportParam[0].SummaryOnly = false;
objAdapter.ReportData.ARAgedRecReportParam[0].AgingFormatCode = "ARSyst";
objAdapter.ReportData.ARAgedRecReportParam[0].SortBy = "CUSTNAME";
objAdapter.ReportData.ARAgedRecReportParam[0].CustType = "B";//S- Sold To, B-Bill To
objAdapter.ReportData.ARAgedRecReportParam[0].CurrDesc = "OMR";
objAdapter.ReportData.ARAgedRecReportParam[0].CurrencyCode = "OMR";
objAdapter.ReportData.ARAgedRecReportParam[0].GLControlType = "AR Account";
objAdapter.ReportData.ARAgedRecReportParam[0].GLControlTypeDesc = "AR Account";
objAdapter.ReportData.ARAgedRecReportParam[0].SortGLControlType = "AR Account";
objAdapter.ReportData.ARAgedRecReportParam[0].SortGLControlTypeDesc = "AR Account";
objAdapter.ReportData.ARAgedRecReportParam[0].PrintSelCriteria = false;
objAdapter.ReportData.ARAgedRecReportParam[0].PrintLegNum = false;
objAdapter.ReportData.ARAgedRecReportParam[0].AutoAction = "SSRSPREVIEW";
objAdapter.ReportData.ARAgedRecReportParam[0].AgentID = "SystemTaskAgent";
objAdapter.ReportData.ARAgedRecReportParam[0].RecurringTask = false;
objAdapter.ReportData.ARAgedRecReportParam[0].ReportStyleNum = 2;
objAdapter.ReportData.ARAgedRecReportParam[0].WorkstationID = Ice.Lib.Report.EpiReportFunctions.GetWorkStationID((Ice.Core.Session)oTrans.Session);
objAdapter.ReportData.ARAgedRecReportParam[0].ArchiveCode = 0;
objAdapter.ReportData.ARAgedRecReportParam[0].SSRSRenderFormat = "PDF";
objAdapter.ReportData.ARAgedRecReportParam[0].PrintReportParameters = false;
objAdapter.ReportData.ARAgedRecReportParam[0].SSRSEnableRouting = false;
objAdapter.ReportData.ARAgedRecReportParam[0].RowMod = "A";
objAdapter.SubmitToAgent("SystemTaskAgent",0,0);
}
catch(Exception ex)
{
EpiMessageBox.Show("An error occured trying to preview report." + ex.Message);
}
}