Skip to main content

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

 

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
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!!

Hi @Naveen Boga 

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

 

It is working Perfectly.

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