Average Purchase price in sales price calculation

[Former Member]

Hi Experts,

I have a specific requirement to calculate the sales price in VKP5 based no Average purchase price in all the info records for that article.

Please guide.

Thanks in Advance,

[Former Member · Accepted solution]

Hello,

There is no standard way of getting average purchase price of all info records. You have to define an alternate calculation type in Pricing procedure (VOFM routine), code it and then include it in Pricing Procedure.

Thanks,

Venu

[Former Member]

Hi,

Yes, there is a standard way: You can use the corresponding purchase price determination type/sequence. Please check the Retail Pricing Customizing, there you'll find it.

Best regards,

Christina

[colin_cheong]

HI,

Why not uses the MAP to re-compute your selling price?

[Former Member]

Hi,

Well, the average of currently valid purchasing prices and moving average are slightly different. Anyhow, of course also the moving average could be used: Again by purchase price determination type/sequence: use special schema and maintain moving average price condition type. But consider volumes, as the moving average is on article/site level: Should each individual store's moving average change lead to a sales price re-calculation, maybe ending up with different sales prices all over a Retailer's store chain? Probably not a good idea. Better implement a reference site (via requirement).

BR,

Christina