Tally TDL Coding Expert with Rajiv Mishra

 [#Form: Master Accounting Form] Delete: Bottom Buttons : Master Group, Master Ledger, Master VchType, Blank Button ;, Master Company Operations, Master Configure Delete: Option : CstCat Buttons : $$IsCostCategoryOn Delete: Option : CstCtr Buttons : $$IsCostCentresOn Delete: Option : Employee Buttons : ($$AddOnInfo:payrollEnabled) AND $$IsPayrollOn Delete: Option : Budget Buttons : $$IsBudgetsOn Delete: Option : Currency Buttons : $$IsMultiCurrencyOn [#Form: Master Inventory Form] Delete: Bottom Buttons : Master Stock Group, Master Stock Item, Master Units, Master VchType, Blank Button ;, Master Company Operations, Master Configure Delete: Option : StockCat Buttons : $$IsStockCategoryOn Delete: Option : Godown Buttons : $$IsMultiGodownOn [#Form: Multi Master Accounting Form] Delete: Bottom Buttons : Multi Master Group, Multi Master Ledger, Blank Button ;, Master Company Operations Delete: Option : Multi CstCat Buttons : $$IsCostCategoryOn Delete: Option : Multi CstCtr Buttons : $$I...

  [#Field:EI COnsignee] Delete:Table Add:Table:MyLedgerColl [Collection:MyLedgerColl] Use : Alias Collection Title : $$LocaleString:"List of Ledger" Type : Ledger Fetch : Name Report : Ledger Variable : LLedger Trigger : LLedger IsODBCTable : Yes Add : SubTitle : $$LocaleString:"Ledger Name","Parent Group" Add :Format :$Parent Fetch:parent

  [#Line: BILLCol1] Add: Option: RAJIVT1: Yes [!Line: RAJIVT1] Add : Right Field : F00xBillCost Local: Field: F00xBillCost : Set as:"Cost" [#Line: BILLCol2] Add: Option: RAJIVT2: Yes [!Line: RAJIVT2] Add : Right Field : F00xBillCost Local: Field: F00xBillCost : Set as:"Center" [#Line: BILL Detail] Add: Option: RAJIV: Yes [!Line: RAJIV] Add :Right Field: F00xBillCost [Field: F00xBillCost] Use: Name Field Width: 10 Skip: YES Align: Center Color: red Set as: if $$IsEmpty:$ObjCostNameI Then $ObjCostNameL Else $ObjCostNameI Border: Thin Left Style: Normal [Function: Func_GetCostCenterName] Parameter: pMasterID : String Parameter: pIsItemWise : Logical Fetch Object: Voucher : ##pMasterID : COSTCENTRENAME;LedgerEntries, Category Allocations Variable: vCCName : String : "Empty" Return: String 001 : SET OBJECT : (Voucher , ##pMasterID). 002 : If: ##pIsItemWise 010 : WALK COLLECTION : LedgerEntries 020 : Walk Collection : InventoryEntries 030 : Walk Collection : Acc...

  Useful Keys of this TDL CODE: place your cursor on the name of stock item and press F4 - to see Sales history, F5 to see Purchase history, F6 - to see both the sales & purchase history ALT + E - to export sales & Purchase history in EXCEL, MS WORD, PDF, HTML etc ;;===========Rajiv Mishra Code starts here================ [Collection : ClnSaleInfo]     Type     : Vouchers : Stock Item     Child Of : $$BaseOwner:#VchStockItem     Filter   : SalesFilter     Sort     : @@Default : -$Date     Fetch    : LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName [System : Formula]     MStk           : $StockItemName = $$BaseOwner:#VCHStockItem     SalesFilter    : $$IsSales:$VoucherTypeName     PurchaseFilter : $$IsPurchase:$VoucherTypeName ;   SalesPurFilter : $$IsPurchase:$VoucherTypeName or $$IsSales:$...

  Watch the full video to understand this code better [#menu: gateway of tally] Title : "Rajiv Mishra" item : My Documents  : Menu : List of Documents  [Menu : List of Documents] item : ITR Copy : Menu : ITR Copy item : "" : Menu : "" item : Registration Certificates : Menu : Registration Certificates item : "" : Menu : "" item : Selected Websites : Menu : My Websites item : "" : Menu : "" item : Selected Softwares : Menu : My Softwares [Menu: ITR Copy] Item : 2021-22 : Browse : "" Item : 2020-21 : Browse : "" Item : 2019-20 : Browse : "" [Menu: Registration Certificates] Item :  Memo : Browse : "" Item :  "" : Browse : "" Item :  PAN : Browse : "" Item :  GST : Browse : "" Item :  TAN : Browse : "" [Menu: My Webs...

  Watch the full video to learn more about TDL. [#Line:DSP VchDetail] Border:Thin Bottom [#Line: BSDetail] Border:Thin Bottom [#Line: PLDetail] Border:Thin Bottom [#Line:CI InvInfo] Border:Thin Bottom [#Line:DSP Accline] Border:Thin Bottom [#Line:EI InvInfo] Border:Thin Bottom [#Field: DSP ClDrAmt] Border:Thin Left [#Field: DSP ClCrAmt] Border:Thin Left [#Field: DSP vchDate] Border:Thin Left Right [#Field: DSP vchnumber] Border:Thin Left Right [#Field: DSP vchDrAmt] Border:Thin Left Right [#Field: DSP vchCrAmt] Border:Thin Right [#Field: DSPDBDrAmt] Border:Thin Left Right [#Field: DSPDBCrAmt] Border:Thin Right

  Wathc the full video to get full coding. [#Line: EI Baseinfo] Lines : EI Consignee, EI Trader NatureofPurc, EI PartyLimit Add:Line:After: EI Consignee:My Line [Line:My Line] Field:Medium Prompt,My Field1 Local:Field:Medium Prompt:Set as:"Tracking No" Local:Field:Medium Prompt:Color:blue Local:Field:Medium Prompt:Background:Yellow Local:Field:Medium Prompt:border:Thick box [Field:My Field1] ;; Use:Name Field ;; Set as    :    $$String:@@LTrkNo Storage:TrkNo Set Always:Yes [System:UDF] TrkNo:String:3000         [system    :    formulae]     LTrkNo                    :    $$CollectionField:$TrkNo:1:TrkVouchers     [Collection    :    TrkVouchers]             Type                     :     Vouchers : VoucherType     ...

  Watch the full video to get full coding [Form:TallyPrimeParty]     Use        : DSP Template     Parts        :PQWSTitle,PQWSPeriod,TallyPrimeParty     Button    : ExplodeFlag,ChangePeriod     Bottom Toolbar Buttons    : EnterToEdit,BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10     Option        : Set Auto Vch Option     : ##DoSetAutoColumn AND $$SetAutoColumns:StockItemNameRepeat       Set Always : SV Print Orientation : "Landscape" Width        : 100% Page     Space Left    : 2 mms      Space Right    : 2 mms [Key: EnterToEdit]     Key         : Enter     Title       : $$LocaleString:"Explode"     Type        : BottomToolBarBtn2       ...

  Few lines are missing here. Watch the full video to get full coding. [#Form: Balance Sheet]    Add :  Part : At end : PrintAuditerDetials [Part : PrintAuditerDetials]    Line  :PrintAuditerDetials1,PrintAuditerDetials2,PrintAuditerDetials3,PrintAuditerDetials4  Local : Field : Default : Width : 30    [Line : PrintAuditerDetials1]     Field :PrintAuditerDetials1      [Field :PrintAuditerDetials1]        Set As : "Prepared By :"  [Line :PrintAuditerDetials2]      Field :PrintAuditerDetials2   Border : Thin top   Local : Field : Default : Style : Small Bold      [Field :PrintAuditerDetials2]        Set As : "Shree Krisjna Associates, CA MR. RAJIV "  [Line :PrintAuditerDetials3]       Field :PrintAuditerDetials3      [Field :PrintAuditerDetials3]        Set As : "Regd...

  Few lines are missing here. Pls watch the full video to get full coding. [Collection : ClnSaleInfo] Type : Vouchers : Stock Item Child Of : $$BaseOwner:#VchStockItem Filter : SalesFilter Fetch : LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName [System : Formula] MStk : $StockItemName = $$BaseOwner:#VCHStockItem SalesFilter : $$IsSales:$VoucherTypeName PurchaseFilter : $$IsPurchase:$VoucherTypeName [Collection: Rama] Use : Vouchers of Ledger ; Child of : #LedgerName [#Field : Vch batch Rate] Key : SalesHistory Key : PurchaseHistory Tooltip : "Press Alt + F9 for Purchase History & Alt + F8 for Sales History" [Key : SalesHistory] Key :  Action : Display : RptSalesHistory [Report : RptSalesHistory] Form : FrmSalesHistory [Form : FrmSalesHistory] Part : PrtSalesHistory Height : if $$InPrintMode then 8.20 else 100% Screen Width : if $$InPrintMode then 5.70 else 50% Screen Horizontal Align: Right Buttons: PrintButton, ExportButton [Part : PrtSalesHistory] Line : LnSales...

  Few lines are missing here. Pls watch the full video to get full coding [#Menu: Gateway of Tally] Add: Key Item : Update UDF : U : Alter Collection : C067Main : NOT $$IsEmpty:$$SelectedCmps [Collection: C067Main] <unitgroup:multiled> Use : Multi Ledger Delete : Report Add : Report: R067Main [Report: R067Main] <unitgroup:multiled> Use : Multi Master Report Family : $$Translate:"Accounts Masters" Title : $$SPrintf:mad:@MultiLedgerCreateModeFormat:mad:@ModeName:mad:@SubModeName Variables : MGroup Set : SVAccounts : Yes Set : SVInventory : No Set : SVStatutory : No Set : SVTallyShop : No Multi Objects : Ledger Under MGroup Delete: Form Add: Form: A067Main Variable: v067ClearPAN : Logical: No [Color : Tomato] RGB:115, 215, 0 [Form: A067Main] Use : Multi Master Form Normal Color : Tomato Parts : P067MLEDBody ;, MLED Body,MLEDDefault, Space Bottom : 0 [Part : P067MLEDBody] Lines : L067MLEDTitle,L067MLEDBody Scrolled: Vertical Repeat : L067MLEDBody : LedgerUnderMGroup B...

  Few lines are Missing Here. Pls Watch the full video to get full code [System: Formula]     SV_COLOR                    : @@SV_RELEASEDBLACK     SV_BACKGROUND      : Leaf Green SV_CALC_BACKGROUND          : If $$InTrueColorMode then "White, CalcBGClr"  else "White, White" ;;Calc Pane Color     SV_INACTIVE_BACKGROUND      : If $$InTrueColorMode then "White, InactiveBGClr"  else "White, White"     SV_INACTIVE_COLOR           : @@SV_RELEASEDLIGHTGREY     SV_PRINTCOLOR               : @@SV_RELEASEDBLACK     SV_PRINTBG                  : @@SV_RELEASEDWHITE     SV_CMPCONFIG            : @@SV_RELEASEDLIGHTGREY     SV_LOGO_BG      ...