Skip to main content
Answer

Auto-fill address in ALL CAPS when using Address Lookup

  • August 22, 2023
  • 4 replies
  • 204 views

The USPS states: 

“Uppercase letters are preferred on all lines of the address block.”

For this (and various other internal reasons) we have made it a standard practice in our business to use ALL CAPS for all addresses in our system. We use a window envelope to mail invoices, so the customer address in Acumatica must be in ALL CAPS in order for that to happen. 

When we use Address Lookup, then select the address to autofill the fields, the address is not in ALL CAPS. Is there a way to change this? 

Best answer by darylbowman

Perhaps a better solution would be to use the UCase() function in the required reports. This will convert a string to upper case no matter what format is entered into Acumatica.

4 replies

darylbowman
Captain II
Forum|alt.badge.img+15
  • Answer
  • August 23, 2023

Perhaps a better solution would be to use the UCase() function in the required reports. This will convert a string to upper case no matter what format is entered into Acumatica.


  • Author
  • Freshman II
  • August 23, 2023

Thank you. I will explore this UCase() function. 


darylbowman
Captain II
Forum|alt.badge.img+15

@reyortdor - Did you get this figured out?


  • Author
  • Freshman II
  • September 11, 2023

Unfortunately, I don’t have report edit capabilities myself. I passed on the information to the appropriate team member to try the UCase() function, but I haven’t heard back about it. I need to follow up.