Im having trouble with a report. I have tried the 'search' but nothing relates to my question.

 

I have a report which at the moment is laid out like this:

 

GROUP1 - CUSTOMER

DETAILS - Invoicenumber -  Inv Date - Stockcode - Quantity - Ordernumber

 

 

for example it will produce:

 

CUSTOMER A

I123456 - 13/07/2011 - PART01234895BVC - QTY x2 - ON/123456

 

 

Simple enough but the report has over 1000 lines, and I need to identify any duplicated order numbers?

 

 

the report is for one customer, and his orders comer through automatically from his website.

We are having a few teething problems with the datalinks, and sometimes he will get a confirmation saying that the ORDER HAS NOT REACHED US. but it actually has, therfore, he sends a manual order by email, which will result in 2 identical orders being delivered the next day.

 

this then causes us more work, in collecting the duplicated order from the customer, raising a credit note etc etc..

 

So, my aim here is to build a report that will identify these duplicate orders at the end of each working day, BEFORE they get loaded onto the vans by the night shift.

 

 

Any ideas?

 

 

Thanks in Advance!

 

Mike

 

 

 

Thanks for the reply!

 

While I understand what you mean, and it seems like that is the answer,

 

How do I do a count? LOL, sorry for the newby question!!

 

I have never used the count function before!

 

 

Thanks

remove the surpression, check the data

and the add the surpression to the order group.

good catch!

 

:D

 

You're a star!

 

If you wasn't so far away, id send you a box of chocolates!!!