hi kranthi,
i want to add a field in the payment advise report in cash and bank mangement module
in this a query is there BankPaymAdviceCheque (aot quey) and i adding the filed in the query called utr number i am running the report , controller is there BankPaymAdviceChequeController
QueryBuildDataSource qbds;
Query reportQuery;
QueryBuildRange bankAccountQueryRange;
QueryBuildRange chequeNumQueryRange;
//Query = BankPaymAdviceCheque
query = this.parmReportContract().parmQueryContracts().lookup(queryKeyStr);
//User can pick specific bank account and cheque from dialog to create payment advice.
if (paymentIntegration == false)
{
qbds = query.dataSourceTable(tableNum(BankPaymAdviceChequeTmp));
bankAccountQueryRange = qbds.findRange(fieldNum(BankPaymAdviceChequeTmp, BankAccount));
chequeNumQueryRange = qbds.findRange(fieldNum(BankPaymAdviceChequeTmp, ChequeNum));
here i am adding my field to inatlize the friom the aot query
utrnumberrange = qbds.findRange(fieldNum(BankPaymAdviceChequeTmp, utrnumber));
but here it is not intalizationg it is givng the null value
utrnumberrange (null value) so that i am not able get the record and filter based on it .
}
//Query = BankCheque
this.parmReportContract().parmQueryContracts().insert(queryKeyStr,this.initQuery(vendOutPaymCheque, custOutPaymCheque));
query = this.parmReportContract().parmQueryContracts().lookup(queryKeyStr);
//Apply user choices from BankPaymAdviceCheque query to BankCheque query
if (paymentIntegration == false)
{
if (bankAccountQueryRange && bankAccountQueryRange.value())
{
SrsReportHelper::addParameterValueRangeToQuery(
query,
tableNum(BankChequeTable),
fieldNum(BankChequeTable,AccountID),
bankAccountQueryRange.value());
}
if (chequeNumQueryRange && chequeNumQueryRange.value())
{
SrsReportHelper::addParameterValueRangeToQuery(
query,
tableNum(BankChequeTable),
fieldNum(BankChequeTable,ChequeNum),
chequeNumQueryRange.value());
}
}
this.processReport(query);
please help me
thanks
srikanth