Hi,
We have a problem with “Price List” lookup field on opportunity form.
We are using multi currency deployment of CRM 4.0, and when I try to link new or existing opportunity with any of price lists, lookup field is empty. Both Form Assistant and Look up Records Webpage are displaying message “No Price List records are available in this view.”
Price lists do exist for every currency. Price List lookup fields on other entities (Quotes, Orders, Invoices …) are working properly, and showing all existing price lists for selected currency.
No extensive customizations are made on opportunity entity just some custom attributes are added.
In my despair a started trace on SQL server and discovered that this query is passed to SQL server:
“exec sp_executesql N'select top 51 pricelevel0.Name as ''name'', pricelevel0.TransactionCurrencyId as ''transactioncurrencyid'', pricelevel0.PriceLevelId as ''pricelevelid'', pricelevel0.TransactionCurrencyIdName as
''transactioncurrencyidname'', pricelevel0.TransactionCurrencyIdDsc as ''transactioncurrencyiddsc'' from PriceLevel as pricelevel0 where (pricelevel0.StateCode = @StateCode0 and pricelevel0.TransactionCurrencyId =
@TransactionCurrencyId0 and (pricelevel0.DeletionStateCode in (@DeletionStateCode0))) order by pricelevel0.Name asc, pricelevel0.PriceLevelId asc',N'@StateCode0 int,@TransactionCurrencyId0 uniqueidentifier,@DeletionStateCode0
int',@StateCode0=0,@TransactionCurrencyId0='00000000-0000-0000-0000-000000000000',@DeletionStateCode0=0”
In which you can see part where parameter is pased:
@TransactionCurrencyId0='00000000-0000-0000-0000-000000000000'
But all opportunities have their currency selected.
Please help if you can it is important to add price list to opportunity to be able to add products to same opportunity.
Regards,
Vladimir Zecevic
