No Items in stock, still a value

BK1960

Hi,

After Inventory Revaluation and Posting Inventory Costs to G/L there is still an inventory value, even though there are 0 items in stock.
I tried to adjust this with a Revaluation Journal, but after Inventory Revalutaion and Posting Inventory Costs to G/L all the original values are back again........???!!!

Customer has been upgraded to version 4.01 and came from 2.01.
The revaluation has to do with Item ledger entries in 2004 - 2006 and these years are closed already. Is this causing the problem?

Can somebody tell me what I should do?

Malajlo

Where are you looking for inv. value? In G/L?

BK1960

Hi,

I look in the Item Ledger Entries. The total of Column "Cost Amount (Actual)" has a value but there are no Items anymore.

Regards

Alex_Chow

Did you run the Adjust Cost - Item Entries process?

BK1960

Yes I did.

pri_1_ranjan

Was there any kind of upgrade done here ?

AdamRoue

Sorry are you saying the ILE entry has a cost amount actual? Well it will have unless the value is zero. You should see an in and an out, the inventory quantity will be zero, the valuation will be zero, but the item ledger entry will still show costs. Little confused to why you think the ILE cost would be reduced after it has been sold. Are you sure you are explaining this correctly?

I know if you book it out and manually alter the cost you can end up with a value and 0 in stock, but to correct this you can do this again, book it in at one cost, remove it by manually setting the cost to the inbound cost plus the difference. Think this is what I did anyway. Still you need to find out why people are manually changing the costs if this is the case.