Dear sir, I have added column in sales order for current stock this fetches value of stock from closing stock. I would like to change color to red if value is negative of closing stock, green if value is positive, yellow if value is 0. Please suggest codes
Working, Thanks... Please suggest tripple condition it's double, red for negative dark green for other, but what about 0
Done by this code Color : If $$IsNegative:$$Value Then "Ref" Else If 0 then "Blue" else "Dark Green" Thanks Brother
How to delete company name and address in simple invoice [#Part: INVSMP] Deleteart: GST INVSMP COMPANY
Please check and correct following code as its working for value 1 but not for 2 and above [Field : PKGVFDATA] Use: Numbers Set as: if (($BilledQTY)/($PackSizeStorage:StockItem:$StockItemName)) = 1 or 2 or 3 or 4 or 5 or 6 or 7 or 8 or 9 or 10 or 11 or 12 Then "P" Else "O" Color: if (($BilledQTY)/($PackSizeStorage:StockItem:$StockItemName)) = 1 or 2 or 3 or 4 or 5 or 6 or 7 or 8 or 9 or 10 or 11 or 12 Then "Dark Green" else "Red" Border: thin box Scroll: Vertical Width : 2 Align: Centre invisible : not @@ISSALESORDER Invisible: @@ISPurchase Invisible: @@ISSALES Skip: Yes Border: Thin Left : $$InPrintMode Add:Style:CLSTKSTYLE
;;Try the following: Code: Set as: if (($BilledQTY)/($PackSizeStorage:StockItem:$StockItemName)) IN (1, 2, 3, 4, 5) THEN "P" ELSE "O"
Please Check Both Line You Have add Some Fields in Both Lines.. [#Line:Exp Inv Details] [#Line:Exp Acc Details]