Active /inactive vendors and vendor descriptions

[markdesouza]

Greetings,

It looks like the company table lacks a few things for our purposes.  There is no description field to describe the vendor or service that they provide.  We note that there is a "note" field but i'm not sure if note is the same as description.  

Also, there is no active check box so that we can easily see which vendors are still active for us or not. 

We can add thse fields in but before we do, I wanted to see if anyone knew the reason SNOW did not include these fields?

[sachin_namjoshi]

you can use "Vendor" flag on company table to make vendor active or inactive.

Also, you can use "notes"  field to describe vendor.

Regards,

Sachin

[markdesouza]

Thanks, however there are non vendor companies in the company table.  using the vendor flag to tell whether the vendor is active or not doesn't seem to make a lot of sense for our use case.  Also, the Notes field is something I'd think we'd use to describe interactions with the vendor, etc, but it's not a description field.  I'm looking for a best practice around this.  

[sachin_namjoshi]

In this case, you will have to create custom active check box field on company table.Then, you need to use this active flag in your code( e.g ref qualifier, BR, script include etc) to filter out vendors from companies.

Also, you can configure journal field to see any updates to description of vendor.

Regards,

Sachin

[markdesouza · Accepted solution]

Thanks.  We have company records that are not vendors so that is not going to help.  I think the only way to resolve this is to:

Add a custom Active field

Change the label from "notes" to "description"