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 originalInstead 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,
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.