Dynamics Gp Deleting Historical Year In Sql Scripts: Sy40101 And Sy40100

Home | Computers-and-Technology | Software

There might be situations, where you have to clone of the Great Plains companies and load its Chart of Accounts into new company, installed via GP Utilities. Table SY40101 is well known in such scenarios, where you need to remove historical years, plus if you would like to reopen one or more of the recent historical years, you could simply update Hystoryr field. With one of the customers, who is running Great Plains in membership outsourcing organization with more than twenty company databases, when copying we realized that there are some nuances

We were able to remove historical years in SY40101 table in the company database without the problem. Then we ran Utilities -> Financial -> Reconcile and to our surprise this process simply wiped out the whole GL10110 table (Account Current Summary Master), where by business logic it should of rebuild the current year records in GL10110. Check Links over Account Master didnt fix the issue

We also tried to enable in Dex.ini logging into DEXSQL.log file, where we were not able to find any clue about error message

After several hours of additional research and analyzing we finally looked at SY40100 table (Period Setup), where we found the traces of historical years. And after removing historical periods in SY40100 table and rerunning Utilities -> Financials -> Reconcile the table GL10110 was repopulated

Customer actually detected the problem in FRx reporting, as FRx uses summary tables in Account master to expedite report generation. Customer reported the problem that Balance Sheet and P&L reports revealed no data. The culprit was SY40100 table, where we didnt delete historical years

Microsoft Management Reporter and the described issue. We believe that it would be also vulnerable in MMR, as it uses the same idea to base reports on GL summary tables (including GL10110 Open or Current Year Account Summary Master file)

The issue might be popular but a bit unique and it is not described in MBS Partner or Customer Source as far as we know. As you might be aware SQL Server 2008 on 64 bit Windows Server platform introduced dramatic technology improvements and changes. For example, you as SQL DBA is encouraging to use SSIS versus old-good-days technologies such as Linked Server to Text File and Open Row Set to text file

Please call us 1-866-304-3265, 1-269-605-4904. help@efaru.com We have local presence in Chicagoland, Southern California, West Michigan, Houston and Dallas areas of Texas. We serve customers USA, Canada, Mexico nationwide and internationally via web sessions and phone conferences (Skype is welcomed). Our consultants speak English, Spanish, Portuguese, Russian, Chinese

About the Author:
Andrew Karasev is Great Plains Certified Master, MVP, help@efaru.com 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project http://www.efaru.com and founder of Alba Spectrum information space

Article Originally Published On: http://www.articlesnatch.com

Tags: Dynamics GP

, Great Plains Dexterity

, eConnect

Related....

Videos...

Recent Software Articles

Iskysoft Updates -1080p Output Video For New Ipad(ipad 3), Apple Tv 3 By: Lorin Young | May 31st 2012 - iSkysoft today released two new updates for its iMedia Converter for Mac and iMedia Converter Deluxe for Mac

DVD to iPad 3 Converter for Mac

Convert DVD to iPad 3 mac

How To View, Edit, And Fill Word, Excel Document In Asp.net Application Or Java Web Application By: Nancy Stewart | May 31st 2012 - As we know, it's impossible to view, edit Microsoft Office documents directly on Web pages for many years. But Aceoffix can do that for you. Without installing Office at the server side, web developers can easily embed and call Office in web pag ...

Create Your Video Sharing Service Like Youtube Using Joomla Youtheme By: Nancycatherine | May 31st 2012 - With the success of YouTube, similar online video sharing website has popped up like mushrooms, taking the media world by storm.

Boost Your Web Traffic & Revenue With Wordpress Review Plugin By: Henry William | May 31st 2012 - One of the best ways of making money online is by reviewing products and services. Most often, before a consumer decides to pay for a good or a service, they will always search for expert or consumer review in order to learn how the product work ...

Review Writer

Review Software

WordPress Commenting Tool

Ruby On Rails Platform Setup By: Annie | May 31st 2012 - To program most Ruby programs, Ruby on Rails programmer / developer needs virtually only two things: a basic text editor and a Ruby interpreter (usually MRI). Developing Rails applications might involve quite a few more tools. The following is a ...

Ruby on rails developers

Ruby on rails programmers

Best Practices For Custom Application Development By: christa joe | May 31st 2012 - Custom applications help businesses to deploy software technology in their operational processes, according to their needs and requirements. This helps to optimize and manage the functional and operational expertise.

Custom Application development

software development

Mobile Application Development India & Its Extensions. By: Victor Parker | May 31st 2012 - Mobilization flexibility has reached the seventh sky in terms of latest technology. The various mobile applications have been invented for better compatibility and easily used by the users. IT sector has emphasized on Mobile application developm ...

Mobile application development India

Open Source Technology Services India & Its Benefits To E-business. By: Victor Parker | May 31st 2012 - In simple words open source refers technologies which are independent to users. It has given the vast platform to the IT solutions. This product is highly recommended in the market and it is more powerful than other commercially products availab ...

Open source technology company India

Perfect Online Data Visualization With Html5 (javascript) Gauges? By: Tatyana Ufimskaya | May 31st 2012 - Online data visualization is very popular nowadays since it offers such advantages as getting data in real time and access from any location and device. More and more companies move their information monitoring and dashboard apps to web. And her ...

html5 gauges

javascript gauges

Take Care Of Your Lifeline"��! By: eScan Antivirus | May 31st 2012 - When we say the advancement of technology has influenced humanity in the various aspects of life that governs almost all acts of man out of some of the few important inventions, I find Credit Cards as the prominent.

Anti-Phishing Working Group

Anti-Virus

Cyber Crime

Cyber Terrorism

Comments

Still can't find what you are looking for? Search for it!

Site Navigation: