Issue in automatic cost adjustment in Inventory.

(0) Share

Report

Posted on by Surath

332

Hey Guys!

We posted few inventory adjustments through Physical Inventory journal with one document number in 2013. There are automatic cost adjustments posted throughout the years for this Doc number since the posting date up until now. 2013 inventory period is already closed, but adjustments are still posting for the same document number.

How can I stop the automatic cost adjustment posting for this document?

Thanks,

Surath

*This post is locked for comments

All responses (17)

Answers (0)

Suggested answer

Alexander Ermakov 28,094 on at

Like (2)

Report

RE: Issue in automatic cost adjustment in Inventory.

NAV will continue posting the adjustments with this document number untill all the items are gone and the period is closed. If period is closed and still you have open entries, with cost, calculated by average method, system will post it in nearest open period. As you mentioned you have many items in this document, you just need to wait untill all the item entrues will be closed. If you do not want to wait, try writing them off to technical account to zero the balance, and then generate new item cards and return that quantity and value back from technical account.
Surath 332 on at

Like (0)

Report

RE: Issue in automatic cost adjustment in Inventory.

Hi Tharanga,

Seems like these is no solution to my situation, rather an explanation. But the answers sure were helpful for me to get a better idea about the situation in hand.
Surath 332 on at

Like (1)

Report

RE: Issue in automatic cost adjustment in Inventory.

Hi Indika,

1. Average Cost Calculation Type : Item

2. Average cost Period: Day

Since there are more than 1500 entries in the original document, if you could specify fields which you want in the screenshot I can share them.

Thank you.
Tharanga Chandrasekara 23,116 on at

Like (0)

Report

RE: Issue in automatic cost adjustment in Inventory.

Hi Surath,

Were you able to get a satisfactory level answer from the forum?
Suggested answer

Indikauk 1,759 on at

Like (0)

Report

RE: Issue in automatic cost adjustment in Inventory.

Hi,

in your inventory setup what are the value you selected for below two fields

1. Average Cost Calculation Type

2. Average cost Period.

also if you can attached a screen shot of item ledger entry those adjustment also will help us get clear idea.
Surath 332 on at

Like (0)

Report

RE: Issue in automatic cost adjustment in Inventory.

Thanks Indika,

The problem was having the adjustment entries posted to the G\L throughout the year. But it seems that's the way the system is configured to handle the process.
Suggested answer

Indikauk 1,759 on at

Like (0)

Report

RE: Issue in automatic cost adjustment in Inventory.

Hi Surath

I think Your Adjustment Entries has Crated Problem to the Average Cost By doing the Adjustment You have Change the Average cost and That is Why Every it passing Cost Adjustment.

By Closing Inventory Period What you do is you Stop Posting Adjustment Entries to Closed Year and what ever Adjustment Occur That will Posted to the Open Year (This is useful when you finalized Monthly Accounts or Audited Accounts System should not pass any automatic Entry to Closed Year)

Thanks

Indika
Surath 332 on at

Like (0)

Report

RE: Issue in automatic cost adjustment in Inventory.

Thank you!
JUBEL THOMAS JOY 238 on at

Like (0)

Report

RE: Issue in automatic cost adjustment in Inventory.

Yes.
Surath 332 on at

Like (0)

Report

RE: Issue in automatic cost adjustment in Inventory.

Thanks Jubel for the explanation. Hope the adjustments will be done after these 7 entries get closed.