Adding Address line 3 to GP Forms

[Pam]

Several of our customers/vendors have addresses that include a 3rd Address
Line (above City, State, Zip).

However, in all of our GP forms, only Address Line 1 & 2, plus
City/State/Zip where added. These all appear to be calculated fields on the
report and I can see where Address Line 3 is available to be chosen -
HOWEVER, I am an absolute novice when it comes to doing calculated fields in
Report Writer.

By using the manual and looking at how the other address lines where
created, I've got the general gist of it; However, when I created "Ship To
Address Line 4" (to include Address Line 3 since calc. Field "Ship to Address
Line 3" contains the City/State/zip), I was attempting to print a packing
slip to the screen to see how it looked when I got the following dialog box:
""MAX Symbol Length exceeded: increase MAX_TOK_LEN""

What the heck does that mean? I have been spending a ton of time trying to
create this calculated field for just one report and I need to add it to all
current forms/historical/.

Thank you

[Graham Anderson]

If you have access to Partnersource/Customersource, look at article 874176
which explains how to use the rw_selectaddrline function.

This prints all of the address lines that exist, and gets rid of white space
for address lines that don't exist.

[Bob Harrison]

The KB article says it does not apply to version 10.0 How do you do this is
version 10?

[Mariano Gomez]

Pam,

Your address calculated fields should look something like this:

Address Line 1 = Function_Script( rw_SelectAddLine 1, "", Address1,
Address2, Address3, "", City, State, Zip, "")

Address Line 2 = Function_Script( rw_SelectAddLine 2, "", Address1,
Address2, Address3, "", City, State, Zip, "")

Address Line 3 = Function_Script( rw_SelectAddLine 3, "", Address1,
Address2, Address3, "", City, State, Zip, "")

Address Line 4 = Function_Script( rw_SelectAddLine 4, "", Address1,
Address2, Address3, "", City, State, Zip, "")

NOTE: I use commas for readability sake, but in Report Writer these will not
exist between each parameter of the function script.

Normally you would find a two blank spaces after the Address2 position in
the function script. Highlight the first blank space, click remove, and chose
Address3 from the appropriate table (RM Customer Address Master, PM Vendor
Address Master, Company Address Master, etc.) and insert in its place.

You will also have to pay attention in certain forms, since you may
encounter address fields on the Report Header and Page Header sections. In
this case, you will have to drag your new AddresLine4 calculated field to
both sections. In addition, pay special attention to the field properties on
both sections as usually they are different. To have access to the field
properties, you can double click on say for example AddressLine3 on each
section and replicate the same properties to AddressLine 4 to ensure you
obtain the right data.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com

[Pam]

Mariano,
Thank you very much for your detailed explaination. You have always been
very helpful.
Pam

[Pam]

Graham, The article was most helpful.
Thank you
pam

[Mariano Gomez]

You are utmost welcome!

[wisk]

I agree. What about in Dynamics GP 10? I cannot get this to work on the Pack
Slip. I also receive the MAX_TOKEN error.