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