All Experts i need Column input Condition.... please Help.....

Discussion in 'Free Source Codes' started by udaya, Mar 15, 2020.

         
  1. udaya

    udaya Member


    [#Line : EI Col2]

    Option : EB EI Col2 : @@IsSales

    [!Line : EB EI Col2]

    Add : Right Fields : After : VCH ActualQty : EB Length, EB Wdth

    [Field : EB Length]

    Use : Number Field
    Type : Number : Forced
    Storage : EBCarton
    Set Always : Yes
    Color : Red
    Border :Thin LeftRight
    Width : 6
    Align : Center
    Format : "NoZero"


    [Field : EB Wdth]

    Use : Number Field
    Type : Number : Forced
    Storage : EBArticle
    Set Always : Yes
    Color : Blue
    Border :Thin Right
    Width : 5
    Align : Center
    Format : "NoZero"
    ; if Item name Contain "Sqft" it shuold goto colomn, else skip

    [System : UDF]

    EB Length : Number : 801
    EB Wdth : Number : 802
     


  2. udaya

    udaya Member


    if Item name Contain "Sqft" it shuold goto colomn, else skip
     


  3. drive

    drive Active Member


    Skip On : IF $StockItemName Contain "Sqft" Then No Else Yes
     


  4. udaya

    udaya Member


    It show err...... Please Correct pars "DRIVE" Bro.....
    upload_2020-3-16_22-20-46.png
     


  5. udaya

    udaya Member


    Please can anyone guide me.... awaiting.....
     


  6. Sanjeev S

    Sanjeev S Member


    Try this ........

    [Field : EB Length]

    Use : Number Field
    Type : Number : Forced
    Storage : EBCarton
    Set Always : Yes
    Color : Red
    Border :Thin LeftRight
    Width : 6
    Align : Center
    Format : "NoZero"
    Skip : if #VCHStockItem contains "SqFt" then no else yes



    [Field : EB Wdth]

    Use : Number Field
    Type : Number : Forced
    Storage : EBArticle
    Set Always : Yes
    Color : Blue
    Border :Thin Right
    Width : 5
    Align : Center
    Format : "NoZero"
    Skip : if #VCHStockItem contains "SqFt" then no else yes
     


  7. udaya

    udaya Member


    Dear Sanjeev and all. I got a small issue. when i enter item in voucher not contain "SqFt" then automatically remove the Quantity, Rate, Per. pleaseGuid me to solve this issue....




    upload_2020-3-18_10-14-49.png
     


  8. udaya

    udaya Member


    I Found this code working perfectly on release 6.5.4 but 6.5.5 and after the above happened..... please guide me........
     


  9. Sanjeev S

    Sanjeev S Member


    Please attach the full code
     


  10. udaya

    udaya Member


    Dear Sanjeev
    when i enter item in voucher not contain "SqFt" then automatically remove the Quantity, Rate, Per.
    I Found this code working perfectly on release 6.5.4 but 6.5.5 and 6.6 remove the fields as entered above (as attached screenshot)




    [#Line : EI Col2]

    Option : EB EI Col2 : @@IsSales

    [!Line : EB EI Col2]

    Add : Right Fields : After : VCH ActualQty : EB Length, EB Wdth

    [Field : EB Length]

    Use : Number Field
    Type : Number : Forced
    Storage : EBCarton
    Set Always : Yes
    Color : Red
    Border :Thin LeftRight
    Width : 6
    Align : Center
    Format : "NoZero"
    Skip : if #VCHStockItem contains "SqFt" then no else yes


    [Field : EB Wdth]

    Use : Number Field
    Type : Number : Forced
    Storage : EBArticle
    Set Always : Yes
    Color : Blue
    Border :Thin Right
    Width : 5
    Align : Center
    Format : "NoZero"
    Skip : if #VCHStockItem contains "SqFt" then no else yes


    [System : UDF]

    EB Length : Number : 801
    EB Wdth : Number : 802
     


  11. udaya

    udaya Member


    final code


    [#Line: EI ColumnOne]

    Option : EB EI ColumnOne : @@IsSales

    [!Line : EB EI ColumnOne]

    Add : Right Fields : Before : VCH QtyTitle : EB Carton, EB Article
    Local : Field : EB Carton : Info : "Length"
    Local : Field : EB Article : Info : "Width"

    [#Line : EI InvInfo]

    Option : EB EI InvInfo : @@IsSales

    [!Line : EB EI InvInfo]

    Add : Right Fields : After : VCH ActualQty : EB Carton, EB Article

    [Field : EB Carton]

    Use : Number Field
    Type : Number : Forced
    Storage : EBCarton
    Set Always : Yes
    Color : Red
    Border :Thin LeftRight
    Width : 6
    Align : Center
    Format : "NoZero"
    ; Skip on : $$IsEnd:$StockItemName
    Skip : if #VCHStockItem contains "Sqf" then No else Yes
    [Field : EB Article]

    Use : Number Field
    Type : Number : Forced
    Storage : EBArticle
    Set Always : Yes
    Color : Blue
    Border :Thin Right
    Width : 5
    Align : Center
    Format : "NoZero"
    ; Skip on : $$IsEnd:$StockItemName
    Skip : if #VCHStockItem contains "Sqf" then No else Yes


    [System : UDF]

    EB Carton : Number : 701
    EB Article : Number : 705

    [#Field : VCH BilledQty]

    Option : EB VCH NrmlBilledQty : @@ISSales

    [!Field : EB VCH NrmlBilledQty]

    Set By Condition : Yes : @@QtyCalculation

    [#Field : VCH Rate]

    Option : EB VCH Rate : @@ISSales

    [!Field : EB VCH Rate]

    Delete : Set By Condition

    [System : Formula]

    QtyCalculation : $$AsQty:#EBCarton * $$AsQty:#EBArticle
     


  12. udaya

    udaya Member


    please if any mistake in the code pls give me the solution experts.......
     


  13. Sanjeev S

    Sanjeev S Member


    Try .....

    [!Field : EB VCH NrmlBilledQty]

    Set By Condition : (#VCHStockItem contains "Sqf") : @@QtyCalculation
     


  14. udaya

    udaya Member


    Thanks lot Saneev S ....... It is Working perfect........ Thanks.... Thanks.... Thanks.... Thanks....
     
    Sanjeev S likes this.


Share This Page