Enhance Dynamics GP Packing Slips: Adding Notes to SOP Blank Forms

Table of Contents

In the realm of enterprise resource planning, the ability to customize documents to fit specific business needs is paramount. This article provides a comprehensive guide on how to integrate vital shipping method notes directly onto your SOP Blank Packing Slips within Microsoft Dynamics GP. This customization is applicable across various versions of Microsoft Dynamics GP and addresses the original KB number 925662. By following these detailed steps, you can ensure that critical information, such as shipping company addresses or special handling instructions, is always present on your outgoing documentation.

The primary objective of this customization is to seamlessly embed notes that are associated with a shipping method into the SOP Blank Packing Slip. Imagine a scenario where each shipping company you utilize has a unique pick-up address or specific delivery instructions. Instead of manually adding this information to each order, you can assign a dedicated shipping method for each carrier and store their specific details within the shipping method’s notes. When a packing slip is generated, these notes will automatically appear, streamlining operations and reducing potential errors. This approach not only enhances the utility of your packing slips but also contributes to better logistical coordination and customer satisfaction.

Understanding the Importance of Customization in Dynamics GP¶

Microsoft Dynamics GP offers robust reporting capabilities, but often, standard reports require modification to meet unique business processes or compliance requirements. The ability to add custom data fields, like shipping method notes, directly onto critical documents such as packing slips, provides immense value. This customization ensures that all necessary information travels with the physical goods, aiding warehouse staff, delivery personnel, and ultimately, the end customer. Beyond mere addresses, these notes could include anything from specific loading dock instructions to contact numbers for delivery coordination, making the packing slip a truly comprehensive document.

Before embarking on any customization within Microsoft Dynamics GP, it is always recommended to perform these actions in a test environment first. This approach safeguards your live production data and allows you to thoroughly validate the changes without impacting ongoing business operations. Once tested and verified, the modified report can then be safely imported into the production environment. Always ensure that you have administrative access and the necessary permissions to modify reports and security settings within Dynamics GP.

Backing Up the Reports.dic File¶

The Reports.dic file is a crucial component of your Microsoft Dynamics GP installation, as it stores all modified reports. Before making any changes, creating a backup of this file is an essential best practice. This backup serves as a safeguard, allowing you to easily revert to a previous version of your reports if any issues arise during the customization process or if the changes do not meet your expectations. Without a proper backup, unintended modifications could lead to significant data loss or operational disruptions, making this first step paramount.

To locate and back up your Reports.dic file, follow these precise instructions:

1. On the Tools menu within Dynamics GP, navigate to Setup, then point to System, and finally click on Edit Launch File.
2. If prompted to provide a system password, enter the correct password and click OK to proceed. This security measure ensures that only authorized personnel can access and modify critical system settings.
3. In the Edit Launch File window, you will see a list of products. Click either Microsoft Dynamics GP (for GP 9.0 and later versions) or Great Plains (for Microsoft Business Solutions - Great Plains 8.0). Pay close attention to the path displayed in the Reports box, as this indicates the location of your Reports.dic file.
4. Once you have noted the path, click OK to close the Edit Launch File window. Navigate to the noted directory using your operating system’s file explorer, locate the Reports.dic file, and copy it to a secure backup location. This simple action can save significant time and effort in case of unforeseen complications.

Opening Report Writer¶

Report Writer is the integrated tool within Microsoft Dynamics GP that allows users to customize existing reports or create new ones from scratch. It provides a graphical interface to manipulate report layouts, add or remove fields, and establish relationships between different database tables. Accessing Report Writer is the gateway to implementing the changes required for our packing slip customization, offering a powerful environment for tailoring your reporting output. Understanding its basic functions will empower you to manage and maintain your custom reports effectively.

To access the Report Writer module, follow these steps:

1. From the main Dynamics GP window, go to the Tools menu.
2. Point to Customize, and then click on Report Writer. This action will launch the Report Writer application, opening a new window dedicated to report customization.
3. In the Product list that appears, select the appropriate option: either Microsoft Dynamics GP or Great Plains, depending on the version of the software you are currently running. This selection ensures that you are working within the correct report dictionary for your specific Dynamics GP installation.
4. Finally, click OK to open the Report Writer main window. From here, you can begin the process of modifying the SOP Blank Packing Slip Form, leveraging the full capabilities of the Report Writer tool.

Creating a New Table Relationship¶

To retrieve the notes associated with a shipping method, we must establish a new data relationship within Report Writer. This involves linking the SOP_Document_HDR_TEMP table, which holds the primary sales order information, to the Shipping Methods Master table. This crucial link allows Report Writer to access the shipping method details, including its unique identifier, which is necessary to then retrieve the actual note content. Building accurate table relationships is foundational to successful report customization, ensuring that all necessary data points are correctly joined.

Here are the detailed steps to create this essential table relationship:

1. On the Report Writer toolbar, locate and click the Tables icon (often represented by a grid or database symbol), and then select Tables from the dropdown. This action opens the Tables window, displaying a list of all available tables within Dynamics GP.
2. In the Tables window, scroll through the list and click to highlight SOP_Document_HDR_TEMP. This is the temporary header table for Sales Order Processing documents. Once selected, click the Open button.
3. With the SOP_Document_HDR_TEMP table open, click the Relationships button, and then click New to define a new connection. This will open a new dialog box where you can specify the parameters of your table relationship.
4. Next to the Secondary Table field, click the ellipsis button (…). This action will open the Relationship Table Lookup window, allowing you to select the table you wish to link.
5. In the Relationship Table Lookup window, find and click on Shipping Methods Master, then click OK. This table contains all the predefined shipping methods and their associated data, including the field for notes.
6. Back in the relationship definition window, in the Secondary Table Key list, select SY_Shipping_Methods_MSTR_Key1. This is the primary key for the Shipping Methods Master table.
7. To establish the link, you must match a field from the SOP_Document_HDR_TEMP table (the primary table) to the Shipping Method field in the Shipping Methods Master table (the secondary table). Locate and select Shipping Method in the Primary Table list. This creates a one-to-one or one-to-many link, allowing data to flow between the tables based on the common shipping method identifier.
8. Finally, click OK to save the new relationship. Close all open windows. If prompted to save changes to the table definition, click Save. This completes the initial crucial link necessary for accessing shipping method data.

Opening the SOP Blank Packing Slip Form¶

With the necessary table relationship established, the next step involves opening the specific report we intend to modify: the SOP Blank Packing Slip Form. This report serves as the foundation for our customization, and Report Writer provides a mechanism to select and bring it into the modification environment. It’s important to distinguish between the original report and the modified version, as any changes we make will be saved as a modified report, leaving the original intact. This ensures that you can always revert to the default if needed.

Follow these steps to access and open the target report:

1. In the main Report Writer window, click the Reports button. This will open the Report Definition window, listing all available reports in your Dynamics GP installation.
2. In the Original Reports list, scroll down and locate SOP Blank Packing Slip Form. This is the standard, un-modified version of the packing slip. Once highlighted, click the Insert button. This action moves a copy of the report from the “Original Reports” list to the “Modified Reports” list, signaling that you intend to make changes.
3. Now, in the Modified Reports list, click to select SOP Blank Packing Slip Form. This is the copy you just inserted and will be working on. With the report highlighted, click the Open button. This will open the Report Definition window for the SOP Blank Packing Slip Form, providing access to its layout, tables, and fields.

Adding the Record Notes Master Table to the SOP Blank Packing Slip Form¶

The Shipping Methods Master table provides the identifier for the note, but the actual textual content of the note is stored in a separate table: Record Notes Master. To display the shipping method notes on the packing slip, we need to create a further relationship, linking the Shipping Methods Master table to the Record Notes Master table. This creates a chain of relationships that allows Report Writer to traverse from the sales document, to the shipping method, and finally, to the specific note text. This multi-step linking is common in complex report customizations.

Here’s how to establish this final link:

1. In the Report Definition window for the SOP Blank Packing Slip Form, click the Tables button. This opens the Report Table Relationships window, showing all tables currently linked to the report.
2. In the Report Table Relationships window, you will see a list of existing table connections. Click on 01.Sales Document Header Temp, and then click the New button. This indicates that you want to add a new table relationship stemming from this primary document header table.
3. In the subsequent Related Tables window, click on Shipping Methods Master, and then click OK. This action adds the Shipping Methods Master table to the report’s list of related tables, making its data accessible.
4. Now, back in the Report Table Relationships window, locate and click on 05.-Shipping Methods Master (the number might vary slightly depending on your existing relationships, but the name will be consistent). With Shipping Methods Master selected, click New again to define a relationship from it.

5. In the Related Tables window that appears, click on Record Notes Master, and then click OK. This finalizes the chain, allowing access to the actual note content.

   Understanding the Report Table Relationships:
   At this stage, your list of report table relationships should reflect a logical flow of data required for the packing slip. The sequence typically follows how information is retrieved. For clarity, the list of items in the Report Table Relations list should closely resemble the following structure:
   1. Sales Document Header Temp (Primary starting point for sales orders)
   2. Sales Transaction Work (Details of the sales transaction)
   3. Customer Master Address File (Customer address information)
   4. Sales User-Defined Work History (Any custom fields or historical data)
   5. Shipping Methods Master (Contains details of the chosen shipping method)
   6. Record Notes Master (Holds the actual text content of the notes)
   7. Sales Document Line Temp* (Details for individual line items on the sales order)
   8. Sales Transaction Amounts Work* (Financial figures related to the transaction)
   9. Sales Line Comment Work and History (Comments associated with specific sales lines)
   10. Sales Serial/Lot Work and History* (Serial or lot number tracking)

   Note: Items marked with an asterisk (*) are typically related to line-item details, while the top portion focuses on header-level information. The exact order and presence of some tables might vary based on specific Dynamics GP setup and prior customizations.

   mermaid graph TD A[SOP_Document_HDR_TEMP] --> B[Shipping Methods Master] B --> C[Record Notes Master]
   This Mermaid diagram visually represents the core table relationships established for this customization.

6. After verifying the relationships, click Close to exit the Report Table Relationships window. All necessary data connections are now in place, paving the way for placing the note field on the report layout.

Adding the Note Field to the Page Header of the Report¶

With all the required tables linked, the final step in Report Writer is to physically drag the note field onto the report’s layout. Placing the field in the Page Header (PH) section ensures that the shipping method notes appear consistently at the top of every page of your packing slip, providing immediate visibility for relevant personnel. Report Writer’s intuitive drag-and-drop interface simplifies this process, allowing you to position and format the field as needed.

Follow these steps to add the note field to your report layout:

1. From the Report Definition window, click the Layout button. This will open the Report Layout window, presenting a visual representation of your packing slip. The window is divided into various sections (e.g., Page Header, Body, Page Footer).
2. In the Toolbox window (which usually appears on the left side of the screen), you will see a Resource list. Use the dropdown to select Record Notes Master. This action will populate the fields list with all available fields from the Record Notes Master table.
3. Locate the Text Field field within the list. Click and drag this Text Field field directly into the PH (Page Header) section of the Report Layout window. Position it where you want the shipping method notes to appear on the packing slip. You can resize and move the field as needed to fit your desired layout and ensure readability.
4. Once the field is placed, you can optionally right-click on it to access its properties. Here, you can adjust formatting such as font size, color, and alignment, or set conditions for when the text should print. Ensure the field is wide enough to display the full note content without truncation.
5. After positioning and formatting the field to your satisfaction, close the Report Layout window.
6. When prompted to save the changes to the report layout, click Save. This action commits your layout modifications to the modified report.
7. In the Report Definition window, click OK to finalize the report modification process.
8. Finally, on the File menu, click either Microsoft Dynamics GP or Microsoft Business Solutions - Great Plains to exit Report Writer and return to the main Dynamics GP interface.

Granting Access to the Report¶

After successfully modifying the SOP Blank Packing Slip Form, the final crucial step is to grant users access to this new, customized report. Without proper security assignments, users will continue to print the original, unmodified packing slip. Dynamics GP offers two primary methods for managing security: Standard Security and Advanced Level Security. Both methods achieve the same goal but cater to different levels of granularity and organizational complexity. Choosing the appropriate method depends on your company’s existing security configuration and needs.

Method 1: Use Standard Security in Microsoft Dynamics GP¶

Standard Security is ideal for simpler environments where security roles are less granular. This method allows you to quickly assign modified reports to specific users.

1. On the Tools menu, point to Setup, then System, and then click Security.
2. If prompted to enter the system password, type the password and click OK.
3. In the User ID list, select the specific user ID for whom you want to enable access to the modified packing slip.
4. In the Type list, select Modified Reports. This filters the list to show only reports that have been altered.
5. In the Series list, select Sales. This focuses the report list on sales-related documents.

6. In the Access List box, locate and double-click SOP Blank Packing Slip Form. An asterisk (*) will appear next to the report name, indicating that the user now has access to the modified version. Click OK to save the security changes.

   Note: The asterisk appearing next to the report name is a visual confirmation that the user is now assigned to the modified version of the report, not the original.

Method 2: Use Advanced Level Security in Microsoft Dynamics GP¶

Advanced Level Security provides more granular control over report access, allowing for complex security configurations based on roles and tasks. This method is often preferred in larger organizations with intricate security policies.

1. On the Tools menu, point to Setup, then System, and then click Advanced Security.
2. If prompted, enter the system password and click OK.
3. In the Advanced Security window, click View, and then select by Alternate, Modified and Custom. This view allows you to see the modified reports.
4. Expand either Microsoft Dynamics GP or Great Plains (depending on your version), then expand Reports, then Sales, and finally expand SOP Blank Packing Slip Form.
5. Under SOP Blank Packing Slip Form, you will see different versions. Click either Microsoft Dynamics GP (Modified) or Great Plains (Modified) to select the customized report.

6. Click Apply to commit the changes, and then click OK to close the Advanced Security window.

   Note: By default, when you launch Advanced Level Security, the current user and current company are selected. Any changes you make will apply to this default selection. However, you have the flexibility to select other users from the User area and additional companies from the Company area within the Advanced Level Security window if you need to apply these changes to a broader group or across different legal entities.

Testing and Validation¶

After all the modifications and security assignments are complete, rigorous testing is absolutely crucial. This step ensures that the packing slip prints correctly, the shipping method notes appear as expected, and no unintended side effects have been introduced. Always perform these tests in a non-production environment first to avoid any disruption to live operations.

To effectively test your customized report:

1. Log in to Microsoft Dynamics GP as a user who has been granted access to the modified SOP Blank Packing Slip Form.
2. Navigate to the Sales Transaction Entry window and create a new sales order, or open an existing one.
3. Crucially, ensure that a shipping method with an associated note is selected for this sales order. You might need to go into the Shipping Methods Setup window (under Setup > Inventory > Shipping Methods) and add a test note to one of your shipping methods.
4. Generate a packing slip for this sales order. When prompted, ensure you select the modified version of the report (it should be the default if security is set correctly).
5. Carefully review the printed or previewed packing slip. Verify that the shipping method note appears in the Page Header section exactly as intended, without any formatting issues or missing text.
6. Test with various shipping methods, some with notes and some without, to confirm that the report handles all scenarios gracefully. Also, test with sales orders that span multiple pages to confirm the note appears on every page.
7. If any issues arise, revisit the steps in Report Writer (especially table relationships and field placement) or security settings to troubleshoot.

Troubleshooting Common Issues¶

Even with careful execution, customization can sometimes lead to unexpected issues. Knowing how to troubleshoot common problems can save significant time.

• Note Not Appearing: Double-check your table relationships in Report Writer. Ensure SOP_Document_HDR_TEMP is linked to Shipping Methods Master, and Shipping Methods Master is linked to Record Notes Master. Verify that a note actually exists for the shipping method selected on the sales order. Also, confirm the Text Field from Record Notes Master was indeed dragged onto the report layout.
• Report Printing Original Version: This is almost always a security issue. Revisit the “Grant Access to the Report” section and ensure the correct modified report is assigned to the user trying to print it. Confirm the asterisk appears next to the modified report name in Standard Security, or the modified version is selected in Advanced Security.
• Formatting Problems: If the note is cut off or improperly formatted, open the report layout in Report Writer. Adjust the size and position of the Text Field in the Page Header section. You might need to make it wider or taller, or change font properties in its field properties window.
• Performance Issues: While unlikely for this specific customization, complex report modifications can sometimes affect performance. If you notice slowdowns, review your table relationships for any inefficiencies.

By methodically checking these points, you can resolve most issues encountered during and after the customization process.

Conclusion¶

Successfully enhancing your Dynamics GP packing slips by adding shipping method notes can significantly improve your logistical efficiency and communication. This detailed guide has walked you through every step, from backing up critical files and establishing complex table relationships to placing the note field on the report layout and assigning appropriate user access. The ability to automatically include vital shipping information directly on your outgoing documents not only streamlines internal processes but also ensures that critical instructions or carrier details are never overlooked.

We encourage you to implement this valuable customization in your Dynamics GP environment. Have you customized your packing slips in other ways? Do you have any tips or tricks for working with Dynamics GP Report Writer? Share your experiences and insights in the comments below! Your feedback and shared knowledge can help other users navigate their own customization journeys.