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?
Best answer by Laura02
View originalCustom sales invoice listing report how to differentiate a credit memo from an invoice
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,
+18
Instead of displaying [ARInvoice.CuryDocBal] for example, try something like this:
iif([ARInvoice.DocType] = ‘Credit Memo’, [ARInvoice.CuryDocBal]*-1,[ARInvoice.CuryDocBal])
Laura
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.