can anyone help me making rokkad type or T style cash book .... ledger

check the conditions once again.............. in the collections or the filter formula

 

Instead u should use formula......... OpBal + DrTotals - CrTotals = ClBal

or Just....$ClosingBalance

 

I presume from the screenshot that your Opening Balance is coming from a "LINE"....... so you need to just add the Opening Balance to the DrTotals or CrTotals ... means in the Field.....add Openng Balance to the total.

 

The Journal entry u have circled and which u want on the credit side....why??? the amount is showing DEBIT, so it is coming as intended on the debit side.

 

As for common total.... ADD one more line for both Dr & Cr sides..... and then in that amount field... add the above two totals.

 

Why having 2 titles.... looks odd.... keep one title....as it is common for both.........the bottom part...for month-wise breakup

 

For Bottom Monthly break-up...............
Set as : If ($GrandParent:Ledger:##LedgerName="Sundry Debtors" OR $_PrimaryGroup:Group:$Parent:Ledger:##LedgerName="Sundry Debtors") Then "Nett Sales" Else "Nett Purchases"

Set as : If ($GrandParent:Ledger:##LedgerName="Sundry Debtors" OR $_PrimaryGroup:Group:$Parent:Ledger:##LedgerName="Sundry Debtors") Then "Nett Receipts" Else "Nett Payments"

 

you haven't remove the blank spaces yet..............

 

Your grand total is wrong........rectify it...........

 

Add the subtotal field and closing balance as computed

 

Set As : #LCFTotal + #LCFBalanceField

 

very good effort..... ......alongwith printing setup........ try to do export setup too.........

help out @KRISBALA with his problems, if you can..................