This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ===== Resend invoices to Hacienda ===== <code> update public.pos_order set state_tributacion=null where state_tributacion=''; </code> ===== Cancel NC orders to send to Hacienda ===== <code> UPDATE public.pos_order SET state_tributacion = 'no_aplica' WHERE tipo_comprobate = 'NC'; </code> ===== Done orders on POS ===== <code> update public.pos_order set state='done' where state='paid'; </code> ===== Cancel odoo POS orders ===== <code> UPDATE public.pos_order SET state = 'cancel' WHERE state = 'paid'; </code> <code> UPDATE public.pos_order SET state = 'cancel' WHERE state = 'paid' and session_id = 272; </code> Determine open POS sessions for more than 24 hours: <code> select name,start_at,create_date,state from pos_session where state !='closed' and start_at < now() - interval '24 hour'; </code> ===== Cancel odoo orders ===== <code> update public.account_invoice SET number_electronic = '50602101900020453068900100001010000000138174933838' where number_electronic = '50602101900020453068900100001010000000160174933838' update public.account_invoice SET sequence = '00100001010000000138' where sequence = '00100001010000000160' update public.account_invoice SET state_tributacion = 'aceptado' where sequence = '00100001010000000138' </code> ===== Cancel odoo tiquete electrónico ===== <code> update public.pos_order set state_tributacion='no_aplica' where number_electronic = '50603111900310276306900800001040000009673105031119'; update public.pos_order set state_tributacion='no_aplica' where amount_total = '0'; </code>