web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Dynamics GP Essentials / Dynamics GP - Price List De...

Dynamics GP - Price List Details SQL Script

Views (2314)
Mahmoud Saadi Profile Picture Mahmoud Saadi 32,738

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

This was originally posted here.

Comments

*This post is locked for comments