Import data (Data Management) – set lookup field to empty/null

0
41
Forum Post: Change the Filter On option on Opportunity Associated View for Account form


Hi,

After many google searches, I am unable to find an answer to what I suspect is a simple question.

As part of our Business Central integration, I need to delete all pricelists in CRM.

To do this, I need to update all existing orders to have an empty pricelist.

I can do this manually – however there are 24,000 orders in the system.

SO I exported all orders (including pricelist column) to excel.

Changed all pricelist columns to have no value and did the import.

All orders still had a pricelist 🙁

Can anyone advise how to update the pricelist to be empty via data import?

I could do it via flow but…

I would have to write it

I suspect it will take a looooong time.

Stan



Source link

Leave a reply

Please enter your comment!
Please enter your name here