Microsoft Great Plains/Dynamics GP 9.0 Implementation: Pharmaceutical Corporation Specifics – overview for consultant
Microsoft Business Solutions Great Plains serves mid-size and large clients in horizontal and vertical markets. Historically Great Plains Software was encouraging ISV partner to write third party modules and later on – Great Plains Software had a chance to select the product for incorporation into their core set of modules: Manufacturing, Project Accounting, Purchase Order Processing, Collection Management, etc. Today we’ll consider Microsoft Great Plains implementation specifics for large pharmaceutical corporation. • Product Research cost. New product research and testing could be grouped into cost center and Microsoft Great Plains offers several Project solutions. The most reliable way is to deploy Great Plains Project Accounting. This module could work in the multicurrency environment, when you incur R&D cost in multiple countries. Then in the first year of product release you can track P&L by your product. There are certain restrictions, however – you typically have one customer, who pays your Project bills. Obviously it is not the case for new product. However you can consider your organization as an association of internal customers • Multinational Payroll. In each country you have to implement Payroll solution. In the case of Microsoft Great Plains you can have separate company for each local subsidiary and implement US, Canadian, Brazilian, Middle Eastern Payroll modules as well as Payroll custom solutions for most of Latin American countries, South Africa and Australia • Intercompanies Transactions. In Great Plains these transactions are automated and the transaction results in parallel transaction, involving due to and due from accounts. You can also do it manually • GL consolidation. This was popular approach in Europe with sophisticated multicurrency and strict tax regulation issues back in earlier 1990th. Nowadays you can use reporting tools to achieve the same goal. FRx could do the job, consolidation Great Plains companies. • EDI. Typical case when Purchasing is automated via EDI. In Great Plains you have multiple options to implement it. The simplest would be SQL queries with strict EDI formatting • Internal Audit. Internal Audit requires you to have random samples. Good example is AP checks and payments. The solution lays in using external reporting tool, based on MS SQL Server stored procedures, such as Crystal Reports. The random selection itself is Transact SQL routine. We are raising this question, because we saw the company struggling to implement this reporting with no luck
About Alba Spectrum Technologies. Alba Spectrum Technologies is joint venture of several IT and business consulting companies, now operating as single business entity. We have local presence in the Houston, Chicago, New York, Los Angeles, San Diego, Dallas, Miami, Atlanta, Denver, Phoenix, New Orleans, Minneapolis, San Francisco, LATAM & Brazil, Germany, Russia, South East Asia and Oceania. We believe in the coexistence of Java (J2EE, EJB, Linux, Unix), Oracle and Microsoft (.Net, C#, VB) platforms and systems and specialize in several product lines and cross platform integration, customization, heterogeneous report design, plus we provide ERP/CRM systems comparison and reviews, not being committed to just on MRP platform. We also stake on XML cross-platform data interchange to be advanced in the coming decade. Alba Spectrum Technologies websites: http://www.albaspectrum.com http://www.greatplains.com.mx http://www.enterlogix.com.br http://www.ronix-systems.de
2012
