I needed some opinions and help and experience on my case: I want to migrate some of my clients accounting systems to Quickbooks integrated with an ecommerce solution from an older system. This will be set up on an on premises server and not connected to the internet, and also I have the following problems:
-I need to know if their is any way of connecting to a QB file other that Folder Sharing. This is not a secure method and not preferable for my clients and myself. Is their any other solution?
- The QB database file is an unknown system to me and other developers and our older system was based on a SQL Server which had a lot of positive points, for example, SQL Server can determine the exact amount of ram, processor, and other server resources for the databases.On the other hand, the SQL Server security system is well known and manipulation of data is only available for certain defined administrators. Also, I know the limitations on increasing data amount and the speed of access in SQL Server and the Indexing feature in SQL Server allows me to determing the speed of my database depending on the type of data I work with.Unfortunately, the QB data file is unknown to me and my developers and I don't know how problems such as security, using server capabilities and speed and access to large amounts of data are solved. What are the solutions on this issue?
- How is the customers credit cards connected to their bank? For example, if I enter my customers account info, how does it connect to the bank? or if they pay with cash, how does the program deposit the money into their credit? also, how does the gift card work in QB?
-I will be using QB books for my clients which are approx. 10 companies with different purposes, for example, food, stationary, computer and network equipment.... This will be set up on a separate hosted server which is not going to be connected to the Internet. All the company files will be stored on the server and the companies will connect via an internal network. The smaller companies have an approximate of 600 transactions a month (including sales orders, purchases, statements...) and the bigger companies wil l have an approximate of 5200 transactions a month. Is this supported in QB Enterprise? I have heard there is a limitation to the amount of transactions. How is this solved?
-Last important issue: The ecommerce solution. I need some one who has experience on this integration to answer some of my questions. Till now I found ASPDotNetStorefront, Magento, and Interspire which integrate with Quickbooks AND work on a separate hosted server as I need. I need to know information about the connectors to QB and the information that is passed on between the two apps.
Any help or advice will be appreciated.