Duplicate Names on the Core Company Table

[cnharris1]

Hello developers,

Quick question, is there a way to allow duplicate names on the core company table? 

The background information is that I manually uploaded several suppliers to our environment. Many suppliers have the same name but different supplier codes, which technically makes them unique. However, on the core_company table, the duplicate names are not showing up, it only shows one supplier and not all that have the same name. 

Is there a way around this on the core_company table?

Any help will be greatly appreciated!

Thanks in advance,

cnharris1

[Community Alums · Accepted solution]

Hi @cnharris1 ,

I have checked the same in PDI and it allows creating a duplicate entry on core_company table.

Would request you to try to create a manual entry with same name and validate.

I would also suspect that if you are using a transform maps to upload the data in core_company table then please take a look if you have a coalesce field set to true in name field.

If my response has resolved your query, please consider giving it a thumbs up ‌‌ and marking it as the correct answer‌‌!

Thanks & Regards,

Sanjay Kumar