BonVivant's picture
Jun 26, 2013
2522 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
Friday, November 29, 2013 - 22:41
Thursday, October 17, 2013 - 04:58
Sunday, September 1, 2013 - 21:20
Monday, August 26, 2013 - 02:00
Friday, July 26, 2013 - 12:10