Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Problem with Adjust Cost Item Entries - Standard Cost
joshplummer
Member Posts: 39
So, I just upgraded from 3.6 to 5.0, and I have what appears to be a very large issue with how Adjust Cost behaves in 5.0 versus 3.6.
In 3.6, Adjust Cost would calculate variances according to the Standard Cost. So, if my standard cost is $100, and it cost me $90 to make it, I would get a $10 favorable variance.
In 5.0, Adjust Cost is basing it's variances on what appears to be Last Direct Cost. So, my standard is $100. And, for some reason, I had to get one done on the outside, short run, and it cost me $150. But, making it internally, I record $90 of cost. I should see a favorable variance of $10. But, Nav 5.0 is giving me an unfavorable variance of $50.
All Items are set to use the Standard Costing method. Last Direct Cost shouldn't even be considered in any way when using Standard Costing.
Please help.
In 3.6, Adjust Cost would calculate variances according to the Standard Cost. So, if my standard cost is $100, and it cost me $90 to make it, I would get a $10 favorable variance.
In 5.0, Adjust Cost is basing it's variances on what appears to be Last Direct Cost. So, my standard is $100. And, for some reason, I had to get one done on the outside, short run, and it cost me $150. But, making it internally, I record $90 of cost. I should see a favorable variance of $10. But, Nav 5.0 is giving me an unfavorable variance of $50.
All Items are set to use the Standard Costing method. Last Direct Cost shouldn't even be considered in any way when using Standard Costing.
Please help.
0
Comments
The adjust cost works as you originally describe it. In 5 if I have a standard cost of 100 and buy for 90 I get a favourable 10.
Was your transaction a converted one? If you create a simple test in a test environment from new what happens?
If you look at the item ledger entry I presume the cost is 100, what is the associated value entry showing you?
The standard cost on the item is 100 and you can see this and the entries making it up?
The new 5.0 Adjust Cost is posting WIP adjustments, and various other adjustments, to Production Orders (and others) that were closed, and completely invoiced YEARS AGO.
As a result, it appears that Adjust Cost is shooting itself in the foot and adjusting the cost of a current production order using an incorrectly adjusted cost of a previous production order.
I never received any instructions on how to make Adjust Cost behave normally once migrated to 5.0. Is there someting I need to do so that Adjust Cost doesn't blindly charge through my entire history and make ridiculous and unnecessary adjustments??
You would need to get your partner and Microsoft involved so they can assess the issue and decide the cause and hopefully fix it.