Revaluation of Stock on Hand

(0) Share

Report

Posted on by Anita75

1,165

Hi All,

I haven't found a way to easily revalue the existing on hand stock - when using revaluation journal system wants apply to entry. Is there a way to revalue without applying to a specific previous entry?

Thanks

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Bilal Haider 414 on at

Like (1)

Report

Hi,

You can try to use report Adjust Cost - Item entries

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (1)

Report

It is advised you run the report already mentioned and BC warns about this. In terms of not relating to a specific entry that is not the purpose of the reval journal. You are looking to manipulate the value entries of the item so it will always relate back to an entry. The batch job for calculating will only handle entries it can.

Was this reply helpful? Yes No
Anita75 1,165 on at

Like (0)

Report

This report does not do anything or prompt a screen so I think this to apply costs to invoices posted - if your setting under inventory is set to cost adjust periodically

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Anita75,

Happy New Year. First an general overview of the Revaluation Journal...

There are typically two scenarios regarding inventory revaluing. In the first scenario, you would want to revalue all of the remaining quantity in inventory for an item. In the second scenario, you would want to revalue a single increase to inventory (positive adjustment, for instance). This scenario could be caused by an incorrect cost posted in a Dynamics NAV Item Journal in which that inventory has already been deducted from inventory. When you do run the Revaluation Journal, in both scenarios, you will notice Applies-To Entry column, which links the Revaluation Amount to the Open Item Ledger Entry being adjusted. However, you can run the Revaluation Journal and Calculate Per Item. This will apply the Revaluation Unit Cost to all Open Entries (see example below).

In either case, in the end, each FIFO or LIFO layer, depending on which Costing Method (Note: Average and Standard do not use this journal), all Open layers will be updated and posted too.

Just a note, you must run Adjust Cost - Item Entries prior to running the revaluation journal as my colleagues noted. You can run setup Automatic Cost Adjustment on the Inventory Setup page.

I hope this helps explain the Revaluation Journal and how it posts.

Thanks,

Steve

Was this reply helpful? Yes No