[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 – Yes7. Paste The path in blank space8. Press enter and save
Now your TDL is ready to use.
ALSO CAN DOWNLOAD WITH BELOW BUTTON: