You’re offline. This is a read only version of the page.
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
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
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
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$?
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?
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (