This discussion is archived
5 Replies Latest reply: Jun 12, 2012 7:36 AM by 871137 RSS

Assembly cost rollup wrong for averag cost org

871137 Newbie
Currently Being Moderated
HI,

For two of the assembly items , when we complete wip jobs cost is coming as very less.
When i see the item cost for these 2 assembly items , it seems cost rollup is not correct.

Cost elements unit cost and material are showing up same value :X$
Remaining fileds material overhead,Resource, Outside processing and resource overhead are blank with no cost.

Include in rollup is already enabled and it is make item.

So Cost rollup is not done properly for these 2 assembly items , but need a way how can we correct them.

Please let me know the way to correct them.

Thanks
Vasudha.
  • 1. Re: Assembly cost rollup wrong for averag cost org
    871137 Newbie
    Currently Being Moderated
    Hi,

    IN addition to above information , when we go to costs tab in item costs window rollup item costs is not showing up any records here .

    Here also only material have cost as X$ and remaining fields are 0.

    Thanks
    Vasudha.
  • 2. Re: Assembly cost rollup wrong for averag cost org
    HrishikeshJ Journeyer
    Currently Being Moderated
    Hi,

    check if WIP Completion Transaction (in Inventory -> Transactions -> Material Transactions form) have distributions.
    One possible reason is that Cost Manager is stuck and is not processing the records.

    Secondly, check if there are any pending move transactions / pending resource transactions that are in error, try to remove error and reprocess the records.

    once all the transactions for the job in question are costed, then you will be able to see correct roll up.

    Thanks,
    Hrishikesh
  • 3. Re: Assembly cost rollup wrong for averag cost org
    871137 Newbie
    Currently Being Moderated
    Hi Hrishikesh,

    Yes wip assy completion transaction exists and have distributions also and they are as below.

    Transaction value Txn type Qty
    16625.29 WIP Assy Completion 30
    5689.43 WIP Assy Completion 30
    -16625.29 WIP Assy Completion -30
    -5689.43 WIP Assy Completion -30

    same subinv , locator , same account and same operation.

    There are no pedning resource or move transactions for this wip job.

    Can you please let me know if I need to check any thing else apart from these.

    Thanks
    Vasudha.
  • 4. Re: Assembly cost rollup wrong for averag cost org
    HrishikeshJ Journeyer
    Currently Being Moderated
    Hi,

    1. are all the 4 lines for same job?
    please provide details of accounts on each of the 4 lines.

    2. have you setup any overheads?

    My guess is that the 4 lines corresponds to
    16625.29 WIP Assy Completion 30 => Inv Valuation Debit
    5689.43 WIP Assy Completion 30 => Inv Valuation Debit
    -16625.29 WIP Assy Completion -30 => WIP Material Account Credit
    -5689.43 WIP Assy Completion -30 => WIP Resource Account Credit

    Can you confirm?

    3. Go thru item cost history of finished good item and see if there is any change in cost on transaction date of WIP Completion Transaction.
    Check the details of cost elements.

    Thanks,
    Hrishikesh
    (astrohrishi@gmail.com)
  • 5. Re: Assembly cost rollup wrong for averag cost org
    871137 Newbie
    Currently Being Moderated
    Hi,


    1. are all the 4 lines for same job? -- Yes
    please provide details of accounts on each of the 4 lines.

    For first 2 lines -- I00195-050002001-0-0-WB02-0-0-0 -- Inv valuation
    for 2nsd 2 lines -- I00195-052000000-0-0-WB02-0-0-0 -- WIP valuation

    2. have you setup any overheads?

    My guess is that the 4 lines corresponds to
    16625.29 WIP Assy Completion 30 => Inv Valuation Debit
    5689.43 WIP Assy Completion 30 => Inv Valuation Debit
    -16625.29 WIP Assy Completion -30 => WIP Material Account Credit
    -5689.43 WIP Assy Completion -30 => WIP Resource Account Credit

    Can you confirm? --Yes

    3. Go thru item cost history of finished good item and see if there is any change in cost on transaction date of WIP Completion Transaction.
    Check the details of cost elements.

    Distribution 4 lines are with date 02-FEB-2012 14:07:26
    If I look at record history of item costs form for this item last update date is -- 10-MAY-2012 15:19:03 and cost elements also of same date (costs button in item costs window)

    Here I can see costs as below

    Cost element basis rate or amount unit cost
    Material item 17.88 17.88
    Material item 0 0
    OSP item 0 0
    OSP item 0 0

    Please let me know if anything is required from my side to analyse the issue .

    Thanks for your response
    Vasudha.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points