WordCustomRefiner2#afd1ca55-403d-404c-b60c-692906bef937
WordCustomRefiner3#cb001ab7-1f19-4da1-8860-3e04d243802c

​​

How to Modify the "Bill To Address Line" Field and the "Ship To Address Line" Field on the SOP Blank Invoice Form Report in Sales Order Processing in Microsoft Dynamics GP

Last Modified Wednesday, January 6, 2016
Top Solution

Download

This article describes how to modify the following fields on the SOP Blank Invoice Form report in Sales Order Processing in Microsoft Dynamics GP:

Sign In Popup
Lock Icon

The content of this page is locked.

To access this information log in to CustomerSource.

Unable to log in to CustomerSource?

Visit our CustomerSource Help Page.

Close

Lock Icon

The content of this page is locked.

To access this information log in to CustomerSource.

Unable to log in to CustomerSource?

Visit our CustomerSource Help Page.

Lock Icon

Your current service plan does not allow access to this information.

To learn more about Microsoft Dynamics Service Plans review our
service plan offerings.

  • The Bill To Address Line field 
  • The Ship To Address Line field

Additionally, this article describes how to add a comma character (,) between the City field and State field in the Ship To Address Line 3 field.

MORE INFORMATION
To modify the Bill To Address Line field and Ship To Address Line field on the SOP Blank Invoice Form report, follow these steps:

1. If the existing Microsoft Dynamics GP reports have been modified, back up the Reports.dic file. To locate the Reports.dic file, follow these steps:

a. Use the appropriate method:

  • In Microsoft Dynamics GP 10.0 or higher, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to System, and then click Posting Accounts.
  • In Microsoft Dynamics GP 9.0 or in earlier versions, point to Setup on the Tools menu, point to System, and then click Edit Launch File.

b. If you are prompted to enter the system password, type your password, and then click OK.

c. In Microsoft Dynamics GP 9.0 or higher, click Microsoft Dynamics GP in the Edit Launch File window. In Microsoft Business Solutions - Great Plains 8.0, click Great Plains in the Edit Launch File window.

d. Note the path that appears in the Reports box.

e. Click OK to close the Edit Launch File window.

2. Create 2 new calculated fields. To do this, follow these steps:

a. Start Report Writer. To do this, click Tools, point to Customize, and then click Report Writer.

b. In Microsoft Dynamics GP 9.0 or higher, click Microsoft Dynamics GP in the Product list. In Microsoft Business Solutions - Great Plains 8.0, click Great Plains in the Product list.

c. Click Reports.

d. In the Original Reports list, click SOP Blank Invoice Form, and then click Insert.

e. In the Modified Reports list, click SOP Blank Invoice Form, and then click Open.

f. Click Layout.

g. In the Toolbox window, click Calculated Fields in the Resources list, and then click New.

h. In the Name box, type a name for the calculated field. For example, type City, State, or ZIP in the Name box.

i. In the Result Type list, click String, and then click Calculated in the Expression Type box.

j. On the Functions tab, click System-Defined, click STRIP in the Function list, and then click Add.

k. On the Fields tab, click Customer Master Address File in the Resources list, click City in the Field list, and then click Add.

l. Click after the last ) in the Expressions Calculated field to close the function.

m. In the Operators area, click CAT.

n. On the Constants tab, click String in the Type list, type a comma character and enter a space character in the Constant field, and then click Add.

o. In the Operators area, click CAT.

p. On the Functions tab, click System-Defined, click STRIP in the Function list, and then click Add.

q. On the Fields tab, click Customer Master Address File in the Resources list, click State in the Field list, and then click Add.

r. Click after the last ) in the Expressions Calculated field to close the function.

s. In the Operators area, click CAT.

t. On the Constants tab, click String in the Type list, enter two space characters in the Constant field, and then click Add.

u. In the Operators area, click CAT.

v. On the Functions tab, click System-Defined, click STRIP in the Function list, and then click Add.

w. On the Fields tab, click Customer Master Address File in the Resources list, click Zip, and then click Add.

x. The following function script appears.

STRIP (RM_Customer_MSTR_ADDR.City) # “, ” # STRIP (RM_Customer_MSTR_ADDR.State) # “ ” # STRIP (RM_Customer_MSTR_ADDR.Zip)

Note Additionally, you can perform similar steps if you want to add a comma character between the City field and State field in the Ship To Address Line 3 field. To do this, follow steps 2a-2x. However, throughout these steps, click Sales Transaction Work instead of Customer Master Address File in the Resources list.

y. Click OK.

3. Replace the existing Bill To Address Line 3 field with the new calculated field. To do this, follow these steps:

a. In the Page Header area of the report layout, click the Bill To Address Line 3 field, and then press DELETE.

b. In the Toolbox window, click the new calculated field that you created in steps 2g-2y. Then, drag that field to the same location on the report layout where the Bill To Address Line 3 field was.

c. Repeat steps 3a and 3b in the Report Header section of the report layout.

4. Replace the existing Ship To Address Line 3 field with the new calculated field. To do this, follow these steps:

a. In the Page Header area of the report layout, click the Ship To Address Line 3 field, and then press DELETE.

b. In the Toolbox window, click the new calculated field that you created in steps 2g-2y, and then drag that field to the same location on the report layout where the Ship To Address Line 3 field was.

c. Repeat steps 4a and 4b in the Report Header section of the report layout.

Note Steps 3 and 4 only work if all the customers have at least two lines of address information other than the following fields:

  • The City field
  • The State field
  • The ZIP Code/Postal Code field

If all the customers have only one line of address information other than the previously mentioned fields, you must delete the Bill To Address Line 2 and Bill To Address Line 3 fields from the report layout.

5. On the File menu, click Microsoft Dynamics GP or Microsoft Business Solutions-Great Plains.

6. When you are prompted to save the changes to the report layout, click Save.

7. When you are prompted to save the changes to the report, click Save.

8. Use one of the following methods to grant the user access the report.

Method 1: Use the standard Microsoft Dynamics GP or Microsoft Business Solutions - Great Plains security

a. On the Tools menu, point to Setup, point to System, and then click Security.

Note If you are prompted to enter the system password, type the system password.

b. In the User ID list, click the identifier who will access the report.

c. In the Type list, click Modified Reports.

d. In the Series list, click Sales.

e. In the Access List box, double-click SOP Blank Invoice Form, and then click OK.

Note After you click OK, an asterisk (*) appears next to the report name.

Method 2: Use Advanced Level Security in Microsoft Dynamics GP or Microsoft Business Solutions - Great Plains

a. On the Tools menu, point to Setup, point to System, and then click Advanced Security.

Note If you are prompted to enter the system password, type the system password

b. Click View, and then click by Alternate, Modified and Custom.

c. Expand Microsoft Dynamics GP or Great Plains, expand Reports, expand Sales, and then expand SOP Blank Invoice Form.

d. Click Microsoft Dynamics GP (Modified) or Great Plains (Modified).

e. Click Apply, and then click OK.

Note By default, the current user and company are selected when you start Advanced Level Security. Any changes that you make apply to the current user and company. However, you can select additional users in the Advanced Security dialog box in the User area. You can select additional companies in the Advanced Security dialog box in the Company area.

Method 3: Microsoft Dynamics GP 10.0 or higher

a. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then click Alternate/Modified Forms and Reports.

b. If you are prompted, type the system password in the Please Enter Password box, and then click OK.

c. In the ID box, type the ID of the user who will print this modified report.
d. In the Product list, click Microsoft Dynamics GP.

e. In the Type list, click Reports.

f . Expand the Sales folder.

g. Expand the SOP Blank Invoice Form.

h. Click Microsoft Dynamics GP (Modified).

i. Click Save.

APPLIES TO

  • Sales Order Processing
  • Report Writer
  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions-Great Plains 8.0
https://mbsauthor.partners.extranet.microsoft.com/sites/CSGP/global/Learning/Pages/MSD_GPModifySOPBlankInvoiceForm.aspx
No
Microsoft Dynamics GP