[#Form : Normal Day Book] Add : Bottom Part : DBCBDetails [Part : DBCBDetails] Line : DBCBDetailsTL,DBCBDetails Repeat : DBCBDetails : MyBANKCASHColl Scroll : Vertical Height : 25 % Page [Line : DBCBDetailsTL] Field : Simple Field Local : Field : Simple Field : Set As : "Cash Bank Details and on " + $$String:##SVCurrentDate Border : Thin Bottom [Line : DBCBDetails] Field : DBCBDetails Right Field : DBCBAMTDR,DBCBAMTCR [Field : DBCBDetails] Use : Name Field Set As : $Name [Field : DBCBAMTDR] Use : Amount Field Set As : IF $$IsDr:$ClosingBalance then $ClosingBalance Else "" [Field : DBCBAMTCR] Use : Amount Field Set As : If Not $$IsDr:$ClosingBalance then $ClosingBalance Else "" [Collection : MyBANKCASHColl] Collection : MYBankLedColl Collection : MyCashLedColl [Collection : MYBankLedColl] Type : Ledger Child of : $$GroupBank Belongsto : yes Fetch : Name ,ClosingBalance [Collection : MyCashLedColl] Type : Ledger Child of : $$GroupCash Belongsto : yes Fetch : Name ,ClosingBalance
If you are a developer, modify the codes as per your requirement or learn TDL. This forum is not meant to get the codes for free.