Great,Plains,Consultant,Los,An computer Great Plains Consultant Los Angeles News: GP Integration wit
----------------------------------------------------------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 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
Out of the box Great Plains has integration with RMS on General Ledger level and it does the job if this is just what you need. But if you would like to control your sales and inventory in Great Plains, then you need more advanced integration. In this small publication we would like to give you technical and functional highlights:1. Microsoft SQL Server DB platform. Both applications deploy MS SQL Server: Dynamics GP and RMS (Headquarters and Store Operations). This opens such integration programming tool as SQL Stored Procedures.2. Great Plains Integration Manager option. If you have moderate level of retail transactions, then you can consider deploying GP Integration Manager with some VBA scripting, where you import daily sales and then in VBA mark these transactions as being exported. Another option is to send day from and day to as parameters. This IM approach is very reliable, however it requires operator intervention to launch integration. If you have IT programmers, who can automate IM call on macros level, or deploy the tool, sold separately by Microsoft Business Solutions through GP partner channel then you can achieve complete automation level even with Integration Manager3. Alba Spectrum GP RMS Integration. This product is very flexible and is written in SQL stored procedures. You can target either GP Sales Order Processing module (where Inventory control side is needed) or directly Receivable Management (where the only concern is proper GL distribution, driven by RMS Items classification). It also addresses Purchase Order Processing side. It is probably very difficult to define standard logic in Great Plains to RMS integration, this is why this specific integration can be considered as Solution, which should be further customized and tuned to your specific integration requirements
Great,Plains,Consultant,Los,An