Cosetes del Openbravo POS

De Wikijoan
Dreceres ràpides: navegació, cerca

How can I reset / remove data in Openbravo POS

If you have been testing and configuring Openbravo POS and you want to remove all the receipts you created but maintaining the master data: Products, categories, ... Execute the following SQL commands:

DELETE FROM TICKETLINES;
DELETE FROM TICKETS;
DELETE FROM PAYMENTS;
DELETE FROM RECEIPTS;
DELETE FROM SHAREDTICKETS;
DELETE FROM STOCKDIARY;
DELETE FROM CLOSEDCASH;
UPDATE STOCKCURRENT SET UNITS = 0;

If you want also reset the receipt number counters, execute for HSQLDB and PostgreSQL:

ALTER SEQUENCE TICKETSNUM RESTART WITH 1;
ALTER SEQUENCE TICKETSNUM_REFUND RESTART WITH 1;
ALTER SEQUENCE TICKETSNUM_PAYMENT RESTART WITH 1;

for MySQL:

UPDATE TICKETSNUM SET ID = 1
UPDATE TICKETSNUM_REFUND SET ID = 1
UPDATE TICKETSNUM_PAYMENT SET ID = 1

for Oracle:

DROP SEQUENCE TICKETSNUM;
CREATE SEQUENCE TICKETSNUM START WITH 1;
DROP SEQUENCE TICKETSNUM_REFUND;
CREATE SEQUENCE TICKETSNUM_REFUND START WITH 1;
DROP SEQUENCE TICKETSNUM_PAYMENT;
CREATE SEQUENCE TICKETSNUM_PAYMENT START WITH 1;

If you want also delete products and categories, execute:

DELETE FROM STOCKCURRENT;
DELETE FROM PRODUCTS_COM;
DELETE FROM PRODUCTS_CAT;
DELETE FROM PRODUCTS;
DELETE FROM CATEGORIES;

If you want also delete customers, execute:

DELETE FROM CUSTOMERS;

If you forgot the administrator password and you cannot login as administrator, to reset the administrator password, execute the following SQL sentence:

UPDATE PEOPLE SET APPPASSWORD = NULL WHERE NAME = 'Admin';

Altres cosetes


creat per Joan Quintana Compte, gener 2009

Eines de l'usuari
Espais de noms
Variants
Accions
Navegació
IES Jaume Balmes
Màquines recreatives
CNC
Informàtica musical
joanillo.org Planet
Eines