Blog

We always need something special that solve all our problems and create all things in simple way according to our need. Same things we required when invoicing in Tally. When we select any item in Tally invoice we need to see it’s history of sales and purchase with all details. Like when this item was purchased or sold, who was the customer, Date, item rate, quantity,discount etc.. Everything we need to know about that item.

So today I have special full detailed item history TDL at invoice time for your Tally Prime and Tally ERP9.

With this free TDL code we can see Invoice number, Date, voucher type, Party Detail, Item Rate, Discount, Amount, Godown etc. in One place.

Load TDL file in Tally ERP9 or in Tally Prime, then go for invoicing , select item and press Alt+H to see full history of stock item with Sales, Purchase, Debit and Credit Note History.

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 tdl code to make see full Item History Detail.

TDL Code:

[Collection : Learnwellscom]
    Type     : Vouchers : Stock Item
    Child Of : $$BaseOwner:#VchStockItem
    Filter   : SalesFilter 
    Fetch	: LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName
[System : Formula]
    LearnWellStock      : $StockItemName = $$BaseOwner:#VCHStockItem
    SalesFilter : $$IsSales:$VoucherTypeName
	PurchaseFilter : $$IsPurchase:$VoucherTypeName
	CreditNoteFilter : $$IsCreditNote:$VoucherTypeName
	DebitNoteFilter : $$IsDebitNote:$VoucherTypeName
[#Field : VCH StockItem]
    Key : LWItemLWHs
[Key : LWItemLWHs]
    Key : Alt+H
    Action : Display : LearnWellIH
	
[Report : LearnWellIH]
	Title:"www.Learnwells.com-Item_History"
    Form : LearnWellIHform
      
[Form : LearnWellIHform]
	Part : LWSalesH,LWPurchaseH,LWCRNH,LWDRNH
	Buttons  : ChangeCompany, ChangeDybkDate, ChangePeriod
	Buttons: PrintButton, ExportButton
	

[Part : LWSalesH]
	Line   : LWSalesLWHsTitle, LWSalesLWHsHD, LWSalesLWHsData
	Repeat : LWSalesLWHsData : Learnwellscom
	Scroll : Vertical
	Common Border	: Yes
	Bottom Line	: LW Total
	Total: LWNSalesLWHs3,LWNSalesLWHs4,LWNSalesLWHs5,LWNSalesLWHs6
	

[Line : LWSalesLWHsTitle]
	Field : LearnWellStkItem
	Fixed : Yes
	Option : alter on enter
	Border:thin top

[Field : LearnWellStkItem]
	Use        : Short Name Field
	Set As     : "History of : " + #VCHStockItem
	Full Width : Yes
	Align      : Centre        
	
[Line : LWSalesLWHsHD]
	Use : LWSalesLWHsData
	Local : Field : Default : Type : String
	Local : Field : LWNSalesLWHs0 : Set As : "Voucher Type"
	Local : Field : LWNSalesLWHs1 : Set As : "Invoice No"
	Local : Field : LWNSalesLWHsDt: Set As : "Date"
	Local : Field : LWNSalesLWHs2 : Set As : "Party Name"
	Local : Field : LWNSalesLWHs3 : Set As : "Qty"
	Local : Field : LWNSalesLWHs4 : Set As : "Rate"
	Local : Field : LWNSalesLWHs5 : Set As : "Discount"
	Local : Field : LWNSalesLWHs6 : Set As : "Amount"
	Local : Field : LWNSalesLWHs7 : Set As : "Godown"
	Border : Column Titles
	
[Line : LWSalesLWHsData]
	Field : LWNSalesLWHs1,LWNSalesLWHs0,LWNSalesLWHsDt, LWNSalesLWHs2,
	Right Field : LWNSalesLWHs3, LWNSalesLWHs4, LWNSalesLWHs5, LWNSalesLWHs6,LWNSalesLWHs7
	Local : Field : LWNSalesLWHs0 : Set As : $VoucherTypeName
	Local : Field : LWNSalesLWHs1 : Set As : $VoucherNumber
	Local : Field : LWNSalesLWHsDt: Set As : $Date
	Local : Field : LWNSalesLWHs2 : Set As : $PartyLedgerName
	Local : Field : LWNSalesLWHs3 : Set As : $$FilterValue:$BilledQty:InventoryEntries:1:LearnWellStock 
	Local : Field : LWNSalesLWHs4 : Set As : $$FilterValue:$Rate:InventoryEntries:1:LearnWellStock 
	Local : Field : LWNSalesLWHs5 : Set As : $$FilterValue:$discount:InventoryEntries:1:LearnWellStock 
	Local : Field : LWNSalesLWHs6 : Set As : $$FilterValue:$Amount:InventoryEntries:1:LearnWellStock 
	Local : Field : LWNSalesLWHs7 : Set As : $$FilterValue:$BatchAllocations[1].GodownName:InventoryEntries:1:LearnWellStock 
	Explode : LearnWellHData : $$FilterCount:InventoryEntries:LearnWellStock  -1 > 0
	Border	: Thin Bottom
	

[Part : LearnWellHData]
	Line : LWSalesLWHsData1
	Repeat : LWSalesLWHsData1 : InventoryEntries
	

[Line : LWSalesLWHsData1]
	Field : LWNSalesLWHs1,LWNSalesLWHs0,LWNSalesLWHsDt, LWNSalesLWHs2 
	Right Field : LWNSalesLWHs3, LWNSalesLWHs4, LWNSalesLWHs5, LWNSalesLWHs6,LWNSalesLWHs7
	Local : Field : LWNSalesLWHs0 : Set As : $$Owner:$VoucherTypeName
	Local : Field : LWNSalesLWHs1 : Set As : $$Owner:$VoucherNumber
	Local : Field : LWNSalesLWHsDt: Set As : $$Owner:$Date
	Local : Field : LWNSalesLWHs2 : Set As : $$Owner:$PartyLedgerName
	Local : Field : LWNSalesLWHs3 : Set As : $BilledQty
	Local : Field : LWNSalesLWHs4 : Set As : $Rate
	Local : Field : LWNSalesLWHs5 : Set As : $Discount
	Local : Field : LWNSalesLWHs6 : Set As : $Amount
	Local : Field : LWNSalesLWHs6 : Set As : $BatchAllocations[1].GodownName
	Empty if : NOT @@LearnWellStock   OR $$ItemSerial=0 
	Border	: Thin Bottom 

[Field : LWNSalesLWHs0]
	Use : Short Name Field    
	Align: Center 
	border:thin left Right
[Field : LWNSalesLWHs1]
    Use : Short Name Field    
	Width:10
    Align:Right
	border:thin left Right 
[Field : LWNSalesLWHsDt]
    Use : Date Field    
	Width:10
	Align:Right
	border:thin Right
[Field : LWNSalesLWHs2]
    Use : Name Field
	Width: Full Width
	Indent : 1
    Variable	: ledgername
	Display		: Voucher
	QuickSearch : Yes
[Field : LWNSalesLWHs3]
    Use : Qty Field
	Align : Right
[Field : LWNSalesLWHs4]
    Use : Rate Price Field
	Width: Full Width 
	Indent : 2
[Field : LWNSalesLWHs5]
    Use : Number Field
    Align : Right
    Format : "Percentage"
	border:thin left Right
	Width:5
[Field : LWNSalesLWHs6]
    Use : Amount Field
	border:thin Right
[Field : LWNSalesLWHs7]
    Use : Name Field
	border:thin Right
	
[Collection : Learnwellscom1]
    Type     : Vouchers : Stock Item
    Child Of : $$BaseOwner:#VchStockItem
    Filter   : PurchaseFilter 
    Fetch	: LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName
[Part :LWPurchaseH]
	Line   : LearnWPLWHsHD, LearnWPLWHsData
	Repeat : LearnWPLWHsData : Learnwellscom1
	Scroll : Vertical
	Bottom Line	: LW Total
	Total: LWNSalesLWHs3,LWNSalesLWHs4,LWNSalesLWHs5,LWNSalesLWHs6
[Line: LearnWPLWHsHD]
	Use: LWSalesLWHsHD	
[Line: LearnWPLWHsData]
	Use: LWSalesLWHsData
[Line:LW Total]
Use : LWSalesLWHsData
Local : Field : LWNSalesLWHs2: Set As : " Total"
Local : Field : LWNSalesLWHs3 : Set As : $$Total:LWNSalesLWHs3 
Local : Field : LWNSalesLWHs6  : Set As : $$Total:LWNSalesLWHs6
Border	: Thin top 

[Collection : Learnwellscom2]
    Type     : Vouchers : Stock Item
    Child Of : $$BaseOwner:#VchStockItem
    Filter   : CreditNoteFilter 
    Fetch	: LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName
[Part :LWCRNH]
	Line   :LearnWCrLWHsHD, LearnWCrLWHsData
	Repeat : LearnWCrLWHsData : Learnwellscom2
	Scroll : Vertical
	Bottom Line	: LW Total1
	Total: LWNSalesLWHs3,LWNSalesLWHs4,LWNSalesLWHs5,LWNSalesLWHs6
[Line: LearnWCrLWHsHD]
	Use: LWSalesLWHsHD	
[Line: LearnWCrLWHsData]
	Use: LWSalesLWHsData
[Line:LW Total1]
Use : LWSalesLWHsData
Local : Field : LWNSalesLWHs2: Set As : " Total"
Local : Field : LWNSalesLWHs3 : Set As : $$Total:LWNSalesLWHs3 
Local : Field : LWNSalesLWHs6  : Set As : $$Total:LWNSalesLWHs6
Border	: Thin top 

[Collection : Learnwellscom3]
    Type     : Vouchers : Stock Item
    Child Of : $$BaseOwner:#VchStockItem
    Filter   : DebitNoteFilter 
    Fetch	: LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName
[Part :LWDRNH]
	Line   : LearnWDrLWHsHD, LearnWDrLWHsData
	Repeat : LearnWDrLWHsData : Learnwellscom3
	Scroll : Vertical
	Bottom Line	: LW Total2
	Total: LWNSalesLWHs3,LWNSalesLWHs4,LWNSalesLWHs5,LWNSalesLWHs6
[Line: LearnWDrLWHsHD]
	Use: LWSalesLWHsHD	
[Line: LearnWDrLWHsData]
	Use: LWSalesLWHsData
[Line:LW Total2]
Use : LWSalesLWHsData
Local : Field : LWNSalesLWHs2: Set As : " Total"
Local : Field : LWNSalesLWHs3 : Set As : $$Total:LWNSalesLWHs3 
Local : Field : LWNSalesLWHs6  : Set As : $$Total:LWNSalesLWHs6
Border	: Thin top 

How to use Item detailed history TDL code:

HOW TO USE TDL CODE:

• Copy above TDL code and make a text file.
• Save text file then load in Tally Prime (Method provided below the code)
• Now go to generate invoice and select item and and press ctrl+H to see item history.
• In item history you will find Sales and Purchase details of item with there Date, Party Name, Voucher type, Invoice number, item rate, item discount, quantity, godown etc. everything in one place.

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.

How to use Item history TDL video:

Watch above video to learn :

• How to add see item full history tdl.
• How to load tdl code in Tally prime and how to use Tally shortcut button for item history TDL.

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\itemhistory.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 Item full history TDL is ready to use