Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Average Cost in NAV 2009
Microsoft Dynamics NAV (Archived)

Average Cost in NAV 2009

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We have average cost method, and since few weeks we face a very strange behavior in one of our subsidiaries. System marks very old entries in the table 5804 "Avg. Cost Adjmt. Entry Point" as not adjusted. But we are sure, that there could be no postings in that periods, as they are closed for the users since long time. And it concerns hundreds of items. As a result, Cost Adjustment for all items takes extremely long, and for some items even goes in cycle.

My questions are:

1. What can cause setting this hook to "No", if there were no psotings, no charge allocations etc. in that period?

2. What can we do with it now? If I just set this hook to yes in all entries earlier than January 2017, for example - we have theoretical risk to get wrong cost. And if we leave it as it is - nobody can work, as many tables are blocked.

*This post is locked for comments

  • Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Average Cost in NAV 2009

    hope you have done it by DB level isn't it ?

    or System level ..

    the case is cost adjustment will effect to  the item so what why your functions mess with it

    try what i have suggest either basic solutions or Critical solution

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Average Cost in NAV 2009

    Hello Maneesha and Manish!

    There were no manual corrections in the database. What I finally made - I marked yesterday all the entries older than 01.01.2017 as adjusted = Yes, then Cost Adjustment run succesfully in a few hours. Now I will monitor if suchentries appear again, maybe then have more information.

    Thank you for your answers!

  • ManishS Profile Picture
    ManishS 78 on at
    RE: Average Cost in NAV 2009

    Has anyone played with the item application entry table ?

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Average Cost in NAV 2009

    Dear anton.dyundik ,

    Ok we have some several solutions for you according to this conversation

    Now you item cost adjustment will be more risk if you are going to readjust it(without your partners)

    the basic solutions are made as by follows but im not sure whether it is very suitable for you or not

    1. Create New Item with same name block existing and use New Item

    2. Create new Item mark as subsidiary as  your existing item and use subsidiary product

    Other path are  Critical paths  

    1. With the help of your partner access the DB level tables and delete entries (on your existing changes has been done to DB level might be miss to modify cascaded tables that's why you got stuck)

    2 . Delete All ledger entries according to the item - related to the cost adjustment

    But to this function first i need to tell you This is really really not recommend : if you only in can't help situation use it , Please get help form you partner to do this don't do it alone  

  • Alex A Profile Picture
    Alex A 2,348 on at
    RE: Average Cost in NAV 2009

    Can you go into the Item Ledger for one example and post the results. Or examine the Item Ledger and confirm no transactions have taken place.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Average Cost in NAV 2009

    Hello Alexander! Answer is "no" for both questions.

    Of course, there are some charges, but they all are allocated on transactions of February 2017 latest,

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Average Cost in NAV 2009

    Could anyone make any manual changes directly in the database? Also, have you posted any item charges to those items recently?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Average Cost in NAV 2009

    Hi Manish!

    No, we didn't change any setup. 

  • ManishS Profile Picture
    ManishS 78 on at
    RE: Average Cost in NAV 2009

    Have you changes the setups , inventory setup ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans