Looking for a Generic Inquiry to get the List of Matrix Items associated to Template Items.
Answer
List of Matrix Items linked to Template Item
+15Best answer by Naveen Boga
Hi
I have tested it and seems working well. Please import the below GI into your instance and verify.
drop view IF EXISTS NBTemplateItemsWithoutMatrix
GO
create view NBTemplateItemsWithoutMatrix
as
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!!
Acumatica Functional Consultant & Customer Experience Supervisor
+19Hi
I have tested it and seems working well. Please import the below GI into your instance and verify.
drop view IF EXISTS NBTemplateItemsWithoutMatrix
GO
create view NBTemplateItemsWithoutMatrix
as
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!!
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
+15Hi
Thank you for the Quick Help, Really helpful for me.
It is working Perfectly.
Acumatica Functional Consultant & Customer Experience Supervisor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.