Hi,
How, if possible, can I set a rule that depending of a value in one specific column affects another column?
This topic has been closed for comments
You can’t set this directly by referencing another column, but with a bit of clever arrangement of the columns and use of multiple formats on the columns, you can approximate a version that gets close. Of course this works only in IEE and not Aurena which takes a big step backwards in this function.
Use Case:
Carl has a need to understand the final condition of each order line and the requirements for that order line to be complete prior to transferring the order to Shipping. This involves a bit of determining the key fields, placing them in the correct order left to right and constructing a truth table of color combinations that tell the full picture at a glance.
| Field | Condition | Comments |
| Sales Part No | See Sales Part No below | Highlights CP lines that need a CP Signoff by selecting Part Numbers beginning with “CP” or “S” (Older Custom Products)
[Text Color changed for readability on background color] |
| Supply Code | See Supply Code below | “Non Inventory” is the over-ride to make the entire row grey – know there is no part to be supplied for this line
“Invent Order”, “Shop Order”, and “Int Purch Trans” must have green “Picked” Status (see below) prior to shipping
“Not Decided” is a bad condition as it means something was over-looked earlier in the process, or very early in this order |
| Status | See Status below | “Canceled” applied to entire line, red text makes it clear it is not required “Released” needs to be processed “Reserved” means the part should be available or very nearly ready “Picked” is good to go |
| Proj Mgr | See Proj Mgr below | Orders that are CPs have a Proj Mgr responsible for generating the CP Signoff.
Highlights field with same formatting as CP part numbers if the field is not NULL.
[Tip in a Tip: ‘ ‘ (single quote space single quote is how Oracle reads NULL, so >’ ‘ is greater than NULL or just not NULL)] |
The Truth Table for some of the line conditions then looks like this – the key being the Status column needs to be Green (Picked) to know it is complete if the Supply Code is Orange/Green/Blue:
| Supply Code | Status | Color Condition |
| Non Inventory | Released | All grey override |
| Invent Order | Released | Orange/Orange |
| Shop Order | Picked | Green/Green |
| Int Purch Trans | Reserved | Blue/Blue |
| Not Decided | Released | Red/Yellow |
| <Any> | Cancelled | Red on grey override |
See the order lines view with everything turned on
Thanks for your swift reply, will try this out.
Regards,
Johan
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.