Forum Discussion

ylemire's avatar
ylemire
Frequent Visitor
6 years ago

Dynamic AR report

Hi everyone, I'm trying to to create a report that allows users to age their accounts receivables based on a user-selected date. The report need to show the outstanding dollar value bucketed in diffe...
Need Help
ylemire's avatar
ylemire
Frequent Visitor
6 years ago

Thanks Xiaoxin for your input, correct me if i'm wrong but as I understand your measure , only the invoice will be considered into calculation, but I also need the payment to be considered. In my example, the invoice (2,500$)  is fully cleared by the payment (4,800$ and a creditor amount of 2,300 $is still open on the payment line.

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ylemire ,

Yes, my formula will filter on two table records and do 'INTERSECT' to extract records who existed in two tables.

>> In my example, the invoice (2,500$)  is fully cleared by the payment (4,800$ and a creditor amount of 2,300 $is still open on the payment line.

Do you means you also want to summary not paid amount? Can you please provide some expected result to help us clear your requirement?

Regards,

Xiaoxin Sheng