Blog

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:

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\Business Summary.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 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…….