Great,Plains,Partner,News,New, computer Great Plains Partner News: New Company with old Customers
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
If your business came under the restructuring and you are opening new legal name and want to start over in the new company, however you would like to preserve your customers and vendors and most of your GL account, then you should read this small publication to get oriented. Lets begin with company creation routine:1. Creating New company. You perform this in Great Plains Utilities. Dynamics GP new company creation should take from five to fifteen minutes, depending on the performance of your server. If you would like to avoid problems, follow all the way through the creation and do not try to stop the process2. Load new company database with your old company backup. This should be done in Microsoft SQL Server Management Studio (MS SQL Server 2005) or in SQL Enterprise Manager (MS SQL Server 2000). You typically load backup from device, select file, and then in options check force restore over existing database. Dont forget to change file name and path, before you click restore button3. Clearing transactions and history. The goal is to just leave master records: GL accounts, customers, vendors, inventory items. In tools, maintenance select clear data and in each series select transactions, summaries and history files. When you are done with this delete SYS00500 table, which contains unposted batches. Now go to tools, and by series (purchasing, sales, inventory) run reconcile you will recalculate customer, vendors, items summaries and balances. Next step is check links, select financial, purchasing, sales and inventory series files4. Removing inactive accounts. If you have a list of the accounts to keep, you can create simple SQL delete statement, where you will join accounts to keep table and GL00100. Then remove orphan accounts, joined by account index in GL00105 table (accounts index master). If you have multicurrency accounts, remove them the same way in MC00200 table. Then, run check links on financial5. Company ID update script. We can not include this script in this small publication, you can find it on GP customer or partner source. And now you are ready to go live with new company6. FRx reports. Just create new company in FRx, you should be able to run old FRx Balance, P&L against new company (if you do not change accounts structure there)
Great,Plains,Partner,News,New,