Get Item Price with Price List and Item Code

[Former Member]

Hello,

I can see multiple ways of getting the price for an item based on from a specific price list.

Can somebody please tell me best practice to achieve this?

Thank you,

[Former Member]

Hi......

What you want exactly?

Report or anyhting else?

Regards,

Rahul

[Former Member]

Hello Rahul,

Thank you for responding.

I have added a combo populated with pricelists to some sales documents.

On et_COMBO_SELECT I want to loop through the matrix and update the prices with the chosen price list.

The reason I am doing this rather than using form 998 (Settings) is because I intend to use the selected price to populate the gross column rather than net.

Regards

Edited by: L Soyer on Feb 25, 2011 12:17 PM

It seems that a straightforward query is the best way of achieving this.