Popular in Course
verified elite notetaker
Popular in Business
This 1 page Document was uploaded by an elite notetaker on Sunday December 20, 2015. The Document belongs to a course at a university taught by a professor in Fall. Since its upload, it has received 6 views.
Reviews for Microsoft-Dynamics-GP-History-Year-Reopening-Recommendations-
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 12/20/15
Microsoft Dynamics GP History Year Reopening Recommendations In case your organization deploys Dynamics GP or its older versions, referred to as Great Flatlands Dynamics, eEnteprise on Microsoft SQL Server and you've got the necessity to reopen historic year, here are a few highlights for you personally. Historic year reopening might be needed if you want to do multicurrency revaluation, or when you really need to publish GL correction transaction towards the year, being not the newest closed one. There can be more reasons, you are able to title them, just as real existence could give unpredicted surprises. Historic year reopening ought to be done on MS SQL Server scripting level, for this reason it's preferred that you're on SQL Server DB platform (this is not on Pervasive SQL, Ctree, or Btrieve, however even when you are well on these archaic Great Flatlands versions, reopening can be done)1.Test the fit Test company, don't try your production company database. This is critical, don't take the chance of compromising your accounting as well as Corporate ERP system data2.Moving GL History table to GL Open table. For generic SQL programmer it should not be any challenge. Both tables GL30000 (GL History) and GL20000 (GL Open) are extremely similar within their structure as well as your programmer should have the ability to compose Place Into SQL statement3.Marking Historic Year as Open. This routine requires update in a number of GP company tables, we're not comfortable to produce the instructions in free publication, please call us4.Getting rid of BBF journals. If you're reopening historic year, you need to remove P&L effect of GL year closing. As excurse to accounting theory, when you're closing the entire year, all of your P&L accounts are made clear out and delivered to Maintained Generating Account and documented on the very first day of 2012. If you're reopening the historic year, you will have to close it sooner or later and also the closing will recreate BBF (Balance Forward) GL transactions5.Repairing GL Accounts. This is particularly important if you work with FRx reviews. To be sure FRx connector to Dynamics GP General Ledger sways on GL Accounts summary tables. And Repairing Utility does essentially recalculation of GL account summary for every account6.And today final steps - reopening historic year. Here you go a little hard to guess which table to choose. It's SY40101 Period Header. All that you should do here's to mark HISTORYR (History Year) area as. At this time, should you open window Financial Inquiry - former historic year ought to be obtainable in the drop lower list and the other way around it ought to no longer be accessible in Historic Financial inquiry7.Since you may see - Great Flatlands historic year reopening may look possible, nevertheless it requires expertise. We're offering this particular service and you may get more information by calling us: 1-866-528-0577, 1-630-961-5918, or send us an email firstname.lastname@example.orgAndrew Karasev, Alba Spectrum http://world wide web.albaspectrum.com 1-866-528-0577, email@example.com Educational portal http://world wide web.pegasplanet.com Andrew is Dynamics GP Licensed Master and is an expert in challenging custom remaking, data conversions, integrations, confirming Microsoft Office 2010 Product Key Free
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'