Product Supplierinfo Group

This module changes how vendor prices (the supplier price list on a product) are entered. Instead of typing the vendor, product name, variant and vendor product code on every single price line, those repetitive values are stored once on a new "supplierinfo group" record, and each price line simply points to it.

On the product form, the old vendor price lists are hidden and replaced by a new grouped list. Each group shows the vendor, variant, vendor product name, vendor product code, company and a computed summary of all minimum quantity/price deals. Inside a group you enter only the useful values: minimum quantity, price, start date, end date and delivery delay.

Business rules added by the code: - A group must be unique per product, variant, company and vendor; a second identical group is refused. - Two price lines with the same minimum quantity and the same date range inside one group are refused. - When a price line is created without a group, the system automatically finds or creates the matching group. - A multi-company rule limits groups to the companies the user is allowed to see.

Access is read-only for regular users and full for purchase managers. A scheduled or manual data migration fills the group column for existing price lines when the module is installed.