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

​

Our primary focus in the wholesale distribution sector is the Prophet 21® user community. Since 2007, we have collaborated with over 500 companies across the USA, Canada, and even Australia that use the Epicor Prophet 21® system.

​

We offer a unique blend of technical programming expertise, a deep understanding of distribution business processes, and extensive experience with the complex code and framework of the Prophet 21® ERP system.

​

Our reputation is built on being consultants and advisors first, and programmers and developers second. We provide the best advice first, and if engaged for a project, we engineer and deliver innovative, customer-centric solutions on time, on spec, and on budget.

​

SQL® Tasks:

We offer custom SQL queries, views, data exports, SSIS & DTS packages, email alerts, and triggers. Our custom SQL programming services can help you maximize the potential of your Prophet 21® system.

​

Examples of Recent Custom SQL Tasks/Projects:
 

• Email Notification Trigger: Created a trigger to send email notifications when a new customer/contact is created in the system, a feature not available in the P21® interface.

• Automated Task Review Script: Developed a nightly script to review tasks resulting from quotes converted to orders, marking them as completed and closed.

• Mass Data Import/Export: Handled large data imports/exports, including product images, document links, product description updates, and data extractions.

• Item Restoration Script: Created a SQL script to restore 21,000 items mistakenly marked as deleted in the P21® system.

Examples of Recent Email Alerts and Triggers:
 

• Shipment Email Confirmation: Automated email confirmations for shipments.

• Open RMA Reminder: Sent reminders for open RMAs where the product has not been returned.

• Outstanding Invoice Reminder: Alerts for due invoices.

• Open Quotes Reminder: Notifications for open quotes.

• Order Expiration Alert: Informed customer service reps of scheduled orders about to expire to prompt customer outreach.

Our Approach:
 

We are builders (of applications), miners (of data), and fire fighters (attacking your special projects and business challenges). Our management team has extensive 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.

​

Contact us if we can assist or be a resource in your P21 SQL Adventures.
We appreciate the opportunity to be, or to become, your Partner-in-P21!