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.
www.xeniosllc.com 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
We enable an organization by supporting each stage of your company’s growth by implementing scalable Microsoft Dynamics solutions. As Microsoft Certified solutions experts and Inner Circle Partners, we work to eliminate redundant systems and leverage existing software investments, while keeping your goals for the future in mind.