Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Reckon.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Reckon, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Reckon Stored Procedures
| Name | Description |
| ClearTransaction | Marks the transaction checks with Cleared, NotCleared or Pending status. |
| CreateReportSchema | Generates a report schema file. |
| CreateSimpleReportSchema | Generates a simple 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. |
| ReportAging | Generates Reckon aging reports. |
| ReportBudgetSummary | Generates budget reports. |
| ReportCustomDetail | Generates a custom transaction detail report. |
| ReportCustomSummary | Generates a custom summary report. |
| ReportGeneralDetail | Generates a general detail report. |
| ReportGeneralSummary | Generate a general summary report. |
| ReportJob | Generates job reports. |
| ReportPayrollDetail | Generates payroll reports. |
| ReportPayrollSummary | Generates payroll summary reports. |
| ReportTime | Generates summary and detail reports related by time. |
| SearchEntities | Search entities in Reckon. |
| SendQBXML | Sends the provided QBXML directly to Reckon. |
| SendQBXMLFile | Sends the provided QBXML file directly to Reckon. This is designed for use with mass inserts. |
| VoidTransaction | Voids a given transaction in Reckon. |