Wood Codes¶
Wood Sizes
Also for the customers that manufacture the wood blinds and so we have set up the stock records with W1 – W6 style codes.
W1 = 25mm slat
W2 = 50mm slat
W3 = 25mm bottom bar
W4 = 50mm bottom bar
W5 = 25mm valance
W6 = 50mm valance
The only problem is that they use the same valances for 25mm and 50mm blinds.
At the moment if we enter W1xx As a fabric, it will select W1xxyy as the slat, W3xxyy as the valance and W5xxyy as the valance.
If W2xx is entered, then it will find W2xxyy, W4xxyy and W6xxyy.
This is hardcoded into the system at the moment.
We need to get W2xx to find W5xxyy instead of W6xxyy.
Therefore we have created a new table in System Tables called ‘Wood Codes’.
It has fields for blind type, slat code, bottom bar code, valance code.
It could have entries like this:
25mm Wood, W1, W3, W5
50mm Wood, W2, W4, W5
When doing the ‘Wood slat’ calculator, if there is a record for the blind type in this table, it will select the W? codes.
Order Processing > Orders > Wood Default Options
Previously, the default Slat Valance and Bottom Bar options that are set for wooden Venetians via the Wood Sizes system table were not editable.
If you tried and change an option, it would automatically reset itself back to the default option.
However, it is possible for a customer to want their valance or bottom bar to be a different colour from the rest of the blind.
It is now possible to change the option so it will not be reset to the default if another option is changed.
Wood Codes
It is now possible to specify alternative Bottom Bar and Valance codes for wood Venetians.
There are two new columns in the Wood Codes system table for ‘Alternative Bottom Bar Code’ and ‘Alternative Valance Code’.
In the example below, we have W4 as the bottom bar code and W6 as the valance code. We could have W16 as the alternative bottom bar code and W18 as the alternative valance code.
When an order for a wood blind is processed, the program will first try and match the original Bottom Bar (W4) code and Valance code (W6) with the colour to select the valance and bottom bar stock item.
However, if no stock code matches these codes, then it will attempt to use the alternative Bottom Bar code (W16) and alternative Valance Code (W18) to match stock items with the colour.
The exact logic is as follows.
1. The system first looks into the ‘Wood Codes’ system table for the blind type selected and gets a part of the stock code from ‘Slat Code’, ‘Bottom Bar’ or ‘Valance Code’ fields depending on what option is found.
2. If nothing is found anything in (1), the program analyses the first part of the fabric/colour code chosen in the order detail. This is hardcoded (W1 – W9) but is represented like this.
Two (or three) first characters in Fabric/Color Code selected Slat Bottom Bar Valance
W10 W10 W11 W12
W1 W1 W3 W5
W2 W2 W4 W6
W7 W7 W8 W9
3. If something is found in (1) or (2) then the program looks into the ‘Wood Sizes’ system table to get another part of the searched stock item that is held in the ‘Slat Code’, ‘Valance Code’ and ‘Bottom Bar’ fields accordingly.
It tries to find a record with the nearest width and it forms a new stock item code.
Then the program checks a stock item by the stock code that was formed and checks if ‘Stock In Hand’ value > 0 (but only if the ‘Use Substitution’ is switched on for the blind type).
If this condition is false, i.e. we didn’t find a stock item at all or ‘Stock In Hand’ value less or equal to 0 (for ‘Use Substitution’ blind types only), the program gets the next record by width from the ‘Wood Sizes’ table.
If it does not find a stock item at all, it then looks in the relevant alternative field and tries to use that.
If there is not enough stock in hand for it and ‘Use Substitution’ is true, it should look at the next record by width.
4. If it doesn’t find the stock item is 3, the program finds a record with the nearest width in the ‘Wood Sizes’ table but ignores the ‘Stock In Hand’ value for ‘Use Substitution’ blinds as it was in (3).
The wood slat calculation has been made smarter so the required slat size is recalculated when not all stock options are available.
To do this, Blindata uses the existing Wood Sizes table to find the correct Slat, Valance or B/Bar Code.
If no existing slat, valance or bottom bar stock item exists for that code size for the Blind Type, then Blindata checks the next size up that is available.
For example, if a blind is ordered that needs a slat size 50, but only stock 80 size slats exist, then Blindata will check from 50 and select the 80 sizes as the slat and put this into the BOM.
Lastly, for slats, if the selected size is double or greater than the original size, then the number of slats required on the works order and in the BOM is divided by two and rounded up to the nearest whole slat.
This is because the larger slats can be cut down to make two smaller slats.
For example, if a blind is ordered that requires 12 ‘40’ size slats, but only ‘80’ size slats are available, then Blindata should assign 6 ‘80’ size slats on the works order and BOM.