Skip to Content
avatar image
Former Member

Inventory Valuation Report

What is the difference between Inventory Valuation and Inventory Audit report? I had just posted a question re: determining the total value of our in-stock inventory (total dollar value) ending in 9/30/08.

We used Inventory Audit Report to determine this, but should we have used Valuation? When we tried the Valuation report we did not get any results.

Thanks,

Mike

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 20, 2008 at 08:34 PM

    Mike,

    The difference can be found from online help:

    *Inventory Audit Report *

    This report provides an audit trail for the posted stock transactions in the chart of accounts.

    You use this report to make comparisons between the accounting view (stock balance accounts) and the logistics view (stock value displayed by the audit report). The report explains the value changes in stock accounts.

    This report does not recalculate the cost but displays the information from the database.

    The report is available only for companies using the perpetual inventory system.

    *Inventory Valuation Report *

    If you work with perpetual inventory, you can use this report to valuate the entire warehouse inventory of all items on a reporting date. You would normally valuate the warehouse inventory on the balance sheet reporting date.

    This report is intended as a managerial report to check what-if scenarios. For instance, you can see what happens if you value an item based on a different costing method. This report is not intended to be used as a report for auditing. For auditing purposes use the Inventory Audit Report.

    You can select one of the following calculation methods for inventory valuation:

    ● Moving Average

    ● FIFO

    ● LIFO

    ● By Price List

    ● Last Evaluated Price

    You can also define various criteria to restrict the selection for inventory valuation.

    You can choose a different valuation method for warehouse inventory valuation, if necessary, and you can also transfer the results to accounting. If you use the moving average price method, you calculate the same values as in the accounting module. Once you have selected a valuation method, we recommend that you continue to use the same method.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 08:31 PM

    The last evaluated price list is updated and populated when the

    Inventory valuation report is executed for the item in version 2004.

    In version 2005 SP01 this price can be updated by both the Inventory

    Valuation Report and the Inventory Audit Report if the company is

    running a Continuious Stock db.

    The different functions of these 2 reports can be read about in the

    online help under:

    Inventory - > Inventory Reports -> Inventory Audit Report

    Inventory - > Inventory Reports -> Inventory Valuation Report

    Also you cannot run the valuation report for the same methood as defined

    for the item.

    Regards

    Vikas

    Edited by: Vikas Rastogi on Oct 20, 2008 10:31 PM

    Add comment
    10|10000 characters needed characters exceeded