Last Evaluated Price List

[Former Member]

Hello Everyone:

Does anyone knows what is the purpose of the Las evaluated Price List and how does it update it?? The online help (F1) didn´t have much information. Does someone has some documentation to read about it?

Thanks advance

Regards

Claudia

[Former Member · Accepted solution]

Dear Claudia,

The Last Evaluated/Calculated Price is a result of running the Stock Valuation Report or the Stock Audit Report.

The Stock Valuation Report is intended for 'what-if scenarios'. For example, if the Moving Average Cost valuation is used for an item, an option is available to view the costs using FIFO or LIFO.

If the item's valuation method is, for example 'moving average', the Valuation Report should not be used to update Last Evaluated/Calculated price as this report is for 'what if scenarios' and won't run for this item. In this case, we can run the Audit Report in order to update the Last Evaluated/Calculated price.

Please check if the option 'manage item cost per warehouse' is selected under Administration/System Initialization/Company Details and if the item has or not a default warehouse.

If the 1st option is selected and the item does not have a default warehouse, the system will not know what cost price to use, (because there might be different costs prices for different warehouses) therefore it will not update it.

Regards

Vikas

SAP Business One Forums Team

[Former Member · Accepted solution]

Hi Vikas:

Thanks very much for you quick answer!.

We have selected u201CManager item cost per warehouseu201D; all the items has a default warehouse and all items use the moving average. Anything else you can tell me about this matter...and also...do you Perhaps have any documentation rearding this issue?

Thanks

Claudia

[Former Member · Accepted solution]

Hi

Is there anyway to update the Last Evaluated Price automatically? Without the need of running any report?

Thanks

Claudia

Edited by: Claudia Patricia Gutiérrez Alvarez on Aug 13, 2009 10:09 AM

[JesperB1 · Accepted solution]

Hi Claudia,

No, a report needs to be run.

Hence the name Evaluated Price.

If you set it with the Inventory Audit Report it will be the same as in your Default warehouse, if you set it with the Inventory Valuation Report it can be almost any value you wnt it to be, price list, fifo etc.

Hope it helps,

Jesper