BOM Journal issue

xyh_self_mail
xyh_self_mail Member Posts: 4
edited 2005-12-31 in NAV/Navision Classic Client
I am from ESG China, Now I faced a issue about Bom Journal. the detail infromation as follows:

Cost methods: average A = B +C
before we run ACIE, the cost of A = the cost of B + the cost of C. the result is correct. but after we run ACIE, system will adjust the cost of A and B, but it will not adjust the cost of A, so the cost of A does not equal to the total cost of A and B.

Have anybody ever faced this situation? need your help, any suggestions?

thanks in advance!

Comments

  • ara3n
    ara3n Member Posts: 9,258
    which version are you using?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • xyh_self_mail
    xyh_self_mail Member Posts: 4
    System version is 3.7B. thanks
  • Shenpen
    Shenpen Member Posts: 386
    It's an old problem... some friends here report that it's solved in 4.0 although I did not check it.

    The solution is 3.7 is a bit tricky. I have did the following:

    - in BOM Ledger an output is always followed by the consumptions. So you can write a report that reads this, for every consumption line, reads the cost from item ledger / resource ledger, and calculates the actual total cost of the output

    - I am generating revaluation journal lines based on this data, which users can post

    so every month they run adjust costs - run this report - post the journal - run adjust costs again to forwards costs to COGS - post to the g/l

    you could try this, or simply go with Standard Costing, if that's acceptable... I think there is a function on the Item Card that calculates standard costs for BOM items, these costs won't be 100% correct of course as the price of the materials might fluctuate, but generally should be more correct than what you have now...
    Do It Yourself is they key. Standard code might work - your code surely works.
  • Shenpen
    Shenpen Member Posts: 386
    ... actually, I think if you adjust costs on every Friday f.e. and then recalculate the standard cost of BOM items, I think you should get approximately quite correct costs ...
    Do It Yourself is they key. Standard code might work - your code surely works.
  • xyh_self_mail
    xyh_self_mail Member Posts: 4
    Many thanks for your kind suggestion.

    I also tested it in version 4.0, the result is the same. could you tell where i can find the patch on this?

Categories