We’d like to “Update Matrix Items” with the attribute values that we’ve added to our Template Items. We learned, after selling some items for free, that it also over-writes the default price with the 0.00 from the Template. Our Matrix Items represent sizes and are each their own price, so we’d like to NOT update the price when we use the “Update Matrix Items” function. Is this possible?
Update Matrix Items: Select Fields
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/aa4c102e-7297-4ce8-8b40-b336ad299dc3.png)
This way, Default Price and MSRP price won’t be overwritten on the matrix items when you do an update.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/656d1efe-d3af-48e3-80aa-2ca726778b87.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c031dbec-9480-49c0-8d17-e6f5d66fe7ae.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/5e68c532-8ff9-4f32-838e-f31e6b66498a.png)
Make sure that Table Name goes before Field Name.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/aab5b213-5174-4f60-b25c-ee747b319ba7.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/5c98d7c3-e625-42a0-8cb2-7f94fa6c20ab.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1c5f1e41-c24a-49d2-8ee8-8a26bf476934.png)
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!
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:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/2e69c3fa-d7fc-47c0-8d46-1026fad1679f.png)
Global settings - perhaps I was unclear:
There is no way to default these across all items or a group of items
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.