SalesPad SQL Procedures that use SPCP

Overview

This is a list of SalesPad stored procedures that have the code to call an spcp (SalesPad Custom Procedure). Custom procedures do not get overwritten or deleted when you run a database update for SalesPad. If you modify the stock procedure, it will get refreshed any time you run the database update.

Called directly from the application:

1. spcpAssemblyReport
2. spcpARStatementReport
3. spcpMOReport
4. spcpPurchaseOrderReport
5. spcpSalesDocumentReport
6. spcpInventorySalesLineTransfer
7. spcpInventorySalesTransfer
8. spcpGetPONextNumber
9. spcpUpdatePurchaseLine
10. spcpCCProcessorInfo
11. spcpOpportunityReport
12. spcpServiceTransferReport

Called from a stored procedure:

1. sppAvataxPostSave - spcpAvataxPostSave
2. sppAvataxPreSave - spcpAvataxPreSave
3. sppCustomerSummary - spcpCustomerSummary
4. sppEvalWfRule - spcpEvalWfRule
5. sppEvalWfRuleCondition - spcpEvalWfRuleCondition
6. sppFulfillReturn - spcpFulfillReturn
7. sppGetBulkPickTicketInfo - spcpGetBulkPickTicketInfo
8. sppGetCustomZipInfo - spcpGetCustomZipInfo
9. sppGetExtendedPricing - spcpGetExtendedPricing
10. sppGetIDNumber - spcpGetIDNumber
11. sppGetInventorySearch - spcpGetInventorySearch
12. sppGetItemPriceExt - spcpGetItemPriceExtSerialLotBin
13. sppGetItemPriceExt - spcpGetItemPriceExt
14. sppGetItemPriceNonExt - spcpGetItemPriceNonExtSerialLotBin
15. sppGetItemPriceNonExt - spcpGetItemPriceNonExt
16. sppGetNextCustomerID - spcpGetNextCustomerID
17. sppGetNextReceiptID - spcpGetNextReceiptNum
18. sppGetNextVendorID - spcpGetNextVendorID
19. sppGetShippingOptions - spcpGetShippingOptions
20. sppItemBarcode - spcpItemBarcode
21. sppPickMultibin - spcpPickMultibin
22. sppRecalcFulfilled - spcpRecalcFulfilled
23. sppRecalcRTVBatch - spcpRecalcRtvBatch
24. sppRecalcSOPBatch - spcpRecalcSOPBatch
25. sppSalesAnalysis - spcpSalesAnalysis
26. sppSalesDocShippingDetail - spcpSalesDocShippingDetail
27. sppSalesDocument_Connector_PostUpdate - spcpSalesDocument_Connector_PostUpdate
28. sppSalesMonitor - spcpSalesMonitor
29. sppUpdateAssembly - spcpGetNextAssemblyID
30. sppUpdateCRMNote - spcpUpdateCRMNote
31. sppUpdateCustomer - spcpGetNextCustomerID
32. sppUpdateCustomerDiscountDetail - spcpUpdateCustomerDiscountDetail
33. sppUpdateCustomerSecureCreditCard - spcpUpdateCustomerSecureCreditCard
34. sppUpdateDW - spcpUpdateDW
35. sppUpdateItemBarcode - spcpUpdateItemBarcode
36. sppUpdateItemMaster - spcpUpdateItemMaster
37. sppUpdateItemPriceList - spcpUpdateItemPriceList
38. sppUpdateVendor - spcpGetNextVendorID
39. sppVendorSummary - spcpVendorSummary
40. sppGetNextOpportunityNumber - spcpGetNextOpportunityNumber
41. sppGetNextProspectNumber - spcpGetNextProspectNumber

Note: To create your own custom procedure for stock procedures that allow it, you can take the original procedure, rename it to an spcp, and remove the section that calls the spcp and use that for the base procedure

Disclaimer: SalesPad is not responsible for code in the spcp nor any issues that are a result of modified logic used in the spcp procedure. If a support issue is found to be related to a customer written spcp, any time spent by SalesPad may be billable.