Advanced Search

Return to Snippet

Revision: 49932
at August 2, 2011 14:10 by wnasich
Initial Code 
TRUNCATE `TICKETLINES`;
TRUNCATE `TICKETS`;
TRUNCATE `PAYMENTS`;
TRUNCATE `TAXLINES`;
TRUNCATE `RECEIPTS`;
TRUNCATE `CLOSEDCASH`;
TRUNCATE `STOCKDIARY`;
TRUNCATE `STOCKCURRENT`;
TRUNCATE `RESERVATION_CUSTOMERS`;
TRUNCATE `RESERVATIONS`;
update TICKETSNUM set ID = 1;
update PRODUCTS set stockcost=0, stockvolume=0;
update CUSTOMERS set curdebt=0, curdate=null;
Initial URL 
http://wiki.openbravo.com/wiki/Projects/POS/Administrator_Guide#Clearing_Data
Initial Description 
THIS PROCESS WILL CLEAR YOUR TRANSACTION DATA.
Openbravo POS. Clearing transaction data can be achieved with this SQL. This may be desirable in a new deployment when all products are loaded, staff have been trained and test runs are complete. This step would be taken when going live.
Initial Title 
Openbravo POS - Clearing transaction data
Initial Tags 

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL