Project

General

Profile

Box Blind Alt

We are now able to use different box blinds if the correct one is not available.

We can now to hold substitute stock items (box blind codes) against stock items.
There could be several substitutes held, so we need to hold an order of preference.

There is a further complication for box blinds, as there are restrictions on the blinds that can be used.
In the table below there are figures for how this will work.
As a result of choosing substitute box blinds, we need to make sure that the blind can be cut from the available box blind.
This means checking that the actual size of the blind is greater than the minimum width for that blind type and box width.
There is a new table in Administration > System Tables to hold blind type, box width and minimum width.
The table is called called Box Blind Minimum Width.

When the bill of material calculation is done for working out the box blind to use, the following additional functionality is used.

The first available box blind (stock code) should be chosen if stock in hand is available.
If there is no stock, the first substitute should be used.
We should then check the box blind minimum width table to see if the blind can be made.
If this is not available, the second substitute should be used etc.