Sales Support System – Fastest Shipping Time Estimation
OpenDesign and implement a Sales Support System within iDempiere ERP that helps the sales team estimate the fastest possible shipping date after receiving a customer order.
## Scope
### Order Analysis Module
– Upon receiving a sales order, automatically analyze each order line’s product, requested quantity, and delivery requirements.
### Production Check
– Query the Manufacturing (Production) module for:
– Current production schedules and available capacity
– Work-in-progress orders for the same product
– Estimated production lead time if a new production order is needed
– BOM component availability
### Inventory Check
– Query the Warehouse (Storage) module for:
– Current on-hand stock across all warehouses
– Reserved quantities for existing orders
– Available-to-promise (ATP) quantities
– Incoming expected receipts (purchase orders in transit)
### Shipping Time Recommendation
– Combine Production and Storage data to generate a recommended earliest shipping date
– Show a breakdown: “Available from stock: X units by Date A” + “Available from production: Y units by Date B”
– Support partial shipment suggestions if full quantity isn’t immediately available
## Technical Requirements
– Implement as an iDempiere plugin (OSGi bundle)
– Callout or Process attached to the Sales Order window
– REST API endpoint for external system integration
– Dashboard widget showing pending orders with estimated shipping dates
## Deliverables
– OSGi plugin source code with unit tests
– Technical documentation
– User guide (English + Traditional Chinese)