How to change item prices after quantity....

Mike1
Mike1 Member Posts: 78
edited 2008-04-29 in NAV/Navision Classic Client
Hello,

A customer of mine has posted a lot of item ledger entries. Unfortunately, they only posted the quantity, not the value.

As a result of that, when they try to run an Inventory Valuation List, the opening values are all € 0,-, even though they do have quantity in stock.

What do I have to do to make the opening values appear in the Inventory Valuation List, or is this simple impossible to do, because then you should have to change posted item entries?

Regards,

Mike
Man who put head on railroad track get splitting headache...

Answers

  • Revolution1210
    Revolution1210 Member Posts: 161
    A Revaluation Journal can be used for changing the inventory value of items.
    Ian

    www.NextEqualZero.com
    A technical eye on Dynamics NAV
  • Mike1
    Mike1 Member Posts: 78
    Hi Ian,

    Tried that already. At first it seems to work, but somehow it posts al item entries with a value € 0.
    Man who put head on railroad track get splitting headache...
  • Revolution1210
    Revolution1210 Member Posts: 161
    You may need to run Adjust Cost - Item Entries
    Ian

    www.NextEqualZero.com
    A technical eye on Dynamics NAV
  • Mike1
    Mike1 Member Posts: 78
    Hi Ian,

    Unfortunately, no success........
    Man who put head on railroad track get splitting headache...
  • AdamRoue
    AdamRoue Member Posts: 1,283
    So you load a revaluation journal, you alter teh cost and post the differences and you say it is posting this as zero? Can you go to the registers and track the values through and see what is being posted where - is it posting 0 after you alter the cost to adjust by x? Any modifications to the costing?
    The art of teaching is clarity and the art of learning is to listen
  • arindom
    arindom Member Posts: 52
    Make batch job .Search value 0 items in ILE .and update the entries aswelas value entry table .
  • Mike1
    Mike1 Member Posts: 78
    The answer is quite simple.

    Make sure that on your Item card the checkbox "Inventory Value Zero" is empty....... ](*,)
    Man who put head on railroad track get splitting headache...

Categories