I have an invoice and order confirmation in Crystal which is duplicating some of the items on the order but only sometimes. When the same invoice is reprinted then there is no duplication.

Say I have item 1000 with 1 qty on it and when the replication happens I have the same items twice. When I reprint the invoice I only see it once.

The application is Sage BusinessVision with Crystal run-time engine version 10. The database is Pervasive SQL version 10

There is a long history behind this issue going back to 2007. The issue started to appear sometime in 2007 and was reported by some customers. BusinessVision QA at the time and later on attempted to replicate the issue but so far to this day no one has ever be able to replicate this. I have attempted to replicate the issue for countless hours with no success.

I'm not sure why but someone from QA discovered that by adding the following formula to the report for suppression in the detail section the problem went away.

previous({SALES_HISTORY_DETAIL.NUMBER}) = {SALES_HISTORY_DETAIL.NUMBER}
and previous({SALES_HISTORY_DETAIL.RECNO}) = {SALES_HISTORY_DETAIL.RECNO}

Now the problem is that as soon as I start customizing the report the problem comes back. In my case I have a custom report for one of my customers where I'm grouping the items on an invoice. Sage is telling me that they can't help me because of the customization I have.

I've been insisting with the Sage QA team to get the issue resolve but they claim that it is a Crystal bug but are not sure because no one has ever been able to replicate it.

Has someone else ever come across this? I have uploaded my custom report and also the standard report if anyone is interested to look at them.
www.iversa.ca/files/Invoice_Plain_Paper.rpt
www.iversa.ca/files/Invoice.rpt

Any help I can get on this is appreciated.

CircleD,
Can you explain in a bit more detail? I'm not sure if I understand fully what to do?

It would be nice to find a way to replicate the issue.

Thank you for your help.