Options

Bom Journal Cost Roll up

subbukumsubbukum 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

Comments

  • Options
    cernstcernst Member Posts: 280
    Adjust cost doesn't work if you use BOM journals you must use manufacturing BOM for this to work.
    This will be changed so it'll work in coming version.
    _____________________
    NAV Freelance Consultant
  • Options
    subbukumsubbukum Member Posts: 3
    Hi cernst,

    Thanx for the prompt reply.
    Any workaround to tackle this issue? The customer has BE licensing.

    subbukum
  • Options
    cernstcernst Member Posts: 280
    Hi,

    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
  • Options
    David_SingletonDavid_Singleton Member Posts: 5,479
    cernst wrote:
    ...
    This will be changed so it'll work in coming version.

    Where did you hear this from?
    David Singleton
  • Options
    santoshmkcetsantoshmkcet Member Posts: 229
    cernst wrote:
    Adjust cost doesn't work if you use BOM journals you must use manufacturing BOM for this to work.
    This will be changed so it'll work in coming version.

    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.
    Thanks & Regards
    Santosh
    Where Stones can be transformed to Gold
  • Options
    cernstcernst Member Posts: 280
    In NAV2013 you have a new feature assembly order which works with adjust cost job. You should try that.
    _____________________
    NAV Freelance Consultant
Sign In or Register to comment.