web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Change/Replace of Main Account in COA

(2) ShareShare
ReportReport
Posted on by 313

Hi,

I have one legal entity with its own individual Chart of Accounts, containing five years of audited transactional history. Additionally, I have two other legal entities that use a shared Chart of Accounts.

At this stage I want to match Expense and Assets Accounts in individual COA.

So, I am planning to incorporate the expense accounts to the individual Chart of Accounts same as shared Chart of Accounts and map them to the appropriate expense procurement categories for P2P cycle.

My questions are:

  1. Is this approach recommended and supported in Microsoft Dynamics 365 Finance & Operations?
  2. What is the best practice for transferring the historical balances and detailed transaction history from the Old Accounts to the new Accounts. and suspend old accounts.

I would appreciate your guidance on the recommended approach and any potential risks or considerations.

 
 
Regards,
Raheel
 
Categories:
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    306,651 Super User 2026 Season 2 on at
    Hi Raheel,
     
    First of all, you should involve an external auditor/accountant in this process. There is an option to create new accounts and use a generic journal to move balances. You can also rename the main account numbers. This will then not require a journal to move the balances, but historical reporting will then not be possible. 
  • Paolo Cecchelli Profile Picture
    699 Super User 2026 Season 2 on at

    Hi,

    adding a few points to what Andre suggested:

    • be careful that as already mentioned the renaming of the accounts will rename all the transactions made before, so for audit purpose is not recommended;
    • to then suspend the main account from being used you can use the “Suspended” flag on the main account, available also as a legal entity specific account. I do not remember if this impacts the closing and opening, but if you zero it out before the closing you should not have problems: 

    • As a backup plan, you can build and run a consolidadated report in management reporter, so that you do not have to actually change anything in Dynamics.

    Best regards,

    Paolo

     

  • Suggested answer
    vishalsahijwani Profile Picture
    341 on at

    Hi , 

    Yes this approach is supported in D365 F&O. Since every legal entity has its own COA you are simply adding more matching codes without changing its existing structure so there is no risk at all.

    Best practices which should be followed for transferring the historical balances and detailed transaction history from the Old Accounts to the new Accounts are as mentioned below : - 

    1. We should keep at least 3-5 years of audit transaction details as it is depending on your audit requirements. Do not repost or try to delete as it may spoil your audit data completely and it would be difficult for you to explain this to audit team. 

    2.Transfer simply the balance amount not the exact transaction detail through a single journal entry from old account to new account on a cutover date as per your requirements. Also this should be done on a start of new fiscal period if possible thereby ensuring trial balances are kept in a good comparing condition.

    3.Create a small customization by getting a custom field called “Is Suspended” flag on the Main accounts. Don't delete the old accounts simply enable this flag and then for whichever accounts you want you can enable this flag (Checkbox or toggle) so that if required you can generate a custom report from the accounts where this flag is enabled. 

    4. As mentioned in the second point try not to do this activity in middle of the year/fiscal period or at end of it to avoid unnecessary reconciliation activities.

    Please try to follow these points and observe if it helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 263 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 257 Super User 2026 Season 2

#3
Subra Profile Picture

Subra 235 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans