/
Template for the Mass Account Merge import

Template for the Mass Account Merge import



Description of Issue

User is looking to import multiple account merges and needs the template



Context
  • Account Merge

  • Account Master



Cause




Resolution

The Account Merge program will accept two different Excel import templates. Users should utilize the template that corresponds with their account entry method. The completed import file may then be imported at:

Enterprise ERP > Financials > General Ledger Menu > Set Up/Chart of Accounts > Account Merge

Users may then import the file in Account Merge by clicking Mass Account Merge Import button in the top ribbon of the program, then either selecting or dragging the import file into the drop window

If the user's account entry method is Org Object Project, the required columns in the import file are:

  • Original Org

  • Original Object

  • Original Project

  • Target Org

  • Target Object

  • Target Project

If the user's account entry method is Long Account, the required columns in the import file are:

  • Original Account

  • Target Account

For any issues with the import or any errors that are received, please contact Enterprise ERP General Ledger Support for assistance.



Additional Information

If the user is using the Long Account template, the account needs to be entered exactly as how the account number is saved in Munis.

A reliable method of ensuring this is by searching for the account in Account Inquiry, copying the account number and pasting it into the import template. If there is a dash at the end of the account number, that needs to be included as well.











Related content

Account Import template - Version 2019.1 and higher
Account Import template - Version 2019.1 and higher
More like this
Account Import Template- Version 11.3
Account Import Template- Version 11.3
More like this
Import layout for Change General Ledger Account Codes
Import layout for Change General Ledger Account Codes
More like this
New option to Include User Defined Fields in import - Account Import
New option to Include User Defined Fields in import - Account Import
More like this
err_msg when importing in the Account Merge program
err_msg when importing in the Account Merge program
More like this
Account Merge - Please enter two MUNIS accounts that have the same balance sheet characteristics
Account Merge - Please enter two MUNIS accounts that have the same balance sheet characteristics
More like this