Microsoft Great Plains Dynamics GP Integration with MS RMS – highlights for consultant

This was long lasting issue and demand from the ERP market – to integrate back end accounting with retail management application.

At this moment MS RMS version is not a concern, it should be easily adaptable for new RMS releases.  Integration works as the set on MS SQL Server stored procedures, custom tables, triggers and views.  In RMS it pulls data from HQ database as well as updates data in HQ, by creating RMS worksheets, these worksheets are automatically marked as approved and then RMS process them internally.  Please be aware that integration is powerful and so, complex – it requires our professional consultants to be involved in its implementation

• Purchase Receipts.  You receive in GP, integration moves purchase receipts into RMS.  Please be sure that you have the same item numbers in Great Plains and in RMS.  Additional restriction – items should not be serial or lot number tracked in GP
• RMS and GP Inventory transfer synchronization.  Integration synchronizes transfers originated as in GP as well as in RMS in counterpart application.  Here, serial/lot number is complication from GP side, so again be sure that you don not use lots and serials in Great Plains.  In GP inventory transfers are created in history, so you do not need to post them
• Sales Order Processing/SOP.  Integration can work as with orders as well as with invoices.  Payments are deposits.  You will have to post SOP batches (or transfer orders to invoices).  Return logic is incorporated
• Customers synchronization.  Two ways – from GP to RMS and from RMS to GP
• Inventory Items.  Items are created in GP.  The purpose of this integration is to control RMS financial results as well as automate new items creation in GP plus print barcode labels at GP side
• GP-RMS stores mapping.  Integration allows you to control several stores from one GP company as well as allows you to have complex mapping: one gp company to one store, one GP company site to one store, etc.