Skip to main content
Solved

Custom sales invoice listing report how to differentiate a credit memo from an invoice

  • Mar 7, 2022 2:14 PM UTC
  • 3 replies
  • 204 views
  • Translate All

Forum|alt.badge.img

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 Laura03

Instead of displaying [ARInvoice.CuryDocBal] for example, try something like this:

iif([ARInvoice.DocType] = ‘Credit Memo’, [ARInvoice.CuryDocBal]*-1,[ARInvoice.CuryDocBal])

 

Laura

View original

3 replies

Forum|alt.badge.img+12
  • Acumatica Support Team
  • Mar 7, 2022 5:07 PM UTC

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,

Translate

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • Mar 7, 2022 7:00 PM UTC

Instead of displaying [ARInvoice.CuryDocBal] for example, try something like this:

iif([ARInvoice.DocType] = ‘Credit Memo’, [ARInvoice.CuryDocBal]*-1,[ARInvoice.CuryDocBal])

 

Laura

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • Mar 8, 2022 10:15 AM UTC

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

Translate