Contents
Supplier Catalog
Overview
Orders → Purchasing → Suppliers’ Catalog
The Supplier Catalog module in Inventory Pro provides a centralized system for managing supplier-specific item information, pricing, and purchasing parameters. This essential tool bridges the gap between your internal item numbering system and supplier-specific part numbers, ensuring accurate ordering and competitive pricing management.
Key Features
- Multi-Supplier Management: Link items to multiple suppliers with individual pricing
- Part Number Mapping: Connect internal item IDs to supplier-specific part numbers
- Price Level Management: Support for multiple pricing tiers (Base, L1-L5)
- Lead Time Tracking: Supplier-specific delivery timeframes for planning
- Term Agreement Integration: Link catalog entries to contract pricing agreements
- UOM Conversion: Manage different units of measure between suppliers and inventory
Key Benefits
- Accurate Ordering: Eliminates part number confusion with supplier-specific mappings
- Competitive Pricing: Track multiple supplier prices for cost optimization
- Automated Integration: Seamless population of purchase order data
- Lead Time Planning: Accurate delivery predictions for inventory planning
- Contract Management: Integration with term agreements for contract pricing
Setting Up the Supplier Catalog
Prerequisites
Before configuring the supplier catalog, ensure you have:
- Item Master List: All inventory items must be created first
- Supplier List: Vendors must be established in the system
- UOM Configuration: Units of measure properly configured for conversions
Adding Catalog Entries
- Navigate to Orders → Purchasing → Suppliers’ Catalog
- Click “Add New Supplier Catalog Entry”
- Configure the catalog entry:
- Supplier: Select the vendor from the dropdown
- Item ID: Choose the internal inventory item using the lookup
- Supplier Item: Enter the supplier’s part number for this item
- Package: Select the packaging type (box, carton, each, etc.)
- UOM: Choose the unit of measure for purchasing from this supplier
- Unit Price: Enter the current price per unit
- Lead Days: Specify typical delivery time in days
Price Level Configuration
When vendor price levels are enabled (Admin Option 510):
- Base Price: Standard pricing tier for regular orders
- L1-L5 Pricing: Volume discount tiers based on quantity breaks
- Quantity Breaks: Configure minimum quantities for each pricing level
- Effective Dates: Set validity periods for pricing tiers
Managing Supplier Information
Supplier-Specific Settings
For each supplier catalog entry, configure:
Pricing Information:
- Unit Cost: Current price per purchasing unit
- Price Levels: Multiple tiers for quantity-based pricing
- Currency: Support for international supplier currencies
- Effective Dates: Validity periods for pricing information
Operational Parameters:
- Lead Time: Expected delivery time in days
- Minimum Order: Supplier’s minimum order quantities
- Order Multiples: Required ordering increments
- Packaging: Standard package sizes and configurations
Contact Information:
- Sales Contact: Primary supplier contact for orders
- Technical Contact: Support contact for product questions
- Emergency Contact: After-hours or urgent order contact
Term Agreement Integration
Link catalog entries to term agreements for contract management:
- Contract Selection: Choose applicable term agreement from dropdown
- Contract Pricing: Override standard pricing with contract rates
- Expiration Tracking: System alerts when contracts approach expiration
- Renewal Management: Track contract renewal dates and requirements
Using the Supplier Catalog
Purchase Order Integration
When creating purchase orders, the supplier catalog provides:
Automatic Population:
- Supplier Part Numbers: Auto-fills when supplier is selected
- Current Pricing: Applies catalog pricing to order lines
- Lead Time Calculations: Estimates delivery dates based on catalog data
- UOM Conversion: Handles purchasing unit conversions automatically
Smart Suggestions:
- Preferred Suppliers: Highlights primary suppliers for each item
- Best Pricing: Identifies most competitive pricing options
- Available Stock: Integration with supplier inventory levels (if supported)
Pricing Management
Multi-Supplier Comparison:
- View all suppliers for any item in a single interface
- Compare pricing across suppliers for competitive analysis
- Track price history and trends over time
- Identify opportunities for cost savings and supplier negotiations
Price Level Selection:
- Choose appropriate pricing tier based on order quantities
- Automatic tier calculation based on quantity breaks
- Override pricing when special arrangements exist
- Track actual vs. catalog pricing variance
Advanced Features
Bulk Import and Export
Import Functionality:
- Bulk Upload: Import large catalogs via CSV/Excel files
- Data Validation: Automatic validation of item and supplier references
- Price Updates: Batch update pricing across multiple entries
- Error Reporting: Detailed feedback on import issues and corrections
Export Capabilities:
- Catalog Reporting: Export complete catalogs for analysis
- Price Lists: Generate supplier-specific price lists
- Comparison Reports: Export multi-supplier comparisons
- Audit Trails: Export catalog change history for compliance
Best Practices
- Regular Updates: Keep catalog entries current with market pricing
- Multiple Suppliers: Maintain at least two suppliers per critical item
- Complete Data: Ensure all fields are populated for accurate automation
- Review Cycles: Establish regular review schedules for pricing validation
- Contract Integration: Link all contract items to appropriate term agreements
- Lead Time Accuracy: Maintain accurate lead times for planning effectiveness
Troubleshooting
Common Issues
- Missing Pricing: Verify catalog entries exist for supplier/item combinations
- Incorrect Part Numbers: Check supplier part number mapping accuracy
- UOM Conversion Errors: Validate unit of measure configurations
- Expired Agreements: Review and update expired term agreements
- Import Failures: Validate import file format and data integrity
On this page