How feasible is it to post JE entries to closed years in GP 2013 SP2. Wanting to combine several companies and need to post JE entries back to 2006 to current.
*This post is locked for comments
Hi Leslie,
I came across this same issue for one of my clients. They accidentally voided a transaction in 2019, now they want to post it back but they get the following error:
the data cannot be before the first day of the most recent historical year
My question is how did you go to post it through SQL. DId you just do a normal GL entry or were there any other steps involved.
Hello
I thought I updated, I have this resolved, working with MBS services team. Took less than 1/2 hour to open the years, very clean and efficient. I had tried the SQL route myself, no way I could have hit all the necessary tables in that amount of time. Highly recommend the services team at MBS as an option for needs such as this.
Diana, contact Mark Polino at Integrated Business Group in Orlando, FL. I know Mark has done this for clients in the past.
You are correct there was (at Convergence) talk about being able to re-open multiple prior years; the Professional Services team wasn't aware of that and unfortunately we can't wait. Convergence said this April in R2 2013 (SP3)...we'll see.
Hello,
Thank you everyone for your input. As we are consolidating and have to crosswalk GL accounts from companies, unfortunately I can't use PSTL. I will be working with MBS to run scripts to reopen the years. Again, thank you for your help.
DIANA,
If you want to combine several companies in GP, better you can use PSTL(Professional Services Tools Library) to copy information from one company to another company within Microsoft Dynamics GP.
For your reference: Have a look on company copy under chapter 8 from below link.
www.cargas.com/.../ProfServicesToolsLibrary2.pdf
Hope this helps!!!
Hi,
Going down the road with Mahmoud - I have done this through the SQL side many times without a problem. Heather heard correctly that you are going to be able to re-open historical years for posting. You have to reopen them in order and then close them in order. For instance, I can't just open 2006 and post to it. I'd have to open all the way back to 2006.
As far as the SQL end of things, the entry going into 2006 would need to look just like the other ones. The closing entry would need to change. It's the closing entry that rolls forward the balances. I normally add/change lines in the existing closing entry so that everything is in the right place. The only trick to this is that you need to put the entry in period 0, and the transaction date is the last day of the previous year. Just make sure your line looks like theirs. For each year going forward you would need to add the period zero transaction to get the beginning balances correct.
NOT a recommended way of doing things, but sometimes you don't have a choice.
Kind regards,
Leslie
I must stand corrected, Ms. Heather has just touched upon the point that the article absolutely refers to posting JE to the most recent year only "You can post transactions to the most recent closed year"
There is another option though representing with a "risky" method represented with SQL insert statements that are identical to GL posting, the balances will not roll forward through the historical years so you need to get in some hard work.
Again, Thanks Heather for the sharp attention,
Hi
I think Mahmoud may have missed the fact that you want to post back to 2006 - the article he notes only allows for one prior historical year.
I certainly know you can't do prior than the last historical year with SP2, but I thought I saw somewhere recently that something might be coming on that (I could be wrong).
Another option to consider would be to set up a new company database based on the settings of the current one. You could then bring data in from as far back as you like and roll the years forward as you go. That is probably how I would approach it.
Cheers
Heather
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
