[#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
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
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....
I Found this code working perfectly on release 6.5.4 but 6.5.5 and after the above happened..... please guide me........
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
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
Try ..... [!Field : EB VCH NrmlBilledQty] Set By Condition : (#VCHStockItem contains "Sqf") : @@QtyCalculation
Thanks lot Saneev S ....... It is Working perfect........ Thanks.... Thanks.... Thanks.... Thanks....