RE: Item Validation based on Project
We have a list of Service Items that we use on transaction forms. Currently, when a transaction form is filled out all service items are available to be selected.
We would like these items to validate against the project selected on the transaction form so that only certain service items can be selected to be expensed to the project.
Project A has the following related items: Admin, Events, Outreach
Project B has the following related items: Admin, Marketing, Operations
Goal: User filling out an expense report for Project A would only have Admin, Events, & Outreach as options to select from in the list field after selecting Project A in the project field.
Do you have a suggestion as to how to accomplish this?
For custom fields, check this out: https://technologyblog.rsmus.com/netsuite/creating-dependent-drop-lists-netsuite/
For standard fields (which I think is what you’re talking about here), I think you’d have to do some scripting, ideally creating a custom record to manage the dependencies.