Change product stock status

[RCG]

Is there an easy way to change the status of current products from 'stock
product' to 'non stock product'?

[RCG]

bump

[GTSageDev]

There's no way to do it in the user interface, so the safe way is to change the
product code / name of the existing stock products and add new non-stock items.

But it can be done by updating the database directly. In the database, the type
of stock item is held in AccountTable.AccountType - the relevant values are 6
for Stock Item or 7 for Non-stock item.

So if you're confident using SQL Management Studio, browse the AccountTable with
this query:

SELECT AccountType, DisplayNumber AS Code, Name
FROM AccountTable
WHERE (AccountType = 6) OR
(AccountType = 7)
ORDER BY Code

and change the AccountType from 6 to 7 for the required products.

You should probably also delete the related records in the
InventoryItemAccountTable (which hold the stock quantities) as these are not
present for Non-stock items. But they may be linked to documents (such as
orders or stock movements).

I cannot say this is a safe thing to do - for example, I haven't tested the
effects on any live sales or purchase orders - so try it on a copy company
first. And don't do it if you don't want to take the risk of corrupting your
database!

Geoff

"RCG" <R...@discussions.microsoft.com> wrote in message
news:146CD9DB-63EF-456F...@microsoft.com...

[RCG]

Thanks Geoff,

Will take the safe but long winded route rather than tinker with SQL database.

"GTSageDev" wrote:

> .
>