Add Vendor Address Info to Check Remittance in Payables Mgmt

Applies To: Microsoft Dynamics GP 10.0 & Microsoft Dynamics GP2010 (EFT for Payables & Payables Mgmt)

To add the primary vendor address information from the PM Vendor Master file (PM00200) to the EFT Check Remittance report, follow the below steps:

NOTE: The below steps will print the primary address that is shown on the Vendor Mainenance Card in Microsoft Dynamics GP on the EFT Check Remittance Report, regardless of what vendor address ID is on the invoice itself, if various address IDs are used for the vendor. See addt'l info section for more info on pulling in the address information associated with each specific report.

Open Report Writer:

1. In Microsoft Dynamics GP, open Report Writer. To do this, click on Microsoft Dynamics GP -> Tools -> Customize -> Report Writer.
2. Leave the product as Microsoft Dynamics GP and click OK.

Create the table Relationship:

1. Click on Tables and select Tables again.
2. Find the PM_Payment_Work_TRX table. Click to select it and click Open.
3. Click Relationships.
4. Click New.
5. In the Table Relationship Definition window, click on the ellipsis button next to the Secondary table.
6. Find the PM Vendor Master File and click OK.
7. For the Secondary Table Key, click the drop-down list and select PM_Vendor_MSTR_Key1.
8. On the left side, select Vendor ID to match the Vendor ID's up between the tables. Click OK.
9. Close the Table Relationshis window, and click OK on the Table Definition window to close it. Close the Tables window.

Drag the new fields on to the report layout:

1. Now click on Reports in the top menubar.
2. Select the Payables EFT Remittance report and click Insert to move it over to the right side of the window.
3. Click to highlight the report in the Modified Reports list and click Open.
4. The Report Definition window will open.
5. Click on the Tables button to open the Report Table Relationships window.
6. Highlight 01.PM Payment WORK Shadow table and click New.
7. The PM Vendor Master File should be listed and highlighted, so just click OK.
8. In the Toolbox window, use the table drop-down list to select the PM Vendor Master File.
9. Drag the address fields (Address 1, City, State, Zipcode) to the H1 section of the report layout, say under Vendor ID. You may need to adjust this section of the report layout to be bigger.
10. When finished, close all the windows in Report Writer, and click Save to save your changes when prompted.

Grant access to the modified report:

1. Click on File, and Microsoft Dynamics GP to get back to GP.
2. Grant access to the modified report as follows:

• In GP, click on Microsoft Dynamics GP -> Tools -> Setup -> System -> Alternate/Modified Forms and Reports
• Enter the ID for the user (such as Defaultuser)
• Product: Microsoft Dynamics GP
• Type: Reports
• Click the + to expand the Purchasing series
• Click the + to expand the Payables EFT Remittance
• Mark to grant access to the Microsoft Dynamics GP (Modified) version of the report.
• Click Save.

Additional Information: In order to get the vendor address information for different Address IDs associated with each specific invoice to print on the Check Remittance Report, you would have to create an addt'l Tables Relationship from the steps outlined above. If the customer has different address IDs used on various invoices, you would have to link PM_Payment_Work_TRX table to the PM Transaction OPEN File (PM20000) first. This file will have the address ID in the VADCDTRO column. Then you must link this address field to the PM Address MSTR (PM00300) tables to the specific address (ADRSCODE field). If you wanted Microsoft to customize this report for you, it would be considered a consulting expense. Please contact your Collins Computing managing consultant.