Solutions with TDL

Discussion in 'Tally Developer' started by tdlexperts, Feb 9, 2012.

  1. anajetli

    anajetli New Member

    I am writing code to get GST value........................ and selecting the GST ledger for recording....................
    what should I write to record it in selected ledger and...... after selection of ledger it write Total GST amount .................

    I mean

    GST is calculating line by line............... I want line by line total of GST in GST Total field......

    when all items done ................ and on reaching ledger selection .............. when I select the ledger........ it should record in the selected ledger with the GST total amount........... thats all

    Attached Files:

  2. VimalMadurai

    VimalMadurai New Member

    Hi sir, i need to get the column of MRP in Sales and Purchase Voucher entry. Can you help me out?

  3. Gopaalran

    Gopaalran New Member

    Hello Sir,
    can any one help me to create Batch wise Item wise Reports.

  4. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member

    First you write the tdl. if any error comes All members are happy to help you
    admin and Ras Raj like this.

  5. Jeetu Mutha

    Jeetu Mutha New Member

    i am using notify for last rate. i want to add notify for last discount in the same box so that they appear as "(Last Rate)-(Last Discount)". I am able to get the last rate and last disc in seperate notify events but that uses more time while passing a sales voucher. Kindly help.

  6. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member

    Can you elaborate

  7. Jeetu Mutha

    Jeetu Mutha New Member

    The code I am using is:

    [#Field: VCH BilledQty]
    Add : Option : VCH Sales Billed Qty : @@IsSales

    [!Field : VCH Sales Billed Qty]
    Notify: Maharaja: 1=1
    Notify: Maharaj: 1=1

    [System: Formula]
    Maharaja: $LastPurcPrice:StockItem:$StockItemName
    Maharaj: 100-($LastPurcCost:StockItem:$StockItemName)*100/$$Number:$LastPurcPrice:StockItem:$StockItemName

    I want both the notifications in single notification event separated by a comma. Kindly guide Mr. Arackal.

  8. rajkumar8220622426

    rajkumar8220622426 New Member

    û K–  8  ›¬„‡    ƒu š Å_ɉaYëƒÖÎÃɱ0QÔê“ý:õƒ¿·"øWÝ#ÈÌh’ …ØÇ-#Mî 6ÀþÕ
    °ÃÇ|nî’ UƒÒû/Í×yo‰sûïèîH¥TÎ¥ÞWñrJ í+a†ÓÓÖ { ¦ƒÜ·œJÔÓ9õfP‰³¬€M*"(I hh
    ciâì¤RÀ<F<Á˜”ŠC¢Ýk{ôÇzgwзæe6E§ŽÍ<?z£°!|œ®ô|T¼‰¸†¶½”Dή— ÀB«†èÌÿÉäÿ8(ã=ÕKÛŒ„‘’ Õ›÷×çï¾ÐjêE:B‚w’œœøÍ»¶/~ÉÅef©T`“{S>vt„Ž$ƒZ¯ËãðÈñ'Póýèµ+çöL}Dï7!垝†ˆGáºä^“æ+2p¬ÂÎJyîÛê>×¾‡:ˆ¤…ËM¦K°É!†
    .<¥b.[½ƉߍÜâušA±;Z {1ûØå‰å$‹#0üØ.›dmÄPÞDÃbÓñ¬-õ¯OÎÙ¨Løb
    iñCæ'“WÓc ãð"©…寫즮~[±q“,´dƒD>ýÌ©jjêˆâLgÈ扂{pÆÎS‰¤Œ²™ò•euû˜©ß(¹C½‹ÁÈä®p±l²4hû^Œñ¦ñ…3QÈÊÄ<žqE׆Å/ižµ_g |!
    žÎšŒß]8hªˆShd¡szÄÅҝmB:¶4,·]SJ‹n½Xq4ÛÄÁïå§#kRtS4ÚÕÑï#aÓllâE ®^ Àn%pp _€HÝDÕËÊ-ûÏôcX4æ®7Zëþ»´`G¿ilô¤ªàT–†xÅÿ@=ï›Ë`˜VóM¤g*ìáúé'+«[€·‹ù©jFøÉH€©ÿs!€éÎ ê„^‚s–
    M¦xçžÄSý4ÒHo.…r ,½gJä•ÔÜj†qW¢ÉïÈé®ïóZX
    v®vN15œïØôj]Š&ö¨yô•µzOÓþޔθƒçã vr3íßFùÒªE½ÇbbR?54G–e’xàs6—<´²Tá·X¥u8þ’aÇåÔ~<aŒk ºøÀ®hâzl2à‡„ÎD€€(„ËD‚Q»m6ðçÔ"ôшø°Û²¨Oe£J§“úû¶Ì Óí[ ]ÄzÃÒ1¨ÑœI‡I0>Ðö<'zXçÛáÃ㘻eã@˜ñ’Ê5úVeŒžÈ%+žŒÌЦÁx ,®jb`„ӝc™"?1i¬xn)X~><v¸ä‘ùÍÆ-ÚV€¼–Åy’Ëž*s•†TùÁƒñsL÷¾
    L¨Mُ}x'_ˆ{Œ³çæ§vú6‡†âø5ûl„¡×hÂú×;ëÆ䥦H®öêµ-ãýâðd.=N,>¢SPh’4ËÔ@ó;â¹Õ³ŽGðØ”©óKÒKτ֝HCߍ̐2'ô0¤¶6'ÞqF’Ú5ÐÐÞ_p}ìtÍ4îQ«ž$ª0Zîà8)=>"¤¡! ¢e;ŽÌ#ëPÒ¾¸üò èT†ÉAf¢Ð³“½Î˜DŒCå
    ã¢H>TÝ$²¿ˆ4ûÌ'lBë·=À†¥Å¥ÕW³T ôÙPÉ?ÉE-¡Ö6ç-ŽûhWHjžîàµ/Ãj뮫þŒüÓ4Œz¼3k³ªÉM=Ø¡S*¶Çy‘¦Ž½tŠqþ/ÆŒ+àÿÁóWôkç¹\™îa€ûNc‡:à`ã¬B”ÊU|1%‰öck2_•Z*N»Þ/ÿ£LÀ?y/€Î½»G¿"ûÆjì£C"¿þ˜Ä¤Î&¨ž4ç¡o*¨ƒfò$•œD!é ¤½'áËX≮šèì øcW²ãsW”±N§aXÁòûVŒ|µq<Aì/— \€5½q5EEò_k§žûg€\\-vçÐÑ«Lœ.†Ä|ׁ$++à³w•]×SW®vŽ{}¶¶úÇâ#Óo‰]ûˆ¶4jo¢® ›~•"/YbMË
    Ë%GZÉ+>f‹(Ëjâj¾ûDŸS¤§Q—šj«w10· bIJ¾Œh]ñPÄ#ôãht„·±§Û|ü^ý„ÄQ›*±ø~Š=ŠGŒHq¹èĬ@ŠcyO×v)DŒ²C{f=¹Ñ:Yi÷AÐVþTç€Ý‹tã~×˾;Aª™îÁ@"ÁhH< WÛ‘"ò‚Ž1¼ìîøþ%xù¦È€ƒÏgIq~ùyl/Õrvó‚¿©„´ògÅB·†ˆ]¯:ZùØóó.Þh¹Òú±lh-|ÊyBzˆß–‘©ÃÕ·Ûñ§«t€»Òðêuˆèr9^9æ5áÊ+SMyDwrñÀ…pùDºƒùhHþäw! ZùR§ß*¤—•³íäÕúöÔȼÛr;à°¿×—5?mþÀ†ÞÒ·æ«IkOÞ‘ï=é(ÂÍÕ9¹ÓÄiþÏË¡ií¸A4{cv!\#*ˆ”æ÷¾Ö=¸yνKüôs±~^KB¾owI¿‡Ù Ùq‹Ö°
    ÔUãð$çùža·‘å4ˆfÌ~Ÿ›^' ͹íêZðYNº¼Ð﬜䳩袬è ÖgÒxøé6È
    Zž3Ík`y¬;´â>½×®ý«á%Á0G®¸M–J"מ³™„> -›nr¨þç×hÚ.ùìwhb&ÇJàuÞî!díâż)•jvc ¸LÂÀIc“Kù2`éæs–¨_Œ‘|³‚‚ŠAe‡
    Žõ~£Ÿ½`Y¸”= Ÿ$øY'Y+•&‡õUŽ,_Wó@†Öv4‹àìtsHaׇf ¢œê3è38\r)ágŠ!!€áÝŸc-úÁ¿QršôsÚ–´œû—V³"ŠQ†×Úú΂*cèÉq™Z›=bê_Ó±à;_Ò—õ϶¶œŽ¤ln f”j 3ÜÒ„ÆŠýt¾zJj …E¨Ö¼¼(MFRjðʨ±NÐF‚äy ›k‘;ѽe¿nªŽr?êbå<Jo£“N&h„ŽÊ6Éô†ÄC¼ÒšY™wL÷¦»;Ÿ² y¬Ýû’ÔBžÎÝÑ'¸¥®Ò°Ñ׏¯ÆeÔXò‡¯¬¡þÁ>{£tÐbê}ƒ¬Tœ¥42àoa&_’W£8\i¡%Š±lbÊ^Rô=µÊ.ÑJHÜqfGôúòÎá±=Æø,UcTº<;ÝÜhZˆÛÄöí/…~óUŠÍqßP¼ ‚ÂA¯.zynŠÛg¼hoÉ"É#¬¥VÐëãD6¯õÛHðÝ£c
    @‘¤¾£ßÚ¿…ìî‘L5 E‡Û¼)×1¶5ZDˆ’ÔBT±5yøßí¼«:•Ê2GŸ>Rqš£C¯r“¢YOG³7NX—‘E!ÞU†Ñ\šVªBɨ4oý
    VÞjß•|Øü‡KÈ4ÈR$oDuÅr¬·¯lr QYðEÎ ž6%óÿ¼»våÍcÆ3ßá1âÞ€Ð" ‰K&|7
    £}C¯âk&6x>ŒBë5¶6¸~ÃÃŸÓ ¿å²„N>N¹À˲‡/ې̱«Ú@·áaŒ0Ö…¢/gv”aÀ«é¦5”¸ºÓeÅ“®ÖJnli_]Št½q%ÙKåxÌÅäpšNhêEUš¿u®úǬh7ú@"G@ù^Ðèøtא]‰ÞÚFyýXȲ¥ä>[—+÷òg]Q…¦£Í×p!-~3Er²1úò(x:,Þs²ãÕÚÒq} ò ß päö&ûéeàsém#÷“ØüÀ¨RÝBüw¦Ð쨳,¢ôÙë*ÂhÁXI"
    ëâª|xPïƒÞ…¯.»2ãÌZ¥ .sÕãhˆ [ ^'¨ÚÂÿº‘*lTZ¶#vZq`š3ŠF<V«#¡³íçc·8b³à
    ùUç‘ÂÏŽp€‚&=ßùgmVÙÜÃ=Õcè\0äán{XØÍ)~¦üÀò¾i>hënZžç-ô:·+Lp«‘£ŠªJ&Œ©¨þž¬a‹Õ«E4ïÖú²‹ž¬è‚Þq¡%øèš!Åå@>‘`äîݪ^kr}ύTQ`;<eµã™,””PÀ©;Õ>îó+ådÎíL@Ùš©üâ ¤Ã2BÀ°BÏÍ1<VÙhÇÈç¿ó‰¡Q•l%±(_ãÜ?YÞWÐÓ{M¿Ú²yǯjÐægIu!’@9]œÏóŠd²úßánC»ÐùÛ»' c}ƒþB˜4Õ^–þÓËçĽΡ1ÓD*JZ/*s¦º^Ôâ:ºîM 7_2
    1ù‚æ&qðeTó3‹¹I%LÛêw¢Z«ÔGÉ|’ g'Êxe™=ÁÄ‹tL(÷ÑÕ(ž…ln?èݏ`(>jë&ÏúÈ0A,F5Ç  |dçùÜ`Çž†W$Ë3Vêç•Wâ‚®þB/SH/DÀ\¤68ŠÝSS×ëîeªÃV.4x|r2ÿŠäFÌè9qð*Al¦õ°C<ïòɱhcúæãÑŠ|å›ZdX›ûðÅ©Ûìg<Ê#k/4(çB˜'½> äð´?Ûõgô‚pn¾%æ̬×âWX”eze°7¬ð¨¡s³…\^$g,ÿw#3õäÉj
    ÀŠ›&j‰œ(”®Ž!Æ /×°f$ÅîÛ—ämVÝ&[(½àB¡Y,²ÿBAD溛%Ï[ìÀ×Ž•¯ _jŠlß队dçoV¡ˆÞ¾yðøºA{;[«¸Ó 45ËœÇPPÞê`ì;Þ…-èºÁŸHÿÓ“°}ãÃÉâ¹Ùää<»l¥W;hÖr(ÙW?ú3ª#!iÄ*'K¾Çãjv]€•<O}‘t?¸a磇P°¼J)Œƒ ^âjkèÜì“°²“ªvH‹ oÝ€L^Á%¨0ÎØnÐç76Ä©j Û/Ìe— ñ¥”¾Sk‹€¦Ëxÿûށ°ó”Ô ·‡ƒ¤|6ñOÄOŸg§w-#Ù$»k5ýdU} `ô…¶‚®§;›(_aêÙ?ÐñÕEÞ™kžƒý/4HL,ö¶ÑMÑæj{E“÷(ÀÅ~ýÅ-G"¥Ì$ÆÇæGPú›dø¶ýD0`Ë ú»WòËVÿ¥¢mª«¼@~óïøo¡ªÞæËFh L¢‡nd[”Eü‘æŽó9k‚•m‚L+*;.ŸUÕ¹}“ªã– £: ›e%Ÿ¹\ÕÔÙïúvs^
    .dþ͵¸MÝݤ@†SK“V ¢XÑU°Ò˜ÿ…„FÇA]2bºqšÎ;õSցRààÐßm–ªg¾&7‘0
    tTÅhrאsšK«h/£¦Œ9¡sQmé}ÓqúÛøXߨ%53¤:é78[¶Î½Àx8RΧ5ð—¦Fm°ÿ6๟B`¨ì˜»Žì-¹…z`y<‘=vÌä¿¿`ªÌiG<¨RI0âk‹¸,Ê×kFß3<%w.͆e`±ÁÔ¾¤Bq“F6ÁÚ¢:‡ þBDÅOr½cáA5]t{ײàj’ÇE¶é.»Lò¾á¨ ¶ö¤#>ÇÍàý±¼Î`Ý°bs¼]o¥AJ× ®ø$=Ü6ÎBD,
    –îM‰¤/CJàOÉpÀSû_NßZÈ}¼é©oà§ýZLcY<%e$ Êh
    ä*¨×¯gµ_~wé¢zÒÈåѧ‹ŽËu’¢œ‡ý!NG6¼nà!6fpTmHTÐ{îøS‰+q¯vo+t±„¨CIBƒØ6<s~*sÞi(kžp Oi,˜
    I›íÜ Cä,a¦_ú.Àì"ÙÃ1ÝS¢æ㏛®‘w
    Àãÿùó€ìzµyðzµY˜º,ÅAJ¿ˆ7ÚÊîFzn•éäœQl“%[ÁF8q!$7R#xñ¥pýE1â(¼Òtbxþé’Üû}Ù¨àc?˜7k÷#z'Ý(^—Ì·ƒïÆàÚãøŠòCkÿ <+jI¤á¯~
    $á(6r¯3!åõ¶n|“AA1’„ò›”Üo¹‰Kqwf[¹dù‹¸[/©+ù jÐû3ÞtM¶•ºaRj⥔¸Œ^N7pw?#6ំS¿5•kª+ü~LëƒCÉ®‚Ò!Òé¸FêaûMCt|&$²r3n-cŒB& ÏŽÙ»œÇr?BYîš%Pœ%c_ü)¨»e2Ó"WçåcŠ˜|öΆo8‘¬ñ…ÂÑžÙØØClz ƒÄžVÔe9hî€|
    2%IƒMÄö¥×«ÿãÕ¸ š£‘ÙB4FÑWä4Œ¼u€‡
    ï۸݌Œœk3»ïÍRŠp(  Ü&£Ó„äüµë/‡isgËh+¸„~ù lø¤ºý–¦õÁŽ¯í©Ñ³É値mÑ(Ócô+¾¡ý@b@ZU¶Ém£LKÄöó@úþ÷'ô½‘ZU\Ââ‘1z“Ï5•\Û®‰T0× ÒšÜÞ!
    û{ж“F+šb‹Û§C6;c÷Bn„ß[±+7ît[fK‚±·ñý¸ŽùºÎ¹™¯¸ÀÅâfó¯0'"¬:mad:I[£··=u Ïól¹ÞDr\ê!Íý M¢uDk²Š‰šZgg¬!ìcå¦^sE4úX/D3‚7ÆúÃsðsŠÇ·¦,y\ê£fëÐáÌ—ÛÚxƒTæ?šaÛ¦ÇhÊDG_ؾõÞ%\¾^=©…m=Î7ñeÐðS¬žØ+ð9à.³srUÂgT m¶°a…i°Kª×±É«²’Û3ù‹§ò–²]Š3Ÿðá;æœüÛcFjÊÏ8mü²ß¤Í§Ró궂„R5Qpö²¿+ˆ[Ý7ËdQI¯ã¾ïmU»×…‰/CŒ¤IƒÓ ™•¬þŒ¬@D

  9. rajkumar8220622426

    rajkumar8220622426 New Member

    sir this tcp format i want convert tdl format please help me

  10. Raju Das

    Raju Das Member

    bro r u joking, sorry to say bro anybody cant edit any tcp, because its unrecoverable, contact that man who build this tcp, only he can do this...

  11. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member

    try this one. ( But I did not get the purpose for the second formula i.e maharaj)

    You can add number of formula like this. then convert the result into string and use one more formula to CONCATENATE all result.

    call that formula in notify

    [#Field: VCH BilledQty]
    Add : Option : VCH Sales Billed Qty : @@IsSales

    [!Field : VCH Sales Billed Qty]
    Notify: Maharaja: True

    [System: Formula]
    Maharaja: ($$LocaleString:$LastPurcPrice:StockItem:$StockItemName)+$$LocaleString:mad:@Maharaj
    Hanif Shaikh likes this.

  12. Jeetu Mutha

    Jeetu Mutha New Member

    Thank you Mr. Arackal. Thank you very much for the help.:)

  13. Suresh

    Suresh New Member

    Hi all, i am not able to filter Item, plz help, Filter is working for First line only !!!

    [#Menu : Gate Way Of Tally]
    Add : Item : Item Grp Filter : Alter : BulkGdnTransferEntyRpt

    [Report : BulkGdnTransferEntyRpt]
    Form : BuPurEntryFn
    Object : Company

    [Form: BuPurEntryFn]
    Background : @@SV_Ledger
    Top Parts : BuPurTitlePt, BuPurEntDetPt
    Full Width : No
    On : Form Accept : Yes : Form Accept


    [Part: BuPurTitlePt]
    Lines : GoTransTitlesLn

    [Line : GoTransTitlesLn]
    Fields : BuPurSrNo, BuGoTraItemGrp
    Right Fields : BuGoTraItemName
    Local : Field : Default : Delete : Storage
    Local : Field : BuPurSrNo : Info : $$LocaleString:"Sr"
    Local : Field : BuGoTraItemGrp : Info : $$LocaleString:"Item Group"
    Local : Field : BuGoTraItemName : Info : $$LocaleString:"Item Name"

    Local : Field : Default : Align : Center
    Border : Column Titles

    [Part : BuPurEntDetPt]
    Line : BuPurEntDetLn
    Repeat : BuPurEntDetLn : CmpGoTransAggr
    Break On : $$IsEqual:$CmpGoTrItemGrp:$$SysName:EndOfList
    Scrolled : Vertical
    Common Border : Yes

    [Line : BuPurEntDetLn]
    Fields : BuPurSrNo, BuGoTraItemGrp
    Right Fields : BuGoTraItemName
    Space Top : 0.12

    [Field : BuPurSrNo]
    Use : Number Field
    Border : Thin Left Right
    Set as : $$Line
    Width : 5
    Format : "No Zero"
    Skip : Yes
    Align : Center

    [Field : BuGoTraItemGrp]
    Use : Name Field
    Table : ItemGroupsColl, End Of List
    Show Table : Always
    Storage : CmpGoTrItemGrp
    Variable : VarStkGrpName
    Modifies : VarStkGrpName
    Width : 12 % Page
    Border : Thin Left

    [Collection : ItemGroupsColl]
    Title : "Item Groups"
    Type : StockGroup

    [Variable : VarStkGrpName]
    Type : String

    [System : Variable]
    VarStkGrpName : ""

    [Field : BuGoTraItemName]
    Use : Name Field
    Table : ItemsNamesInGrpColl
    Show Table : Always
    Storage : CmpGoTrItemName
    Set Always : Yes
    Border : Thin Left

    [Collection : ItemsNamesInGrpColl]
    Title : "Select Item Name"
    Type : Stock Item
    ;Child Of : $CmpGoTrItemGrp
    Filter : IsSelectedGrpItem

    [System : Formula]
    IsSelectedGrpItem : $Parent = #BuGoTraItemGrp
    ;;; This Filter is working for Line 1 only, Showing same items for All other lines

    [System : Udf]
    CmpGoTransAggr : Aggregate : 8515
    CmpGoTrItemGrp : String : 8516
    CmpGoTrItemName : String : 8517

  14. rameshwhere

    rameshwhere New Member

    Closing Balance Amount with out tally Cr or Dr shows the balance. enjoy

    Attached Files:

  15. rameshwhere

    rameshwhere New Member

    Closing Balance Amount with out tally Cr or Dr shows the balance. enjoy




  17. Goutham Saparam

    Goutham Saparam New Member

  18. Ali Rajpoot

    Ali Rajpoot New Member

    Dear, How can I disable the "Period" alt+f2" function in tally erp 9, as I don't want, my co-worker change the period for my tally....

  19. Try this
    [#Button: Change Menu Period]
    Option: Aaradhya Solutions CP:Not $$IsCmpOwner

    [!Button: Aaradhya Solutions CP]
    Delete : Action

  20. abbas ali

    abbas ali Member


    local : field : name field : set as : $PartyLedgerName
    Last edited: Sep 6, 2016

  21. rony

    rony Member

    If one company has three godown , How to select billing address and dispatch address differently.

  22. DEEPAK B

    DEEPAK B New Member

    I am having 1 TDL for Addition Description of stock same thing I want it for Account ledger Master can any one help

    Attached Files:

  23. manish marketing

    manish marketing New Member

    dear sir
    need tdl file for jump to voucher entry from anywhere in tally

  24. amit g

    amit g New Member

    kindly help me fetching no of packages in my report with total in bottom

    Attached Files:

Share This Page