You’re offline. This is a read only version of the page.
Hi All,
In one of the company we have financial year from 2003 to 2017 and it was fine till last month. From year 2003 to 2016 all was historical year and 2017 was open, for whatever reason suddenly the 2003 is become a open year. So I have 2003 and 2017 as open year and all the years between these 2 is historical year. Now I tried to make the 2003 as historical year which is not possible now. I have ran all checklink on company and system, financial with no luck. I copied this database into a test database and thought of try to something using PSTL and after copying in test database the 2003 is become historical on it. So not sure what else to try any help will be good.
*This post is locked for comments
Hi Beat,
I logged out all users on all company and reverse 2016 and closed 2016 again and all worked well. Thanks for your kind help on this.
I would think so, as it checks simply the ACTIVITY table and won't let you re-open a previous year if any other user as 'sa' would be logged in.
And yes, every time you do some changes with the PSTL on the FY's or Accounts, it's advised to run a reconcile on all years (including historical) to rebuild the opening balance for each FY. Don't forget to run the GL00105 rebuild in the PSTL.
Hi Beat,
That worked perfectly alright and the 2003 is become history now. I forgot to mention to you that on my 2017 opening from 2016 is not brought forward, 2016 is already closed. I tried to reverse historical 2016 but its says another user logged in to the company. But I was only user logged into this company, if other users logged into other companies will that be a problem. I ran checklink and financial reconcile with no luck of opening balance.
Hi Beat,
Just now I saw your answer I will check it out on Monday and let you know. Thanks for your kind help and have a nice week end.
Hi Babu,
Companies hold a historical status in SY40101:
SELECT * FROM SY40101;
-- update the status
UPDATE sy40101
SET historyr = 1 --> 1=closed, 0=Open
WHERE YEAR1 = 2013 --> Change FY
AND HistoryR = 0;
Let us know.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (