SALES SUMMARY WITH STOCK ITEMS

Discussion in 'Free Source Codes' started by sseema, Dec 29, 2019.

         
  1. sseema

    sseema Member


    upload_2019-12-29_12-5-23.png

    [#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
     
    Ramesh Chittapragada likes this.



  2. same I need group with item explode on same voucher
     


Share This Page