Revaluation item with Costing method Average

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (7)

Answers (1)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Revaluation item with Costing method Average

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
Verified answer

RobertasR 5,002 on at

Like (0)

Report

RE: Revaluation item with Costing method Average

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Revaluation item with Costing method Average

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
Suggested answer

Rajendra Gangwar 150 on at

Like (0)

Report

RE: Revaluation item with Costing method Average

Hi Humaidi,

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

Ahmed Mohamed Rafik 3,049 User Group Leader on at

Like (0)

Report

RE: Revaluation item with Costing method Average

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.
Suggested answer

RobertasR 5,002 on at

Like (0)

Report

RE: Revaluation item with Costing method Average

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
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Revaluation item with Costing method Average

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.