Error when doing Statements. What does this mean?

Submitted by garry edgar on Fri, 30/01/2015 - 16:26

General User's Discussion

Failed to generate report. The subreport is placed on a non-splitting band, but it does not have a rewindable data source.

Re: Error when doing Statements. What does this mean?

Submitted by Ben_Charlton on Tue, 03/02/2015 - 10:36.

http://www.openvpms.org/forum/custom-statement-wont-print-certain-custom...

Garry are you using a customised Statement report or Statement Items report.

If so please attach them so we can review.

On a side note I think this will require a code patch as it will represent a very random error that only occurs occassionally on some files.

Regards

Ben

OpenVPMS Installer and Helper

Ph: +61423044823

Email: info[at]charltonit.com[dot]au

Re: Error when doing Statements. What does this mean?

Submitted by garry edgar on Wed, 04/02/2015 - 14:00.

hi ben. we are using whatever we unpacked when tony set up our system.

Re: Error when doing Statements. What does this mean?

Submitted by Ben_Charlton on Wed, 04/02/2015 - 14:43.

Ok gary this is probably a error due to a problem with the way data is provided to sub reports on certain reports that are in Openvpms.

Technically the problem occurs when the itemization on a clients statement hits a page boundary. The system should at that point push the entire itemization to the next page, but it cant - because it cant "rewind" the data to the first entry. So it produces an error.

We are looking at modifying that part of the system to avoid this error

As a temporary fix edit the statement report and remove the subreport statementitems. Upload the report replacing the existing statement report. Run statements being aware that there will be no invoice breakdowns on statements this month. The finalize the period. Reupload the original statement report.

It is probably a regular clients statement that is the one throwing an error. I am looking at the patch and hopefully we will get something done before 1.8 comes out to fix this.

Regards

Ben

OpenVPMS Installer and Helper

Ph: +61423044823

Email: info[at]charltonit.com[dot]au

Re: Error when doing Statements. What does this mean?

Submitted by garry edgar on Wed, 04/02/2015 - 21:28.

I am not sure how you remove the sub-report. Do I delete it out of Templates?

Personally, I would rather a better statement system anyway as we get clients who we see regularly and never have an outstanding bill. Then, the first time they do, it prints an itemised statement including every transaction since we went onto Open. Sometimes that is 5-10 pages. And it gives a total for what they have spent in 2-3 years!!!!

Re: Error when doing Statements. What does this mean?

Submitted by tony on Thu, 05/02/2015 - 07:23.

Hi Garry,

Currently the statement will only detail invoices if they are not marked as printed and post the previous opening balance for the customer. I can only assume the invoices being detailed are ones that were migrated from your original software and you are possibly not doing an end period to generate the closing and opening balances each month ?

I can definitely run a script to fix the first issue for you.

Do you know how to run the end period process ?

Cheers Tony