Item Name

Item Name

Submitted by Nathan Clouse on 09/08/15.

c Great for bringing in the Item Name after you have collected all the data you want.

AX Version: 

Module: 

CREATE VIEW [dbo].[vw_inventItemName] 
AS 
  SELECT it.recid, 
         'itemName' = Isnull(erpt.NAME, it.namealias) 
  FROM   dbo.inventtable it 
         INNER JOIN dbo.ecoresproduct erp 
                 ON it.product = erp.recid 
         LEFT JOIN dbo.ecoresproducttranslation erpt 
                ON erpt.product = erp.recid 
                   AND erpt.languageid = 'en-us' 

go