Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Inventory Costing
santosh_1
Member Posts: 1
my client has an requirement like
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.
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.
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?
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.
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.
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?
0
Answers
It's quite time costly to understand what exactly you need. I recommend you to read the following whitepaper which explains a lot about costing in NAV 2013 (most should still be applicable to 2016): archerpoint.com/sites/default/files/docs/ms-dynamics-nav-2013-inventory-costing-wp-ap.pdf
Altough one might often think there is need for development, it looks like your request is related more to reporting requirements than to coding questions.
In the event in which there is no suitable costing method for your current customer I strongly recommend you not to modify the standard valuation codeunit but to do reporting based on information gathered in a second table (or create a view, ...) for example.
Best regards,
Sebastien
Edit: I saw you posted this in the "Classic Client" forum. Attached you can find the PDF for NAV 5.0