Solved

Remove Matrix Item from Template

  • 4 December 2023
  • 8 replies
  • 93 views
A
Rank

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

manikantad18
Rank
Userlevel 7
Badge +12

Hi @Aspence26 

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

 

Acumatica Functional Consultant
A
Rank

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

manikantad18
Rank
Userlevel 7
Badge +12

Is this package Published in Your assistance?

Which version Acumatica your are using.

1 Attachment
Acumatica Functional Consultant
A
Rank

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. 

manikantad18
Rank
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

Acumatica Functional Consultant
A
Rank

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. 

Chris Hackett
Rank
Userlevel 7
Badge

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
A
Rank

@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


Terms & ConditionsCookie settings
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