On a recent project our client a microbrewery wanted to bring data into Microsoft Dynamics GP from two different 3rd party products that they were using in their day to day business. The customer was using eOstar Route Accounting Software to manage their deliveries and Aloha POS for their Tasting Room Sales.
From eOstar the client was looking to bring in Journal Entries for their General Ledger as well as Bank Deposits to interact with the GP Bank Reconciliation module. We were pleased to find that eOstar had developed their own integrations to Dynamics GP. The client worked with their eOstar representative to coordinate the upgrade of the product to bring the eOstar GL and Banking Transactions into GP through the eOstar integration modules.
The customer also wanted to bring in the daily Sales of the tasting room from the Aloha POS system. This would allow Tender sales receipts to be recorded in GP and keep an accurate inventory of the tasting room items in Dynamics GP. We created a custom .net application using vb.net and eConnect to bring the SOP data into GP. The integration retrieved the Cash, Credit Card, Gift Card, Comp Tender Data items and line item Sales data from Aloha EOD files and created a SOP Invoice for each day. One of the challenges we had was how to handle the beer inventory in the tasting room as beer was sold by various pour sizes, by flights, kegs, and cases. We setup a unit of measure in GP for Ounces to keep track of the beer poured in the tasting room. We were able to use categories and descriptions in the Aloha item data to map the item to the Ounce Unit of Measure and provide correct ounce value. Another challenge was how to handle a flight of beer which is several small samples of different beers sold as one unit. We defined flights in GP using kits where we were able to specify the ounces and beer that made up each flight.
In case you were wondering there are 1984 ounces of beer in a keg.
Check out our White Paper on Dynamics ERP for Craft Beer Production.
This article was written by Patti Vuz, Dynamics GP Technical Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics GP provider in Southern California.