BonVivant's picture
Jun 26, 2013
1723 views
Reputation: 79
+1
-47 likes
-1

Inventory to cero

There is any script to turn the inventory to cere like the transactions script?

1 answers

JohnSCS's picture
JohnSCS
Jul 01, 2013
Reputation: 271
+1
+7 likes
-1

** TRY AT YOUR OWN RISK **

I have tested, and the following lines removes all inventory movements.

Please backup your database BEFORE running this.

 

DELETE FROM [InventoryTransactionDocuments]
GO
DELETE FROM [InventoryTransactions]
GO
DELETE FROM [WarehouseConsumptions]
GO
DELETE FROM [PeriodicConsumptionItems]
GO
DELETE FROM [PeriodicConsumptions]
GO

We have already answers to
842 questions
E-Posta Facebook Twitter RSS Skype
Telefon (212) 252 0634