Managing Companies and Vendors in ServiceNow

[GChanner]

We realized our company table needs to be sanitized and I would like your help in doing so. We want to know how other customers handles companies and vendors.

Issue: We have instances where a company can be both a company and a vendor and where a company is not the vendor.

Example for us:

Carahsoft is the company and ServiceNow is the vendor however in our company table we have ServiceNow listed as the company and the vendor attribute checked which identifies ServiceNow as both a company and a vendor. Not Carahsoft. We are now finding this is incorrect.

For Applications Portfolio Manager we want to pull vendors however we have other forms which will need to pull companies.

On the core company table, we are thinking of the following:

In addition to the Vendor flag add a relationship field.

Add a new reference field:

Field Name: u_provides_vendor
Table: core_company
Reference: core_company

Example:

Company	Vendor	Provides Vendor
Carahsoft	✔	ServiceNow
ServiceNow	✔	—
CDW	✔	Microsoft

This means both Carahsoft and ServiceNow will be listed in the core company table but flagged differently.

Any feedback or insight will be helpful

Thanks

Garfield Channer

[pavani_paluri]

Hi @GChanner ,

Keep every organization in the same Company table.
Use a Vendor flag to mark which ones are actual vendors.
Add a new field (like `Provides Vendor`) to show the link between a reseller and the vendor they represent.

Carahsoft is a company, but it points to ServiceNow as the vendor.
ServiceNow is flagged as a vendor directly.
Same for CDW → Microsoft.

This way Applications Portfolio Manager can pull only vendors (those flagged as vendors).
Other forms (procurement, contracts, etc.) can pull companies (resellers, distributors).
You avoid confusion because both entities are stored, but their roles are clear.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P