web
You’re offline. This is a read only version of the page.
close
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) / Cost adjusted in value...
Microsoft Dynamics NAV (Archived)

Cost adjusted in value entry. How Avoid it?

(0) ShareShare
ReportReport
Posted on by Jaime Figueras 179

Hi, I am in trouble with the inventory. We do not work with inventory periods. On 31/12/2016  I did negative adjustment of all items. We work with variants and with lot numbers. The inventory valuation is 0 in this moment. The problem is that when I do the positive adjustment of all items, Nav makes very much adjustments in value entry table of old entries. I have activated adjusted field in all the rows of 5804 table before doing the positive adjustments, but Nav still makes those old adjustments. Any way to avoid that adjustments? Maybe I forget another table? Thanks.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    You have Cost is Adjusted Field in the following tables

    Table Item (27)

    Table Avg. Cost Adjmt. Entry Point (5804)

    Table Average Cost Calc. Overview (5847)

    Table Inventory Adjmt. Entry (Order) (5896)

  • Jaime Figueras Profile Picture
    Jaime Figueras 179 on at

    In Table 27 it is not editable, but if in the 5847 and 5896 I activate all rows as adjusted when the inventory is 0, maybe nav doesnt do that automatic adjustments when doing the positive adjustments?

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    27 table should also be editable if you selected the path of direct manual corrections in the database. One standard option is not use the old item cards anymore and create new ones, and make needed positive adjustments there.

  • Jaime Figueras Profile Picture
    Jaime Figueras 179 on at

    At 31/12/2016 I have 0 inventory and if I summarize: cost amount (actual), cost amount (expected) and quantities, I have done manually a line (in value entries) to everything is zero (in each variant of each ítem).

    I have 160 ítems where everyones summarize 0.

    When I do the positive adjustment of inventory: 156 ítems only do the movement I have done (well). But in 4 ítems appears 40 lines of adjustments of the past. What you reffer making new ítem cards? Create new ítems? We use Nav 2015. Thanks.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans