i want to clear the work period how can i do that ???
What do you mean? Ending the work period each day “clears” the work period
i want to clear the work period mean i want to delete my work period
You cant just delete a WP. You can clear all data however.
how i can do it please
If you have Database Tools module installed you can create default tasks and then use the Clear all transaction Data. Once you install Database Tools module you find it under Settings > Database Tools
To install Database Tools module its under Samba Market. You would need to purchase a license for it first from www.sambamarket.com
An alternative would be to run this script in MSSMS.
DELETE FROM [TicketEntities]
GO
DELETE FROM [Tickets]
GO
DELETE FROM [AccountTransactionDocuments]
GO
DELETE FROM [AccountTransactions]
GO
DELETE FROM [AccountTransactionValues]
GO
DELETE FROM [Calculations]
GO
DELETE FROM [CostItems]
GO
DELETE FROM [InventoryTransactionDocuments]
GO
DELETE FROM [InventoryTransactions]
GO
DELETE FROM [Orders]
GO
DELETE FROM [PaidItems]
GO
DELETE FROM [PeriodicConsumptionItems]
GO
DELETE FROM [PeriodicConsumptions]
GO
DELETE FROM [ProductTimerValues]
GO
DELETE FROM [Payments]
GO
DELETE FROM [WarehouseConsumptions]
GO
DELETE FROM [WorkPeriods]
GO
DELETE FROM [EntityStateLogs]
GO
UPDATE [Numerators] SET Number = 0
GO
UPDATE [EntityStateValues] SET EntityStates = '[{"S":"Available","SN":"Status"}]' Where EntityStates like '%Status%'
GOok thank you but i cant clear the only the work period
look i have make a new brunch so i install the prog again and take the same data base and install it on the program but i want to clear the work period
Like I said you can not clear just a work period. The script I showed you will clear all transaction data. It will not clear your menu etc.
how can i use the script ?
Clear transactions is a default task in the database tools module.
