Thursday, July 20, 2017

Dynamics NAV-LS Retail - Price Change History View

----------------------------------------------------------------------------------------------------------------
--Shows all sales price records
--Change the Date Filters to the period you want
----------------------------------------------------------------------------------------------------------------
SELECT     [CRONUS$Sales Price].[Item No_], CRONUS$Item.Description, [CRONUS$Sales Price].[Starting Date],
                      [CRONUS$Sales Price].[Ending Date], [CRONUS$Sales Price].[Unit Price Including VAT], [CRONUS$Sales Price].[Sales Type],
                      [CRONUS$Sales Price].[Sales Code], [CRONUS$Sales Price].[Currency Code], [CRONUS$Sales Price].[Variant Code],
                      [CRONUS$Sales Price].[Unit of Measure Code], [CRONUS$Sales Price].[Minimum Quantity], [CRONUS$Sales Price].[Unit Price],
                      [CRONUS$Sales Price].[Price Includes VAT], [CRONUS$Sales Price].[Allow Invoice Disc_],
                      [CRONUS$Sales Price].[VAT Bus_ Posting Gr_ (Price)], [CRONUS$Sales Price].[Allow Line Disc_], [CRONUS$Sales Price].[Markup _],
                      [CRONUS$Sales Price].[Profit _], [CRONUS$Sales Price].[Profit (LCY)]
FROM         [CRONUS$Sales Price] INNER JOIN
                      CRONUS$Item ON [CRONUS$Sales Price].[Item No_] = CRONUS$Item.No_
WHERE     ([CRONUS$Sales Price].[Starting Date] >= CONVERT(DATETIME, '2016-10-01 00:00:00', 102) AND
                      [CRONUS$Sales Price].[Starting Date] <= CONVERT(DATETIME, '2017-06-30 00:00:00', 102))
ORDER BY [CRONUS$Sales Price].[Item No_], [CRONUS$Sales Price].[Starting Date], [CRONUS$Sales Price].[Ending Date]

No comments:

Post a Comment