Tracking Minority/Women Owned Status in Vendor Records

Matt Terrill

Has anyone figured out a way to track and report on vendor status as minority or women-owned business in FE NXT?

It looks to me like this would have to be a custom field with a drop down of several options (Women-owned, Black-owned, Latinx-owned, Other POC-owned, etc).

As our organization seeks to engage in meaningful DEAI work and measure progress, I am eager to find a way to reliably track and report this information.


Would welcome suggestions or any solutions others have found.

Michael Sullivan

Hey there Matt! I'm glad that you're asking - this has been a little passion project of mine for years. When I worked in training in FENXT, custom fields for Minority Owned, Women Owned, or Locally Owned businesses were the number one example of how and why to use custom fields (attributes in FE7). You can use those custom fields in reports in order to evaluate your impact in that regard.


Other common custom fields that FENXT users apply to Vendor records include:

• Solicit=Yes/No
• Approved Vendor=Yes/No (if there's a need for an approved vendor list)
• W2 on File=Yes/No

Mary Aquino

Love all of Michael's examples - also, it's awesome that you can FILTER your vendor list by a Custom field. This is super helpful if you're looking in Financial Edge NXT for only women owned, or minority owned vendors. 


Little trick you could also do - create the Custom field/attribute and then in database view, create queries using those Custom fields - then you can use the queries on some of the Payables reports to filter. I tried it on the AP Account Distribution report and the Open Invoice report and while my little sample database looks pretty sad, you probably will get some cool results.


Hope these tips help you!

Matt Terrill

Thank you Mary & Michael; this is a great start!

I think I have a handle on how to set up the custom field. I included screenshots in case helpful for others. Instructions are also available in the help panel - search "custom fields".

But I'd be curious for some specific examples or screenshots of queries to ensure our reports function as intended.

If you're willing and able to share any of that Mary, I'd find it helpful & hopefully so would others.


Thanks again to you both for taking time to respond. Stay safe & healthy!




 

Mary Aquino

Hey Matt - I'll set some stuff up...my sample has *nothing* so I've gotta do some pre-work but I'll post the Query criteria you might be able to use. 

Mary Aquino

Matt, hope this is helpful - feel free to reach out if you need clarification on any of the steps - I admit, I did this quickly so you had a resource.