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.
TDL code:
[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[1].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[1].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
![](https://secureservercdn.net/192.169.221.188/8nr.7d3.myftpupload.com/wp-content/uploads/2022/06/Sdfv.jpg)
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…….
2023 Best Trick to Create Own Unlimited High Quality AI images
With this trick we will create Unlimited High Quality AI images, with the help of google colab. Artificial intelligence (AI) has revolutionized the way we create and consume content. With the help of AI, it is now possible to create unlimited high-quality images in a matter of minutes. In this blog post, we will show…
Ultimate Ecommerce Reconciliation
With 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: Other benefits…
2023 Best Tally TDL to See Party Wise and Product Wise Sale Report
This 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 software used…