Display volume discounts

[Former Member]

I need to be able to display either the standard volume discounts that are available to a BP in a Sales Document. I know that when I have a BP with special prices I can click on the Last Prices and then get to the volume discounts (have to navigate my way through) Is there any way of accomplishing the same maneuver for regular volume discounts?

Would be great if I could get a query that would list all of the available discounts as I enter the Item Code.

thx,

Richard.

[Former Member · Accepted solution]

Thank you or the reply Gordon,

Sounds good to have a fms but I would like to be able to see the various prices associated to the different discounts.

How can I accomplish that?

thx,

Richard

Edited by: Richard Pagé on Oct 19, 2009 6:59 PM

[Former Member · Accepted solution]

When the number of prices is more than one, it will pop up a list by this FMS.

[Former Member]

Richard,

This FMS would be a tough one. Try this one to start:

SELECT T0.Price FROM SPP2 T0 WHERE T0.CardCode = $[$4.0.0\] AND T0.ItemCode = $[$-38.1.0\] AND T0.Amount > $[-$38.11.number\]

Thanks,

Gordon