How to add Internet information for an item to the "SOP Blank Invoice" form in Microsoft Dynamics GP


SUMMARY

This article contains step-by-step instructions for how to modify the SOP Blank Invoice form. To successfully modify this form, you must open it by using Report Writer in Microsoft Dynamics GP. Then, you must create a new calculated field for the form.

After you create this calculated field, you must insert it into the report layout, and then save the changes to the report. Finally, you must assign security permissions to the report. This article includes detailed instructions for each of these steps.

INTRODUCTION

This article describes how to add Internet information for an item to the SOP Blank Invoice form in Microsoft Dynamics GP.

MORE INFORMATION

To add Internet information for an item to the SOP Blank Invoice form, follow these steps.

Step 1: Start Report Writer

a. In Microsoft Dynamics GP, point to Customize on the Tools menu, and then click Report Writer .
b. In the Product list, click Microsoft Dynamics GP , and then click OK .
c. Click Reports .

Step 2: Open the SOP Blank Invoice form

a. In the Report Writer window, click SOP Blank Invoice Form in the Original Reports list.
b. To move this report to the Modified Reports list, click Insert .
c. In the Modified Reports list, click SOP Blank Invoice Form , and then click Open .
d. In the Report Definition window, click Layout .

Step 3: Create a calculated field for the SOP Blank Invoice form

a. In the Toolbox window, click Calculated Fields in the list that appears on the Layout tab.
b. Click New .
c. In the Calculated Field Definition window, type Item Home Page in the Name box.
d. In the Result Type list, click String .
e. In the Expression Type box, click Calculated .
f. Click the Expressions Calculated box, click the Functions tab, and then click User-Defined .
g. In the Core list, click System .
h. In the Function list, click RW_GetInternetInfo , and then click Add .
i. Click the Constants tab, click String in the Type list, type ITM in the Constant box, and then click Add .
j. On the Fields tab, click Sales Transaction Amounts Work in the Resources list, click Item Number in the Field list, and then click Add .
k. Click the Constants tab, click String in the Type list, leave the Constant box blank, and then click Add .
l. In the Type list, click Integer , type 2 in the Constant box, and then click Add . The following information appears in the Expressions Calculated box:

FUNCTION_SCRIPT(RW_GetInternetInfo"ITM"SOP_LINE_WORK.Item Number""2)

Note This calculated field displays the information that appears in the Home Page field of the Internet Information window.
m. Follow steps a through l for each line that you want to print in the report. For example, to print the information that is displayed in the E-mail field of the Internet Information window, type 1 in the Constant box in step l. In this situation, the following information appears:

FUNCTION_SCRIPT(RW_GetInternetInfo"ITM"SOP_LINE_WORK.Item Number""1)

n. Click OK .

Step 4: Add the calculated field to the report layout

a. In the Toolbox window, leave the Calculated Fields option selected in the list on the Layout tab. Then, drag the Item Home Page field from the list of calculated fields to the H2 area of the report.
b. Modify the size and the location of the Item Home Page field according to your requirements.

Step 5: Save the changes to the report, and then exit Report Writer

a. On the File menu, click Microsoft Dynamics GP or Microsoft Business Solutions - Great Plains .
b. Click Save when you are prompted to save the changes to the report layout.
c. Click Save when you are prompted to save the changes to the modified report.
d. Exit Report Writer.

Step 6: Assign security permissions to the modified report

Method 2: Use the Standard Security tool

a. Open the User Security Setup window by pointing to the Microsoft Dynamics GP menu, then point to Tools, point to Setup, point to System, and then click on User Security.
b. Enter the User Id you are looking to grant access to the modified form/report to.
c. Enter the company this security needs to be granted in.
d. Take down the "Alternate/Modified Forms and Reports ID" that appears at the bottom of the window.
e. Open the Alternate/Modified Forms and Reports window by pointing to the Microsoft Dynamics GP menu, then point to Tools, point to Setup , point to System, then click on Alternate/Modified Forms and Reports.
f. Enter in the Id obtained in step D
g. Select Microsoft Dynamics GP as the product.
h. Select Reports as the Type.
i. Expand the Sales Folder.
j. Find the report you are looking to grant access to in the list that populates and expand it. Make sure it is set to the one labeled (modified)