Dispaly Today Closing bal as tomarrows opening bal

There are many available reports in Oracle Apps so you can discuss the requirements related to these reports here.
Post Reply
keerti_rose
Posts: 40
Joined: Sat Mar 01, 2008 3:39 pm
Location: India

Dispaly Today Closing bal as tomarrows opening bal

Post by keerti_rose »

Hi Buddies,

This is keerti...Can u pls help me in this...."I am developing a report in General Ledger Module....I have to display "Today Closing balance has to be dispalyed as Tomorrows opening balance"....Pls do the needful...It's really helpful to me.
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

select sum(amount) from table where date < sysdate;
keerti_rose
Posts: 40
Joined: Sat Mar 01, 2008 3:39 pm
Location: India

Post by keerti_rose »

[quote]select sum(amount) from table where date < sysdate;

I don't think so
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests