Skip to main content

Hi,

How, if possible, can I set a rule that depending of a value in one specific column affects another column? 

 

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)

 

pText 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

Terms & ConditionsCookie settings