Setting The RM Detail Aged Trial Balance - Options Report to Show Only Amounts Remaining in Aging Buckets With Credits Shown as Negative


TechKnowledge Content


Issue

How to set the RM Detail Aged Trial Balance - Options report to show only amounts remaining in aging buckets with credits shown as negative?

Resolution

Note - If you do not wish to have the credit documents show as negative, see Knowledge Base Aticle 864285

Follow these steps to modify the RM Detailed Aged Trial Balance | Options using Report Writer.

1. Insert the RM Detailed Aged Trial Balance | Options into the modified report list.

2. Highlight the report and select Open.

3. In the Report Definition window choose the Tables button.

4. In the Report Table Relationships window, highlight the RM Document Temporary File and choose the New button.

5. Highlight the RM Open File and choose the OK button.

6. Select the Close button.

7. Choose Layout option from the Report Definition window.

8. Select Calculated Field from your table drop down list in the Toolbox. Choose New to create a new calculated field.

9. Name the new Calculated Field 'Net Amount 1' and choose Conditional as the Expression type. Result Type will be Currency.

10. Click on the Conditional expression field.

11. Using the Fields tab, select Calculated Fields from the Resources list and select Bucket 1 from the Field list, then choose Add.

12. Choose the <> from the operators list.

13. Choose the Constant tab. Choose Currency as the type and click Add.

14. Click on the True Case expression field.

15. Using the Fields tab, select the RM Open File in the Resources list. Highlight Current Trx Amount in the Field list and click on Add.

16. Click on the False Case expression field.

17. Using the Functions tab, select the System | Defined Option and choose STR_CUR from the Function list. Click on Add.

18. Choose the Constant tab and choose String as the type and click Add.

19. Use the OK button to exit the window.

20. Create another calculated field. Select Calculated Field from your table drop down list in the Toolbox. Choose New to create a new calculated field.

21. Name the new Calculated Field 'Negative/Positive Net Amount 1' and choose Conditional as the Expression type. Result Type will be Currency.

22. Click on the Conditional expression field.

23. Using the Fields tab, select Calculated Fields from the Resources list and select Bucket 1 from the Field list, then choose Add.

24. Choose the <> from the operators list.

25. Choose the Constant tab. Choose Currency as the type and click Add.

26. Choose the AND from the operators list.

27. Using the Fields tab, select RM Document Temporary File from the Resources list and select RM Document Type-All from the Field list, then choose Add.

28. Choose the >= from the operators list.

29. Choose the Constant tab. Choose Integer as the type. Select 7 as the integer and click Add.

30. Click on the True Case expression field.

31. Using the Fields tab, select the Calculated Fields in the Resources list. Highlight Net Amount 1 in the Field list and click on Add.

32. Choose the * from the operators list.

33. Choose the Constant tab. Choose Currency as the type. Select -1.00000 and click Add.

34. Click on the False Case expression field.

35. Using the Fields tab, select the Calculated Fields in the Resources list. Highlight Net Amount 1 in the Field list and click on Add.

36. Repeat Steps 8 through 35 to create a Net Amount and Negative/Positive Net Amount calculated field for each Aging Bucket on the report. Increment the Name of the Calculated field to match the aging bucket. ie. Net Amount 2. The Bucket number in step 11 should correspond to the Net Amount field number.

37. Remove the following fields from the H2 section of the report: Bucket 1, Bucket 2, Bucket 3, Bucket 4.

38. Remove the following fields from the Body of the report: Apply Bucket 1, Apply Bucket 2, Apply Bucket 3, Apply Bucket 4.

39. Drag the Negative/Positive Net Amount Calculated Fields on the layout placing them in the H2 section where Bucket 1, Bucket 2, Bucket 3, Bucket 4 were before.

40. Double Click on each of the new Calculated Fields and change the Display Option to Hide when Empty.

41. Choose the X from the top right corner of the Report Layout window.

42. Save your changes.

43. Click OK in the Report Definition window.

44. From the top menu bar, choose File | Great Plains Dynamics.

45. Give users access to the modified report in the Security Setup window (Setup | System | Security) within Dynamics.



This article was TechKnowledge Document ID: 29050

DISCLAIMER 

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.