Print Page | Close Window

A/R Invoice formula

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18984
Printed Date: 27 Apr 2024 at 9:09pm


Topic: A/R Invoice formula
Posted By: guy723
Subject: A/R Invoice formula
Date Posted: 30 Jan 2013 at 5:39am

I have a A/R Aging Reports run by Details and Summary and I used this formula to exstract the invoice amount that greater than 120 days so I can place it in the column >120Days.

It works for the A/R Aging Details report but it didn't work out for the A/R Aging Summary reports. It would grab all the number in the D_90 string it suppose to pick out the invoice amount that meet the condition.

Here is the formula.
if date(year(today()),month(today()),day(today()))>120 + {V_BI_AR_AGING.INV_DATE} then {V_BI_AR_AGING.D_90}

Any help would be great.!

Thanks in advance


Print Page | Close Window