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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How can we change the ...
Microsoft Dynamics AX (Archived)

How can we change the effective date of a published retail channel in organisational hierarchy -AX 2012 R2

(0) ShareShare
ReportReport
Posted on by dhanyanair 58

Dear All,

How can we change the  effective date of  a published retail channel in organisational  hierarchy.When we try to change the  date getting below error 

"An organization hierarchy cannot be published on a date earlier than or on the last publication date. Select or enter an effective date later than the last publication date and try again".

Thanks & Regards 

Dhanya 

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,941 Super User 2025 Season 2 on at
    RE: How can we change the effective date of a published retail channel in organisational hierarchy -AX 2012 R2

    HI DCJenkins,

    There is no functional feature to change the date or revert the published hierarchy. When there are no new transactions or additions in the database, a restore with point in time could help. Otherwise you will need to change data in SQL directly which is far from recommended. If you are using Dynamics 365, then this is not possible as you don't have access to the database. You can also write an x++ script to change data. But test it carefully as it would be very easy to cripple the database on this data model.

  • Community Member Profile Picture
    Community Member on at
    RE: How can we change the effective date of a published retail channel in organisational hierarchy -AX 2012 R2

    Is there anyway to revert a published hierarchy back to an earlier date? short of deleting and re-creating.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,941 Super User 2025 Season 2 on at
    RE: How can we change the effective date of a published retail channel in organisational hierarchy -AX 2012 R2

    Hi Dhanya,

    When you publish a version of an hierarchy, the date should be a date after the last published date. What dates did you use? If you have one published today, you can eventually use a date of tomorrow to overcome this validation error.

    If you need to change the published date, it would be a cumbersome job by changing values in multiple tables. If you just can use another date, it would be the most easy solution.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans