;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;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
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 !