Hello,
When i run the aged trial balance it shows fully applied invoices and payments. It is matched already and customer wants to see only outstanding documents. Are there any way to remove all applied documents from aging reports.
Eranda
Hello,
When i run the aged trial balance it shows fully applied invoices and payments. It is matched already and customer wants to see only outstanding documents. Are there any way to remove all applied documents from aging reports.
Eranda
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
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,
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
*Community Hub is the new name for Sage City