Query not working for Customer Specific Price List (Gross)

[carloortega08]

Hi Experts,

I would like to ask for your assistance regarding Sales Price List

What I would like to achieve is to retrieve the list of all Customer Specific Price List (Gross)

but even if I use the code below it is not working as expected

var initQuery = SalesPriceList.QueryByGroupCode;
var initSelParams = initQuery.CreateSelectionParams();
initSelParams.Add(initQuery.GroupCode.content, "I", "EQ", "PLALL1");
var initQueryResult = initQuery.Execute(initSelParams);
var queryprice = SalesPriceList.QueryByTypeCodeAndPropertyIDAndPropertyValue;
var queryprice_Params = queryprice.CreateSelectionParams();
queryprice_Params.Add(queryprice.TypeCode.content, "I", "EQ", "8PL0");
queryprice_Params.Add(queryprice.ReleaseStatusCode, "I", "EQ", "3");
var queryprice_Results = queryprice.Execute(queryprice_Params);

I hope you can help me resolve this thank you

Regards,

Carlo

[Adie]

Hello Carlo,

[Adie]

Hello Carlo,

Please have a look at this KBA: 3195901 - How to Query Campaign Specific Price List via the Web Service QuerySalesPriceListIn.  When querying a sales price list, the header key names has to be passed in the query. For customer specific price list, the header key name is Account. 

Kindly refer to the sample query in the KBA and adapt your query, and try again.

Thanks,

Adie