• From: Suriname, Paramaribo
  • Registered: 01/17/2014
  • Posts: 37

Topic: bank statement report

hi, i dont know if someone already had such a report , but i want to use the bank statement report rep601 to show transactions for each bank account on a new page between the chosen dates. Is this possible and has anyone such a report?
for now you can choose 1 bank account and 2 dates and it shows the transactions for this account only between the chosen dates , this is good , but i want to have the report print for all bank accounts between the chosen dates and each bank account on a new page.
if it will cost something you can sent me a message to do this
wbr
sewkar

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: bank statement report

The bank_accounts.id field is chosen in the rep601.php's request form as the PARAM_0.

If the line 28 in the said report print_bank_transactions() is cycled through all such ids in the bank accounts table, then we get what you want. Check out the attachment.

How much do you want to pay? wink

@joe: want to make it a rep603.php or as an extension for printing all rep601's.

Post's attachments

reporting_601.zip 12 kb, 2 downloads since 2019-12-28 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: bank statement report

Yes, maybe a good idea. Will have a look.

Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: bank statement report

Possibly an option in the PARAM_0 to have ALL might be all that is necessary without having a new report altogether.
Also the page numbers caveat should be noted - all pages are in sequence with no page reset when account changes.

apmuthu's Website

  • From: Suriname, Paramaribo
  • Registered: 01/17/2014
  • Posts: 37

Re: bank statement report

How much do you want to pay? wink
hi i dont know , you tell me what would be ok
wbr
sewkar

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: bank statement report

The solution mentioned by @apmuthu seems the best one. The routine bank_accounts_list needs an extra parameter to opt. for the 'All' solution.
I will implement this asap.

Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: bank statement report

@sewkar: Just kidding. If you can afford it, kindly contribute to the project. It will in part pay for the hosting, and other expenses. Thanks for the feature request - that is what makes Open Source worth pursuing and preserving - peer group vetted best way forward.

We can explore where else the "All" can be implemented.

apmuthu's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: bank statement report

This has now been implemented in 2.4.7 and committed to stable repo.
The fixed files can be downloaded https://sourceforge.net/p/frontaccounti … rep601.php
https://sourceforge.net/p/frontaccounti … s_main.php
https://sourceforge.net/p/frontaccounti … lasses.inc

/Joe

Post's attachments

rep601_new_outputs.zip 36.2 kb, 1 downloads since 2019-12-29 

You don't have the permssions to download the attachments of this post.