I have a custom sales invoice listing report with a column for invoice type. I would want to know I can I add a negative sign to my invoice type “credit memo” so as to differentiate them from invoices?
Answer
Custom sales invoice listing report how to differentiate a credit memo from an invoice
Best answer by Laura03
Instead of displaying [ARInvoice.CuryDocBal] for example, try something like this:
iif([ARInvoice.DocType] = ‘Credit Memo’, [ARInvoice.CuryDocBal]*-1,[ARInvoice.CuryDocBal])
Laura
Hi
You can achieve the above by using an Iif function based expression.
You may attach the report file and elaborate the requirement in detail.
Regards,
VijayKumarU
+19Instead of displaying [ARInvoice.CuryDocBal] for example, try something like this:
iif([ARInvoice.DocType] = ‘Credit Memo’, [ARInvoice.CuryDocBal]*-1,[ARInvoice.CuryDocBal])
Laura
~ Laura Barber, WM Synergy
Instead of displaying [ARInvoice.CuryDocBal] for example, try something like this:
iif([ARInvoice.DocType] = ‘Credit Memo’, [ARInvoice.CuryDocBal]*-1,[ARInvoice.CuryDocBal])
Laura
Thank you this resolved my issue
Kudzai Masora
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.