...
Type - this field must be set to “F”inished, “S”emi-finished, “B”oth or left blank
Extend Mixed - If checked, this causes the substitution items to be grouped (as per the lens priority) with the first substitution line and any other line that has the “Mixed” flag set. Otherwise, the blanks selected for the substitution line will be placed together at the end of the blank selection list. If not selected, then the blanks that meet the substitution description are grouped in the midst of any items matching the specified primary selection, based in sequence of the substitution line that picked them.
Thick - this field must be set to either a valid thickness code or blank
...
*NOTE - if there are blank rows between entries, they will be removed when the entry is saved.
Examples
Example 1
Lens Style | Material | Pre-Treatment | Tint | Manufacturer | Customer | Addon1 | Addon2 | Addon3 |
|---|---|---|---|---|---|---|---|---|
SVA | C | CBS | ZZZ |
Lens Style | Material | Pre-Treatment | Tint | Manufacturer | Type | Extend | Thick | Addon1 | Addon2 | Addon3 |
|---|---|---|---|---|---|---|---|---|---|---|
SVA | C | CBS | F | ✓ | ||||||
SVA | C | CBF | F | ✓ | ARC | |||||
SVA | C | CBF | S | ✓ | ARC | |||||
SVA | C | SBF | ✓ | ARC |
For this example, we need an order with a single vision aspheric in polycarbonate 1.586, with a clear blue filter w/ shc. The order can have any tint, manufacturer, customer, and addons, and this primary selection would match.
If the order matches, it will search the secondary selections from top to bottom for blanks that are valid for the order.
Let’s say that the only blank you have in inventory with the correct base curves and whatnot match SVA;C;CBF;;S;;ARC
In addition to the blank being selected for the order, ARC will also be added to the addons.
Example 2
Lens Style | Material | Pre-Treatment | Tint | Manufacturer | Customer | Addon1 | Addon2 | Addon3 |
|---|---|---|---|---|---|---|---|---|
SV | C | SRC | ZZZ |
Lens Style | Material | Pre-Treatment | Tint | Manufacturer | Type | Extend | Thick | Addon1 | Addon2 | Addon3 |
|---|---|---|---|---|---|---|---|---|---|---|
SVA | C | CAT | SHO | ✓ | N | |||||
SVA | C | CAT | SHO | ✓ | ||||||
SVA | C | SRC | ✓ |
In this case, if an order is entered for SVA, C (assuming no other records exist to match the treatment or colour on the order), RxU would consider N thickness lenses from SHO first, and put those at the top of the selection list, followed by regular thickness SHO lenses, followed by other lenses from other vendors (in sequence by lens priority, base, diameter, etc).
Example 3
Lens Style | Material | Pre-Treatment | Tint | Manufacturer | Customer | Addon1 | Addon2 | Addon3 |
|---|---|---|---|---|---|---|---|---|
SV | C | MIR | SGY |
Lens Style | Material | Pre-Treatment | Tint | Manufacturer | Type | Extend | Thick | Addon1 | Addon2 | Addon3 |
|---|---|---|---|---|---|---|---|---|---|---|
SV | C | MIR | SGY | F | ||||||
SV | C | ARC | GY3 | F | MIR | |||||
SV | C | SRC | GY3 | F | MIR | ARC | ||||
SV | C | SRC | GY3 | S | MIR | ARC |
Specify order with SGY, a Silver Mirror coating on a Grey lens. If available, we would want to use a finished lens with the mirror coating already on it; if not available, we would like to use a finished lens with GY3 and AR already on it, and apply the mirror; if that is not available, we would want to use a finished scratch coated GY3 lens, and apply both AR and the mirror coating; if that isn’t available, a semi-finished scratch coated blank, and apply both AR and the mirror coating.