Purchase Open Qty

This module adds visibility on pending quantities in the Purchases app. On each purchase order line it computes a "Qty to Receive" value: for storable products it sums the quantities of stock moves that are not yet cancelled or done, and for service products it uses the ordered quantity minus the received quantity. This value is stored and can be shown as an optional column in the purchase order lines list.

On the purchase order itself, two computed values are added: "Qty to Receive" and "Qty to Bill", each being the sum of the corresponding values on its lines. Two boolean flags, "Pending Qty to Receive" and "Pending Qty to Bill", indicate whether there is anything left to receive or to bill. These fields appear as optional columns in the order lines section of the purchase order form, but only when the order is in Purchase or Done state.

Users can filter purchase orders and purchase order lines using dedicated filters: "Pending Qty to Bill" and "Pending Qty to Receive". These filters are available in the search views of both purchase orders and purchase order lines, making it easy to list only the documents that still have work pending.

The module also includes an installation hook that pre-creates and pre-fills the new quantity columns on existing purchase order lines, so the data is ready as soon as the module is installed.