As I discussed in my previous post about GP and CRM integration, here is the query for getting all the price levels in GP and combining them with Currency (in my example 2 currencies).
you can use this query in your integration application or your code to read the data from GP database and make it ready to send to Dynamics CRM price list.
SELECT [IV40800].[PRCLEVEL], [IV40800].[DSCRIPTN], [MC40200].[CURNCYID], [MC40200].[ISOCURRC] FROM [IV40800], [DYNAMICS].[dbo].[MC40200] [MC40200] WHERE [MC40200].[CURNCYID] = 'USD' or [MC40200].[CURNCYID] = 'CDN'