• Facebook Social Icon
  • LinkedIn Social Icon

p. 678.720.2223    |       email us

MindHARBOR, Inc. 13000 Deerfield Parkway, Suite 300, Alpharetta GA 30004 | with remote staff in CA, FL, GA, IL, MI, OH, TX, and UT.

MindHARBOR is not part of / or associated with any of the registred brands and logos listed on this website including: Epicor Prophet 21, EPICOR, Activant, Dynachange, ICE, ORACLE, Microsoft, AutoCrib, and/or any other registered brands and service marks. MindHARBOR "is" an independent systems provider specializing in high end, high quality custom C# .NET programming, application development, Dynachange business rules, SQL server reporting services (SSRS), custom integration and other development services for manufacturing, wholesale distribution, and services based organizations -AND- Epicor Prophet 21 ERP system users on time, on spec and on budget ...since January of 2000.

© 2000-2019 by MindHARBOR, Inc., All Rights Reserved.  

Epicor Prophet 21 ERP SQL Developers

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

Our focus in the wholesale distribution space is on the Prophet 21® user community.  Our team has worked with over 350 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!