Hi @Mike I have a follow up question to your post. 

• Is your ‘sold to’ field actually your CRMs Lead/Contact ID field? It sounds like this value you are using as your lead/contact ID has null values and may be why it’s breaking. Is there another value also called Lead ID or Contact ID? On any import you do scheduled or manual you need Lead/Contact ID. I am wondering if that is why it’s breaking.

The report does pull in the Contact ID, but it finds that contact from the opportunity record and the “Sold To” field. Issue is that some of the “sold To” fields are blank if that record has been marked inactive. We are education the sellers to re-populate this field on all their deals if it is blank, but if 1 slips by and it happens to be the first record at the top of the report, them the import fails.

@Mike can you add a filter to the report where if that value is blank you exclude it from this report? Then you may want a different CRM report for only the blank “Sold To” contacts so that the reps can go through those contacts separately and then it wont break or delay your import. Just an idea. Not sure how that would work for your set up/process. 

I think we came to the same conclusion at the same time! Sometimes putting problem on the page leads to the solution. Great thinking!

hah! Perfect! 

Love seeing this type of exchange and sharing of challenges and solutioning by the Champions.  This is exactly why we launched it.  I hope to see more members doing the same.  Thank you @RebeccaHeyse and @Mike for starting us off.

Day 1 and @RebeccaHeyse is already hard at work in the Champions Hub!!