Install the module

When creating or editing a supplier in Odoo, the user can enable the "Use for proposal" option. This option allows the automatic generation of order proposals with this supplier.

Automatic Generation of Order Proposals

Order proposals are generated automatically every day, taking into account sales made in the last 24 hours.

Generation is based on past sales and forecasted sales for the coming days, calculated as follows:

Average Total Sales per Day: Calculated since the last order.

Forecasted Total Projected Sales: Estimated based on average sales per day and days remaining until next billing date

Manual Generation of Order Proposals

The user can choose to manually generate an order proposal by specifying a start date for sales.

The proposal is then based on the same criteria as those used for automatic generation, but allows more flexibility for manual adjustments.

Request the proposal from the button

Fill in the dates according to the form and generate

The command proposal generated

The order is in draft status and it remains for the user to validate

Why 22 as the order quantity?

On August 20, a manual generation of the order proposal was performed for the item Office Chair. Initially, the available stock was 50 units, and 45 units were sold between August 1 and 20, leaving a stock of 5 units. To anticipate future sales and avoid a stock shortage before the next billing scheduled for August 31, an analysis of the average daily sales was performed. Based on these sales and forecasting the needs until August 31, it was determined that an additional 22 units needed to be ordered. This quantity was calculated to ensure sufficient coverage of needs until the next billing, while maintaining an optimal stock.