Help with this code

Discussion in 'Tally Developer' started by HAROON2015, Oct 8, 2019.

    
  1. HAROON2015

    HAROON2015 Member


    please help with this code
    i want to fetch stock item name according to stock group name tried this but not working

    Code:
    ;;-----------------------------------------------------------------------------------------------------------------------------
    [#Line: EI ColumnOne]
        Add: Option:  grp groupselectiontitle:@@IsSales
    
    [!Line :grp groupselectiontitle]
        Add: Field: Before:VCH ItemTitle:grpGrouptitField
       
    [Field: grpGrouptitField]
        Width: 50 Mms
        Info: "Groups"
        Style: tiny bold
       
    [#Field: VCH ItemTitle]
        Space Left: 15 mms
    [#Line: Eiinvinfo]
        Add: Option: grp groupselection:@@IsSales
    
    [#Line: CIInvInfo]
        Add: Option: grp groupselection:@@IsSales
       
    [!Line: grp groupselection]
        Add: Field: Before:VCH StockItem:grpGroupField
    
    [Field: grpGroupField]
        Use: Name Field
        Wdith : 50 mms
        Storage: grpvchGrP
        Table: grpgrpcoll
        Show Table : Always
        Modifies: MygrpName
        Set Always: yes
       
       
    [#Field: VCH StockItem]
        Table : vchgrpitemcoll,End of List
    [collection : vchgrpitemcoll]
        Title : $$Localestring:"List of Stock Items"
        Type : Stockitem
        Child Of:##MygrpName
        Fetch : Name, closingBalance
        Format : $Name, 40
        Format : $closingBalance:Base
        Full Height : yes
        Align : Right
    
    [Variable: MygrpName]
        Type: String
    
    [System: Variable]
        MygrpName:""
    
    [Collection: grpgrpcoll]
        Type: stockgroup
       
    
    
    [System: UDF]
        grpvchGrP : String: 2300
    
     


  2. Murali.R

    Murali.R Member


    [#Line: EI ColumnOne]
    Add: Option: grp groupselectiontitle:mad:@IsSales

    [!Line :grp groupselectiontitle]
    Add: Field: Before:VCH ItemTitle:grpGrouptitField

    [Field: grpGrouptitField]
    Width: 50 Mms
    Info: "Groups"
    Style: tiny bold

    [#Field: VCH ItemTitle]
    Space Left: 15 mms
    [#Line: Eiinvinfo]
    Add: Option: grp groupselection:mad:@IsSales

    [#Line: CIInvInfo]
    Add: Option: grp groupselection:mad:@IsSales

    [!Line: grp groupselection]
    Add: Field: Before:VCH StockItem:grpGroupField

    [Field: grpGroupField]
    Use: Name Field
    Width : 50 mms
    Storage: grpvchGrP
    Table: grpgrpcoll
    Show Table : Always
    Modifies: MygrpName
    Set Always: yes


    [Collection: grpgrpcoll]
    Type: stockgroup
    ; Use : List of StockGroups
    Collection : Primary
    Variable : Stock Group Name
    Fetch : Name


    [System: UDF]
    grpvchGrP : String: 2300



    [*Collection: Vch Stock Item Extract]
    Use : ExtractAlias Collection
    Source Collection : Stock Item Src
    Collection : StockItem PartNo With Closing
    Title : $$LocaleString:"List of Items"
    Fetch : Name,parent,Category, VchStkItmBalance,LastSalePrice
    Set as : $FirstName
    Keep Source : ()...
    Client Only : Yes
    Filter : Mrinfo1
    Format : $VchStkItmBalance : "Base"
    Format : $LastSalePrice: "Base"
    Add: With Alias : Yes


    [System:formula]
    Mrinfo1:$$IsEqual:$Parent:$$LocaleString:#grpGroupField
     


  3. HAROON2015

    HAROON2015 Member


    Saying vch stock item extract description not found
     



  4. Just do this code will work
    [#Collection: Vch Stock Item Extract]
    filter:Mrinfo1
    [System:formula]
    Mrinfo1:$$IsEqual:$Parent:$$LocaleString:#grpGroupField
     


  5. svn

    svn Member


    [#Collection : VCH Stock Item Extract]
    Add : Subtitle : "CL. QTY AS ON VOUCHER DATE"
    Add :Format : $VchStkItmBalance:$closingstock:$voucherdate,10


    How to add item closing stock balnce as voucher date.
    thank you for advance sir.
     
    Last edited: Jun 28, 2021


Share This Page