MIS Builder Total Committed Purchase

This module creates a new read-only data source called mis.total.committed.purchase that MIS Builder can use when building management reports. It gathers purchase order lines from orders that are not in draft or cancelled state, so confirmed and received purchases are counted as commitments.

Each line shows the date, a name, the related purchase order, the account, the analytic account (only visible to users with analytic accounting rights), the product, and debit and credit amounts. The account is determined from the product's account first, then the product category, then parent categories, and finally the company default; if nothing is found, it falls back to zero.

Users can see this data in a simple list view showing date, name, purchase order, account, analytic account, product, debit and credit. All users can read the data, but nobody can create, edit or delete records because it is a database view refreshed automatically.

It depends on the MIS Builder and Purchase apps and does not add its own menu; the data becomes available as a source inside MIS Builder report definitions.