Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Microsoft Dynamics GP.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft Dynamics GP, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for Microsoft Dynamics GP Stored Procedures
| Name | Description |
| CreateSchema | Creates a schema file for the specified table or view. |
| VoidCashReceipt | This stored procedure voids a cash receipt. |
| VoidPurchaseOrder | This stored procedure voids a purchase order document. |
| VoidReceivablesCreditMemo | This stored procedure voids a receivables credit memo. |
| VoidReceivablesReturn | This stored procedure voids a receivables return. |
| VoidSalesBackorder | This stored procedure voids a sales backorder. |
| VoidSalesInvoice | This stored procedure voids a sales invoice. |
| VoidSalesOrder | This stored procedure voids a sales order. |
| VoidSalesQuote | This stored procedure voids a sales quote. |
| VoidSalesReturn | This stored procedure voids a sales return. |