Skip to Content
Former Member
Jan 22, 2008 at 05:10 AM

Usage of Standard Price + Moving Average (for Statistical Calculation)


Good morning,

My company uses the standard price since we are manufacturing few items.

Standard Price generates Purchase Price Variance and we have to adjust the stardard price twice a year.

Is there a way to display the moving average price of the items (for statistical reasons) so we adjust our Standard Price Accordingly ?

Can we do so within the normal SBO functionality (but you can only store one item cost) or shall we (and how) do it with report composer / XL Reporter.

Thanking you in advance