FM Books Connector Plug-in for FileMaker
With a FileMaker and QuickBooks integration, you can save time by eliminating double entry, improving data accuracy and giving your users access important QuickBooks related information in FileMaker.
FM Books Connector
Version 12.0.0.8
Platform
Windows
Pricing Options
This product requires an annual subscription. Please select your desired license option:
By making a connection between FileMaker and QuickBooks, you can use data in FileMaker to automate the creation of invoices in QuickBooks, adjust inventory, create a PO, update a customer, apply a payment or even pull a report. With this plug-in and our QuickBooks Desktop hosting plans the possibilities for integration between these two great programs are virtually endless.
If you are using the QuickBooks Online with Windows or Mac, have a look at the FM Books Connector Online plug-in.
Key Features
Download our Plug-in Demo
Try our fully functional demo file for up to 30 days. Please note the demo will expire 2 hours from opening your FileMaker application. To reset the demo, close and reopen your FileMaker application.
Need help getting started?
Visit our Help Center for a full list of FAQs and product documentation, submit a question on our PCI FM Forums page, or view videos on our YouTube channel.
Learn how to integrate FileMaker and QuickBooks Desktop using the FM Books Connector plug-in with Productive Computing University’s new course Connect FileMaker to QuickBooks Desktop. We have designed a six-hour training course to teach you how to install, configure and develop robust solutions. With this course, you will learn the skills necessary to build a direct connection between FileMaker to QuickBooks.
Benefits of a FileMaker and QuickBooks Integration
A FileMaker and QuickBooks integration can increase your team's productivity and efficiency in 4 easy ways:
- Eliminate duplicate data entry between systems
- Give your staff information on customers, items, inventory, invoices and payments - while protecting your QuickBooks file
- Implement a process that works with your existing workflow
- Give secure access to data anytime and on any device - iPad, iPhone, Windows, Mac and the web
System Requirements
Application:
FileMaker Pro 19.4 - 2024 for Windows
Claris Pro for Windows
QuickBooks® Desktop Applications:
- US versions of QuickBooks Pro, Premier/Accountant, Enterprise 2022 - 2024
- Canadian versions of QuickBooks Pro, Premier/Accountant, Enterprise
- UK versions of QuickBooks Pro, Premier/Accountant, Enterprise
Platform:
Windows® 10/11 Enterprise and Pro Editions (64-bit only)
The plug-in may work with earlier versions of FileMaker or operating systems, however, these are no longer supported.
As of FileMaker 19, all plug-ins need to be 64-bit. If using older plug-ins or older versions of FileMaker, the plug-in bit version that you use depends upon the FileMaker Pro bit version you have installed. FileMaker and the plug-in need to be running in the same bit version.
NOTE: QuickBooks Desktop was traditionally a 32-bit application. However, with the 64-bit version of FM Books Connector, we provide a supplementary component called the QB Bridge to ensure the plug-in will communicate properly with QuickBooks. The FM Books Connector 64-bit installer will automatically install the component during the installation process. As of QuickBooks Desktop 2022, Intuit will offer a 64-bit version that also works with the FM Books 64-bit installer and QB Bridge.
Version History
- Version: 12.0.0.8 | Release Date: 09/03/2024 | Platform: Win
- Resolved issue where PCQO_SGetXML would cause a crash when providing no parameter
- Updated the code signing certificate for the Windows installer to ensure plug-in security
- Updated to use the latest version of FileMaker 2024 plug-in SDK
- Updated demo file
- Updated handling for secure access to the Productive Computing plug-in registration server
- Version: 12.0.0.7 | Release Date: 06/04/2024 | Platform: Win
- This plug-in is verified as compatible with FileMaker Pro 2024
- Version: 12.0.0.7 | Release Date: 10/05/2023 | Platform: Win
- Confirmed compatibility with QuickBooks Desktop 2024
- Version: 12.0.0.7 | Release Date: 08/25/2023 | Platform: Win
- Updated to resolve issues with Intuit's "Revoked Certificate" error
- Updated embedded XSD files to provide compatibility with QBSDK 16.0 and older
- Re-applied the software code signing certificate for the plug-in, installer, and QB Bridge
- Updated demo files with the latest plug-in builds
- Version: 12.0.0.6 | Release Date: 04/25/2023 | Platform: Win
- This plug-in is verified as compatible with FileMaker Pro 2023
- Version: 12.0.0.6 | Release Date: 09/27/2022 | Platform: Win
- Confirmed compatibility with QuickBooks Desktop 2023
- This plug-in is verified compatible with Claris Pro
- Version: 12.0.0.6 | Release Date: 11/18/2021 | Platform: Win
- This plug-in is verified compatible with Windows 11
- Version: 12.0.0.6 | Release Date: 09/28/2021 | Platform: Win
- Confirmed compatibility with QuickBooks Desktop 2022 32-bit and 64-bit versions when using the QB Bridge with the FM Books Connector installer (included with the download.)
- Version: 12.0.0.6 | Release Date: 09/21/2021 | Platform: Win
- Updated the code signing certificate for the Windows installer to ensure plug-in security.
- Version: 12.0.0.5 | Release Date: 8/18/2021 | Platform: Win
- Updated Mac Template - Added support for Apple Silicon (M1 / ARM64) system architecture
- Version: 12.0.0.5 | Release Date: 1/27/2021 | Platform: Win
- Added new function: PCQB_SToggleApplyFilter - this function will toggle whether to apply the string escape character filter on subsequent calls to PCQB_RqAddFieldWithValue. This can be helpful in resolving issues with double-escaped characters.
- Confirmed compatibility with QuickBooks 2021 Canadian editions
- Updated Developer's Guide and Functions Guide
- Updated Mac Template - Download Version 12 Mac Template
- Version: 12.0.0.4 | Release Date: 9/21/2020 | Platform: Win
- Added compatibility for QuickBooks Desktop 2021 Pro, Premier, and Enterprise US editions
- Version: 12.0.0.4 | Release Date: 8/31/2020 | Platform: Win
- Updated PCQB_SFormatString to encode ampersand characters; these characters will not be automatically encoded when calling PCQB_RqAddFieldWithValue
- Version: 12.0.0.3 | Release Date: 7/27/2020 | Platform: Win
- Miscellaneous update to demo file
- Version: 12.0.0.3 | Release Date: 6/5/2020 | Platform: Win
- There is a new URL for the Intuit QuickBooks Desktop Onscreen Reference for Intuit Software Development Kits (also referred to as the OSR). The QuickBooks Desktop API (OSR), is referential documentation that developers can use to know what fields, objects, elements, and formats are acceptable to QuickBooks Desktop.
- Updated the QuickBooks OSR reference link in Demo file
- Updated the QuickBooks OSR reference link in the Developer's Guide
- Updated the QuickBooks OSR reference link in the Functions Guide
- Updated installer settings to resolve an issue where custom install paths were not fully supported
- Version: 12.0.0.3 | Release Date: 5/20/2020 | Platform: Win
- This plug-in is verified compatible with FileMaker Pro 19 (64-bit) and FileMaker Pro (Advanced) 17 - 18 (32-bit & 64-bit)
- Miscellaneous improvements
- Updated Mac Template
- Updated Demo file
- Download Version 12 Mac Template
- Version: 12.0.0.2 | Release Date: 1/15/2020 | Platform: Win
-
- Resolved an issue with PCQB_AddFieldWithValue where some unicode characters were not being escaped correctly
-
- Version: 12.0.0.1 | Release Date: 11/21/2019 | Platform: Win
- Resolved issue where PCQB_RqAddFieldWithValue would not properly escape special characters when using a "string"-type field value
- Version: 12.0.0.0 | Release Date: 09/16/2019 | Platform: Win
- Added compatibility for QuickBooks Desktop 2020 Pro, Premier, and Enterprise US editions
- Updated Demo file
- Updated Mac Template
- Version: 11.0.0.2 | Release Date: 05/22/2019 | Platform: Win
- This plug-in is verified compatible with FileMaker Pro (Advanced) 16 - 18 (32-bit & 64-bit)
- This plug-in and its installer is now code-signed, introducing an extra level of security that ensures the plug-in package is not compromised in any way
- Consolidated the different regional demo files into one. The demo file supports QuickBooks Desktop US, UK and CA (Canadian)
- Download Version 11
- Download Version 11 Mac Template
- Version: 11.0.0.1 | Release Date: 9/17/2018 | Platform: Win
- Confirmed compatible with QuickBooks Desktop 2019 US, UK, and Canadian Editions
- Removed obsolete function PCQB_ZResetQBOE from the functions list
- Resolved version mismatch in the Get(InstalledFMPlugins) function
- Updated Developer's Guide
- Updated Mac template
- Version: 11.0.0.0 | Release Date: 7/31/2018 | Platform: Win
- Added new batch handling for processing numerous requests and responses, including four new functions: PCQB_RqAddRequestToBatch, PCQB_RsOpenFirstBatchRecord, PCQB_RsOpenNextBatchRecord, and PCQB_SClearBatchQueue
- Updated Mac Template
- Updated Developer's Guide
- Updated Functions Guide
- Updated Demo file
- Version: 10.0.1.0 | Release Date: 6/14/2018 | Platform: Win
- Resolved an issue where using PCQB_RsUseXML to load an XML document while not in an active QuickBooks session would return a warning log if logging is enabled.
- Added extra handling to PCQB_RqAddFieldWithValue to properly handle a date or timestamp field value that has already been formatted to QuickBooks standards.
- Resolved an issue where the plug-in splash screen does not accurately report how long the demo registration has left.
- Confirmed compatibility with QuickBooks 2018 Canadian and UK editions
- Version: 10.0.0.1 | Release Date: 5/15/2018 | Platform: Win
- This plug-in is confirmed compatible with FileMaker Pro 15 - 17 (32-bit and 64-bit)
- Version: 10.0.0.1 | Release Date: 10/03/2017 | Platform: Win
- Resolved an issue with the QB Bridge where paginating over a large set of records or a long period of time would cause the session to reset itself and stop paginating prematurely
- Resolved an issue with the QB Bridge where paginating over a large set of records or a long period of time would cause the session to reset itself and stop paginating prematurely
- Version: 9.0.1.2 | Release Date: 10/03/2017 | Platform: Win
- Resolved an issue with the QB Bridge where paginating over a large set of records or a long period of time would cause the session to reset itself and stop paginating prematurely
- Resolved an issue with the QB Bridge where paginating over a large set of records or a long period of time would cause the session to reset itself and stop paginating prematurely
- Version: 10.0.0.0 | Release Date: 09/18/2017 | Platform: Win
- This plug-in is confirmed compatible with QuickBooks Desktop 2018 Pro, Premier, and Enterprise US editions
- This plug-in is confirmed compatible with QuickBooks Desktop 2018 Pro, Premier, and Enterprise US editions
- Version: 9.0.1.1 | Release Date: 09/18/2017 | Platform: Win
- Resolved an issue in the 64-bit version where the QB Bridge would lose its session after 2 minutes of inactivity or during a large volume of requests. This fix requires a reinstallation of the FM Books Connector; please use the setup.exe installer package to reinstall all components of the plug-in
- Resolved an issue in the 64-bit version where the QB Bridge would lose its session after 2 minutes of inactivity or during a large volume of requests. This fix requires a reinstallation of the FM Books Connector; please use the setup.exe installer package to reinstall all components of the plug-in
- Version: 9.0.1.0 | Release Date: 05/09/2017 | Platform: Win
- This plug-in is confirmed compatible with FileMaker® Pro 14 - 16 (32-bit and 64-bit)
- Added FileMaker 16 script step functionality
- Updated Developer's Guide
- This plug-in is confirmed compatible with FileMaker® Pro 14 - 16 (32-bit and 64-bit)
- Version: 9.0.0.0 | Release Date: 04/13/2017 | Platform: Win
- Updated Developer's Guide
- Updated the handling of a large QuickBooks result set in the 32-bit plug-in to prevent a crash condition when working through the response records
- Updated Developer's Guide
- Version: 9.0.0.3 | Release Date: 11/03/2016 | Platform: Win
- Resolved an issue in the FM QB Bridge that prevented connection to older versions of QuickBooks. This issue only affects the 64-bit version of the FM Books Connector plug-in
- Resolved an issue in the FM QB Bridge that prevented connection to older versions of QuickBooks. This issue only affects the 64-bit version of the FM Books Connector plug-in
- Version: 9.0.0.2 | Release Date: 11/01/2016 | Platform: Win
- Implemented fix in the 32-bit version of the plug-in to fully resolve the "Server threw an exception" error. This may require a reset of the QuickBooks Integrated Applications certificate
- As of 9.0.0.2 the 32-bit version will not require the FM QB Bridge. The 32-bit plug-in uses QBXML request processor (RP2) conduit
- 64-bit version is unchanged from version 9.0.0.1
- Implemented fix in the 32-bit version of the plug-in to fully resolve the "Server threw an exception" error. This may require a reset of the QuickBooks Integrated Applications certificate
- Version: 9.0.0.1 | Release Date: 10/28/2016 | Platform: Win
- Confirmed compatibility with QuickBooks Desktop 2017 Canadian and UK editions
- Added extensive logging functionality to the plug-in. This is an advanced feature. Please refer to the Functions Guide for details on the new logging functions and how to use them
- Enhanced internal error capture and exception handling to resolve issues with FileMaker freezing and crashing when communicating with the FM QB Bridge
- Partially resolved an issue with receiving a "server threw an exception" error from the QB Bridge when executing requests or connecting/disconnecting sessions. This issue is still under investigation. Please reference the Known Issues section in the developer's guide for more information
- Confirmed compatibility with QuickBooks Desktop 2017 Canadian and UK editions
- Version: 9.0.0.0 | Release Date: 09/22/2016 | Platform: Win
- Added compatibility for QuickBooks Desktop 2017 Pro, Premier, and Enterprise US editions
- Added compatibility for FileMaker 64-bit
- Created MSI installer package for Windows
- Updated Developer's Guide
- Updated Demo file
- This plug-in is verified compatible with FileMaker® Pro 13-15 for Windows (32-bit) and FileMaker Pro 14-15 (64-bit)
- Added compatibility for QuickBooks Desktop 2017 Pro, Premier, and Enterprise US editions
- Version: 8.0.0.1 | Release Date: 05/10/2016 | Platform: Win
- This plug-in is verified compatible with FileMaker® Pro 13-15 for Windows (32-bit)
- This plug-in is verified compatible with FileMaker® Pro 13-15 for Windows (32-bit)
- Version: 8.0.0.1 | Release Date: 01/26/2016 | Platform: Win
- This plug-in is guaranteed compatible with QuickBooks Desktop 2016 Pro, Premier and Enterprise CA and UK editions
- This plug-in is guaranteed compatible with QuickBooks Desktop 2016 Pro, Premier and Enterprise CA and UK editions
- Version: 8.0.0.1 | Release Date: 11/13/2015 | Platform: Win
- Resolved issue in which certain request types were not fully defined in newer versions of the QBXML SDK
- Resolved issue in which certain request types were not fully defined in newer versions of the QBXML SDK
- Version: 8.0.0.0 | Release Date: 09/24/2015 | Platform: Win
- Updated demo file
- Added support for QuickBooks 2016 Desktop Pro, Premier, and Enterprise US editions
- Updated demo file
- Version: 7.0.0.1 | Release Date: 09/24/2015 | Platform: Win
- Resolved issue with InventoryAdjustmentMod request not being considered a valid XML request
- This plug-in is confirmed compatible with Windows 7-10
- Resolved issue with InventoryAdjustmentMod request not being considered a valid XML request
- Version: 7.0.0.0 | Release Date: 05/28/2015 | Platform: Win
- FileMaker 14 32-bit compatible. Intuit's QuickBooks is a 32-bit application. FM Books Connector requires FileMaker 10-14 (32-bit) and QuickBooks (32-bit) but will function on a 64-bit Windows operating system
- FileMaker 14 32-bit compatible. Intuit's QuickBooks is a 32-bit application. FM Books Connector requires FileMaker 10-14 (32-bit) and QuickBooks (32-bit) but will function on a 64-bit Windows operating system
- Version: 7.0.0.0 | Release Date: 10/13/2014 | Platform: Win
- Added support for QuickBooks Desktop 2015 Pro, Premier, and Enterprise US editions
- Added support for QuickBooks Desktop 2015 UK and Canadian editions
- Added support for Reckon Accounts 2014 (Australia)
- Updated to resolve errors received when calling PCQB_ZParseXML
- Added support for QuickBooks Desktop 2015 Pro, Premier, and Enterprise US editions
- Version: 6.0.2.3 | Release Date: 06/27/2014 | Platform: Win
- Resolved underlying issue where Server Busy messages were being generated when executing a request that was exceedingly time-consuming
- Updated developer guide
- Resolved underlying issue where Server Busy messages were being generated when executing a request that was exceedingly time-consuming
- Version: 6.0.2.2 | Release Date: 03/27/2014 | Platform: Win
- Deprecated connectivity to QuickBooks Online via QBXML
- Updated demo files
- Updated developer and functions guides
- FM Books Connector is verified compatible with FileMaker Pro 10-13 and may work with earlier versions of FileMaker Pro
- FM Books Connector is verified compatible with Windows 7/8 and may work with Windows XP/Vista
- Deprecated connectivity to QuickBooks Online via QBXML
- Version: 6.0.2.1 | Release Date: 02/26/2014 | Platform: Win
- Resolved an issue with receiving a "Server Busy" error box when executing a request
- Resolved an issue with receiving a "Server Busy" error box when executing a request
- Version: 6.0.2.0 | Release Date: 01/20/2014 | Platform: Win
- Added support for FileMaker Pro 13. Please review page 31 of the Developer's Guide for specific information on this version for FileMaker 13 compatibility.
- Updated Developer's Guide
- Miscellaneous minor updates to demo files
- Added support for FileMaker Pro 13. Please review page 31 of the Developer's Guide for specific information on this version for FileMaker 13 compatibility.
- Version: 6.0.1.0 | Release Date: 12/06/2013 | Platform: Win
- Implemented the QuickBooks 2014 QBXML SDK
- Added support for QuickBooks 2014 UK and Canadian versions
- Updated demo files for support of UK and CA QuickBooks files/tax codes
- Updated Developer's Guide
- Implemented the QuickBooks 2014 QBXML SDK
- Version: 6.0.0.0 | Release Date: 10/11/2013 | Platform: Win
- Added support for QuickBooks 2014 Pro, Premier, and Enterprise US editions
- Added support for QuickBooks 2014 Pro, Premier, and Enterprise US editions
- Version: 5.0.2.1 | Release Date: 09/11/2013 | Platform: Win
- Internal code updated to use FileMaker 12 SDK
- Internal code updated to use FileMaker 12 SDK
- Version: 5.0.2.0 | Release Date: 08/29/2013 | Platform: Win
- Updated OSR link in demo files, Developer's Guide, and Functions Guide
- Updated OSR link in demo files, Developer's Guide, and Functions Guide
- Version: 5.0.2.0 | Release Date: 04/22/2013 | Platform: Win
- Added support for Microsoft® Windows 8
- Added error trapping for "RqExecute" script
- Updated "Refresh Item List" script in demo files
- Updated Developer's Guide
- Added support for Microsoft® Windows 8
- Version: 5.0.1.1 | Release Date: 01/08/2013 | Platform: Win
- Resolved pathing issue to XSD files for validation
- Updated plug-in scripts for error trapping
- Updated Developer's Guide
- Updated Functions Guide
- Resolved pathing issue to XSD files for validation
- Version: 5.0.1.0 | Release Date: 11/29/2012 | Platform: Win
- Set validation attribute to "true" by default - validates XML when executing requests.
- Updated Developer's Guide.
- Updated Functions Guide.
- FileMaker 12v3 added a third area for extensions. Updated the plug-in to accommodate all three locations. Paths are:
Win7 - C:UsersAppDataLocalFileMakerFileMaker Pro [Advanced]12.0Extensions
WinXP - C:Documents and SettingsLocal SettingsApplication DataFileMakerFileMaker Pro [Advanced]12.0Extensions
- Set validation attribute to "true" by default - validates XML when executing requests.
- Version: 5.0.0.0 | Release Date: 10/31/2012 | Platform: Win
- Registration System 2 Plug-in release
- Updated demo lockout from 30 minutes to 2 hours
- Updated Registration URL to "licensing2.productivecomputing.com"
- Added support for QuickBooks 2013 US, UK, Canadian, and Australian Editions.
- Added support for QuickBooks Online Edition.
- Set validation attribute "false" by default - does not validate XML against XSD files when executing requests.
- Updated script for invoice pushing.
- Registration System 2 Plug-in release
- Version: 4.0.0.3 | Release Date: 11/15/2011 | Platform: Win
- Added support for QuickBooks 2012 Canadian version.
- Added support for QuickBooks 2012 Canadian version.
- Version: 4.0.0.2 | Release Date: 10/27/2011 | Platform: Win
- Added support for SDK 11 and QuickBooks 2012 for US, UK and Australian editions
- Updated registration process and added new splash screen
- MetaDataOnly query using the PCQB_RqExecute command now properly returns 0 instead of End
- Added support for SDK 11 and QuickBooks 2012 for US, UK and Australian editions
- Version: 3.0.0.5 | Release Date: 05/13/2011 | Platform: Win
- Full support for QuickBooks Online Edition
- Added new PCQB_GetCurrentQBVersion function
- Confirmed support for high ASCII characters particularly smart quotes
- Fixed issue where RqExecute would return "End" when successfully processing a "TxnDisplayMod" request. The executed request now properly returns "0" for success instead of "END."
- All null values are now interpreted as !!ERROR!! including if QuickBooks returns two tags and nothing in between
- New demo files (one for use with QuickBooks Desktop edition and one for use with QuickBooks Online edition)
- Full support for QuickBooks Online Edition
- Version: 3.0.0.0 | Release Date: 11/01/2010 | Platform: Win
- Added support for SDK 10 and QuickBooks 2011
- Officially only support QuickBooks versions 2006 or later
- Added support for SDK 10 and QuickBooks 2011
- Version: 2.0.0.5 | Release Date: 11/01/2010 | Platform: Win
- Fixed issue where PCQB_EndSession function is not releasing the connection to QuickBooks
- Fixed issue where PCQB_EndSession function is not releasing the connection to QuickBooks
- Version: 2.0.0.4 | Release Date: 01/22/2010 | Platform: Win
- Added support for QuickBooks Simple Start Editions
- Added support for QuickBooks Simple Start Editions
- Version: 2.0.0.3 | Release Date: 01/22/2010 | Platform: Win
- The PCQB_ZValidateXML function is now fixed to return "!!ERROR!!" when the XML is malformed.
- Added third optional parameter of (optWellFormedOnly) to the PCQB_ZValidateXML function. The default value is False. Set it to true if you want to only test if the xml passed to the function is well formed, leave it empty or set to False if you want full validation against the QBXML templates.
- The PCQB_ZValidateXML function is now fixed to return "!!ERROR!!" when the XML is malformed.
- Version: 2.0.0.2 | Release Date: 10/30/2009 | Platform: Win
- PCQB_FormatString reverted to previous style. String formats in QB do not adhere to documented format in SDK8
- PCQB_FormatString reverted to previous style. String formats in QB do not adhere to documented format in SDK8
- Version: 2.0.0.1 | Release Date: 10/29/2009 | Platform: Win
- Added support for SDK 8 and QuickBooks 2010
- Added Key/Mouse hooks
- Change PCQB_ZParse function to omit n character.
- Must use QBXMLRP2 for future versions of QB
- Repaired PCQB_RsUseXML to properly load XML
- Major version set to v2
- Added new splash screen with new logo
- Added support for SDK 8 and QuickBooks 2010
- Version: 1.0.5.11c | Release Date: 10/29/2009 | Platform: Win
- Support for QuickBooks Online edition
- Support for QuickBooks Online edition
- Version: 1.0.5.11 | Release Date: 08/21/2009 | Platform: Win
- Corrected registration issue where the plug-in was expiring in 30 days for all users
- Corrected registration issue where the plug-in was expiring in 30 days for all users
- Version: 1.0.5.10 | Release Date: 07/16/2009 | Platform: Win
- Fixed crashing condition when adding an empty field to a request
- Fixed crashing condition when adding an empty field to a request
- Version: 1.0.5.9 | Release Date: 07/09/2009 | Platform: Win
- Fixed bugs in PCQB_ZExecute , PCQB_SFormatString , PCQB_GetOperatingMode
- PCQB_ZExecute now returns "!!ERROR!!" if the execution of the XML fails
- PCQB_SFormatString now returns an empty string for empty values passed into the function as the first parameter
- Added "EXPIRED" value to PCQB_GetOperatingMode. "EXPIRED" value will be returned if the 30 minute or 30 day demo trial period has timed out
- Fixed bugs in PCQB_ZExecute , PCQB_SFormatString , PCQB_GetOperatingMode
- Version: 1.0.5.8 | Release Date: 06/19/2009 | Platform: Win
- Corrected Connection Errors with QBs 2006 UK edition as plug-in would attempt to create a new connection when a connection was already established
- Corrected Connection Errors with QBs 2006 UK edition as plug-in would attempt to create a new connection when a connection was already established
- Version: 1.0.5.7 | Release Date: 06/05/2009 | Platform: Win
- Repaired bugs in PCQB_Zxxx functions. (inaccurately returning XML from Queries)
- Temporarily removed support for QBOE until QBOE is fully supported
- Fixed bug with calling PCQB_BeginSession when QBs file is closed
- Repaired bugs in PCQB_Zxxx functions. (inaccurately returning XML from Queries)
- Version: 1.0.5.5 | Release Date: 04/03/2009 | Platform: Win
- Fixed bug in PCQB_BeginSession. Would return Error even if a valid file name was passed the function and QB was not running
- Fixed bug in PCQB_BeginSession. Would return Error even if a valid file name was passed the function and QB was not running
- Version: 1.0.5.4 | Release Date: 04/03/2009 | Platform: Win
- Remove bug when beginning a session without a file name
- Remove bug in Australian Versions when creating invalid header path
- Remedy 'Unable to locate XML errors'
- Changed XML returned by all functions such that it is viewable in DataViewer
- Activated last parameter in Zquery function
- Remove bug when beginning a session without a file name
- Version: 1.0.5.3 | Release Date: 03/06/2009 | Platform: Win
- RsOpenNextRelatedRecord now opens the next related record if and only if it is the same type of record as the current record
- Added error trapping to filtering functions to indicate that the filter failed
- Added STRTYPE to SFormatString
- New logo added to all documentation and demo
- RsOpenNextRelatedRecord now opens the next related record if and only if it is the same type of record as the current record
- Version: 1.0.5.2 | Release Date: 03/06/2009 | Platform: Win
- Fixed RsUseXML to properly load xml into parser. This function properly loads QBXML according to the type of session established (POS or Desktop). The XML is loaded and parsed as if it were acquired via the PCQB_RqExecute function. Root nodes of QBXML/QBXMLMsgsRs or QBPOSXML/QBPOSXMLMsgsRs are added to the XML parameter if they do not exist. Note that the function requires a session with QuickBooks that is initiated by either a PCQB_BeginSession, PCQB_ZQuery or PCQB_ZModify function call. On success the loaded XML is available to other PCQB_Rsxxxx function calls
- Added "text" "time" "date" and "interval" for reverse formatting (QB to FileMaker)
- Removed trailing carriage return from values returned by PCQB_SGetXML function
- PCQB_SFormatString funtion takes additional values as the second parameter. These values "text", "time", "date", and "interval" convert the first parameter FROM QuickBooks format to FileMaker format instead of converting from FileMaker to QuickBooks format
- Fixed RsUseXML to properly load xml into parser. This function properly loads QBXML according to the type of session established (POS or Desktop). The XML is loaded and parsed as if it were acquired via the PCQB_RqExecute function. Root nodes of QBXML/QBXMLMsgsRs or QBPOSXML/QBPOSXMLMsgsRs are added to the XML parameter if they do not exist. Note that the function requires a session with QuickBooks that is initiated by either a PCQB_BeginSession, PCQB_ZQuery or PCQB_ZModify function call. On success the loaded XML is available to other PCQB_Rsxxxx function calls
- Version: 1.0.5.1 | Release Date: 03/06/2009 | Platform: Win
- Repaired MSXML6 references
- Updated Documentation
- Repaired MSXML6 references
- Version: 1.0.5.0 | Release Date: 01/27/2009 | Platform: Win
- Changed location of PCI registration file for support with FileMaker 10.
PCI files are now stored in a subfolder of the local application data folder. Symbolic path is %APPDATA_LOCAL%/PCINC/productName/productVersion - Updated Installation and Registration document
- Changed location of the XSD files for support with FileMaker 10 to the local application data folder. The symbolic path is
%APPDATA_LOCAL%/PCINC/productName/XSD
- Changed location of PCI registration file for support with FileMaker 10.
- Version: 1.0.4.1 | Release Date: 01/15/2009 | Platform: Win
- Fixed error with optHideWindow parameter in PCQB_BeginSession and PCQB_RqExecute
- Compatible with FileMaker 10
- Fixed error with optHideWindow parameter in PCQB_BeginSession and PCQB_RqExecute
- Version: 1.0.3.1 | Release Date: 12/12/2008 | Platform: Win
- Modified so that OwnerID and IncludeRetElement are not added to end of request. They are instead kept in the position in which they are added. (DataExtMod requests were failing )
- Modified so that OwnerID and IncludeRetElement are not added to end of request. They are instead kept in the position in which they are added. (DataExtMod requests were failing )
- Version: 1.0.3.0 | Release Date: 11/04/2008 | Platform: Win
- Compatibility to use the same type XML pass through commands as FileBooks Link
- Support for QuickBooks 2009 versions
- Enhanced FileMaker demo file to be compatible with international versions of QuickBooks (Canadian, UK and Australian)
- Single plug-in to support for QuickBooks international versions (Canadian, UK and Australian) 2004-2009
- New Function Calls Include:
- PCQB_ZParseXML Loads an XML document into memory and applies the XPath query to the document.
- PCQB_RqExecute Allows for a filter string to filter results, and a path string to save the results
- PCQB_RqAddFiledWithValue Automatically formats most input values to values expected by QuickBooks
- PCQB_RqUseXML Allows for path to XML file as input or direct XML as input
- PCQB_RsUseXML Allows user to load an XMK document into the parser
- PCQB_SFormatString Returns the input string formatted to the desired QB format
- PCQB_ZParseXML Loads an XML document into memory and applies the XPath query to the document.
- Compatibility to use the same type XML pass through commands as FileBooks Link
- Version: 1.0.2.7 | Release Date: 10/22/2008 | Platform: Win
- Registration changes:
- Creates certificate with only 2 version numbers
- Supports extra parameter in LicenseID ( licenseID "|"
- Removed 30 minute timeout
- Creates certificate with only 2 version numbers
- Registration changes:
- Version: 1.0.2.6 | Release Date: 10/21/2008 | Platform: Win
- Bugs Fixes:
- fixed the index of the first record to properly increment on the first call to PCQB_RsOpenFirstRecord.
- PCQB_SGetXML now returning the proper value
- now returns the full document if the user hasn't specified a filter otherwise it returns the filtered response
- xnDisplayAdd/Mod now returns proper value
- fixed the index of the first record to properly increment on the first call to PCQB_RsOpenFirstRecord.
- Modifications:
- Build to support QBSDK 8
- Includes support for International (UK, Canadian and Australian) versions
- Added ability to pass a text value with the PCxx_Register function. This is to enable 123 Sync the ability to pass a QB File name when registering the plug-in. The proper format is license_ID & "|" & textString for example PCQB_Register( "PCIFMBC|My QuickBooks File.QBW" ; "80" ; .... )
- Added functionality:
- PCQB_ZParseXML - loads an XML document into memory and applies the XPath query to the document.
- Bugs Fixes:
- Version: 1.0.2.5 | Release Date: 10/08/2008 | Platform: Win
- QuickBooks 2009 compatibility
- Modified Demo file set up page
- QuickBooks 2009 compatibility
- Version: 1.0.2.3 | Release Date: 10/08/2008 | Platform: Win
- Roll back QBXMLRP usage to version 5.0 (QBXMLRP.DLL ) to support Canadian versions
- Roll back QBXMLRP usage to version 5.0 (QBXMLRP.DLL ) to support Canadian versions
- Version: 1.0.2.2 | Release Date: 10/08/2008 | Platform: Win
- Add extra functions and parameters for working with stored XML files.
- PCQB_RqExecute allows for a filter string to filter results, and a path string to save the results
- PCQB_RqAddFiledWithValue Automatically formats most input values to values expected by QuickBooks
- PCQB_RqUseXML allows for path to XML file as input or direct XML as input
- PCQB_RsUseXML allows user to load an XMK document into the parser
- PCQB_SFormatString returns the input string formatted to the desired QB format.
- Add extra functions and parameters for working with stored XML files.
- Version: 1.0.2.1 | Release Date: 09/02/2008 | Platform: Win
- Extended plug-in demo to a 30 day period
- Demo now has the ability to push an invoice with or without a class
- Updated Demo logo and several minor cosmetic Demo updates
- Extended plug-in demo to a 30 day period
- Version: 1.0.2.0 | Release Date: 09/02/2008 | Platform: Win
- Added:
new - PCQB_RsUseXML
new = PcQB_SFormatString
updated = PCQB_RqUseXML - takes parameters indicating input is a file, and a XPath string
updated = PCQB_RqExecute - new file path to write response to, XPath to filter results
updated PCQB_RqAddFieldWithValue
updated PCQB_SGetXML
- Added:
- Version: 1.0.1.2 | Release Date: 09/02/2008 | Platform: Win
- Minor change in the registration process. Swapped setting creation date/time on PCI certificate
- Minor change in the registration process. Swapped setting creation date/time on PCI certificate
- Version: 1.0.1.1 | Release Date: 12/01/2007 | Platform: Win
- Changed the demo to reflect webserver.productivecomputing.com instead of www.filemakerconsulting.com
- Removed bug causing the FM Application window to resize
- Changed the demo to reflect webserver.productivecomputing.com instead of www.filemakerconsulting.com
Additional Information
Please Note:
This fully functional demo file is usable for 30 days. However, the demo will expire 2 hours from opening your FileMaker application. To reset please close and reopen your FileMaker application.
Mac Template Download and Details:
The FM Books Connector Mac Template is for development purposes only. For full functionality to communicate directly with QuickBooks for Windows the full version of the FM Books Connector plug-in is required. Unfortunately, communication of any kind to the Macintosh version of QuickBooks is not available since Intuit does not have a Mac compatible Software Development Kit (SDK).
Download Mac Template
Integration Details:
Successful integration of FileMaker plug-ins requires the creation of integration scripts within your FileMaker solution. Intermediate to advanced experience with FileMaker Pro, especially in the areas of scripting and calculations, is necessary to integrate this plug-in. After review of our overview videos, sample scripts and documentation you find you need assistance please contact us or fill out a Request For Quote.
Ready to get started now - try Core CRM Pro! Core CRM Pro comes pre-configured with 30-day trial versions of the FM Books Connector or FM Books Connector Online plug-ins and is designed to integrate with your existing QuickBooks company file (Desktop or Online). Core CRM Pro allows you to pull your existing QuickBooks contacts and items in order to set up your file, as well as continually push customer and invoices and pull payment balances.
Have your own solution but need to integrate with QuickBooks Online (Windows or Mac), please see the FM Books Connector Online plug-in.