Microsoft Dynamics Blog

Welcome to Armanino’s Microsoft Dynamics Blog, where you’ll find information on topics across Microsoft Dynamics 365 ERP and CRM, Dynamics GP, Power BI, PowerApps, Flow and more. Use these tips, tricks and insights to get the most out of your applications! Want these articles delivered straight to your inbox? Subscribe to our newsletter below.

Tuesday, June 14, 2011

Point of Sale Data to Dynamics GP

Posted by Armanino Dynamics Team

Integrating a point of sale system to Dynamics GP is a fairly common business solution.  The sticky point is determining which functions will be done in the POS system, and which functions will be done in Dynamics GP.  There is generally some compromise around the purchasing/receiving/inventory functions.  Also the cash control processes generally result in some compromise.

Here is a solution that clearly defines relevant functions for both the POS system and the ERP system. provides solid POS systems to the hospitality industry.  For an operator with many locations, providing good financial reporting and control with a POS system only, is a challenge.  So this is how using Dynamics GP as a back-office system and using the 2TouchPOS system provides a comprehensive solution for the hospitality industry.

The integration between the two systems is simple.  On a daily basis, each store’s results are forwarded to an ftp location.  Integration manager is used to process the stores’ results to create a transaction in Dynamics GP that will do the following:

  • Decrement inventory for items used
  • Decrement inventory for items consumed in a recipe (use sales kits for this)
  • Provide a cash control point to audit cash deposits
  • Create all related journal entries to record the activity
  • Provide simple audit reports to verify the results of the integration

The functions of the two systems are clearly delimited and take advantage of each systems’ strengths.

The 2TouchPOS system provides the ability to effectively operate, manage, and control a dynamic service environment.

Dynamics GP provides the following:

  • Corporate-wide financial reporting and control
  • Purchasing and payables control
  • Inventory valuation and quantity management
  • Cash control and management

Dynamics provides several methods for connecting to external systems.  This is just one example.

Here’s a quick video that shows this in action: Integrating POS Data into Dynamics GP


comments powered by Disqus
« | »