What This Process Does
Through Journal Entries
- Withdraws the amount out of the incorrect account code and moves it to reflect the correct account code.
- The original activity associated with the incorrect transaction will still exist, however activity is now created which shows a negative coming out of the wrong account code and a positive going into the correct account code.
Through the Account Masters
- Two journal entries are created automatically to account for the “Move” done in the Account Masters.
- Eliminates the need to create two separate journal entries manually.
Best Practices
- Account codes - for Expenditures, Revenue and Balance Sheet are affected through a variety of processes throughout the software in nearly all modules: Financial Management, Vendor Payments, Purchase Orders, Payroll, etc. These are known as the source modules for the activity. On occasion, the wrong account code is affected. Based on the situation, and when the error was discovered, the correction may be made in the source module by utilizing an undo process. Otherwise, the amount can be moved from the incorrect account code to the correct account code in Financial Management using the options outlined in this document.
- Undo Processes – It is not recommended by RDA to run the undo processes in order to change the account code on a journal entry.
Moving Amounts Between Account Codes
- At times, a transaction will be created where the wrong account code is used. When this happens, an amount can be moved from the wrong account code to the correct account code in two different ways:
- Moving an amount through journal entries
- Moving an amount through the Move feature in the Account Masters
..through Journal Entries
- Create two journal entries
- First Journal Entry:
- Populate fields with the exact same information as the incorrect transaction (including the wrong account code and amount).
- In the amount field, move your cursor to the right of the amount and type in a dash to indicate this amount is negative.
- Once all information is entered, click Save.
- Do not cancel out of the journal entry process.
- Second Journal Entry:
- Keep all fields exactly the same, except the account code and the amount.
- Change to the correct account code where the amount should be.
- Move the cursor to the right of the amount (should be negative) and delete the dash to indicate the amount is positive.
- Once all information is entered, click Save.
- Cancel out of the process.
- Review the Audit Trail
- The net affect of these entries should be zero. If the report is correct, set the flags.
- Run the Journal Entry Distribution
- If the report is correct, set the flags.
- Post the Activity
- If the report is correct, set the flags.
..through the Account Masters (Bundle FM 22 Required)
(refer to the above screen shot for an Expenditure Account Code)
- Access the Account Masters of the incorrect account code
- Modules → Finance → Financial Management → Query → View an Account Master → Expenditure/Revenue/GL
- Type in the account code and press Tab, or select the Browse button then locate the account code.
- Click the Years/Amounts button and choose your fiscal year.
- Depending on which journal entry type you wish to move:
- Click on the Move button located to the right of the screen near the Undistributed column.
- A screen will follow that requires fields to be populated according to which account code the amount will be moved to; be sure to select the correct processing period and Journal ID (review the Instructions tab for additional information).
- Once all fields are appropriately populated, click the Save button; followed by the Cancel button.
- Run the Audit Trail
- The report will show two transactions: A negative amount being moved out of one account code and a positive amount being moved into another account code.
- These two transactions represent journal entries that are automatically created once the Move process is done. It is identical to moving the amount by creating two journal entries as described in the previous section.
- The net affect of these entries should be zero. If the report is correct, set your flags.
- Run the Journal Entry Distribution
- If the report is correct, set the flags.
- Post the Activity
- If the report is correct, set the flags.