Sales Support System – Fastest Shipping Time Estimation

Open

Design 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)

Discussion

Leave a Reply

Your email address will not be published. Required fields are marked *

You Missed