Skip to main content

SalesPad SQL Procedures that use SPCP - Knowledgebase / SalesPad / Troubleshooting - Cavallo Technical Support

SalesPad SQL Procedures that use SPCP

Authors list
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.

Helpful Unhelpful