cancel
Showing results for 
Search instead for 
Did you mean: 

Nil balance for cleared document

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi,

Thanks for ur reply.

can u tel me in detail how to compare current doc debit/credit value with next document credit/debit value?

I have to check it if clearing document contains any value.

reply...

Thanks

Manisha