Skip to main content

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?

Hi @kudzaim20 

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

Reply


Terms & ConditionsCookie settings