Active Product Prices by Type

Active Product Prices by Type

Submitted by Nathan Clouse on 08/30/15.

Provides a list of prices per product / product variant for items that have an active price whether it is Sales, Purchase or Costing. Products and Variants not in this view do not have an active price.

AX Version: 

Module: 

CREATE VIEW [dbo].[vw_pimInventItemPriceActive] 
AS 
  SELECT iipa.itemid, 
         iipa.activationdate, 
         iipa.costingtype, 
         iipa.price, 
         iipa.priceunit, 
         iipa.priceqty, 
         iipa.pricetype, 
         iipa.unitid, 
         iipa.markup, 
         iipa.inventdimid, 
         id.inventsiteid, 
         pv.displayproductnumber, 
         pv.configid, 
         pv.inventcolorid, 
         pv.inventsizeid, 
         pv.inventstyleid, 
         pv.dataareaid, 
         pv.partition 
  FROM   inventitempriceactive iipa 
         INNER JOIN vw_pimproductvariants pv 
                 ON iipa.itemid = pv.itemid 
                    AND iipa.dataareaid = pv.dataareaid 
                    AND iipa.partition = pv.partition 
         INNER JOIN inventdim id 
                 ON id.inventdimid = iipa.inventdimid 
                    AND id.dataareaid = pv.dataareaid 
                    AND id.partition = pv.partition