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) / Remaining Inventory Va...
Microsoft Dynamics NAV (Archived)
Answered

Remaining Inventory Value - No quantity - No unit cost

(0) ShareShare
ReportReport
Posted on by Alex A 2,913

Hello,

Looking for some answers to how I might chase down this issue. The Inventory Valuation report shows amounts remaining for three items that have a zero remaining quantity and a zero unit cost. Two of the amounts are for negative 1 cent. See attachment.


0257.Untitled.png

Any suggestions for figuring out how to fix this will be very much appreciated. Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Indikauk Profile Picture
    Indikauk 1,759 on at

    Hi Alex

    Hope Below link will help you wich already have discussed the same issue.

    community.dynamics.com/.../222968

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,891 on at

    Just do the cost adjustment that's it :)

  • Alex A Profile Picture
    Alex A 2,913 on at

    Hi Maneesha, are you talking about the 'Adjust Cost Item Entries'?

  • Alex A Profile Picture
    Alex A 2,913 on at

    Indika, I tested your suggestion as found on the bottom of that other post, but it did not alter the value as shown on the Inventory Valuation Report. Is there a verified solution for this?

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,891 on at

    yes ,

    or check this will happen by rounding

    msdn.microsoft.com/.../hh168375(v=nav.90).aspx

    msdn.microsoft.com/.../hh997375(v=nav.90).aspx

  • Verified answer
    Indikauk Profile Picture
    Indikauk 1,759 on at

    Hi Alex

    Mainly I have noticed Valuation problem due to expected Cost & Multilocation transactions those not closed properly as I have explained in my suggested link.

    if you to go to you item card then select the Item no. "HB50C" then click on the below item button and select Etnies & Value Entry just export those entries to excel and share it via dropbox then I'll let you know where is the problem and how to correct it.

    or you can check the same and find out from which transaction the value remaining on the valuation report.

    if you have gone through all my reply on the provided link I hope you could solve the problem but I think only you have gone through my last reply on that thread.

    In this community lot of people don't do verification on the answer even if the got the right solution instead they start with one question and once that is loved they come up with may sub question and later on, they don't verify any suggestion.

    Thanks

    Indika

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,891 on at

    have you try the Rounding Method ?

  • Verified answer
    Alex A Profile Picture
    Alex A 2,913 on at

    After trying several adjustment options, the answer was in the fact that running the Inventory Valuation report with the current date now shows the inventory value back at zero for all three items. The original issue was that it did not show this as of the date at the end of the year. This means that there was a Cost Adjustment Value Entry that cleared the value correctly, but was posted after the period end date. So in effect, this was a timing issue.

    I learned the following:

    "If the Allow Posting From Date in G/L Setup is set to 01/01/2017 shortly after 12/31/2016 and before Adjust Cost Item Entries is run for all cost changes, the system will use the first available Posting Date after the close, which would for example be 1/1/2017."

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)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans