GRN vs GIV crystal report (please help)

[NKOS13]

l'm trying to run a crystal report that will match my receipts with my invoices so that l can see all my receipts that have not been invoiced yet.And see if they are any differences between the Receipted Amount & Invoiced amount.

Everything runs fine but when it comes to the Receipt with multiple invoices or the opposite (more than one receipt but one invoice, it starts duplicating data.

Please help guys this report is stressing me. The tables l used are : POINVH1, POINVH2, POINVL,PORCPH1,PORCPH2,PORCPL
and linked using RCPHSEQ and linked the
PORCPL & POINVL using the RCPLSEQ and made it an full join type .

Please help

 

[ettienne]

Check your table links if you are getting duplicate data, you also need to use grouping on your report to avoid duplicates.

 

[Jay Converse]

Or use a subreport.

 

[NKOS13]

Thanks guys for your help l will try use subreport and see what l get