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?
Custom 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 E-mail address. We'll send you an e-mail with instructions to reset your password.