Apparently during original data entry no one entered the Country in the Ship To table. I have created a Updatable BAQ but when I update a record to USA for the country I get the following error.
Country references Invalid Value.
Also, I have 5494 records to update. Is there anyway to update them all at once instead of one at a time. I am on the cloud so I can’t do it on the back end.
Even without DMT, you can create an updateable dashboard and use either the uptake from Excel function or Paste Update function to mass-update the records.
