on 10-20-2008 8:48 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.