Wednesday, June 18, 2008

Enabling Address Third Line in Microsoft Dynamics GP Report Writer

Ok, I felt the need to write about this because I still cannot understand why, after so many years, the Microsoft Dynamics GP development team cannot extend the courtesy of adding the extra calculated field required to display the address third line for customers, vendors, etc., and anyone who happens to have a third line in their address.

Case in point, if your address happens to be:

1972 Western Boulevard
Tower C
Suite 400
COLUMBUS, OH 43203

Dynamics GP will display on all its reports:

1972 Western Boulevard
Tower C
COLUMBUS, OH 43203


Now, that's just a bummer! Anyways, to correct this issue you will need to modify all reports where you need to display a third line by incorporating a fourth calculated field -- follow whatever convention used by Microsoft to create the calc field as it will make your life easier. 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 in this post, but in Report Writer these will not exist between each parameter of the function script. Normally, you would find 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 to certain reports, 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, special attention is required for 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.

Until next post!

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

1 comment:

Angela Palmer said...

Thank you so much for this!! I posted this question on a Microsoft Dynamics GP forum and someone led me to it. I don't have much experience with report writer, so I am going to work with our IT department to follow your instructions.

Thanks again for your help!