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

[ Date: 2023-01-24 19:09:59 ]

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

[ Date: 2023-01-24 20:36: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 != 358192 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 != 358192 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-01-24 19:10:08 ]

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

[ Date: 2023-01-24 16:25:02 ]

UPDATE "account_move" SET "message_main_attachment_id" = 158921, "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (357555);

[ Date: 2023-01-24 16:44:21 ]

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

[ Date: 2023-01-24 15:26:40 ]

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

[ Date: 2023-01-24 15:26:46 ]

UPDATE "account_move" SET "message_main_attachment_id" = 159467, "write_uid" = 1223, "write_date" = (now() at time zone 'UTC') WHERE id IN (358594);

[ Date: 2023-01-24 20:52:12 ]

UPDATE "account_move" SET "message_main_attachment_id" = 158285, "write_uid" = 983, "write_date" = (now() at time zone 'UTC') WHERE id IN (356697);

[ Date: 2023-01-24 14:35:03 ]

UPDATE "account_move" SET "message_main_attachment_id" = 158343, "write_uid" = 968, "write_date" = (now() at time zone 'UTC') WHERE id IN (356737);

[ Date: 2023-01-24 14:42:17 ]

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

[ Date: 2023-01-24 16:38:43 ]

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

[ Date: 2023-01-24 13:37:46 ]

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

[ Date: 2023-01-24 13:57:50 ]

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

[ Date: 2023-01-24 14:56:44 ]

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

[ Date: 2023-01-24 15:02:02 ]

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

[ Date: 2023-01-24 14:52:22 ]

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

[ Date: 2023-01-24 19:06:33 ]

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

[ Date: 2023-01-24 15:26:46 ]

UPDATE "account_move" SET "message_main_attachment_id" = 159454, "write_uid" = 1223, "write_date" = (now() at time zone 'UTC') WHERE id IN (358578);

[ Date: 2023-01-24 20:49:05 ]

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

[ Date: 2023-01-24 15:26:51 ]

UPDATE "stock_move" SET "is_done" = true, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (237441, 233509, 233510, 233518, 233520, 233521, 233522, 233523, 233524, 233528, 233529, 233530, 233534, 233535, 233536, 233537, 233545, 233547, 233548, 233549, 233552, 233553, 233554, 233555, 233556, 233561, 233562, 233564, 233565, 233567, 233568, 233570, 233571, 233572, 233573, 233575, 233576, 233577, 233581, 233584);

[ Date: 2023-01-24 18:21:23 ]

UPDATE "stock_move" SET "reference" = '02-G/IN/02069', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (164480, 164482, 164483, 164485, 164486, 164425, 164426, 164427, 164428, 164429, 164431, 164432, 164433, 164434, 164435, 164437, 164438, 164439, 164441, 164442, 164443, 164444, 164445, 164446, 164447, 164448, 164449, 164450, 164451, 164452, 164454, 164455, 164457, 164458, 164460, 164462, 164464, 164465, 164466, 164470, 164472, 164476, 164479);

[ Date: 2023-01-24 21:04:12 ]

UPDATE "stock_move" SET "is_done" = true, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (232448, 232451, 232452, 232453, 232454, 232455, 232456, 232458, 232459, 232460, 232461, 232464, 232465, 232466, 232471, 232472, 232473, 232474, 232477, 232861, 232478, 232479, 232481, 232482, 232485, 236967, 232489, 236970, 232491, 232494, 236977, 232497, 232500, 236982, 232502, 232506, 232507, 232446, 232447);

[ Date: 2023-01-24 16:18:39 ]

UPDATE "stock_move" SET "reference" = '02-G/IN/02070', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (164480, 164482, 164483, 164485, 164486, 164425, 164426, 164427, 164428, 164429, 164431, 164432, 164433, 164434, 164435, 164437, 164438, 164439, 164441, 164442, 164443, 164444, 164445, 164446, 164447, 164448, 164449, 164450, 164451, 164452, 164454, 164455, 164457, 164458, 164460, 164462, 164464, 164465, 164466, 164470, 164472, 164476, 164479);

[ Date: 2023-01-24 21:05:22 ]

COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;

[ Date: 2023-01-24 09:01:02 ]

UPDATE "stock_move" SET "picking_id" = 56864, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (164480, 164482, 164483, 164485, 164486, 164425, 164426, 164427, 164428, 164429, 164431, 164432, 164433, 164434, 164435, 164437, 164438, 164439, 164441, 164442, 164443, 164444, 164445, 164446, 164447, 164448, 164449, 164450, 164451, 164452, 164454, 164455, 164457, 164458, 164460, 164462, 164464, 164465, 164466, 164470, 164472, 164476, 164479);

[ Date: 2023-01-24 21:03:39 ]

UPDATE "stock_move" SET "date" = '2023-01-24 18:20:07', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (237441, 233510, 233518, 233520, 233521, 233522, 233523, 233524, 233528, 233529, 233530, 233534, 233535, 233536, 233537, 233545, 233547, 233548, 233549, 233552, 233553, 233554, 233555, 233556, 233561, 233562, 233564, 233565, 233567, 233568, 233570, 233571, 233572, 233573, 233575, 233576, 233577, 233581, 233584);

[ Date: 2023-01-24 18:20:39 ]

UPDATE "stock_move" SET "picking_id" = 56870, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (164480, 164482, 164483, 164485, 164486, 164425, 164426, 164427, 164428, 164429, 164431, 164432, 164433, 164434, 164435, 164437, 164438, 164439, 164441, 164442, 164443, 164444, 164445, 164446, 164447, 164448, 164449, 164450, 164451, 164452, 164454, 164455, 164457, 164458, 164460, 164462, 164464, 164465, 164466, 164470, 164472, 164476, 164479);

[ Date: 2023-01-24 21:04:51 ]

UPDATE "stock_move" SET "is_done" = true, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (209408, 209409, 209411, 209412, 209415, 209416, 209417, 209418, 209419, 235000, 209966, 237365, 237367, 237376, 209360, 209361, 209362, 209365, 209367, 209368, 209369, 209370, 209371, 209372, 209373, 209376, 209377, 209379, 209381, 209382, 209383, 209384, 209386, 209396, 209399, 209400, 209401, 209405, 209406, 209407);

[ Date: 2023-01-24 17:53:50 ]

UPDATE "stock_move" SET "scrapped" = false, "state" = 'confirmed', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (237483, 237484, 237485, 237486, 237487, 237488, 237489, 237490, 237491, 237492, 237493, 237494, 237495, 237496, 237497, 237498, 237499, 237500, 237501, 237502, 237503, 237504, 237505, 237506, 237507, 237508, 237509, 237510, 237511, 237512, 237513, 237514, 237515, 237517);

[ Date: 2023-01-24 18:28:55 ]

UPDATE "stock_move" SET "date" = '2023-01-24 16:17:29', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (232448, 232451, 232452, 232453, 232454, 232456, 232458, 232459, 232460, 232461, 232464, 232465, 232466, 232471, 232472, 232473, 232474, 232477, 232478, 232479, 232861, 232481, 232482, 232485, 236967, 232489, 236970, 232491, 232494, 232497, 236977, 232500, 232502, 236982, 232506, 232507, 232447);

[ Date: 2023-01-24 16:17:57 ]

UPDATE "stock_move" SET "date" = '2023-01-24 17:52:55', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (209408, 209409, 209411, 209412, 209415, 209416, 209417, 209418, 209419, 235000, 209966, 237365, 237367, 237376, 209361, 209362, 209365, 209368, 209369, 209370, 209371, 209372, 209373, 209376, 209377, 209379, 209381, 209384, 209386, 209396, 209399, 209400, 209401, 209405, 209406, 209407);

[ Date: 2023-01-24 17:53:23 ]

UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (237483, 237484, 237485, 237486, 237487, 237488, 237489, 237490, 237491, 237492, 237493, 237494, 237495, 237496, 237497, 237498, 237499, 237500, 237501, 237502, 237503, 237504, 237505, 237506, 237507, 237508, 237509, 237510, 237511, 237512, 237513, 237514, 237515, 237516, 237517);

[ Date: 2023-01-24 18:29:17 ]

COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;

[ Date: 2023-01-24 09:02:19 ]

with data as ( select distinct shl.id as record, 1775, shl.id as ref, 'Sales History' as ref_code, shl.product_id as product_id, shl.invoice_date as invoice_date, shl.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, shl.selling_branch as selling_branch, st.id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_history_line as shl LEFT JOIN stock_warehouse as st ON st.branch_id = shl.selling_branch LEFT JOIN product_product as pp ON pp.id = shl.product_id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id where shl.selling_branch = 44 and shl.sales_obtain != 'direct' and shl.product_id is not null and shl.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and shl.invoice_date >= '2017-01-24 22:20:05' and shl.invoice_date <= '2023-01-24 22:20:05' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127) and pt.inventory_vendor_id in (3091) and pp.id not in (239248, 239415, 173215, 192883, 197258, 190564, 177068, 173289, 173962, 173213, 203231, 190550, 173211, 177379, 187914, 180822, 197276, 188418, 188396, 176894, 173589, 206528, 206638, 178699, 188463, 227034, 179337, 181338, 190563, 174247, 174255, 173304, 177858, 177532, 181422, 199620, 178803, 180305, 204988, 190715, 177544, 184510, 190525, 173306, 190625, 190565, 177543, 184443, 241006, 180741, 174026, 206542, 178741, 180352, 181401, 181429, 184468, 238885, 173808, 173475) UNION ALL ( select distinct sol.id as record, 1775, so.id as ref, 'Sale Order' as ref_code, sol.product_id as product_id, am.invoice_date as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_order_line sol LEFT JOIN product_product as pp ON sol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN sale_order as so ON sol.order_id = so.id LEFT JOIN sale_order_line_invoice_rel as solrel ON solrel.order_line_id = sol.id LEFT JOIN account_move_line as aml ON aml.id = solrel.invoice_line_id LEFT JOIN account_move as am ON am.id = aml.move_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where sol.branch_id = 44 and sol.product_id is not null and sol.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and am.invoice_date >= '2017-01-24 22:20:05' and am.invoice_date <= '2023-01-24 22:20:05' and so.state in ('done', 'sale') and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127) and pt.inventory_vendor_id in (3091) and pp.id not in (239248, 239415, 173215, 192883, 197258, 190564, 177068, 173289, 173962, 173213, 203231, 190550, 173211, 177379, 187914, 180822, 197276, 188418, 188396, 176894, 173589, 206528, 206638, 178699, 188463, 227034, 179337, 181338, 190563, 174247, 174255, 173304, 177858, 177532, 181422, 199620, 178803, 180305, 204988, 190715, 177544, 184510, 190525, 173306, 190625, 190565, 177543, 184443, 241006, 180741, 174026, 206542, 178741, 180352, 181401, 181429, 184468, 238885, 173808, 173475)) UNION ALL ( select distinct sol.id as record, 1775, so.id as ref, 'Sale Order' as ref_code, sol.product_id as product_id, so.date_order as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_order_line sol LEFT JOIN product_product as pp ON sol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN sale_order as so ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where sol.branch_id = 44 and sol.product_id is not null and sol.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and so.date_order >= '2017-01-24 22:20:05' and so.date_order <= '2023-01-24 22:20:05' and so.state in ('permanent_order') and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127) and pt.inventory_vendor_id in (3091) and pp.id not in (239248, 239415, 173215, 192883, 197258, 190564, 177068, 173289, 173962, 173213, 203231, 190550, 173211, 177379, 187914, 180822, 197276, 188418, 188396, 176894, 173589, 206528, 206638, 178699, 188463, 227034, 179337, 181338, 190563, 174247, 174255, 173304, 177858, 177532, 181422, 199620, 178803, 180305, 204988, 190715, 177544, 184510, 190525, 173306, 190625, 190565, 177543, 184443, 241006, 180741, 174026, 206542, 178741, 180352, 181401, 181429, 184468, 238885, 173808, 173475)) UNION ALL ( select distinct rol.id as record, 1775, ro.id as ref, 'Repair Orders' as ref_code, rol.product_id as product_id, ro.create_date as invoice_date, rol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, ro.branch_id as selling_branch, ro.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from repair_order ro LEFT JOIN repair_line as rol ON ro.id = rol.repair_id LEFT JOIN product_product as pp ON rol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where ro.state = 'done' and ro.branch_id = 44 and rol.product_id is not null and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and ro.create_date >= '2017-01-24 22:20:05' and ro.create_date <= '2023-01-24 22:20:05' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127) and pt.inventory_vendor_id in (3091) and pp.id not in (239248, 239415, 173215, 192883, 197258, 190564, 177068, 173289, 173962, 173213, 203231, 190550, 173211, 177379, 187914, 180822, 197276, 188418, 188396, 176894, 173589, 206528, 206638, 178699, 188463, 227034, 179337, 181338, 190563, 174247, 174255, 173304, 177858, 177532, 181422, 199620, 178803, 180305, 204988, 190715, 177544, 184510, 190525, 173306, 190625, 190565, 177543, 184443, 241006, 180741, 174026, 206542, 178741, 180352, 181401, 181429, 184468, 238885, 173808, 173475)) UNION ALL ( select distinct sm.id as record, 1775, mrp.id as ref, 'Manufacturing Orders' as ref_code, sm.product_id as product_id, mrp.create_date as invoice_date, sm.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, mrp.branch_id as selling_branch, sm.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from mrp_production mrp LEFT JOIN stock_move as sm ON sm.raw_material_production_id = mrp.id LEFT JOIN product_product as pp ON sm.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where mrp.state = 'done' and mrp.branch_id = 44 and sm.product_id is not null and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and mrp.create_date >= '2017-01-24 22:20:05' and mrp.create_date <= '2023-01-24 22:20:05' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127) and pt.inventory_vendor_id in (3091) and pp.id not in (239248, 239415, 173215, 192883, 197258, 190564, 177068, 173289, 173962, 173213, 203231, 190550, 173211, 177379, 187914, 180822, 197276, 188418, 188396, 176894, 173589, 206528, 206638, 178699, 188463, 227034, 179337, 181338, 190563, 174247, 174255, 173304, 177858, 177532, 181422, 199620, 178803, 180305, 204988, 190715, 177544, 184510, 190525, 173306, 190625, 190565, 177543, 184443, 241006, 180741, 174026, 206542, 178741, 180352, 181401, 181429, 184468, 238885, 173808, 173475))) insert into item_list_line (item_demand_plan_id, product_id, invoice_date, product_uom_qty, inventory_vendor_id, selling_branch, warehouse_id, method, ref_id, ref, create_date, active) ( select 1775, data.product_id as product_id, data.invoice_date as invoice_date, data.product_uom_qty as product_uom_qty, data.inventory_vendor_id as inventory_vendor_id, data.selling_branch as selling_branch, data.warehouse_id as warehouse_id, brpm.method as method, data.ref as ref_id, data.ref_code as ref, now() at time zone 'UTC', True from data LEFT JOIN branch_product_method as brpm ON brpm.product_id = data.product_id and brpm.branch_id = 44);