Inventory Revaluation Journal

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 6.00.00 and 6.00.14 are required for the functionality described in this document.

TABLE OF CONTENTS

• Creating and Posting Revaluation Journal Entries

Creating and Posting Revaluation Journal Entries

1. Revaluation Journals can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “Revaluation Journals” in “Tell me what you want to do” then selecting “Revaluation Journals” from the results in the Go to Pages and Tasks section OR by selecting the “Revaluation Journals” menu action (if present) from your Role Center home page.

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 Process à Calculate Inventory Value from the menu.

4. Ceres will recommend running the Adjust Cost – Item Entries batch job before continuing.

5. A Calculate Inventory Value Page will be displayed. 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 defaults and cannot be changed.

Update Standard Cost: Toggle this field if you want the Items’ Standard Cost to be updated according to the calculated Inventory Value.

Update Unit Cost (Revalued): With Ceres 6.00.14; toggled this field if for Items with a Costing Method equal to Standard, you want the Items’ current Standard Cost to be utilized for the 'Unit Cost (Revalued)' field on the resulting revaluation journal line.

6. On the Item FastTab select filters for the items or groups of items that you want to revalue.

7. Click OK to proceed with Calculate Inventory Value process which will generate lines in the Revaluation Journal.

8. Alternatively, you can manually insert the lines to be revalued.

1. In the Item no field, use the Assist Button to view the Item List, select the item you wish to revalue and hit OK.
2. 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.
3. Then select the Lot No. you want to revalue.
4. Repeat steps a and c for each item you wish to revalue.

9. 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.

10. To run the Test Report, click on the Actions à Posting à Test Report. The report will display the $ impact on the items you are revaluing.

11. To Post or Post and Print the Journal, click on Actions à  Posting and select Print or Post and Print. Select Yes to confirm that you want to post the journal lines.

12. To view the results, go to the Item Card for one of the items that was revalued and select Related à  History à  Entries à  Value Entries from the menu. The entries that were revalued have an Entry Type of Revaluation.