Breaking

EXCEL TO TALLY - AUTOMATION 10.0 | BEST EXCEL TO TALLY DATA TRANSFER UTILITY | EXCEL TO TALLY PRIME IMPORT | EXCEL TO TALLY ERP9 IMPORT

This is Excel to Tally Automationto automate your Data Entry with Tally. It is very helpful to import Excel Datainto Tally, easy and quickly...

Tuesday, 9 February 2021

Last Purchase Rate Notification for Every Item | Tally TDL Free Code


We sale product and go to invoice for customer and forgot purchase rate of item and put wrong amount in sale bill. Oh! that's horrible thing stop it. Yes now we can stop inputting  wrong selling price with this Tally Prime and Tally ERP 9 free TDL code. This TDL code will notify for purchase rate of item when goto sell.

We can modify this TDL code according to our need. We can add some additional fields, we can remove extra fields, and it is very simple to work with Tally Erp9 and Tally Prime. Best simple code for Last purchase rate notification.

HOW TO USE:

        1. Load below Tally Prime rate notification TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go for invoicing , when you select item and go for enter rate detail it will popup a last purchase rate of item.
      3. Now we can prevent wrong invoicing with this TDL code. 


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 work in all Tally versions. for more detail watch above Video.

TDL Code : 

[#Field:VCHBatchRate]
On:Focus:Yes:Set:LstPurRate:$$Number:$LastPurcPrice:StockItem:#VCHStockItem
Notify:MSGNotice:@@IsSales
[System:Formula]
MSGNotice:$LastPurcPrice:StockItem:#VCHStockItem

[#Field:VCHBatchRateUnits]
On:Focus:Yes:Set:LstSaleRate:$$Number:$LastSalePrice:StockItem:#VCHStockItem
Notify:MSGNotice:@@IsSales
[System:Formula]
MSGNotice:$LastSalePrice:StockItem:#VCHStockItem



HOW TO UPLOAD ABOVE CODE IN TALLY:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as - C:\Users\HP\Desktop\rec\Party Detail.txt)
4. Open Tally ERP9  OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup - Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

No comments:

Post a Comment