STOCK ITEM WITH GROUP FILTER VOUCHER TDL - PLZ HELP ME THE CODES

Discussion in 'Free Source Codes' started by RAVI BANOTH, Oct 28, 2020.

    
  1. RAVI BANOTH

    RAVI BANOTH Member


    [Collection:MYSTKGRPCOLL1]
    Title:"List Of Stock Group"
    Type:STOCK GROUP
    Align:Center
    Format:$name,22
    Sub Title : ""

    [#Collection: Vch Stock Item Extract]
    Child Of:#MYGRPFILTER
    Belongs To:Yes

    [#Line: EI COLUMNONE]
    Add: Field: Before :VCH ItemTitle :MYGRPFILTER
    Add:Field:At Beginning:SRNO1
    Local: Field: MYGRPFILTER : Info: "Stock Group"
    Local:Field:SRNO1:Info:"Sr.No"
    Local:Field:SRNO1:Style:LARGE BOLD
    [Field:SRNO1]
    Set as:$$Line
    Width:10
    Skip:Yes
    [#Line: EI INVINFO]
    Add: Field: Before :VCH STOCKItem :MYGRPFILTER
    Add:Field:At Beginning:SRNO1
    Local:Field:SRNO1:Space Left:2
    Local:Field:SRNO1:Style:LARGE BOLD

    [Field:MYGRPFILTER]
    Use:NAME FIELD
    Color:BLUE
    Style:LARGE BOLD
    Table:MYSTKGRPCOLL1,EndofList
    Width:30
    Storage:MYGRPFILTERstr
    Show Table:Always


    [System:UDF]
    MYGRPFILTERstr:String:1009


    ;;;;;;;;;;;invoice settin;;;;;;;;;


    [#Line:EXPINV COLUMN1]
    ; Add:Right Field:At Beginning:GRPFILTERTITLE;EXPINV DescTitle
    Add:Left Field:Before:EXPINV DescTitle:GRPFILTERTITLE;EXPINV DescTitle

    [Field:GRPFILTERTITLE]
    Use:NAME FIELD
    Set as:"Stock Group"
    Width:12
    Align:Center
    Style:SMALL BOLD
    Border:THIN LEFT
    Space Right:2
    [#Line:EXPINV INVDETAILS]
    Add:Left Field:Before:EXPINV Desc: GRPFILTERT
    [Field:GRPFILTERT]
    Use:NAME FIELD
    Set as:$MYGRPFILTERstr
    Set Always:Yes
    Align:Left
    Width:12
    Style:NORMAL bold
    Border:THIN LEFT
    Space Right:2
    Indent:3
    Case:All Capital
     


  2. RAVI BANOTH

    RAVI BANOTH Member


    Dear All,
    Please help me Any One. Regarding group name is showing but Item name not Taging with Group Name


    Thanks & Regards
    B.R.Naik
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Please check your Item Collection.......... it is empty and devoid of any parameters.

    Since you have made this code on your own, you can easily make the collection for the StockItems

    In your collection of StockItem .... instead of Child Of......use Filter ......
     
    naren1234 likes this.


  4. Himanshu-2002

    Himanshu-2002 Active Member


    You have to create a collection of stock Items and after that Filter it according to group name
    Example:
    [Collection:MyStockCollection]
    Type:StockItem
    Fetch:Name, Parent
    Format:$Name, 20
    Format:$Parent, 20
    Filter: MyStkGrpFilter

    [System:formulas]
    MyStkGrpFilter:$Parent="MyGroupName"
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $$IsEqual:$parent:#MYGRPFILTER

    this formula works best..................in System : Formula
     
    naren1234 likes this.


  6. Himanshu-2002

    Himanshu-2002 Active Member


    Oo..From Today I will use this method
     


Share This Page