Edit, Manage and Validate Existing Adjustments in the MDFM

Select a section of the article below to navigate directly to it. 

1. Edit and Manage Adjustments
2. Validate Adjustments
3. Troubleshooting

Edit and Manage Adjustments Walkthrough

Select Next to move through the guide. You can also zoom in and out of the image by selecting the Magnifying Glass in the bottom right-hand corner. You can view the full guide by selecting the External Link icon. 

Key Actions to Know

Navigate Adjustments

Within the appropriate data model, select Adjust.

• If needed, export the posted Adjustments to Excel for external review.
• Add or remove columns by selecting the Column Chooser.
• Filter within the adjustments by selecting the type, statement structure, reporting fund and/or period.
• You can also search for specific criteria within the appropriate column.

Edit or Duplicate Existing Adjustments

• Right click on adjustments within the Posted Adjustment table to either edit the existing transaction or make duplicates of posted adjustments to create a similar but new adjustment. 
  • Duplicate row as Pending GL - creates duplicate of the selected adjustment. 
  • Duplicate group rows as Pending GL will duplicate all rows associated with the same number in the adjustment number column.
  • Duplicate All Adjustments as Pending GL - creates duplicates of all filtered adjustments. 

Edit and Manage Pending Adjustments

• Once added to the Pending Transactions table, you can perform bulk actions by selecting all or specific transactions to edit, delete or post.
• Edit specific transactions by selecting the edit pencil. Select the Save (floppy disk) icon to save, the Arrow icon to cancel any edits and the Delete (trash can) icon to delete a transaction from Pending Adjustments.
• Click Post Transactions to post all Pending Adjustments.
  • Note: Before posting the adjustment, the total of the ending balance needs to be 0. 

Validate Adjustments Walkthrough

Select Next to move through the guide. You can also zoom in and out of the image by selecting the Magnifying Glass in the bottom right-hand corner. You can view the full guide by selecting the External Link icon. 

Step-by-Step Instructions

• After creating adjustments (or as needed), navigate to the Mapping page within the corresponding data model where you made the adjustments.
• Click the filter for the 'Adjustment' column.
• Select “True” and click “Ok.”
• The Mapped Accounts should now show adjustments within the data model. Continue to filter as needed.

Troubleshooting

Issue: I edited an existing journal entry, but cannot post it now.

Solution: The user who initially created the journal entry is the only one who can post. Add columns for users to see who needs to post them. 

Issue: I filtered for Adjustment is true, but still cannot see adjustments.

Solution: If you cannot see the adjustments, make sure the filters are cleared and re-select the Adjustment is “True” filter.