Why ERP Systems Still Leave Procurement Teams Using Excel and Email

Many manufacturers and distributors invest heavily in enterprise resource planning (ERP) systems, yet purchasing teams still spend hours exporting data, calculating orders in Excel, and following up with suppliers.

The problem isn't necessarily that their ERP lacks purchasing functionality. It's that maintaining procurement records and automating day-to-day purchasing decisions are two different things.

ERP procurement automation connects information, calculations, and supplier workflows so purchasing teams can execute routine orders with less manual effort.

Why Traditional ERP Workflows Still Require Manual Purchasing

An ERP can store inventory balances, supplier information, production schedules, and purchase orders.

However, the information required to make a purchasing decision often exists outside the system.

At Nyck AI, we've repeatedly seen four disconnected sources of purchasing information:

• ERP: Inventory, sales, production plans, and existing orders.

• Excel: Supplier MOQs, lead times, pricing, and packaging requirements.

• Email: Updated delivery dates, supplier confirmations, and pricing changes.

• Employee knowledge: Seasonal purchasing practices, acceptable substitutions, and warehouse constraints.

A buyer may need to consult all four before determining what to purchase.

This fragmentation explains why having an ERP doesn't automatically eliminate manual procurement.

The Six Costs of Manual Procurement

When purchasing depends on spreadsheets and email, companies commonly encounter six problems.

1. Stockouts and overstock: Incomplete purchasing information can lead to missed demand or unnecessary inventory.

2. Purchasing errors: Manual calculations and inconsistent schedules increase the risk of missing SKUs or placing orders late.

3. Lost productivity: Purchasing managers spend time preparing and tracking orders instead of negotiating with suppliers or identifying cost savings.

4. Working capital constraints: Businesses may overbuy to protect against uncertainty, tying up cash in inventory.

5. Limited pricing visibility: Supplier price changes can be difficult to track when information is scattered across systems and communications.

6. Poor purchase order visibility: Buyers may struggle to determine which orders are confirmed, delayed, or require follow-up.

These issues are not inevitable features of ERP software. They often reflect gaps in how a company's purchasing workflows are configured and connected.

How to Automate Procurement Without Replacing Your ERP

For many manufacturers, the answer is to build a connected procurement workflow around existing systems.

Step 1: Unify Procurement Data

Bring together ERP records, supplier requirements, operational knowledge, and relevant supplier communications.

Accurate, consistent data is essential. Automating decisions using incomplete information can introduce new errors rather than eliminate old ones.

Step 2: Standardize Purchasing Decisions

Establish clear rules for order timing, replenishment calculations, and supplier constraints.

Standardizing these decisions reduces reliance on repetitive spreadsheet work.

Step 3: Automate Order Execution

Use automation to help calculate order quantities, draft purchase orders, communicate with suppliers, and track confirmations.

Include appropriate human review for exceptions and high-impact purchasing decisions.

Step 4: Measure Procurement Performance

Track time spent preparing orders, purchasing accuracy, inventory levels, supplier response times, and cost savings.

The objective is to improve purchasing outcomes, not simply automate more activities.

How Nyck AI Works With Existing ERP Systems

Nyck AI is designed to automate procurement for mid-sized manufacturers and distributors using information from their existing systems.

By connecting ERP data with supplier-specific requirements and purchasing workflows, Nyck supports:

• Demand forecasting and purchasing schedules.

• Order calculations and quantity optimization.

• Purchase order preparation.

• Supplier communication and order confirmations.

• Purchasing visibility and cost-saving opportunities.

Instead of forcing buyers to manually coordinate every step, Nyck brings these activities into a connected procurement process.

Frequently Asked Questions

Can procurement be automated without replacing an ERP?

Yes. Procurement automation software can integrate with existing ERP systems to support purchasing calculations, purchase order preparation, supplier communication, and order tracking. Compatibility depends on the ERP and its available integrations.

What's the difference between an ERP and procurement automation software?

An ERP manages core business information and transactions. Procurement automation software focuses on executing and optimizing purchasing workflows, often using data maintained in the ERP.

Turn Procurement Data Into Action

Your ERP provides an important foundation for managing operations. The next opportunity is ensuring that purchasing teams can act on that information efficiently.

Learn how Nyck AI automates purchasing alongside existing systems or book a demo.