11/06/2025 08:29:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1265' AND id_document != '96710' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 11/06/2025 08:29:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1265', document_date = '2025-04-15', 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 = '979.40', price_tax_excluded = '848.39', date_upd = NOW() WHERE id_document = '96710' 11/06/2025 08:29:36 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 = '96710' 11/06/2025 08:29:36 am >> DELETE FROM ps_document_detail WHERE id_document = '96710' 11/06/2025 08:29:37 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 ( '96710' , '23636' , 'GESU CRISTO FIGLIO DI DIO SALVATORE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 11/06/2025 08:29:37 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 ( '96710' , '23503' , 'TRISTE CASO DELL\'OMELIA - F. ROSINI' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 11/06/2025 08:29:37 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 ( '96710' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '10' , '-10' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '18.00' ) 11/06/2025 08:29:37 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 ( '96710' , '15210' , 'CERO PASQUALE API 80X120' , '3' , '-3' , '1' , '80' , '65.573770491803' , '22' , '0' , '240.00' ) 11/06/2025 08:29:37 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 ( '96710' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '28.00' ) 11/06/2025 08:29:37 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 ( '96710' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 11/06/2025 08:29:37 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 ( '96710' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 11/06/2025 08:29:37 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 ( '96710' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 11/06/2025 08:29:37 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 ( '96710' , '23672' , 'IN DIALOGO CON IL PROPRIO TEMPO - 13/3 - RATZINGER' , '1' , '-1' , '4' , '75.0000' , '75' , '0' , '5' , '71.25' ) 11/06/2025 08:29:37 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 ( '96710' , '23671' , 'IN DIALOGO CON IL PROPRIO TEMPO - 13/1-2 - RATZINGER' , '1' , '-1' , '4' , '130.0000' , '130' , '0' , '5' , '123.50' ) 11/06/2025 08:29:37 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 ( '96710' , '19757' , 'PIVIALE - KKP/024/02/20' , '1' , '-1' , '1' , '350.0000' , '286.88524590164' , '22' , '0' , '350.00' ) 11/06/2025 08:29:37 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 ( '96710' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '3' , '-3' , '4' , '7.0000' , '7' , '0' , '5' , '19.95' ) 11/06/2025 08:29:37 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 ( '96710' , '1938' , 'CERO PASQUALE API 80X100' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 11/06/2025 09:05:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2080' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 09:05:28 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' , '2080' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 11/06/2025 09:05:28 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 = '97653' 11/06/2025 09:05:28 am >> DELETE FROM ps_document_detail WHERE id_document = '97653' 11/06/2025 09:05:28 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 ( '97653' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 11/06/2025 09:05:28 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 ( '97653' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '3' , '-3' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '60.00' ) 11/06/2025 09:17:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2081' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 09:17:53 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' , '2081' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.30' , '8.44' , NOW() , NOW() ) 11/06/2025 09:17:53 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 = '97654' 11/06/2025 09:17:53 am >> DELETE FROM ps_document_detail WHERE id_document = '97654' 11/06/2025 09:17:53 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 ( '97654' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 11/06/2025 09:17:53 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 ( '97654' , '23779' , 'BRACCIALE ZIRCONI - BZ001' , '2' , '-2' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '4.40' ) 11/06/2025 09:17:53 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 ( '97654' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 11/06/2025 09:17:53 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 ( '97654' , '23385' , 'DECINA LEGNO - FR18' , '3' , '-3' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '1.80' ) 11/06/2025 09:26:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2082' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 09:26:37 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' , '2082' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 11/06/2025 09:26:37 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 = '97655' 11/06/2025 09:26:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97655' 11/06/2025 09:26:37 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 ( '97655' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 11/06/2025 10:21:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2083' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 10:21:35 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' , '2083' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '36.00' , NOW() , NOW() ) 11/06/2025 10:21:35 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 = '97656' 11/06/2025 10:21:35 am >> DELETE FROM ps_document_detail WHERE id_document = '97656' 11/06/2025 10:21:35 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 ( '97656' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '36' , '36' , '0' , '0' , '36.00' ) 11/06/2025 10:58:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2084' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 10:58:02 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' , '2084' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '233.00' , '197.65' , NOW() , NOW() ) 11/06/2025 10:58:02 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 = '97657' 11/06/2025 10:58:02 am >> DELETE FROM ps_document_detail WHERE id_document = '97657' 11/06/2025 10:58:02 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 ( '97657' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 11/06/2025 10:58:02 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 ( '97657' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 11/06/2025 10:58:02 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 ( '97657' , '19213' , 'FINTA CANDELA 4X25 - 114' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 11/06/2025 10:58:02 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 ( '97657' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '2' , '-2' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '27.00' ) 11/06/2025 10:58:02 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 ( '97657' , '16939' , 'SACCO PORTAELEMOSINA CON ASTA 1 m - 1750' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 11/06/2025 10:58:02 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 ( '97657' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 11/06/2025 10:59:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2085' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 10:59:36 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' , '2085' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.20' , '60.58' , NOW() , NOW() ) 11/06/2025 10:59:36 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 = '97658' 11/06/2025 10:59:36 am >> DELETE FROM ps_document_detail WHERE id_document = '97658' 11/06/2025 10:59:36 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 ( '97658' , '1596' , 'CAMPANELLO 4 SUONI - 629' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 11/06/2025 10:59:36 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 ( '97658' , '21125' , 'CUORE EUCARISTICO DI GESU - S. LONGOBARDI' , '1' , '-1' , '4' , '3.20' , '3.2' , '0' , '0' , '3.20' ) 11/06/2025 11:12:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2086' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 11:12: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 ( '11' , '2086' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.48' , '46.48' , NOW() , NOW() ) 11/06/2025 11:12: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 = '97659' 11/06/2025 11:12:10 am >> DELETE FROM ps_document_detail WHERE id_document = '97659' 11/06/2025 11:12: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 ( '97659' , '7436' , 'PANE DI SANTANTONIO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 11/06/2025 11:12: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 ( '97659' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 11/06/2025 11:12: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 ( '97659' , '23770' , 'PAROLA E PREGHIERA - AGO 25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 11/06/2025 11:12: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 ( '97659' , '23697' , 'PAROLA E PREGHIERA - LUG 25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 11/06/2025 11:12: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 ( '97659' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 11/06/2025 11:12: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 ( '97659' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 11/06/2025 11:31:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2087' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 11:31: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' , '2087' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 11/06/2025 11:31: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 = '97660' 11/06/2025 11:31:56 am >> DELETE FROM ps_document_detail WHERE id_document = '97660' 11/06/2025 11:31: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 ( '97660' , '23610' , 'LUMETTO 17X17 - RL' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 11/06/2025 11:31: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 ( '97660' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 11/06/2025 11:42:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2088' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 11:42:42 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' , '2088' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 11/06/2025 11:42:42 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 = '97661' 11/06/2025 11:42:42 am >> DELETE FROM ps_document_detail WHERE id_document = '97661' 11/06/2025 11:42:42 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 ( '97661' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 11/06/2025 11:54:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2089' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 11:54: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' , '2089' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '12.05' , NOW() , NOW() ) 11/06/2025 11:54: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 = '97662' 11/06/2025 11:54:56 am >> DELETE FROM ps_document_detail WHERE id_document = '97662' 11/06/2025 11:54: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 ( '97662' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 11/06/2025 12:21:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2090' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 12:21:15 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' , '2090' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '315.00' , '258.20' , NOW() , NOW() ) 11/06/2025 12:21:15 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 = '97663' 11/06/2025 12:21:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '97663' 11/06/2025 12:21:15 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 ( '97663' , '540' , 'AMPOLLE ALTARE FUSIONE DORATA - 504 ' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 11/06/2025 12:21:15 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 ( '97663' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' , '-1' , '1' , '16.50' , '13.524590163934' , '22' , '0' , '16.50' ) 11/06/2025 12:21:15 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 ( '97663' , '6011' , 'LUMINELLO VETRO - 474' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 11/06/2025 12:21:15 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 ( '97663' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '-1' , '1' , '52.00' , '42.622950819672' , '22' , '0' , '52.00' ) 11/06/2025 12:21:15 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 ( '97663' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '51.00' , '41.803278688525' , '22' , '0' , '51.00' ) 11/06/2025 12:21:15 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 ( '97663' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '49.5' , '40.573770491803' , '22' , '0' , '49.50' ) 11/06/2025 12:24:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2091' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 12:24:24 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' , '2091' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.00' , '106.50' , NOW() , NOW() ) 11/06/2025 12:24:24 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 = '97664' 11/06/2025 12:24:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '97664' 11/06/2025 12:24:24 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 ( '97664' , '22881' , 'ADORAZIONE EUCARISTICA ALLA SCUOLA DELLA LITURGIA - POLI/ZOTTELE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 11/06/2025 12:24:24 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 ( '97664' , '23751' , 'GESU VERAMENTE - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 11/06/2025 12:24:24 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 ( '97664' , '23003' , 'SANTA MESSA - M. MIRTILLI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 11/06/2025 12:24:24 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 ( '97664' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 11/06/2025 12:24:24 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 ( '97664' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '36.05' , '29.549180327869' , '22' , '0' , '36.05' ) 11/06/2025 12:24:24 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 ( '97664' , '1199' , 'BIBBIA TOB - SOFTEN' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 11/06/2025 12:29:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2092' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 12:29:15 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' , '2092' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.60' , '9.51' , NOW() , NOW() ) 11/06/2025 12:29:15 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 = '97665' 11/06/2025 12:29:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '97665' 11/06/2025 12:29:15 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 ( '97665' , '17520' , 'LUMINO SMERALDO' , '3' , '-3' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.50' ) 11/06/2025 12:29:15 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 ( '97665' , '16061' , 'MEDAGLIA S. RITA- FM022' , '4' , '-4' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '1.20' ) 11/06/2025 12:29:15 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 ( '97665' , '6331' , 'MEDAGLIA OVALE DECORATA - MIRACOLOSA - G011.3' , '2' , '-2' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '1.60' ) 11/06/2025 12:29:15 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 ( '97665' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 11/06/2025 12:29:15 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 ( '97665' , '6336' , 'MEDAGLIA OVALE DECORATA - S.RITA - G291-D' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 11/06/2025 12:29:15 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 ( '97665' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 11/06/2025 01:00:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2093' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 01:00:16 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' , '2093' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 11/06/2025 01:00:16 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 = '97666' 11/06/2025 01:00:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '97666' 11/06/2025 01:00:16 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 ( '97666' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 11/06/2025 02:53:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1915' AND id_document != '97463' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 11/06/2025 02:53:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1915', document_date = '2025-05-29', 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 = '12.00', price_tax_excluded = '12.00', date_upd = NOW() WHERE id_document = '97463' 11/06/2025 02:53:42 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 = '97463' 11/06/2025 02:53:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '97463' 11/06/2025 02:53:42 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 ( '97463' , '23649' , 'APPARECCHIO ALLA MORTE - 8975 ' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 11/06/2025 03:32:45 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'P0dkmsPOKOLycHcU' , NOW() , NOW() ) 11/06/2025 03:32:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4216' , '1' ) 11/06/2025 03:32:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4216' , '2' ) 11/06/2025 03:32:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4216' , '3' ) 11/06/2025 03:34:00 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4216' 11/06/2025 03:34:00 pm >> 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 ( '4216' , '10' , '183' , '' , 'SCHIAVONE' , 'TERESA' , 'VIA CAPPELLA DEI BISI 189' , '' , '80050' , 'S. MARIA DELLA CARITA\'' , '' , '' , '3398726971' , '' , '' , NOW() , NOW() ) 11/06/2025 03:34:00 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4216' 11/06/2025 03:35:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '78' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 03:35:02 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 ( '21' , '78' , '2025-06-11' , '' , '4216' , '0' , '4679510' , 'VIA CAPPELLA DEI BISI 189 80050 S. MARIA DELLA CARITA\\\'' , '' , '' , '4.95' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 11/06/2025 03:35:02 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 = '97667' 11/06/2025 03:35:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '97667' 11/06/2025 03:35:02 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 ( '97667' , '23795' , 'DIALOGO DELLA DIVINA PROVVIDENZA - CATERINA DA SIENA' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 11/06/2025 03:35:02 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 ( '97667' , '23759' , 'NON IO MA DIO - A. SALZANO ACUTIS' , '1' , '-1' , '4' , '18.90' , '18.9' , '0' , '5' , '17.95' ) 11/06/2025 03:35:02 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 ( '97667' , '23760' , 'SANTA MESSA SANTO ME - A. SALZANO ACUTIS' , '1' , '-1' , '4' , '18.90' , '18.9' , '0' , '5' , '17.95' ) 11/06/2025 03:43:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2092' AND id_document != '97665' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 03:43:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2092', document_date = '2025-06-11', 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 = '11.60', price_tax_excluded = '9.51', date_upd = NOW() WHERE id_document = '97665' 11/06/2025 03:43:13 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 = '97665' 11/06/2025 03:43:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '97665' 11/06/2025 03:43:13 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 ( '97665' , '17520' , 'LUMINO SMERALDO' , '3' , '-3' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '1.50' ) 11/06/2025 03:43:13 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 ( '97665' , '16061' , 'MEDAGLIA S. RITA- FM022' , '4' , '-4' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '1.20' ) 11/06/2025 03:43:13 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 ( '97665' , '6331' , 'MEDAGLIA OVALE DECORATA - MIRACOLOSA - G011.3' , '2' , '-2' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '1.60' ) 11/06/2025 03:43:13 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 ( '97665' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 11/06/2025 03:43:13 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 ( '97665' , '6336' , 'MEDAGLIA OVALE DECORATA - S.RITA - G291-D' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 11/06/2025 03:43:13 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 ( '97665' , '18276' , 'CINGOLO CON NODI - 3280' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 11/06/2025 04:04:18 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 ( '32' , '1110/25' , '2025-05-31' , '25' , '0' , '125' , '4669745' , 'VIA SIBELLUCCIA, AREA P.I.P. 84088 MERCATO SAN SEVERINO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '10' , '0' , '390.00' , '375.00' , NOW() , NOW() ) 11/06/2025 04:04:18 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 = '97668' 11/06/2025 04:04:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '97668' 11/06/2025 04:04:18 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 ( '97668' , '23721' , 'BEATITUDINI - M. DE ROSA' , '500' , '0' , '3' , '0.75' , '0.72115384615385' , '4' , '0' , '390.0000' ) 11/06/2025 04:04:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23721' AND id_supplier = '125' 11/06/2025 04:04:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23721' , '125' , '1' ) 11/06/2025 04:58:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2094' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 04:58: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' , '2094' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '274.50' , '249.83' , NOW() , NOW() ) 11/06/2025 04:58: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 = '97669' 11/06/2025 04:58:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '97669' 11/06/2025 04:58: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 ( '97669' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 11/06/2025 04:58: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 ( '97669' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '50' , '-50' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '175.00' ) 11/06/2025 04:58: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 ( '97669' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 11/06/2025 04:58: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 ( '97669' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '2' , '-2' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '23.00' ) 11/06/2025 04:58: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 ( '97669' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '28.00' ) 11/06/2025 05:40:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2095' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 05:40:57 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' , '2095' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 11/06/2025 05:40:57 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 = '97670' 11/06/2025 05:40:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '97670' 11/06/2025 05:40:57 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 ( '97670' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 11/06/2025 05:46:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2096' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 11/06/2025 05:46:16 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' , '2096' , '2025-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.60' , '15.25' , NOW() , NOW() ) 11/06/2025 05:46:16 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 = '97671' 11/06/2025 05:46:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '97671' 11/06/2025 05:46:16 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 ( '97671' , '6015' , 'LUMINO ELETTRICO A BASSA TENS. - LED' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 11/06/2025 05:46: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 ( '97671' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15.6' , '12.786885245902' , '22' , '0' , '15.60' )