Faqs

Welcome to the FAQ

Don’t forget to also check our forums if you don’t find an answer to your question here. This page is relatively new so expect it to grow rapidly. All our products support QuickBooks Pro, Premiere, and Enterprise 2004 – 2018.

AccessBooks RealTime

Where can I find the relationships between the database tables?

We’re looking to develop a simple document to illustrate these relationships – although many are very simple and repeated throughout – however since the database is modeled so closely to the QuickBooks XML specification you can use the Intuit documentation for further insight.

Intuit On Screen Schema Reference

Do you support QuickBooks for Mac?

No. Unfortunately, QuickBooks for Mac doesn’t have an API by which third-party solutions can integrate. We wish it did though.

Can I export credit card information from QuickBooks?

Ancillary information, yes. The full credit card numbers no. Companies like Visa and Mastercard prohibit the ability to export such sensitive data.

Can I find out who created a certain transaction in the OpenSync database?

Yes, you can access this data by dumping the Audit Trail report out to database table.

Do you support Microsoft Access .ACCDB database file formats?

We only support .MDB files as they are a common denominator across all versions of Access. You can easily link an accdb format file to an MDB file from within Access. Segmenting your data and logic from the replicated QB data is our recommended practice anyway as it makes it much easier to upgrade the QB schema down the road to support newer versions of QB.

Why aren’t the data types set for the database fields OpenSync creates?

This feature will be introduced in version 3.0. The reason is due to the manner in which version 2.0 was engineered and the degree by which it would be difficult to retrofit into the current architecture. That said, as long as you adhere to the intended data types, you can set them yourself without it impacting OpenSync operation.

Can I synchronize two QuickBooks company files to a single database?

No. OpenSync does not support dumping multiple company files to a single database, you must have a separate database for each company file. The reason for this is that the internal ids used by QuickBooks (ListIDs and TxnIDs) are not guaranteed to be unique across company files.

Can I sync the Price Rules listed in the Advanced Pricing Module in QuickBooks?

Unfortunately, no. QuickBooks has yet to expose this data through the API.

“lsLicense30.dll failed to register” during installation

We’ve seen this error a few times and are working with the developers of our third-party license control to mitigate it but in the mean time the best solution we’ve seen is temporarily lower or disable User Access Control in Windows during the installation. Once the application is installed and all components registered, it’s perfectly fine to reset UAC to its previous level.

How to adjust user access control in Windows Vista / Windows 7

Do you support QuickBooks Point of Sale?

No. Not that we don’t want to but simply because up until now the demand hasn’t warranted the development cost. That said, if you’re interested in investing in the development, we’d be happy to speak with you.