Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: A/R Invoice formula Post Reply Post New Topic
Author Message
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Topic: A/R Invoice formula
    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

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.