GL Mass Maintenance

Mar 7, 2020 | GL, Oracle

Creating accounts for a new CC based on a current CC is shown below:


To do a move simply name the source accounts and map to target accounts.

A move operation transfers balances from one or more source accounts to one or more target accounts. In the Mass Maintenance Workbench window, you use one account specification each to define the source accounts and the target accounts.

For example, assume that you want to merge the balances from three costs centers (575, 683, and 937) into one (357). The source and target specifications in the Mass Maintenance Workbench window are:

Source specification: 01. 575 . . Target specification: 01. 357 . .

Source specification: 01. 683 . . Target specification: 01. 357 . .

Source specification: 01. 937 . . Target specification: 01. 357 . .

Business Rules

You cannot move/merge across ledgers.

If you submit a move/merge request for a ledger set, a parent request will be automatically submitted along with multiple child requests, one for each ledger in the ledger set.

You cannot move/merge across balancing segment values. For example, if your balancing segment is company, you cannot move balances from one company to another.

You cannot move/merge across financial statement categories. For example, you cannot move a balance sheet account balance to an income statement account. You can move/merge within categories, except for equity accounts. For example, you can move/merge an asset balance to a liability account.

You cannot move/merge budget or encumbrance balances.

You cannot move or merge the balances of purged accounting periods. However, since current balances are based on the purged periods, General Ledger will adjust the quarter-to-date, year-to-date, project-to-date, period-average-to-date, quarter-average-to-date, and year-average-to-date balances of your source and target accounts in the earliest unpurged period.

Move/merge operations will not update the accounts and account ranges used in any General Ledger definitions, such as recurring journals, mass allocations, consolidation mappings, and summary accounts.

If any source accounts have historical rates assigned, you must update or create the historical rates for the target accounts. The rates will not be updated or created during the move/merge.

If you have budgetary control enabled in your ledger, funds checking and reservation does not validate move/merge adjustments to your source and target accounts.

If you enabled the Track by Secondary Segment option for your ledger, running the Mass Maintenance Move/Merge option inappropriately may cause your retained earnings accounts balances to be incorrect. We recommend that you only move balances within the same balancing segment value and secondary tracking segment value during Move/Merge to maintain the accuracy of the retained earnings account.

Otherwise, you should use manual journal adjustments when crossing balancing segment and secondary tracking segment values in your reclassifications. The Move/Merge program bypasses the Posting program, updating General Ledger balances directly. The Posting program correctly updates the retained earnings accounts.

See: Secondary Tracking Segment

Special rules for net income accounts (average balance processing): Balances for the Net Income account will never be moved/merged. If a net income account is among the source/target accounts, the move/merge operation will be aborted during the Validation process.

Let's set up a call?

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Let's set up a call

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Let's get on a call!

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Subscribe To Keep Up To Date

Subscribe To Keep Up To Date

Join our mailing list to receive the latest news and updates.

You have Successfully Subscribed!

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close