Payment QR Code On Invoice

 Payment QR Code On Invoice

As we know most of the customers are now making payments using UPI Payments apps like Phonepe, Google Pay, Paytm, Amazon Pay.

Using this TDL you can generate the QR code in Tally Automatically and print it on your Invoice so that your customer does not have to be at your place to scan the code, or you do not have to send a mobile number to get the money or share the QR code.

Customers can just scan the QR code Printed on the Invoice and send you the money. 

Just attached the TDL file to your tally and you will get option like below 

Set you UPI id/Bank Account Details or Mobile Number and that it.

Now Create a Sales Invoice and Print it. And you should be able to see the QR code as below.

That is now you can Print/Mail this invoice to customer and they can scan the QR code and make the payment.

Cost only 500/- Only

Sr No. on Sales Screen (Free TDL)

 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.

[#Line : EI ColumnOne]

Option : Global EI ColumnOne1

[!Line : Global EI ColumnOne1]

add : fields: before:VCH ItemTitle : VCH SlNO

[field : vch slno]

use : name field

setas : "SL"

Align : Centre

width : 5

style : Small 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

Border : Thin Left Right

Width : 5

Skip : Yes

Tally Password Recovery Free TDL File ( Customization)

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 password recovery.

[#Menu: Gatewayoftally]
Add:Item:password:Display:TallyPass

[Report:Tallypass]
Form:Tallypass
Object:COmpany

[Form:Tallypass]
Part:Tallypass
Height:40% page
Width:40% page
Background:White

[Part:Tallypass]
Line:Tallypass_Title,Admin_Details,User_Details
Repeat:User_Details:CmpUser List
Scroll:Vertical
Float:Yes

[Line:Tallypass_Title]
Field:U_Name,U_pass
Border:Totals
Space Bottom:2

[Field:U_name]
Use:Name Field
Set as: "USER NAME "
Align:Center
Color:Red

[Field:U_Pass]
Use:Name Field
Set as:"PASSWORD "
Align:Center
Color:Red

[Line:Admin_Details]
Field:Admin_Name,Admin_Pwd

[Field:Admin_Name]
Use:Name Field
Set as:$OwnerName:Company:##SVCurrentCompany
Color:Blue
Align: Center

[Field:Admin_Pwd]
Use:Name Field
Set as:$OwnerPassword:Company:##SVCurrentCompany
Color:Blue
Align:Center

[Line:User_Details]
Field:V_Username,V_password

[Field:V_UserName]
Use:Name Field
Set as:$Name
Color:Blue

[Field:V_Password]
Use:Name Field
Set as:$password
Color:White
Align:Center

[#Collection:Cmp User list]
Fetch:*.*
Is ODBC Table:Yes

Note:-- Take a Backup of you data before following. No one will be responsible in case of Data loss.

Step 1. Copy the Above code and past it to notepad and save it.

Step 2. Attach the code to Tally. If you don't know please follow the link.

Step 3. If you are not in a position to open the company of which you forgot password using other username and password. Create a new company and do not close the new company because if you close you will not be able to recover password.

If you can open the same company with other username password. Do not follow below step and just go the new option to view password.

Step 4. Copy 2 files CmpSave.900 and Company.900 from the data folder of  the company whose password you want to recover and paste it in new company data folder. It will ask you to replace file prompt. click yes.

Step 5 Now go back to tally where the new company is still open and go to the new option on gateway of tally to view the password.


Disclamer:- This is just for educational purpose and for personal use. Do use it for data leakage purpose. If used we are not responsible for this.

Free Tally TDL to make PAN Card Field Compulsory (PAN Card Validation)

PAN is important especially for financial transactions. According to experts, PAN is a way for Income Tax Department to keep tabs on your financial dealing.

And as we know in Tally.ERP 9 capture PAN card details during ledger creation in Tally most of us skips the same. So to stop this below is a small free Tally TDL code which will make entering PAN card details mandatory in Tally. ERP 9 during Ledger Creation.

[#Field: LED ITNo]
    Validate    :$$StringLength:$$Value = 10

To attach this code in your Tally.ERP9 software please follow step from below url

http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html

Download Free Tally.ERP9 software  (Educational version)

1. Microsoft excel Shortcuts

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	CTRL+SHIFT+$	Applies the Currency format with two decimal places (negative numbers in parentheses).
9	CTRL+SHIFT+%	Applies the Percentage format with no decimal places.
10	CTRL+SHIFT+^	Applies the Exponential number format with two decimal places.
11	CTRL+SHIFT+#	Applies the Date format with the day, month, and year.
12	CTRL+SHIFT+@	Applies the Time format with the hour and minute, and AM or PM.
13	CTRL+SHIFT+!	Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
14	CTRL+SHIFT+*	Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).  In a PivotTable, it selects the entire PivotTable report.
15	CTRL+SHIFT+:	Enters the current time.
16	CTRL+SHIFT+"	Copies the value from the cell above the active cell into the cell or the Formula Bar.
17	CTRL+SHIFT+Plus (+)	Displays the Insert dialog box to insert blank cells.
18	CTRL+Minus (-)	Displays the Delete dialog box to delete the selected cells.
19	CTRL+;	Enters the current date.
20	CTRL+`	Alternates between displaying cell values and displaying formulas in the worksheet.
21	CTRL+'	Copies a formula from the cell above the active cell into the cell or the Formula Bar.
22	CTRL+1	Displays the Format Cells dialog box.
23	CTRL+2	Applies or removes bold formatting.
24	CTRL+3	Applies or removes italic formatting.
25	CTRL+4	Applies or removes underlining.
26	CTRL+5	Applies or removes strikethrough.
27	CTRL+6	Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
28	CTRL+8	Displays or hides the outline symbols.
29	CTRL+9	Hides the selected rows.
30	CTRL+0	Hides the selected columns.
31	CTRL+A	Selects the entire worksheet.  If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.  When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.  CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
32	CTRL+B	Applies or removes bold formatting.
33	CTRL+C	Copies the selected cells.  CTRL+C followed by another CTRL+C displays the Clipboard.
34	CTRL+D	Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
35	CTRL+F	Displays the Find and Replace dialog box, with the Find tab selected.  SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action.  CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
36	CTRL+G	Displays the Go To dialog box.  F5 also displays this dialog box.
37	CTRL+H	Displays the Find and Replace dialog box, with the Replace tab selected.
38	CTRL+I	Applies or removes italic formatting.
39	CTRL+K	Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
40	CTRL+N	Creates a new, blank workbook.
41	CTRL+O	Displays the Open dialog box to open or find a file.  CTRL+SHIFT+O selects all cells that contain comments.
42	CTRL+P	Displays the Print dialog box.  CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
43	CTRL+R	Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
44	CTRL+S	Saves the active file with its current file name, location, and file format.
45	CTRL+T	Displays the Create Table dialog box.
46	CTRL+U	Applies or removes underlining.  CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
47	CTRL+V	Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.  CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
48	CTRL+W	Closes the selected workbook window.
49	CTRL+X	Cuts the selected cells.
50	CTRL+Y	Repeats the last command or action, if possible.
51	CTRL+Z	Uses the Undo command to reverse the last command or to delete the last entry that you typed.  CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.