cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Stephane

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member583013
Active Contributor
0 Kudos

Stephane,

Please try the following.

Go to Inventory Reports > Inventory Valuation Report > Use Calculation method as Moving Average. Select Display method Row Per Item

You should see the moving average price for the item.

Suda

Former Member
0 Kudos

Hello Suda

Is there a way to get both data (moving average & standard price) available onto the same report ?

Thanks

Stéphane

JesperB1
Advisor
Advisor
0 Kudos

Hi Stephane,

It is possible but it needs to be an SQL query and you need to update the Last Evaluated Price before running the report with the inventory valuation report. The only problem is that you can only maintain one Last Calculated Price at a time, meaning there will be a problem if you want it per warehouse.

Let us know if you want help writing the query and if so if it is by warehouse or by item.

Regards,

Jesper