Revaluation item with Costing method Average

(0) Share

Report

Posted on by Community Member

Hi everyone,

I have a problem when I try to do Revaluation item with costing method average, the program said "You cannot revalue individual item ledger entries for items that use the average costing method", it happen after I select the transaction in field Applies-to Entry. But there is no problem when I try with NAV 2017, please give me solution, thanks.

FYI, I using NAV 2013.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I believe this is because those items might have partial revaluation entries. I am not sure how to fix but that could be issue, check value entries for that and see if there are any entries with parital valuation to true.

Was this reply helpful? Yes No
Suggested answer

RobertasR 5,004 on at

Like (0)

Report
Copy link

Link copied!

Hi Humaidi,

when the costing method is Average, system doesn't allow to revalue a single transaction, as ALL units have the same cost (hence average).

To revalue you would run 'Calculate Inventory Value' by 'Item' (as opposed to 'by ILE') from the Revaluation Journal, that will give you one line for one item. You put new cost and it applies the new cost for all open entries of this item.

Hope that helps.

Robertas

Was this reply helpful? Yes No
Suggested answer

Ahmed Mohamed Rafik 3,049 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Revaluation don't work on items that use the Average Cost Method, as all items has the same cost.

Use instead "Calculate Inventory Value" function on the ribbon.

If you find this answer helpful, Click Yes to Verify the answer to share with other community members.

Was this reply helpful? Yes No
Suggested answer

Rajendra Gangwar 150 on at

Like (0)

Report
Copy link

Link copied!

Hi Humaidi,

Whenever costing method is average on Item Master Card, we cannot revalue a transaction. Try Calculate Inventory Value instead.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Dear Robertas,

I think I cannot use calculate Inventory value instead for this case, because it will revalue all unit cost for this item. In my case i just need to change 1 purchase transaction where the users give wrong price. May my picture can explain more.

I just want to change the transaction on 31th Oct 2017 from 42,122.09 into 42,264.50

Was this reply helpful? Yes No
Verified answer

RobertasR 5,004 on at

Like (0)

Report
Copy link

Link copied!

In this case, the revaluation is not an option. For average costing method you have to revalue ALL stock for given item. To correct the wrong 'price' on the Purchase Invoice, you should use Item Charge - that will change the cost (and recalculate average cost as well) AND will be an additional invoice/credit note for the vendor.

Robertas

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Everyone,

I found interesting article about my case, hope this can help if someone get the same problem.

forum.mibuso.com/.../you-cannot-revalue-individual-item-ledger-entries

Was this reply helpful? Yes No