Sometime when we do accounting and create invoices of customer, there is lots of things to do in an invoice. We need to check customer all details like, there products, GST, Discount, Selling price, purchase price etc. When customer come to you and told that last time you provided this discount and product price was different, then you go to check there previous details and tell customer the truth that the price and discount was this. If we use Tally then these things become smooth, because of Tally TDL (Tally Definition Language). With TDL file we can fetch customer last purchase rate and item discounts. And at the same invoicing time we can check party last purchase rate and there discounts.
So today have something special for your Tally. With this Tally TDL we can track customer or Ledger wise last rate and item discounts and can set it automatically in invoice. After adding this Automatic Last Rate and Last Discount Ledger Wise and Item Wise TDL we can solve all our problems related to customer.If you use Tally Prime or Tally ERP9, this Automatic Last Rate and Last Discount Ledger Wise and Item Wise TDL will help to create invoice correctly . And always this will help to remember customer discounts and there item prices.
This is must have Tally TDL for Tally Prime and Tally ERP9.With this Free Tally Prime TDL, Now we can create invoice correctly without any fail.
[Collection: LearnwellAutoSV] Type : Vouchers : VoucherType Child Of : $$VchTypeSales Belongs To : Yes Fetch : Date, VoucherTypeName, LedgerName, Voucher Number, Amount,DISCOUNT, MasterID, LedgerEntries.BillAllocations.* [Collection: LWcollRT] Source Collection : LearnwellAutoSV Walk : InventoryEntries By : MasterID : $..MasterID Compute : LedgerName : $..PartyLedgerName Compute : VoucherNumber : $..VoucherNumber Compute : Amount : $Amount Compute : Rate : $Rate Compute : DISCOUNT :$DISCOUNT Compute : ItemName : $StockItemName Sort : @@Default : -$VoucherNumber Search Key : $LedgerName+$ItemName ;www.learnwells.com [#Field: VCH batch Rate] Delete: Set By Condition Delete: Set as Delete: Inactive add:Set As :($$AsRate:$$CollectionFieldByKey:$Rate:@StkPartyRt:LWcollRT) StkPartyRt:($LedgerEntries.LedgerName+$StockItemName) Set Always : yes [#Field: VCH batch discount] Delete: Set By Condition Delete: Set as Delete: Inactive add:Set As :($$AsRate:$$CollectionFieldByKey:$DISCOUNT:@StkPartyRt:LWcollRT) StkPartyRt:($LedgerEntries.LedgerName+$StockItemName) Set Always : yes
How to use above TDL Code:
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
- Make a Text file of above code
- Save it in to your computer
- Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Business Summary.txt)
- Open Tally Prime Software
- Click on Help and click on TDL & Addon (for Tally Prime)
- Press F4 (to open a Box)
- Set Load TDL file on Startup – Yes
- Paste The path in blank space
- Press enter and save
- Now your Auto Last sale rate with Auto last discount TDL is ready to use
HOW TO SEE RESULT IN TALLY:
- Go to Sales Voucher for invoicing.
- Now we can see previous sale amount and discount % automatic fetches as per ledger.
This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. This free TDL Code will perfectly work with Tally Prime.
Watch above video to learn :
- How to add own fields and lines in Tally
- How to alter Tally field section.
- How to Modify Item details in invoice.
- And Many More…….
Ultimate Ecommerce Reconciliation
Spread the loveWith this automatic Ultimate Ecommerce Reconciliation utility we can reconcile all type E-commerce platforms (Amazon, Flipkart, Meesho, Myntra etc.) sales with there payments. We can reconcile all data order wise and stock item wise with one click. Also try Excel to Tally Ultimate Ecommerce Import This Ultimate Ecommerce Reconciliation utility has below features: … Read more
2023 Best Tally TDL to See Party Wise and Product Wise Sale Report
Spread the loveThis Tally TDL to See Party Wise and Product Wise Sale Report will help to see which item you sold more and which item you sold less. And same also can see which customer buy which items more and which customer buy which item less. We all know Tally is a popular accounting … Read more
7 Most Innovative Business Ideas (2023) You Can Start with Rs. 1 Lakh | 7 Best Businesses That Can be Started in 1 Lakh
Spread the loveStarting a business can be a daunting task, especially if you don’t have a lot of money to invest. But don’t let that discourage you. You need capital, an idea, and most importantly, the willingness to take risks and make mistakes. If you have the necessary resources, Rs. 1 lakh can be enough … Read more