Business Units are not displayed when opening the referenced field in a pm_project (Project) record.

[S_McCray]

When we are in a project, and we try to select a Business Unit record (on the Details tab) there are no results pulling up. We've validated there are records on the table, but not sure why they aren't showing up. Tried to go into the script include and understand why but I don't really see what could be causing it.

Might be a simple solution, but I am not quite sure. We have everything pretty much as OOB, the reference field and the Utils are unadjusted from their OOB states.

[ersureshbe · Accepted solution]

Hi,

Can you refer below screenshot and refer the 'Reference qual Condition' and check the table 'business_unit' is having the records with active state?

Regards,

Suresh,

[S_McCray]

Yeah we looked closer, and initially thought the reference qualifier we had there was oob but was not, and we found the issue. Pretty simple now that we see it..

Reference Qualifier was resulting in making the Department in the Business Unit match the Department field on the Project, if those two did not match, the business unit didn't show up in the list.