Advanced Search

Openbravo POS - Clearing transaction data

/ Published in: SQL
Save to your folder(s)
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.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.