Sale Stock Last Date

This module adds a "Last delivery date" to every sale order line. It is filled in automatically from the stock moves linked to the line: only outgoing moves that are done and not scrapped are considered, and the most recent one wins. The value is stored, so it stays available for searching and reporting.

Where you see it: - On the sale order form, inside the order lines: the date appears in the line pop-up next to the customer lead time, and as an optional column in the lines list. - In the Sales Analysis report (sale.report), where the date is available as a column and can be used for grouping.

Business rules and behaviours: - The date is computed automatically; users do not type it. - It only reflects deliveries that were actually completed (done outgoing moves), so cancelled, scrapped or incoming moves are ignored. - If several deliveries exist for a line, the latest date is kept.

In the Sales Analysis search panel you get a "Sent yesterday" filter that shows lines delivered between yesterday and today, and a "Last Delivery Date" grouping option that groups results by month.

It touches the sale order line and the sales analysis report, and relies on the sale_stock module for the delivery information.