TOTAL MINUS DISCOUNT TO BE SHOWN. TOTAL DISCOUNT AMOUNT TO BE SHOWN. LIKE VALUE TOTAL THEN DISCOUNT TOTAL= FINAL VALUE
Dear Nakul, Use this small addition ;;;--------------- ;; Add a hidden discount amount field [#Line: EI InvInfo] Option : EI SInvInfo : @@IsPOSInvoice [!Line : EI SInvInfo] Add : Right Field : Before : VCH Value : VCH DAmount [#Line: CI InvInfo] Option : CI SInvInfo : @@IsPOSInvoice [!Line : CI SInvInfo] Add : Right Field : Before : VCH Value : VCH DAmount [Field : VCH DAmount] Use : Amount Field Set as : ($Rate * $BilledQty) * $Discount /100 Set Always : Yes Skip : Yes Invisible : Yes ;; add field level formula [#Field : EI Disc Total] DiscTotal : $$Total:VCHDAmount ;;; use total discount in Total field with small alignment adjustments [#Line: VCH POS InvoiceTotal] Local : Field : EI Disc Total : Set as : $$StringDiscTotal Local : Field : EI Disc Total : Align : Right Local : Field : EI Disc Total : Width : 15 Local : Field : EI Disc Total : style : Normal Bold Local : Field : VCH POS InvoiceTotal : Width : 15
use this file .... Code: ;; Add a hidden discount amount field [#Line: EI InvInfo] Option : EI SInvInfo : @@IsPOSInvoice [!Line : EI SInvInfo] Add : Right Field : Before : VCH Value : VCH DAmount [#Line: CI InvInfo] Option : CI SInvInfo : @@IsPOSInvoice [!Line : CI SInvInfo] Add : Right Field : Before : VCH Value : VCH DAmount [Field : VCH DAmount] Use : Amount Field Set as : ($Rate * $BilledQty) * $Discount /100 Set Always : Yes Skip : Yes Invisible : Yes ;; add field level formula [#Field : EI Disc Total] DiscTotal : $$Total:VCHDAmount ;;; use total discount in Total field with small alignment adjustments [#Line: VCH POS InvoiceTotal] Local : Field : EI Disc Total : Set as : $$String:@DiscTotal Local : Field : EI Disc Total : Align : Right Local : Field : EI Disc Total : Width : 15 Local : Field : EI Disc Total : style : Normal Bold Local : Field : VCH POS InvoiceTotal : Width : 15