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

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

S_McCray — Thu, 10 Mar 2022 13:22:48 GMT

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.

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

ersureshbe — Thu, 10 Mar 2022 13:40:21 GMT

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,

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

S_McCray — Thu, 10 Mar 2022 20:03:21 GMT

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.