Dynamics GP Retail Integration and Barcoding Notes

If your organization is committed to Microsoftopinion the best results could be achieved if you are
Dynamics GP ERP and MRP application, formerlyusing Microsoft RMS for POS, Store Operations, and
known as Great Plains Dynamics or eEnterprise, weits Headquarters module.  We have set of integration
are offering you GP integration and implementationscripts ready for tuning, including lot numbers logic,
highlights for small and mid-size retailers withPurchase Receipt integration, moving Sales to GP
warehouse and supply chain management,Sales Order Processing or Receivable Management
consignment and barcoding automation. (when you do not track QTY in GP and would only
We name our products Solutions, as we typically workneed GL distributions) modules.  However, if you have
with your IT people and in-house programmers to tuneanother Point Of Sale system, such as Counterpoint,
existing modules and program codes to fit your, oftenfor example, we should be able to help you out as
unique, business processes and requirements:well.  Counterpoint has GP integration extension, and
1.       Handcrafts, Souvenirs, Jewelry, Variableothers POS systems could be integrated via either GP
Weight Food and Items tracking in Great Plains.  HereIntegration Manager or SQL Scripts.  If you POS is
the dilemma is how and where to print barcodebased in Linux, Oracle, PHP/MySQL ecommerce, and
labels.  We recommend you to consider trackingif you are able to open ODBC connection from it to
these items either by serial (unique items) or lot numberDynamics GP MS SQL Server databases, the rest is
(when each series received is unique) in Great Plains. doable
In the case of food (meat, poultry, cheese) with3.       Supply Chain Management.  Here you
variable weight you can deploy advanced distributionmay need Barcode Scanners batch or real time
with Catch Weight functionality.  Barcode labelsintegration to Dynamics GP Inventory (Cycle Stock
printing could be done in GP ReportWriter, or if youCount), Purchase Order Processing (Purchase
prefer advanced tools, consider Crystal Reports orReceipts scanning), Sales Order Processing (Picking
Microsoft SQL Server Reporting Services (SSRS). Tickets and Packing Slips)
We have simple VBA scripts, allowing you to call4.       Inventory Consignments.  In some
Crystal Report directly from GP, assuming that yousituations you do not want to show merchandise on
are deploying Great Plains Modifier with VBA scriptingyour Balance Sheet and would prefer consignment
2.       Retail application integration.  Here, in ourmodel.