Amount Wise Outstanding TDL

2023 Best Free Amount Wise Outstanding TDL for Tally Prime and Tally ERP9

The Amount wise Outstanding TDL provides a comprehensive view of the current outstanding amounts, with amount wise.

Tally is a widely used accounting software that provides various financial management solutions for businesses. There is lots of reports hold in Tally, but sometime we required more detailed reports.

So today I have amount wise outstanding TDL for your Tally Prime and Tally ERP9. This feature allows businesses to keep a record of their credit sales and outstanding payments, which helps in managing cash flow and reducing the risk of overdue payments.

Amount Wise Outstanding TDL :

This Amount Wise Outstanding TDL categorizes outstanding amounts into predefined brackets (e.g., 0-1000, 1001-5000, 5001-10000, etc.). This segmentation provides a clear view of the distribution of outstanding dues. This TDL can be use for Sundry Debtors and also for Sundry Creditors.

Amount Wise Outstanding TDL

Amount Wise Outstanding TDL Code:

With this TDL, businesses can make more informed decisions about collections strategies and prioritize follow-up efforts based on the amount owed.

Also checkout Invoice Modification TDL for Tally Prime and Tally ERP9

[#Menu: Account Statements]
Add : Item : Before : Quit : Learnwell Outstanding :Menu :LearnwellOutstandings
[Menu:LearnwellOutstandings]
Add : Item : Sundry Creditors Outstanding : Display :LearnwellOutstandingsCR
Add : Item : Sundry Debtors Outstanding : Display :LearnwellOutstandingsDR

[Report:LearnwellOutstandingsCR]
Form :LearnwellOutstanding
Variable : SvFromDate, SvToDate
Set : SvFromDate : @@DSPFromDate
Set : SvToDate : @@DSPToDate

[Form:LearnwellOutstanding]
Background :@@SV_BALANCESHEET
Part :LWoutT1,LWoutT2,LWoutD
Width       : 100% Screen
Height      : 100% Screen
Button : ExplodeFlag, F2ChangePeriod
Keys : ChangePeriod

[Part : LWoutT1]
Line :LearnWellInfoL
Space Bottom : 0.50

[Line : LearnWellInfoL]
Field : Name Field
Local : Field : Name Field : Set as: "Learnwells.com - Outstanding Report"
Local : Field : Name Field : Align : Left

[Part :LWoutT2]
Line :LWoutTL

[Part :LWoutD]
Line :LearnwellOutstanding
Repeat :LearnwellOutstanding :LearnwellCreditors
Scroll : Vertical
Common Border : Yes
Space : Yes
Space Bottom : 0.50
Bottom Line : NBPMTotals
Total :LW20KT, LW50KT, LW100KT, LW500KT,LW1000KT, LW1000KMT, GrandTotalT

[Line :LWoutTL]
Use :LearnwellOutstanding
Local : Field : Default : Type : String
Local : Field : Default : Align : Center
Local : Field : Default : Style : TinyBold
Local : Field : Default : Border : Thin Left
Local : Field : Parent Name : Set As : "Pariculars"
Local : Field : Parent Group : Set As : "Group"
Local : Field : Mobile : Set as : "Mobile No"
Local : Field : LW20K : Set as : "=<20K "
Local : Field : LW50K : Set as : "=<50K "
Local : Field : LW100K: Set as : "=<1L "
Local : Field : LW500K : Set as : "=<5L "
Local : Field : LW1000K : Set as : "=<10L "
Local : Field : LW1000KM : Set as : "=>10L "
Local : Field : GrandTotal : Set as : "Grand Total "
Border : Column Titles
Height : 1.20

[Line :LearnwellOutstanding]
Field : Parent Name, Parent Group,Mobile
Right Field :LW20K, LW50K, LW100K, LW500K, LW1000K,LW1000KM, GrandTotal
Border : Column Titles
Height : 1.25
Option : Alter on Enter

[Field : Parent Name]
Use : Name Field
Set as : $Name
Style : Tiny Bold
Border : Thin Left
Width : 60

[Field : Parent Group]
Use : Name Field
Set as : $Parent
Style : Tiny Bold
Border : Thin Left
Width : 20

[Field : Mobile]
Use : Name Field
Set as :$LedgerMobile
Style : Tiny Bold
Border : Thin Left
Width : 20

[Field : LW20K]
Use : Amount Field
SetbyCondition : (($ClosingBalance > 0 AND NOT $ClosingBalance <= 20000) OR ($ClosingBalance < 0 AND NOT $ClosingBalance >= 20000))
Set as : $ClosingBalance
Type : Amount
Align : Center
Width : 15
Style:Tiny

[Field : LW50K]
Use : Amount Field
SetbyCondition : (($ClosingBalance > 20000 AND NOT $ClosingBalance <= 50000) OR ($ClosingBalance < 20000 AND NOT $ClosingBalance >= 50000))
Set as : if $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Center
Width : 15
Style:Tiny

[Field : LW100K]
Use : Amount Field
SetbyCondition : (($ClosingBalance > 50000 AND NOT $ClosingBalance <= 100000) OR ($ClosingBalance < 50000 AND NOT $ClosingBalance >= 100000))
Set as : if $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Center
Width : 15
Style:Tiny

[Field : LW500K]
Use : Amount Field
SetbyCondition : (($ClosingBalance > 100000 AND NOT $ClosingBalance <= 500000) OR ($ClosingBalance < 100000 AND NOT $ClosingBalance >= 500000))
Set as : if $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Center
Width : 15
Style:Tiny

[Field : LW1000K]
Use : Amount Field
SetbyCondition : (($ClosingBalance > 500000 AND NOT $ClosingBalance <= 1000000) OR ($ClosingBalance < 500000 AND NOT $ClosingBalance >= 500000))
Set as : if $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Center
Width : 15
Style:Tiny

[Field : LW1000KM]
Use : Amount Field
SetbyCondition : (($ClosingBalance < 999999999 AND NOT $ClosingBalance >= 1000000) OR ($ClosingBalance > 999999999 AND NOT $ClosingBalance <= 500000))
Set as : if $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Center
Width : 15
Style:Tiny

[Field : GrandTotal]
Use : Amount Field
Set as : if $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Right
Width : 15


[Line: NBPMTotals]
Field : Parent Name
Right Field :LW20K, LW50K, LW100K, LW500K,LW1000K, LW1000KM, GrandTotal
Border : Totals
Local : Field : Default : Align : Center
Local : Field : Default : Style : Normal Bold
Local : Field : Default : Border : Thin Left
Local : Field : Parent Name : Set as : "Grand Total"
Local : Field : Parent Name : Align : Center
Local : Field : LW20K: Type : Amount
Local : Field : LW50K: Type : Amount
Local : Field : LW100K	: Type : Amount
Local : Field : LW500K : Type : Amount
Local : Field : LW1000K : Type : Amount
Local : Field : LW1000KM	: Type : Amount
Local : Field : GrandTotal : Type : Amount
Local : Field : LW20K: Set as : $LW20KT
Local : Field : LW50K: Set as : $LW50KT
Local : Field : LW100K	: Set as : $LW100KT
Local : Field : LW500K : Set as : $LW500KT
Local : Field : LW1000K : Set as : $LW1000KT
Local : Field : LW1000KM	: Set as : $LW1000KMT
Local : Field : GrandTotal : Set as : $TotalCB
Local : Field : GrandTotal : Border : Thin Left Right
Local : Field : GrandTotal : Align : Right



[Collection :LearnwellCreditors]
Type : Ledger
By : Amount
Child of : $$GroupSundryCreditors
Belongs To: Yes
Fetch : ClosingBalance
Filter : ZeroClosing
Filter : CreditOnly
AggrCompute : TotalCB : Sum : $ClosingBalance

[System:formula]
Zeroclosing:$ClosingBalance>0 
CreditOnly :Not $$IsDr:$ClosingBalance
TotalCB : $$CollAmtTotal:LearnwellCreditors:$ClosingBalance
Co20K:($ClosingBalance:Ledger:$Name > 0 AND $ClosingBalance:Ledger:$Name <= 20000)
LW20KT  :$$FilterAmtTotal:LearnwellCreditors:Co20K:$ClosingBalance
Co50K:($ClosingBalance:Ledger:$Name > 20000 AND $ClosingBalance:Ledger:$Name <= 50000)
LW50KT  :$$FilterAmtTotal:LearnwellCreditors:Co50K:$ClosingBalance
Co100K:($ClosingBalance:Ledger:$Name > 50000 AND $ClosingBalance:Ledger:$Name <= 100000)
LW100KT  :$$FilterAmtTotal:LearnwellCreditors:Co100K:$ClosingBalance
Co500K:($ClosingBalance:Ledger:$Name > 100000 AND $ClosingBalance:Ledger:$Name <= 500000)
LW500KT  :$$FilterAmtTotal:LearnwellCreditors:Co500K:$ClosingBalance
Co1000K:($ClosingBalance:Ledger:$Name > 500000 AND $ClosingBalance:Ledger:$Name <= 1000000)
LW1000KT  :$$FilterAmtTotal:LearnwellCreditors:Co1000K:$ClosingBalance
Co1000KM:($ClosingBalance:Ledger:$Name > 1000000)
LW1000KMT  :$$FilterAmtTotal:LearnwellCreditors:Co1000KM:$ClosingBalance

;;........................Learnwells.com................................
;;...........................e2t.in.....................................

[Report:LearnwellOutstandingsDR]
Form :LearnwellOutstandingD
Variable : SvFromDate, SvToDate
Set : SvFromDate : @@DSPFromDate
Set : SvToDate : @@DSPToDate

[Form:LearnwellOutstandingD]
Background :@@SV_BALANCESHEET
Part :LWoutT1D,LWoutT2D,LWoutDD
Width       : 100% Screen
Height      : 100% Screen
Button : ExplodeFlag, F2ChangePeriod
Keys : ChangePeriod

[Part : LWoutT1D]
Line :LearnWellInfoLD
Space Bottom : 0.50

[Line : LearnWellInfoLD]
Field : Name Field
Local : Field : Name Field : Set as: "Learnwells.com - Outstanding Report"
Local : Field : Name Field : Align : Left

[Part :LWoutT2D]
Line :LWoutTLD

[Part :LWoutDD]
Line :LearnwellOutstandingD
Repeat :LearnwellOutstandingD :LearnwellCreditorsD
Scroll : Vertical
Common Border : Yes
Space : Yes
Space Bottom : 0.50
Bottom Line : NBPMTotalsD
Total :LW20KTD, LW50KTD, LW100KTD, LW500KTD,LW1000KTD, LW1000KMTD, GrandTotalTD

[Line :LWoutTLD]
Use :LearnwellOutstandingD
Local : Field : Default : Type : String
Local : Field : Default : Align : Center
Local : Field : Default : Style : TinyBold
Local : Field : Default : Border : Thin Left
Local : Field : Parent NameD : Set As : "Pariculars"
Local : Field : Parent GroupD : Set As : "Group"
Local : Field : MobileD : Set as : "Mobile No"
Local : Field : LW20KD : Set as : "=<20K "
Local : Field : LW50KD : Set as : "=<50K "
Local : Field : LW100KD: Set as : "=<1L "
Local : Field : LW500KD : Set as : "=<5L "
Local : Field : LW1000KD : Set as : "=<10L "
Local : Field : LW1000KMD : Set as : "=>10L "
Local : Field : GrandTotalD : Set as : "Grand Total "
Border : Column Titles
Height : 1.20

[Line :LearnwellOutstandingD]
Field : Parent NameD, Parent GroupD,MobileD
Right Field :LW20KD, LW50KD, LW100KD, LW500KD, LW1000KD,LW1000KMD, GrandTotalD
Border : Column Titles
Height : 1.25

[Field : Parent NameD]
Use : Name Field
Set as : $Name
Style : Tiny Bold
Border : Thin Left
Width : 60

[Field : Parent GroupD]
Use : Name Field
Set as : $Parent
Style : Tiny Bold
Border : Thin Left
Width : 20

[Field : MobileD]
Use : Name Field
Set as :$LedgerMobile
Style : Tiny Bold
Border : Thin Left
Width : 20

[Field : LW20KD]
Use : Amount Field
SetbyCondition : (($ClosingBalance > 0 AND NOT $ClosingBalance <= 20000) OR ($ClosingBalance < 0 AND NOT $ClosingBalance >= 20000))
Set as : $ClosingBalance
Type : Amount
Align : Center
Width : 15
Style:Tiny

[Field : LW50KD]
Use : Amount Field
SetbyCondition : (($ClosingBalance > 20000 AND NOT $ClosingBalance <= 50000) OR ($ClosingBalance < 20000 AND NOT $ClosingBalance >= 50000))
Set as : if not $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Center
Width : 15
Style:Tiny

[Field : LW100KD]
Use : Amount Field
SetbyCondition : (($ClosingBalance > 50000 AND NOT $ClosingBalance <= 100000) OR ($ClosingBalance < 50000 AND NOT $ClosingBalance >= 100000))
Set as : if not $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Center
Width : 15
Style:Tiny

[Field : LW500KD]
Use : Amount Field
SetbyCondition : (($ClosingBalance > 100000 AND NOT $ClosingBalance <= 500000) OR ($ClosingBalance < 100000 AND NOT $ClosingBalance >= 500000))
Set as : if not $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Center
Width : 15
Style:Tiny

[Field : LW1000KD]
Use : Amount Field
SetbyCondition : (($ClosingBalance > 500000 AND NOT $ClosingBalance <= 1000000) OR ($ClosingBalance < 500000 AND NOT $ClosingBalance >= 500000))
Set as : if not $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Center
Width : 15
Style:Tiny

[Field : LW1000KMD]
Use : Amount Field
SetbyCondition : (($ClosingBalance < 999999999 AND NOT $ClosingBalance >= 1000000) OR ($ClosingBalance > 999999999 AND NOT $ClosingBalance <= 500000))
Set as : if not $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Center
Width : 15
Style:Tiny

[Field : GrandTotalD]
Use : Amount Field
Set as : if not $$IsDr:$ClosingBalance then 0 else $ClosingBalance
Type : Amount
Border : Thin Left
Align : Right
Width : 15


[Line: NBPMTotalsD]
Field : Parent NameD
Right Field :LW20KD, LW50KD, LW100KD, LW500KD,LW1000KD, LW1000KMD, GrandTotalD
Border : Totals
Local : Field : Default : Align : Center
Local : Field : Default : Style : Normal Bold
Local : Field : Default : Border : Thin Left
Local : Field : Parent NameD : Set as : "Grand Total"
Local : Field : Parent NameD : Align : Center
Local : Field : LW20KD: Type : Amount
Local : Field : LW50KD: Type : Amount
Local : Field : LW100KD	: Type : Amount
Local : Field : LW500KD : Type : Amount
Local : Field : LW1000KD : Type : Amount
Local : Field : LW1000KMD	: Type : Amount
Local : Field : GrandTotalD : Type : Amount
Local : Field : LW20KD: Set as : $LW20KTD
Local : Field : LW50KD: Set as : $LW50KTD
Local : Field : LW100KD	: Set as : $LW100KTD
Local : Field : LW500KD : Set as : $LW500KTD
Local : Field : LW1000KD : Set as : $LW1000KTD
Local : Field : LW1000KMD	: Set as : $LW1000KMTD
Local : Field : GrandTotalD : Set as : $TotalCBD
Local : Field : GrandTotalD : Border : Thin Left Right
Local : Field : GrandTotalD : Align : Right



[Collection :LearnwellCreditorsD]
Type : Ledger
By : Amount
Child of : $$GroupSundryDebtors
Belongs To: Yes
Fetch : ClosingBalance
Filter : ZeroClosing
Filter : DebitOnly
AggrCompute : TotalCBD : Sum : $ClosingBalance

[System:formula]
Zeroclosing:$ClosingBalance>0 
DebitOnly :$$IsDr:$ClosingBalance
TotalCBD : $$CollAmtTotal:LearnwellCreditorsD:$ClosingBalance
Co20KD:($ClosingBalance:Ledger:$Name > 0 AND $ClosingBalance:Ledger:$Name <= 20000)
LW20KTD  :$$FilterAmtTotal:LearnwellCreditorsD:Co20KD:$ClosingBalance
Co50KD:($ClosingBalance:Ledger:$Name > 20000 AND $ClosingBalance:Ledger:$Name <= 50000)
LW50KTD  :$$FilterAmtTotal:LearnwellCreditorsD:Co50KD:$ClosingBalance
Co100KD:($ClosingBalance:Ledger:$Name > 50000 AND $ClosingBalance:Ledger:$Name <= 100000)
LW100KTD  :$$FilterAmtTotal:LearnwellCreditorsD:Co100KD:$ClosingBalance
Co500KD:($ClosingBalance:Ledger:$Name > 100000 AND $ClosingBalance:Ledger:$Name <= 500000)
LW500KTD  :$$FilterAmtTotal:LearnwellCreditorsD:Co500KD:$ClosingBalance
Co1000KD:($ClosingBalance:Ledger:$Name > 500000 AND $ClosingBalance:Ledger:$Name <= 1000000)
LW1000KTD  :$$FilterAmtTotal:LearnwellCreditorsD:Co1000KD:$ClosingBalance
Co1000KMD:($ClosingBalance:Ledger:$Name > 1000000)
LW1000KMTD  :$$FilterAmtTotal:LearnwellCreditorsD:Co1000KMD:$ClosingBalance

Amount Wise Outstanding TDL for Tally Prime and Tally ERP9:

HOW TO USE TDL CODE:
  • Copy above TDL code and create a text file.
  • Save text file and load in Tally (Method provided below the code)
  • Go to Gateway of Tally – Display More Reports – Statement of Accounts – Learnwell Outstanding .
  • You will find Sundry Debtors Outstanding and Sundry Creditors Outstanding
  • Also can print and Export Outstanding details.

This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.

Amount Wise Outstanding TDL Video:

See the below video to learn how to add change amount details in TDL code:

Watch above videos to learn :

  • How to Create TDL files for Tally in Tally Prime Developer.
  • How to Load TDL files in Tally.
  • How to add change between and less than greater than amount for outstanding.
  • How to See the TDL effects in Tally.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Outstanding.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your Outstanding TDL for Tally Prime and ERP9 is ready to use.

The “Amount Wise Outstanding” TDL can be a powerful tool for businesses looking to gain a more detailed understanding of their receivables and payables. By segmenting outstanding amounts, you can make more informed decisions and implement targeted strategies for collections and payments. Always ensure that you obtain TDLs from reputable and trusted sources.

Tally to Excel Import

2023 Amazing Quick Sale Summary from Tally to Excel Import | Tally to Excel Import Free Tool

This is Quick Sale Summary from Tally to Excel Import, to import your sales data into excel direct from Tally without any hustle.

However, extracting and analyzing data from Tally can sometimes be a complex task. In this blog post, we’ll introduce you to a powerful tool that simplifies this process – the Quick Sale Summary from Tally to Excel Import Tool.

Understanding the Quick Sale Summary from Tally to Excel Import Tool:

The Quick Sale Summary from Tally to Excel Import Tool is a user-friendly macro enabled excel workbook application designed to seamlessly transfer sales data from Tally to Microsoft Excel. This tool bridges the gap between your accounting software Tally and spreadsheet analysis, providing you with a simplified and efficient way to process sales information.

Tally to Excel Import

Key Benefits of the Tally to Excel Import:

The Tally to Excel Import tool revolutionizes the way businesses manage their financial data. Its primary advantage lies in its ability to automate the transfer of sales information from Tally to Excel, saving significant time and eliminating manual data entry.

How to Use Tally to Excel Tool:

  1. Enable Macro in Excel Tool (Process given below)
  2. Set ODBC in Tally (Method provided below)
  3. Open Excel Macro Enabled Excel tool and Write Date
  4. Click on Get Button (If have previous data in sheet then click on clear button first.)
  5. Now all Tally Data will collect in Excel Sheet

How to Enable Macro of Tally to Excel Tool:

To enable macro in Macro workbooks, open Excel – goto File – Option – Trust Centre – Trust Centre Setting – Macro Setting – Tick on Enable Macro and Press OK.

For More details Follow these steps to enable and disable macro

How to Enable ODBC in Tally:

Tally Prime Users goto Help – Setting – Connectivity

Tally ERP9 Users goto F12 Configure

For More details: how to enable ODBC in Tally Prime and in Tally ERP 9

How to Use Tally to Excel Import Free Tool Video:

Tally to Excel Import Tool Download Link:

You can download tally to excel import tool with below button:

Unlocking the Potential of Your Tally:

The Quick Sale Summary from Tally to Excel Import Tool empowers businesses to harness the full potential of their sales data. By automating the process and providing a user-friendly interface, this tool enhances your ability to make informed decisions and drive growth.

With this we can create our Pivot Table for MIS report, that will help a lot for business growth.

2023 Best Invoice Modification TDL for Tally Prime and ERP9 | MRP in Voucher and Invoice Print

2023 Best Invoice Modification TDL for Tally Prime and ERP9 | MRP in Voucher and Invoice Print

Here is Invoice Modification TDL for Tally Prime and ERP9 to Add MRP in Voucher and Invoice Print. Tally Prime and ERP9 are widely used accounting software that offer robust capabilities with the help of TDL.

In this blog post, we will modify voucher and invoice printing, and add our own fields like MRP, and other columns with the help of Tally TDL code.

2023 Best Invoice Modification TDL for Tally Prime and ERP9 | MRP in Voucher and Invoice Print

Invoice Modification TDL for Tally Prime and ERP9:

With This TDL code we can add our own field in tally voucher and in tally invoice. This will help you to add MRP, Description, Own discount, Extra Discount, Standard Cost etc. in Invoice.

Also Checkout Voucher Modification TDL


[#Line: DSP AccLine]
Option:LearnwellSMr
[!Line:LearnwellSMr]
add:field:LearnwellSMRP
invisible:##DSPShowInwards
[Field:LearnwellSMRP]
Use : Name Field
Set as :$MRPDetails[Last].MRPRateDetails[Last].MRPRate
width:15
color:red
Align:Right


[#Line : EI ColumnOne]
Option 	: LearnwellVCHmrp     
[!Line: LearnwellVCHmrp]	
Add	: Right Fields	: At Beginning	: LWMrpT
[Field : LWMrpT]
Info	: "MRP"
Align	: Centre
Width	: 10
Style	: Small bold
[#Line : EI ColumnTwo]
Option  : LearnwellVCHmrp2  
[!Line:  LearnwellVCHmrp2  ]
Add	: Right Fields	: At Beginning	: LWMrpT
Local	: Field	: LWMrpT	: Info	: " "


[#Line : EI InvInfo]							
	Option  : LearnwellVCHmrpIN   
[#Line : CI InvInfo]							
	Option  : LearnwellVCHmrpIN  
[!Line: LearnwellVCHmrpIN]
Add	: Right Fields	: At Beginning : LWMrpV
[Field : LWMrpV]
Use	: Name Field
Set As: $StockItemMRPRate
Align	: Centre
Border  : Thin Left Right
Width	: 10
Skip	: YES


[#Line: ExpInv Column1]
Add : left Field : After :EXPINV DescTitle : LWMrpV
Local : Field : LWMrpV : Info : "MRP"
Local : Field : LWMrpV : Delete : Storage
Local : Field : LWMrpV : Type : String
Local : Field : LWMrpV : align : Center
Local : Field : LWMrpV : Width : 10
Local : Field : LWMrpV : Style : small normal
Local : Field : LWMrpV : border : thin left
[#Line :ExpInv InvDetails]
add : left Fields : after : EXPINV Desc :OWNFIELDMRP
[ Field : OWNFIELDMRP]
use : Name Field
Set as :$StockItemMRPRate
Set Always : Yes
Width : 10
Align : Center
Border : Thin Left

MRP in Voucher and Invoice Print:

HOW TO USE TDL CODE:
  • Copy above TDL code and create a text file.
  • Save text file and load in Tally (Method provided below the code)
  • Go to create a Voucher.
  • You will find item MRP etc. will appear after selecting item in voucher.
  • Also can print all extra details in Invoice.

This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.

MRP in Voucher and Invoice Print Video:

See the below video to learn how to add own fields in voucher and print in invoice:

Watch above videos to learn :

  • How to Create TDL files for Tally.
  • How to Load TDL files in Tally.
  • How to add MRP, and own columns in voucher and invoice print.
  • How to See the TDL effects in Tally.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\MRP.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your Voucher and Invoice modification TDL for Tally Prime and ERP9 is ready to use.

By Adding MRP, in voucher column and print column will help to prevent wrong entries and creating a professional invoice. This Free TDL is a valuable TDL for Tally that can help streamline the data entry process and increase efficiency.

GST Return Status

GST Return Status Checking Tool

Welcome to our GST Return Status Checking Tool! Have you ever wondered about the status of your Goods and Services Tax (GST) return? Our user-friendly tool is here to help you track the return filling records and GST additional details of your GST or any other GST number quickly and easily. 

Check GST Return Status:

Fill GST Number and Click on Search Button

Check GST Details

Check GST Details

Returns

Financial Year Date of Filing Return Type Tax Period
Stock Summary Additional Details Tally TDL

2023 Best Stock Summary Additional Details Tally TDL for Tally Prime 3.0

Efficient stock management is crucial for any business to thrive in today’s competitive market. But with this Stock Summary Additional Details Tally TDL for Tally Prime 3.0 we can maintain it easily. While TallyPrime 3.0 offers robust stock management features, sometimes you might find the need to include additional details such as Part Number, HSN Code, GST Rate, MRP Rate, Standard Cost, and Standard Selling Cost in your stock summary. In this blog post, we will explore how to achieve this enhancement using a Tally TDL (Tally Definition Language) customization.

Tally Definition Language (TDL) is a powerful scripting language that allows you to customize and extend the functionality of Tally. It provides the flexibility to add new features, fields, and behaviors to meet your specific business requirements. With TDL, you can transform Tally into a tailored solution that suits your unique needs.

The Need for Stock Summary Additional Details Tally TDL:

While Tally’s stock summary provides valuable information, sometimes you require additional data to make more informed decisions. The inclusion of Part Number, HSN Code, GST Rate, MRP Rate, Standard Cost, and Standard Selling Cost can enhance your stock management capabilities significantly.

Stock Summary Additional Details Tally TDL

Stock Summary Additional Details Tally TDL Code:

[#Field:DSPQ QTYTitle]
add:fields:after:DSP DispTitle:PartNT,LearnwellSHsnT,LearnwellSRT,LearnwellMRPT,LWSTDCostT,LWSTDSellT
invisible:##DSPShowInwards
[Field:LearnwellSHsnT]
Set as :"HSN"
color:blue
style:bold
[Field:LearnwellSRT]
Set as :"GSTRate"
color:blue
style:bold
[Field:PartNT]
Set as :"PartNumber"
color:blue
style:bold
[Field:LearnwellMRPT]
Set as :"MRP"
color:blue
style:bold
[Field:LWSTDCostT]
Set as :"Standard Cost"
color:blue
style:bold
[Field:LWSTDSellT]
Set as :"Standard Sell"
color:blue
style:bold

[#Field:DSP StkCl]
add:fields:after:DSP DispName:PartN,LearnwellSHsn,LearnwellSR,LearnwellMRP,LWSTDCost,LWSTDSell
invisible:##DSPShowInwards
[Field:PartN]
Set as :$PartNo
width:25
color:red
[Field:LearnwellSHsn]
Set as :$HSNDetails[Last].HSNCode
width:20
color:red
[Field:LearnwellMRP]
Set as :$MRPDetails[Last].MRPRateDetails[Last].MRPRate
width:15
color:red
[Field:LearnwellSR]
Set as :$GstDetails[Last].STATEWISEDETAILS[1].RateDetails[1, @@IsIGST].GSTRate
width:8
color:red
[Field:LWSTDCost]
Set as :$StandardCost
width:20
color:red
[Field:LWSTDSell]
Set as :$StandardPrice
width:20
color:red

Also Check Invoice format TDL for Tally Prime 3.0

How to Use Stock Summary Additional Details Tally TDL:

  • Copy above TDL code and create a text file.
  • Save text file and load in Tally (Method provided below the code)
  • Go to Stock Summary Tab in Tally Prime 3.0
  • Here you will find Stock Summary with additional details of Stock Items like : Part Number, HSN Code, GST Rate, MRP Rate, Standard Cost, and Standard Selling Cost

This is best free TDL to have in your Tally. It will support Tally Prime 3.0, Tally Prime, Tally ERP9, that can be use for lifetime. This free TDL Code will perfectly work with old Tally Prime also.

Stock Summary Additional Details Tally TDL Video:

See the below video to learn how to load tdl in tally and add or change details in stock summary :

Watch above videos to learn :

  • How to change TDL details in TDL code.
  • How to Remove Extra Fields from Tally TDL Code.
  • How to add Additional Fields in Tally TDL Code.
  • How to add TDL file in Tally Prime 3.0.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/

FOLLOW BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Stocksummary.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your Stock Summary Additional Details Tally TDL is ready to use.

Conclusion:

Customizing your Tally Prime 3.0 stock summary through TDL opens up a world of possibilities for tailored stock management. By incorporating Part Numbers, HSN Codes, GST Rates, MRP Rates, Standard Costs, and Standard Selling Costs, you empower your business with more accurate data for decision-making. Remember that TDL customization requires careful planning, testing, and refinement. So, take the time to craft a solution that aligns perfectly with your business needs and watch your stock management efficiency soar.

Excel to TallyPrime 3.0 Import Automation

Best Excel to TallyPrime 3.0 Import Automation – All in One

Upgrade your data entry work with Excel to TallyPrime 3.0 Import Automation – your ultimate solution for effortlessly importing all your critical data into Tally including Masters, Vouchers with item, Vouchers without Item, Vouchers with CostCentre, Bank entries, GST2A-2B entries, Stock Journal, In-Out Vouchers, Multi Currency Vouchers etc.. Simplify and accelerate the process of importing Excel data into Tally, all while ensuring precision and efficiency. With an array of powerful features, this software is your key to streamlining your financial and inventory workflows.

Excellent Features of Excel to TallyPrime 3.0 Import Automation:

Introducing Excel to TallyPrime 3.0 Import Automation – the ultimate solution to revolutionize your data integration experience:

Effortless Data Integration with Real-Time Connectivity:

With Excel to TallyPrime 3.0 Import Automation, you can bid farewell to the days of manual data transfer. This powerful tool offers real-time connectivity, allowing you to seamlessly synchronize your critical data between Excel and TallyPrime. Experience unparalleled accuracy and efficiency as your data is effortlessly imported into Tally, ensuring that you’re always working with the most up-to-date information.

Supporting Tally Prime 3.0 Multi GST Option:

Staying compliant with the latest changes in Tally Prime 3.0 is crucial. Excel to TallyPrime 3.0 Import Automation ensures that your entries are seamlessly imported as per the latest Tally Prime 3.0 changes, guaranteeing that your financial records are accurate and up-to-date.

Master Checking and Highlight Before Import:

The innovative Master Checking Facility built into Excel to TallyPrime 3.0 Import Automation takes the guesswork out of data entry. This feature examines ledger and stock item masters in Tally and highlights any missing elements on the voucher sheet. This proactive approach ensures that your data is complete and accurate before it’s even imported into Tally.

Instant Buyer and Consignee Filling from Tally:

Say goodbye to manual input errors and wasted time. Excel to TallyPrime 3.0 Import Automation allows you to directly import buyer and consignee details from Tally into the voucher sheet. This automation accelerates your workflow and reduces the risk of errors, ensuring that your financial records are both precise and efficient.

Automatic Master Import with Voucher Sheet:

Managing masters in Tally can be a time-consuming task. With Excel to TallyPrime 3.0 Import Automation, this process becomes a breeze. The software automatically checks for ledger and stock item masters in Tally, creating any missing masters during the import process. This hands-free approach saves you time and eliminates potential errors.

Flexible Entry Modes and Automated Calculation Enchantment:

Your data import preferences matter, which is why Excel to TallyPrime 3.0 Import Automation offers dual entry modes. Choose between the ODBC one-click direct entry system or XML generation, based on your preferred method. The software’s automated calculation enchantment feature takes care of complex calculations, from cell addresses to round-offs and taxable values. The Validate feature puts these calculations at your fingertips, ensuring your data is accurate and error-free.

Effortless Unlimited Entries with User-Friendly Formats:

Break free from limitations with Excel to TallyPrime 3.0 Import Automation. Whether you’re dealing with a handful of entries or managing thousands, this tool’s streamlined one-click process supports up to 25,000 entries at a time. The user-friendly formats cater to various types of work, making the data entry process smooth and intuitive.

Learnwell Tab on Excel Ribbon:

Excel to TallyPrime 3.0 Import Automation integrates seamlessly into your Excel environment. With buttons conveniently placed on the Excel Ribbon, you can simplify actions and boost efficiency. Instantly access key features and functionalities that streamline your data integration workflow.

Supporting All Versions of Microsoft Excel:

Worried about compatibility? Excel to TallyPrime 3.0 Import Automation has you covered. From Excel 2007 to the latest Excel 365 version, this software’s compact footprint ensures uninterrupted operations, regardless of your Excel version.

Lifetime Access and Round-the-Clock Support:

Investing in Excel to TallyPrime 3.0 Import Automation means gaining lifelong access with no renewal required. And should you need assistance, round-the-clock support is just a call, WhatsApp message, or remote desktop session away.

Masterful Sheets for Comprehensive Data Entry:

Excel to TallyPrime 3.0 Import Automation comes equipped with a range of specialized sheets that cover various aspects of data entry into TallyPrime:

Excel to TallyPrime 3.0 Import Automation
  • Tally Details Sheet:
    • Collects Tally company, ledger, and item details.
    • Facilitates master checking and filling for voucher sheets.
  • Data Sheet:
    • Directly imports Excel files for data transfer.
    • Populates voucher sheets with matching headers.
    • Eliminates manual copy-pasting efforts.
  • Excel to TallyPrime 3.0 Import Automation – Stock Master Sheet:
    • Imports stock item every details into TallyPrime 3.0.
    • Allows modification of Tally stock master. It can alter every detail of Tally item.
    • “Data from Tally” button helps in collect item all details from Tally to Excel for easy modifications and update in Tally.
    • Supports item group and unit master imports also.
  • Excel to TallyPrime 3.0 Import Automation – Ledger Master Sheet:
    • Imports Ledger every details into TallyPrime 3.0.
    • Allows modification of Tally Ledgers. It can alter every detail of Tally Ledger.
    • “Data from Tally” button helps in Retrieves ledger details from Tally to Excel for easy modifications and update in Tally
    • Supports ledger group master import alongside ledger masters.
  • Excel to TallyPrime 3.0 Import Automation – CostCentre Master Sheet:
    • Imports CostCentre Mster into TallyPrime 3.0.
    • Add won Groups for CostCentre.
    • Add Cost Category
  • Excel to TallyPrime 3.0 Import Automation – Item Invoice Sheet:
    • Import invoices with stock items in TallyPrime 3.0.
    • Import Sales, Purchase, Debit Note, Credit Note, Journal with stock items and every details of Invoices.
    • Entries can do with Part Number and Alias also along with item name.
    • Entries can do with Multiple Godown and Batch wise.
    • Entries can do with Billwise details.
    • Supports Multiple Stock Items in Single Voucher.
    • Supports Multiple Taxable and GST Ledger in Single Voucher.
    • Add your own voucher type and ledger details as per your Tally.
    • Automatic Checking ledger and item details from Tally and highlighted non created masters.
    • Automatic filling Buyer and Consignee details along with Taxable and GST Ledgers from Tally.
    • Add Tax Classification details also.
    • Collect data from DataSheet to avoid copy pasting.
    • Validate Button to check GST calculation, Multi Item calculation, Round off Calculation etc.
    • Post Master Button to create Ledger Master and Stock Master at voucher entry time.
    • Post Voucher button to create Vouchers into Tally with all important details.
  • Excel to TallyPrime 3.0 Import Automation – Item Invoice Detailed Sheet:
    • Import invoices with stock items in TallyPrime 3.0.
    • Import Sales, Purchase, Debit Note, Credit Note, Purchase Order, Sales Order with stock items and every details of Invoices.
    • Entries with Order Numbers.
    • Having Order Details, Dispatch Details, E-Waybill Details columns.
    • Entries can do with Part Number and Alias also along with item name. Can add Item description also.
    • Entries can do with Multiple Godown and Batch wise. Also supporting Manufacturing and Expiry Date.
    • Entries can do with Billwise details.
    • Supports Multiple Stock Items in Single Voucher.
    • Supports Multiple Taxable and GST Ledger in Single Voucher.
    • Add your own voucher type and ledger details as per your Tally.
    • Automatic Checking ledger and item details from Tally and highlighted non created masters.
    • Automatic filling Buyer and Consignee details along with Taxable and GST Ledgers from Tally.
    • Add Tax Classification details also.
    • Collect data from DataSheet to avoid copy pasting.
    • Validate Button to check GST calculation, Multi Item calculation, Round off Calculation etc.
    • Post Master Button to create Ledger Master and Stock Master at voucher entry time.
    • Post Voucher button to create Vouchers into Tally with all important details.
  • Excel to TallyPrime 3.0 Import Automation – Accounting Invoice Sheet:
    • Import invoices without stock items in TallyPrime 3.0.
    • Import Sales, Purchase, Debit Note, Credit Note, Journal with every details of Invoices.
    • Entries can do with Billwise details.
    • Supports Multiple Taxable and GST Ledger in Single Voucher.
    • Add your own voucher type and ledger details as per your Tally.
    • Automatic Checking ledger details from Tally and highlighted non created masters.
    • Automatic filling Buyer and Consignee details from Tally.
    • Collect data from DataSheet to avoid copy pasting.
    • Validate Button to check GST calculation, Multi Ledger calculation, Round off Calculation etc.
    • Post Master Button to create Ledger Master at voucher entry time.
    • Post Voucher button to create Vouchers into Tally with all important details.
  • Excel to TallyPrime 3.0 Import Automation – Accounting Voucher Sheet:
    • Import Simple Accounting Vouchers in TallyPrime 3.0.
    • It has Two Debit Credit Columns with Multiple Ledger support in Single Invoice.
    • Having Group option for Ledgers, that will help in creating ledger masters.
    • Import Sales, Purchase, Debit Note, Credit Note, Journal, Receipt, Payment, Contra Vouchers.
    • Entries can do with Billwise details.
    • Add your own voucher type and ledger details as per your Tally.
    • Automatic Checking ledger details from Tally and highlighted non created masters.
    • Validate Button to Multi Ledger calculation.
    • Post Master Button to create Ledger Master at voucher entry time.
    • Post Voucher button to create Vouchers into Tally with all important details.
  • Excel to TallyPrime 3.0 Import Automation – Accounting Voucher Detailed Sheet:
    • Import Multiple Debit Credit Accounting Vouchers in TallyPrime 3.0.
    • Direct Ledger Name connection from Tally to add ledgers from Tally in to Sheet.
    • Import Sales, Purchase, Debit Note, Credit Note, Journal, Receipt, Payment, Contra Vouchers.
    • Import Entries with CostCentre and Cost Category.
    • Entries can do with Billwise details.
    • Add your own voucher type and ledger details as per your Tally.
    • Post Voucher button to create Vouchers into Tally with all important details.
  • Excel to TallyPrime 3.0 Import Automation – GSTR2A-2B Sheet:
    • Import GSTR2A-2B Entries in TallyPrime 3.0.
    • Supporting Single GST and Multi GST entries.
    • Having Import Button to Get GST file direct into Sheet to avoid copy pasting.
    • Auto calculate Multiple GST in single voucher.
    • Auto populate State Names asper GST Number.
    • Validate Button to Multi Ledger calculation.
    • Post Master Button to create Party Ledger Master at voucher entry time.
    • Post Voucher button to create Voucher into Tally with all important details.
  • Excel to TallyPrime 3.0 Import Automation – StockJournal Sheet:
    • Import Stock Journal and Manufacturing Journal Entries in TallyPrime 3.0.
    • Having Consumption, Production and Cost of Components Sections. Also have Scrap option.
    • All Stock items with Batch and Godown name.
    • Auto calculate Multiple Stock Item in single voucher.
    • Direct Stock Item connection from Tally to add correct stock item in sheet.
    • Validate Button to calculate multiple stock item entries with multiple batch and godwon in single voucher.
    • Post Voucher button to create Voucher into Tally with all important details.
  • Excel to TallyPrime 3.0 Import Automation – In-Out Sheet:
    • Import Material In-Out, Rejection In-Out, Journal, Sales, Purchase Entries in TallyPrime 3.0.
    • Having Godown to Godown transfer opiton also.
    • Entries with Batch, Godown and Tracking Id with Stock Item.
    • Auto calculate Multiple Stock Item in single voucher.
    • Validate Button to calculate multiple stock item entries with single voucher.
    • Post Voucher button to create Voucher into Tally with all important details.
  • Excel to TallyPrime 3.0 Import Automation – Multi Currency Voucher Sheet:
    • Import Payment, Receipt, Contra, Journal, Sales, Purchase Entries without Item in TallyPrime 3.0.
    • Entries with Multiple Billwise references.
    • Entries with Multiple Debit Credit Option.
    • Support all country currency.
    • Also can do entries in local currency.
    • Having ledger selection option direct from Tally.
    • Support own voucher type also.
    • Validate button to calculate multiple bill details in single voucher.
    • Post Voucher button to create Voucher into Tally with all important details.
  • Excel to TallyPrime 3.0 Import Automation – Multi Currency Invoice Sheet:
    • Import Sales, Purchase, Debit Note, Credit Note, Journal Entries With Item in TallyPrime 3.0.
    • Support Multiple stock item in Single voucher.
    • Import Godown wise and Batch wise entries with item description.
    • Entries with Multiple Billwise references.
    • Entries with Multiple Debit Credit Option.
    • Support all country currency.
    • Also can do entries in local currency.
    • Having ledger and item selection option direct from Tally.
    • Support own voucher type also.
    • Validate button to calculate multi currency and multiple item in single voucher.
    • Post Voucher button to create Voucher into Tally with all important details.
  • Excel to TallyPrime 3.0 Import Automation – Bank Voucher Sheet:
    • Import all type bank statements in TallyPrime 3.0.
    • Support Multiple debit credit in Single voucher.
    • Import entries with bank reconciliation date.
    • Import with all details including value date, cheque number etc.
    • Support own voucher type including Contra.
    • Support auto select voucher type for payment and receipt.
    • Having Ledger selection option direct from Tally.
    • Post Voucher button to create Bank Vouchers into Tally with all important details.
  • SIMPLE AND FASTEST SHEETS
  • IMPORT ALL TYPE DATA WITH DIFFERENT SHEETS
  • UTILITY ALSO HAVE HELP SHEET, READ CAREFULLY BEFORE USE.
  • EVERY BUTTON IN RIBBON HAS HELP OPTION WITH IT. MOVE CURSOR ON BUTTONS TO GET HELP.

VIDEO HELP:https://youtu.be/8LuTJvBDOeg
WEBSITE : www.Learnwells.com and E2T.in
EMAIL : Learnwells@outlook.com
YOUTUBE : https://www.youtube.com/learnwell/c
FACEBOOK: https://www.facebook.com/learnswell/
CONTACT NO. +91-9131810293 (ASHISH SINGH)

Invoice Customization TDL for Tally Prime

2023 Best Invoice Customization TDL for Tally Prime | Invoice Format TDL for Tally

Here is Best Invoice Customization TDL for Tally Prime. In the realm of business, your company’s image is more than just a logo – it’s a reflection of your professionalism and credibility. When it comes to invoices, they are not mere transactional documents; they are opportunities to reinforce your brand identity and make a lasting impression on your clients. This is where the power of Tally Prime’s customization capabilities comes into play.

In this blog post, we unveil an innovative Tally Definition Language (TDL) solution that transforms your invoices into stylish and professional representations of your business. With the “Elegant Invoice with QR Code and Logo” for Tally Prime, you can create invoices that feature a sleek QR code for seamless payments, an eye-catching logo with a bold company name and address, and a captivating header for item details. Discover how this Invoice Format TDL for Tally can elevate your company’s status in the market and help you make a memorable impact on your clients.

The Importance of Invoice Customization TDL for Tally Prime:

Invoices are more than just records of financial transactions; they serve as tangible representations of your brand. An invoice is often the last piece of communication a client receives from you, making it a critical touchpoint for leaving a positive and memorable impression.

Unleashing the Power of Tally Prime Customization with Invoice Format TDL for Tally:

Tally Prime, renowned for its robust accounting capabilities, offers users the ability to customize their software experience through TDLs. These TDLs enable users to tailor Tally to their specific business needs, ensuring efficiency, accuracy, and enhanced brand representation.

Invoice Format TDL for Tally

Introducing the Invoice Customization TDL for Tally Prime:

The Invoice Format TDL for Tally is a game-changing customization for Tally Prime users. Designed to create visually striking invoices, this TDL amalgamates essential elements like a bold company logo, a QR code for seamless payments, and an enhanced item header design for clarity.

Customized Invoice Format TDL for Tally TDL Code :

[#Part: EXPINV SaleTopLeft]
Height      : If ($$InExportMode OR $$InMailAction OR $$InUploadAction) AND ($$IsSysNameEqual:Excel:##SVExportFormat OR $$IsSysNameEqual:HTML:##SVExportFormat) THEN +
							(10 + 10 + @WithOrderVch + @WithOrderTerms + @WithBuyer + @WithCountry)  ELSE +
							(10 + 10 + @WithOrderVch + @WithOrderTerms + @WithBuyer + @WithCountry) % page
	
	Delete: Parts: EXPINV Company	
	
	[#Form: Printed Invoice]
		Add:Parts:LWCMPDetails	

[part:LWCMPDetails]
Add:Parts:LWQR,CMPdtl,CMPLOGO


[Part:LWQR]
Part :LearnWellQRIn,qrtxt
Vertical : Yes
[Part :LearnWellQRIn]
Horizontal Alignment :Left
Vertical : No
Lines :LWQrLn
QR code: ("upi://pay?pa=9131810293@ybl&pn=AshishKumarSingh&tn=Bill No."+$$String:$voucherNumber) : True
Height : 10% page
Width : 12% Page
[Line :LWQrLn]
Field :LWQrFn
[Field :LWQrFn]
Set As : ""
[Part:qrtxt]
Line:as
[Line:as]
Field:as
[Field:as]
Use:name field
Set as:"Scan to Pay"

[Part:CMPLOGO]
Part :LearnWellLOGO
Vertical : Yes
[Part :LearnWellLOGO]
Horizontal Alignment :Right
Vertical : No
Lines :LWLG
Graph Type: "C:\Users\ssonu\Files\Channels\Learnwell\logo.jpg"
Height : 10% page
Width : 15% Page
[Line :LWLG]
Field :LWLGF
[Field :LWLGF]
Set As : ""

[Part:CMPdtl]
Lines:LWCMPName,LWCMPAdd
Repeat:LWCMPAdd:CompanyAddress
[Line:LWCMPName]
Field:LWCMPName
[Field:LWCMPName]
Use:name field
Set as:@@CMPMailNAme
Full Width:Yes
Align:Centre
Style:Cmpstyle
[Line:LWCMPAdd]
Field:LWCMPAdd
[Field:LWCMPAdd]
Set as:$address
Align:Center
Full Width:Yes
Style:ADDStyle
[Style:Cmpstyle]
Use: Normal Bold
Height:20	 
[Style:ADDStyle]
Height:10
Use:Normal  
[#Part: EXPINV Signature]
Delete:Border
[#Part: EXPINV Column]
Border:Thick Box
Delete:Line:EXPINV Column2
Local : Field : Default : Style :Normal Bold
Local : Field : Default : Print FG :White
Print BG:Black

How to Use Invoice Customization TDL for Tally Prime in Tally:

  • Copy above TDL code and create a text file.
  • Save text file and load in Tally (Method provided below the code)
  • Change QR Code Details in TDL file
  • Create a Logo and replace logo path in TDL file
  • Go to Tally sales voucher and Print an Invoice.
  • You will find new invoice format with QR code and Logo and Company Details on Middle, and changed Item description header.

This is best free TDL to have in your Tally. It will support Tally Prime 3.0, Tally Prime, Tally ERP9, that can be use for lifetime. This free TDL Code will perfectly work with old Tally Prime also.

Invoice Customization TDL for Tally Prime Video:

See the below video to learn how to load tdl in tally and change QR details and Logo details:

Watch above videos to learn :

  • How to change TDL details in TDL code.
  • How to Change QR code details in TDL file.
  • How to Change LOGO in TDL.
  • How to add TDL file in Tally Prime 3.0.
  • How to Print sales Invoice in New format.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/

FOLLOW BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Invoice.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your Auto Receipt with Sales Entry TDL is ready to use.

Conclusion:

In the world of business, perception matters. With the Elegant Invoice with QR Code and Logo TDL, Tally Prime users can transform ordinary invoices into extraordinary brand statements. Elevate your company’s image, streamline payment processes, and ensure your brand leaves a lasting mark with invoices that reflect the very essence of your business. Empower your invoicing experience with this TDL and unlock the potential to make every invoice a testament to your brand’s credibility and professionalism.

Watermark on PDF files and Invoices in Bulk

2023 Most Powerful Code to Add Watermark on PDF files and Invoices in Bulk | Watermark TDL for Tally

In this blog post I will provide you all a Most Powerful Code to Add Watermark on PDF files and Invoices in Bulk. In the digital age, protecting and branding your PDF files is essential to maintain the integrity and ownership of your valuable content. Adding watermarks to PDF files not only adds a layer of security but also enhances the professional appeal of your documents. However, manually adding watermarks to multiple PDF files can be time-consuming and tedious. Thankfully, Python offers powerful libraries that enable us to automate this process efficiently.

And Tally, the widely-used accounting and business management software, offers a plethora of features that streamline financial operations for businesses across the globe. However, when it comes to securing sensitive documents or adding branding elements to reports, Tally might require additional customizations. People always asks for Watermark TDL for Tally, but it is not possible to add Watermark in Tally invoices through TDL, but with this python method we can add watermark in Tally Invoices along with statements or in any other Tally reports.

In this blog post, we will explore how to add watermarks to PDF files in bulk using Python.

Understanding Watermark on PDF files:

A watermark is an overlay image or text that is superimposed on a document to signify its origin, ownership, or confidential status. In this context, we will focus on adding transparent image-based watermarks to PDF files.

Installing Python for Watermark on PDF files and Invoices:

To install Python for adding watermarks to PDF files and invoices, follow these simple steps:

Download Python: Visit the official Python website (https://www.python.org/) and download the latest version of Python suitable for your operating system (Windows, macOS, or Linux).

Install Python: Run the downloaded Python installer and follow the on-screen instructions to install Python on your computer. Make sure to check the option “Add Python X.X to PATH” during installation for easier command-line access.

Install Required Libraries for Watermark on PDF files and Invoices:

Open your command-line interface (Command Prompt on Windows or Terminal on macOS/Linux) and install the necessary Python libraries using the “pip” command: pip install PyPDF2 reportlab

Python Code for for Watermark on PDF files and Invoices :

import os
import PyPDF2

def add_watermark(input_pdf_path, output_pdf_path, watermark_pdf_path):
    with open(input_pdf_path, 'rb') as input_pdf:
        pdf_reader = PyPDF2.PdfReader(input_pdf)
        pdf_writer = PyPDF2.PdfWriter()

        watermark_pdf = PyPDF2.PdfReader(watermark_pdf_path)
        watermark_page = watermark_pdf.pages[0]

        for page_num in range(len(pdf_reader.pages)):
            page = pdf_reader.pages[page_num]
            page.merge_page(watermark_page)
            pdf_writer.add_page(page)

        with open(output_pdf_path, 'wb') as output_pdf:
            pdf_writer.write(output_pdf)

if __name__ == "__main__":
    input_folder = r"C:\Users\ssonu\Downloads\PDF"
    output_folder = r"C:\Users\ssonu\Downloads\output"
    watermark_pdf_path = r"C:\Users\ssonu\Downloads\logo.pdf"

    # Create the output folder if it doesn't exist
    if not os.path.exists(output_folder):
        os.makedirs(output_folder)

    # Iterate through all PDF files in the input folder
    for file_name in os.listdir(input_folder):
        if file_name.endswith(".pdf"):
            input_pdf_path = os.path.join(input_folder, file_name)
            output_pdf_path = os.path.join(output_folder, file_name)
            add_watermark(input_pdf_path, output_pdf_path, watermark_pdf_path)

How to Use Python Code to Add Watermark in PDF files and Tally Invoices:

Follow below steps to add watermark in pdf files and in Tally Invoices:

  1. Create a Separate folder in computer.
  2. Add Python code file in this folder
  3. Create Input and Output subfolders
  4. Create a watermark logo for watermarking, and also put in this folder.
  5. Add raw PDF files in input folder, for that you want to create watermark.
  6. Change Path in Python code asper your files and input, output locations.
  7. Open CMD and run as administrator
  8. Type pushd your folder location and press enter
  9. Type Python Pythonfilename.py and press enter
  10. Your all pdf files having in input folder will be save in output folder with logo.
Watermark in PDF files and Tally Invoices

How to use as Watermark TDL for Tally:

To use this method as watermark TDL for Tally, Save all Tally Invoices in PDF form in your Input folder and next follow above all steps. After Process completion watermark will be added in all Tally Invoices.

Also get Auto Receipt with Sales Voucher

How to Use Watermark on PDF files and Invoices in Bulk and How to use as Watermark TDL for Tally Video:

Watch the below video to see How to Use Watermark on PDF files and Invoices in Bulk and How to use as Watermark TDL for Tally :

Watch above videos to learn :

  • How to create logo for watermark.
  • How to create folders.
  • How to use python code in CMD (Command Prompt)
  • How to use pushd in python.
  • How to run python code file through CMD
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/

Conclusion:

Automating the process of adding watermarks to PDF files in bulk using Python and the PyPDF2 and Pillow libraries can save you valuable time and effort. Whether you want to protect your documents or add branding elements to them, this approach simplifies the process and enhances your PDF files’ overall appeal. Feel free to customize the script further to suit your specific needs, such as handling different image formats or configuring watermark positions. Empower your PDF management tasks with Python’s capabilities, and ensure your documents remain secure and professionally branded.

FAQ – Watermark on PDF files and Invoices in Bulk:

What is Python, and why is it used for watermarking PDF files and invoices?

Python is a popular and versatile programming language known for its simplicity and readability. It is widely used for various tasks, including automating processes like watermarking PDF files and invoices. Python’s rich ecosystem of libraries, such as PyPDF2 and Pillow, makes it an excellent choice for handling PDF manipulation and image processing.

Do I need programming knowledge to use Python for watermarking?

Basic understanding of Python programming would be helpful, but you can also find ready-made scripts and tutorials online that you can customize for your watermarking needs. With some practice, even beginners can implement watermarking with Python.

How do I install Python on my computer?

You can download the latest version of Python from the official Python website (https://www.python.org/) and run the installer for your operating system. During installation, make sure to check the option “Add Python X.X to PATH” for easy command-line access.

What are the required Python libraries for watermarking PDF files and invoices?

You need to install two libraries: PyPDF2 for PDF manipulation and Pillow for image processing. Use the “pip” command to install them as follows:

Copy code
pip install PyPDF2
pip install Pillow

How can I create a watermark image for use in the watermarking process?

You can design a watermark as a transparent PNG image using graphic design software like Adobe Photoshop or free alternatives like GIMP. Save the image in the same directory as your Python script.

Can I automate the watermarking process for multiple PDF files and invoices?

Yes, that’s one of the significant advantages of using Python for watermarking. You can create a Python script that handles the watermarking process in bulk, saving you time and effort.

Will watermarking PDF files and invoices affect their original content?

No, when you add a watermark to a PDF file or invoice using Python, the original content remains intact. The watermark is simply overlaid on the document without modifying the underlying data.

Is watermarking with Python a secure method for document protection?

While watermarking enhances document security and authenticity, it is not a foolproof method for protecting highly sensitive information. For robust security, consider additional encryption or access control measures.

Can I customize the appearance and position of the watermark on PDF files and invoices?

Yes, Python allows extensive customization of watermark appearance, such as transparency, size, position, and rotation. You can adjust these parameters in your Python script to suit your preferences.

Is Python watermarking suitable for large-scale document processing?

Python is efficient for various tasks, but large-scale document processing may require additional optimization. If dealing with a massive number of files, consider parallel processing or cloud-based solutions.

Auto Receipt with Sales Entry TDL

2023 Best and Amazing Auto Receipt with Sales Entry TDL

Tally has long been recognized as the go-to accounting and business software in India and several other Asian countries. Its robust features and user-friendly interface have made it an indispensable tool for countless businesses, both big and small. However, did you know that you can unlock even more power and efficiency from Tally through customization?

In this article, we present an innovative solution that takes Tally’s capabilities to the next level – the “Auto Receipt with Sales Entry TDL.” By incorporating this TDL into Tally, you can revolutionize your data entry and reporting system, making it more efficient and effective than ever before.

This TDL file is designed to work seamlessly with Tally Prime 3.0, Tally Prime, and Tally ERP 9, providing you with the convenience of automating receipt entries along with sales invoicing.

What is the “Auto Receipt with Sales Entry TDL”?

The “Auto Receipt with Sales Entry TDL” is a powerful TDL file created for Tally users to enhance their invoicing and receipt recording experience. When you create a sales invoice using Tally, this TDL allows you to input received amount details with different payment modes against the specific invoice. Once the sales voucher is saved, a popup message will prompt, asking if you wish to create receipt entries for the same invoice. If you choose “Yes,” the receipt entries will be automatically generated, saving you valuable time and effort.

Auto Receipt with Sales Entry TDL

The Power of Receipt Entry at Sales Time:

At the heart of this Auto Receipt with Sales Entry TDL lies the concept of recording receipt entries at the time of creating sales invoices. This seemingly small adjustment brings about a wealth of benefits that can significantly improve your financial management process.

Streamlined Outstanding Clearances:

By capturing receipt details while invoicing, you can ensure that every sale is promptly associated with its corresponding payment. This approach streamlines the process of clearing outstanding balances, reducing the likelihood of funds getting stuck in the system.

Accurate Bill-to-Bill Payments:

Receipt entry at sales time enables accurate bill-to-bill matching. This means that every invoice is immediately linked to its payment, allowing for a clear and transparent payment reconciliation process.

Continuous Bank and Cash Reconciliation:

With receipt entries entered alongside sales invoices, your bank and cash accounts are automatically updated. This real-time updating ensures that your financial records are always up-to-date and accurate.

Enhanced Sales Voucher Reconciliation:

The “Auto Receipt with Sales Entry TDL” brings another significant advantage – the receipt records are held directly within the sales voucher. When it comes to future sales voucher reconciliation, all relevant payment information is readily available for quick and efficient matching.

Comprehensive Payment Mode Tracking:

This Auto Receipt with Sales Entry TDL includes a dedicated section to record payment modes, such as cash, credit, cards, UPI, and cheques, along with their respective amounts. This invaluable feature simplifies the process of conveying payment details to customers during account reconciliation.

Time-Saving Automation:

Manually entering receipt details after invoicing can be tedious, especially when dealing with multiple transactions. This Auto Receipt with Sales Entry TDL automates the receipt entry process, eliminating the need for redundant data entry tasks.

Reduced Errors:

Automation significantly reduces the chances of human errors that might occur during manual data entry. By automating the receipt entries, you ensure accuracy and maintain the integrity of your financial data.

Enhanced Productivity:

By streamlining the invoicing and receipt recording workflow, you and your accounting team can focus on other critical tasks..

Better Cash Flow Management:

The “Auto Receipt with Sales Entry TDL” facilitates faster receipt recording, leading to better cash flow management and improved financial planning.

Auto Receipt with Sales Entry TDL Code:

  [#Form: Sales Color]
        Add :  Part : At End  :LearnwellReceiptMode
		On : Form Accept : yes : Form Accept
		On : Form Accept : yes : Call : WantReceipt
    [Part :LearnwellReceiptMode]
        Line         :LearnwellRCPLine, LearnwellRCPLineDtl
        Bottom Line : LearnwellRCPLineTotal
        Total        : LearnwellRCPLineTotalDtl
        Height        : 25% Page
        Repeat         : LearnwellRCPLineDtl : LWRecMode
        BreakOn     : $$IsEndofList:$LWRecModes
        Vertical    : Yes
        Scroll      : Vertical
        Invisible    : Not @@IsSales

        [Line :LearnwellRCPLine]
            Fields : LearnwellRecFldTtl, LearnwellRecFldDtl,LearnwellRcBnk,LearnwellDateT,LearnwellInstr,LearnwellRcParty,LearnwellVCHT,LearnwellNarrT
             Border        : Thin Bottom         
            [Field : LearnwellRecFldTtl]
                Use            : Name Field
                Set As        : "Payment Mode "
                Skip        : Yes
                Width         : 10% Page
                Space Left    : 1% Page

            [Field : LearnwellRecFldDtl]
                Use            : Name Field
                Set As        : "Amount"
                Skip        : Yes
                Width         : 7% Page
				Space Left    : 1% Page
			[Field:LearnwellRcBnk]
				Use            : Name Field
                Set As        : "Bank/Cash Name"
                Skip        : Yes
                Width         : 10% Page
			[Field:LearnwellRcParty]
				Use            : Name Field
                Set As        : "Party Ledger"
                Skip        : Yes
                Width         : 10% Page
			[Field:LearnwellDateT]
				Use            : Name Field
                Set As        : "Date"
                Skip        : Yes
                Width         : 5% Page
			[Field:LearnwellVCHT]
				Use            : Name Field
                Set As        : "VoucherType"
                Skip        : Yes
                Width         : 7% Page
			[Field:LearnwellNarrT]
				Use            : Name Field
                Set As        : "Narration"
                Skip        : Yes
                Width         : 10% Page
			[Field:LearnwellInstr]
				Use            : Name Field
                Set As        : "Inst/Cheque No."
                Skip        : Yes
                Width         : 7% Page
        [Line : LearnwellRCPLineDtl]
            Fields : LearnwellRecFldDtl1, LearnwellRCPLineTotalDtl,LearnwellRcBnkdt,LearnwellDateD,LearnwellInstrD,LearnwellRcPartydt1,LearnwellRcPartydt,LWQuickVCD,LearnwellNarrD

            [Field : LearnwellRecFldDtl1]
                Use            : Name Field
                Storage     : LWRecModes
                Set As        : $LWRecModes
                Table        : RecModes
                ShowTable    : Always
                Key            : RecModes
                Width         : 10% Page
           
            [Field : LearnwellRCPLineTotalDtl]
                Use            : Amount Field
                Storage        : LWRecModemt
                Set As        : $LWRecModemt
                Set Always    : Yes
                Width         : 7% Page
                Inactive    : $$IsEndofList:$LWRecModes
                Skip        : If $$IsEndofList:$LWRecModes Then Yes Else No
                Border        : Thin Bottom
                Validate    : Not $$IsEmpty:$LWRecModemt
				
			[Field:LearnwellRcBnkdt]
				Type : String
				Table : LearnwellLedgerColl, EndOfList
				Storage :LWRecModebnk
				Use : Name Field
				Set always : Yes
				Show Table : Always
				Case : Title Case
				Width : 10% Page
				Align : Left
			
			[Field:LearnwellRcPartydt1]
				Type : String
				Table : LearnwellLedgerColl, EndOfList
				Storage :LedgerName
				Use : Name Field
				Set as:$PartyName
				Set always : Yes
				Show Table : Always
				Case : Title Case
				Width : 10% Page
				Align : Left
			[Field:LearnwellRcPartydt]
				Type : String
				Storage :LWRecModeparty
				Use : Name Field
				Set as:#LearnwellRcPartydt1
				Set always : Yes
				Width : 10% Page
				Align : Left
				Invisible: Yes
			[Field:LearnwellDateD]
				Type : Date
				Use : Short Date Field
				Storage : Date
				Width : @@ShortWidth
				Set as:$Date
				Width:5% Page
				Align : Left
			[Field:LWQuickVCD]
				Type : String
				Use : Name Field
				Set always : Yes
				Storage : LWQuickVCD
				Set as:"Receipt"
				Width:5% Page
				Align : Left
			[Field:LearnwellNarrD]
				Type : String
				Use : Name Field
				Storage : Narration
				Full Width : Yes
				Set as:"Being Amount Recived Against Inv No. " + $VoucherNumber
				Align : Left
				Width:10% Page
			[Field:LearnwellInstrD]
				Type : String
				Use : Name Field
				Storage : Instrument
				Width   : 7% Page
				Align : Left
				
        [Line : LearnwellRCPLineTotal]
            Fields       : InvLearnwellrec1, InvLearnwellrec2
           
            [Field : InvLearnwellrec1]
                Use            : Medium Prompt
                Set As        : "TOTAL : "
                Width         : 10% Page
                Space Left    : 1% Page
                Style        : Large Bold
               
            [Field : InvLearnwellrec2]
                Use            : Amount Field
                Width         : 7% Page
                Set As        : $$Total:LearnwellRCPLineTotalDtl
                Style        : Large Bold
                Set Always    : Yes
                ReadOnly     : Yes
                Control        : InvLearnwellrectotalcont : If $Amount = #InvLearnwellrec2 then No Else Yes
                Border        : Thin Bottom
				
[Collection: LearnwellLedgerColl]
Title : "List of Ledgers"
Type : Ledger
Belongs to : yes
Format : $Name,30
Align : Right
Full Height : Yes

;===WWW.LEARNWELLS.COM==;

[Button :CreateRecMode]
Key : Ctrl+M
Title : "Receipt Modes"
Action :Alter:RecModes
[#Form         :    Voucher]
    Add:Button:At End:CreateRecMode

[Report    : RecModes]
    Form    : RecModes
    Object    : Company
    Title    : "Receipt Mode"

[Form    : RecModes]
    FullHeight    : Yes
    Part        : RecModes

    [Part    : RecModes]
        Line    : RecModesMTLn, RecModesMLn
        Repeat    : RecModesMLn : RecModes
        BreakOn : $$IsEmpty:$RecModes
        Scroll    : Vertical

        [Line    : RecModesMTLn]
            Border    : Column Titles
            Field    : RecModesMTFld

            [Field    : RecModesMTFld]
                Use        : Name Field
                Set As    : "Payment Mode"
                Align    : Center

        [Line    : RecModesMLn]
            Field    : RecModesMFld

            [Field    : RecModesMFld]
                Use        : Name Field
                Storage    : RecModes
                Scroll  : Vertical

[Key : RecModes]
    Key     : Alt+C
    Action     : Alter : RecModes

;==www.learnwells.com==;
    [Collection    : RecModes]
            Type    : RecModes : Company
            ChildOf    : ##SVCurrentCompany
            Format    : $RecModes, 15,
             Collection : EndofList
            Title    : "Payment Mode"
			Fetch:LWRecModes 
			Fetch:LWRecModemt
    [Collection    : LWRecModes]
            Compute    : CLWRecModes     : $LWRecModes
            Compute    : CLWRecModemt  : $LWRecModemt
            Format    : $LWRecModes
            Format    : $LWRecModemt
			Fetch:LWRecModes 
			Fetch:LWRecModemt
	[Collection: LWRecMode]
	Title : "Bulk Payment Entry"
	Type : LearnWellQuickEntry : Company
	Child Of : ##SVCurrentCompany
    [System : UDF]
        RecModes                  : String : 3824
        LWRecModes            : String : 3825
        LWRecModemt        : Amount : 3826
		LWRecModebnk	:String:3828
		LWRecModeparty:String:3829
		Date:Date:3830
		LWQuickVCD:String:3831
		Narration : String:3832
		LWRecMode    : Aggregate : 3827
		LearnWellQuickEntry : Aggregate :3833
		Instrument : String :3835
		
	[System: UDF]
	LedgerName : String :3834
	[System: Variable]
	[Variable : LearnWellGETD]
	Type: Number
		
;;www.learnwells.com


[Function: LearnwellRecEntry]
Parameter : LearnWellVCGT : String : ##SVVoucherType
Variable : SVVoucherType : String
Variable : LWLDate : Date
Variable : LWLDrL : String
Variable : LWLCrL : String
Variable : LWLAMt : Amount
Variable : LWLNarr : String
Variable : LWLBnkt: String
Variable : LWLInst: String
Variable : LearnWellGETD : Number: 1
001 : Start Batch Post : 10
005 : START PROGRESS : ($$NumItems:LWRecMode) : "In process" : @@CmpMailName : "Voucher Creation in Process"
007 : WALK COLLECTION : LWRecMode
010 : SET : LWLDate : $$Date:$Date
010a : Set : LWLBnkt :""
015 : SET : LWLBnkt :$LWQuickVCD
020 : SET : LWLDrL : $LWRecModebnk
030 : SET : LWLCrL : $LWRecModeparty
040 : SET : LWLAMt : $$AsAmount:$LWRecModemt
045 : SET : LWLNarr : $Narration
046 : SET : LWLInst : $Instrument
050 : SET : SVViewName : $$SysName:AcctgVchView
060 : NEW OBJECT : Voucher
070 : SET VALUE : Date : ##LWLDate
080 : SET VALUE : VoucherTypeName :##LWLBnkt
080a : Log: #LWQuickVCD
090 : SET VALUE : Narration : $Narration
110 : INSERT COLLECTION OBJECT : AllLedgerEntries
120 : SET VALUE : Ledger Name : ##LWLCrL
140 : SET VALUE : IsDeemedPositive : "No"
141	: SET VALUE : Amount : ##LWLAMt
142 : INSERT COLLECTION OBJECT :BankAllocations
143 : SET TARGET: BankAllocations [1]
144	: SET VALUE :INSTRUMENTNUMBER:##LWLInst
145	: SET VALUE :INSTRUMENTDATE:##LWLDate
146	: Set Value : UniqueReferenceNumber : $$MakeTallyUniqueID
147 : Set Value : Name : $$MakeUniqueID
148 : Set Value : Payment Mode : "Transacted"
149 : SET TARGET : ..
150 : SET TARGET : ..
150a : LOG : $$String:##LWLDrL
160 : INSERT COLLECTION OBJECT : AllLedgerEntries
170 : SET VALUE : Ledger Name : ##LWLDrL
180 : SET VALUE : Amount : ##LWLAMt
190 : SET VALUE : IsDeemedPositive : "Yes"
191	: SET VALUE : Amount : ##LWLAMt * (-1)
200 : SET TARGET : ..
210 : SET VALUE : PersistedView : ##SVViewName
220 : CREATE TARGET
230 : INCREMENT : LearnWellGETD
230a : SHOW PROGRESS : ##LearnWellGETD
240 : END WALK
260 : END PROGRESS
280 : RETURN
290 : End Batch Post


[Function:WantReceipt]
20 : QUERYBOX : "Want to Create Receipt Entry Also?" : Yes:No
30 : If:$$LastResult
40 : Call: LearnwellRecEntry
;60 : MSGBox : "Status":"Receipt Successful"
65 : Return
70 : End If


Also checkout AutoBackup TDL for Tally Prime 3.0 and Tally Prime

How to Use Auto Receipt with Sales Entry TDL Code in Tally:

  • Copy above TDL code and create a text file.
  • Save text file and load in Tally (Method provided below the code)
  • Go to Tally voucher and Create a Sales voucher.
  • At Voucher end you will find Payment Mode Section.
  • Here Write all Receipt related details and save voucher.
  • After saving voucher there a Query box will show “You want to take receipt entries also?”, Press Yes.
  • Your sales voucher will be created along with receipt entries.

This is best free TDL to have in your Tally. It will support Tally Prime 3.0, Tally Prime, Tally ERP9, that can be use for lifetime. This free TDL Code will perfectly work with old Tally Prime also.

Auto Receipt with Sales Entry TDL Code Tally Usage Video:

See the below video to learn how to load tdl in tally and record receipt entries with sales invoice at invoicing time.

Watch above videos to learn :

  • How to record receipt when invoicing.
  • How to Load TDL files in Tally.
  • How to add different payment modes in Tally.
  • How to use Query Box after saving sales invoice.
  • How to add receipt other details.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/

FOLLOW BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\SalesTimeReceipt.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your Auto Receipt with Sales Entry TDL is ready to use.

Conclusion:

The “Auto Receipt with Sales Entry TDL” is a game-changer for Tally users who wish to streamline their invoicing and receipt recording processes. By automating receipt entries alongside sales invoicing, this TDL significantly reduces manual efforts, enhances accuracy, and improves overall productivity. Best of all, the TDL is available for lifetime use free of charge, making it a valuable tool for businesses of all sizes.

FAQ: Auto Receipt with Sales Entry TDL:

What is the “Auto Receipt with Sales Entry TDL”?

The “Auto Receipt with Sales Entry TDL” is a Tally Definition Language file designed to automate receipt entries while creating sales invoices in Tally. It streamlines outstanding clearances, enhances bill-to-bill payment matching, and ensures continuous bank and cash reconciliation.

Is the TDL compatible with Tally Prime 3.0, Tally Prime, and Tally ERP 9?

Yes, the “Auto Receipt with Sales Entry TDL” is compatible with Tally Prime 3.0, Tally Prime, and Tally ERP 9. It can be used across different versions of Tally to enhance your accounting efficiency.

How does the Auto Receipt with Sales Entry TDL simplify the receipt entry process?

By capturing receipt details at the time of creating sales invoices, the TDL eliminates the need for separate receipt entries. This results in streamlined outstanding clearance and ensures every sale is associated with its corresponding payment.

What are the benefits of recording receipt entries at sales time?

  1. Clear outstanding balances promptly, reducing the chance of funds getting stuck.
  2. Enable accurate bill-to-bill payment matching for transparent reconciliation.
  3. Maintain continuous bank and cash reconciliation for up-to-date financial records.

Can I customize the Auto Receipt with Sales Entry TDL to suit my business requirements?

As the TDL provides a section for payment modes, advanced users can customize it to align with their specific business needs. Customization allows businesses to tailor the TDL according to their preferred payment methods.

Can I still create manual receipt entries if needed?

While the TDL automates receipt entries, you can still create manual entries if required. The TDL provides a convenient automated option, but users retain the flexibility to input data manually whenever necessary.

Empower your Tally software with the “Auto Receipt with Sales Entry TDL” to simplify your accounting process, improve data accuracy, and streamline financial management. Enjoy the benefits of automated receipt recording and elevate your Tally experience to new heights!

Auto Backup TDL for Tally Prime 3.0

Amazing Auto Backup TDL for Tally Prime 3.0

In this blog post, we will learn about how to enable data backup with the help of Auto Backup TDL for Tally Prime 3.0, which eliminates the need for manual backups by automatically creating backups while opening or shutting a company data. Data security is important for any business; and Tally Prime 3.0, being a widely-used accounting software, must ensure that its users can protect their valuable financial data effortlessly. This TDL requires no additional settings and is easy to implement, providing a seamless experience for Tally users.

Understanding the Auto Backup TDL for Tally Prime 3.0 :

The Auto Backup TDL is a powerful extension to Tally Prime 3.0 that enhances data protection by automating the backup process. Once loaded into Tally, the TDL takes care of automatically creating backups of the company data every time it is opened or closed. This means that Tally will prompt users to create a backup every time they access a company, reducing the risk of data loss significantly.

The Convenience of No Additional Settings:

One of the most attractive features of the Auto Backup TDL for Tally Prime 3.0 is its user-friendly nature. Unlike other backup solutions that may require complex configurations, this TDL works seamlessly without any additional settings. By simply loading the TDL file into Tally Prime 3.0, users can enable the auto backup feature immediately. This simplicity is particularly beneficial for small businesses or users with limited technical knowledge, making data security accessible to all.

Auto backup tdl for Tally Prime 3.0

Auto Backup TDL for Tally Prime 3.0 TDL Code:

[System: Events]
TSPL Smp CmpLoadEvent2 : Load Company : NOT $$IsRemoteCompany : Call : Backup Function
TSPL Smp CmpCloseEvent : Close Company : NOT $$IsRemoteCompany : Call : Backup Function

[Function: Backup Function]
Variable : Backup Det Var: String
00 : IF : ##EnableAutoBackup
10 : IF : ##AutoBackupPrompt
20 : QUERYBOX : "Backup Company ?" : Yes:No
30 : IF : $$LastResult
40 : CALL : Backup Company
50 : ENDIF
60 : ELSE :
70 : CALL : Backup Company
80 : ENDIF
90 : ENDIF

[Function: Backup Company]
10 : SET : BackupDetVar : @@DestPath + ", " + ##SVCurrentPath + ", " + ##SVCurrentCompany + +
", " + @@CoNumber
20 : BACKUP COMPANY : "," : ##BackupDetVar
30 : SET : SVBackupPath : @@DestPath
;;www.learnwells.com
[System: Formula]
DestPath : ##DestinationPath + "\" + @@DateForm + "\" + @@TimeForm
CoNumber : $$String:($CompanyNumber:Company:##SVCurrentCompany):5
DateForm : $$String:$$MachineDate
TimeForm : @@HrsForm + @@MtsForm
HrsForm : If $$StringPart:$$MachineTime:0:2 CONTAINS ":" +
Then $$StringPart:$$MachineTime:0:1 +
Else $$StringPart:$$MachineTime:0:2
MtsForm : if $$StringPart:$$MachineTime:0:2 CONTAINS ":" +
Then $$StringPart:$$MachineTime:2:2 +
Else $$StringPart:$$MachineTime:3:2
;www.learnwells.com
[Variable: EnableAutoBackup]
Type : Logical
Persistent : Yes
[Variable: DestinationPath]
Type : String
Persistent : Yes
[Variable: AutoBackupPrompt]
Type : Logical
Persistent : Yes
[System: Variable]
EnableAutoBackup: Yes
DestinationPath : "C:\Users\ssonu\Files\Autobackup"
AutoBackupPrompt: Yes
;;www.learnwells.com
 

Also checkout Voucher Modification TDL for Tally Prime

HOW TO USE TDL CODE:

  • Copy above TDL code and create a text file.
  • Save text file and load in Tally (Method provided below the code)
  • Change destination path in TDL code. (Watch below video for more details)
  • Go to shut a company or open a new company.
  • Your Tally will ask to take backup of company.
  • Press Yes to generate backup or Press No to back to the company.
  • Your backup will be created at specified path with date and time.

This is best free TDL to have in your Tally. Tally Prime 3.0 that can use it for lifetime. This free TDL Code will perfectly work with old Tally Prime also.

Auto Backup TDL for Tally Prime 3.0 Video:

See the below video to learn how to load tdl in tally and take auto backup of companies data.

Watch above videos to learn :

  • How to change backup path in Autobackup TDL file
  • How to Load TDL files in Tally.
  • How to take backup of companies after loading Auto backup TDL in Tally Prime
  • How to See Backup Data with date and Time.
  • How to restore backup in Tally Prime 3.0
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/

FOLLOW BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\autobackup.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your Autobackup TDL for Tally Prime 3.0 is ready to use.

Conclusion:

Data security is a top priority for businesses, and the Auto Backup TDL for Tally Prime 3.0 is a game-changer in ensuring the protection of financial data. With its simplicity and efficiency, this TDL allows users to enable automatic backups without any complex configurations. By loading the TDL file into Tally Prime 3.0, users can rest assured that their company data will always be safeguarded, minimizing the risk of data loss.

Incorporating the Auto Backup TDL into Tally Prime 3.0 is a proactive step towards securing vital financial information. Whether you are a small business owner or a seasoned accounting professional, the Auto Backup TDL is a must-have addition to Tally Prime 3.0 for enhanced data security. So, make the smart choice today and ensure your valuable data is always protected with this innovative Auto Backup TDL!

FAQ – Auto Backup TDL for Tally Prime 3.0:

What is the Auto Backup TDL for Tally Prime 3.0?

The Auto Backup TDL for Tally Prime 3.0 is an extension for Tally Prime 3.0, designed to automate the backup process of company data. It creates backups automatically when you open or shut down a company in Tally, ensuring the security and integrity of your financial data.

How does the Auto Backup TDL for Tally Prime 3.0 work?

Once the Auto Backup TDL is loaded into Tally Prime 3.0, it monitors the actions of opening or closing a company data. When you access a company or close it, the TDL automatically triggers the backup process, prompting you to save a backup file.

Do I need to configure the Auto Backup TDL for Tally Prime 3.0 after installation?

No, the Auto Backup TDL is designed for simplicity. Once you load the TDL file into Tally Prime 3.0, it starts working without any additional settings. This user-friendly feature makes data security accessible to all Tally users.

What are the benefits of using the Auto Backup TDL?

The Auto Backup TDL simplifies data security in Tally Prime 3.0. Its key benefits include:

  1. Automatic backups on company data startup and shutdown.
  2. No need for manual backup creation; the TDL handles it for you.
  3. User-friendly and requires no complex configurations.
  4. Reduces the risk of data loss due to system crashes or power failures.

Is the Auto Backup TDL compatible with Tally Prime 3.0 only?

The Auto Backup TDL is specifically designed for Tally Prime 3.0 but you can use it for old Tally Prime also. It may not be compatible with other accounting software.

Can I customize the Auto Backup TDL for Tally Prime 3.0 according to my business needs?

Yes, the Auto Backup TDL allows customization to suit your specific backup requirements. Advanced users can modify the TDL to align with their business data protection strategies.

Does the Auto Backup TDL for Tally Prime 3.0 replace regular manual backups?

While the Auto Backup TDL automates the backup process, it is still recommended to create manual backups periodically, especially before performing critical operations or system updates.

Is the Auto Backup TDL suitable for large enterprises with vast data sets?

Yes, the Auto Backup TDL for Tally Prime 3.0 can benefit businesses of all sizes. However, for large enterprises.