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
     


  3. Manish8215

    Manish8215 New Member


    Can you please tell me how to enter plywood inventory with different sizes ?
     


  4. Philip Fernandes

    Philip Fernandes New Member


    Entries passed through credit note for sales return not captured above
     


  5. Sanjeev S

    Sanjeev S Member


    Source Collection is Sales if Credit Notes collection added it will definitely calculate.

    Regards
     


  6. Philip Fernandes

    Philip Fernandes New Member


    Can you please help it didn't work
     


  7. K.Deepa

    K.Deepa New Member



Share This Page