Solved

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

  • 7 March 2022
  • 3 replies
  • 122 views

Userlevel 4
Badge

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?

icon

Best answer by Laura02 7 March 2022, 20:00

View original

3 replies

Badge +16

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

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

 

Laura

Userlevel 7
Badge +11

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,

Userlevel 4
Badge

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


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved