News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Average cost is not ad...

Small and medium business | Business Central, N...

Answered

Average cost is not adjusting after revaluation of item with LOT no. tracking in NAV 2018

(0) Share

Report

Report

Posted on by yogesh manikpure

25

Hi Friends,

I am stuck in a scenario given bellow. Kindly request you to help.

I have an item for which lot no. is compulsory and following average costing method. I have done positive adjustment of item A with qty 10 and Value 2000 and lot no. LOT192001 dated 01/04/2020. The inventory has been sold completely.

Now I want to revalue the the item cost to 4000 dated 0104/2020. System is allowing me to revalue but it is not adjusting or rolling the cost. Due to this when I am running inventory valuation, I am seeing item A with quantity zero and value 2000 (Revalued cost).

I have seen that it is happening only with item having lot no. or serial no. compulsory.

I am using NAV 2018.

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Marco Mels on at

Like (1)

Report

RE: Average cost is not adjusting after revaluation of item with LOT no. tracking in NAV 2018

Hello,

Happy New Year.

Thank you for confirming solution.

Thanks.
Verified answer

yogesh manikpure 25 on at

Like (0)

Report

RE: Average cost is not adjusting after revaluation of item with LOT no. tracking in NAV 2018

Hi Friends,

I got the solution to this. it was basically posting date and valuation date issue. Which is resolved. Thanks,

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans