16/09/2023 09:00:54 am >> SELECT document_num FROM ps_document WHERE document_num = '17/S' AND id_document != '12143' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-08') 16/09/2023 09:00:54 am >> UPDATE ps_document SET id_document_type = '23', document_num = '17/S', document_date = '2023-09-08', document_letter = 'S', id_customer = '3487', id_supplier = '', id_address = '144688385', address1 = 'VIA T. TASSO, 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '75.00', price_tax_excluded = '75.00', date_upd = NOW() WHERE id_document = '12143' 16/09/2023 09:00:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12143' 16/09/2023 09:00:54 am >> DELETE FROM ps_document_detail WHERE id_document = '12143' 16/09/2023 09:00:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12143' , '111' , 'I NONNI SONO UN TESORO' , '100' , '-100' , '4' , '1.5000' , '1.5' , '0' , '50' , '75.00' ) 16/09/2023 09:27:04 am >> SELECT document_num FROM ps_document WHERE document_num = '40/E' AND id_document != '87263' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-12') 16/09/2023 09:27:04 am >> UPDATE ps_document SET id_document_type = '23', document_num = '40/E', document_date = '2023-09-12', document_letter = 'E', id_customer = '189', id_supplier = '', id_address = '4677907', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '4574.36', price_tax_excluded = '4574.36', date_upd = NOW() WHERE id_document = '87263' 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87263' 16/09/2023 09:27:05 am >> DELETE FROM ps_document_detail WHERE id_document = '87263' 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '5457' , 'IO SONO CON VOI 1 PARTE' , '490' , '-490' , '4' , '2.8000' , '2.8' , '0' , '38' , '850.64' ) 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '5458' , 'IO SONO CON VOI 2 PARTE' , '500' , '-500' , '4' , '2.8000' , '2.8' , '0' , '38' , '868.00' ) 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '11191' , 'VENITE CON ME 1 PARTE' , '490' , '-490' , '4' , '2.8000' , '2.8' , '0' , '38' , '850.64' ) 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '11192' , 'VENITE CON ME 2 PARTE' , '540' , '-540' , '4' , '2.8000' , '2.8' , '0' , '38' , '937.44' ) 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '2679' , 'CONOSCERE GESU\'' , '100' , '-100' , '4' , '3.5000' , '3.5' , '0' , '38' , '217.00' ) 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '120' , '-120' , '4' , '2.4000' , '2.4' , '0' , '38' , '178.56' ) 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '9675' , 'SARETE MIEI TESTIMONI' , '100' , '-100' , '4' , '3.5000' , '3.5' , '0' , '38' , '217.00' ) 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '10' , '-10' , '4' , '3.4000' , '3.4' , '0' , '38' , '21.08' ) 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '20' , '-20' , '4' , '10.0000' , '10' , '0' , '38' , '124.00' ) 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '20' , '-20' , '4' , '10.0000' , '10' , '0' , '38' , '124.00' ) 16/09/2023 09:27:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87263' , '15020' , 'PREGARE OGNI GIORNO' , '300' , '-300' , '4' , '1.0000' , '1' , '0' , '38' , '186.00' ) 16/09/2023 10:27:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2838' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-16') 16/09/2023 10:27:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2838' , '2023-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.50' , '22.60' , NOW() , NOW() ) 16/09/2023 10:27:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87311' 16/09/2023 10:27:51 am >> DELETE FROM ps_document_detail WHERE id_document = '87311' 16/09/2023 10:27:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87311' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 16/09/2023 10:27:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87311' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 16/09/2023 11:03:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2839' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-16') 16/09/2023 11:03:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2839' , '2023-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '10.50' , NOW() , NOW() ) 16/09/2023 11:03:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87312' 16/09/2023 11:03:49 am >> DELETE FROM ps_document_detail WHERE id_document = '87312' 16/09/2023 11:03:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87312' , '21388' , 'AGENDA DEL CATECHISTA 2023-2024' , '7' , '-7' , '4' , '1.50' , '1.5' , '0' , '0' , '10.50' ) 16/09/2023 11:07:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2840' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-16') 16/09/2023 11:07:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2840' , '2023-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 16/09/2023 11:07:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87313' 16/09/2023 11:07:56 am >> DELETE FROM ps_document_detail WHERE id_document = '87313' 16/09/2023 11:07:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87313' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 16/09/2023 12:04:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2841' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-16') 16/09/2023 12:04:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2841' , '2023-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '16.18' , NOW() , NOW() ) 16/09/2023 12:04:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87314' 16/09/2023 12:04:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '87314' 16/09/2023 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87314' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 16/09/2023 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87314' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 16/09/2023 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87314' , '6053' , 'MADONNA DEL CARMELO - CM 13 - 023 CAR/13' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 16/09/2023 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87314' , '19744' , 'ASCOLTAMI GESU' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 16/09/2023 12:04:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87314' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 16/09/2023 12:08:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2842' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-16') 16/09/2023 12:08:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2842' , '2023-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 16/09/2023 12:08:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87315' 16/09/2023 12:08:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '87315' 16/09/2023 12:08:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87315' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '100' , '0.00' ) 16/09/2023 12:08:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87315' , '20983' , 'CLERGY MM LIMITED 80/20' , '2' , '-2' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '80.00' ) 16/09/2023 12:10:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2713' AND id_document != '87159' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 16/09/2023 12:10:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2713', document_date = '2023-09-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '48.00', price_tax_excluded = '43.31', date_upd = NOW() WHERE id_document = '87159' 16/09/2023 12:10:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87159' 16/09/2023 12:10:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '87159' 16/09/2023 12:10:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87159' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 16/09/2023 12:10:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87159' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.8500' , '5.85' , '0' , '0' , '5.85' ) 16/09/2023 12:10:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87159' , '17005' , 'BIGLIETTO AUGURALE medio' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 16/09/2023 12:10:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87159' , '21338' , 'DIO DI ABRAMO - A. MELLO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 16/09/2023 12:10:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87159' , '6053' , 'MADONNA DEL CARMELO - CM 13 - 023 CAR/13' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 16/09/2023 12:12:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2842' AND id_document != '87315' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-16') 16/09/2023 12:12:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2842', document_date = '2023-09-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '87315' 16/09/2023 12:12:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87315' 16/09/2023 12:12:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '87315' 16/09/2023 12:12:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87315' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '100' , '0.00' ) 16/09/2023 12:12:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87315' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 16/09/2023 12:12:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87315' , '18251' , 'CLERGY JEANS NIDO DAPE MM - 3XL' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 16/09/2023 12:39:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2843' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-16') 16/09/2023 12:39:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2843' , '2023-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 16/09/2023 12:39:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87316' 16/09/2023 12:39:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '87316' 16/09/2023 12:39:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87316' , '15096' , 'CORONA MATRIMONIO - ARG ' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 16/09/2023 12:42:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2844' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-16') 16/09/2023 12:42:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2844' , '2023-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 16/09/2023 12:42:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87317' 16/09/2023 12:42:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '87317' 16/09/2023 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87317' , '20515' , 'DECINA ULIVO - 04/7-D' , '5' , '-5' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.50' )