Skip to main content

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!

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

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

 

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

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

Reply


Terms & ConditionsCookie settings