INTRODUCTION
This article describes how to add the receiving user-defined fields to the POP Receivings Posting Journal report in Microsoft Dynamics GP or in Microsoft Business Solutions – Great Plains 8.0.
MORE INFORMATION
Add the user-defined fields
1. |
Open Report Writer in Microsoft Dynamics GP as follows: • In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Customize , and then click Report Writer . |
2. |
Click Tables . |
3. |
In the Tables window, click POP_Receipt , and then click Open . |
4. |
In the Table Definition window, click Relationships , and then click New . |
5. |
Click the ellipsis button to the left of the Secondary Table line. |
6. |
Click Purchasing Receipt User Defined , and then click OK . |
7. |
For the Secondary Table Key , select (POP_ReceiptUserDefinedldx_ID) . |
8. |
In the Primary Table list, click POP Receipt Number . |
9. |
Click OK . |
10. |
Close the Table Relationships window, and then click OK . |
11. |
Close the Tables window. |
12. |
Click Reports . |
13. |
In the Original Reports list, click POP Receivings Posting Journal , and then click Insert . |
14. |
In the Modified Reports list, click the same report, and then click Open . |
15. |
In the Report Definition window click Tables . |
16. |
In the Report Table Relationships window, click Purchase Receipts Work , and then click New . |
17. |
Click Purchasing Receipt User Defined , click OK , and then click Close . |
18. |
In the Report Definition window, click Layout . |
19. |
In the Toolbox, click Purchasing Receipt User Defined . |
20. |
Click User Defined Text 01 or the field that you are using, and then drag it into the H1 section or the RH section of the report. |
Save the report
1. |
Close the Report layout dialog box. |
2. |
If you are prompted to save changes, click Save , and then click OK . |
3. |
On the File menu, click Microsoft Dynamics GP or Microsoft Business Solutions - Great Plains . |
Grant access to the report
In Microsoft Dynamics GP 10.0
1. |
Create the ID to print the modified report. To do this, follow these steps:
|
||||||||||
2. |
Assign the security to print the modified report. To do this, follow these steps:
|
In Microsoft Dynamics GP 9.0 or in Microsoft Business Solutions - Great Plains 8.0
Method 1: Use the Advanced Security tool
1. |
On the Tools menu, point to Setup , point to System , and then click Advanced Security . |
2. |
Type the system password if you are prompted. |
3. |
Click View , and then click by Alternate, Modified and Custom . |
4. |
Expand the following nodes: • Microsoft Dynamics GP or Microsoft Great Plains |
5. |
Expand the purchase order form that you modified. |
6. |
Click Microsoft Dynamics GP (Modified) or Microsoft Great Plains (Modified) . |
7. |
Click Apply , and then click OK . |
Method 2: Use standard Microsoft Dynamics GP security
1. |
On the Tools menu, point to Setup , point to System , and then click Security . If you are prompted, type the system password. |
2. |
In the User ID list, click the user ID for the user who you want to have access to the report. |
3. |
In the Type list, click Modified Reports . |
4. |
In the Series list, click Purchasing . |
5. |
In the Access List box, double-click the report that you modified, and then click OK . An asterisk (*) appears next to the report name. |