Try to add an additional filter - GACCDUDATE table  AMTCUR > PAYCUR + TMPCUR. If having issues, reach me at yq_qiu  @  hotmail.  com.  Regards

Hello Jackie,

Thanks for the reply. Do you meant to add the filter in to the report ?

Eranda

Yes. You can access it at Crystal reports tool - "Reports -> Select Expert -> Record", and then add the line like "and {GACCDUDATE.AMTCUR_0} > {GACCDUDATE.PAYCUR_0} + {GACCDUDATE.TMPCUR_0}". If you still want to show the line with over paid or over applied invoices/payments, then you may use " and {GACCDUDATE.AMTCUR_0} <> {GACCDUDATE.PAYCUR_0} + {GACCDUDATE.TMPCUR_0}". 

Regards,

Yes. You can access it at Crystal reports tool - "Reports -> Select Expert -> Record", and then add the line like "and {GACCDUDATE.AMTCUR_0} > {GACCDUDATE.PAYCUR_0} + {GACCDUDATE.TMPCUR_0}". If you still want to show the line with over paid or over applied invoices/payments, then you may use " and {GACCDUDATE.AMTCUR_0} <> {GACCDUDATE.PAYCUR_0} + {GACCDUDATE.TMPCUR_0}". 

Regards,

Hi Jackie,

I tried putting above filter.  but it didn't work. it changed the supplier totals. Do you have any idea please. Thanks again for your reply.

Eranda

It's better to look at your data at the table GACCDUDATE. I guess it may need to use the {GACCDUDATE.AMTLOC_0} <> {GACCDUDATE.PAYLOC_0} + {GACCDUDATE.TMPLOC_0}. Please try it. If not, email me and I can connect to your system and have a look on your data. Regards