===== 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>