Home › Forums › Users › General User's Discussion ›

Problem with reports

Submitted by Guest on Tue, 12/05/2015 - 16:30
in

Hi,

 

I'm trying to run the customer balance report that came with openvpms, but when i choose the date and run it, it keeps coming up with the error "report has no pages to print".

 

Am I doing something wrong?

 

Thanks,

 

Shanon

‹ Reusing obsolete products Add Visit and Note - suggested change ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Problem with reports

Submitted by Ben_Charlton on Tue, 12/05/2015 - 17:12.

Nope I just ran the same report - it returns empty on my system as well so the report is faulty - I will lodge a ticket with this to get it fixed for the next release.

I dont use it anyway I prefer the Aged Balance Report from the communitry documents

http://www.openvpms.org/customisation/customer-aged-balance-report

Download it and it it as a new report and see how you go!

 

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

Re: Problem with reports

Submitted by tgething (not verified) on Sat, 16/05/2015 - 07:02.

I had a play with the report.  The problem is that the report is written to display the customer balances on the specified date by looking for opening balance transactions on that date.  Hence if you run Reporting|Debtors|End Period on say 30/4/15 (which will generate a set of opening balance transactions on that date), and then you run the Customer Balance report with the date 1/5/15 then there will be no output. Running it for 30/4/15 will generate output.

Tim A - there are three possible actions:

  1. do nothing - on the basis that the Report button on the Reporting|Debtors screen generates the equivalent data with lots more choice of parameters.
  2. add explanation to the report to say how it works - my normal approach where one wants to give guidance to the user is to add a string parameter titled 'Explanation' with text like 'This report shows the customer balances at the Balance Date - and this MUST correspond with a date on which you ran Reporting|Debtors|End Period otherwise there will be no output'.
  3. replace the report with something more useful - I have an aged balance report cloned from the one Ben refers to above.  This usefully complements the Reporting|Debtors|Report in that it shows the aged balances.

Regards, Tim G

Re: Problem with reports

Submitted by tanderson on Thu, 21/05/2015 - 23:43.

If you know the End Period date, then the Customer Balance Report can be used to list debtors historically. This isn't possible in Reporting - Debtors.

That said, I don't know how useful it is, or if newer reports supercede it.

Re: Problem with reports

Submitted by tgething (not verified) on Fri, 22/05/2015 - 06:11.

Sharon - I have contributed an Outstanding Debtors report to the 1.8 set - you can use this to look at the customer balance situation as at any date.

However, this is generated for 1.8 and I do not really want to spend time back-porting it to 1.7.  However, the Customer Aged Balance report that Ben refers to above is what I developed mine from - so for your use in 1.7 go grab that one.

Regards, Tim G

Syndicate content