Featured Post

Dynamics GP 2018 - Upcoming Features

We are counting the days for Dynamics GP 2018 release which is promising to introduce a new set of features that have been highly recogniz...

Wednesday, February 22, 2017

Dynamics GP - Price List Details SQL Script


It's been a while, back with more SQL scripts for Dynamics GP. This one provides a summary for all Dynamics GP prices lists including all price levels


Price List Details



CREATE VIEW [dbo].[Vw_PriceListDetails]
AS   
SELECT  A.ITEMNMBR ,
        RTRIM(LTRIM(B.ITEMDESC)) AS ItemDescription,
        RTRIM(LTRIM(A.CURNCYID)) AS Currency ,
        RTRIM(LTRIM(A.PRCLEVEL)) PriceLevel ,
        RTRIM(LTRIM(C.DSCRIPTN)) AS PriceLevelDescription,
        A.UOFM AS UnitOfMeasurement,
        A.FROMQTY AS FromQuantity,
        A.TOQTY AS ToQuantity,
        A.UOMPRICE AS 'Unit Of Measurement Price',
        A.QTYBSUOM 'ConversionFactor',
             A.UOMPRICE 'Price without Tax'
FROM    [IV00108] AS A
        LEFT OUTER JOIN IV00101 AS B ON A.ITEMNMBR = B.ITEMNMBR
             LEFT OUTER JOIN dbo.IV40800 AS C
             ON C.PRCLEVEL = A.PRCLEVEL

GO




Best Regards, 
Mahmoud M. AlSaadi

No comments:

Post a Comment