Posting to history year (2 years back)

Question Status

qeefahs asked a question on 3 Apr 2010 11:44 PM


We have a situation where the years 2006 and 2007 are closed and the client required to post into 2006.

is there a way to achieve this?



Hossam Fathy responded on 4 Apr 2010 12:18 AM
Microsoft has script to open the year, so open year 2007 and post what you want to 2006.
qeefahs responded on 4 Apr 2010 12:23 AM

 Thank you for the reply, i was able to open the years except that i am facing various issues after re-closing the years and reconciling.

The problem is that the figures of "BBF" (balanc brought forward) transaction are no longer considered part of the opening balances for the next year but rather are considered as part of the period balances for the closed years.

i.e. suppose 2007 is closed already and the opening balance for retained earning is 1000000, after opening 2007 and reclosing and reconciling 2007/2008 the amount 1000000 is no longer part opening balances of 2008 but rather is part retained earning period balances of 2007.

 Hope the clarification is clear.



Hossam Fathy responded on 4 Apr 2010 9:26 AM

 how you open year 2007?


Richard L. Whaley responded on 4 Apr 2010 9:30 AM

Sorry you went the long way around.

When you post to the most recent historical year, the balances roll forward.  When you post to previous years, that year is updated but nothing rolls forward. 

 Post to the oldest year that needs adjustment and, if it is not the most recent historical year, make the same adjustments to the next year, and the next year, etc until the most recent historical year has been updated.  Remember that one will automatically roll forward.

qeefahs responded on 4 Apr 2010 9:34 AM
I used professional services tools library and used fiscal year modifier.
Hossam Fathy responded on 4 Apr 2010 10:37 AM

I am not sure of what u doing

I hope that you run this process on test database not on the real one.

please tell me exactly the steps you did.


qeefahs responded on 4 Apr 2010 11:07 AM

I am doing the following ( on test environment):

1. i am using professional services tools library. and using steps 2 and 3 of the fiscal year modifier. i.e. open closed period and then process.

2.i run year end closing procedure twice (for 2006 and 2007)

3. i am doing reconciling years 2006, 2007 up to 2010. (using tools -> financials -> reconcile).

4. i check retained earning account summary ie. (inquiry-> financials ->summary ).




Hossam Fathy responded on 4 Apr 2010 2:25 PM

I am not sure that professional service tools allow to open the year again.

Do you able to post transactions to year 2006?