TALLY TDL – ITEM ANALYSIS

by with One Comment TallyTDL 2019TDL 2020TDL for Tally
If you are a businessman or accountants or CA and use Tally ERP 9 Accounting software, then you are in right place. I have something special for you. I have Tally TDL for you to do all your work smoothly and time. TDL files play an important role in Tally software.
With this Tally ERP9 TDL you can track Stock Item Details and analyse it’s details like group, opening , closing , last sale and purchase amount with there dates. This Tally TDL will be very helpful to control your business and its profits.
[Button : Item Analysis]
Key : Ctrl+9
Title : “Item Analysis”
Action : Display Collection : Stock Items 
[#Menu        :    Main Menu]
 Add          :    Top Button    :    At Beginning     :     Item Analysis
[#Menu        :    default]
 Add          :    Top Button    :    At Beginning     :     Item Analysis
[#form       :    default]
 Add          :    Top Button    :    At Beginning     :     Item Analysis
[#form       :    voucher]
 Add          :    Top Button    :    At Beginning     :     Item Analysis

[Collection:Stock Items]
Title:”LearnWell Items”
Type:Stock Item
Trigger:LWPriceList
Variable:SVStock Item List
Report:StockItemDetails
Format:$Name,20
Format:$Parent,15
Format:$OpeningBalance,12
Format:$ClosingBalance,12
Format:$LastSalePrice,12
Format:$LastSaleDate,12
Format:$LastPurcPrice,12
Format:$LastPurcDate,12
Sub Title:”Name”,”Group”,”Opening”,”Closing”,”Last Sale Price”,”Last Sale Date”,”Last Purc Price”,”Last Purc Date”
[Report:LWPriceList]
Title:Stock Item-Learnwells.com
Form:LWPriceList
[Form:LWPriceList]
Part:LWPriceList
Vertical Align:Top
Horizontal Align:Center
[Part:LWPriceList]
Line:TLWPriceList,LWPriceList
[Line:TLWPriceList]
Field:TLWPriceList
Space Bottom:1
[Field:TLWPriceList]
Info:”Stcok Item Name”
Align:Center
Width:50
Style:Normal bold
Border:Thin bottom
[Line:LWPriceList]
Field:LWPriceList
[Field:LWPriceList]
Table:Stock items
Show Table:Always
Modifies:SVStock Item List
Width:50
Max:251
[Report:StockItemDetails]
Title:”LearnWell:” + ##SVStockItemList
Form:StockItemDetails
Object:Stock Item :##SVStockItemList
[Form:StockItemDetails]
Part:StockItemDetails
[Part:StockItemDetails]
Line:StockItemDetails
[Line:StockItemDetails]
Field:StockItemDetails
[Field:StockItemDetails]
Set as:”www.Learnwells.com”
Style:bold
Color:red

[Variable:SVStock Item List]
Type:String
[System:Variable]
SVStock Item List:””

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.



Tags # TDL 2020 # TDL for Tally

     

Business Control – Tally TDL

by with No Comment TDL 2019TDL 2020TDL for Tally
TDL (Tally Definition Language) are nerves system of Tally. With TDL files we can modify tally asper our requirement. In this segment I have something very special for you. 

With this Tally ERP9 TDL you can control your business by adding selling and purchase price amount in stock item and prevent billings beyond this..
Also can see last purchase and last selling price at voucher entry time.

[#Part: STKI Batch]
    Add:Line:At End:LWminprice,LWmaxprice
[Line:LWminprice]
    Space Top:0.1
    Field:Medium Prompt,LWminprice
    Local:Field:Medium Prompt:Set as:”Min Purc Price”
[Field:LWminprice]
    Use:Rate Price Field
    Set Always:Yes
    Width:10
    Storage:iteminsaleprice
[Line:LWmaxprice]
    Space Top:0.1
    Field:Medium Prompt,LWmaxprice
    Local:Field:Medium Prompt:Set as:”Max Sell Price”
[Field:LWmaxprice]
    Use:Rate Price Field
    Set Always:Yes
    Width:10
    Storage:itemaxsaleprice
[System:UDF]
    itemaxsaleprice:Rate:5628
    iteminsaleprice:Rate:6523
[#Field:VCHBATCH rate]
    Control:ValidityofPrice:if  ($$Value < $iteminsaleprice:Stockitem:$StockItemName or $$Value > $itemaxsaleprice:StockItem:$StockItemName)then Yes else No
[#Field: VCH rate]
    Control:ValidityofPrice:if  ($$Value < $iteminsaleprice:Stockitem:$StockItemName  or $$Value > $itemaxsaleprice:StockItem:$StockItemName) then Yes else No
[System:Formulae]
    ValidityofPrice:”Please enter rate between minimum and maximum  price as mentioned in stock item”

[*Collection: Vch Stock Item Extract]

Use : ExtractAlias Collection
Source Collection : Stock Item Src
Collection : StockItem PartNo With Closing
Title        : $$LocaleString:”List of Items                                     Stock Qty     LastSale Price  LastPurc Price”
Fetch        : Name, VchStkItmBalance,LastSalePrice,LastPurcPrice 
Set as : $FirstName
Keep Source : ().
Client Only : Yes
Format  : $VchStkItmBalance   : “Base”
Format  : $LastSalePrice: “Base”
Format  : $LastPurcPrice: “Base”
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.



Tags # TDL 2020 # TDL for Tally

     

EXCEL TO TALLY – E commerce

by with No Comment Excel to TallyExcel2TallyXML
THIS EXCEL2TALLY-Eco  SOFTWARE (E-COMMERCE SPECIALIAST) HELP YOU TO EXPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY LIKE TALLY 7.2, TALLY ERP 9, TALLY ERP, OR GST READY TALLY .. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME WITH MULTI COMPUTER.

NOW YOU CAN GENERATE XML FOR TALLY OF YOUR E COMMERCE EXCEL DATA (FLIPKART, AMAZON,SHOPCLUES,MEESHO ETC) AND ALOS FOR OTHER EXCEL SHEET DATA WITHIN A SECOND WITH BELOW DETAILS:

LEDGER MASTER – WITH GST NUMBER, FULL ADDRESS, FULL CONTACT DETAILS, OPENING BALANCE, SET CREDIT LIMITS, SET INTEREST, AND WITH BILL WISE OPENING DETAILS, INTEREST CALCULATION, AND CONTACT DETAILS.

STOCK MASTER – WITH HSN CODE, ALIAS, OPENING, MRP RATES, STANDARD RATES, BATCH DETAILS.


M.i.i VOUCHER : – WITH THIS MULTIPLE INVOICE, MULTIPLE INVENTORY, MULTIPLE VOUCER, MULTIPLE TAX RATES  VOUCHER SHEET YOU CAN GENERATE ENTRIES WITH SIMPLE FORMAT. DIRECT COPY PASTE FROM YOUR DATA. CONSIGNEE, BUYERS DETAILS. WITH SINGLE BILL WISE REFERENCE. WITH MULTIPLE STOCK UNIT VOUCERS, SUITABLE FOR SALES, PURCHASE VOUCHERS AND CREDIT NOTE , DEBIT NOTES, VOUCHERS WITH YOUR OWN CREATED VOUCHER AS PER GST NORMS WITH  MULTIPLE STOCK ITEMS, DETAILS INCLUDING GODOWN, BATCHES FOR EVERY STOCK ITEMS IN SAME SHEET.

SETTELMENT VCH- WITH THIS SHEET YOU CAN IMPORT YOUR SETTELEMENT TYPE VOUCHERS (RECEIPT, PAYMENT, JOURNAL, ETC) WHO HAS MULTI LEDGERS IN EVERY VOUCHERS. THIS SHEET IS MOST FAVOURABLE FOR AMAZON, FLIPKART TYPE E COMMERCE PAYMENT SETTELMENTS WITH SINGLE AND MULTI BILLWISE REFERENCES
ALL IN ONE VOUCHER SHEET – WITH THIS SHEET YOU CAN IMPORT YOUR ALL VOUCHERS – SALES, PURCHASE, RECEIPT, PAYMENT, CONTRA, JOURNAL ETC WITH MULTIPLE BILL WISE REFERENCE AT A TIME.

YOU CAN USE IT FOR LIFETIME, NO RENEWAL REQUIRED

YOU CAN USE IT IN MULTIPLE COMPUTERS.


MO.NO.- 9131810293
EMAIL :- LEARNWELLS@OUTLOOK.COM

CLICK DOWNLOAD BUTTON TO DOWNLOAD

EXCEL 2 TALLY – REGULAR

by with No Comment Excel to TallyExcel VBAExcel2TallyXMLPAID UTILITY

THIS EXCEL2TALLY-REGULAR SOFTWARE HELP YOU TO EXPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY LIKE TALLY 7.2, TALLY ERP 9, TALLY ERP, OR GST READY TALLY .. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME WITH MULTI COMPUTER.
NOW YOU CAN GENERATE XML FOR TALLY OF YOUR EXCEL SHEET DATA WITHIN A SECOND WITH BELOW DETAILS:
LEDGER MASTER  – WITH GST NUMBER, FULL ADDRESS, FULL CONTACT DETAILS, OPENING BALANCE, SET CREDIT LIMITS, SET INTEREST,  AND WITH BILL WISE OPENING DETAILS.
STOCK MASTER – WITH HSN CODE, ALIAS, OPENING, MRP RATES, STANDARD RATES, BATCH DETAILS.
A.S-I VOUCHER : – WITH THIS VOUCHER SHEET YOU CAN GENERATE ENTRIES WITH SIMPLE FORMAT. DIRECT COPY PASTE FROM YOUR DATA. CONSIGNEE DETAILS, BUYERS DETAILS. , DISPATCH DETAILS, WITH SINGLE BILL WISE REFERENCE. WITH TAX CLASSIFICATION DETAILS. SUITABLE FOR ADVANCE SALES , PURCHASE VOUCHERS AND CREDIT NOTE , DEBIT NOTES, RECEIPT NOTE, DELIVERY NOTES, SALES ORDER, PURCHASE ORDER VOUCHERS AS PER GST NORMS WITH STOCK ITEM DETAILS INCLUDING GODOWN, MULTIPLE BATCHES FOR EVERY STOCK ITEMS, WITH ITEM DESCRIPTION AND WITH ORDER TRACKING SYSTEM FOR EVERY STOCK ITEM. ALSO CAN USE FOR PHYSICAL STOCK VOUCHERS.
ALL IN ONE VOUCHER SHEET – WITH THIS SHEET YOU CAN IMPORT YOUR ALL VOUCHERS – SALES, PURCHASE, RECEIPT, PAYMENT, CONTRA, JOURNAL ETC WITH MULTIPLE BILL WISE REFERENCE AT A TIME.
.
A.A.-VC H– WITH THIS SHEET YOU CAN IMPORT SALES, PURCHASE, DEBIT NOTE, CREDIT NOTE ETC ENTRIES WITH BILL WISE DETAIL AND WITHOUT INVENTORY WITH SIMPLE FORMAT.
M-TH VOUCHER : – WITH THIS VOUCHER SHEET CAN GENERATE MULTI VOUCHER TYPE WITH THOUSANDS OF LEDGER IN ONE VOUCHER. (FOR EXAMPLE IF YOU GO TO TAKE ENTRIES FOR JOURNAL, SALES, PURCHASE, RECEIPT, CONTRA, PAYMENT, DR. NOTE, CR. NOTE ETC AT A TIME AND YOUR ONE VOUCHER HAS MANY LEDGERS LIKE HUNDRED OR THOUSANDS LEDGERS IN ONE VOUCHER, YOU CAN USE THIS SHEET).
YOU CAN USE IT FOR LIFETIME, NOW RENEWAL REQUIRED
YOU CAN USE IT IN MULTIPLE COMPUTERS.
MO.NO.- 9131810293
EMAIL :- LEARNWELLS@OUTLOOK.COM

FORMAT DOWNLOAD DIRECT LINK : DOWNLOAD FORMAT

DOWNLOAD FULL VERSION CLICK BELOW DOWNLOAD BUTTON :


TRACK GSTIN

by with One Comment TDL 2020TDL for Tally

TDL (Tally Definition Language) are very useful for Tally Accounting Software. Today I have something special for your tally software.
This is GSTIN Tracker. Now you can Search Party GST No. with one click.
Just select party name and find GST number of Customer.

The TDL Code is as under :

[#Menu: Gateway OF Tally]
Add:ToolBar Buttons:Trackgstin

[button: Trackgstin]
Key: Ctrl + G
Action: alter : Trackgstin

[Report: Trackgstin]
Form: Trackgstin

[Form: Trackgstin]
No Confirm: yes
Part: Trackgstin
Option: Small size form size form

[Part: Trackgstin]
Line: Trackgstin

[Line: Trackgstin]
Field: Ledgersselect,Short Name field
Local: Field:Short Name field: Set as: $PartyGSTIN:ledger:#Ledgersselect

[Field: Ledgersselect]
Use: Short Name field
Table: Ledger
Show Table: Always

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.



LEDGER CLOSING TDL

by with No Comment TDL 2019TDL 2020TDL for Tally

TDLs are very useful if you use Tally accounting software. With TDL (Tally Definition Language) files we can modified Tally software and it’s reporting according to our needs. So today I have something special for you.

Sometime when we take ledger print or mail to our debtors or creditors for outstanding collection or payments, we need to fill closing balance in word form also. So this Tally TDL file will help you to add party closing balances in words.

The code is as under : 


[System: Formulae]
IfAmtthenOnlystring : If @@VchClg = 0 Then “” Else $$String:” Only”

[#Line: DSP VchClAmt]
Add : Left Field : ClBalinWord
Local : Field : Default: Style: normal bold
Local : Field : Default: Background: lily white
Local : Field : Default: Color: Blue 
Border: Thin Top Bottom:($$LineNumber = $$LastLineNumber ) AND $$InPrintMode


[#Line: LV FCthree]
Add : Left Field:ClBalinWord1
Local : Field : Default: Style: normal bold
Local : Field : Default: Background: lily white
Local : Field : Default: Color: Blue 
Border: Thin Top Bottom:($$LineNumber = $$LastLineNumber ) AND $$InPrintMode

[Field: ClBalinWord]
Set as: $$InWords:@@VchClg + @@IfAmtthenOnlystring
Color: Blue
Style: Large Bold 

;;www.learnwells.com

[Field: ClBalinWord1]
Set as:$$InWords:@@BalanceVchDrCrAmt + ” Only “
Color: Blue
Style: Large Bold
Print FG:Red
Indent:10
Width:50% Screen
Lines:0



FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.



ITEM AND LEDGER SUMMARY

by with One Comment TDL 2019TDL 2020TDL for Tally

WITH THIS TALLY TDL FILE YOU CAN SEE ITEM WISE SALE SUMMARY AND PARTIES VOUCHER WISE TRANSACTION REPORTS. IT WILL BE VERY USEFUL FOR OUTSTANDING COLLECTION AND FOR STOCK SUMMARY.

[#Menu: Display Menu] Add: Item: Unique Sale Summary : Menu: Unique Sale Summary [Menu: Unique Sale Summary] Key Item: ITEM WISE : T : Display : ProductwiseRpt Item : Blank Key Item: LEDGER SUMMARY : S : Display Collection: TransVchLedgerColl Item : Blank [Report: LWLL] Use : DSP Template Form : LWLL Variable : DoSetAutoColumn, PName Repeat : PName Set : DoSetAutoColumn : Yes Set : DSPRepeatCollection : “LEARN Party” Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate [Form: LWLL] Use : DSP Template Parts : LWLL Background : White, Light Orange Option : Set Auto Vch Option : ##DoSetAutoColumn AND $$SetAutoColumns:PName [!Form: Set Auto Vch Option] [Part: LWLL] Lines : LWLL Title, LWLL Details BottomLines : LWLL Total Repeat : LWLL Details : Smp Stock Item Scroll : Vertical CommonBorder: Yes Total : LWLL Party, LWLL Col Total [Line: LWLL Title] Use : LWLL Details Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : LWLL Name : Set as : “Particulars” Local : Field : LWLL Name : Widespaced: Yes Local : Field : LWLL Party : Set as : ##PName Local : Field : LWLL Party : Lines : 0 Local : Field : LWLL ColTotal : Set as : “Total” Border : Flush Totals [Line: LWLL Details] Fields : LWLL Name, LWLL Party, LWLL Col Total Repeat : LWLL Party Total : LWLL Party [Field: LWLL Name] Use : Name Field Set as : $IName Display : Stock Vouchers Variable : Stock Item Name [Field: LWLL Party] Use : Qty Primary Field Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQty:@MyFormula:LEARNSummVoucher MyFormula : ##PName + #LEARNRepName Format : “NoZero” Border : Thin Left [Field: LWLL Col Total] Use : Qty Primary Field Set as : $$Total:LEARNRepParty Border : Thin Left [Line: LWLL Total] Fields : LWLL Name, LWLL Party, LWLL Col Total Repeat : LWLL Party Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : LWLL Name : Set as : “Total” Local : Field : LWLL Name : Widespaced: Yes Local : Field : LWLL Party : Set as : $$Total:LEARNRepParty Local : Field : LWLL ColTotal : Set as : $$Total:LEARNRepColTotal Border : Thin Top [Collection: LEARN Voucher] Type : Voucher Filter : IsSalesVT [Collection: LEARN Summ Voucher] Source Collection : LEARN Voucher Walk : Inventory Entries By : PName : $PartyLedgerName By : IName : $StockItemName Aggr Compute : BilledQty : SUM : $BilledQty Search Key : $PName + $IName [Collection: Smp Stock Item] Source Collection : LEARN Voucher Walk : Inventory Entries By : IName : $StockItemName Aggr Compute : BilledQty : SUM : $BilledQty Filter : NonEmptyQty [Collection: LEARN Party] Source Collection : LEARN Voucher Walk : Inventory Entries By : PName : $PartyLedgerName Aggr Compute : BilledQty : SUM : $BilledQty Filter : NonEmptyQty [Variable: PName] Type : String Repeat : ##DSPRepeatCollection [System: Formula] IsSalesVT : $$IsSales:$VoucherTypeName NonEmptyQty : NOT $$IsEmpty:$BilledQty [Report: ProductwiseRpt] Use : DSP Template Form : ProductwiseRpt Title : “Product-wise Sales Summary Report” [Form: ProductwiseRpt] Use : DSP Template Parts : ProductwiseRptHdr, ProductwiseRpt Height : 100% Screen Width : 100% Screen Delete : Buttons : ExplodeFlag Delete : Bottom Buttons : DSPAutoColumns, BudgetAnalysis, ReportConfig [Part: ProductwiseRptHdr] Lines : ProductwiseRptHeader [Line: ProductwiseRptHeader] Field : Name Field Right Field : DSP MainDateTitle Local : Field : Name Field : Set as : $$LocaleString:”Inventory Details” Local : Field : Name Field : Style : Normal Bold Space Bottom: 1 [Part: ProductwiseRpt] Lines : ProductwiseRptTitle, ProductwiseRptInfo Repeat : ProductwiseRptInfo : SummaryColl Scrolled : Vertical Common Borders : Yes Border : Thin Bottom Float : No [Line: ProductwiseRptTitle] Use : ProductwiseRptInfo Local : Field : Default : Type : String Local : Field : Default : Lines : 0 Local : Field : Default : Style : Normal Bold Local : Field : ProductTotalAmt : Align : Centre Local : Field : ProductMaxRate : Align : Centre Local : Field : ProductMinRate : Align : Centre Local : Field : ProductName : Set as : “Particulars” Local : Field : ProductTotalAmt : Set as : “Total Quantity” Local : Field : ProductMaxRate : Set as : “Maximum Rate” Local : Field : ProductMinRate : Set as : “Minimum Rate” Border : Thin Column Titles [Line: ProductwiseRptInfo] Fields : ProductName Right Fields : ProductTotalAmt, ProductMaxRate,ProductMinRate Local : Field : Default : Style : Normal [Field: ProductName] Use : Name Field Set as : $StockItemName Display : Stock Vouchers Variable : Stock Item Name [Field: ProductTotalAmt] Use : Qty Primary Field Set as : $StkTotalQty Border : Thin Left Right Width : 10 [Field: ProductMaxRate] Use : Rate Field Set as : $StkMaxRate Border : Thin Right Width : 10 [Field: ProductMinRate] Use : Rate Field Set as : $StkMinRate Border : Thin Right Width : 10 [Collection: SalesVouchersColl] Type : Voucher Filter : OnlySalesCreditNote [Collection: SummaryColl] Source Collection : SalesVouchersColl Walk : Inventory Entries By : StockItemName : $StockItemName Aggr Compute : StkTotalQty : Sum : $BilledQty Aggr Compute : StkMinRate : Min : $Rate Aggr Compute : StkMaxRate : Max : $Rate Keep Source : No Sort : Default : $StockItemName [System: Formula] OnlySalesCreditNote : $$IsSales:$VoucherTypeName OR $$IsCreditNote:$VoucherTypeName [Collection: TransVchLedgerColl] Use : Ledger Report : Transact Report Trigger : Ledger Name Variable : Ledger Name [Report: Transact Report] Use : DSP Template Form : TransVchReport Variable : Ledger Name [Form: TransVchReport] Use : DSP Template Part : LV Title, TransVchTitle, TransVchBody Width : 100% Screen Height : 100% Screen Delete : Buttons : ExplodeFlag Delete : Bottom Buttons : DSPAutoColumns, BudgetAnalysis, ReportConfig Local: Line : LV Title : Local : Field : LV Title : Local : Field: Simple Prompt : Info : $$LocaleString:”Ledger” Local: Line : LV Title : Local : Field : LV Title : Local : Field: Name Field : Set as : #LedgerName [Part: TransVchTitle] Lines : TransVchTitle [Line: TransVchTitle] Use : TransVchLedDetail Local : Field : Default : Type : String Local : Field : Default : Align : Centre Local : Field : Default : Style : Normal Bold Local : Field : TransVchTypeName : Set as : “Voucher Type Name” Local : Field : TransVchDrAmt : Set as : “Debit Amt” Local : Field : TransVchCrAmt : Set as : “Credit Amt” Border : Thin Top Bottom [Part: TransVchBody] Lines : TransVchLedDetail Bottom Lines: TransVchLedTotal Repeat : TransVchLedDetail : TransVchSummaryColl Scroll : Vertical CommonBorder: Yes Total : TransVchDrAmt, TransVchCrAmt [Line: TransVchLedDetail] Fields : TransVchTypeName Right Fields : TransVchDrAmt, TransVchCrAmt Local : Field : Default : Style : Normal [Field: TransVchTypeName] Use : Name Field Set as : $TransVchName [Field: TransVchDrAmt] Use : Amount Forex Field Set as : $TransVchDrAmt Border : Thin Left Right [Field: TransVchCrAmt] Use : Amount Forex Field Set as : $TransVchCrAmt Border : Thin Right [Line: TransVchLedTotal] Use : TransVchLedDetail Local : Field : Default : Style : Normal Bold Local : Field : TransVchTypeName : Set as : “Total” Local : Field : TransVchDrAmt : Set as : $$Total:TransVchDrAmt Local : Field : TransVchCrAmt : Set as : $$Total:TransVchCrAmt Border : Thin Top Bottom [Collection: TransVchColl] Type : Voucher [Collection: TransVchSummaryColl] SourceCollection: TransVchColl Walk : Ledger Entries By : TransVchName : $VoucherTypeName By : TransVchLed : $LedgerName Aggr Compute : TransVchDrAmt : Sum : If $$IsDr:$Amount then $Amount else “” Aggr Compute : TransVchCrAmt : Sum : If NOT $$IsDr:$Amount then $Amount else “” Filter : TransVchFilter ;; Filtering done here to retrieve only values pertaining to the requested Party [System: Formula] TransVchFilter : #LedgerName = $TransVchLed TransVchOpBal : $OpeningBalance:Ledger:#LedgerName TransVchClBal : $ClosingBalance:Ledger:#LedgerName ;;WWW.LEARNWELLS.COM

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 

Now your TDL is ready to use.

Bank Daybook

Bank Daybook

by with 7 Comments TDL 2020TDL for Tally

Every business maintain bank, and if we do accounting in Tally Software we all need this TDL file.
TDL (Tally Definition Language) files used to modify Tally Software according to your uses. TDL files are very useful to simplify your work.

With this TDL you can see your bank daybook with narration and its cheque number.Also can edit at a time.It is very nice TDL file for Tally and must have tdl for tally.


[#Menu : Gateway of Tally] Add : Item : Bank Daybook : Display : BankDaybookd [Report:BankDaybookd] Use : DSP Template Set : SVfromDate :##SVfromDate Set : GroupName : ##GroupName Variable : IsMultiPage, InNewPages Set : IsMultiPage : yes Set : InNewPages : yes Set : SVToDate : ##SVCurrentdate Set : SVfromDate : $BooksFrom:Company-:##SVCurrentCompany Variable : BankName : string Set : BankName : “” [Form: BankDaybookd] Button : PrintButton, ExportButton, F2 ChangePeriod, SelectBank Parts :LWBnkDetails, BankLDetails Height : 100% screen Width : 100% screen Background : Light Surf Green [Button : SelectBank] Title : “Select Bank” Key : Alt + B Action : Alter : BankSelection [Report : BankSelection] Form :BankSelection ;Title : BankSelection” [Form : BankSelection] Parts : BankSelection Option : Small Size Form Full Width : No Space Left : 0.5 Space Right : 0.5 [Part : BankSelection] Lines : Form SubTitle, BankSelection Local : Field : Form SubTitle : Info : “Bank Selection” [Line : BankSelection] Fields : Long Prompt, BankSelection Local : Field : Long Prompt : Set as : $$String:”Bank Selection:” Local : Field : Default : width: 15 [Field : BankSelection] Use : Name field Table : BankAccounts, End of List Show Table : Always Sort : Yes Modifies : BankName :Yes Variable :BankName [Variable:BankName] Type : String Persistent : Yes [System:Variables] BankName:”” [Collection : BanknameColl] Type : Ledger Include : Group:$$GroupBank, Group:$$GroupBankOD Belongsto : yes Format : $BankName, 15 Fetch : Name Title : “List of Bank” FullHeight : No Filter: Filterbank [System: Formulae] Filterbank:$Ledgername = ##BankName or $$IsSysName:##BankName Filterbank:$IsBelongsTo:$$GroupBank OR $$IsBelongsTo:$$GroupBankOD [Part:LWBnkDetails] Line: LWBnkDetails Name, LWStts [Line:LWBnkDetails Name] Field: Form Sub Title Local : Field : Form Sub Title : Set as : @@CmpMailName Local : Field : Form Sub Title : Align : Center Local : Field : Form Sub Title : Fullwidth : yes Local : Field : Form Sub Title : Color : Blue Local : Field : Form Sub Title : Border: Thin Bottom Local : Field : Form Sub Title : Style: Large Bold Italic Space Bottom:0.2 [Line : LWStts] Field:LWStts Space Bottom:0.2 [Field:LWStts] Use :Name field Set as : $$LocaleString:”Period ” + $$String:##SVFromDate + ” to ” + $$String:##SVToDate Align : Center Full Width : Yes Color :Black Style :Small bold Italic Background : Light Surf Green [Part: BankLDetails] Lines : BnkTts, BnkLns, Repeat : BnkLns : paymentColl CommonBorder: Yes Scroll : Vertical Border : Thin Bottom [Line : BnkTts] Use : BnkLns Local : Field : Default : Color : Black Local : Field : Default : Background : Light Grey Local : Field : Default : Type : String Local : Field : Default : Align : Centre Local : Field : Default : Line : 0 Local : Field : LWvchDt : Set as : “Vch Date” Local : Field : LWldNm : Set as : “Particulars” Local : Field : LWLptm : Set as : “Naration” Local : Field : LWChqno : Set as : “Cheque No.” Local : Field : LWDramt : Set as : “Withdrawl.” Local : Field : LWCramt : Set as : “Deposit” Border : column Titles [Line: BnkLns] Fields : LWvchDt, LWldNm, LWLptm, Right Fields : LWChqno ,LWDramt, LWCramt Option : AlterOnEnter [Field:LWvchDt] Use : Short Date Field Set as : $Date Format : Short Date, Separator:”-” Border : Thin Left Width : 8 Align : Right Alter : Voucher : $$IsVoucher [Field:LWldNm] Use : Name Field Set As : $AllLedgerEntries[1].LedgerName Border : Thin Left full width:Yes Align : left [Field :LWLptm] Use : Name Field Set as : $Narration Border : Thin Left Width : 30 Align : left [Field:LWChqno] Use : Name Field Set As : $AllLedgerEntries[-1].BankAllocations.InstrumentNumber Border : Thin Left Width :15 Align : Right [Field:LWDramt] Use : Amount Field Set as : If $$IsDr:$Amount then $Amount else “” Format : “Cr/Dr” Border : Thin Left Width :15 Align : Right [Field:LWCramt] Use : Amount Field Set as : If not $$IsDr:$Amount then $Amount else “” Format : “Cr/Dr” Border : Thin Left Width :15 Align : Right [Collection:paymentColl] Type : Vouchers : Ledger Child Of:##BankName belongs to : Yes Fetch : Date, Vouchernumber, VoucherTypeName, Amount, MasterID, LedgerName, Parent,ParentFullLis, Narration, LWDramt, LWCramt Compute:DrAmt:If $$IsDr:$Amount then $Amount else “” Compute:CrAmt:If not $$IsDr:$Amount then $Amount else “” Filter:MYVCH Sort : Default : $Date, $LedgerName [System : Formula] MYVCH:$$IsPayment:$VoucherTypeName or $$IsReceipt:$VoucherTypeName or $$IsContra:$VoucherTypeName


FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.




TDL for Tally | REMINDER WITH PRAY

by with One Comment TDL 2019TDL 2020TDL for Tally

With this TDL file you can pray and set a work reminder, or due dates of Taxes

Very Nice TDL for Tally ERP 9 – Reminder with Pray.
You can Change Image Path in TDL file and Save.
You can Set Reminder Dates and Task in TDL file and Save.
[System : Event]
Prayerstart: system start : true : call : prayer
[FUNCTION : Prayer]
01 : DISPLAY : PrayerReport
[FUNCTION : prayerstopf]
01 : Form Reject to Menu:PrayerForm
[REPORT : PrayerReport]
FORM : PrayerForm
TITLE : “Prayer”
[FORM : PrayerForm]
part : PrayerPart
Part:Messagep
Key:pryerquit
[PART : PrayerPart]
Horizontal Alignment:Centre
Vertical:No
Graph Type : “C:UsersHPDesktoplaxmi_ganesh.jpg”
LINE : PrayerLine 
[LINE : PrayerLine]
Field:prayerfield
[Field:prayerfield]
Set as:””
Full Width:Yes
Key:pryerquit
[Key: pryerquit]
Key : Enter
Action : Form Reject
[PART : Messagep]
LINE : Messagel 
[LINE : Messagel]
Field:Messagef
[Field:Messagef]
Set as:”Press Enter”
Align:Center

[System : Event]
appstart: system start : true : call : Reminder
[FUNCTION : Reminder]
01 : DISPLAY : ReminderReport
[REPORT : ReminderReport]
FORM : ReminderForm
TITLE : “Reminder”
[FORM : ReminderForm]
part : ReminderPart
HEIGHT : 20% screen
WIDTH : 100% screen
Background:Jobimon
[PART : ReminderPart]
LINE : ReminderLine 
[LINE : ReminderLine]
FIELD : NAME FIELD
LOCAL : FIELD : NAME FIELD : INFO : if ($$DayOfDate:$$MachineDate< 6 ) then $$LocaleString:(6-($$DayOfDate:$$MachineDate)) + ” more days are to Reconcile Ledger…..”else if ($$DayOfDate:$$MachineDate< 7 ) then $$LocaleString:(7-($$DayOfDate:$$MachineDate)) + ” more days are to make TDS payment” + 
else if ($$DayOfDate:$$MachineDate< 10 ) then $$LocaleString:(10-($$DayOfDate:$$MachineDate)) + ” more days are to File GRTR1″else if ($$DayOfDate:$$MachineDate< 20 ) then $$LocaleString:(20-($$DayOfDate:$$MachineDate)) + ” more days are to File GSTR 3B” + 
else if (($$MonthOfDate:$$machineDate)=3) then $$LocaleString:(($$MonthEnd:$$machineDate)-$$machineDate) +”  days remaining from year end closing”else $$LocaleString:(($$MonthEnd:$$machineDate)-$$machineDate) +” days remaining from month end closing”
LOCAL : FIELD : NAME FIELD : STYLE : r1
LOCAL : FIELD : NAME FIELD : FULL WIDTH : YES
local : field : name field : Color:White
local : field : name field : align : centre
[Color : Jobimon]
RGB : 102, 0, 255
[Style:R1]
Font: Verdana
Height  : 16
Bold:Yes
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

EXCEL TO TALLY DATA IMPORT – SELF FORMAT

by with No Comment Excel to TallyExcel2TallyXML

We take all type entries related to sales, purchase, debit note , credit note, payment, receipt etc to maintain our business perfectly. But some time when  our entries were huge and can not do it manually in tally software (Tally ERP9  most usable software in India). In tally it has very nice feature to maintain our business.
But sometime when our entries are so high in quantity and not possible to enter manually, then we can use Excel to Tally software to take bulk entries.

Now you can enter bulk entries with your won excel format. 
Provide me your Excel format, and next day you can able to import your Data into Tally software

THIS EXCEL2TALLY-NINJA WITH SELF FORMAT SOFTWARE HELP YOU TO EXPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY LIKE TALLY 7.2, TALLY ERP 9, TALLY ERP, OR GST READY TALLY .. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME WITH MULTI COMPUTER.
NOW YOU CAN GENERATE XML FOR TALLY OF YOUR EXCEL SHEET DATA WITHIN A SECOND.
WITH THIS SOFTWARE YOU CAN GENERATE XML ENTRIES FOR TALLY ERP9 , TALLY9, TALLY 7.2 ETC WITH BELOW DETAILS :
  1. LEDGER MASTER WITH GST NUMBER, FULL ADDRESS, OPENING BALANCE, AND WITH BILL WISE DETAILS.
  2. STOCK MASTER WITH HSN CODE, ALIAS, OPENING, MRP RATES, STANDARD RATES, BATCH DETAILS.
  3. ALL IN ONE VOUCHER SHEET – WITH THIS SHEET YOU CAN IMPORT YOUR ALL VOUCHERS – SALES, PURCHASE, RECEIPT, PAYMENT, CONTRA, JOURNAL ETC WITH MULTIPLE BILL WISE REFERENCE AT A TIME.
  4. SELF FORMAT – YOU CAN IMPORT SALES, PURCHASE, DEBIT NOTE, CREDIT NOTEENTRIES WITH YOUR FORMAT AND UPTO 5000 (FIVE THOUSAND) ENTRIES AT A TIME..
  5. YOU CAN USE IT FOR LIFETIME
  6. YOU CAN USE IT IN MULTIPLE COMPUTERS, NO RENEWAL.
  7. NOW WITH MULTIPLE LEDGER VOUCHER FORMAT (ALL GST LEDGERS AND ALL TAXABLE LEDGERS)
  8. NOW WITH MULTI GST VOUCHERS WITH STOCK ITEMS
YOUR FORMAT, OUR WORK
SAVE TIME, LABOUR, MONEY
MO.NO.- +91-9131810293
EMAIL :- LEARNWELLS@OUTLOOK.COM
WEBSITE: WWW.LEARNWELLS.COM
DOWNLOAD THE SOFTWARE WITH BELOW BUTTON
PLEASE CONTACT FOR ANY QUERY.