UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1573529 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1573529 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

Date: 2024-08-02 12:25:00

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1573714 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1573714 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

Date: 2024-08-02 13:05:32

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1573805 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1573805 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

Date: 2024-08-02 13:28:46

x Hide

UPDATE "product_warehouse_inventory" SET "last_used_date" = '2024-08-02', "write_uid" = 999, "write_date" = (now() at time zone 'UTC') WHERE id IN (35844, 35788, 35440, 336017, 36534, 35867, 332062, 122367);

Date: 2024-08-02 12:28:34

UPDATE "product_warehouse_inventory" SET "last_used_date" = '2024-08-02', "write_uid" = 1043, "write_date" = (now() at time zone 'UTC') WHERE id IN (18272, 375683, 375684, 25667, 18445, 18159, 22800, 16410);

Date: 2024-08-02 17:44:18

UPDATE "product_warehouse_inventory" SET "last_used_date" = '2024-08-02', "write_uid" = 980, "write_date" = (now() at time zone 'UTC') WHERE id IN (45185, 8962, 63491, 45315, 342792, 87946, 78347, 62860, 329868, 106254, 30093, 61457, 26770, 45076, 66325, 63513, 29854, 8735, 62624, 52256, 27554, 80803, 62884, 63396, 30115, 45086, 63528, 29610, 357036, 63405, 63536, 45232, 18610, 19251, 49972, 81205, 45110, 49975, 27572, 45241, 18619, 27581, 63550, 19262, 81216, 20414, 64451, 41284, 63178, 45258, 65144, 30154, 339279, 63187, 64468, 78931, 80467, 7508, 45144, 20439, 78810, 80477, 30048, 358881, 41313, 374499, 7523, 45161, 80881, 30070, 63352, 78329, 63483, 65151);

Date: 2024-08-02 15:16:39

x Hide

UPDATE "account_move" SET "message_main_attachment_id" = 5604276, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (1573529);

Date: 2024-08-02 12:25:22

UPDATE "account_move" SET "message_main_attachment_id" = 5605779, "write_uid" = 1022, "write_date" = (now() at time zone 'UTC') WHERE id IN (1575157);

Date: 2024-08-02 19:20:38

UPDATE "account_move" SET "message_main_attachment_id" = 5604292, "write_uid" = 1045, "write_date" = (now() at time zone 'UTC') WHERE id IN (1573548);

Date: 2024-08-02 12:28:05

x Hide

INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "asset_id", "auto_post", "branch_id", "campaign_id", "carrier_id", "commercial_partner_id", "company_id", "currency_id", "date", "discount_amount_applied", "edi_billed", "edi_split_lock", "expense_choice", "extract_remote_id", "extract_state", "fiscal_position_id", "invoice_cash_rounding_id", "invoice_date", "invoice_date_due", "invoice_incoterm_id", "invoice_origin", "invoice_origin_new", "invoice_payment_term_id", "invoice_product_qty", "invoice_user_id", "is_edi_bill", "is_move_sent", "journal_id", "medium_id", "move_type", "narration", "open_invoice", "order_type", "partner_bank_id", "partner_id", "partner_shipping_id", "payment_reference", "ref", "source_id", "state", "team_id", "to_check", "to_check_negative") VALUES (nextval('account_move_id_seq'), 1026, (now() at time zone 'UTC'), 1026, (now() at time zone 'UTC'), NULL, false, 44, NULL, 69, 33886, 1, 2, '2024-08-02', 0.0, false, false, NULL, -1, 'no_extract_requested', 3, NULL, NULL, '2024-09-01', NULL, 'B-12066', 'sale.order,157033', 94, 1.0, 983, false, false, 1, NULL, 'out_invoice', '', false, 'sale', 1, 33886, 36059, '', '002-455977', NULL, 'draft', 1, false, false) RETURNING id;

Date: 2024-08-02 12:25:47

x Hide

UPDATE "sale_order" SET "carrier_id" = NULL, "write_uid" = 1190, "write_date" = (now() at time zone 'UTC') WHERE id IN (122852);

Date: 2024-08-02 20:24:39

x Hide