on 08-05-2010 7:07 AM
Hello Experts,
I want o/p like :
Debit Credit Balance Clearing document No
200000 1200000
200000- Nil 1200000
100000
50000-
25000- 25000
Can anyone plz tel me how to calculate balance so that i can print "Nil" for cleared documents.
Thanks,
Manisha
Edited by: PATIL MANISHA on Aug 5, 2010 8:57 AM
Edited by: PATIL MANISHA on Aug 5, 2010 10:57 AM
Hi,
Please confirm the key field for which you are doing the report. for instance, in your case hope you are considering the document number.
Just sum up the debit & credit value. If it is 0, then assign -nil- to the balance. Otherwise, the amount. In your case -
200000 1200000
200000- Nil 1200000
200000 + (-200000) = 0 & hence -NIL.
Regards,
Selva K.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.