Prices not updating in cart for Lookup variables

[brian_]

I think this may be a bug but wanted to check with other community members to see if anyone else is experiencing this. We're using Lookup varibles (both Select and Multiple Choice) and have defined prices for the options. The prices do display properly inline with the option, and when you select the option, the displays properly update on other choices to reflect the current selection.

Option 1

Option 2 [add $100]

-selection Option 2-

Option 1 [subtract $100]

Option 2

This part works great, however the cart price never updates. Using a non-Lookup variant of the variables (standard Select Box or Multiple Choice) the behavior is as expected. Display values update AND the price is updated in the cart.

Any ideas?

This blog post utilizes Lookup Select Box with pricing implications and it appears to work properly

Mini-Lab: Service Catalog - Building a Custom Choice Table

We are on Geneva Patch 7

[brian_ · Accepted solution]

A coworker figured out the root cause. This is not at all a bug and was a matter of our configuration.

The value of the lookup field should be set to sys_id or a unique value. I was setting it to a field in the table that was not necessarily unique. After changing it to be sys_id, everything works as expected.