Tally TDL Coding Expert with Rajiv Mishra

  Few lines of this code is missing. Pls Watch the full video to get full coding. Option : TAXINCLU : @@IsSales Or @@IsPurchase [!Line : TAXINCLU] Add : Left Fields : After : EXPINV DescTitle : TAXINC Local : Field : TAXINC : Info : "Batch" Local : Field : TAXINC : Width : 4 Local : Field : TAXINC : Align : Center [#Line: EXPINV InvDetails] Option : EB EXPINV InvDetails : @@IsSales  [!Line : EB EXPINV InvDetails] Add : Left Fields : After : EXPINV Desc : TAXINC [Field : TAXINC] Use : Simple Field Align : Right Set as : $BatchName Border : Thin Left Width : 4.5 Skip : YES Option : TAXINCLUD : @@IsSales [!Line : TAXINCLUD] Add : Left Fields : After : EXPINV DescTitle : TAXINCL Local : Field : TAXINCL : Info : "Exp" Local : Field : TAXINCL : Width : 4.5 Local : Field : TAXINCL : Align : Center [#Line: EXPINV InvDetails] Option : WEB EXPINV InvDetails : @@IsSales [!Line : WEB EXPINV InvDetails] Add : Left Fields : After : EXPINV Desc : TAXINCL [Field : TAXINCL] Use : Si...

  Few lines are missing here. Pls watch the video for full  coding. [#Form: CMP Action Form]     Add:Button:AutoPath [Button:AutoPath]     title: if ##AutoPath then "Manual Path" else "Auto Path"     Key: Alt + U     Action:call :AutoPathfunc [Function:AutoPathfunc]       10:Set:AutoPath : not ##AutoPath       100:Return [#Field    : CMP Directory]     table        : TlyTrng ListofData Path : ##AutoPath     Show Table    : Always     Key:AutoPath [Collection    : TlyTrng ListofData Path]     Title        : "List of Data Path"     Type        : DATA    : App INI Config     Child Of    : "AppINIConfig"     Fetch        : DATA     Format        : $DATA

  Few lines are missing here. Pls watch the full video first to get the full coding       [Function : DSD Remove Alias Of Maters]         001 : CALL : DSD Remove Alias of Ledger     002 : CALL : DSD Remove Alias of StockItem       [Function : DSD Remove Alias of Ledger]         01 : WALK COLLECTION            : LEDGER         02    : Modifyobject : (Ledger,$Name).LanguageName[1].Name[2].Name    :""       03 : END WALK     [Function : DSD Remove Alias of StockItem]         01 : WALK COLLECTION            : StockItem         02    : Modifyobject : (StockItem,$Name).LanguageName[1].Name[2].Name    :""       03 : END WALK

  Few Lines are Missing Here. Watch the full video to get the full coding [Line : Daybook cr]     Add : left Field : LineselectedTotal1,LineselectedTotalD,LineselectedTotalC     Right Field : Daybook dr, Daybook cr [Field : Daybook dr]     Use : Amount Forex Field     Set as : $$Total:DSPDBDrAmt     Invisible          :  ##IsVoucherregister [Field : Daybook cr]     Use : Amount Forex Field     Set as : $$Total:DSPDBcrAmt     Invisible          :  ##IsVoucherregister [#Part: DB Body]     Total: DSPDBDrAmt,DSP DBCrAmt [#Line : DSP VchDetail]     Option        : SelectedLinesRajtSKRTotalOnFocus1     Option        : SelectedLinesRajtSKRTotalOnFocusd     Option        : SelectedLinesRajtSKRTotalOnFocusc [!Line: SelectedLinesRajtSKRTotalOnFocus1] ;Line...

  Few lines are missing here. Pls Watch the full video first. [#Form: Ledger Vouchers] Add: Button: InputNewVchRajivamt1 [#Form: Day Book] Add: Button: InputNewVchRajivamt1 [Button: InputNewVchRajivamt1] Title: "Set Fix Vch Amt" Key: CTRL+F7 Action List : InputVchRajivamt1, ModifyVchRajivamt 1 [Button: InputVchRajivamt1] Key:CTRL+F7 Action: Alter: Rpt InputVchRajivamt1 [Button: ModifyVchRajivamt1] Key: CTRL+F7 Action: Call : FuncEdit4 [Function: FuncEdit4] Variable : MSTID : String 100 : WALK COLLECTION : SELRajivVouchers4 120 : SET : MSTID : "ID:"+ $$String:$MasterID 130 : NEW OBJECT : Voucher : ##MSTID 140 : SET TARGET : LedgerEntries[1] 160 : SET VALUE : Amount : #NvVchRajivamt 170 : SET TARGET : .. 172 : SET TARGET : LedgerEntries[2] 175 : SET VALUE : Amount : #NvVchRajivamt 177 : SET TARGET : .. 180 : SET TARGET : .. 190 : ACCEPT ALTER 200 : END WALK [Collection: SELRajivVouchers4] Data Source : Report : Selected Fetch : All Ledger Entries [Report: Rpt InputVch...

  Few Lines are missing here. Watch the full video to get full coding. Width : @@VCHQtyWidth Setas : $$LocaleString:"Gross Wt." Style : Small Align : Centre Border : Thin Right Invisible : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then Yes Else NOT $DiffActualQty OR $$IsPhysStock:##SVVoucherType OR $$IsStockJrnl:##SVVoucherType Skip : Yes Fixed : Yes [#Field: VCH BilledQtyTitle] Width : @@VCHQtyWidth Setas : $$LocaleString:"Net Wt." Style : Small Align : Centre Inactive : If @@IsJobOrdersOn Then Yes Else NOT $DiffActualQty OR $$IsPhysStock:##SVVoucherType OR $$IsStockJrnl:##SVVoucherType Skip : Yes Fixed : Yes [#Field: EXPINV ActualQtyTitle] Use : QtyTitleField Set as : if @@IsOrderVch then $$LocaleString:"To Ship" else $$LocaleString:"Gross Wt." Align : Centre Style : Small Invisible : @@IsJobWorkVouchers OR NOT @@InvWithQty OR NOT @@InvWithActQty OR NOT $$InPixelMode [#Field: EXPINV BilledQtyTitle] Use : QtyTitleField Set as : if @@IsOrd...

  Few lines are missing here. Pls watch the full video first. [#Line: EXPSMP Column1]      Add:  Field      : After : EXPINV DescTitle  :RBCSMP AddlDescTitle; : @@RBCAddlDescDetails      Add    : Right Field    :  Before : EXPINV QtyTitle : EXPINV PackagesTitle1      Local          : Field : EXPINV PackagesTitle1    :  Border: Thin Left      Local          : Field : EXPINV PackagesTitle1    :  Info: "Package"      Local          : Field : EXPINV DescTitle    :  Align : Left        [#Line: EXPSMP Column2]     Add:  Field     : After :EXPINV DiscTitle: RBCSMP Column2; :  @@RBCAddlDescDetails     Add    : Right Field    :  Before : EXPINV ActualQtyTitle : ...

  Few lines are missing here. Pls watch the full video first. [#Line : EI ColumnOne] Option : Global EI ColumnOne [!Line: Global EI ColumnOne] Add : Right Fields : After : VCH DiscTitle : SchemeAmtTL,SchemeAmtTL1,SchemeAmtTL2 Info : "Dis-1" Align : Centre Width : 5 Style : Small Border : Thin Left Right Background : Red [Field : SchemeAmtTL1] Info : "Dis-2" Align : Centre Width : 5 Style : Small Border : Thin Left Right Background : Green [Field : SchemeAmtTL2] Info : "Dis-3" Align : Centre Width : 5 Style : Small Border : Thin Left Right Background : Blue [#Line : EI ColumnTwo] Option : Global EI ColumnTwo [!Line: Global EI ColumnTwo] Add : Right Fields : After : VCH DiscTitle : SchemeAmtTL ,SchemeAmtTL1,SchemeAmtTL2 Local : Field : SchemeAmtTL : Info : " " [#Line : EI InvInfo] Option : Global EI InvInfo [#Line : CI InvInfo] Option : Global EI InvInfo [!Line: Global EI InvInfo] Add : Right Fields : After : VCH Discount : SchemeAmt,SchemeAmt1,Sch...

  Few Lines are Missing Here. Pls Watch the video to get full coding. On : Form Accept : $$InAlterMode : CALL : SALES Export Report On : Form Accept : $$InCreateMode : CALL : SALES Export Report ;; Function Definition begins [Function: SALES Export Report] 10: SET : SVExportLocation : "C:\users\user\desktop\daily" 20: SET : SVExportFormat : $$SysName:pDF 30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber 40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat 50: Set : SVPrintFileName :##SVExportLocation+"\"+#SVPrintFileName 60: EXPORT REPORT : . : TRUE ;; End of File

  Few Lines are missing here. Pls watch the video first to get the full coding/ [#Line: EI ColumnOne] Option : TlyErp EI ColumnOne :  [#Line: EI ColumnTwo] Option : TlyErp EI ColumnOne :  [#Line: EI ColumnOneRate] Option : TlyErp EI ColumnOne :  [!Line : TlyErp EI ColumnOne] Add : Right Fields : Before : VCH QtyTitle : TlyErp VCH BatchTitle, TlyErp VCH MfgTitle, TlyErp VCH ExpTitle [Field: TlyErp VCH BatchTitle] Set as : $$LocaleString:"Batch No" Style : Small Bold Align : Centre ;Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl Skip : Yes Fixed : Yes ;Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth Inactive : NOT @@HasBatchWise [Field: TlyErp VCH MfgTitle] Set as : $$LocaleString:"Mfg. Date" Style : Small Bold Align : Centre ;Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffAc...

  Few lines are missing here. Pls watch the Full video first. [#Line: EI ColumnOne] ;; Invoice Column Headings1 without class Option : Global EI ColumnOne : @@IsSales [#Line: EI ColumnOne] Add : Right Fields : Before: VCH Qtytitle : PrevRate Local : Field : Default : Align : Left Local : Field : PrevRate : Info : "Prev. Rate" [Field: PrevRate] Use : Short Name Field Width : 8 Align : Center Invisible : NOT ##VrVarC1 Skip on : $$IsEnd:$StockItemName [#Line: EI InvInfo] Add : Right Fields : Before: VCH BilledQty : PrevRate1 Local : Field : Default : Align : Left ; Local: Field: default : Set as: $Prevrate1 [Collection: VCHSourceColl] Type : Vouchers : VoucherType Child of : $$VCHTypeSales [Collection: VCH Summary Collection] Source Collection : VCHSourceColl Walk : Inventory Entries By : Partyled : $PartyLedgerName By : ItemName : $StockItemName By : VoucherNo : $$Owner:$VoucherNumber By : MasterId : $MasterId Aggr Compute : RateValue : Sum : $Rate Sort : Default : -$MasterId [...

  Few Lines are missing here. Watch the video first. BottomParts : EXPINV Totals , EXPINV SignOff , EXPINV Customer, EXPINV Jurisdiction, EXPINV InvoiceCompGen ; Width : @@InvWidth Inch ; Height : @@InvHeight Inch ; Space Top : @@InvSpace inch ; Space Right : 0.5 inch ; Space Left : @@InvSpaceLeft inch ; Space Bottom: 0.25 inch Page Break : EXPINV ClPageBreak, EXPINV OpPageBreak Option : STX Comprehensive Invoice : @@IsIndianServiceTax AND $$STXCanUpdateDutyLed Option : Invoice Bank Info Fetch : ##SABankInfo AND NOT $$IsSysName:##SABankName ;; When Sales Bill is made in Voucher mode, while printing sales ledger is also getting printed Set Always : SVViewName : $$SysName:InvVchView Delete :parts : STDInvoiceTop, EXPINV OpPageBreak, EXPINV Details Delete :BottomParts : EXPINV Totals , EXPINV SignOff , EXPINV Customer, EXPINV Jurisdiction, EXPINV InvoiceCompGen Add: Top Parts : INV;,EXPSMPtitle1 Height : 100% Page Width : 100% Page Space Top : 0.25 inch Space Right : 0.25 inch Space L...

  Few lines of this code is Missing here. Pls Watch the full video for  Full coding. आप में से कई साथियों को Month wise Income रिपोर्ट बनानी होती है जिसमे काफी समय लगता है. आज की कोडन आपके समय को बचाएगी और बिलकुल Professional Monthly Yearly Income  रिपोर्ट दिखाएगी।  Tally TDL की कुछ Lines आपको वीडियो में से लेनी है बाकि कोड नीचे दिया गया है।  अब हम इसे इस्तेमाल करना समझेंगे।  वैसे तो यह बड़ा आसान तरीका है पर इसमें आपको अपने Voucher Entry की Date को ध्यान रखना है क्यूंकि यह रिपोर्ट Voucher Date के अनुसार उसी महीने की Income रिपोर्ट दिखती है।  आप रिपोर्ट में जा कर Period Change कर के Monthly And Yearly रिपोर्ट देख सकते है।  बाकि पूरी जानकारी के लिए आपको इसकी वीडियो जरूर देखनी चाहिए।  : Before : @@locQuit  : "Month Wise Income Report" : R : Display : Income [Report:Income] Use : DSP Template Title  : "Month Wise Income Summary" Repeat : IncomeStatement Form : Income         Variable :...