Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

How to create ZipCode-City-State instead of City-State-ZipCode

Posted on by 1,345

Hi,

The standard address calculated method design is City-State-ZipCode. For my country, the standard setting is ZipCode-City-State. I tried changing the calculated field sequence or arrangement directly but it does not work.

Does anyone know how to change the standard setting? It will also be helpfull if it can be set for 4 address lines instead of 3, using the suppress formula where if any of the address line is blank it will be supressed.

Thanks.

*This post is locked for comments

  • Suet Lee Profile Picture
    Suet Lee 1,345 on at
    Re: How to create ZipCode-City-State instead of City-State-ZipCode

    Hi,

    I am able to solve the above problem using the RW_Adress function.

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans