56
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
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.
Is there anyway to revert a published hierarchy back to an earlier date? short of deleting and re-creating.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (