Looking for a Generic Inquiry to get the List of Matrix Items associated to Template Items.
Best answer by Naveen Boga
View originalLooking for a Generic Inquiry to get the List of Matrix Items associated to Template Items.
Best answer by Naveen Boga
View originalHi
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!!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.