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
Bom Journal Cost Roll up
subbukum
Member Posts: 3
Hi,
I am using Nav2009 SP1. The scenario i have is:
Item A has a child item K.
Item K is procured on 2 different dates as
03/01/2010 qty 10 at Rs 10 each
03/02/2010 qty 15 at Rs 30 each
Bom journal is used for posting item A.
On 03/3/2010 a bom journal is posted for 1 qty of Item A with 15qty of consumption of item K.
The costing now showing is
Item A after bom joournal posting Rs 330 per unit
Item K after posting is adjusted automatically to Rs 250 per unit, which is correct.
But the cost of item A is not getting corrected to Rs 250 from Rs 330 as there is no other cost associated even after manually running the cost adjustment batch job.
can anyone help please?
Thanx
subbukum
I am using Nav2009 SP1. The scenario i have is:
Item A has a child item K.
Item K is procured on 2 different dates as
03/01/2010 qty 10 at Rs 10 each
03/02/2010 qty 15 at Rs 30 each
Bom journal is used for posting item A.
On 03/3/2010 a bom journal is posted for 1 qty of Item A with 15qty of consumption of item K.
The costing now showing is
Item A after bom joournal posting Rs 330 per unit
Item K after posting is adjusted automatically to Rs 250 per unit, which is correct.
But the cost of item A is not getting corrected to Rs 250 from Rs 330 as there is no other cost associated even after manually running the cost adjustment batch job.
can anyone help please?
Thanx
subbukum
0
Comments
This will be changed so it'll work in coming version.
NAV Freelance Consultant
Thanx for the prompt reply.
Any workaround to tackle this issue? The customer has BE licensing.
subbukum
What you could do is to call the standard cost calculation in the BOM posting function before the BOM journal is posted. Then a new calculation is done and you get a better value.
But if the vendor invoice for the components is posted after you've posted the BOM then you won't get the right value anyway so this isn't 100%. The thing is that BOM journals are just positive and negative entries with no connection to each other so it would be har to rewrite the adjut cost job i think. Hope for a new release soon
NAV Freelance Consultant
Where did you hear this from?
Kindly confirm that the adjusted cost will be updated in the main items cost only in Advanced Management edition and not in Business Essential edition or is there a solution to this in BE edition.
Santosh
Where Stones can be transformed to Gold
NAV Freelance Consultant