Taking stock items of one group only and not taking stock items of another group in multiple entries

Discussion in 'Free Source Codes' started by Nikhil dixit, Oct 22, 2019.

    
  1. Nikhil dixit

    Nikhil dixit New Member


    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;STOCK CATEGORY;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;


    [Collection:MYSTKCATEGORYCOLL2]
    Title:"List Of Stock Categories"
    Type:STOCK CATEGORY
    Align:Center
    Format:$name,22
    Sub Title : ""

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

    [#Line: EI COLUMNONE]
    Add: Field: Before :VCH ItemTitle:MyCatFILTER1
    Add:Field:At Beginning:SRNO2
    Local: Field: MyCatFILTER1 : Info: "CATEGORY"

    Local:Field:SRNO2:Style:LARGE BOLD
    [Field:SRNO2]
    Set as:$$Line
    Width:10
    Skip:Yes
    [#Line: EI INVINFO]
    Add: Field: Before :VCH Stock Item :MyCatFILTER1
    Add:Field:At Beginning:SRNO2
    Local:Field:SRNO2:Space Left:2
    Local:Field:SRNO2:Style:LARGE BOLD

    [Field:MyCatFILTER1]
    Use:NAME FIELD
    Color:BLUE
    Style:LARGE BOLD
    Table:MYSTKCATEGORYCOLL2,EndofList
    Width:30
    Storage:MyCatFILTERstr
    Show Table:Always


    [System:UDF]
    MyCatFILTER1str:String:1009


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


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

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

    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;STOCK GROUP;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;





    [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: "Stamp"
    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

    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:"Stamp"
    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. Karthick MS

    Karthick MS New Member



    First send your query in screenshot. So that we will guide you.
     


  3. Nikhil dixit

    Nikhil dixit New Member


    IN this we have 2 stockcateory,2 stock group .In electronic group we have a tv & wahsing machine and the second group is mobiles ,in mobile group we have o stock item like samsung ,nokia . prolem is if first we select a electronic group then in the second entry we can't fetch stock item of another group(mobile) . pkease help !
     

    Attached Files:



Share This Page