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

Free Tally Customization (TDL) HSN Code and GST Percentage During Voucher Entry updated

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 Column One]

 Add   : Right Field: At Beginning:OTSHSNCode

 Add:Right Field: After:OTSHSNCode:OTSGSTPerT

 

[Field:OTSGSTPerT]

 Use:Name Field

 Set as: "GST %"

 Skip: Yes

 Border:Thick Left Right

 Width:10

 Align: Center

 

[Field:OTSHSNCode]

 Use:Name Field

 Set as: "HSN Code"

 Skip: Yes

 Border:Thick Left Right

 Width:10

 Align: Center

[#Line : EI Inv Info]

 Add: Right Field:At Beginning:OTSHSNCodeNo

 Add: Right Field: After: OTSHSNCodeNo: OTSGSTPer

[Field:OTSHSNCodeNo]

 Use: Name Field

 Set as:$(Stockitem,$stockitem).GstDetails[Last].hsncode

 Width:10

 Align: Center

 Set Always: Yes

 Skip: Yes

 

[Field:OTSGSTPer]

 Use: Number Field

 Set as:$(Stockitem,$stockitem).GSTDetails[First].StatewiseDetails[1, @@IsAnyState].RateDetails[1, @@IsIGST].GSTRate

 Format: Percentage

 Width:10

 Align: Center

 Set Always: Yes

 Skip: Yes

 

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)

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 Info menu, press F12 Configure > Advanced Configuration.

· In the Client/Server Configuration screen, set Enable ODBC Server to Yes.

Step 2:

1. Start Microsoft Office 2007.

2. Click Data.

The sub options of Data menu appears as shown:

3. Click From Other sources .

4. Select From Microsoft Query .

Choose Data Source dialog box appears.

5. Select TallyODBC.

Tally.ERP 9 connects to data source and displays Query Wizard – Choose Columns dialog box.

6. Select the columns you would want to include in the query. Select Ledger and Click > button to the right of the following fields: (For example, $Parent)

7. Click Next .

The Query Wizard - Filter Data dialog box appears.

8. Set the filter conditions in the Filter Data dialog box to limit the data to those that match your criteria.

9. Click Next .

The Query Wizard - Sort Order dialog box appears.

10. Sort the data in ascending or descending order as per the requirement.

11. Click Next.

The Query Wizard - Finish dialog box appears.

The option Return Data to Microsoft Office Excel will be selected, by default.

12. Click Finish.

Once the Query Wizard process is complete, the dialogue box entitled Import Data appears.

13. Click OK .

The excel sheet will display the report as shown below:

Simple Tally.ERP9 TDL Code for having contact details In Sales Screen

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:"
Local : Field : name Field : Set as : $LedgerContact:Ledger:#EIConsignee + "  " + $LedgerMobile:Ledger:#EIConsignee
Local: Field: Name Field: Width:25

To attach the above code you will need to follow the steps given in http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html

After Attaching the above code you will be able to see the contact details of your customer on sales voucher screen provided it is filled in in your Ledger.