Serial Number on Sales Screen for Large Invoices Most of the dealers and consumer products dealers have large product/SKU line and the invoices they prepare has a lot of SKU/Stock item in them.  To manage how many products/SKU are sold in a single invoice before printing it Serial Numbers are required on sales and purchase screen. This tdl will provide you with the same function in tally. To attach the code in your tally just copy-paste the below code into Notepad and save it. And just attached the same file to your tally and you should be able to get the serial number as below ..read more

Send Sales Invoice, Receipt Voucher, Payment Voucher, Ledger Statement, and Outstanding Statement to Whatsapp. Now you can send Sales Invoice, Receipt Voucher, Payment Voucher, Ledger Statement, and Outstanding Statement to your customer's/suppliers WhatsApp number without creating any PDF or writing any message using this customization. It will be a completely automated process. Cost:- 900/- For More details contact:- enquiry@onetouchsolution.in or WhatsApp on +919607474805   ..read more

View HSN code and GST Percentage of Stock Item During Voucher Entry. Lot of need know during voucher entry weather the HSN code and GST percentage of Stock Item is entered/updated properly or not. Below code will show you the HSN code and GST percentage of select Stock Item during Voucher entry. To Attach the code to you Tally Software please follow the instructions in the link below. http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html You will need to copy and paste the below code and copy and paste it into your txt/tdl file using notepad/word pad. [#Line : EI ..read more

Tally.ERP9 Data Password Recovery Free TDL file (Customization Code) Here we'll learn to recover our Tally's Data password . Its many of time, tally user face to password forgot problem. In that case, we'll need to go who customizes the tally. for this,   Many of time, some tally users don't recover their tally's password because of extra recovery charges Note:- This tools has being working till Tally version 4.93 after that Tally has encrypted the Normal password too and still there is no tool to de-crypt the Data password. Please find the below code for Tally data pas ..read more

Sr No      Key      Description   1 CTRL+PgUp Switches between worksheet tabs, from left-to-right. 2 CTRL+PgDn Switches between worksheet tabs, from right-to-left. 3 CTRL+SHIFT+( Unhides any hidden rows within the selection. 4 CTRL+SHIFT+) Unhides any hidden columns within the selection. 5 CTRL+SHIFT+& Applies the outline border to the selected cells. 6 CTRL+SHIFT_  Removes the outline border from the selected cells. 7 CTRL+SHIFT+~ Applies the General number format. 8 ..read more

Connecting Tally.ERP 9 to Microsoft Excel 2007 using ODBC Tally ODBC helps you to extract the Data from Tally.ERP 9 and design the reports in MS Excel 2007. To extract Step 1: Enable ODBC 1. Start Tally.ERP 9. It should be open till the process is complete. 2. Ensure that the ODBC Server is running. You can confirm this when the message Running as ODBC Server is displayed in the Configuration block of Information Panel (at the bottom) of Tally.ERP 9 screen, as shown: In case, the ODBC Server is not running, enable the ODBC Server · From Gateway of Tally or Company Inf ..read more

Most of us you like to have customer's contact details in front of us during Voucher entry and Especially during Sale Invoicing so that we can contact them easily without searching for there contact details here and there. And using below code you can achieve the same. NOTE:- This is only for Sales Invoice and will only show the mobile number and contact person. [#Line: EI PartyLimit] Add : Field : After : EI CreditLimit : Contact [Field : Contact] Invisible : NOT ##CurBalanceFlag Field : Simple Prompt, Name Field Local : Field : Simple Prompt : Info : $$LocaleString:"Contact:" Loca ..read more

In this Post I am sharing sample code about how to change and create custom menu on Tally.ERP9 Start instead of Gateway of Tally. This can be use full for security purpose were we want or employee to have only those options which we want on there screen and which cannot be achieved using default Tally.ERP9 security feature. So lets start. [System: Formula] locDefaultGateway                 : $$LocaleString:"Gateway of Tally"     locInvv   :$$LocaleString:"Inventory Vouchers" locRepo   :$$LocaleString:"Reports" [Menu: Vouchers ..read more

How to Add Custom field (UDF) on any screen of Tally.ERP9 Software In this post we will learn how to add Custom Field on any Screen of Tally.ERP9 Software. I will be taking example of Sales Screen as this is the one of which we get most enquiry of or we our-self require most of the time to capture more information which is ether required during sales entry or want to print some additional information on our Invoice. In this post we will be taking example of scenario where we want to view contact person of Customer. So before we start you will need to have any text editor software installed ..read more

What is an Invoice? An invoice is a commercial document that itemizes a transaction between a buyer and a seller. If goods or services were purchased on credit, the invoice usually specifies the terms of the deal, and provides information on the available methods of payment. An invoice is also known as a bill or sales invoice. BREAKING DOWN 'Invoice'  Companies may opt to simply send a month-end statement as the invoice for all outstanding transactions. If this is the case, the statement must indicate that no subsequent invoices will be sent. An invoice must state it is an invoice on ..read more