Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I wanted to get steps out there on how to add the "Additional Information" field from the Internet Information window to the SOP Blank Invoice Form report in Microsoft Dynamics GP. The steps can be applied to other Sales documents like the Picking ticket or Sales Order.
The Calculated field will end up looking like the following:
FUNCTION_SCRIPT(RW_GetInternetText"CUS"RM_Customer_MSTR.Customer NumberRM_Customer_MSTR.Address Code8019 )
Open Report Writer
Open Report Writer - Microsoft Dynamics GP > Tools > Customize > Report Writer
If asked for a Product, select Microsoft Dynamics GP
On the Original Reports side, highlight SOP Blank Invoice Form and Insert to the right.
Then on the Modified Reports side, highlight the same report and choose Open.
Link the RM Customer MSTR table to the Sales Transaction Work table
Create the calculated field for the first line of the Additional Information field
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: You can change "CUS" to one of the following to apply this function to other fields in GP:
CMP = COMPANYVEN = VENDORCUS = CUSTOMERPLOYEEITM = ITEMSLP = 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 textThe 9 refers to the field on the window
1 = Email2 = Home Page3 = FTP Site4 = Image5 = Login6 = Password7 = User Defined 18 = User Defined 29 = Addl Info10 = TO address11 = CC address12 = BCC address
The Calculated field should display as follows:
Add fields to the layout of the report
In the Toolbox window, click Calculated Fields, and then click Additional Information Field Line 1.
Drag the field to the H2 section
Double-click Additional Information Field Line 1
In the Display Type list, click Data.
Save the modified report and set security to the modified report. (Administration >> Setup >> System >> Alternate/Modified Forms and Reports)
If you are using the function to pull single fields from the internet informant window, for example the email field. You do not need to incorporate the character length of the string or the line of text. The function would look like the following:
FUNCTION_SCRIPT(RW_GetInternetInfo"CUS"RM_Customer_MSTR.Customer NumberRM_Customer_MSTR.Address Code1 )
Note: Steps were tested on GP 2015 R2 and GP 2016 R2.
Hope you find this information helpful!
Kelsey Koep | Support Engineer | Microsoft Dynamics GP