Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Sage Intacct.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Sage Intacct, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Sage Intacct Stored Procedures
| Name | Description |
| AccountBalanceReport | Create an Account Balance report. |
| ApproveVendor | Approves vendors by recordno. |
| CreateAttachment | Create an attachment. |
| CreateCustomReportSchema | Creates a schema file for the specified custom report. |
| CreateSchema | Creates a schema file for the specified table or view. |
| CreateTrialBalancesReport | Creates a schema file for the specified custom report. |
| DeclineVendor | Declines vendors by recordno. |
| GetCustomFields | Retrieves custom fields and values from a table / record. |
| GetDimensionRestrictedData | Lists the IDs of related dimensions that are the targets of to-many relationships from a single source dimension. |
| GetKeys | Retrieves a list of keys in an object. |
| GetRelationshipColumns | Sets relationship columns in Intacct. |
| GetUserDateTimePreferences | Obtains Date and Time preferences for a specified user. |
| GetVendorApprovalHistory | Generated a report on the vendor's approval history. |
| ReverseInvoice | Reverses invoice by key and date. |
| SetRelationship | Sets relationship columns in Intacct. |
| UpdateAttachment | Updates the attachment Table. |
| VoidAPPayment | Stored procedure will void appayment records. |