BOM and adjustment

Meri
Meri Member Posts: 29
edited 2014-08-26 in NAV/Navision Classic Client
Hi all,

I wan to ask can anybody help with the following:

while making Bill of Material the total cost from the negative adjustment is different from the total cost of the positive adjustment for the adjusted amount on negative adjustment:

Item No. Document No. Entry Type: Adj. Cost Amount Actual
955900952 SOSTAVNICA 030414 Negative Adjmt. No -3.085,00
962615600 SOSTAVNICA 030414 Negative Adjmt. No -147.962,00
965900201 SOSTAVNICA 030414 Negative Adjmt. No -14.096,00
965900401 SOSTAVNICA 030414 Negative Adjmt. No -24.899,00
965900501 SOSTAVNICA 030414 Negative Adjmt. No -16.218,00
965900502 SOSTAVNICA 030414 Negative Adjmt. No -15.355,00
965900600 SOSTAVNICA 030414 Negative Adjmt. No -36.164,00
965900600 SOSTAVNICA 030414 Negative Adjmt. Yes 572
965900901 SOSTAVNICA 030414 Negative Adjmt. No -60.602,00
962612010 SOSTAVNICA 030414 Positive Adjmt. No 318.381,00

Total negative adjustment: - 317.809,00
Total positive adjustment: 318.381,00
Difference: 572,00

Why is this? :?

Best Regards,
Meri

Comments

  • pvrb
    pvrb Member Posts: 17
    Good evening,

    Although Navision has its Cost Adjustment batch, I trust this does not work for "assembly BOM". Or at leat in Nav 4.0, my cleverer colleague managed to modify Nav years ago, so that the cost adjustment was able to adjust also "assembly BOM" postings.
    Please note: Cost adjustment batch does work for "production BOM"; you have production orders, BOMs, routings, but this is a different "league" (one needs a pretty good licence as well).

    This is why the scenario you painted ("assembly BOM") is what I would assume happens a lot:
    1. Maybe initially the sum of costs on all relevant "negative adjustment" Item Ledger Entries = costs on the positive Item Ledger Entry
    2. As soon as any cost adjustment of "assembly components" (i.e. negative adjustment enrties) is posted in NAV, a difference will appear in Nav.

    The only solutions to your issue I could suggest are:
    (a) Nav modification or
    (b) Nav report/function which suggests revaluation journallines for the "positive adjustment" BOM item ledger entries.
    I trust (b) is easier to develop and test. When (a) is developed properly and works 100%, well, it is even better.

    Kind regards,
    Pavel

Categories