Full Detailed Item History TDL at Invoice Time | 2021 Best Tally Prime and Tally ERP 9 TDL for Invoicing

by
with one comment
Tally Prime TDLTDL 2021TDL for Tally
Rate this post

 

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.

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

 
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
HOW TO USE:

        1. Load below Item History  TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go for invoicing and select item and Press Alt+H to see item full history

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 :
1. How to add extra fields and lines in voucher of tally.
2. How to add Collections for vouchers
3. And Many More…….

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 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:UsersHPDesktoprecParty 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.


ALSO CAN DOWNLOAD WITH BELOW BUTTON:


Tags: No tags