29/11/2025 09:01:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3979' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 09:01:15 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' , '3979' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '36.50' , NOW() , NOW() ) 29/11/2025 09:01:15 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 = '100163' 29/11/2025 09:01:15 am >> DELETE FROM ps_document_detail WHERE id_document = '100163' 29/11/2025 09:01:15 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 ( '100163' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '20' , '-20' , '4' , '0.70' , '0.7' , '0' , '0' , '14.00' ) 29/11/2025 09:01:15 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 ( '100163' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 29/11/2025 09:01:15 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 ( '100163' , '24002' , 'LODE INTONATA DALLANGELO - M. CURTO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 29/11/2025 09:01:15 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 ( '100163' , '24215' , 'DILEXI TE - 8429' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 29/11/2025 09:26:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3980' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 09:26:39 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' , '3980' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 29/11/2025 09:26:39 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 = '100164' 29/11/2025 09:26:39 am >> DELETE FROM ps_document_detail WHERE id_document = '100164' 29/11/2025 09:26:39 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 ( '100164' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 29/11/2025 09:26:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3981' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 09:26:57 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' , '3981' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 29/11/2025 09:26:57 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 = '100165' 29/11/2025 09:26:57 am >> DELETE FROM ps_document_detail WHERE id_document = '100165' 29/11/2025 09:26:57 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 ( '100165' , '21137' , 'MOCCOLO 70X200' , '8' , '-8' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '60.00' ) 29/11/2025 09:58:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3982' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 09:58:07 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' , '3982' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 29/11/2025 09:58:07 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 = '100166' 29/11/2025 09:58:07 am >> DELETE FROM ps_document_detail WHERE id_document = '100166' 29/11/2025 09:58:07 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 ( '100166' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/11/2025 09:59:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3983' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 09:59:26 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' , '3983' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.53' , '18.53' , NOW() , NOW() ) 29/11/2025 09:59:26 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 = '100167' 29/11/2025 09:59:26 am >> DELETE FROM ps_document_detail WHERE id_document = '100167' 29/11/2025 09:59:26 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 ( '100167' , '24079' , 'FRANCESCO IL PRIMO ITALIANO - A. CAZZULLO' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 29/11/2025 10:17:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3984' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 10:17: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' , '3984' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 29/11/2025 10:17: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 = '100168' 29/11/2025 10:17:28 am >> DELETE FROM ps_document_detail WHERE id_document = '100168' 29/11/2025 10:17: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 ( '100168' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 29/11/2025 10:17:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3985' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 10:17:43 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' , '3985' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 29/11/2025 10:17:43 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 = '100169' 29/11/2025 10:17:43 am >> DELETE FROM ps_document_detail WHERE id_document = '100169' 29/11/2025 10:17:43 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 ( '100169' , '18880' , 'COPRILEGGIO MORELLO' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 29/11/2025 10:28:07 am >> SELECT document_num FROM ps_document WHERE document_num = '143/A' AND id_document != '100002' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-19') 29/11/2025 10:28:07 am >> UPDATE ps_document SET id_document_type = '24', document_num = '143/A', document_date = '2025-11-19', document_letter = 'A', id_customer = '316', id_supplier = '', id_address = '4669506', address1 = 'VIA VITO LEMBO, 2 84020 PALOMONTE', 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 = '366.77', price_tax_excluded = '366.77', date_upd = NOW() WHERE id_document = '100002' 29/11/2025 10:28:07 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 = '100002' 29/11/2025 10:28:07 am >> DELETE FROM ps_document_detail WHERE id_document = '100002' 29/11/2025 10:28:07 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 ( '100002' , '13397' , 'MIO GESU' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 29/11/2025 10:28:07 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 ( '100002' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 29/11/2025 10:28:07 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 ( '100002' , '10751' , 'TU MI PERDONI' , '15' , '-15' , '4' , '6.90' , '6.9' , '0' , '5' , '98.33' ) 29/11/2025 10:28:07 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 ( '100002' , '14719' , 'TU MI AMI DAVVERO' , '25' , '-25' , '4' , '6.90' , '6.9' , '0' , '5' , '163.88' ) 29/11/2025 10:28:07 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 ( '100002' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '-1' , '0' , '51.00' , '51' , '' , '0' , '51.00' ) 29/11/2025 10:28:28 am >> SELECT document_num FROM ps_document WHERE document_num = '143/A' AND id_document != '100002' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-19') 29/11/2025 10:28:28 am >> UPDATE ps_document SET id_document_type = '24', document_num = '143/A', document_date = '2025-11-19', document_letter = 'A', id_customer = '316', id_supplier = '', id_address = '4669506', address1 = 'VIA VITO LEMBO, 2 84020 PALOMONTE', 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 = '366.77', price_tax_excluded = '357.57', date_upd = NOW() WHERE id_document = '100002' 29/11/2025 10:28: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 = '100002' 29/11/2025 10:28:28 am >> DELETE FROM ps_document_detail WHERE id_document = '100002' 29/11/2025 10:28: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 ( '100002' , '13397' , 'MIO GESU' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 29/11/2025 10:28: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 ( '100002' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 29/11/2025 10:28: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 ( '100002' , '10751' , 'TU MI PERDONI' , '15' , '-15' , '4' , '6.9000' , '6.9' , '0' , '5' , '98.33' ) 29/11/2025 10:28: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 ( '100002' , '14719' , 'TU MI AMI DAVVERO' , '25' , '-25' , '4' , '6.9000' , '6.9' , '0' , '5' , '163.88' ) 29/11/2025 10:28: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 ( '100002' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '-1' , '1' , '51.0000' , '41.803278688525' , '22' , '0' , '51.00' ) 29/11/2025 10:40:11 am >> SELECT document_num FROM ps_document WHERE document_num = '47/A' AND id_document != '96002' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-03') 29/11/2025 10:40:11 am >> UPDATE ps_document SET id_document_type = '24', document_num = '47/A', document_date = '2025-03-03', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', address2 = '', note = '9', 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 = '123.60', price_tax_excluded = '109.53', date_upd = NOW() WHERE id_document = '96002' 29/11/2025 10:40:11 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 = '96002' 29/11/2025 10:40:11 am >> DELETE FROM ps_document_detail WHERE id_document = '96002' 29/11/2025 10:40:11 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 ( '96002' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '3' , '-3' , '4' , '16.0000' , '16' , '0' , '5' , '45.60' ) 29/11/2025 10:40:11 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 ( '96002' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '15' , '-15' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '36.00' ) 29/11/2025 10:40:11 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 ( '96002' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '12' , '-12' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '42.00' ) 29/11/2025 10:41:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3986' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 10:41:39 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' , '3986' , '2025-11-29' , '' , '1148' , '0' , '1148' , 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.90' , '107.32' , NOW() , NOW() ) 29/11/2025 10:41:39 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 = '100170' 29/11/2025 10:41:39 am >> DELETE FROM ps_document_detail WHERE id_document = '100170' 29/11/2025 10:41:39 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 ( '100170' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '3' , '-3' , '4' , '16.0000' , '16' , '0' , '5' , '45.60' ) 29/11/2025 10:41:39 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 ( '100170' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '15' , '-15' , '1' , '2.3' , '1.8852459016393' , '22' , '0' , '34.50' ) 29/11/2025 10:41:39 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 ( '100170' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '12' , '-12' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '40.80' ) 29/11/2025 11:06:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3987' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 11:06:24 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' , '3987' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '102.60' , NOW() , NOW() ) 29/11/2025 11:06:24 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 = '100171' 29/11/2025 11:06:24 am >> DELETE FROM ps_document_detail WHERE id_document = '100171' 29/11/2025 11:06:24 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 ( '100171' , '23608' , 'QUADRO DECORATO 33X33 - PR-R' , '1' , '-1' , '1' , '24.2' , '19.83606557377' , '22' , '0' , '24.20' ) 29/11/2025 11:06:24 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 ( '100171' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 29/11/2025 11:06:24 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 ( '100171' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 29/11/2025 11:15:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3988' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 11:15:18 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' , '3988' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '560.00' , '560.00' , NOW() , NOW() ) 29/11/2025 11:15:18 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 = '100172' 29/11/2025 11:15:18 am >> DELETE FROM ps_document_detail WHERE id_document = '100172' 29/11/2025 11:15: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 ( '100172' , '5444' , 'IO SONO CON VOI - CAT.' , '44' , '-44' , '4' , '5.50' , '5.5' , '0' , '0' , '242.00' ) 29/11/2025 11:15: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 ( '100172' , '11193' , 'VENITE CON ME CAT.' , '55' , '-55' , '4' , '5.50' , '5.5' , '0' , '0' , '302.50' ) 29/11/2025 11:15: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 ( '100172' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '15.5' , '15.5' , '0' , '' , '15.50' ) 29/11/2025 11:16:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3989' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 11:16: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' , '3989' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '13.30' , NOW() , NOW() ) 29/11/2025 11:16: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 = '100173' 29/11/2025 11:16:53 am >> DELETE FROM ps_document_detail WHERE id_document = '100173' 29/11/2025 11:16: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 ( '100173' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 29/11/2025 11:24:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 11:24:30 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' , '3990' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.80' , '21.87' , NOW() , NOW() ) 29/11/2025 11:24: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 = '100174' 29/11/2025 11:24:30 am >> DELETE FROM ps_document_detail WHERE id_document = '100174' 29/11/2025 11:24: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 ( '100174' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 29/11/2025 11:24: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 ( '100174' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/11/2025 11:24: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 ( '100174' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 29/11/2025 11:24: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 ( '100174' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 29/11/2025 11:39:00 am >> SELECT document_num FROM ps_document WHERE document_num = '35' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 11:39:00 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 ( '24' , '35' , '2025-11-29' , '' , '1178' , '0' , '4679509' , 'P. ZZA LINGUITI, 1 84095 GIFFONI VALLE PIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '77.87' , NOW() , NOW() ) 29/11/2025 11:39:00 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 = '100175' 29/11/2025 11:39:00 am >> DELETE FROM ps_document_detail WHERE id_document = '100175' 29/11/2025 11:39:00 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 ( '100175' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 29/11/2025 11:39:00 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 ( '100175' , '24193' , 'NATIVITA 21X25 - P802' , '1' , '-1' , '1' , '61' , '50' , '22' , '0' , '61.00' ) 29/11/2025 11:44:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 11:44:52 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' , '3991' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 29/11/2025 11:44:52 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 = '100176' 29/11/2025 11:44:52 am >> DELETE FROM ps_document_detail WHERE id_document = '100176' 29/11/2025 11:44:52 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 ( '100176' , '5999' , 'LUME VETRO SOFFIATO MELOGRANO - 1021' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '28.00' ) 29/11/2025 11:44:52 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 ( '100176' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 29/11/2025 11:44:52 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 ( '100176' , '5975' , 'LUCERNA COLORATA - 1491' , '1' , '-1' , '1' , '21' , '17.213114754098' , '22' , '0' , '21.00' ) 29/11/2025 11:44:52 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 ( '100176' , '19910' , 'LUCERNA COLORATA - 1490/KIT' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 29/11/2025 11:51:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3922' AND id_document != '100089' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26') 29/11/2025 11:51:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3922', document_date = '2025-11-26', 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 = '35.00', price_tax_excluded = '28.69', date_upd = NOW() WHERE id_document = '100089' 29/11/2025 11:51:22 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 = '100089' 29/11/2025 11:51:22 am >> DELETE FROM ps_document_detail WHERE id_document = '100089' 29/11/2025 11:51:22 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 ( '100089' , '6343' , 'MEDAGLIA S. BENEDETTO ARGENTO - MM18 - RA 634' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 29/11/2025 11:51:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3837' AND id_document != '99972' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-18') 29/11/2025 11:51:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3837', document_date = '2025-11-18', 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 = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '99972' 29/11/2025 11:51:55 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 = '99972' 29/11/2025 11:51:55 am >> DELETE FROM ps_document_detail WHERE id_document = '99972' 29/11/2025 11:51:55 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 ( '99972' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 29/11/2025 11:51:55 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 ( '99972' , '21861' , 'BAMBINELLO CM 7 - PKS07-C' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 29/11/2025 12:07:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 29/11/2025 12:07:07 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' , '3992' , '2025-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '14.59' , NOW() , NOW() ) 29/11/2025 12:07:07 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 = '100177' 29/11/2025 12:07:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '100177' 29/11/2025 12:07:07 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 ( '100177' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 29/11/2025 12:44:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3848' AND id_document != '99983' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 29/11/2025 12:44:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3848', document_date = '2025-11-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 = '46.50', price_tax_excluded = '43.43', date_upd = NOW() WHERE id_document = '99983' 29/11/2025 12:44:12 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 = '99983' 29/11/2025 12:44:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '99983' 29/11/2025 12:44:12 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 ( '99983' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/11/2025 12:44:12 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 ( '99983' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 29/11/2025 12:44:12 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 ( '99983' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 29/11/2025 12:44:12 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 ( '99983' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 29/11/2025 12:44: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 ( '99983' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 29/11/2025 12:45:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3763' AND id_document != '99862' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-12') 29/11/2025 12:45:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3763', document_date = '2025-11-12', 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 = '264.20', price_tax_excluded = '234.55', date_upd = NOW() WHERE id_document = '99862' 29/11/2025 12:45:05 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 = '99862' 29/11/2025 12:45:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '99862' 29/11/2025 12:45:05 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 ( '99862' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/11/2025 12:45:05 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 ( '99862' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 29/11/2025 12:45:05 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 ( '99862' , '12490' , 'CROCE SAN BENEDETTO ULIVO - CZ6NIK' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 29/11/2025 12:45:05 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 ( '99862' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.7' , '6.7' , '0' , '0' , '6.70' ) 29/11/2025 12:45:05 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 ( '99862' , '3528' , 'DIO VIVO E VERO - L. F. LADARIA' , '1' , '-1' , '4' , '59.0000' , '59' , '0' , '5' , '56.05' ) 29/11/2025 12:45:05 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 ( '99862' , '1671' , 'CANTICO DEI CANTICI - RIL.' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' )