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.