Skip to Content
0
Former Member
Dec 23, 2011 at 07:57 PM

A/R Aging Report

46 Views

In Crystal Report 2008, I am creating a A/R Aging Report by joining OJDT + OINV + ORIN to show all open A/R invoices and A/R credit memo. In the WHERE statement, I was unable to specify DocStatus = 'O' for both OINV & ORIN at the same time. Only one at a time. Instead, can I specify WHERE isnull ({JDT1.MthDate}) (Reconciliation date is blank). Will this capture ALL the open invoices + credit memo?

Also, I also need to insert 'Paid' field in the report. However, there was no 'paid field in the OJDT / JDT1 tables. If I use the 'Paid' field from OINV then credit memo won't show. Vice versa if I use 'Paid' field from ORIN. Any idea where can I grab the 'Paid' field?

Thanks.