Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the adapter beyond simple SELECT operations with Sage 300.
Stored procedures accept a list of parameters, perform their intended function, and then return, if applicable, any relevant response data from Sage 300, along with an indication of whether the procedure succeeded or failed.
Sage 300 Adapter Stored Procedures
| Name | Description |
| APCreateGLBatch | Usage information for the operation APCreateGLBatch.rsb. |
| APCreateRecurringPayableBatch | Usage information for the operation APCreateRecurringPayableBatch.rsb. |
| APCreateRetainageDocumentBatch | Usage information for the operation APCreateRetainageDocumentBatch.rsb. |
| APDeleteInactiveRecords | Usage information for the operation APDeleteInactiveRecords.rsb. |
| APPostInvoices | Usage information for the operation APPostInvoices.rsb. |
| APPostPaymentsAndAdjustments | Usage information for the operation APPostPaymentsAndAdjustments.rsb. |
| ARCreateGLBatch | Usage information for the operation ARCreateGLBatch.rsb. |
| ARCreateRecurringCharge | Usage information for the operation ARCreateRecurringCharge.rsb. |
| ARCreateRetainageDocumentBatch | Usage information for the operation ARCreateRetainageDocumentBatch.rsb. |
| ARPostInvoices | Usage information for the operation ARPostInvoices.rsb. |
| ARPostReceiptsAndAdjustments | Usage information for the operation ARPostReceiptsAndAdjustments.rsb. |
| ARPostRefunds | Usage information for the operation ARPostRefunds.rsb. |
| CreateSchema | Creates a schema file for the specified table or view. |
| GLPostJournal | Usage information for the operation GLPostJournal.rsb. |
| ICCreateGLBatch | Usage information for the operation ICCreateGLBatch.rsb. |
| ICDayEndProcessing | Usage information for the operation ICDayEndProcessing.rsb. |
| POCreateBatch | Usage information for the operation POCreateBatch.rsb. |
| PODayEndProcessing | Usage information for the operation PODayEndProcessing.rsb. |