THIS IS EXCEL2TALLY- Auto Import – Payroll WITH THIS WE CAN UPLOAD SALARY/PAYROLL DATA FROM EXCEL TO TALLY WITH ALL DETAILS WITH EMPLOYEE MASTER, ATTENDANCE, PAYROLL VOUCHERS.
MAINTAIN YOUR SALARY SHEET AND IMPORT EVERY TIME IN TALLY WITH ONE CLICK WITH EMPLOYEE MASTER, ATTENDANCE , PAYROLLS.
WITH THIS AUTO IMPORT SOFTWARE NOW YOU CAN UPLOAD ENTRIES WITH BELOW FEATURES:
* EMPLOYEE MASTER : WITH ALIAS, ADDRESS, ALL GENERAL INFORMATION, BANK DETAILS, STATUTORY DETAILS, MULTIPLE PAYHEADS WITH THERE AMOUNT.
* ATTENDANCE VOUCHER : NOW TAKE ATTENDANCE WITH UNLIMITED EMPLOYEES WITH ALL DETAILS (AS WITH – WORKING DAYS, WORKING HOURS OR ANY OTHER FORM OF WORK THAT YOU WANT TO TAKE WITH ATTENDANCE VOUCHER.) NOW WITH AUTO CELL ADDRESSFOR MULTIPLE VOUCHERS WITH MULTIPLE EMPLOYEES.
* PAYROLL VOUCHER : VOUCHER WITH UNLIMITED EMPLOYEE, MULTI PAY HEADS, MULTI DEDUCTION HEADS, WITH COST CATEGORY, UPLOAD UNLIMITED VOUCHERS AT A TIME. PAYSLIPS WILL BE GENERATED AUTOMATICALLY. NOW WITH AUTO CELL ADDRESS FOR MULTIPLE VOUCHERS WITH MULTIPLE EMPLOYEES
* GENERATE SINGLE OR MULTIPLE PAYSLIPS WITH ALL DETAILS.
* WE CAN ALSO USE IT FOR PAYMENT OR JOURNAL OR OTHER VOUCHERS THAT NEED TO FILL COST CENTER/EMPLOYEE NAME. JUST CHANGE VOUCHER NAME. * NOW WITH MULTI COST CATEGORY. * MULTI VOUCHERS IN ONE SHEET. * AUTO ENTRY IMPORT WITH ONE BUTTON IN SAME SHEET
* UNLIMITED ENTRIES AT A TIME * VERY SIMPLE FORMAT AS PER YOUR SHEET.
YOU CAN USE THIS UTILITY IN ALL TALLY VERSIONS AND FOR LIFETIME.
WITH THIS TALLY ERP9 TDL YOU CAN SEE DAILY SALES, DAILY PURCHASE AMOUNT , CONTACT NO. AND CONTACT PERSON AT INVOICE TIME AND CONTACT DETAILS AND GST NUMBER IN LEDGER ACCOUNT. IT WILL BE VERY HELPFUL TO SEE DAILY BUSINESS AND OUTSTANDING COLLECTION
[#Line : LV Title] Add : Field : After : LEDMailName : LWContGST [Field : LWContGST] Use : Name Field Set as : $$String:”Contacts: ” + $$LocaleString:($ledgermobile:Ledger:##LedgerName)+ ” ” + $$LocaleString:($LedgerContact:Ledger:##LedgerName) +” – Gstin: ” + $$LocaleString:($Partygstin:Ledger:##LedgerName) Color : Red Width:50 Background:Light yellow [#Line: EI PartyLimit] Add : Field : After : EI CurrentBalance : TotSales [Field : TotSales] Invisible : NOT ##CurBalanceFlag or NOT @@IsSales Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info : $$LocaleString:”Today’sTotal Sale:” 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 : Blue [System : Formula] TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales ;;……….www.Learnwells.com………;; [#Line: EI PartyLimit] Add : Field : After : EI CurrentBalance : TotPurch [Field : TotPurch] Invisible : NOT ##CurBalanceFlag or NOT @@IsPurchase Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info : $$LocaleString:”Today’s Total Purchase:” Local : Field : Simple Prompt : Width : 14 Local : Field : Amount Field : Set as : @@TrsTotPurch Local : Field : Amount Field : Format : “Symbol,DrCr” Local : Field : Amount Field : Set always : Yes Local : Field : Amount Field : Color : Blue ;;……….www.Learnwells.com………;; [System : Formula] TrsTotPurch : $$FromValue:$Date:$$ToValue:$Date:$DebitTotals:Group:$$GroupPurchase [#Line: EI PartyLimit] Add : Field : After : EI CreditLimit : LWContact [Field : LWContact] Invisible : NOT ##CurBalanceFlag Field : Simple Prompt, Name Field Local : Field : Simple Prompt : Info : $$LocaleString:”Contacts:” Local : Field : name Field : Set as : $LedgerMobile:Ledger:#EIConsignee + ” ” + $LedgerContact:Ledger:#EIConsignee
;;……….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
THIS EXCEL2TALLY_MasterImport SOFTWARE HELP YOU TO IMPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY WITH HELP OFXML. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME WITH MULTI COMPUTER. ALSO CAN UPDATED OLD MASTERS WITH NEW DETAILS. NOW IMPORT STOCK ITEMS and LEDGER MASTERS IN TALLY WITH BELOW FEATURES :
STOCK MASTER: 1. WITH OWN GROUP 2. WITH FULL GST DETAILS (HSN, GST RATES) 3. WITH ALIAS 4. WITH PART NO. 5. WITH OPENING BALANCES. 6. OPENING WITH MULTIPLE BATCHES
7.OPENING WITH MULTIPLE GODOWNS
8. OPENING WITH MULTIPLE RATES 9. WITH STANDARD COST AND STANDARD SALE RATE 10. WITH MRP DETAIL 11. WITH MULTI UNIT AND WITH CONVERSION ENTRY 12. WITH 2500 STOCK ITEM ENTRY AT A TIME
LEDGER MASTERS: 1. WITH ADDRESS, PIN, STATE 2. WITH GST TYPE AND GST NUMBER 3. WITH OWN GROUPS 4. OPENING BALANCES WITH BILLWISE DETAILS 5. ENABLE BILLWISE, COST CENTERS, INTEREST, CREDIT LIMITS ETC. 6. SET CREDIT PERIOD
7. SET CREDIT LIMITS
8. WITH LEDGER NOTES AND DESCRIPTION
9. WITH ADVANCE INTEREST CALCULATION
10. WITH FULL CONTACT DETAIL – PHONE NO, MOBILE NO, EMAIL ID, CONTACT PERSION
11. WITH TDS DETAIL AND PAN NUMBER
12. WITH PARTY BANK DETAILS.
YOU CAN USE IT LIFETIME.
YOU CAN UPDATED YOUR OLD MASTERS ALSO
CLICK ON GENERATE BUTTON TO CREATE XML TO IMPORT IN TALLY.
WITH THIS TALLY ERP9 TDL YOU CAN SEE SALES, PURCHASE COLUMNAR REPORTS WITH ITEM GST DETAILS LIKE HSN CODE, TAXABLE LEDGER, AND TAX DETAILS. IT WILL HELP YOU TO FILE GST RETURNS AND OTHER GST RELATED OR BUSINESS RELATED WORKS.
;;WWW.LEARNWELLS.COM;; [#Collection: Columnar Vouchers of Company] Fetch : AllInventoryEntries.GSTLedItemIGSTRateEx, AllInventoryEntries.GSTItemHSNCodeEx, AllInventoryEntries.GSTEntryLedgerName [#Line: DSP ColVchTitle] Add: Field : After: DBC GSTIN:LearnWellHSN Add: Field : After: DBC GSTIN:LearnWellldg Add: Field : After: DBC GSTIN:LearnWellRT Local : Field:LearnWellHSN : Set as : $$LocaleString:”HSN” Local : Field:LearnWellldg : Set as : $$LocaleString:”TAXABLE LEDGER” Local : Field:LearnWellRT : Set as : $$LocaleString:”GST Rate” [#Part: DBC QtyDetails] Local : Field : LearnWellldg : Set as : $GSTEntryLedgerName [#Line: DSP ColVchDetail] Add: Field : After: DBC GSTIN:LearnWellHSN Add: Field : After: DBC GSTIN:LearnWellldg Add: Field : After: DBC GSTIN:LearnWellRT [Field: LearnWellHSN] Use : Short Name Field Set as : $GSTItemHSNCodeEx Width : 0 Style : Normal Bound : 8,15 Invisible : NOT (##LearnWellSAC AND @@IsGSTOn) Scroll : Yes Border : Thin Left [Field: LearnWellldg] Use : Short Name Field Set as : $GSTEntryLedgerName Width : 0 Style : Normal Bound : 8,15 Invisible : NOT (##LearnWellLDG AND @@IsGSTOn) Scroll : Yes Border : Thin Left [Field: LearnWellRT] Use : Short Name Field Set as : $GSTLedItemIGSTRateEx Width : 0 Style : Normal Bound : 8,15 Invisible : NOT (##LearnWellRT AND @@IsGSTOn) Scroll : Yes Border : Thin Left Alignment : Centre
;;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
THIS EXCEL TO TALLY 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 THROUGH EXCEL SHEET. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME WITH MULTI COMPUTER, NOW WITH VERY SIMPLE FORMAT. NOW WITH UPDATED VERSION YOU CAN GENERATE –
a) LEDGER MASTER : – NOW IMPORT LEDGER MASTER IN TALLY WITH FULL ADDRESS, GST DETAILS , OPENING BALANCE WITH MULTI BILL WISE REFERENCE AND WITH OWN GROUP.
b) COST-CENTER MASTER :- NOW IMPORT COSTCENTER IN TALLY WITH YOUR OWN GROUP
c) GROUP CREATION :- WITH THIS SHEET YOU CAN CREATE SUB GROUPS UNDER MAIN GROUPS AND ALSO UNDER SUB GROUPS
VOUCHERS : – IT HAS MULTIPLE SHEETS TO IMPORT VOUCHERS IN TALLY. YOU CAN USE ACCORDING TO YOUR DATA. YOU CAN IMPORT ALL TYPE ACCOUNTING VOUCHERS WITH EVERY SHEET.
IT HAS BELOW VOUCHER IMPORT SHEETS WITH THERE ADVANCE FEATURES:
1.All in One VOUCHER : WITH THIS VOUCHER SHEET YOU CAN GENERATE ALL VOUCHER TYPE (SALES, PURCHASE, PAYMENT, RECEIPT, CONTRA, JOURNAL ETC. OR YOUR OWN CREATED VOUCHER TYPES) WITH MULTIPLE DR. CR. LEDGERS AND MULTIPLE BILLWISE REFERENCE AND MULTIPLE COSTCENTER DETAILS WITH COST CATYEGORY. ALSO THIS SHEET HAS DUAL NARRATION SYSTEM (AUTO OR MANUAL NARRATION). DIRECT COPY PASTE FROM YOUR DATA. DO FAST ENTRIES WITH MULTI REFERENCES AND COSTERCENTERS. YOU CAN USE ALL TYPE VOUCHERS WITHOUT STOCK ITEMS.
2.AS VOUCHER : WITH THIS VOUCHER SHEET YOU CAN GENERATE ENTRIES WITH SIMPLE FORMAT. DIRECT COPY PASTE FROM YOUR DATA. DO FAST ENTRIES WITH MULTI REFERENCES AND COSTERCENTERS. YOU CAN USE ALL TYPE VOUCHERS WITHOUT STOCK ITEMS.
3.AS INVOICE :WITH THIS VOUCHER SHEET YOU CAN GENERATE ENTRIES WITH SIMPLE FORMAT. DIRECT COPY PASTE FROM YOUR DATA. CONSIGNEE DETAILS, BUYERS DETAILS, CREDIT NOTE AND DEBIT NOTES WITH GST NORMS, DISPATCH DETAILS, WITH SINGLE AND MULTI BILL WISE REFERENCES AND COSTERCENTERS. WITH TAX CLASSIFICATION DETAILS. YOU CAN USE ALL TYPE VOUCHERS WITHOUT STOCK ITEMS.
4.S-C VOUCHER : THIS SHEET IS SPECIALIST FOR JOURNAL VOUCHER. ALSO CAN USE FOR OTHER VOUCHERS. IT CAN IMPORT YOUR EXCEL DATA IN TO TALLY WITH MULTI BILL WISE REFERENCES AND MULTI COSTCENTERS FOR EVERY LEDGER IN ONE VOUCHER.
5.BANK VOUCHER: WITH THIS BANK VOUCHER SHEET YOU CAN GENERATE ENTRIES OF BANK LIKE, PAYMENT, RECEIPT AND CONTRA WITH MULTI BILL WISE REFERENCE AND COSTCENTER. ALSO YOU CAN RECONCILE YOUR BANK ENTRIES AT ENTRY TIME. YOU CAN GENERATE ENTRIES WITH CHEQUE NUMBER / INSTRUMENT NUMBER, CHEQUE DATES, RECONCILIATION DATES. AND ALSO CAN USE RECEIPT, PAYMENT, CONTRA VOUCHERS AT A TIME.
6.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).
*NOW FILL COST CENTERS WITH THERE OWN COST CATEGORY IN REFERENCE SHEET FOR ALL TYPE VOUCHERS. *NOW WITH MULTI LEDGER VOUCHERS WITH MULTIPLE COSTCENTERS. *NOW WITH ROUND OFF COLUMNS.
NOTE : – ALL SHEETS CAN BE USE FOR ANY VOUCHER CREATION. ALL SHEETS HAS SIMPLE FORMAT. IF YOU WANT ANY CHANGES ACCORDING TO YOUR DATA, WE WILL CHANGE FREE OF COST. YOU CAN USE THIS SOFTWARE IN YOUR ANY COMPUTER. PAY ONCE USE LIFETIME.
EVERYTIME WE NEED SOMETHING SPECIAL TO DO PROPER WORK AND TRACK OUR BUSINESS. IN THIS SEGMENT I HAVE SOMETHING SPECIAL FOR YOU.
DOWNLOAD THIS TALLY TDL FILE AND RELAX IN BUSINESS AND LIFE.
WITH THIS TALLY ERP 9 TDL YOU CAN SEE COLUMNAR STOCK ITEMS DETAILS WITH THERE GROUP, UNIT, OPENING AND CLOSING STOCK WITH QUANTITY WITH VALUE , STANDARD COST, SELLING COST, AND MRP DETAILS WITH ONE CLICK. ALSO CAN EXPORT REPORTS IN EXCEL AND PDF FORMAT WITH FILTERED ITEMS. AND ALSO CAN EDIT STOCK ITEMS DETAILS BY PRESSING CTRL+ ENTER
[#Menu:Gateway of Tally] Add:Key Item:before:@@locQuit:Item List:I:Display:LEARNWELLItems [Report: LEARNWELLItems] Use : DSP Template Form : LEARNWELLItems [Form: LEARNWELLItems] Use : DSP Template Part : LEARNWELLItemsTT, LEARNWELLItemsRR Width : 100% Screen Background:Stone Wash Bottom Part : LW Note Bottom Toolbar Buttons: BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10 [Part : LEARNWELLItemsTT] Line : LEARNWELLItemsTT [Line : LEARNWELLItemsTT] Use : LEARNWELLItemsRR Local : Field : LWsrn: Set as : “Srn” Local : Field : LWItmName: Set as : “Item Name” Local : Field : LWItmGrp: Set as : “Item Group” Local : Field : LWItmUnit: Set as : “Item Unit” Local : Field : LWPrCst: Set as : “STRD.COST” Local : Field : LWSlCst: Set as : “SELL RATE” Local : Field : LWMrp: Set as : “MRP” Local : Field : LWItmGstOP: Set as : “Opening Qty.” Local : Field : LWOpValue: Set as : “Opening Value” Local : Field : LWClsQty: Set as : “Closing Qty.” Local : Field : LWClsValue: Set as : “Closing Value” Border : Column Titles Option: Alter On Enter [Part : LEARNWELLItemsRR] Line : LEARNWELLItemsRR Repeat : LEARNWELLItemsRR: STOCKITEM Scroll : Vertical Common Border : Yes [Line : LEARNWELLItemsRR] Field : LWsrn,LWItmName,LWItmGrp,LWItmUnit,LWPrCst,LWSlCst,LWMrp,LWItmGstOP,LWOpValue,LWClsQty,LWClsValue [Field : LWsrn] Use : Short Name Field Set as : $$Line Style : Normal Width : 4 Align : Centre [Field : LWItmName] Use : Name Field Set as : $NAME Width : 40 Style : Normal Bold Border : Thin Left Alter:StockItem [FIELD:LWItmGrp] USE:Simple Field SET AS:$Parent Width : 20 Style : Normal Border : Thin Left [FIELD:LWItmUnit] USE:Simple Field SET AS:$BaseUnits Width : 8 Style : Normal Border : Thin Left [FIELD:LWPrCst] USE: SIMPLE FIELD SET AS: $STANDARDCOST Width : 12 Style : Normal Border : Thin Left [FIELD:LWSlCst] USE: SIMPLE FIELD SET AS: $STANDARDPRICE Width : 12 Style : Normal Border : Thin Left [FIELD:LWMrp] Use : Name Field Set As : $MRPDetails[Last].MRPRateDetails[Last].MRPRate Width : 12 Style : Normal Border : Thin Left [Field : LWItmGstOP] Use : Simple Field Set as : $OpeningBalance Width : 12 Style : Normal Border : Thin Left [Field : LWOpValue] Use : Simple Field Set as : $OpeningValue Width : 12 Style : Normal Border : Thin Left [Field : LWClsQty] Use : Name Filed Set as : $ClosingBalance Width : 12 Style : Normal Border : Thin Left [Field : LWClsValue] Use : Name Filed Set as : $ClosingValue Width : 12 Style : Normal Border : Thin Left [Part : LW Note] Line : LW Note
[Line : LW Note] Field : LW Note
[Field : LW Note] Set as : “Ctrl+Enter to Edit Item – Always Take Backup – www.Learnwells.com” Color : Red Style : Large bold Fullwidth : yes [ Collection : LEARNWELLItemsRR] Type : Stockitem
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
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
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”
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
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.
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).
