How to adjust Item Cost of an item manualy

nota

Hi Navision Gurus!
I have started loving this forum as everytime i put a query it is met with adequate response.

Today i would like to ask you Gurus that my Item Adjust batch file is not working on a few items and now i would like to adjust them manualy.

Can anybody help me in this regard? it's urgent!

Thanks!

muksha

Adjust cost Item batch job do many things which can't be done manually. If you require only to change the unit cost than you can revaluate your inventory with the correct rate.

Alex_Chow

nota wrote:

Today i would like to ask you Gurus that my Item Adjust batch file is not working on a few items and now i would like to adjust them manualy.

What do you mean that it doesn't work on a few items. What problems are you having?

nota

can we directly go to the table and change the cost?

Deep

can we directly go to the table and change the cost?

Cost is never changed in the same entry, but is always adjusted with new adjusting entries.
So never try to change the posted entries, else you end up in a much fierce firefighting.

Alex_Chow

nota wrote:

can we directly go to the table and change the cost?

NNNOOOOOOOO!!!!!!!!!!!!!!!!!! :shock:

muksha

can we directly go to the table and change the cost?

Try it system will not allow you to change the unit cost even in the Table. In fact you should never do such things any time it will impact your costing.

ssingla

nota wrote:

can we directly go to the table and change the cost?

Modification of posted entries to rectify the mistakes from back end or by batch jobs is certainly a no-no thing. You will end up with a lot of mess including mismatching of interdependent tables, zero system integrity etc.

You can use the standard ways of Physical Inventory Journal and Revaluation Journal.

AdamRoue

Alex Chow wrote:

nota wrote:

Today i would like to ask you Gurus that my Item Adjust batch file is not working on a few items and now i would like to adjust them manualy.

What do you mean that it doesn't work on a few items. What problems are you having?

This is the question you need to answer - you ignored it by asking if you could manually change the data in the table, which is obviously no.

ssingla

AdamRoue wrote:

Alex Chow wrote:

nota wrote:

Today i would like to ask you Gurus that my Item Adjust batch file is not working on a few items and now i would like to adjust them manualy.

What do you mean that it doesn't work on a few items. What problems are you having?

This is the question you need to answer - you ignored it by asking if you could manually change the data in the table, which is obviously no.

Don't know why but quite regularly I found people who prefers to modify the data at back end to rectify the mistakes or block the inconsistency function to allow posting [-o< [-o<

David_Singleton

Alex Chow wrote:

NNNOOOOOOOO!!!!!!!!!!!!!!!!!!

Ah yes, my favorite answer

Alex_Chow

ssingla wrote:

Don't know why but quite regularly I found people who prefers to modify the data at back end to rectify the mistakes or block the inconsistency function to allow posting [-o< [-o<

Yes, this is quite disturbing indeed... But I highly doubt this is only limited to NAV. I'd bet this case happens in SAP, Oracle, etc as well.

Savatage

The answer of "revaluation journal" was already given. 8)

Alex_Chow

Savatage wrote:

The answer of "revaluation journal" was already given. 8)

But to run revaluation journal, you must run ACIE first.

nota

Thanks everyone who has contributed. The best solution seems to be the "Revaluation Journal". Can someone explain what needs to be run before revaluation journal? or are there any particular steps to be followed.

Thanks a lot!

ssingla

Run Adjust Cost Batch job before revaluing the inventory.

Alex_Chow

nota wrote:

Thanks everyone who has contributed. The best solution seems to be the "Revaluation Journal". Can someone explain what needs to be run before revaluation journal? or are there any particular steps to be followed.

Thanks a lot!

Wow.... nota completely ignored me...

ssingla

Alex Chow wrote:

But to run revaluation journal, you must run ACIE first.

nota

Dear Gurus! I am sorry if i couldn't reply to someone's query as i cannot or don't want to reveal some info. due to company policies. Hope u will understan.
Tanks Everyone.

gvolkov

How would you revalue item that is no longer in inventory (qty = 0) and still has inventory value?

I am looking for the most proper way. I could positive adjust it, revalue, and negative adjust it i guess. But it just seems wrong. It seems wrong to have positive value with 0 qty in the first place.