Period Range not showing = Please help ????

Discussion in 'Free Source Codes' started by bikash agarwal, Mar 5, 2024.

    

  1. Hello Sir :)
    can anyone please help in period showing :cool:

    code also attached .... :D

    see attached pic ..
     

    Attached Files:

    • fff.JPG
      fff.JPG
      File size:
      410.3 KB
      Views:
      27


  2. vishnu joshi

    vishnu joshi Member


    Try This

    Code:
    ;---------------------------------------------------------------average_rate
    
    
    
    [#Menu : Gateway of Tally]
    Item : Item Sales Average_RATE : Display :LearnwellItemSumm42
    [Report :LearnwellItemSumm42]
    Form :LearnwellItemSumm
    Variable : SVFromDate,SVToDate
    Set : SVFromDate : SVfromDate:$$FinYearBeg:##StartDate:$StartingFrom:Company:##SVCurrentCompany
    Set : SVToDate : $$MonthEnd:##SVFromdate ;;$$Machinedate  ;;
    [Form :LearnwellItemSumm]
    Part : LXTitle,LWSummItemTitle,LWSummItemDetail
    Button : Change Period,Print Button,Export Button
    Bottom Part : LWSummItemDetailBTM
    Background :Light Lily Yellow ;White
    
    
    [Part : LXTitle]
    Line :partyaddL59
    
    [Line:partyaddL59]
    Field:partyaddL43
    
    [Field:partyaddL43]
    Fields:Simple Prompt, Name Field
    Local:Field:simple prompt : info :$$localestring:"Period.:"
    Local : Field : simple prompt : color : WHITE
    Local : Field : simple prompt :Background:leaf green
    Local : Field :simple prompt : style : SMALL bold
    Local : Field : simple prompt : width : 14
    Local : Field : name Field :Set as : @@DSPDateStr     ;$$String:##SVFromDate + " to " + $$String:##SVToDate
    Local : Field : name Field :Set Always:Yes
    Local : Field : name Field :Skip:Yes
    Local : Field :name Field : width : 30
    Local : Field :name Field : space left : 4
    Local : Field :name Field : style : SMALL 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
    Width:33
    
    
    [Field : LWHsn]
    Use: Name Field
    Set as:$(Stockitem,$stockitem).GstDetails[Last].hsncode
    Style : Small
    Width:10
    color: leaf green
    Align: left
    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
    Style : Small
    Width:10
    Align: left
    color: blue
    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
    color: geranium
    Width:15
    
    [Field : LWAmtTTl]
    Use : Amount Field
    Set As : $AmountToT
    Style : Small
    Width:18
    
    [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
    Compute : FromDate  :$$Date:$$String:$MonthStart
    Compute : EndDate    :$$Date:$$String:$MonthEnd
    [Collection : LWCollSalesItems]
    Source Collection : LearnwellItemSummcoll
    Walk : Inventory Entries
    By : Stockitem : $StockitemName
    Aggr Compute : BilledQtyToT : Sum : $BilledQty
    Aggr Compute : AmountToT : Sum : $Amount
    
    
     



  3. thanks

    can stock name be sort by name ascending ... by stock name
    as default in tally as shown in pic
     

    Attached Files:

    • 55.png
      55.png
      File size:
      8.5 KB
      Views:
      8
    Last edited: Mar 8, 2024


Share This Page