Purpose of this document
If you received or posted at the wrong cost (value) for your inventory, Ceres allows the inventory to be revalued via the Inventory Revaluation Journal. This document explains how to use the Inventory Revaluation Journal to change the inventory value of your Items.
Ceres Object release 5.00.00 is required for the functionality described in this document.
Table of Contents
Creating and Posting Revaluation Journal Entries
1. The Revaluation Journal can be accessed from Departments à Warehouse à Inventory à Tasks
à Revaluation Journals.
2. From the Revaluation Journal, select the Batch Name to use.
3. Run the Calculation Inventory Valuation batch job to populate the journal with the items you want to
revalue. To run the batch job. select à Home à Calculate Inventory Value.
4. A Calculate Inventory Value Page will display. On the Options FastTab update the fields as necessary.
Posting Date: Enter the Posting Date.
Document No.: Input a Document No if this field is blank.
Calculate By: The Calculate By field automatically default and cannot be changed.
5. On the Item FastTab select filters for the items or groups of items that you want to revalue.
6. Click OK to proceed with Calculate Inventory Value process which will generate lines in the Revaluation
Journal.
7. Alternatively, you can manually insert the lines to be revalued.
- In the Item no field, use the Assist Button to view the Item List, select the item you wish to revalue and hit OK.
- In the Applies to Entry field, use the Assist Button to view the Item Ledger Entries, select the entry that you wish to revalue and hit OK. This will automatically populate the Location Code field.
- Then select the Lot No. you want to revalue.
- Repeat steps 3.a and 3.c for each item you wish to revalue.
8. In the Unit Cost (Revalued) field, enter the new unit cost. Or enter the new total amount in the Inventory
Value (Revalued) field. The Amount field displays the revaluation difference or the difference between the
Inventory Value (Calculated) and the Inventory Value (Revalued) fields.
9. To run the Test Report, click on the Actions Tab of the Ribbon and select Test Report. Te report will display
the $ impact on the items you are revaluing.
10. To Post or Post and Print the Journal, click on the Actions Tab of the Ribbon and select Print or Post and
Print. Select Yes to confirm that you want to post the journal lines.
11. To view the results, go to the Item Card for one of the items that was revalued and select Entries à Value
Entries from the Navigate Tab on the Ribbon. The entries that were revalued with have an Entry Type of
Revaluation.
Related Topics
- Item Overview
- Items on Hand by Date Report
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article