free code :- Items wise Sales summary

Discussion in 'Free Source Codes' started by psjain_jal, Apr 5, 2013.

    
  1. NANDKUMAR FULFAGER

    NANDKUMAR FULFAGER New Member


    hello !
    how to create loading sheet as item name, acctual qty, billed qty, box , loose qty
     


  2. yogeshtailor

    yogeshtailor Member


    dear Sir i m also Design customize report Sales
    That Report Display in Stock Item Wise Group

    please help any no idea to group
     

    Attached Files:



  3. Praveen Davis

    Praveen Davis Member


    this is not working, just a blank screen!!!
     


  4. yogeshtailor

    yogeshtailor Member


    sale invoice
     


  5. vipul patel

    vipul patel New Member


    Dear admin,

    i want to add some column in this following code.

    like godown wise / location wise sales report

    Particular | Location -1 sales Qty | Location -2 sales Qty | Location -3 sales Qty | Total Sales Avg sales Sales Value

    ABC | 20 | 50 | 10 | 80

    XYZ | 60 | 20 | 50 | 130




    [#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
     


  6. mulo abu

    mulo abu New Member


    what do you mean
     


  7. sandeep76out

    sandeep76out New Member


    wow nice code Sir and working
    thank you
     


  8. farrakh hayat

    farrakh hayat Member


    Sir,
    Child of : $$VchTypeSales for sales
    Child of : $$VchTypeSalesorder for sale order
    Child of : $$VchTypePurchsae for purchase
    please guide me that what will be for manufacturing ?
    I want to generate report in same way for manufacturing .
    my manufacturing voucher "MFG" is under "Stock journal".

    Please guide me.
    Thank you
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $$VchTypeStockJrnl
     
    farrakh hayat likes this.


  10. farrakh hayat

    farrakh hayat Member


    Thank you very much.
     


Share This Page