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

Notifications

Announcements

Community site session details

Community site session details

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

Removing an account structure from the Ledger

(0) ShareShare
ReportReport
Posted on by 235

Question removing an account structure from the Ledger:

Scenario - During data migration, the balance sheet account structure has a department dimension and so we have attached this balance sheet account structure to the Ledger to import all historical transactions with their department dimension details.  Going forward, this dimension is no longer a requirement (will not be allowed).

We setup an account structure BS_Import with a Active to date of 06/30/21 and attached to the Ledger.  Once importing is done, this needs to be removed and the new BS structure (all the same GL's) that does NOT have a department dimension and with a Active from date of 07/01/21 is to be attached.

I am getting the below error when trying to remove the BS_Import structure for their Gold environment where no users have transactions created:

pastedimage1624636602395v1.png

Any thoughts/assistance would be greatly appreciated!

Thanks,

DCTX

I have the same question (0)
  • Suggested answer
    Ramit Paul Profile Picture
    22,757 Most Valuable Professional on at

    Hello DCTX,

    Why cant you just adjust the same structure you have created, it should solve the issue.

    What is stopping you to do that?

  • Suggested answer
    Hossein.K Profile Picture
    6,648 on at

    Hi,

    It says you have journal with this account structure . you can create another

  • André Arnaud de Calavon Profile Picture
    296,568 Super User 2025 Season 2 on at

    Hi DCTX,

    If the dimension is not required anymore, why are you moving the balances including the dimension? Why not simply without the dimension?

    What is your intention with the journal? Remove the dimensions before posting?

  • DCTX Profile Picture
    235 on at

    @Andre: all historical dimensions be migrated even if they won't be used in future state.

    @Hossein: so if any journals get posted to a structure, it can never be removed from the Ledger (this was my main concern with this strategy)

    @Ramit: I haven't tested this yet, but if true, this would most likely be the best scenario!

  • Suggested answer
    Sheela Ningappa Profile Picture
    2,602 on at

    Hi,

    There must be some unposted documents and that is why you get the error

    Further, look into other ways to modify an existing account structure rather than wholesale swapping out / deleting / replacing them due to the amount of places that likely link to that structure.

    Thanks,

    SHeela

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

News and Announcements

[Smoke test 2510.1]

Quick Links

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans