[k_dunc]

Hi all,

In a Bill record Expenses and Items > Expenses subtab, I need to dynamically link a new Custom Column Field (Activity Code – as seen in the attached screenshot) to whatever the user selected as the Category.

The Category field is obviously the list of Expense Categories (Setup > Accounting > Expense Categories). This is unchanged. What I need to do, is dynamically link my Activity Code column to show a drop-down List/Record based on the user's Category selection. For example, if I have the following 2 Expense Categories and linked Activity Codes (an Other Custom Multiple Select Field):

Category
Activity Code

1
abc, def, xyz

2
xyz

If the user selects '2' from the Category, then the only option that should be displayed in my Activity Code drop-down should be 'xyz'. If the user was to select '1' from the Category, then the 3 Activity Codes should be displayed.

Any ideas how I can achieve this?

Thanks in advance,

Kirk.
This is a cached copy. Click here to see the original post.

[j.j]

use Multiple Dependent Dropdown Lists check suiteAnswer Id: 10093

[k_dunc]

Thanks for that j.j. That worked for me – sort of. I've done these before, but clearly NetSuite don't allow us to do this by using NetSuite's Expense Categories list. I've needed to make a copy of this in a Custom List, which isn't an ideal solution, but it appears to be the only way to do it for now.

Thanks again,

Kirk.

[Author]

Posts