Skip to Content
0
Former Member
Nov 02, 2012 at 11:26 AM

Inventory valuation at Item Cost

88 Views

Good day all

In SBO 8.82 the standard system report "Inventory in Warehouse" has an option to use price lists to value stock. While price list valuation is useful we would like to value stock using Item Cost values as in the Item Master.

In our case we are using Moving Average cost for all items.

There are options (Simulation report) to move the current Item Cost into the Last Evaluated Price list and then select this option in the Inventory in Warehouse Report (Detailed) but this requires additional processing and time at busy month-ends.

A suitable report can be written using one of the reporting or other tools available but find it strange that there is no standard SOB report available. Surely if one selects a type of item cost method - standard, FIFO or Moving Average one would expect a standard system stock valuation report to ship with the vanilla product?

Your comments and suggestions are apprecaited.

Thanks and best wishes

Dana