Skip to main content

Hi,

Is there a way to print an address without the blank lines.  I am producing an email which includes the delivery address but looks un tidy because of the blank rows in the address.  I am using an event  with plsql code.

 

Thanks

​@JannetteC   You can try the address presentation api which will use the settings you define in IFS in the Address Presentation page for a given country.  

For example:

select company
,     company_api.get_name(company) name
,     address_presentation_api.format_address(country_db, address1, address2, address3, address4, address5, address6, city, county, state, zip_code, country ) address
from company_address 

Reply


Terms & ConditionsCookie settings