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)
Hi
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?
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.
Hi
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.
Hi
Also I was incorrect when stating the ERP import matrix package was published.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.