free code :- Items wise Sales summary

Code :-

Code:

#Menu : Gateway of Tally]
    Item : Sales Summary - Item wise : Display : My SalesSummary
    [Report :My SalesSummary]
    Form :My SalesSummary
    Variable : SVFromDate,SVToDate
    Set : SVFromDate : $$MonthStart:##SVFromdate
    Set : SVToDate : $$MonthEnd:##SVFromdate
    [Form :My SalesSummary]
        Part : MyReportTitle,My SalesSummaryTL,My SalesSummary
        Button : Change Period,Print Button,Export Button
        Bottom Part  : My SalesSummaryBTM
        Background  : @@SV_UNYELLOW
        [Part : MyReportTitle]
            Line :MyReportTitle
            [Line :MyReportTitle]
                Field : Simple Field
                Local : Field : Simple Field : Set As : "Sales Summary - Item wise from " + $$String:##SVFromDate +" to " + $$String:##SVToDate
                Local : Field : Simple Field : Style : Normal Bold
        [Part : My SalesSummaryTL]
            Use : My SalesSummary
            Delete : Repeat
            Delete : Scroll
            Border : ColumnTitles
            Local : Field : Default : Type : string
            Local : Field : My SalesSummaryItem : Set As : "Particulars"
            Local : Field : MyItemsSalesQty: Set As : "Sales Qty"
            Local : Field : MyItemsSalesRate : Set As : "Avg. Rate"
            Local : Field : MyItemsSalesAmount : Set As : "Sales Value"
            Local :Field : Default : Style : Small Bold
        [Part :My SalesSummary]
            Line : My SalesSummary
            Repeat : My SalesSummary :MySalesItems
            Scroll : Vertical
            Total : MyItemsSalesQty,MyItemsSalesAmount
            [Line :My SalesSummary]
                Field : My SalesSummaryItem
                Right Field : MyItemsSalesQty,MyItemsSalesRate,MyItemsSalesAmount
                Border : Thin bottom
                [Field : My SalesSummaryItem]
                    Set As : $Stockitem
                    Style : Small
                    Display : Item Monthly Summary
                    Variable  : StockitemName
                [Field : MyItemsSalesQty]
                    Use : Qty Primary Field
                    Style : Small
                    Set As : $BilledQtyToT
              [Field : MyItemsSalesRate]
                    Use : Rate Price Field
                    Set as : $AmountToT / $BilledQtyToT
                    Style : Small
                [Field : MyItemsSalesAmount]
                    Use : Amount Field
                    Set As : $AmountToT
                    Style : Small
[Part : My SalesSummaryBTM]
            Use : My SalesSummary
            Delete : Repeat
            Delete : Scroll
            Delete : Total
            Border : Totals
            Local : Field : My SalesSummaryItem : Set As : "Total"
            Local : Field : MyItemsSalesQty: Set As : $$Total:MyItemsSalesQty
            Local : Field : MyItemsSalesAmount : Set As : $$Total:MyItemsSalesAmount
            Local :Field : Default : Style : Small Bold
[Collection : MySalesSummaryCollection]
        Type : Vouchers : VoucherType
        Child of : $$VchTypeSales
        Belongs to : yes
        Fetch  : Date,Inventory Entries
[Collection : MySalesItems]
    Source Collection : MySalesSummaryCollection
    Walk : Inventory Entries
    By : Stockitem    :    $StockitemName
    Aggr Compute : BilledQtyToT : Sum : $BilledQty
    Aggr Compute : AmountToT  : Sum : $Amount

 

[#Menu : Gateway of Tally]

add this line 1st

 

Missing '[' in first line

 

very very small correction this code due to typing mistake

 

thank you for providing this..

 

Get no information data of item wise sale with this code.
Only Blank Screen.

 

pl check your data

 

Good Report,
Now please help me
and make program to bank payment sheet

 

Great

 

good report. Useful to sales people

 

how can we get date butoon in this report

 

thank u sir

 

Very nice addon. Thanx.

 

Dear Psjain_jal and Experts,
Very Good tdl, but not getting Quantity Total at Bottom Line. plz. check.
Thanks

 

;; Aggr Compute : BilledQtyToT : Sum : $BilledQty
;; Aggr Compute : AmountToT : Sum : $Amount


;;Compute : BilledQtyToT : Sum : $BilledQty
;;Compute : AmountToT : Sum : $Amount

This codes not working in my tally 9 2.14 version please do the needful

 

Great Sir,
Can we have Stock Group and Godwon Wise Item Sale Summay

 

I am very happy to see this report but how can i get
Items wise Sales Order summary.
Can any body help me?

 

yes you can create as you want...!!!

 

instead of Child of : $$VchTypeSales put Child of : $$VchTypeSalesorder

 

Dear Aaradhya,

Its working Thanks.

Manish

 

what code should be added to do in condensed/detailed formed on main screen ?

 

Hello!

I have a distribution business and I am looking for a similar report in my tally.

Can you help me how to use a code to get the desired report?

Thanks

 

hello !
how to create collection list by date, bill no.,party name, invoice amount