cancel
Showing results for 
Search instead for 
Did you mean: 

Duns number update in Sourcing

Former Member
0 Kudos

Hi,

We have around 1500 vendors ( Supplier) in CLM system version 9.0.

Few are having Duns number around 10% remaining are not having empty in Duns number

field.

However in ECC system now the Duns number are updated for around 80% of the vendors.

Now how do i make the changes in CLM system. ie updating the duns number for the suppliers in CLM.

It will be great if step by step details.

Thanks in advance.
With Regards
Divaka V

Accepted Solutions (1)

Accepted Solutions (1)

kushagra_agrawal
Active Participant
0 Kudos

Hi Divakar,

Please prepare the workbook in which maintain below 2 fields:

EXTERNAL_ID,DUNS

Where EXTERNAL_ID is the external id of the supplier and DUNS is the value which you want to update.

Prepare the workbook and go to Setup-->System Administration-->Import Data-->New

and the upload the workbook which you have prepared. in the next screen select the Object Type as supplier and click next.

Wait till the import finishes. DUNS of all the supplier will be updated in the SCLM System.

Hope it helps. If you want I can mail you the sample workbook.

Let me know if you have an doubt.

Regards,

Kushagra A

Former Member
0 Kudos

Hi Kushagra A,

Thanks for the support. It worked fine.

With Regards

Divakar V

Answers (0)