Skip to Content
0
Former Member
Jan 04, 2008 at 07:41 AM

First Doc Date

21 Views

Hi Gurus,

I have a scenario wherein

Cust Appntmntdt Doc Date Deposit

ABC 5/18/2007 5/25/2007 -100,000.00 INR

9/14/2007 115.00 INR

10/31/2007 3,385.00 INR

11/30/2007 0.00 INR

12/29/2007 7,581.00 INR

Now , with this i want to display first deposit of tht customer. Here, customers first deposit is on 5/25/2007 -100,000.00 INR.

The query result will be:

Cust Appntmntdt Starting Deposit

ABC 5/18/2007 -100,000.00 INR

HOw can i achieve this...??

Thanks in advance.

Vaishnavi.