29/03/2025 09:51:52 am >> SELECT document_num FROM ps_document WHERE document_num = '827' AND id_document != '96175' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-11') 29/03/2025 09:51:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '827', document_date = '2025-03-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 = '229.50', price_tax_excluded = '194.79', date_upd = NOW() WHERE id_document = '96175' 29/03/2025 09:51: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 = '96175' 29/03/2025 09:51:52 am >> DELETE FROM ps_document_detail WHERE id_document = '96175' 29/03/2025 09:51: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 ( '96175' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '84.00' ) 29/03/2025 09:51: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 ( '96175' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/03/2025 09:51: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 ( '96175' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '9.5' , '9.5' , '0' , '0' , '9.50' ) 29/03/2025 09:51: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 ( '96175' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 29/03/2025 09:51: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 ( '96175' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 29/03/2025 09:52:13 am >> SELECT document_num FROM ps_document WHERE document_num = '932' AND id_document != '96312' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-20') 29/03/2025 09:52:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '932', document_date = '2025-03-20', 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 = '96.50', price_tax_excluded = '83.38', date_upd = NOW() WHERE id_document = '96312' 29/03/2025 09:52:14 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 = '96312' 29/03/2025 09:52:14 am >> DELETE FROM ps_document_detail WHERE id_document = '96312' 29/03/2025 09:52:14 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 ( '96312' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 29/03/2025 09:52:14 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 ( '96312' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 29/03/2025 09:52:14 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 ( '96312' , '22286' , 'COLLETTO DOPPIO MISTO LINO - CD01/C' , '1' , '-1' , '1' , '17.5000' , '14.344262295082' , '22' , '0' , '17.50' ) 29/03/2025 09:52:14 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 ( '96312' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.85' , '7.2540983606557' , '22' , '0' , '8.85' ) 29/03/2025 09:52:14 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 ( '96312' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 29/03/2025 09:52:14 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 ( '96312' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '2' , '-2' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '4.40' ) 29/03/2025 09:52:47 am >> SELECT document_num FROM ps_document WHERE document_num = '926' AND id_document != '96305' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-20') 29/03/2025 09:52:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '926', document_date = '2025-03-20', 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 = '2.00', price_tax_excluded = '1.64', date_upd = NOW() WHERE id_document = '96305' 29/03/2025 09:52:47 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 = '96305' 29/03/2025 09:52:47 am >> DELETE FROM ps_document_detail WHERE id_document = '96305' 29/03/2025 09:52:47 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 ( '96305' , '4971' , 'IMMAGINE IN CARTA - SCA5070' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 29/03/2025 09:53:18 am >> SELECT document_num FROM ps_document WHERE document_num = '871' AND id_document != '96238' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-14') 29/03/2025 09:53:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '871', document_date = '2025-03-14', 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 = '96238' 29/03/2025 09:53: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 = '96238' 29/03/2025 09:53:18 am >> DELETE FROM ps_document_detail WHERE id_document = '96238' 29/03/2025 09:53: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 ( '96238' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 29/03/2025 09:53: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 ( '96238' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 29/03/2025 09:53: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 ( '96238' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '5' , '-5' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '3.50' ) 29/03/2025 09:53: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 ( '96238' , '19362' , 'LUMINO DIAMANTE VARI COLORI' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 29/03/2025 10:04:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1767' AND id_document != '92019' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 29/03/2025 10:04:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1767', document_date = '2024-05-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '256.70', price_tax_excluded = '218.60', date_upd = NOW() WHERE id_document = '92019' 29/03/2025 10:04:21 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 = '92019' 29/03/2025 10:04:21 am >> DELETE FROM ps_document_detail WHERE id_document = '92019' 29/03/2025 10:04:21 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 ( '92019' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 29/03/2025 10:04:21 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 ( '92019' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 29/03/2025 10:04:21 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 ( '92019' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 29/03/2025 10:04:21 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 ( '92019' , '6019' , 'LUMINO ROSSO - 10B' , '27' , '-27' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.50' ) 29/03/2025 10:04:21 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 ( '92019' , '6014' , 'LUMINO BIANCO - 10B' , '27' , '-27' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.50' ) 29/03/2025 10:04:21 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 ( '92019' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 29/03/2025 10:04:21 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 ( '92019' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 29/03/2025 10:04:21 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 ( '92019' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 29/03/2025 10:04:21 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 ( '92019' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 29/03/2025 10:04:21 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 ( '92019' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '26' , '-26' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '18.20' ) 29/03/2025 10:04:21 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 ( '92019' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 29/03/2025 10:04:21 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 ( '92019' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 29/03/2025 10:04:21 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 ( '92019' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/03/2025 10:09:19 am >> SELECT document_num FROM ps_document WHERE document_num = '811' AND id_document != '96159' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-10') 29/03/2025 10:09:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '811', document_date = '2025-03-10', 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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '96159' 29/03/2025 10:09:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96159' 29/03/2025 10:09:19 am >> DELETE FROM ps_document_detail WHERE id_document = '96159' 29/03/2025 10:09:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96159' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 29/03/2025 10:10:00 am >> SELECT document_num FROM ps_document WHERE document_num = '166' AND id_document != '95318' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 29/03/2025 10:10:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '166', document_date = '2025-01-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '168.00', price_tax_excluded = '137.70', date_upd = NOW() WHERE id_document = '95318' 29/03/2025 10:10: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 = '95318' 29/03/2025 10:10:01 am >> DELETE FROM ps_document_detail WHERE id_document = '95318' 29/03/2025 10:10:01 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 ( '95318' , '23349' , 'DECINA IMITAZIONE PERLA 5MM - 1708' , '70' , '-70' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '140.00' ) 29/03/2025 10:10:01 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 ( '95318' , '13365' , 'SCATOLA 6x4' , '67' , '-67' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '26.80' ) 29/03/2025 10:10:01 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 ( '95318' , '12936' , 'SCATOLA 4X4' , '3' , '-3' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '1.20' ) 29/03/2025 10:14:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1008' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 10:14: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' , '1008' , '2025-03-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 29/03/2025 10:14: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 = '96407' 29/03/2025 10:14:28 am >> DELETE FROM ps_document_detail WHERE id_document = '96407' 29/03/2025 10:14: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 ( '96407' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 29/03/2025 10:44:44 am >> SELECT document_num FROM ps_document WHERE document_num = '966' AND id_document != '96354' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-25') 29/03/2025 10:44:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '966', document_date = '2025-03-25', 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 = '134.50', price_tax_excluded = '110.25', date_upd = NOW() WHERE id_document = '96354' 29/03/2025 10:44:44 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 = '96354' 29/03/2025 10:44:44 am >> DELETE FROM ps_document_detail WHERE id_document = '96354' 29/03/2025 10:44:44 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 ( '96354' , '12453' , 'CROCE DA TAVOLO - CM27' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 29/03/2025 10:44:44 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 ( '96354' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '39.5' , '32.377049180328' , '22' , '0' , '39.50' ) 29/03/2025 10:57:39 am >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '95744' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-14') 29/03/2025 10:57:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2025-02-14', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '2098.70', price_tax_excluded = '1729.11', date_upd = NOW() WHERE id_document = '95744' 29/03/2025 10:57: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 = '95744' 29/03/2025 10:57:39 am >> DELETE FROM ps_document_detail WHERE id_document = '95744' 29/03/2025 10:57: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 ( '95744' , '16796' , 'LUMINO 5B BIANCO' , '2016' , '-2016' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '403.20' ) 29/03/2025 10:57: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 ( '95744' , '1041' , 'BENEDIZIONI' , '1000' , '-1000' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '180.00' ) 29/03/2025 10:57: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 ( '95744' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '7' , '-7' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '168.00' ) 29/03/2025 10:57: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 ( '95744' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '290.00' ) 29/03/2025 10:57: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 ( '95744' , '23531' , 'COPRI LEZIONARIO PLACCA ARG. - 082' , '1' , '-1' , '1' , '146.0000' , '119.67213114754' , '22' , '0' , '146.00' ) 29/03/2025 10:57: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 ( '95744' , '16796' , 'LUMINO 5B BIANCO' , '3360' , '-3360' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '672.00' ) 29/03/2025 10:57: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 ( '95744' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 29/03/2025 10:57: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 ( '95744' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '28.00' ) 29/03/2025 10:57: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 ( '95744' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 29/03/2025 10:57: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 ( '95744' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '24.50' ) 29/03/2025 10:57: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 ( '95744' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 29/03/2025 10:57: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 ( '95744' , '15332' , 'GRANI PER CERO' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 29/03/2025 10:57: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 ( '95744' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 29/03/2025 10:57: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 ( '95744' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/03/2025 10:59:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1009' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 10:59: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' , '1009' , '2025-03-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.17' , '12.17' , NOW() , NOW() ) 29/03/2025 10:59: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 = '96408' 29/03/2025 10:59:57 am >> DELETE FROM ps_document_detail WHERE id_document = '96408' 29/03/2025 10:59: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 ( '96408' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/03/2025 10:59: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 ( '96408' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 29/03/2025 10:59:58 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 ( '96408' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 29/03/2025 11:46:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1010' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 11:46: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' , '1010' , '2025-03-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.87' , NOW() , NOW() ) 29/03/2025 11:46: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 = '96409' 29/03/2025 11:46:28 am >> DELETE FROM ps_document_detail WHERE id_document = '96409' 29/03/2025 11:46: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 ( '96409' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 29/03/2025 11:46: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 ( '96409' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/03/2025 11:47:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1011' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 11:47:25 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' , '1011' , '2025-03-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.00' , '64.75' , NOW() , NOW() ) 29/03/2025 11:47:25 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 = '96410' 29/03/2025 11:47:25 am >> DELETE FROM ps_document_detail WHERE id_document = '96410' 29/03/2025 11:47:25 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 ( '96410' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 29/03/2025 11:48:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1012' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 11:48:22 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' , '1012' , '2025-03-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 29/03/2025 11:48: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 = '96411' 29/03/2025 11:48:22 am >> DELETE FROM ps_document_detail WHERE id_document = '96411' 29/03/2025 11:48: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 ( '96411' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 29/03/2025 11:49:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1013' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 11:49:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1013' , '2025-03-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 29/03/2025 11:49:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96412' 29/03/2025 11:49:12 am >> DELETE FROM ps_document_detail WHERE id_document = '96412' 29/03/2025 11:49:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96412' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 29/03/2025 11:49:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1014' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 11:49:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1014' , '2025-03-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.41' , '104.41' , NOW() , NOW() ) 29/03/2025 11:49:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96413' 29/03/2025 11:49:51 am >> DELETE FROM ps_document_detail WHERE id_document = '96413' 29/03/2025 11:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96413' , '23527' , 'CODICE DI DIRITTO CANONICO - 9 EDIZ.' , '1' , '-1' , '4' , '109.90' , '109.9' , '0' , '5' , '104.41' ) 29/03/2025 11:58:11 am >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '95275' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-14') 29/03/2025 11:58:11 am >> UPDATE ps_document SET id_document_type = '24', document_num = '21/A', document_date = '2025-01-14', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '497.20', price_tax_excluded = '416.39', date_upd = NOW() WHERE id_document = '95275' 29/03/2025 11:58: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 = '95275' 29/03/2025 11:58:11 am >> DELETE FROM ps_document_detail WHERE id_document = '95275' 29/03/2025 11:58: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 ( '95275' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '60' , '-60' , '4' , '0.7000' , '0.7' , '0' , '0' , '42.00' ) 29/03/2025 11:58: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 ( '95275' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 29/03/2025 11:58: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 ( '95275' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 29/03/2025 11:58: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 ( '95275' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/03/2025 11:58: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 ( '95275' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - 1492' , '2' , '-2' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '34.00' ) 29/03/2025 11:58: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 ( '95275' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 29/03/2025 11:58: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 ( '95275' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 29/03/2025 11:58: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 ( '95275' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '5' , '-5' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '89.50' ) 29/03/2025 11:58: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 ( '95275' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 29/03/2025 11:58: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 ( '95275' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '25' , '20.491803278689' , '22' , '0' , '125.00' ) 29/03/2025 11:58:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1015' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 11:58:48 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' , '1015' , '2025-03-29' , '' , '3712' , '0' , '4671443' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '497.20' , '416.39' , NOW() , NOW() ) 29/03/2025 11:58:48 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 = '96414' 29/03/2025 11:58:48 am >> DELETE FROM ps_document_detail WHERE id_document = '96414' 29/03/2025 11:58:48 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 ( '96414' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '60' , '-60' , '4' , '0.7000' , '0.7' , '0' , '0' , '42.00' ) 29/03/2025 11:58:48 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 ( '96414' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2951' , '22' , '0' , '8.90' ) 29/03/2025 11:58:48 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 ( '96414' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 29/03/2025 11:58:48 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 ( '96414' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9231' , '4' , '0' , '2.00' ) 29/03/2025 11:58:48 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 ( '96414' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - 1492' , '2' , '-2' , '1' , '17.0000' , '13.9344' , '22' , '0' , '34.00' ) 29/03/2025 11:58:48 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 ( '96414' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377' , '22' , '0' , '70.00' ) 29/03/2025 11:58:48 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 ( '96414' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8525' , '22' , '0' , '112.80' ) 29/03/2025 11:58:48 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 ( '96414' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '5' , '-5' , '1' , '17.9000' , '14.6721' , '22' , '0' , '89.50' ) 29/03/2025 11:58:48 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 ( '96414' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.459' , '22' , '0' , '6.00' ) 29/03/2025 11:58:48 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 ( '96414' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '25.0000' , '20.4918' , '22' , '0' , '125.00' ) 29/03/2025 11:59:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1015' AND id_document != '96414' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 11:59:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1015', document_date = '2025-03-29', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '497.20', price_tax_excluded = '416.39', date_upd = NOW() WHERE id_document = '96414' 29/03/2025 11:59: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 = '96414' 29/03/2025 11:59:00 am >> DELETE FROM ps_document_detail WHERE id_document = '96414' 29/03/2025 11:59: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 ( '96414' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '60' , '-60' , '4' , '0.7000' , '0.7' , '0' , '0' , '42.00' ) 29/03/2025 11:59: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 ( '96414' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 29/03/2025 11:59: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 ( '96414' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 29/03/2025 11:59: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 ( '96414' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/03/2025 11:59: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 ( '96414' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - 1492' , '2' , '-2' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '34.00' ) 29/03/2025 11:59: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 ( '96414' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 29/03/2025 11:59: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 ( '96414' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 29/03/2025 11:59: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 ( '96414' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '5' , '-5' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '89.50' ) 29/03/2025 11:59:01 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 ( '96414' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 29/03/2025 11:59:01 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 ( '96414' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '125.00' ) 29/03/2025 12:22:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '811' AND id_document != '96159' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-10') 29/03/2025 12:22:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '811', document_date = '2025-03-10', 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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '96159' 29/03/2025 12:22:11 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 = '96159' 29/03/2025 12:22:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '96159' 29/03/2025 12:22:11 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 ( '96159' , '17617' , 'IMMAGINI ISONZO X 100' , '10' , '-10' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '35.00' ) 29/03/2025 12:22:11 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 ( '96159' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 29/03/2025 12:22:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '932' AND id_document != '96312' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-20') 29/03/2025 12:22:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '932', document_date = '2025-03-20', 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 = '96.50', price_tax_excluded = '83.38', date_upd = NOW() WHERE id_document = '96312' 29/03/2025 12:22:49 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 = '96312' 29/03/2025 12:22:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '96312' 29/03/2025 12:22:49 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 ( '96312' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 29/03/2025 12:22:49 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 ( '96312' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 29/03/2025 12:22:49 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 ( '96312' , '22286' , 'COLLETTO DOPPIO MISTO LINO - CD01/C' , '1' , '-1' , '1' , '17.5000' , '14.344262295082' , '22' , '0' , '17.50' ) 29/03/2025 12:22:49 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 ( '96312' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.85' , '1.516393442623' , '22' , '0' , '1.85' ) 29/03/2025 12:22:49 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 ( '96312' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 29/03/2025 12:22:49 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 ( '96312' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '2' , '-2' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '4.40' ) 29/03/2025 12:22:49 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 ( '96312' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 29/03/2025 12:23:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '798' AND id_document != '96141' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-10') 29/03/2025 12:23:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '798', document_date = '2025-03-10', 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 = '184.40', price_tax_excluded = '156.63', date_upd = NOW() WHERE id_document = '96141' 29/03/2025 12:23:33 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 = '96141' 29/03/2025 12:23:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '96141' 29/03/2025 12:23:33 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 ( '96141' , '22201' , 'UN TEMPO PER PIANTARE E UN TEMPO PER SDRAIARE - T. HALIK' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 29/03/2025 12:23:33 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 ( '96141' , '23449' , 'TENTATI MA NON VINTI - L. PASQUA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 29/03/2025 12:23:33 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 ( '96141' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '139.0000' , '113.93442622951' , '22' , '0' , '139.00' ) 29/03/2025 12:23:33 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 ( '96141' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 29/03/2025 12:23:33 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 ( '96141' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/03/2025 12:24:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '834' AND id_document != '96184' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-11') 29/03/2025 12:24:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '834', document_date = '2025-03-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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '96184' 29/03/2025 12:24:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96184' 29/03/2025 12:24:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '96184' 29/03/2025 12:24:34 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 ( '96184' , '1914' , 'CERA DELLA LITURGIA' , '10' , '-10' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '45.00' ) 29/03/2025 12:26:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '858' AND id_document != '96218' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-13') 29/03/2025 12:26:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '858', document_date = '2025-03-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '134.90', price_tax_excluded = '113.55', date_upd = NOW() WHERE id_document = '96218' 29/03/2025 12:26: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 = '96218' 29/03/2025 12:26:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '96218' 29/03/2025 12:26: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 ( '96218' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '5' , '-5' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '45.00' ) 29/03/2025 12:26: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 ( '96218' , '18140' , 'TAU SNODATO PADRE NOSTRO MEDIO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/03/2025 12:26: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 ( '96218' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 29/03/2025 12:26: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 ( '96218' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '17.90' ) 29/03/2025 12:26: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 ( '96218' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 29/03/2025 12:26: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 ( '96218' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 29/03/2025 12:26: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 ( '96218' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '9.00' ) 29/03/2025 12:26: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 ( '96218' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 29/03/2025 12:26:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1016' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 12:26:42 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' , '1016' , '2025-03-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '11.90' , NOW() , NOW() ) 29/03/2025 12:26: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 = '96415' 29/03/2025 12:26:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '96415' 29/03/2025 12:26: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 ( '96415' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '5' , '-5' , '4' , '2.50' , '2.5' , '0' , '5' , '11.90' ) 29/03/2025 12:30:07 pm >> DELETE FROM ps_document WHERE id_document = '95275' 29/03/2025 12:30:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '95275' 29/03/2025 12:37:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1017' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 12:37:49 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' , '1017' , '2025-03-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.45' , '10.45' , NOW() , NOW() ) 29/03/2025 12:37:49 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 = '96416' 29/03/2025 12:37:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '96416' 29/03/2025 12:37:49 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 ( '96416' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 29/03/2025 12:37:49 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 ( '96416' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 29/03/2025 12:50:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-03-29') 29/03/2025 12:50: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 ( '24' , '15' , '2025-03-29' , '' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '515.84' , '515.84' , NOW() , NOW() ) 29/03/2025 12:50: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 = '96417' 29/03/2025 12:50:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '96417' 29/03/2025 12:50: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 ( '96417' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '560' , '-560' , '4' , '1.00' , '1' , '0' , '38' , '347.20' ) 29/03/2025 12:50: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 ( '96417' , '15019' , 'PREGHIAMO CON MARIA' , '340' , '-340' , '4' , '0.80' , '0.8' , '0' , '38' , '168.64' )