Here's your June Adventures-in-P21 eNews Update.
Your review of projects, tips, industry scoop, and more.
Now reaching over 3,800 (world-class) Prophet 21 ERP system users!
|
|
- We hope this message finds you doing well (and hanging in there) during these sad and totally unexpected times. We are all in this together, if our team can help you in any way, please reach out...we are here for & with you!
- P21WWUG Connect 2020, will be a virtual event this year. The Session Schedule is now available...more scoop will be coming in our July newsletter!
|
|
|
Recent Custom Projects for P21® System Users
|
Our Team has been busy since our last update in April. Here are new project examples that highlight our core focus areas completed since our last newsletter. If you'd like help with challenges in any of these types of projects, please let us know.
|
|
New & Recent Projects Round-up
|
|
New Custom Purchase Order Update Management Solution
|
|
Here's the sample workflow process for our custom PO Update Manager Web Portal (we can fully customize same, similar, and/or different for your unique needs):
- Users will login to web portal (Use windows authentication for P21)
- User will see a list of Open Po's
- User will then be able to filter by any/all columns (see PO Edit.xlsx sheet for a list of columns)
- After the user has filtered down the list of Po's they will be able to easily modify:
- po_hdr_ud.confirmed
- p21_view_po_line.required_date
- p21_view_po_line.date_due
- p21_view_po_line.expected_ship_date
- p21_view_po_line.supplier_ship_date
- shipped – This is a conditional field ( if ship_date is not null then ‘Y’ )
- PO NOTES (only show / edit notes with the Expedite tag)
- After the user has completed the changes on the portal, the user would click SAVE.
- This will fire a process to update all modified Purchase Orders.
|
|
New Custom Sales/Order Entry Portal & Shopping List Application
( The vid is a bit choppy but it's a good visual example of one of our recent custom projects )
|
|
Recent P21 Business Process Automation Projects:
|
|
- Automating imports such as Journal Entry, Invoice, Orders, etc. using XML automation in P21.
- Automating other tasks such as open/close orders to trigger down-payments and the closing/opening of cash drawers. (a few, of many possible XML automation examples).
- Numerous P21 data import and export projects.
- M&A ERP Data Migration - migrating data from various ERP platforms into P21 and bringing newco's on to P21.
- Document Link Solution.
- A Web form interface triggered by business rule for creating/editing Hazmat Shipping batches with reports to be printed and saved as PDF.
- Inventory Information Portal.
- Auto AP Past Due Invoice Process.
- Barcodes of Pick Ticket Barcodes on transfer and transfer pack list.
- Custom VMI solution new features - added Scandit scanner library.
- Printing to specific default printer(s).
- TSC printer project - developed an interface to print labels for individual items on PT.
- FedEx, UPS, Carrier, etc. Freight Rate inbound & outbound Business rules.
- A/P Freight Validation - added extra extra logic for the adjustments to not round to the min. tonnage.
- P21 assembly copying.
- Assembly component modification and cost update.
- Service Order Customizations and Service Ops Software integrations w/P21.
- Time Clock / Job Management System.
|
|
Connecting P21 data with third party software: we've been opening the P21 system up to best-in-class third party software solutions, and helping users get more out of P21 since 2007...If you'd like to connect to a third party software system, we can probably help.
Past projects include: Amex, Amazon, AutoCrib, eBay, Profit2, Blue Ridge Global, Waterloo Information Systems Limited (WISL), SnapVend, epaCUBE, ShipLink Global, Restaraunt365, Rubber Tree Systems, Bezlio,
Salesforce (SFDC), Salesforce Service Lightening, Service Titan,
and Banyan Technology...coming soon: SAP Concour and BuyRexRoth Bosch.
eCommerce Integrations
(please visit our new ecommerce integrations page here)
:
our focus is on using our custom API middleware (and/or Epicor APIs) needed to bridge & connect the data streams between systems. We usually work with front-end teams or internal resources that manage the design and marketing. Big Commerce & Magento are (currently) the two most popular ecommerce products that we're getting requests for...we can connect most Ecom platforms (including custom solutions).
Here are a few current integration project examples:
- ROC Commerce & P21.
- Magento & P21 Integration Project.
- OroCommerce & P21 Integration Project.
- WMS (Warehouse Management Systems) Integration Project.
- AutoCrib FTP Integration.
- SAP Concur Accounts Payable (AP) Automation Integration.
- SalesForce Integration Project.
- ASPDotNet Storefront Project.
|
|
Recent rules examples:
- Business rule that captures and validates UOM conversions on order line.
- Business rule that sets stockable flag on new item on the fly creation.
- Business rule that displays custom crystal form as PDF from button in ShipTo based on custom fields.
- Order Entry Credit Card Fee Business Rule.
- Limit Payment Type per Role.
- New Item Sale Business Rule.
- Change contact type business rule.
- WWMS COO Business Rule.
- Inventory Source Location Availability rule.
- Calculate Freight button - Specific address freight per order.
- Freight matrix BR (changes for quotes).
|
|
Because so many customers have asked, we've added our (most popular)
|
|
Custom Reports
Recent Reporting Projects
- Custom Crystal Report Modifications.
- Crystal Forms Cost Check Report.
- Made requested modifications to open PO query and excel file.
- Inventory Value Report.
- Backorder Report.
- Price Update Report process revamp.
- Bin Report.
- Inventory Quantities Report.
- Accessory Item sub report.
- PO Receipt Cost Check Report Redo.
- Daily Invoice Credit report.
- Cost Reduction Impact Report
- Customer Price Extract Report.
- SSRS Reports.
- Asset Dashboard Report.
Forms Changes
- Add qty ship/back order qty to order & purchase order.
- Add Customer PO to Consolidated Invoice.
- Alternate Items on Quote Form.
- Add Supplier Part No to Pick Ticket.
We can help with all of these types of custom BI & Forms requirements
|
|
P21 Vendor and MindHARBOR Partner Spotlight
|
|
ShipLink Global has been impressing system users over, and over, and over!!
See ShipLink for Prophet 21 in Action -
To learn more about Prophet 21 integration and configuration capabilities, contact ShipLink Global
at 657.222.0500
or visit:
ShipLink Global Online
|
|
Why are 82% of U.S. Businesses Migrating to Digital AR Workflows?
Especially now in this “new normal” pandemic economy, businesses must manage costs and revenue with precision. That’s why MindHARBOR is partnering with fintech leader
Unified Payments Group
whose cloud-based, modular payment acceptance solutions integrate seamlessly with P21 to streamline and automate users’ AR processes and workflows.
Do you know how much paper checks, PDF invoices and credit card acceptance cost your business?
What do customers say about Unified Payments Group?
“The National Association of Wholesaler-Distributors endorses Unified as our exclusive partner for AR and payment acceptance technology to our industry because their solutions are best-in-class. Unified’s integrity and the unparalleled support they provide are why NAW is more than just a partner, we are also a customer,
”
said NAW’s Chief Affinity Officer, Anthony Simone.
Digital transformation doesn’t have to be disruptive.
Unified’s suite of automated AR and cash app solutions, including dynamic e-invoicing, no-cost credit card acceptance, pay-by-text, online and mobile/curbside payments, and more are supported by subject matter experts from the payment and treasury management industries.
Receive your complimentary AR Savings Consultation
...to understand what Least-Cost Payment Routing can do for your business.
|
|
ORO Commerce for Prophet 21 ERP Users
Oro Inc., founded in 2012 by industry leaders in open-source business application development, is the company behind OroCRM, OroCommerce, and OroPlatform. Due to their smart and flexible architecture and robust feature set Oro products have rapidly become popular within B2B and multichannel commerce spheres gaining the title of the No.1 B2B eCommerce product of 2017 by Frost and Sullivan
...learn more about Oro & P21!
How Midway Dental Supply bridged the gap to ecommerce - by Peter Lucas @ DigitalCommerce360 - Looking to get out from under a non-user-friendly ecommerce platform, Midway Dental found the answer to its problem in middleware software that integrated a new ecommerce site with its P21 ERP system using MindHARBOR's custom API's.
|
|
Epicor®, Prophet 21®, KKR, and Your Industry News Round-up
|
|
Cloud Transition During the COVID-19 – Exposing the Enterprise Vulnerabilities - “In times of economic and business uncertainty, cybercriminals are taking full advantage of the situation,” says Emma Vas, Director of Product Marketing for Distribution, Epicor, in an Exclusive interview with Enterprise Talk.
Behind Gustave A. Larson’s Timely Pre-Pandemic Pivot (Our Congrats to Rob S. & Team G.A. Larson!) -
By: Eric Smith - MDM - Over the last two years, Milwaukee-based HVACR distributor Gustave A. Larson Co. has transitioned from outside to inside sales, a move that became reality at the start of 2020. That sales model transformation has paid dividends during the coronavirus crisis, and now the company enters the post-pandemic well-positioned for the summer surge.
ERP Expands Alongside WMS
-
Supply Chain Management Review -
With Epicor's Prophet 21 WMS, APIs communicate and sync needed processes with automated systems, whether that be robotics, an automated storage ...
Distribution’s Value: Rebuilding for the Next Normal - By: Thomas P. Gale - MDM's Tom Gale is optimistic that over the next several months distribution will play such a critical role in getting our economy off its back and to fully functioning capacity as quickly as possible.
As established but "monolithic" ecommerce technology becomes outdated and less effective, the current crop of B2B commerce platforms are competing to offer more flexibility in connecting with customers. But they also vary widely in meeting the particular needs of any one company, Forrester Research says in a new review of 13 technology vendors.
Amazon Business is on track to be the biggest industrial distributor
- by Mark Brohan - DigitalCommerce360 - Amazon Business will achieve gross merchandise volume (GMV) of $75 billion by 2023, Applico says. This sales growth would make Amazon Business the biggest industrial distributor in the United States, according to a new study from marketplace services provider Applico Inc.
B2B Trends & Charts - Fastenal expects a surge in ecommerce sales - The distributor of industrial and construction supplies said its ecommerce sales grew 27% in the first-quarter, bringing sales on Fastenal.com to a record 10% of total sales in March. Including other internet-based sales such as vending machines brings ecommerce to 35% of total sales—a share expected to keep growing, executives said. Read Now
Resources On Linkedin:
Join the New P21 User Group, Group on Facebook (now @134 members & growing):
If you aren't a member yet,
you ARE missing out!
|
|
We get a lot of emails from our friends in the P21 user community each month that are looking for new roles, opportunities, and/or seeking relocation. We also get contacts from companies that are looking for fulltime talent.
We'll always do our best to connect talent...if you are looking for a new role, or if you have an opening, please send Mike the details…when we see a fit, we’ll gladly (and confidentially) make the connections (without any fees or strings for either party). We've helped make MANY of these win/win connections over the past 14 years, and we've already connected
3
new hires in 2020 (with a few more pending)!
|
|
Got Content, Feedback, Questions?
|
|
|
If you have articles, press releases, adventures, questions, and/or tips to share with other Prophet 21® system users in the next edition of Adventures in P21, please send them our way! e.
blaze@mindharbor.com
|
|
MindHARBOR.com Quicklinks & More Information:
|
|
Thank you for reading, and for the opportunity to be your Partner-in-P21!
|
|
Please forward & share this newsletter with a fellow P21 user today!
|
|
MindHARBOR is not part of /or associated with any of the brands and logos listed on this email or our website including: Epicor Software Corp., Epicor Prophet 21®, Epicor 8 Vantage®, Epicor 10®, NetSuite®, Activant®, Dynachange®, ICE®, Microsoft®, AutoCrib®, Cribmaster®, SnapVend®, Power Bi®, Intel®, Microsoft®, 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, custom business application development, SQL server reporting services (SSRS), and eBusiness Consulting services on time, on spec and on budget...
since we opened our business on January 1, 2000.
|
|
|
|
|
|
|