How to modify the SOP Blank Invoice Form or the SOP Blank Order Form in Report Writer to include the Credit Card Number information from the Sales Payment Entry window
This article describes how to modify the Microsoft Business Solutions - Great Plains Sales Ordering Processing (SOP) SOP Blank Invoice Form or the SOP Blank Order Form in Report Writer to include the Credit Card Number information in Microsoft Dynamics GP and Microsoft Business Solutions - Great Plains.
Applies to: Microsoft Dynamics GP
Original KB number: 850166
Introduction
If you want to include the credit card number on the SOP Blank Invoice Form or on the SOP Blank Order Form, you can't have Serial/Lot information on the same form.
More information
To modify the SOP Blank Invoice Form or the SOP Blank Order Form in Report Writer, follow these steps:
Open Report Writer:
In Microsoft Dynamics GP 10.0, select Microsoft Dynamics GP, select Tools, select Customize, and then select Report Writer.
In Microsoft Business Solutions - Great Plains 8.0 and in Microsoft Dynamics GP 9.0, select Tools, point to Customize, and then select Report Writer.
Create the relationship between the Sales Transaction Amounts Work and the Sales Payment Work and History tables:
- Select the Tables menu, and then select Tables from the drop-down list.
- Select SOP_LINE_WRK from the list of tables, and then select Open.
- In the Table Definition window, select Relationships.
- In the Table Relationship window, select New.
- Select the ellipsis button, select Sales Payment Work and History from the drop-down list, and then select OK.
- Select SOP_Payment_WORK_HIST_Key1 from the Secondary Table Keys list.
- In the Primary Table drop-down list, select SOP Type, select the SOP Number fields, and then select OK. Leave the third drop-down list value blank.
- Select OK or the Close button to close all windows.
Replace the Sales Serial/Lot Work and History table with the Sales Payment Work and History table:
- On the Reports menu, select SOP Blank Invoice Form/SOP Blank Order Form from the list of original reports, and then select Insert.
- Select SOP Blank Invoice Form/SOP Blank Order Form from the list of modified reports, and then select Open.
- In the Report Definition window, select Tables.
- In the Report Table Relationships, select the Sales Serial/Lot Work and History table, and then select Remove.
- Select OK when you're prompted.
- Select the Sales Transaction Amounts Work table, and then select New.
- From the list of Related Tables, select Sales Payment Work and History, and then select OK.
- Select OK to close the window and return to the Report Definition window.
Remove the Serial/Lot restriction and create a new restriction that involves the Sales Payment Work and History table:
- In the Report Definition window, select Restrictions.
- In the Report Restrictions windows, select the Type and Number of SOP_Serial_Lot = self restriction, and then select Delete.
- Select New to create a new restriction.
- Type Dummy as the name for the restriction.
- Select Sales Payment Work and History and Report Table and Amount Paid as the Table Field.
- Select Add Field.
- Select the = button.
- Select Amount Paid as the Table Field, and then select Add Field. The Restriction Expression should now resemble the following example:
SOP_Payment_WORK_HIST.AmountPaid = SOP_Payment_WORK_HIST.AmountPaid - Select OK or the Close button to close all windows, and then go back to the Report Definition window.
Remove any instances of the Serial/Lot Work and History table in the layout of the report:
- Select Layout.
- Remove the Serial/Lot Number field and the (C) Serial/Lot Quantity field in the B section of the report.
- In the toolbox, select Calculated Fields from the drop-down list.
- Select (C) Serial Lot Band from the list of calculated fields, and then select Open.
- Set Integer as the Result Type.
- In the Calculated Expression, select the SOP_Serial_Lot_WORK_HIST.Serial/Lot Number expression, and then select Remove.
- On the Constants tab, select Integer as the Type, and then select 0 as the Constant.
- Select Add.
- Select OK to save the Calculated Field.
- Select (C) Serial Lot Quantity from the list of calculated fields, and then select Open.
- Set Integer as the Result Type, and then select Calculated as the Expression Type.
- Select Yes when you're prompted.
- Remove everything in the Calculated Expression section of the report by highlighting the fields and then selecting Remove.
- On the Constants tab, select Integer as the Type, and then 0 as the Constant.
- Select Add.
- Select OK.
Add the required fields into the report layout:
- In the toolbox, select Sales Payment Work and History from the drop-down list.
- Select Receipt Number Credit Card from the list of fields.
- Drag the Receipt Number Credit Card field to the H2 section on the report.
- Double-click the Receipt Number Credit Card field to open the Report Field Options window.
- Under Visibility, select Hide When Empty, and then select Display Type as Data value.
- Select OK.
- Save the changes to your report.
After you save the report, you'll have to assign security permissions to the modified report to use the report in Microsoft Dynamics GP. To assign security permissions to the modified report, use one of the following methods.
Method 1: Use security in Microsoft Dynamics GP 10.0
On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then select Alternate/Modified Forms and Reports.
In the ID box, type the user ID that will print this modified report.
In the Product list, select Microsoft Dynamics GP.
In the Type list, select Reports.
Expand the Sales folder and then expand the folder that contains the report that you modified.
Select the Microsoft Dynamics GP (Modified) report.
Select Save.
On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then select User Security.
In the User list, select a user ID that will print this modified report.
In the Company list, select a company.
In the Alternate/Modified Forms and Reports ID list, select the ID that you used in step 2.
Method 2: Use the Advanced Security tool in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0
On the Tools menu, point to Setup, point to System, and then select Advanced Security.
If you're prompted, type the system password in the Please Enter Password box, and then select OK.
In the Advanced Security window, select View, and then select By Alternate, Modified and Custom.
Select the modified report:
For Microsoft Dynamics GP 9.0:
Expand Microsoft Dynamics GP, expand Reports, expand Sales, and then expand the folder that contains the report that you modified.
Select the Microsoft Dynamics GP (Modified) report.
For Microsoft Business Solutions - Great Plains 8.0:
Expand Great Plains, expand Reports, expand Sales, and then expand the folder that contains the report that you modified.
Select the Great Plains (Modified) report.
Select Apply, and then select OK.
Note
By default, when you start the Advanced Security tool, Microsoft Dynamics GP 9.0 and Microsoft Business Solutions - Great Plains 8.0 will select the current user and the current company. Any changes that you make will affect the current user and the current company. However, you can select additional users in the Users area of the Advanced Security window. You can select additional companies in the Company Name area of the Advanced Security window.
Method 3: Use the Standard Security tool in a version earlier than Microsoft Business Solutions - Great Plains 8.0
Note
An asterisk (*) will appear next to the report name.
On the Tools menu, point to Setup, point to System, and then select Security.
If you're prompted, type the system password in the Please Enter Password box, and then select OK.
In the User ID list, select the ID of the user or users that you want to have access to the modified report.
In the Type list, select Modified Reports.
In the Series list, select Sales.
In the Access List box, double-click the report that you modified, and then select OK.