top of page

Epicor Prophet 21 ERP SQL Developers

Epicor Prophet 21® Wholesale Distribution Software - P21 SQL Development Projects, Scripts, & Tasks

Our focus in the wholesale distribution space is on the Prophet 21® user community.  Our team has worked with over 500 companies (across the USA, Canada ...and as far away as Australia) that use the Epicor Prophet 21® system since 2007.
We bring you a totally unique mix of technical programming competence, a deep understanding of distribution business processes and a vast amount of experience, learning and understanding of the complex code/framework that the Prophet 21® ERP system is built on. 


We've built our reputation in being consultants/advisors first, and programmers/developers second. We will always give you our best advice first, and if engaged to execute a project, we will then engineer and deliver an innovative customer-centric solution for your organization, on time, on spec, and on budget.

SQL® Tasks: Custom SQL queries / views, data exports, SSIS & DTS packages, email alerts and triggers.  We can help you get a lot more out of your Prophet 21® system through custom SQL programming services.

Examples of recent custom SQL tasks/projects:

  • Created a trigger to set up an alert – send email notification to recipients when a new customer / contact is created in the system. Currently this is not a possibility using the P21® interface.

  • Created a script to run nightly that will review all tasks that exist as a result of quotes created in the system that have been converted to orders. The script then marks all tasks for these quotes as completed and then marked as closed.

  • Mass data import / export (product images and/or documents in the document links tab, updates to product descriptions, data extractions such as product listings).

  • Created SQL script to un-delete 21,000 items that were mistakenly marked as deleted in the P21® system.


Examples of recent Email Alerts and Triggers:

  • Most often done using SQL DB Mail and/or combination of custom application + DB Mail.

  • Shipment email confirmation.

  • Open RMA email reminder (customer created RMA but haven’t sent the product back).

  • Email alert/reminder outstanding invoice due.

  • Email alert/reminder for open quotes.

  • Alert Customer Service Reps of scheduled orders about to expire so can they reach out to customer and review.


We are builders (of applications), miners (of data) and fire fighters (in attacking your special projects & business challenges). Our management team a ton of combined experience in the manufacturing and distribution sectors and our team has logged tens of thousands of development hours with the Prophet 21® system since 2007.

Please contact us if we can help -or- be a resource in your P21 SQL Adventures!


We appreciate the opportunity to be (or to become) your Partner-in-P21!

bottom of page