Monday, October 15, 2012
Re-implementing Sage Accpac ERP Modules when Upgrading
I came across with a scenario where I had to carry out an upgrade for Financial Modules and re-implement Operational Modules. There I had implemented SM, GL, AR, AP, IC and OE modules. I had a requirement only to upgrade SM, GL, AP and AR modules from Accpac 5.2 to Accpac 6.0 and re implement IC, OE modules as new modules.
This task was difficult because even we do not activate those modules from Data Activation UI when doing the upgrade all the tables and data reside in IC and OE are also carried to the new version in the database. Hence we had to find a solution for this scenario.
The solution we found is shown below,
1. Upgrade all modules from 5.2 to 6.0 including SM, GL, AP, AR, AP, IC and OE using data activation UI and Database Dump
2. Create a new Accpac company in Accpac 6.0 with SM, GL, AP, AR, AP, IC and OE without any data.
3. Dump the newly created Accpac 6.0 company database
4. From that dump all tales related to IC and OE omitting SM, GL, AP and AR modules. These files are shown as REC files in DAT folder in Dump.
5. Replace copied REC filed from empty company with upgraded database's dump files in DAT folder (All tales related to IC and OE omitting SM, GL, AP)
6. DB LOAD the files replaced DUMP to Accpac
After DB loading that DUMP file we got IC and OE modules without any data. Hence we could re implement IC and OE while having all past data and setup in Financial Modules.
Subscribe to:
Post Comments (Atom)
Amazing writing! Again, you provide several realistic ways. I want to thank you for your outstanding performance. In most cases, a mobile app development framework can help you choose the best framework to create a new mobile application. Thanks for sharing, as otherwise i would not have thought about trying this solution.
ReplyDeleteI know this is an amazing post, it defines the true value of your knowledge. In fact, running a business is not common. People keep running to drive more business and generate more customers. At RisingMax which is best IT consulting companies in NYC, you can maintain a leading position with real estate software development in New York. keep it up. I really think this article is amazing, I can't describe it in words. Also, if you need an automotive software development service, do not delay in shaking hands with RisingMax.
ReplyDeleteOnce again you provide several doses of reality which explore the complete explanation of packing and moving companies in Bangalore . This article don't have to be that long. I simply couldn't leave your web site before suggesting that I actually loved the usual info on packing and movers services in Bangalore. I just want to know what is the best way to get real service
ReplyDelete