Tally TDL Coding Expert with Rajiv Mishra

 Few lines are missing here. Watch the full video for full coding. [#Menu: Gateway of Tally] Add : Item : Blank Add : Key Item :  Search Description: H : Alter : FindVoucherRajiv Title : $$LocaleString:"Description Search " [Form: FrmFindVoucher] Part : PrtFindVoucher Full Width : Yes Space Right : 2 Space Left : 2 Option : Small Size Form Background : @@SV_CMPCONFIG On: Form Accept : Yes : Form Accept On: Form Accept : Yes : Display : FindVoucherRajiv Entries in Daybook [Part: PrtFindVoucher] Line :LinImpReceiptV [Line: LinImpReceiptV] Fields : Medium Prompt, Name Field; Local: Field: Medium Prompt : Set As : " Search String (Contains)" Local: Field: Name Field : Modifies : xlsFilePath : Yes [Report: FindVoucherRajiv Entries in Daybook] Use : Daybook ; Title:Search Contain data Set : SVFromDate : $$FinYearBeg:##StartDate:$StartingFrom:Company:##SVCurrentCompany Set : SVToDate : $$FinYearEnd:##StartDate:$StartingFrom:Company:##SVCurrentCompany Set : ExplodeNarrFlag ...

  Few lines are missing here. watch the video for Full Code [Field:CMP EnableBrokerLine] Use : Logical Field Storage : EnableBroker Set as : If $$IsEmpty:$$Value then "No" else $$Value Sub Form: CMP BrokerNameReport: $$Value = "Yes" [Report: CMP BrokerNameReport] Form : CMP BrokerNameForm Object : Company [Form: CMP BrokerNameForm] Part : CMPBrokerDetails Background : White, Petal Pink [Field:CMPName Field] Use : Name Field Skip : Yes Align : Center Border : Thin Bottom [Part:CMPBrokerDetails] Part : CMP BrokerNamePart,CMP TransportPart,CMP LoadManPart Vertical : No Common Border : Yes [Part: CMP BrokerNamePart] Line : CMP BrokerNamePartTit,CMP BrokerName LineDetails Repeat : CMP BrokerName LineDetails: BrokerNameList BreakOn : $$IsEmpty:$BrokerNameList Height : 10 Scroll : Vertical CommonBorder: Yes Space Left : 2 mms Space Right : 2 mms Border : Thin Right [Line:CMP BrokerNamePartTit] Field : CMPName Field Local : Field : CMPName Field : Set as : "Boker Name...

  Few lines are missing here. Kindly watch full video for complete code ;;----------GatewayofTaly menu by Rajiv--- [#Menu: Gateway OF Tally] Add: Toolbar Buttons: StockItemhotkey [#Form: Default] Add: Toolbar Buttons: before : HelpButton : StockItemhotkey [button: StockItemHotKey] Key: ALT + L Action: alter : StockItemclosingbalance Title: " Stock Qty Balance" [Report: StockItemclosingbalance] Form: StockItemclosingbalance Title: "StockItem Balance" [Form: StockItemclosingbalance] No Confirm: yes Part: StockItemclosingbalance Option: Normal size form [Part: StockItemclosingbalance] Line: StockItemclosingbalance [Line: StockItemclosingbalance] Field: StockItemselect, Short Name field Local: Field: Short name field : Set as: $closingbalance:StockItem:#StockItemselect

  [#Menu: Gateway OF Tally] Add: Toolbar Buttons: Notepad, Word, Excel, Tally, Powerpoint, My Computer, Paint, Chrome [#Form : Default] Add: Toolbar Buttons: before : HelpButton : Notepad, Word, Excel, Tally, Powerpoint, My Computer, Paint, Chrome [Button : Chrome] Title : $$LocaleString:"Chrome" Key : Ctrl + C Action : Exec Command : Chrome.exe [Button : Paint] Title : $$LocaleString:"Paint" Key : Ctrl + P Action : Exec Command : mspaint.exe [Button : My Computer] Title : $$LocaleString:"MyComputere" Key : Ctrl + A Action : Exec Command : My computer.exe [Button : Notepad] Title : $$LocaleString:"Notepad" Key : Ctrl + O Action : Exec Command : Notepad.exe [Button : Word] Title : $$LocaleString:"Word" Key : Ctrl + D Action : Exec Command : WinWord.exe [Button : Excel] Title : $$LocaleString:"Excel" Key : Ctrl + X Action : Exec Command : Excel.exe [Button : Tally ] Title : $$LocaleString:"Tally" Key : Ctrl + Y Action ...

  Few lines of the code is missing here. Pls watch the full video for full code. ;;----------Gate way of Taly menu by Rajiv--- [#Menu:Gate Wayof Tally] ;; you can write the menu without space Gatewayoftally-- Add : Item : RajDarbar Room Reservation : Display : RajDarbar ;;--- you can change the item name-- [Report : RajDarbar] Variable     : SVFromDate, SVToDate Set         : SVfromDate     : ##SVDate Set         : SVToDate     : ##SVCurrentDate Form         : RajDarbar [Form : RajDarbar]     Parts         : DSP Company Name, DSP Company Address     Use         : DSP Template     Height         : 100% Screen ;;-- you can increase decrees height width  lke 50% screen--     Width         : 100% Screen     ;BackGro...

  Few lines of the code is Missing. Watch the full video for complete code. [#Menu: Gateway of Tally] Add : Key Item : "Expiry Report ": E : Display : EBXRptMain : $$IsAccountingOn:$$CurrentCompany [Report: EBXRptMain] Title : "Stock Item Expiry report " Print Set : Report Title : "Stock Item Expiry report" Variable : SVFromDate, SVToDate, IsItemBatchReport Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate Form : EXRptMain [Form: EXRptMain] Part : PMainTitle , PExpiryTitle, PExpiryBody Background : Released Pale Yellow Buttons : PrintButton, ExportButton, ChangePeriod Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12 Space Top : if $$InPrintMode Then ##SVSpaceTop else 0.05 inches Space Bottom : if $$InPrintMode Then 0.5 else 0 inches Space Left : if $$InPrintMode AND $$InPixelMode then 0.5 else 0 inches Space Right : if $$InP...

 few lines are missing here. Watch the lesson Video for complete code.  : Y : Display : STQueryCSknl : NOT $$IsEmpty:$$SelectedCmps  [Report: STQueryCSknl] Use : DSP Template Form : STQueryCSknl Title : "Month Wise Dispatch" PrintSet : Report Title : "Month Wise Item Wise Total sales"  Variable : SV Print Orientation : String  Variable : ETNETNPartyMatInNameLed : String Set : ETNETNPartyMatInNameLed : ""  Variable : ETNETNPartyMatInItemNameLedItem : String Set : ETNETNPartyMatInItemNameLedItem : "" [Form: STQueryCsKnl] Use : DSP Template Parts : DB Title, STQueryCSknl Delete : Buttons : ExplodeFlag Delete : Bottom Buttons : DSPAutoColumns, BudgetAnalysis, ReportConfig Local: Line : DB Title : Local : Field : Name Field: Set as : "Month Wise Item Wise Total Sales" background : White  Button :Print Button,Export Button,ETNETNPartyMatIn,ETNETNPartyMatInItem  Set Always : SV Print Orientation : "Landscape" [Button ...

  few lines are missing in this. pls watch the full video for full coding. [!Line : Global EI ColumnOne1] add : fields: before:VCH ItemTitle : VCH SlNO [field : vch slno] use : name field setas : "SL" Align : Centre width : 5 style : bold Skip : yes [#Line : EI InvInfo] Option : Global EI InvInfo1 [#Line : CI InvInfo] Option : Global EI InvInfo1 [!Line : Global EI InvInfo1] add : fields:before: VCH StockItem : vchslno1 [field : vchslno1] Set as : $$Line Align : Centre Width : 3 Skip : Yes

In this lesson,  the teacher is helping learners to :- understand Grammar topic is there / are there / how many by the Monkey song Teaching Rules / Tricks:- Golden Rule of Teaching First, you should Enjoy your teaching!! If you don't feel good in your own class, Never expect from your learners. I always enjoy my all classes and it helps me to build up my teaching level up. Try some teaching activities from our videos and see the outstanding results in your classroom.  Involve yourself deeply in your teaching activity and you will see your learners are more interested than you. Try some of these activities :- https://youtube.com/playlist?list=PL3OwfzHiGFsBdw-C-J2irRc5HjT3BScBn Watch the song and try to write the song lines in the comment box below

  Few lines of the code is missing. pls watch the video for full coding. [#Menu: Gateway of Tally] Add : Key Item : Search Vouchers: H : Alter : RajivSVch [Report:RajivSVch] Form : FrmFindVoucher Title : $$LocaleString:"Search Vouchers" [Form: FrmFindVoucher] Part : PrtFindVoucher     Full Width  : No     Space Right : 2     Space Left  : 2     Option      : Small Size Form     Background  : Light Yellow   On: Form Accept : Yes : Form Accept On: Form Accept : Yes : Display : RajivSVch Entries in Daybook [Part: PrtFindVoucher] Line :LinImpReceiptV,LinImpReceiptV1,LinImpReceiptV2 [Line: LinImpReceiptV] Fields : Long Prompt, Name Field;, vaibhfield Local: Field: Long Prompt : Set As : "Type Narration or Voucher No. here" Local: Field: Name Field : Modifies : xlsFilePath : Yes [Line: LinImpReceiptV1] Fields : custslipfld [field : custslipfld...

  Few lines are missing here. Pls watch the full video for those lines. [Field : TotSales] Invisible   : NOT ##CurBalanceFlag      Field       : Simple Prompt, Amount Field     Local       : Field : Simple Prompt : Info    : $$LocaleString:"Today's Total Sales:" Local     : Field : Simple Prompt : Width   : 14     Local       : Field : Amount Field  : Set as  : @@TrsTotSales     Local       : Field : Amount Field  : Format  : "Symbol,DrCr" Local       : Field : Amount Field : Set always : Yes Local       : Field : Amount Field : Color : Black [System : Formula]     TrsTotSales     : $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales     ;$$ToValue:$Date:$CreditTotals:Group:$$GroupSales...

  Few lines are missing here. Pls Watch the video for full code. Add : Line : At End :Use Default Godown,Default Godown Name [Line :Use Default Godown] Space Bottom   : 0.2 Field : Medium Prompt,Use Default Godown         Local : Field : Medium Prompt : Set As : If ($$IsSales:$Parent Or $$IsPurchase:$Parent) Then "Use Default Godown" else "" Local : Field : Medium Prompt :Invisible   : NOT $$IsMultiGodownOn ;;---Add here Local : Field : Medium Prompt : Color : Blue Local : Field : Medium Prompt : Border : Subtotals [Field : Use Default Godown] Use : Logical Field Storage   : UseDefaultGodown Inactive : NOT ($$IsSales:$Parent Or $$IsPurchase:$Parent) Invisible       : NOT $$IsMultiGodownOn [Line :Default Godown Name] Field : Medium Prompt,Default Godown Name         Local : Field : Medium Prompt : Set As : "Default Godown Name" Local : Field...

 Few lines of the code is missing here. Pls watch the full video for complete vode [Line: CMP EnableSalesmanTable] Field: Medium Prompt, CMP EnableSalesmanTable Local: Field: Medium Prompt: Info: "Enable Salesman ? " ;;Invisible: NOT $$MODAdvInventory or NOT $IsInvoicingOn Space Top: 1 [Field: CMP EnableSalesmanTable] Use: Logical Field Storage: EnableSalesman Set as: If $$IsEmpty:$$Value then "No" else $$Value Sub Form: SmReport: $$Value = "Yes" [#Menu: Gateway Of Tally] Add : Item : Sales Person Report : Menu : Salesman Menu [Menu: Salesman Menu] Add : Item : Sales Person Name : Alter : Salesman Name Add : Item : Blank Add : Item : Salesman Sales Report : Display : SmReport Add : Item : Blank [Report: Salesman Name] Form : Salesman Name Object : Company [Form: Salesman Name] Part : FormSubTitle, Saleman ;Button : Delete All, Remove Line, Restore Line, Restore All,Report Operations FullWidth : No Height : 90% Screen Background : Light Yellow SpaceRight : ...