This is a bit weird, and I can only replicate it under a very specific set of circumstances - circumstances which arguably you shouldn't really find yourself in. Can you check the item and tell me what the Bom type is - component, built item, phantom etc?

This is a bit weird, and I can only replicate it under a very specific set of circumstances - circumstances which arguably you shouldn't really find yourself in. Can you check the item and tell me what the Bom type is - component, built item, phantom etc?

I actually have it happening on two products currently, both are set as component (They are a single physical item, not an built item or an ingredient in anything else.)

Even weirder then.

For the record : there's nothing about the revaluation routine that demands an item have its status set as 'inactive', even temporarily. However, at the end of the process the standard cost of the item is set to the new value and an update is called to persist the change to the database. It's during the update that Sage 200 is checking certain conditions of the item and coming to the conclusion that it should be inactive - which it subsequently tries to do, but then runs into further validation which says it can't be made inactive because of allocations/on order quantities. 

The only thing that should make Sage 200 think a component is ripe for making inactive is if it has no locations (Warehouses/Bins). At least as far as i can see in the code.  

Strange, they both definitely have both warehouses and bins set on them.

I have just done testing on our dev system and found some items that where showing the same error, however when I removed some of the warehouses listed on them it started to work.

These two items on our live system do have one extra warehouse listed on them that most items do not, however I can't remove it to test as one has stock in that warehouse and the other says it has open PO's.

Never mind, I seem to have worked it out.

Both of these items had four warehouses on them, but in each case one of those warehouses did not have a bin listed.
After removing that warehouse from the items, I was able to complete the revaluation.

Many thanks for pointing me in the right direction.