Posted By

wnasich on 08/02/11


Tagged

clearing pos Openbravo


Versions (?)

Openbravo POS - Clearing transaction data


 / Published in: SQL
 

URL: http://wiki.openbravo.com/wiki/Projects/POS/Administrator_Guide#Clearing_Data

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.

  1. TRUNCATE `TICKETLINES`;
  2. TRUNCATE `TICKETS`;
  3. TRUNCATE `PAYMENTS`;
  4. TRUNCATE `TAXLINES`;
  5. TRUNCATE `RECEIPTS`;
  6. TRUNCATE `CLOSEDCASH`;
  7. TRUNCATE `STOCKDIARY`;
  8. TRUNCATE `STOCKCURRENT`;
  9. TRUNCATE `RESERVATION_CUSTOMERS`;
  10. TRUNCATE `RESERVATIONS`;
  11. UPDATE TICKETSNUM SET ID = 1;
  12. UPDATE PRODUCTS SET stockcost=0, stockvolume=0;
  13. UPDATE CUSTOMERS SET curdebt=0, curdate=NULL;

Report this snippet  

You need to login to post a comment.