Skip to main content
Solved

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


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 Laura02

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

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

 

Laura

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • March 7, 2022

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,


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • March 7, 2022

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

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

 

Laura


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 41 replies
  • March 8, 2022
laura01 wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings