In the Toolbox window, click Calculated Fields, and then click New.
In the Name field, type “Additional Information Field Line 1.”
In the Result Type list, click String, and then click Calculated in the Expression Type area.
Click the Functions tab, and then click User-Defined.
In the Core list, click System, click RW_GetInternetText in the Function list, and then click Add.
Click the Constants tab, click String in the Type list, type CUS in the Constant field, and then click Add.
Note: this function also works for other fields in GP:
CMP = COMPANY
VEN = VENDOR
CUS = CUSTOMER
EMP = EMPLOYEE
ITM = ITEM
SLP = SALESPERSON
Click the Fields tab, click RM Customer MSTR under the Resources list, click Customer Number in the Fields list, and then click Add.
From the Fields tab again, click RM Customer MSTR under the Resources list, click Address Code in the Fields list, and then click Add.
Select the Constants tab.
Click Integer in the Type list, type 80 in the Constant field, and then click Add.
Type 1 in the Constant field, and then click Add.
Type 9 in the Constant field, and then click Add.
Note: The values 80,1 and 9 refer to the following:
The 80 refers to the character length of the string.
The 1 refers to the first line of text
The 9 refers to the field on the window
1 = Email
2 = Home Page
3 = FTP Site
4 = Image
5 = Login
6 = Password
7 = User Defined 1
8 = User Defined 2
9 = Addl Info
10 = TO address
11 = CC address
12 = BCC address
The Calculated field should display as follows:
FUNCTION_SCRIPT(RW_GetInternetText"CUS"RM_Customer_MSTR.Customer NumberRM_Customer_MSTR.Address Code5019 )
- Click OK
- Repeat steps 1 through step 13 in this section if you want to print additional lines from the Additional Information field. In step 11, replace 1 with the number of the additional line that you want to print. For example, if you want to print the second line of the Additional Information field, type 2.
Save the modified report and set security to the modified report. (Administration >> Setup >> System >> Alternate/Modified Forms and Reports)