Solved

Remove Matrix Item from Template

  • 4 December 2023
  • 8 replies
  • 90 views

When I got into the template item for a product we sell and try to delete one of the matrix items that we no longer offer I am getting an error. “Referenced in multiple tables”. The trace points to a number of locations including old sales orders and GL accounts entries. 

Is there a way to keep the references in the tables but remove from the matrix? (we use matrix to push to a number of ecommerce solutions our current work around works with some and not all) 

icon

Best answer by manikantad18 4 December 2023, 19:28

View original

8 replies

Userlevel 7
Badge +12

Hi @Aspence26 

Are you able to remove the Template ID from the stock Item screen?

 

It is not an element/entry I can edit in the stock item screen. Could this be a user access issue? 

Userlevel 7
Badge +12

Is this package Published in Your assistance?

Which version Acumatica your are using.

2022 R1. It is published. In the stock item screen the template ID field is a link to the template items screen and not a field I can edit. 

Userlevel 7
Badge +12

Hi @Aspence26 

One more check, Do you see any Option in Item class “ Allow edit template ID”  also check the permissions.

Thanks

I do not see that option in the Item Class screen. Not sure how to check my permissions but there is one user with total access and I will see if they can do it. 

 

Our problem is with Big Commerce - Even though we have the stock item unclicked for “Export to External System” whenever we make a change to the Item Template and publish it adds back the deleted item. Then if we remove it on Big Commerce auto syncing no longer works because the matrix item is trying to push to BC but no longer sees that item. We want auto sync without the item we no longer offer. 

Userlevel 7
Badge

Hi @Aspence26 were you able to find a solution? Thank you!

@Chris Hackett Not yet. Still working on reviewing permissions. As far as I can tell as a System Administrator I have a lot of access but I am still unable to change Template ID association from the Stock Item editing screen. I have a ticket with our VAR to review. 

Also I was incorrect when stating the ERP import matrix package was published. 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved