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 originalI 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 originalHi
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,
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.