Update Matrix Items: Select Fields

@lawsont , yes, you can exclude those fields from update. For that, go to the Template Item, UPDATE SETTINGS tab, and add these 2 fields to the first pane like this:

This way, Default Price and MSRP price won’t be overwritten on the matrix items when you do an update.

@Yuri Karpenko Is there a way to update that setting globally? I know, in theory, we can do an import scenario, but we have so many items that every time I do an import scenario, we get our account throttled by Acumatica. So, trying to avoid that! 

@Yuri Karpenko Okay, thanks. That is a big bummer because I assume that every time we create a new Template Item, we’ll have to set that or else risk selling items for free. 

@Yuri Karpenko While I have ya, I’m trying to create an Import Scenario, but getting an error. See below. Do you see where I went wrong? Thanks 

@lawsont , in addition to Field Name field, you also need Table Name. Which can be one of these:

Make sure that Table Name goes before Field Name.

@Yuri Karpenko  So, this is what I’m mapping into Table Name. Is that right?

@lawsont , yes.

@Yuri Karpenko  Okay, that’s what I did and it resulted in that error. I’ve been trying to update the Import Scenario in different ways, but the following yielded the same error: 

 

There is a customization package out here on the community that ACU developed that allows you to add stock items to the template item (by making the template ID field available).  I have seen companies use this function to add new stock items to the template ID without using the “update matrix” button which can cause the issues you’re referring to.  Probably not a GREAT workaround but it does prohibit those mass updates.

The lack of a global default makes this functionality unusable for our organization as well, unfortunately! 
Just pinging in here to say I threw up a community Idea for this, so please give it an upvote if anyone finding this thread is also having issues with this functionality! Thanks!
 

There is the UPDATE SETTINGS tab which allows you to determine which fields attributes are not updated during the UPDATE MATRIX ITEMS button push: 

Global settings - perhaps I was unclear:
There is no way to default these across all items or a group of items