Appointments

Overview

Inventory → Inventory → Appointments

The Appointments module in Inventory Pro provides a streamlined way to track and manage expected inventory deliveries without requiring formal purchase orders. This is essential for managing consignment inventory, supplier deliveries, returns, and informal stock arrangements where traditional PO processes may not be necessary or appropriate.

Key Features

• Supplier Management: Track which supplier will deliver the inventory
• Warehouse Assignment: Specify destination warehouse for incoming stock
• Line Item Control: Manage specific items, quantities, and pricing
• Receiving Integration: Direct receiving against appointment records
• Status Tracking: Monitor appointment progress from creation to completion
• Alert System: Automated notifications for appointment events

Key Benefits

1. Simplified Tracking: Monitor expected deliveries without PO overhead
2. Accurate Planning: Better warehouse capacity and labor planning
3. Cost Control: Track costs even for informal arrangements
4. Compliance: Maintain audit trail for all incoming inventory
5. Efficiency: Streamlined receiving process with pre-populated data

Creating and Managing Appointments

Creating a New Appointment

1. Navigate to Inventory → Inventory → Appointments
2. Click the “Create New Appointment” button
3. Fill in the appointment header information:
   • Supplier: Select the vendor delivering the stock
   • Carrier: Choose the shipping carrier (optional)
   • Warehouse: Select destination warehouse
   • Expected Date: Set anticipated delivery date
   • Reference Numbers: Add any internal or supplier reference numbers

Adding Line Items

1. After creating the appointment header, click on the “Line Items” tab
2. Add items to the appointment:
   • Click the three dots icon to select items
   • Enter Units quantity expected to be received
   • The Packages field will auto-calculate based on unit of measure
   • Set Unit Price for cost tracking (optional)
   • Add Serial Numbers or Expiration Dates if required

Appointment Status Management

Appointments can be in several states:

• Outstanding: Active appointments awaiting receipt
• Current: Appointments ready for receiving
• Received: Completed appointments with all items received
• Canceled: Appointments that were canceled before completion

Receiving Against Appointments

Standard Receiving Process

1. From the appointment line items page, click “Receive”

2. The system will:

   • Validate warehouse assignment
   • Check for outstanding quantities
   • Open the receiving interface
   • Pre-populate items from the appointment

3. Use the receiving screen to:

   • Scan barcodes or manually enter items
   • Adjust quantities as needed
   • Assign locations and serial numbers
   • Complete the receiving transaction

Partial and Over-Receiving

• Partial Receiving: System tracks remaining quantities and maintains appointment open status
• Over-Receiving: System allows receiving more than appointed quantities with warnings
• Backorder Generation: Configurable option to automatically create backorders for unfinished appointments

Security and Permissions

The appointments system integrates with Inventory Pro’s comprehensive security framework:

• Create/Modify Appointment: Control who can create and edit appointments
• Maintain Appointment Lines: Restrict line item management
• Positive Adjustment (Receiving): Control receiving permissions
• Preview Appointment: Manage access to appointment reports

Integration Points

Related Modules

• Receiving: Direct integration with inventory receiving processes
• Inventory: Real-time inventory updates upon receipt
• Suppliers: Link with vendor management system
• Jobs: Optional integration for project-based tracking
• Alerts: Automated notifications for appointment events

Workflow Integration

• Links to purchase order processes when formal POs are needed
• Integration with work order systems for production materials
• Connection to shipping systems for return processing

Status Filters and Views

Available Filters

• All Appointments: Show all appointment records
• Outstanding Appointments: Active appointments not yet completed
• Received Appointments: Completed appointments
• Canceled Appointments: Appointments that were canceled

Search and Navigation

• Search by Appointment ID using the search functionality
• Filter by Supplier, Warehouse, or Job
• Use date ranges to find appointments within specific timeframes

Advanced Features

Grid System Integration

The appointments module leverages Inventory Pro’s advanced grid system (IPOLGridF.dll) to provide sophisticated line item management:

Grid Functionality:

• Real-time Validation: Automatic validation of part numbers, quantities, and pricing during data entry
• Smart Calculations: Automatic package calculations based on units and unit of measure
• Cost Integration: Automatic cost updates from part master when unit price is zero or part changes
• Line Numbering: Automatic line number assignment for new entries
• Audit Tracking: Automatic timestamp and user tracking for all changes

Data Validation Features:

• Part Verification: Validates part existence and checks for discontinued items
• Quantity Controls: Ensures positive quantities and handles zero quantity scenarios
• Price Management: Applies part costs automatically and preserves manual price entries
• Package Calculations: Computes package quantities based on part unit of measure

Grid Operations:

• Batch Processing: Save multiple line changes in a single transaction
• Error Handling: Comprehensive validation with specific error messages
• Transaction Safety: Rollback capabilities for failed operations
• Performance Optimization: Efficient data loading and processing

Integration with Other Modules

• Job Tracking: Link appointments to specific jobs for cost allocation
• Alert System: Automated notifications for appointment events:
  • Receive: When items are received
  • Complete: When appointment is fully received
  • Partial: When partial quantities are received
  • Backorder: When backorders are generated

Configuration Options

System administrators can configure:

• Auto-complete behavior: Whether to auto-complete appointments when fully received
• Backorder generation: Automatic creation of backorders for partial receipts
• Cost update behavior: Whether to update part costs upon receipt
• Redirect behavior: Whether to return to appointment list after receiving

Reports and Documentation

• Preview Function: Generate printable appointment documents
• Image/PDF Attachments: Attach supporting documentation
• Audit Trail: Track all changes and modifications with user and timestamp information

Reporting and Analytics

• Outstanding appointments by supplier
• Receiving efficiency metrics
• Cost variance tracking
• Delivery performance analysis

Technical Implementation

Grid Class Architecture

The appointments line items are managed by the Appointments.cs grid class, which provides:

Core Methods:

• Save(): Processes all line item changes with transaction management
• Validate(): Validates individual rows with comprehensive business rules
• CanProcess(): Initializes grid and validates processing capabilities

Validation Rules:

• Quantity Validation: Ensures quantities are greater than zero
• Part Validation: Verifies part existence and discontinuation status
• Cost Application: Applies part cost when unit price is zero or part changes
• Package Calculation: Computes packages based on quantity and units per pack
• Record Management: Handles line numbering, references, and audit fields

Error Handling:

• Discontinued part detection with specific error messages
• Invalid part number validation with detailed feedback
• Transaction rollback on validation failures
• Comprehensive error logging and user notification

Database Integration

Key Tables:

• Appointments: Header information (supplier, warehouse, dates)
• AppointmentsLines: Line item details (parts, quantities, pricing)
• AppointmentsLines_A1: Archived line items for completed appointments
• zwGridFormats: Grid configuration and field definitions

Grid Views:

• Appointment1: Editable view for active appointments
• Appointment2: Read-only view for completed/archived appointments

Testing Framework

Comprehensive unit tests ensure reliability:

• Quantity validation tests for zero, negative, and positive values
• Part validation tests for valid, invalid, and discontinued parts
• Unit price tests for cost application and preservation scenarios
• Package calculation tests for various quantity scenarios
• New record tests for proper field initialization
• Audit field tests for timestamp and user tracking
• Integration tests for complete appointment validation workflows

Best Practices

1. Regular Updates: Keep appointment information current with suppliers
2. Accurate Quantities: Enter precise expected quantities to facilitate receiving
3. Warehouse Assignment: Always assign specific warehouses before receiving
4. Documentation: Attach supporting documents when available
5. Timely Processing: Process receipts promptly to maintain inventory accuracy

Troubleshooting

Common Issues

• Cannot Receive: Check warehouse assignment and user permissions
• Missing Items: Verify items exist in the system and are not discontinued
• Permission Errors: Ensure user has appropriate security permissions
• Archived Appointments: Completed appointments are archived and cannot be modified