Skip to main content
Solved

Reducing Address1 to 30 characters in Apps 9

  • November 17, 2023
  • 4 replies
  • 144 views
T
Do Gooder (Customer)
Forum|alt.badge.img+4

Hi 

I need to restrict the length of Address1 to 30 characters due to restriction when passing data to myTNT. I think this is possible by editing the address layout per country but cant find where. Address Presentation windows just changes the display size of the fields in the address popup but doesn’t change how many characters can be entered. The Address Setup per Country window also doesnt seem to offer this facility. 

Is it possibe? 

Many thanks!

Best answer by AsankaGaru

Hi Tom,

My bad for not checking your version properly before responding. 

Above function was introduced in APP10.

 

You could use a custom event for this purpose in your current version. Your steps would be;

  • Create a custom event for the LU and table you need (for example:CustomerInfoAddress,CUSTOMER_INFO_ADDRESS_TAB  ) for new objects and changes.
  • Use the address_ID new value as an attribute
  • Create a new custom attribute XXX for measuring the length of this attribute. 
  • Create an event action with execute online sql, and define an error as the outcome
  • for conditions for preforming this action use  XXX>30 

Hope this helps,

Thanks

Asanka

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

A
Hero
Forum|alt.badge.img+11

Hi,

What you need is the address setup screen. This allows limiting the address rows to a user defined length. For example, I am only allowing 30 characters per address line in supplier addresses.

If I try to enter beyond 30 characters, I get an error like below.

 

Hope this helps,

Asanka

Asanka Garusinghe - https://www.linkedin.com/in/asanka-garusinghe-61634a64/
T
Do Gooder (Customer)
Forum|alt.badge.img+4
  • TomBeresford
  • Do Gooder (Customer)
  • December 11, 2023

Hi Asanka 

Thanks so much for the help. 

In our Apps 9, I don’t see this option. I only see the following under Enterprise, Basic Data: 

There is an “Address Set-up per Country” screen (see below) but no Address Setup like yours? 

I don’t think we ever applied the final patch/release to our Apps 9. I wonder if Address Set-up was included in that?

Any ideas?

Thanks

Tom

 

A
Hero
Forum|alt.badge.img+11

Hi Tom,

My bad for not checking your version properly before responding. 

Above function was introduced in APP10.

 

You could use a custom event for this purpose in your current version. Your steps would be;

  • Create a custom event for the LU and table you need (for example:CustomerInfoAddress,CUSTOMER_INFO_ADDRESS_TAB  ) for new objects and changes.
  • Use the address_ID new value as an attribute
  • Create a new custom attribute XXX for measuring the length of this attribute. 
  • Create an event action with execute online sql, and define an error as the outcome
  • for conditions for preforming this action use  XXX>30 

Hope this helps,

Thanks

Asanka

Asanka Garusinghe - https://www.linkedin.com/in/asanka-garusinghe-61634a64/
T
Do Gooder (Customer)
Forum|alt.badge.img+4
  • TomBeresford
  • Do Gooder (Customer)
  • December 19, 2023

Hi Asanka - thanks so much for the advice. That has really helped clarify things. Tom

Reply


Terms & ConditionsCookie settings

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