Solved

adding - A on a certain invoice form

  • 24 October 2022
  • 2 replies
  • 31 views

Userlevel 3
Badge

hi, we have multiple invoice forms and on a certain one i would like to add a - A after the invoice Number.

example: reference number: 123 - A

do you know what the expression/value would be to do this? sorry if my wording is not correct as im new to this.

also, what programming language does the report designer use?

 

 

 

icon

Best answer by BenjaminCrisman 24 October 2022, 22:41

View original

2 replies

Userlevel 7
Badge +4

Hi @mna10! The reports use SQL language to query the database for information to populate the report.

For that you can just type + ‘A’ at the end.

The result would look like =[ARInvoiceHdr.InvoiceNbr]+’ ’+’A’.

You can also use the Concat() function to smash things together, like =Concat([ARInvoiceHdr.InvoiceNbr]+’ ’+’A’)

Userlevel 3
Badge

hi @BenjaminCrisman, wow thanks. definitely was overthinking and didnt try any of that. looks good now. Thanks for the fast reply.

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