Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / reports for inventory ...
Microsoft Dynamics NAV (Archived)

reports for inventory valuation

(0) ShareShare
ReportReport
Posted on by santarzan 397

When we run reports for inventory valuation or anything that relies on item costs, the calculations seem to vary based on when we run the reports. For example, we have an item that costs $5 with 5 on hand and when we run the inventory valuation report on 2/28/2016 it shows $25. This is correct. The cost goes up to $7 on 5/1/2016, we have 10 on hand, and when we run the report on 5/31/2016 it shows $70. This is correct. However, if we run the report on 5/31/16 using the 2/28/2016 date filter, it shows $35 instead of the $25 when we ran it on 2/28/2016. Which appears to be the 5 that we had on hand on 2/28/2016 multiplied by the new cost that took place on 5/1/2016. Is this because we have our items set up as Standard in the costing method? Is it possible to run the reports and get the same results, no matter which day we run the report? If we had to change the costing method, is there a quick way to change them all?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: reports for inventory valuation

    To Change the costing method - there´s a module from CKL Software GmbH Germany. You can change the costing method per qualifying date for the Future. But never changing the post in the past. Please have a look at www.ckl-kore.de 

  • santarzan Profile Picture
    santarzan 397 on at
    RE: reports for inventory valuation

    yes i have updated the report now its working fine

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: reports for inventory valuation

    You can change the Item Cost Manually at Item Card or you can use the "Standard Cost Worksheet" to change the Standard Cost

    You would find this option under Purchase > Inventory & Costing > Costing > Standard Costs Worksheet.

    Refer following link for further details. Although it is in NAV 2016, you would be able to understand the concept.

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

  • santarzan Profile Picture
    santarzan 397 on at
    RE: reports for inventory valuation

    hi Vishal ,

    also i have one doubt like when the value in the standard cost is updated,

    like first i bought item for 5$ and later i bought the same item for 7$ but the standard cost remains same in the item card and the sane value has been calculated for the inventory validation, if i want to change the standard cast do i need to change it in the item card manually to 7$?

  • santarzan Profile Picture
    santarzan 397 on at
    RE: reports for inventory valuation

    its an standard report .

  • santarzan Profile Picture
    santarzan 397 on at
    RE: reports for inventory valuation

    no i dint have any .

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: reports for inventory valuation

    It might be the case that you are using a customized report that always takes the latest updated price. What report are you using, is it a modified standard one or a newly developed?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: reports for inventory valuation

    Ideally, system should show 25$ only in standard NAV system.

    I tried creating the exactly same scenario and found the same result in standard "Inventory Valuation" Report.

    Is there any customization in your report?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans