I Can't fetch stock catrgory here is my code please help.

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

    
  1. Nikhil dixit

    Nikhil dixit New Member


    [Collection:MYSTKCATEGORIESCOLL2]
    Title:"List Of Stock Categories"
    Type:STOCK CATEGORIES
    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:Info:"Sr.No"
    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:MYSTKCATEGORIESCOLL1,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
     


  2. balajimg

    balajimg Active Member


    in your collection you have used
    Type:STOCK CATEGORIES
    but it is
    Type:STOCK CATEGORY
     
    Nikhil dixit likes this.


  3. Nikhil dixit

    Nikhil dixit New Member



    thankyou sir
     


  4. Mahesh Sethi

    Mahesh Sethi Member


    First Check Your First Collection [Collection:MYSTKCATEGORIESCOLL2]
    Then Correct The Field Value when you call that collection Data
    And Also Check Your your other collections also
     


Share This Page