16/06/2025 09:07:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2139' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-16') 16/06/2025 09:07:38 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' , '2139' , '2025-06-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.75' , '20.40' , NOW() , NOW() ) 16/06/2025 09:07:38 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 = '97723' 16/06/2025 09:07:38 am >> DELETE FROM ps_document_detail WHERE id_document = '97723' 16/06/2025 09:07:38 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 ( '97723' , '5536' , 'LACCIO' , '5' , '-5' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '2.50' ) 16/06/2025 09:07:38 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 ( '97723' , '18130' , 'TAU GRANDE CM 4 - T9' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 16/06/2025 09:07:38 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 ( '97723' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 16/06/2025 09:08:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2139' AND id_document != '97723' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-16') 16/06/2025 09:08:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2139', document_date = '2025-06-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 = '21.75', price_tax_excluded = '20.40', date_upd = NOW() WHERE id_document = '97723' 16/06/2025 09:08:17 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 = '97723' 16/06/2025 09:08:17 am >> DELETE FROM ps_document_detail WHERE id_document = '97723' 16/06/2025 09:08:18 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 ( '97723' , '5536' , 'LACCIO' , '5' , '-5' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '2.50' ) 16/06/2025 09:08:18 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 ( '97723' , '18130' , 'TAU GRANDE CM 4 - T9' , '5' , '-5' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '5.00' ) 16/06/2025 09:08:18 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 ( '97723' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 16/06/2025 09:32:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2140' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-16') 16/06/2025 09:32:23 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' , '2140' , '2025-06-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 16/06/2025 09:32:23 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 = '97724' 16/06/2025 09:32:23 am >> DELETE FROM ps_document_detail WHERE id_document = '97724' 16/06/2025 09:32:23 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 ( '97724' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 16/06/2025 09:54:46 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3056' 16/06/2025 09:54:46 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3056' , '10' , '210' , '' , 'GAMBARDELLA' , 'ANDREA' , 'VIA MAESTRA DEI VILLAGGI 124 ' , '' , '84011' , 'AMALFI' , '' , '' , '3315099657' , '' , '' , NOW() , NOW() ) 16/06/2025 09:54:46 am >> UPDATE ps_customer SET email = 'gambardella.andrea@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3056' 16/06/2025 09:55:26 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3056' 16/06/2025 09:55:26 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3056' , '10' , '210' , '' , 'GAMBARDELLA' , 'ANDREA' , 'VIA MAESTRA DEI VILLAGGI 124 ' , '' , '84011' , 'AMALFI' , 'Andrea Gambardella\r\nHOTEL LE SIRENUSE\r\nVia C. Colombo 30\r\nPositano 84017\r\nSalerno\r\n\r\n' , '' , '3315099657' , '' , '' , NOW() , NOW() ) 16/06/2025 09:55:26 am >> UPDATE ps_customer SET email = 'gambardella.andrea@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3056' 16/06/2025 09:56:08 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3056' 16/06/2025 09:56:08 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3056' , '10' , '210' , '' , 'GAMBARDELLA' , 'ANDREA' , 'VIA MAESTRA DEI VILLAGGI 124 ' , '' , '84011' , 'AMALFI' , 'Andrea Gambardella\r\nHOTEL LE SIRENUSE\r\nVia C. Colombo 30\r\nPositano 84017\r\nSalerno\r\n\r\n' , '' , '3315099657' , '' , '' , NOW() , NOW() ) 16/06/2025 09:56:08 am >> UPDATE ps_customer SET email = 'gambardella.andrea@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3056' 16/06/2025 09:58:10 am >> SELECT document_num FROM ps_document WHERE document_num = '80' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-06-16') 16/06/2025 09:58:10 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 ( '21' , '80' , '2025-06-16' , '' , '3056' , '0' , '4679514' , 'VIA MAESTRA DEI VILLAGGI 124 84011 AMALFI' , '' , '' , '5' , '4' , '3' , '0' , '0' , '' , '9' , '0' , '43.00' , '43.00' , NOW() , NOW() ) 16/06/2025 09:58:10 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 = '97725' 16/06/2025 09:58:10 am >> DELETE FROM ps_document_detail WHERE id_document = '97725' 16/06/2025 09:58:10 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 ( '97725' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '0' , '40.00' , '40' , '' , '5' , '38.00' ) 16/06/2025 10:05:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2124' AND id_document != '97706' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-13') 16/06/2025 10:05:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2124', document_date = '2025-06-13', 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 = '3', id_causal = '0', price_tax_included = '630.00', price_tax_excluded = '516.39', date_upd = NOW() WHERE id_document = '97706' 16/06/2025 10:05:30 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 = '97706' 16/06/2025 10:05:30 am >> DELETE FROM ps_document_detail WHERE id_document = '97706' 16/06/2025 10:05:30 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 ( '97706' , '23634' , 'CASULA MARIANA LANA - 7930L' , '1' , '-1' , '1' , '630.0000' , '516.39344262295' , '22' , '0' , '630.00' ) 16/06/2025 11:24:19 am >> UPDATE ps_document SET id_document_type = '31', document_num = '98', document_date = '2023-01-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4678840', address1 = 'VIA CALENDONE 22/24 23887 OLGIATE MOLGORA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '5289.93', price_tax_excluded = '4357.88', date_upd = NOW() WHERE id_document = '82124' 16/06/2025 11:24:19 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 = '82124' 16/06/2025 11:24:19 am >> DELETE FROM ps_document_detail WHERE id_document = '82124' 16/06/2025 11:24:19 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 ( '82124' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '503' , '503' , '1' , '7.3500' , '6.0245901639344' , '22' , '3' , '4375.09' ) 16/06/2025 11:24:19 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 ( '82124' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '350.0000' , '286.88524590164' , '22' , '0' , '427.00' ) 16/06/2025 11:24:19 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 ( '82124' , '0' , 'SPESE CONAI' , '1' , '1' , '1' , '180.4500' , '147.90983606557' , '22' , '0' , '220.15' ) 16/06/2025 11:24:19 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 ( '82124' , '0' , 'TELAIO' , '1' , '1' , '1' , '120.0000' , '98.360655737705' , '22' , '0' , '146.40' ) 16/06/2025 11:24:19 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 ( '82124' , '' , 'SPESE VARIE' , '1' , '1' , '0' , '121.29' , '121.29' , '' , '0' , '121.2900' ) 16/06/2025 11:47:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2141' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-06-16') 16/06/2025 11:47:12 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' , '2141' , '2025-06-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '110.66' , NOW() , NOW() ) 16/06/2025 11:47:12 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 = '97726' 16/06/2025 11:47:12 am >> DELETE FROM ps_document_detail WHERE id_document = '97726' 16/06/2025 11:47:12 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 ( '97726' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 16/06/2025 11:53:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2142' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-16') 16/06/2025 11:53:03 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' , '2142' , '2025-06-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.00' , '103.85' , NOW() , NOW() ) 16/06/2025 11:53:03 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 = '97727' 16/06/2025 11:53:03 am >> DELETE FROM ps_document_detail WHERE id_document = '97727' 16/06/2025 11:53:03 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 ( '97727' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 16/06/2025 11:53:03 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 ( '97727' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 16/06/2025 11:53:03 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 ( '97727' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '4' , '-4' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '18.00' ) 16/06/2025 03:37:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2143' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-16') 16/06/2025 03:37:35 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' , '2143' , '2025-06-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.15' , '15.15' , NOW() , NOW() ) 16/06/2025 03:37:35 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 = '97728' 16/06/2025 03:37:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '97728' 16/06/2025 03:37:35 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 ( '97728' , '16836' , 'AMORE DELLE ANIME - 8199' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 16/06/2025 03:37:35 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 ( '97728' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.5' , '8.5' , '0' , '0' , '8.50' ) 16/06/2025 03:55:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1712' AND id_document != '97233' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-17') 16/06/2025 03:55:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1712', document_date = '2025-05-17', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '97233' 16/06/2025 03:55:46 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 = '97233' 16/06/2025 03:55:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '97233' 16/06/2025 03:55:46 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 ( '97233' , '17087' , 'POLO COTONE MM' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 16/06/2025 03:56:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1732' AND id_document != '97257' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-19') 16/06/2025 03:56:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1732', document_date = '2025-05-19', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '97257' 16/06/2025 03:56:34 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 = '97257' 16/06/2025 03:56:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '97257' 16/06/2025 03:56:35 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 ( '97257' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.1' , '4.1803278688525' , '22' , '0' , '5.10' ) 16/06/2025 03:56:35 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 ( '97257' , '20982' , 'POLO MM VISCOSA 100%' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 16/06/2025 05:51:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2144' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-16') 16/06/2025 05:51:20 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' , '2144' , '2025-06-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.41' , '104.41' , NOW() , NOW() ) 16/06/2025 05:51:20 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 = '97729' 16/06/2025 05:51:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '97729' 16/06/2025 05:51: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 ( '97729' , '23527' , 'CODICE DI DIRITTO CANONICO - 9 EDIZ.' , '1' , '-1' , '4' , '109.90' , '109.9' , '0' , '5' , '104.41' ) 16/06/2025 06:20:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2145' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-16') 16/06/2025 06:20:21 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' , '2145' , '2025-06-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.20' , '16.20' , NOW() , NOW() ) 16/06/2025 06:20:21 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 = '97730' 16/06/2025 06:20:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '97730' 16/06/2025 06:20:21 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 ( '97730' , '21636' , 'FESTA DELLA MIA CRESIMA' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 16/06/2025 06:20:21 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 ( '97730' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' )