Skip to main content
Solved

Auto-fill address in ALL CAPS when using Address Lookup


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.

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

4 replies

darylbowman
Captain II
Forum|alt.badge.img+13
  • 1606 replies
  • 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
  • 7 replies
  • August 23, 2023

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


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

@reyortdor - Did you get this figured out?


  • Author
  • Freshman II
  • 7 replies
  • 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. 


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