Inventory Value

trancu

we use Nav4.0!


Hello everybody

how can I set my Inventory Value for an Item to 0,00 ?

On the report Inventory Value it shows me:
Invoice Quantity: 309
Inventor: 0
Inv. Value Actual: 3000,00
Inv. Valuation Exp.: -1000,00
Inv. postet to G/L: 3000,00

I have already try with the Revaluation Journal:
(Functions -> calculate Inventory Value...)
But this Form just shows me:
Quantity: 309
Unit Cost (Calculated): 0,00
Inventory Value (Calculated): 0,00

Now I don't know how I can change the Inventory Value, because the Revaluation Journal says that the Inventory Value (Calculated) already has the value 0,00!

thanks for your answeres.

regards

johnson_alonso

What costing method do you use..? I think you maybe wrong before using the revaluation,



Rgds,
Johnson

Alex_Chow

Without using the revaluation journal, the easiest way would be to negative adjust your quantity, then positive adjust the items back in at 0 cost.

Roelof

Is there a way to revalue Inventory by Lot? It seems to be by location but I would like to have a solution to do this by Lot.
Any help is welcome.

Thanks!

ssingla

You can also use Zero Value Item functionality of the system.

Roelof

ssingla,

Can you be more specific? I would like to know more.

Alex_Chow

ssingla wrote:

You can also use Zero Value Item functionality of the system.

I think this only applies with using Return Reason Codes, not the actual revaluation of inventory.

fl

deadlizard wrote:

ssingla wrote:

You can also use Zero Value Item functionality of the system.

I think this only applies with using Return Reason Codes, not the actual revaluation of inventory.

No, "Inventory Value Zero" is a standard field in the item table. However it is standard not shown on the Item card. If you check this boolean for an item, you can have item ledger entries (inventory), but it wil never have a value.

ssingla

Zero Value items are those items which are charged to p&l as soon as they are purchased i.e. financially the consumption is booked at the instance of booking of purchase invoice but for internal control purpose you want to track the usage of the item. For E.g. Printing and stationery items.
In this case the system post ILE without any value therefore the standard entry of Inventory Debit and Direct Cost Applied Credit is not passed.

Roelof

But that would not solve my problem.
I do have inventory and Inventory Value. I'm also able to track that by lot. I'm also able to enter my Item Charges by Lot. I created that functionality. BUT... now I want to be able to revalue my Inventory by Lot. And that isn't standard in Navision or is there a way to do it?
Any help is welcome!

Alex_Chow

It's probably the easiest if you just do negative adjustment, then positive adjust it back in with the cost you want.

Roelof

Believe me. I tried that many times. But after run Adjust Cost it comes back to what it was before. I finally found a solution by setting the ValueEntry.Adjustment = yes after creating the ValueEntry record in CodeUnit 22. That works like a champ.