web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / 4 Address Lines
Microsoft Dynamics GP (Archived)
Suggested Answer

4 Address Lines

(0) ShareShare
ReportReport
Posted on by Community Member

I am trying to Customize Check Printing and have Calculated Fields for 4 address line.  Vendor Address Line 1, Vendor Address Line 2, Vendor Address Line 3 and Vendor Address Line 4.  I am by no means a developer but thought I would be able to modify this report.  The lines of code for each address line is below. 

Address Line 1

FUNCTION_SCRIPT(rw_SelectAddrLine1""PM_Payment_WORK.Address 1PM_Payment_WORK.Address 2""""PM_Payment_WORK.CityPM_Payment_WORK.StatePM_Payment_WORK.Zip Code"" )

 

Address Line 2

FUNCTION_SCRIPT(rw_SelectAddrLine2""PM_Payment_WORK.Address 1PM_Payment_WORK.Address 2""""PM_Payment_WORK.CityPM_Payment_WORK.StatePM_Payment_WORK.Zip Code"" )

 

Address Line 3

FUNCTION_SCRIPT(rw_SelectAddrLine3""PM_Payment_WORK.Address 1PM_Payment_WORK.Address 2""""PM_Payment_WORK.CityPM_Payment_WORK.StatePM_Payment_WORK.Zip Code"" )

 

 

Below is what I added to try to get the 4th Address line to print…. The outcome is the report does not print Address Line 4

Address Line 4

FUNCTION_SCRIPT(rw_SelectAddrLine4""PM_Payment_WORK.Address 1PM_Payment_WORK.Address 2""""PM_Payment_WORK.CityPM_Payment_WORK.StatePM_Payment_WORK.Zip Code"" )

Can anyone help in determining the code I should use for Vendor Address Line 4 that will print the 4th line of the address and THEN the city, state, zip.... and I hope I've explained things sufficientl.

Thanks in advance!

Mary

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    You need to insert Address 3 into the formula where the "" marks appear after Address 2. Remove the first set of "" marks and insert Address 3 in each of the calculated fields. I always edit the package file to do this sort of thing. If you export the report to a package file, change the calculated fields to look like this:

    CalculatedField "Vendor Address Line 1"

    {

    EvaluateAfter ""

    Expression "'rw_SelectAddrLine'( 1 \"\" 'PM_Payment_WORK'.'Address 1''PM_Payment_WORK'.'Address 2''PM_Payment_WORK'.'Address 3'\"\" 'PM_Payment_WORK'.'City''PM_Payment_WORK'.'State''PM_Payment_WORK'.'Zip Code'\"\"  )  "

    ResultType "String"

    }

    CalculatedField "Vendor Address Line 2"

    {

    EvaluateAfter ""

    Expression "'rw_SelectAddrLine'( 2 \"\" 'PM_Payment_WORK'.'Address 1''PM_Payment_WORK'.'Address 2''PM_Payment_WORK'.'Address 3'\"\" 'PM_Payment_WORK'.'City''PM_Payment_WORK'.'State''PM_Payment_WORK'.'Zip Code'\"\"  )  "

    ResultType "String"

    CalculatedField "Vendor Address Line 3"

    {

    EvaluateAfter ""

    Expression "'rw_SelectAddrLine'( 3 \"\" 'PM_Payment_WORK'.'Address 1''PM_Payment_WORK'.'Address 2''PM_Payment_WORK'.'Address 3'\"\" 'PM_Payment_WORK'.'City''PM_Payment_WORK'.'State''PM_Payment_WORK'.'Zip Code'\"\"  )  "

    ResultType "String"

    }

    This doesn't come out real well on the forum, but I'd be happy to send you either the package file or the notepad file. If that's all you want to change, I'd also be willing to change your package file if you want to send it to me. (leslievail@earthlink.net)

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at

    Thanks Leslie -- I sent you a separate e-mail asking for the notepad file!

    I appreciate the help!

    Mary

  • Community Member Profile Picture
    Community Member on at

    Thanks everyone for your suggestions... I was able to fix it yesterday... YIPPEE!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans