IN THIS WE WANT TO INVISIBLE THA COLUMN WHEN WEIGHT CLUMN IN SALES CONFIGURTION IS NO PLS HELP SIR!

Discussion in 'Free Source Codes' started by Rohit001, Jan 16, 2020.

    
  1. Rohit001

    Rohit001 Member


    [#Line: EI ColumnOne]

    Option : sms EI ColumnOne : @@IsSales

    [!Line : sms EI ColumnOne]

    Add : Right Fields : Before: VCH QtyTitle :GRWT ,LESWT, NTWT, TNCH
    Local : Field : GRWT : Info : "Gross Wt."
    Local : Field : LESWT : Info : "Less Wt."
    Local : Field : NTWT : Info : "Net Wt."
    Local : Field : TNCH : Info : "Tunch"
    [#Line : EI InvInfo]

    Option : sms EI InvInfo : @@IsSales

    [!Line : sms EI InvInfo]

    Add : Right Fields : After : VCH ActualQty : GRWT,LESWT, NTWT, TNCH


    [Field : GRWT]

    Use : Number Field
    Type : Number : Forced
    Storage : smsgrwt
    Set as : ""
    Width : 10
    Align : Center
    Format : "NoZero"
    [Field : LESWT]

    Use : Number Field
    Type : Number
    Storage : smsleswt
    Set as : ""
    Width : 10
    Align : Center

    Format : "NoZero"

    [Field : NTWT]

    Use : Number Field
    Type : Number: Forced
    Storage : smsnetwt
    Set as :mad:@NET
    Set Always:Yes
    Read Only:Yes
    Skip:Yes
    Width : 10
    Align : Center
    Format : "NoZero"


    [Field : TNCH]

    Use : Name Field
    Type : String : Forced
    Storage : smstunch
    Set Always : Yes
    Width : 10
    Align : Center
    Format : "NoZero"

    [System:Formula]
    NET:$smsgrwt-$smsleswt

    [System : UDF]
    smsgrwt : Number : 702
    smsleswt : Number : 701
    smsnetwt : Number : 705
    smstunch : String : 709


    [#Field: EXPINV HSNSACTitle]
    Info : $$LocaleString:"HSN/SAC"
    Width: 12% Page
    [#Field: EXPINV AltQtyTitle]
    Info : $$LocaleString:"Weight"
    Align:Left

    [#Field: EXPINV QtyTitle]

    Use : QtyTitleField
    Info : $$LocaleString:"Pieces"
    Border : Thin Left
    Align : Centre
    Style : Small


    [#Line: EXPINV Column1]

    Option : sms EXPINV Column1 : @@IsSales

    [!Line : sms EXPINV Column1]

    Add : Left Fields : After : EXPINV DescTitle :GRWT, LESWT, NTWT, TNCH
    Local : Field : GRWT : Info : "Gross Wt."
    Local : Field : LESWT : Info : "Less Wt."
    Local : Field : NTWT : Info : "Nett Wt."
    Local : Field : TNCH: Info : "Tunch"
    Local : Field : GRWT :Border:thin left
    Local : Field : GRWT :Width:7% Page
    Local : Field : LESWT :Border:thin left
    Local : Field : LESWT :Width:7% Page
    Local : Field : NTWT :Border:thin left
    Local : Field : NTWT :Width:7% Page
    Local : Field : TNCH :Border:thin left
    Local : Field : TNCH :Width:7% Page
    Local : Field : GRWT : Delete: Storage
    Local : Field : LESWT : Delete: Storage
    Local : Field : NTWT : Delete: Storage
    Local : Field : TNCH : Delete: Storage
    Local : Field : GRWT : Type : Number
    Local : Field : LESWT : Type : Number
    Local : Field : NTWT : Type : Number
    Local : Field : TNCH : Type : String
    Local : Field : TNCH : Style : Small
    Local : Field : NTWT : Style : Small
    Local : Field : LESWT : Style : Small
    Local : Field : GRWT : Style : Small

    [#Line: EXPINV InvDetails]

    Option : sms EXPINV InvDetails : @@IsSales

    [!Line : sms EXPINV InvDetails]

    Add : Left Fields : After : EXPINV Desc :GRWTPrint, LESWTPrint, NTWTPrint,TNCHPrint


    [Field : GRWTPrint]

    Use : Number Field
    Type : Number : Forced
    Set as : $smsgrwt
    Width : 6.9% Page
    Set Always : Yes
    Align : Center
    Format : "NoZero"
    Border :THIN LEFT

    [Field : LESWTPrint]

    Use : Number Field
    Type : Number : Forced
    Set as : $smsleswt
    Set Always : Yes
    Width : 6.9% Page
    Align : Center
    Format : "NoZero"
    Border :THIN LEFT




    [Field : NTWTPrint]

    Use : Number Field
    Set as : $smsnetwt
    Set Always : Yes
    Width : 6.8% Page
    Align : Center
    Format : "NoZero"
    Border :THIN LEFT

    [Field : TNCHPrint]

    Use : Name Field
    Set as : $smstunch
    Set Always : Yes
    Width : 6.7% Page
    Align : Center
    Format : "NoZero"
    Border : THIN LEFT
    ;;;;;

    [#Part: EXPINV BasicLeft]
    Width : 29% Page


    ;;; sales configuration;;;

    [#Part: VchF12PrnSTDConfig SalesInvoiceLeft]
    ADD:Line:AFTER:SABankInfo:pN TGNM
    [Line:pN TGNM]
    Fields : Medium Prompt,ShortNameField1
    Local : Field : Medium Prompt : Set as : $$LocaleString:"Print Weight Column ?"
    [Field:ShortNameField1]
    Use:Logical Field

    Modifies:Yes
    Variable:pRNWithWGTCOLMN
    Set:No

    [System:Variables]
    PRNWithWGTCOLMN:Yes

    [Variable: PRNWithWGTCOLMN]

    Type : Logical
    Persistent : Yes
     


  2. Rohit001

    Rohit001 Member


    plss see the images given below:-
     

    Attached Files:



  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Invisible : NOT ##PRNWithWGTCOLMN ........... in the title fields as well as data fields.
     
    Rohit001 likes this.


  4. Rohit001

    Rohit001 Member


    SIR I NOT FIND THE OUTPUT PLSSS SEE THE CODE SIR

    [#Line: EXPINV Column1]

    Option : sms EXPINV Column1 : @@IsSales

    [!Line : sms EXPINV Column1]

    Add : Left Fields : After : EXPINV DescTitle :GRWT, LESWT, NTWT, TNCH
    Local : Field : GRWT : Info : "Gross Wt."
    Local : Field : LESWT : Info : "Less Wt."
    Local : Field : NTWT : Info : "Nett Wt."
    Local : Field : TNCH: Info : "Tunch"
    Local : Field : GRWT :Border:thin left
    Local : Field : GRWT :Width:7% Page
    Local : Field : LESWT :Border:thin left
    Local : Field : LESWT :Width:7% Page
    Local : Field : NTWT :Border:thin left
    Local : Field : NTWT :Width:7% Page
    Local : Field : TNCH :Border:thin left
    Local : Field : TNCH :Width:7% Page
    Local : Field : GRWT : Delete: Storage
    Local : Field : LESWT : Delete: Storage
    Local : Field : NTWT : Delete: Storage
    Local : Field : TNCH : Delete: Storage
    Local : Field : GRWT : Type : Number
    Local : Field : LESWT : Type : Number
    Local : Field : NTWT : Type : Number
    Local : Field : TNCH : Type : String
    Local : Field : TNCH : Style : Small
    Local : Field : NTWT : Style : Small
    Local : Field : LESWT : Style : Small
    Local : Field : GRWT : Style : Small
    Local : Field : TNCH : Invisible : NOT ##PRNWithWGTCOLMN
    Local : Field : NTWT : Invisible : NOT ##PRNWithWGTCOLMN
    Local : Field : LESWT : Invisible : NOT ##PRNWithWGTCOLMN
    Local : Field : GRWT : Invisible : NOT ##PRNWithWGTCOLMN

    [#Line: EXPINV InvDetails]

    Option : sms EXPINV InvDetails : @@IsSales

    [!Line : sms EXPINV InvDetails]

    Add : Left Fields : After : EXPINV Desc :GRWTPrint, LESWTPrint, NTWTPrint,TNCHPrint


    [Field : GRWTPrint]

    Use : Number Field
    Type : Number : Forced
    Set as : $smsgrwt
    Width : 6.9% Page
    Set Always : Yes
    Align : Center
    Format : "NoZero"
    Border :THIN LEFT
    Invisible : NOT ##PRNWithWGTCOLMN
    [Field : LESWTPrint]

    Use : Number Field
    Type : Number : Forced
    Set as : $smsleswt
    Set Always : Yes
    Width : 6.9% Page
    Align : Center
    Format : "NoZero"
    Border :THIN LEFT
    Invisible : NOT ##PRNWithWGTCOLMN



    [Field : NTWTPrint]

    Use : Number Field
    Set as : $smsnetwt
    Set Always : Yes
    Width : 6.8% Page
    Align : Center
    Format : "NoZero"
    Border :THIN LEFT
    Invisible : NOT ##PRNWithWGTCOLMN
    [Field : TNCHPrint]

    Use : Name Field
    Set as : $smstunch
    Set Always : Yes
    Width : 6.7% Page
    Align : Center
    Format : "NoZero"
    Border : THIN LEFT
    Invisible : NOT ##PRNWithWGTCOLMN
    ;;;;;

    [#Part: EXPINV BasicLeft]
    Width : 29% Page


    ;;; sales configuration;;;

    [#Part: VchF12PrnSTDConfig SalesInvoiceLeft]
    ADD:Line:AFTER:SABankInfo:pN TGNM
    [Line:pN TGNM]
    Fields : Medium Prompt,ShortNameField1
    Local : Field : Medium Prompt : Set as : $$LocaleString:"Print Weight Column ?"
    [Field:ShortNameField1]
    Use:Logical Field
    Invisible : NOT ##PRNWithWGTCOLMN
    Modifies:Yes
    Variable:pRNWithWGTCOLMN


    [System:Variables]
    PRNWithWGTCOLMN:Yes

    [Variable: PRNWithWGTCOLMN]

    Type : Logical
    Persistent : Yes





    PLS SEE THE IMAGES SIR!
     

    Attached Files:



  5. Rohit001

    Rohit001 Member


    Anybody help plssss
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    the part of code in CONFIG...not here...so cannot comment. You might not have defined the variable properly....there u must use "Modifies"
     


  7. Rohit001

    Rohit001 Member


    thankyou sir i got the output
     


Share This Page