B1UP Validation - Conditionaly Change the Cell Color

Vaughn Bradley

I will simplify this for clarity. A customer has a Stock field on the Sales Order lines. It has a formatted search that calculates the current stock value/count. Depending on that value, they want to change the color of that cell. So if row/item one has stock of 10 or less, make that cell red, but if row/item two has stock of 100 or more, make it green, otherwise make it yellow. So far everything I do makes the whole column red, yellow or green. I need that column different (potentially) for every line.

Comments

3 comments

  • Comment author
    Vaughn Bradley

    So I guess the real question is can I set the backcolor at the row level or just the field level.

    0
  • Comment author
    Dave Gutman

    Hi Vaughn,  The online help for the Macro command: BackColor has a chart that shows which SAP UI elements are impacted by the command.  This command doesn't impact Matrix Rows and Matrix Cells, but it does impact Matrix Columns.

    0
  • Comment author
    Nadav Caridi

    I did something similar in a row level. But it wouldn't reset when I would bring up a new order. I ended up just doing a validation before the order is being submitted that shows up missing inventory lines. It also works better in my scenario since most of my orders are submitted via xml interfaces.
    Cheers

    0

Please sign in to leave a comment.