I know there are more than one way to connect FMP to QB-POS. Any comments on which is better?
There have been plugins around for a while supporting Quickbooks app and that is the traditional way to do it. But it is fairly obvious that Intuit is putting its money into their cloud version of Quickbooks for the future. Being that that seems to be the direction for the future, there is an fmQBO solution for Geist Interactive that handles RESTful API connections to their cloud version of Quickbooks. So if you're starting something new, I would take a good look at that.
Thanks, I have great respect for any innovations going from Geist, but I think the future of this will be to dump QB (the customer is not happy with it, big surprise) and replace it with a FMP POS system. However, he is not ready to do that yet, so we are looking for the best plugin to work for a solution now.
Good Dog Database Design
Stripe integration is a popular option. We include a POS module using it as standard to all of our clients in our Kosmas solution. If you need a physical terminal instead, Cayan has developer friendly hardware and API too.
Well I'm not a fan of Quickbooks and from a database perspective, they are dismal, especially when they consider things like 10 users a lot and their database doesn't support common database standards, etc. They are not flexible in that very little can be changed or altered in their solution. It is a fine vertical solution with no flexibility targeted at small businesses. Beyond, that it is not a great system. Probably the biggest benefit I see is that for those who want to use it for payroll, it is updated with the tax code requirements each year for the governments. Most of my clients have an outside firm do the payroll and the business processes are all done on FileMaker and I like that. However, if you do have to integrate an external accounting system with FileMaker, something like SAGE that can run on MS SQL Server and FileMaker can ODBC into is a lot easier to integrate.
For Point of Sale, I did a search in the Made For FileMaker and this might be useful for you:
Search | Made for FileMaker
We've used the plug in from Productive Computing for years with no complaint. This is a long standing third party developer.
Before I go through the trouble to set up the environment, I am trying to determine if the Productive Computing plug-in talks to the "Point of Sale" version of QuickBooks. I have sent an email over to support, but does anyone know?
Retrieving data ...