Notifications
Announcements
No record found.
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
Just follow the steps provided under MS support article 851423
Never hesitate to share any further inquiries,
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
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,
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
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!!!
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.
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.
Diana, contact Mark Polino at Integrated Business Group in Orlando, FL. I know Mark has done this for clients in the past.
I've done it before using direct table import. Key is making sure the dates are correct. And also, make sure to do it in a test company first.
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
