How to add the Vendor Name to the MDA Detail Analysis Report

SUMMARY

This article describes how to add the Vendor Name to the Multidimensional Analysis (MDA) Detail Analysis report.

MORE INFORMATION

Note If you are using multiple account groups assigned to a specific account, these modifications will create duplicates and the report will not work properly.

1. Launch Report Writer. Click Tools, click Customize, and then click Report Writer.

2. Click the Reports icon at the top menu.

3. On the Original Reports side, highlight the Account Analysis Report Detail and click Insert.

4. On the Modified Reports side, highlight the Account Analysis Report Detail and click Open.

5. Click the Tables button in the Report Definition window.

6. In the Report Table Relationships window, highlight the Account Master and click New.

7. Highlight the Year-to-Date Transaction Open and click OK.

8. In the Report Table Relationships window, highlight the Transaction Analysis Codes and click New.

9. Highlight the Transaction Analysis Groups and click OK.

10. Close the Report Table Relationships window.

11. Click the Restrictions button and click New.

12. Name the Restriction Identity.

13. From the Report Table drop-down, choose Year-to-Date Transaction Open.

14. From the Table Fields choose Originating Master Name.

15. Click Add Field, click the '=' in the Operators section, and click Add Field again (the Restriction Expression at the bottom should look like 'GL_YTD_TRX_OPEN.Originating Master Name = GL_YTD_TRX_OPEN.Originating Master Name').

16. Click OK and click New to create another restriction.

17. Name the Restriction JournEntry.

18. From the Report Table drop-down, choose the Transaction Analysis Groups.

19. From the Table Fields, select Journal Entry and click Add Field and click the '=' from the Operators section.

20. From the Report Table drop-down, choose the Year-to-Date Transaction Open.

21. From the Table Fields, select Journal Entry and click Add Field (the Restriction Expression at the bottom should look like 'DTA_Transaction_Groups_WORK.Journal Entry = GL_YTD_TRX_OPEN.Journal Entry').

22. Click OK and close the Report Restrictions window.

23. Click Layout in the Report Definition window.

24. In the Toolbox on the left, select the Year-to-Date Transaction Open table from the drop-down list.

25. Now you can add any fields on the report you would like from this table (Vendor Name = Originating Master Name).

26. Once added to the layout, double-click this field and make sure it is set to 'Data'.

27. Close out of Report Writer and go back to Great Plains, making sure to save your changes.

28. Make sure to grant access to the modified report by going to Setup | System | Security, choose the User ID and company, product of Great Plains, type of Modified Reports and series of Financial.

29. The modified report can now be printed. Click Reports, click Financial, click Multidimen Analysis, and then select the Account Analysis Report.

Note Since the Originating Master Name is pulled from the GL20000 (in the above example) the PM transactions must be posted in the GL. If they have only been posted to the GL, the Originating Master Name will not yet show.

Note This will only work for open year data. If you would like to see history information, the YTD Trx Open needs to be removed and the GL30000 needs to be linked in the same manner to the Account master. Both restrictions would also need to be updated by replacing the YTD Trx Open with information from the GL30000. Lastly, the Originating master name would need to be added from the GL30000.

This article was TechKnowledge Document ID: 31824