Zero Quantity and Positive Inventory Value

gvolkov

Hello guys, i know this has been discussed already, but i am not having luck fixing this.
Here is the situation. One of the items has 0.04 cents value, but no quantity. This 0.04 cents is a result of the adjustment. So to fix this, i post a positive adjustment. Run Adjust Cost and post negative adjustment. At this point inventory value is 0 ( the way it should be ). But after i run the Adjust Cost again, i again have 0.04 cents in there. The item is dead item, it will not be used anymore. All i want is to get rid of this 0.04 cents, and put it where it belongs the right way.

Thanks

matttrax

I don't know all the ins and outs of adjust cost and what it does, so this may not work. But how about:

1) Positive adjustment to get the item back in there
2) Revaluation journal to writedown the cost from $0.04 to $0.00
3) Negative adjustment to get it out of the system

For all I know that violates all kinds of account rules, but it's worth a try.

gvolkov

For all I know that violates all kinds of account rules, but it's worth a try.

I know this would work, but i am trying to get it where it belongs. Since all qty was sold out, maybe it should be in COGS, right?
I am trying to prevent this from happening in the first place, so that we dont have to rub our tummy, pat our heads, and post journals to fix these values.

Alex_Chow

gvolkov wrote:

For all I know that violates all kinds of account rules, but it's worth a try.

I know this would work, but i am trying to get it where it belongs. Since all qty was sold out, maybe it should be in COGS, right?
I am trying to prevent this from happening in the first place, so that we dont have to rub our tummy, pat our heads, and post journals to fix these values.

Is the inventory value 0 when you run it as of today? Or for a specific period?

What version of NAV are you using?

AdamRoue

The point Alex makes about timing is critical. I have seen users try to find values on reports that are not values now, so you cannot find them in the ledgers, they have become 0.00. I would recommend as a starting point of setting really wide dates on the report for the item, is the 0.04 real? Is the 0.04 a balance on the ledger? There is nothing to day it should be in COGS until you know it exists!

I remember a while back with 4 you could create this situation and many differences on a variety of reports. I seem to remember we had an issue with the users altering the cost on credit notes, or perhaps it was on the item journal, I cannot remember the details, but we were able to track it down to specific transactions after a lot of investigation.

gvolkov

Yeah, it is as of today. And yes it should be in COGS. And the interesting part is that after i run a positive adjustment and then negative adjustment, the value is correct. (zero) BUt after i run adjust cost again, it goes back to 0.04 cents.

AdamRoue

Dont run it as of today, run it 10 years in teh future, see if anyone has posted any future based entires.

gvolkov

i can identify the entry, its the last entry in the Value entries.
It is an 'Adjustment' entry, and it does apply to another earlier entry. It does have 'inventory adjustment' as the Source Code. And it was posted in 2008. So its fine that something was adjusted in past, but i would expect this amount to be in COGS.

Alex_Chow

Is this a recurring problem in your database? Or was this caused by an application of a service pack? Upgrade? Custom process?

What version of NAV are you running?

gvolkov

Does not look like a recurring problem. Looks more like certain things beeing done 'wrong way' or 'different way'. So far i can precisely identify them. This cost adjustment just makes me furious. At the same time, i respect the fact that NAV takes care of the cost adjustments. THis adjustment just doesnt get forwarded to COGS no matter how hard i try.

Alex_Chow

If it's not a recurring problem, then I would suggest you get it to 0 by what matttrax suggested.

What version of NAV are you using?

gvolkov

This is a 4.0SP2 database on 5.0 client.

Alex_Chow

gvolkov wrote:

This is a 4.0SP2 database on 5.0 client.

Just curious, are you guys using manufacturing?

You mentioned you pinned down the problem. What exactly did the user do to get this 0.04 value?

gvolkov

No Manufacturing. It is an adjustment entry linked to a sale.

Alex_Chow

gvolkov wrote:

No Manufacturing. It is an adjustment entry linked to a sale.

Were there anything special done to the sale get the adjustment entry?