Vendor duplicate check

[Former Member]

Hi,

I working on a report that checks for vendor duplicates.

Looking forward to your good ideas and/or code samples and take appropriate action on good/interesting answers.

For example

1) how would you check on duplicate names?

2) how to check the postcode field if there are no checks on the input format (e.g. ignore upper/lower case and spaces)?

3) which vendor master fields would indicate duplicate vendors (e.g. company registration number, VAT registration number)?

All ideas and examples are welcome.

Thanks,

Dennis

[Former Member]

Hi,

I working on a report that checks for vendor duplicates.

Looking forward to your good ideas and/or code samples and take appropriate action on good/interesting answers.

For example

1) how would you check on duplicate names?

2) how to check the postcode field if there are no checks on the input format (e.g. ignore upper/lower case and spaces)?

3) which vendor master fields would indicate duplicate vendors (e.g. company registration number, VAT registration number)?

All ideas and examples are welcome.

Thanks,

Dennis

[Former Member]

Personally I would use the VAT number as this is unique key for vendors.