Set up Roth 401(K)

  • Created:
  • / Author: tombucci
Solution:

This knowledgebase article explains how to set up the Roth 401K in Sage Pro ERP.

This feature has been documented under PTR 81063 and will be available in the January 1 2007 PUP Release and in Sage Pro 7.4 Service Pack 1.

Related  Reading
For more information on how to set up Roth 401(K), please refer to Knowledgebase article 22325.

If the January 1 2007 PUP or Save Pro 7.4 Service Pack 1 is unavailable, please refer below for the solution below. It shows how to create a datadriller and a customized report to determine the combined amounts for Roth 401, both pre-tax and post-tax.

Important
Please attempt this solution in a test environment first to obtain the desired results. Once this is complete, this can be implemented in a live system.

To create a customized datadrill, follow the steps below:

  1. Under the Maintain, point to Deductions and click Deductions.
  2. Set up two deductions: “Deduction_A” and “Deduction_B.”
  3. Under the File menu, click Maintain Dataviews.
  4. In the Dataview ID field, type “ROTH_401.”
  5. Click Add.
  6. Type a title and description for this dataview.
  7. Click … for Table.
  8. Double-click “PREHDE.”
  9. Click OK.
  10. Click … for  Column.
  11. Double-click “PREMPL,” “DEDID” and “YTDDEDU.”
  12. Click OK.
  13. Paste the following query into the  Filter text field:UPPER(DEYEAR) == “2003” AND UPPER(DEQTR) == “4” AND UPPER(DEDID) == “Deduction_A” OR UPPER(DEDID) == “Deduction_B”

    Important
    The “UPPER(DEYEAR)” is the current reporting year for the Roth 401K and the “UPPER(DEQTR)” is the last quarter that existed in that year. This ensures the latest YTD amounts are used. Please refer to Figure 1 in the attached document.

  14. Click Save.
  15. Click Exit.

The Roth 401(K) datadriller has now been created and saved. A custom report can now be created from this datadriller. Please refer to the attached document for additional information:

  1. Press F3 on the keyboard; the Select dataview picklist appears.
  2. Double-click the “ROTH_401” dataview.
  3. Click Print or Export the active Dataview.
  4. Click Custom Reports.
  5. Type a report name into the  Report ID field.
  6. Enter the appropriate information into the Report Filename, Report Path and Description/Title fields.
  7. Verify that  Default Report for this Dataview is selected. Please refer to Figure 2 in the attached document.
  8. Click Save.
  9. The Report Wizard appears.
  10. Click >> to move all the fields from Available fields to Selected fields.
  11. Click Next.
  12. Select “Prempl” from the 1. listbox.
  13. Click Summary Options.
  14. Select Sum for the Ytddedu field.
  15. Click OK.
  16. Click Next.
  17. In Step 3, select any style.
  18. Click Next.
  19. In Step 4, select any report layout.
  20. Click Next.
  21. In Step 5, select any field to sort the records by.
  22. Click Next.
  23. Click Preview to preview the report.
  24. Click Finish to exit the wizard.

Once completed, the report and the datadriller are ready for use. The total amounts for Roth 401K can be determined by creating this report without having to manually calculate them.

© Copyright Sage Software

Leave A Comment?