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 the transaction checks with Cleared, NotCleared or Pending status. |
| CreateReportSchema | Generates a report schema file. |
| GetQBFileStatus | Gets the status of the quickbooks file. |
| ListMerge | Merge two accounts, customers, or vendors. Requires QBXML version 7.0 or higher. |
| SearchEntities | Search entities in QuickBooks. |
| SendQBXML | Sends the provided QBXML directly to QuickBooks. |
| SendQBXMLFile | Sends the provided QBXML file directly to QuickBooks. This is designed for use with mass inserts. |
| VoidTransaction | Voids a given transaction in QuickBooks. |