Dear Sir , I am adding Old balance and current bill in invoice and code are given below but in that 1 ) old balance amount is coming but colour in dr amount red and in cr amount green is not changing even though i insert condition . 2) In BillAmt1 field g. total amount is not coming, I tried $$amount but that is net amount is coming and not the g. total . Even #EXRPNVINVTotal showing blank space. Pl help in this problem Regards. [Field : Name Field1] Use : ShortPrompt Set As : "OLD BALANCE" PrePrinted : Yes Width : 25% Page Style : Normal Print FG : Blue Colour : Blue [Field : Name] Use : Amount Forex Field set as : $ClosingBalance:Ledger:$PartyLedgerName - $Amount Preprinted : Yes Width : 15% Page Style : NormalBold Print FG : Red Colour : IF $ClosingBalance Dr then Red else Green Format : "Symbol,DrCr" [Line: Billamt] Fields:Billamt1 Spce Top : 0.50 [Field: Billamt1] Field : Short Prompt, Amount Field Local : Field : Short Prompt : Info :$$LocaleString:"BILL AMOUNT" Local : Field : Short Prompt : Width : 21.5 Local : Field : Amount Field : Set as : #EXRPNVINVTotal Local : Field : Amount Field : Format : "Symbol,DrCr"
please check this area of your code Colour : IF $ClosingBalance Dr then Red else Green Local : Field : Amount Field : Set as : #EXRPNVINVTotal
sir, I know the area of mistake, but what is needed is correct code or where and what the mistake ? Normally when u put '#EXRPNVINVTotal' replies the total amount of the Invoice, but here blank replies.