Purging Move/Merge Tables
A move/merge operation populates two interim tables, GL_MOVEMERGE_BAL_<move/merge request id> and GL_MOVEMERGE_DAILY_BAL_<move/merge request id>, with the balances being moved or merged. The information in these tables is retained after a successful move/merge because it is needed to reverse the move/merge.
When you are satisfied that the results of a move/merge are correct and that you want to retain the new balances, you should purge the tables. Do not purge the tables if you think you may want to reverse the move/merge later.
Additional Information: If you reverse a move/merge operation, the interim tables will be purged automatically.
To purge the interim move/merge tables:
1. Navigate to the Mass Maintenance Workbench window.
2. Query the move/merge request whose interim tables you want to purge.
3. Choose the Purge button.
See Also
Moving or Merging Account Balances
Defining a Move/Merge Request
Mass Maintenance Statuses