List of Matrix Items linked to Template Item

  • 10 October 2023
  • 2 replies

Userlevel 7
Badge +12

Looking for a Generic Inquiry to get the List of Matrix Items associated to Template Items.



Best answer by Naveen Boga 10 October 2023, 18:34

View original

2 replies

Userlevel 7
Badge +19

Hi @manikantad18 I have created a simple SQL View and then created a GI for the same.

I have tested it and seems working well. Please import the below GI into your instance and verify.


drop view IF EXISTS NBTemplateItemsWithoutMatrix
create view NBTemplateItemsWithoutMatrix
Select CompanyID, InventoryID, InventoryCD, Descr from Inventoryitem where CompanyID=2 and istemplate=1 and InventoryID not in( Select TemplateItemID from InventoryItem Where CompanyID=2 and TemplateItemID is not null)


Hope this helps!!

Userlevel 7
Badge +12

Hi @Naveen Boga 

Thank you for the Quick Help, Really helpful for me.


It is working Perfectly.


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