Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with QuickBooks.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from QuickBooks, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for QuickBooks Stored Procedures
| Name | Description |
| ClearTransaction | Marks specified transaction checks in QuickBooks with statuses such as Cleared, NotCleared, or Pending for reconciliation. |
| CreateReportSchema | Generates a schema file for custom QuickBooks reports, providing a structure for tailored data extraction. |
| GetQBFileStatus | Retrieves the current status of the QuickBooks file, providing insight into its availability or issues. |
| ListMerge | Merges two accounts, customers, or vendors in QuickBooks. Requires QBXML Version 7.0 or higher. |
| SearchEntities | Facilitates entity searches in QuickBooks by various attributes, streamlining entity identification. |
| SendQBXML | Sends QBXML data directly to QuickBooks, enabling custom operations or mass processing. |
| SendQBXMLFile | Sends a QBXML file directly to QuickBooks for bulk operations or advanced data handling. |
| VoidTransaction | Voids a specified transaction in QuickBooks, ensuring proper tracking and adjustment of financial records. |