Component Group Price Table¶

There is a menu option in Pricing called ‘Component Group Price Table’. This holds ‘Product Group’, ‘Price Band’ (fabric group) and Price.

Order Processing > Orders > Components

We have a customer that sells mostly box blinds but as components.
When they enter a component detail line, they want to choose from several different possible selling prices.
There will be lots of products that fall into the same product group, so we need to be able to group the prices.
As we do not use ‘Fabric Group’ in the component detail entry, let’s use this field, along with ‘Product Group’.

Work Done

There is a field in Parameters called ‘Use Component Price Band’.

If ‘Use Component Price Band’ = true, in the component order detail entry, there is now a field choice for ‘Price Band’.
This will lookup the ‘Fabric Group’ table and store the result in fabricgroup_id in the OrderDetail table.
Once the price band has been selected (and the ‘Product Group’ found from the stock/fabric table), the program searches the component group price band table to find a price.
If either the product description product code or price band is changed, the price lookup is re-done.
The ‘Price Band’ defaults to the fabric group set up in the stock record.

There may be a lot of records in the component group price band table, so we have created an import routine.
There is a new option in ‘Import From Excel’ called ‘Component Group Price Table’, and it has the following layout.

The price now displays properly to 2 decimal places.