hello members, can someone help me with a TDL for putting a "opening balance" tag on above in ledger.... :: can see the pic attached for position :
Code: [#Line : LV Title] Add : Field : After : LEDMailName : LVOPeningBalance [Field : LVOPeningBalance] Use : Name Field Set as : $$String:"Opening Balance: " + $$LocaleString:($OpeningBalance:Ledger:##LedgerName) Color : Blue
Code: [#Line : LV Title] Add : Field : After : LEDMailName : LVOPeningBalanceT, LVOPeningBalance [Field : LVOPeningBalanceT] Use : Name Field Set as : "Opening Balance" Color : White Background : Red Width : 13 Align : Right Border : Thin Box [Field : LVOPeningBalance] Use : Amount Field Set as : $OpeningBalance:Ledger:##LedgerName Color : Yellow Background : Black Format : "DrCr, No Zero" Width : 15 Align : Left Border : Thin Box
@bikash agarwal, see this code [#Line : LV Title] Add : Field : After : LEDMailName : LVOPeningBalance [Field : LVOPeningBalance] Use : Name Field Set as : $$String:"Opening Balance: " + $$LocaleString$OpeningBalance:Ledger:##LedgerName) Color : Blue [#Line : LV Title] Add : Field : After : LEDMailName : LVClosingBalance [Field : LVClosingBalance] Use : Name Field Set as : $$String:"Closing Balance: " + $$LocaleString$ClosingBalance:Ledger:##LedgerName) Color : red
Finaly done, sea code [#Line : LV Title] Add : Field : After : LEDMailName : LVOPeningBalance [Field : LVOPeningBalance] Use : NAME Field Set as:$Address:LEDGER:##LEDGERnAME;+","+$StateName+","+$PinCode:LEDGER:##lEDGERnAME Color : Blue Line:2 Width:50 Background:WHITE Border:THIN BOX Style:TINY Type:String Skip:Yes ;+++++++++++++++++++++++++++ [#Field:LV TITLE] ColorPINK Local:StyleEFAULT:Height:16 Border:THIN BOX ;BackgroundINK [#FieldSP MainDateTitle] ColorPINK Border:THIN BOX ;BackgroundINK Local:StyleEFAULT:Height:16 ;++++++++++++++++++++++++++++++ [#Part:LV ScrTitle] Add:Line:AT END:NEWLVTITLE, NEWLVTITLE1 [Line:NEWLVTITLE] ADD: Left Field:NEWLVTITLE,NEWLVTITLE1 Add:Right Field:NEWOPBAL,NEWCLBAL ;Local:Field:SIMPLE PROMPT:BackgroundPINK Local:Field:SIMPLE PROMPT:Border:THIN BOX Local:Field:NAME FIELD:Border:THIN BOX [Line:NEWLVTITLE1] Add:Left Field:NEWLVTITLE2,NEWLVTITLE3 Add:Right Field:NEWSUBDRAMT,newsubcramt ;Local:Field:SIMPLE PROMPT:BackgroundINK Local:Field:SIMPLE PROMPT:Border:THIN BOX Local:Field:AMOUNT FIELD:Border:THIN BOX [Field:NEWLVTITLE] Field:Simple Prompt, Name Field Local:Field:Simple Prompt:Set as:"GSTIN No. :" Local:Field:name field:Set as:$PARTYGSTIN:Ledger:##LedgerName ;Local:Field:NAME FIELD:Background:WHITE Local:Field:NAME FIELD:Skip:Yes [Field:NEWLVTITLE1] Field:Simple Prompt, Name Field Local:Field:Simple Prompt:Set as:"Contact Person :" Local:Field:NAME FIELD:Set as:$LEDGERcontact:LEDGER:##LEDGERNAME ;Local:Field:NAME FIELD:Background:WHITE Local:Field:NAME FIELD:Skip:Yes [Field:NEWLVTITLE2] Field:Simple Prompt, Name Field Local:Field:Simple Prompt:Set as:"CELL No. :" Local:Field:NAME FIELD:Set as:$LEDGERMOBILE:LEDGER:##LEDGERNAME ;Local:Field:NAME FIELD:Background:GREY Local:Field:NAME FIELD:Skip:Yes [Field:NEWLVTITLE3] Field:Simple Prompt, Name Field Local:Field:Simple Prompt:Set as:"E-mail ID :" Local:Field:NAME FIELD:Set as:$Email:LEDGER:##LEDGERNAME ;Local:Field:NAME FIELD:Background:GREY Local:Field:NAME FIELD:Skip:Yes [Field:NEWOPBAL] Field:Simple Prompt, AMOUNT Field Local:Field:Simple Prompt:Set as:"OP. BALANCE :" Local:Field:AMOUNT FIELD:Set as:$OpeningBalance:Ledger:##LedgerName Local:Field:AMOUNT FIELD:Format:"DR,CR" ;Local:Field:AMOUNT FIELD:Background:WHITE Local:Field:AMOUNT FIELD:Border:THIN BOX Local:Field:AMOUNT FIELD:Skip:Yes [Field:NEWSUBDRAMT] Field:Simple Prompt, AMOUNT Field Local:Field:Simple Prompt:Set as:"DR SubTotal :" Local:Field:AMOUNT FIELD:Set as:$$Total:dspvchdramt Local:Field:AMOUNT FIELD:Format:"DR,CR" ;Local:Field:AMOUNT FIELD:Background:GREY Local:Field:AMOUNT FIELD:Skip:Yes [Field:NEWSUBcRAMT] Field:Simple Prompt, AMOUNT Field Local:Field:Simple Prompt:Set as:"CR SubTotal :" Local:Field:AMOUNT FIELD:Set as:$$Total:dspvchCramt Local:Field:AMOUNT FIELD:Format:"DR,CR" ;Local:Field:AMOUNT FIELD:Background:GREY Local:Field:AMOUNT FIELD:Skip:Yes [Field:NEWCLBAL] Field:Simple Prompt, AMOUNT Field Local:Field:Simple Prompt:Set as:"CL. BALANCE :" Local:Field:AMOUNT FIELD:Set as:$cLOSINGBalance:Ledger:##LedgerName Local:Field:AMOUNT FIELD:Format:"DR,CR" ;Local:Field:AMOUNT FIELD:Background:WHITE Local:Field:AMOUNT FIELD:Border:THIN BOX Local:Field:AMOUNT FIELD:Skip:Yes
Dear Amitji and All Colleague I have Shifted Opening Balance Line from Bottom Part To Top of Body Part... Thank you
Nice idea and implementation.....Congrats.... Ensure, it remains the same when you activate "Running Balance" and columnar.
Dear Amitji Yes, it remains the same after activate "Running Balance" and not showing in Columnar Report. Thank you for the guidance.
>Set as : $$String:"Opening Balance: " + $$LocaleString$OpeningBalance:Ledger:##LedgerName) How to add current date/time/datetime here instead? Asking for knowledge purpose