11,627
Hi,
When we run Customer account statement report for multiple customers, it opens the report in a separate window for each customer and same in case of File. Is it possible to allow the report to show all records in one window with each customer record on separate page?
Thanks,
Baber.
*This post is locked for comments
Hi All,
I've found the solution for above issue, After debugging the code i've created another table where i've been able to store the records same as system, Then after insertion i've a created a simple Dp class to achieve the system report design also created the replica design as well. After that i've called the report design on controller class of customer account statement. It'll print the whole record in one preview.
do let me know if this solution works for you.
Regards,
Zohan
Hi,
??????
For Above Question....
Hi,
The internal account statement report is working with one financial dimension but when i enter more than one financial dimenion
the report is printing null data. what is the issue behind this?
Hi Mustafa Aliasghar,
your question is about 'ranges in query' or 'range in report'
Please feel free to create a new question, this can help in keeping community healthy.
Hi,
How to add SUB DIVISION PARAMETER in account statement report in a Dynamic Query......
Hi,
Sohaib
Could you please elaborate more on this topic ?? I'm new with all this stuff. Just wanted to print Single Statement in Morphx Report.
Thanks,
Dhruv
Sorry, I didn't get any solution for this. Customer requirement was dropped, then I didn't do further research on this. But you can look at how Internal customer account statement report works and replicate the functionality from there.
Thanks,
Baber.
Hi Syed,
Now I have the same requirement which you had earlier. Have you got any solution and if yes please help me on the same.
Thanks,
K.K. Bhargava
Yeah it would be much easy to create a new report than modifying exiting.
All you can do is following.
Create a query same as report has current, but don’t use no-exist join
Create a temp table
Create your RDP class which will do something as under
While(qr.next())//here queryrun same which is in step#1
{
//create query for custtrans same as createBaseCustTransQuery (method) of CustAccountStatementExtController
//take these custtrans records and .insert into your temp table.
}
Another point, this current report shows settlements also, whereas External account statement is an external document. And my customer should not bother about settlements of my financials. Customer is interested only in ‘What I have paid’, ‘what invoices I have received’ and ‘and how much I have to pay more/remaining payable ’
So include another range in custtrans as localCustTrans.TransType != LedgerTransType::Settlement
Overall it would be as under
while select localCustTrans
order by localCustTrans.TransDate ASC
where localCustTrans.AccountNum == _custAccountNum
&& localCustTrans.TransDate >= _fromDate && localCustTrans.TransDate <= _toDate
&& localCustTrans.TransType != LedgerTransType::ExchAdjustment
&& localCustTrans.TransType != LedgerTransType::Settlement
Group your report by CustAccountNum and put a a page break at end of each group
Thanks for the details Sohaib and good to know about the bug in this report. Regarding the question, the things you have mentioned, I already looked at the logic, tried different things with outputReports method called inside runPringMgmt, but all in vain.
Considering this, I am thinking of creating a new DP and controller class, just like for internal account statement and copy the existing logic from controller to new DP class.
Thanks,
Baber.
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
