Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Importing Vendors through Transaction Import - issues with address field

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

We are importing vendors from another software.   Some of the vendors that have been imported have 2 address lines.   We have discovered that if the address has been changed and we reimport the vendor that it will not override the 2nd address line or delete the information in the 2nd address line.    

*This post is locked for comments

  • Suggested answer
    Ram Peru Profile Picture
    Ram Peru 2,830 on at
    RE: Importing Vendors through Transaction Import - issues with address field

    Hello Cathy T,

    You are changing existing value of the vendor. You need to include the Key identifier with Level.

    For Instance,

    You have to include the key identifier as "Change" with level "Vendor" to modify the existing values.

    Refer the below picture to create the csv file for changing the existing values.

    4405.vendor2.png

    If you want address2 to be updated with a blank, you have to use the Quote space Quote ( “  â€œ ).

    Refer below picture address1 & address2 fields highlighted in red color.

    Hope this will help you to solve your problem on Transaction Import.

    Thanks,

    Perumalsamy R

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,791 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans