BonVivant's picture
Jun 26, 2013
2433 views
Reputation: 79

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

** 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
1030 questions
E-Posta Facebook Twitter RSS Skype
Telefon (212) 252 0634