News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Cost adjustment proces...

Microsoft Dynamics NAV (Archived)

Cost adjustment process issue

(0) Share

Report

Report

Posted on by Ashoka K Sampath

1,428

Hi All,

We use dynamics NAV 2009 R2,

My client has 3 companies and one consolidated company(report purpose) in the database.

Data per company filed = NO ,in Item table (27) ,

Items more than 20,000.

Now the problem when run Adjust Cost - Item Entries... report (Finance management)

Some times it wont run.

Then change the Average cost cal.type , item to Item & location & variant (inventory setup-Warehouse module) and run again.

Then Adjust Cost - Item Entries... report run properly. But the problem is , it takes long time. (4 hours for 3 companies)

Is there a way to avoid this problem ?

Thanks In advance :) ,

Inventory setup;

Automatic cost posting= Yes

Expected cost posting=Yes

Automatic cost adjustment= Never (We cant do this Always, because its takes some times at posting each transaction)

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Ashoka K Sampath 1,428 on at

Like (0)

Report

RE: Cost adjustment process issue

HI Alexsandar,

Thanks for the reply,

ILE ( Item ledger entry no) = 236164

VE (Value entry no) = 948889

This company Use SKU card also. most of the time each item has two SKU cards.

No variants

:)

Another Q : If company use SKU card , should default value in Average cost cal. type= Item & Location & variant (Warehouse setup) is it true ?
Aleksandar Totovic 16,765 on at

Like (0)

Report

RE: Cost adjustment process issue

What is entry numbers in Item Ledger Entry and Value Entry?

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans