Synopsis

The Import Wizard only accepts or imports Stock Items. 

 

Procedure

The script will only work if there are no transactions created yet on the Items. To change the Stock Item Type to Non-Stock Item Type, see the steps below. 

1. Go to System Manager > Tools > Import Wizard. Import all your Inventory Items.

2. Back up your database.

3. Open the SQL Server Management Studio and run the script.

 

UPDATE InventoryItem

SET ItemType = 'Non-Stock',

ClassCode = ‘DEFAULT-NON-STOCK’,

GLClassCode = ‘DEFAULT-NON-STOCK'

EXEC GenerateInventoryStockTotal 'admin'

 

Note: This will update all the items in the inventory module. If you have specific items that you need to change the item type, you need to use the “Where” clause. 


Disclaimer: The Connected Business Team is not liable for any data loss in case the script is implemented in the database with transactions to the items.

 

Applicable Products:

All Interprise Suite versions

War diese Antwort hilfreich? 0 Benutzer fanden dies hilfreich (0 Stimmen)