How To See Only the Payables Distribution Account on the Payables Check with Stub on Top & Bottom

Issue

How to see only the Payables Distribution Account on the Payables Check with Stub on Top & Bottom?

Resolution

Follow these steps to print the PM Distribution Account on the PM Check with Stub on Top & Bottom:

1. Go Into Report Writer and select the Tables button from the Tool Bar.

2. Select the table PM_Payment_Stub_Duplicate and then select Open.

3. Select the Relationships button and then select New to create a New relationship.

4. Select the Lookup (3 ellipses) and select PM Distribution Work Open as the Secondary Table.

5. Select Key 1 and choose Apply to Voucher Number as Key 1. (This is the only field used in the link).

6. Select OK to save the link. Close the remaining windows, saving your changes as you exit.

7. Select the Reports button in Report Writer and Insert the Check with Stub on Top & Bottom.

8. Open the report and select Tables from the Report Definition window.

9. Highlight the PM Payment Stub Duplicate table and select New. Select PM Distribution Work Open to link the tables. Click OK to save the link.

10. Highlight the PM Distribution Work Open table and select New. Select Account Master to link the tables.

11. Close the Table Relationships window and select Restrictions from the Report Definition window.

12. Add a New Restriction. The expression is Voucher Number = Voucher Number.

Note - Voucher # is from the PM Distribution Work Open Table.

Select OK to save the restriction.

13. Add a second Restriction. The expression is Account Category Number <> 1.

Note - Account Category Number is from the Account Master Table. One represents the Cash Account. So, if you are using any other Check besides Check with Stub on Top and Bottom, and you have anything but Cash and Payables, you will want to modify this restriction. Instead, make the restriction Account Category=13. The Payables Account is 13.

Select OK to save the restriction.

14. Select Layout from the Report Definition window.

15. Add the field Account Number from the Account Master table to the Body (B) of the Check Layout.

Note - You will have to rearrange or remove some existing fields in the Body (B) to make room for the new field.

16. Close the Layout and Select OK to close the Report Definition window.

17. We then need to grant access to this report by going back into Dynamics and opening the User Security Setup window by navigating to the Microsoft Dynamics GP menu, then point to Tools, point to Setup, point to System, and then click User Security.

18. Enter the User Id you are looking to grant access to the modified form/report to.

19. Enter the company this security needs to be granted in.

20. Take down the "Alternate/Modified Forms and Reports ID" that appears at the bottom of the window.

21. Open the Alternate/Modified Forms and Reports window by navigating to the Microsoft Dynamics GP menu, then point to Tools, point to Setup, point to System, and then click Alternate/Modified Forms and Reports.

22. Enter in the Id obtained in step 4

23. Select Microsoft Dynamics GP as the product

24. Select Windows or Reports as the Type.

25. Find the Purchasing folder and expand it. Find the Check with Stub on Top and Bottom report you are looking to grant access to in the list that populates. Expand the report and make sure it is set to the one labeled "Microsoft Dynamics GP (modified)"

26. Test the formatted Check report with a Test Company or The World Online, Inc. Company. 

27. Print Checks.

Notes

1. This will only print the Payables side of the Distribution. This Techknowledge assumes that
Cash is the Credit side of the Distribution and will only print the Debit or Payables side on the Check Stub.

2. This will only work with Payables Computer Checks. It will not work for Checks that are done on the fly.

3. This will only work if the Check is paying 12 or less Vouchers. If more than 12 Vouchers are paid, a Remittance Form prints, which is a separate report in Report Writer. If a Check is printed with more than 12 Vouchers, it may throw off the Check alignment.

This article was TechKnowledge Document ID: 3306