Skip to main content
Solved

Auto-fill address in ALL CAPS when using Address Lookup

  • 22 August 2023
  • 4 replies
  • 106 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? 

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.


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


@reyortdor - Did you get this figured out?


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. 


Reply