Change of item's cost method

[Former Member]

Hello,

Our customer is planning to change the cost method for all existing 2000 items.

We went through note 869071 and it seems that according to it, they need to close all open documents.

They have a lot of open documents for each item which means that it would be almost impossible for

them to close them all and then re-create them. Many of their sales and purchase documents have

references that go through approval processes and can not be just closed and re-opened with new numbers.

Please advise if there is a way to bypass this obstacle.

Thanks in advance

Revital

[Former Member]

Hi

This is an I think moment.

We considered doing this in 2005 but we could not for 2 reasons:

1. any item linked to a BoM had to be removed from the BoM

2. you could not change the accounting method (costing method) if there was a transaction history for the current year.

It appears to have changed for 2007 and as long as the item has no stock then you can change the accounting method. If I was you I would create a duplicate database, export a list of all stock and current price to excel and use DTW to change all stock quantities to zero. Then use the stock valuation method window to change the method and re-import the stock quantities. There may be a small discrepancy on the GL as valuations differ slightly depending on what valuation is used.

If it works please let me know as I may propose that we make the change.

Regards

Stewart Clark

[former_member583013]

Hi Stewart,

Your explanation and idea is very logical. Thanks for sharing.

Suda

[former_member583013]

To Change the Item's Costing method, the only thing you need is to clear the OnHand quantities for the items.

[Former Member]

Hi

The answer is NO . Otherway around is setting up a new company and transfer everything .

Hope this helps

Bishal