This Item Sales Summary TDL will help you a lot to see Items summary with there GST details, HSN, Quantity, Average Rates, Closing etc.
Tally Prime 3.0, the latest iteration of the Tally Business software, brings a host of powerful features to streamline business operations. One standout addition is the Item Sales Summary TDL – a free Tally Prime TDL File that empowers users to gain deeper insights into their sales performance.
In this blog post, we’ll explore the significance of this Item Sales Summary TDL and how it can revolutionize your Tally Prime experience.
Item Sales Summary TDL:
The Item Sales Summary TDL is a custom Tally TDL file designed specifically for Tally Prime 3.0 users. It provides a comprehensive overview of item-wise sales, enabling businesses to make informed decisions based on detailed sales data.
Item Sales Summary TDL Code:
The TDL seamlessly integrates with Tally Prime 3.0, ensuring a smooth transition into your existing workflow.
Also checkout Daily Auto Reminder TDL with Image
[#Menu : Gateway of Tally]
Item : Item Sales Summary : Display :LearnwellItemSumm
[Report :LearnwellItemSumm]
Form :LearnwellItemSumm
Variable : SVFromDate,SVToDate
Set : SVFromDate : $$MonthStart:##SVFromdate
Set : SVToDate : $$MonthEnd:##SVFromdate
[Form :LearnwellItemSumm]
Part : LWSummTitle,LWSummItemTitle,LWSummItemDetail
Button : Change Period,Print Button,Export Button
Bottom Part : LWSummItemDetailBTM
Background :White
[Part : LWSummTitle]
Line :LWSummTitle
[Line :LWSummTitle]
Field : Simple Field
Local : Field : Simple Field : Set As : "Item Sales Summary for" + $$String:##SVFromDate +" to " + $$String:##SVToDate
Local : Field : Simple Field : Style : Normal Bold
[Part : LWSummItemTitle]
Use : LWSummItemDetail
Delete : Repeat
Delete : Scroll
Border : ColumnTitles
Local : Field : Default : Type : string
Local : Field : LWSummItemDetailItem : Set As : "Particulars"
Local : Field : LWHsn : Set As : "HSN Code"
Local : Field : LWGstperc : Set As : "GST Rate"
Local : Field : LWQtyTTl: Set As : "Sales Qty"
Local : Field : LWItmRate : Set As : "Avg. Rate"
Local : Field : LWAmtTTl : Set As : "Sales Value"
Local :Field : Default : Style : Small Bold
[Part :LWSummItemDetail]
Line : LWSummItemDetail
Repeat : LWSummItemDetail :LWCollSalesItems
Scroll : Vertical
Total : LWQtyTTl,LWAmtTTl
[Line :LWSummItemDetail]
Field : LWSummItemDetailItem,LWHsn,LWGstperc
Right Field : LWQtyTTl,LWItmRate,LWAmtTTl
Border : Thin bottom
[Field : LWSummItemDetailItem]
Set As : $Stockitem
Style : Small
Display : Item Monthly Summary
Variable : StockitemName
[Field : LWHsn]
Use: Name Field
Set as:$(Stockitem,$stockitem).GstDetails[Last].hsncode
Width:10
Align: Center
Set Always: Yes
Skip: Yes
[Field : LWGstperc]
Use: Number Field
Set as:$(Stockitem,$stockitem).GSTDetails[First].StatewiseDetails[1, @@IsAnyState].RateDetails[1, @@IsIGST].GSTRate
Format: Percentage
Width:10
Align: Center
Set Always: Yes
Skip: Yes
[Field : LWQtyTTl]
Use : Qty Primary Field
Style : Small
Set As : $BilledQtyToT
[Field : LWItmRate]
Use : Rate Price Field
Set as : $AmountToT / $BilledQtyToT
Style : Small
[Field : LWAmtTTl]
Use : Amount Field
Set As : $AmountToT
Style : Small
[Part : LWSummItemDetailBTM]
Use : LWSummItemDetail
Delete : Repeat
Delete : Scroll
Delete : Total
Border : Totals
Local : Field : LWSummItemDetailItem : Set As : "Total"
Local : Field : LWQtyTTl: Set As : $$Total:LWQtyTTl
Local : Field : LWAmtTTl : Set As : $$Total:LWAmtTTl
Local :Field : Default : Style : Small Bold
[Collection : LearnwellItemSummcoll]
Type : Vouchers : VoucherType
Child of : $$VchTypeSales
Belongs to : yes
Fetch : Date,Inventory Entries
[Collection : LWCollSalesItems]
Source Collection : LearnwellItemSummcoll
Walk : Inventory Entries
By : Stockitem : $StockitemName
Aggr Compute : BilledQtyToT : Sum : $BilledQty
Aggr Compute : AmountToT : Sum : $Amount
Item Sales Summary TDL:
HOW TO USE TDL CODE:
- Copy above TDL code and create a text file.
- Save text file and load in Tally (Method provided below the code)
- Go to Tally Main Screen and in Gateway of Tally find Item Sales Summary Tab .
- From item Sales Summary Tab you can see Item summary with there GST details.
This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.
Item Sales Summary TDL Video:
See the below video to learn how to use Item sales summary TDL in Tally Prime 3.0:
Watch above videos to learn :
- How to use TDL files in Tally.
- How to see item wise sales summary report.
- How to use item sales summary tdl in tally prime 3.0
- More videos related to free TDL files on youtube/learnwell
- Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
- Make a Text file of above code
- Save it in to your computer
- Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\salesummary.txt)
- Open Tally Prime Software
- Click on Help and click on TDL & Addon (for Tally Prime)
- Press F4 (to open a Box)
- Set Load TDL file on Startup – Yes
- Paste The path in blank space
- Press enter and save
- Now your item sales summary TDL for Tally Prime is ready to use.
The Item Sales Summary TDL for Tally Prime 3.0 is a game-changer for businesses seeking to gain a deeper understanding of their sales performance. Its ability to provide detailed item-wise sales data not only facilitates informed decision-making but also enhances inventory management strategies.