WITH updated_records AS ( UPDATE product_warehouse_inventory SET loc_check_qty = COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0) - COALESCE(qty_reserve, 0) WHERE loc_check_qty != (COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0) - COALESCE(qty_reserve, 0)) AND company_id = 1 RETURNING id, product_id, warehouse_id ) SELECT product_id, id AS warehouse_inventory_id, warehouse_id FROM updated_records;

Date: 2024-07-05 15:34:25

WITH updated_records AS ( UPDATE product_warehouse_inventory SET loc_check_qty = COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0) - COALESCE(qty_reserve, 0) WHERE loc_check_qty != (COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0) - COALESCE(qty_reserve, 0)) AND company_id = 1 RETURNING id, product_id, warehouse_id ) SELECT product_id, id AS warehouse_inventory_id, warehouse_id FROM updated_records;

Date: 2024-07-05 15:42:37

WITH updated_records AS ( UPDATE product_warehouse_inventory SET loc_check_qty = COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0) - COALESCE(qty_reserve, 0) WHERE loc_check_qty != (COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0) - COALESCE(qty_reserve, 0)) AND company_id = 1 RETURNING id, product_id, warehouse_id ) SELECT product_id, id AS warehouse_inventory_id, warehouse_id FROM updated_records;

Date: 2024-07-05 14:13:26

x Hide

UPDATE product_warehouse_inventory SET loc_check_qty = COALESCE(2.0, 0) + COALESCE(1.0, 0) - COALESCE(1.0, 0) WHERE product_id = 172218 AND warehouse_id = 42 AND company_id = 1;

Date: 2024-07-05 15:28:28

UPDATE product_warehouse_inventory SET loc_check_qty = COALESCE(2.0, 0) + COALESCE(4.0, 0) - COALESCE(3.0, 0) WHERE product_id = 171831 AND warehouse_id = 35 AND company_id = 1;

Date: 2024-07-05 15:24:11

UPDATE product_warehouse_inventory SET loc_check_qty = COALESCE(2.0, 0) + COALESCE(0.0, 0) - COALESCE(0.0, 0) WHERE product_id = 171891 AND warehouse_id = 44 AND company_id = 1;

Date: 2024-07-05 18:53:44

x Hide

update product_warehouse_inventory set qty_shipped_not_invoiced = CASE WHEN 14.0 IS NOT NULL THEN GREATEST ((112.0 - 108.0) + (14.0 - 14.0), 0) ELSE GREATEST ((112.0 - 108.0), 0) END where product_id = 238899 and warehouse_id = 43 and company_id = 1;

Date: 2024-07-05 13:34:39

update product_warehouse_inventory set qty_shipped_not_invoiced = CASE WHEN 8.0 IS NOT NULL THEN GREATEST ((2.0 - 2.0) + (8.0 - 8.0), 0) ELSE GREATEST ((2.0 - 2.0), 0) END where product_id = 214536 and warehouse_id = 41 and company_id = 1;

Date: 2024-07-05 14:09:46

update product_warehouse_inventory set qty_shipped_not_invoiced = CASE WHEN 0.0 IS NOT NULL THEN GREATEST ((3.0 - 3.0) + (0.0 - 0.0), 0) ELSE GREATEST ((3.0 - 3.0), 0) END where product_id = 208751 and warehouse_id = 36 and company_id = 1;

Date: 2024-07-05 19:22:49

x Hide

UPDATE "product_warehouse_inventory" SET "last_used_date" = '2024-07-05', "write_uid" = 1037, "write_date" = (now() at time zone 'UTC') WHERE id IN (63079, 26951, 52683, 28913, 102580, 89626, 102588, 96959);

Date: 2024-07-05 18:53:46

UPDATE "product_warehouse_inventory" SET "last_used_date" = '2024-07-05', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (45188, 45253, 64454);

Date: 2024-07-05 15:52:51

x Hide

UPDATE product_warehouse_inventory SET qty_available = 16.0 WHERE product_id = 239794 AND warehouse_id = 42 AND company_id = 1;

Date: 2024-07-05 11:50:22

UPDATE product_warehouse_inventory SET qty_available = 115.0 WHERE product_id = 194200 AND warehouse_id = 36 AND company_id = 1;

Date: 2024-07-05 17:59:08

UPDATE product_warehouse_inventory SET qty_available = 44000.0 WHERE product_id = 195844 AND warehouse_id = 43 AND company_id = 1;

Date: 2024-07-05 14:41:34

x Hide

UPDATE product_warehouse_inventory SET qty_reserve = 1.0 WHERE product_id = 211643 AND warehouse_id = 39;

Date: 2024-07-05 15:06:36

UPDATE product_warehouse_inventory SET qty_reserve = 3.0 WHERE product_id = 171831 AND warehouse_id = 35;

Date: 2024-07-05 15:23:00

UPDATE product_warehouse_inventory SET qty_reserve = 1.0 WHERE product_id = 189285 AND warehouse_id = 43;

Date: 2024-07-05 14:53:05

x Hide

UPDATE product_warehouse_inventory SET qty_mtd_sold = 2.0 - 0 WHERE product_id = 219747 AND warehouse_id = 42;

Date: 2024-07-05 15:21:45

UPDATE product_warehouse_inventory SET qty_mtd_sold = 2.0 - 0 WHERE product_id = 191053 AND warehouse_id = 41;

Date: 2024-07-05 14:08:44

UPDATE product_warehouse_inventory SET qty_mtd_sold = 2.0 - 0 WHERE product_id = 173802 AND warehouse_id = 43;

Date: 2024-07-05 19:03:01

x Hide

UPDATE product_warehouse_inventory SET qty_reserve = 0 WHERE product_id = 207553 AND warehouse_id = 42;

Date: 2024-07-05 13:30:19

UPDATE product_warehouse_inventory SET qty_reserve = 0 WHERE product_id = 219747 AND warehouse_id = 42;

Date: 2024-07-05 15:21:13

UPDATE product_warehouse_inventory SET qty_reserve = 0 WHERE product_id = 213571 AND warehouse_id = 36;

Date: 2024-07-05 19:28:59

x Hide

DELETE FROM sale_order_line WHERE id IN (436609);

Date: 2024-07-05 16:29:13

DELETE FROM sale_order_line WHERE id IN (438458);

Date: 2024-07-05 16:29:16

DELETE FROM sale_order_line WHERE id IN (438450);

Date: 2024-07-05 16:29:15

x Hide

UPDATE product_warehouse_inventory SET qty_on_order = 2.0 WHERE product_id = 172564 AND warehouse_id = 45;

Date: 2024-07-05 15:26:50

UPDATE product_warehouse_inventory SET qty_on_order = 3.0 WHERE product_id = 171831 AND warehouse_id = 37;

Date: 2024-07-05 15:42:34

UPDATE product_warehouse_inventory SET qty_on_order = 2.0 WHERE product_id = 171996 AND warehouse_id = 35;

Date: 2024-07-05 14:00:38

x Hide

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

Date: 2024-07-05 16:29:22

x Hide

UPDATE product_warehouse_inventory SET qty_ytd_sold = 871.9 WHERE product_id = 191077 AND warehouse_id = 37;

Date: 2024-07-05 18:18:14

UPDATE product_warehouse_inventory SET qty_ytd_sold = 2.0 WHERE product_id = 194474 AND warehouse_id = 35;

Date: 2024-07-05 14:22:56

UPDATE product_warehouse_inventory SET qty_ytd_sold = 1.0 WHERE product_id = 261282 AND warehouse_id = 38;

Date: 2024-07-05 12:01:07

x Hide

UPDATE product_warehouse_inventory SET loc_check_qty = COALESCE(-1.0, 0) + COALESCE(8.0, 0) - COALESCE(4.0, 0) WHERE product_id = 189183 AND warehouse_id = 36 AND company_id = 1;

Date: 2024-07-05 15:35:53

UPDATE product_warehouse_inventory SET loc_check_qty = COALESCE(-1.0, 0) + COALESCE(8.0, 0) - COALESCE(4.0, 0) WHERE product_id = 189183 AND warehouse_id = 36 AND company_id = 1;

Date: 2024-07-05 15:36:00

UPDATE product_warehouse_inventory SET loc_check_qty = COALESCE(-1.0, 0) + COALESCE(0.0, 0) - COALESCE(0.0, 0) WHERE product_id = 259759 AND warehouse_id = 35 AND company_id = 1;

Date: 2024-07-05 15:00:32

x Hide

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 != 1518880 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 != 1518880 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

Date: 2024-07-05 16:17:57

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 != 1518129 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 != 1518129 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

Date: 2024-07-05 13:27:42

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 != 1518007 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 != 1518007 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

Date: 2024-07-05 13:08:17

x Hide

UPDATE product_warehouse_inventory SET qty_on_order = 0 WHERE product_id = 213571 AND warehouse_id = 36;

Date: 2024-07-05 19:29:34

UPDATE product_warehouse_inventory SET qty_on_order = 0 WHERE product_id = 197946 AND warehouse_id = 42;

Date: 2024-07-05 15:34:16

UPDATE product_warehouse_inventory SET qty_on_order = 0 WHERE product_id = 219314 AND warehouse_id = 42;

Date: 2024-07-05 15:21:26

x Hide

UPDATE "account_move" SET "message_main_attachment_id" = 5548770, "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (1518130);

Date: 2024-07-05 13:27:54

UPDATE "account_move" SET "message_main_attachment_id" = 5549334, "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (1518880);

Date: 2024-07-05 16:18:22

x Hide

UPDATE "sale_order" SET "amount_total" = '299.59', "amount_untaxed" = '299.59', "carrier_id" = 1, "margin" = '83.88', "margin_percent" = 0.27998264294535863, "unpaid_amount_total" = '299.59', "write_uid" = 1271, "write_date" = (now() at time zone 'UTC') WHERE id IN (150033);

Date: 2024-07-05 16:29:37

x Hide

UPDATE product_warehouse_inventory SET qty_available = 0 WHERE product_id = 191077 AND warehouse_id = 41 AND company_id = 1;

Date: 2024-07-05 14:08:25

UPDATE product_warehouse_inventory SET qty_available = 0 WHERE product_id = 203937 AND warehouse_id = 35 AND company_id = 1;

Date: 2024-07-05 16:26:33

UPDATE product_warehouse_inventory SET qty_available = 0 WHERE product_id = 176730 AND warehouse_id = 36 AND company_id = 1;

Date: 2024-07-05 16:13:35

x Hide

UPDATE product_warehouse_inventory SET qty_mtd_sold = 0 - 0 WHERE product_id = 213571 AND warehouse_id = 36;

Date: 2024-07-05 19:29:10

UPDATE product_warehouse_inventory SET qty_mtd_sold = 0 - 0 WHERE product_id = 211643 AND warehouse_id = 39;

Date: 2024-07-05 15:06:46

UPDATE product_warehouse_inventory SET qty_mtd_sold = 0 - 0 WHERE product_id = 172202 AND warehouse_id = 35;

Date: 2024-07-05 16:34:37

x Hide

UPDATE "sale_order" SET "amount_total" = '279.07', "amount_untaxed" = '279.07', "core_bank_transaction" = false, "margin" = '78.14', "margin_percent" = 0.2800014333321389, "unpaid_amount_total" = '279.07', "write_uid" = 1271, "write_date" = (now() at time zone 'UTC') WHERE id IN (150033);

Date: 2024-07-05 16:29:22

x Hide

UPDATE "product_warehouse_inventory" SET "unit_cost" = 97.45, "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (14769);

Date: 2024-07-05 16:21:01

x Hide

UPDATE "sale_order" SET "core_bank_transaction" = false, "write_uid" = 1271, "write_date" = (now() at time zone 'UTC') WHERE id IN (150033);

Date: 2024-07-05 16:30:00

x Hide

UPDATE product_warehouse_inventory SET qty_in_transist = 10.0 - 7.0, last_intra_company_receipt_date = '2024-06-25T17:05:50'::timestamp, last_intra_company_qty = 1.0 WHERE product_id = 238278 AND warehouse_id = 41;

Date: 2024-07-05 12:39:48

UPDATE product_warehouse_inventory SET qty_in_transist = 297.0 - 297.0, last_intra_company_receipt_date = '2024-07-05T17:51:54'::timestamp, last_intra_company_qty = 6.0 WHERE product_id = 188107 AND warehouse_id = 36;

Date: 2024-07-05 17:51:57

UPDATE product_warehouse_inventory SET qty_in_transist = 3.0 - 2.0, last_intra_company_receipt_date = '2024-07-01T17:45:18'::timestamp, last_intra_company_qty = 2.0 WHERE product_id = 176845 AND warehouse_id = 35;

Date: 2024-07-05 13:10:43

x Hide

UPDATE product_warehouse_inventory SET qty_mtd_sold = 0 - 2.0 WHERE product_id = 237127 AND warehouse_id = 41;

Date: 2024-07-05 12:50:20

UPDATE product_warehouse_inventory SET qty_mtd_sold = 0 - 4.0 WHERE product_id = 238648 AND warehouse_id = 43;

Date: 2024-07-05 13:15:04

UPDATE product_warehouse_inventory SET qty_mtd_sold = 0 - 4.0 WHERE product_id = 237210 AND warehouse_id = 35;

Date: 2024-07-05 12:54:56

x Hide