06/06/2025 09:41:08 am >> SELECT document_num FROM ps_document WHERE document_num = '76' AND id_document != '97565' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-06-05') 06/06/2025 09:41:08 am >> UPDATE ps_document SET id_document_type = '21', document_num = '76', document_date = '2025-06-05', document_letter = '', id_customer = '3356', id_supplier = '', id_address = '4671990', address1 = 'VIA SALVATORE DE RENZI, 26 84125 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '72.00', price_tax_excluded = '72.00', date_upd = NOW() WHERE id_document = '97565' 06/06/2025 09:41:08 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 = '97565' 06/06/2025 09:41:08 am >> DELETE FROM ps_document_detail WHERE id_document = '97565' 06/06/2025 09:41:08 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 ( '97565' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '25' , '-25' , '4' , '2.8000' , '2.8' , '0' , '15' , '59.50' ) 06/06/2025 09:41:08 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 ( '97565' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '25' , '-25' , '0' , '0.5000' , '0.5' , '0' , '0' , '12.50' ) 06/06/2025 09:50:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2014' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 09:50: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' , '2014' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '20.08' , NOW() , NOW() ) 06/06/2025 09:50: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 = '97582' 06/06/2025 09:50:48 am >> DELETE FROM ps_document_detail WHERE id_document = '97582' 06/06/2025 09:50: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 ( '97582' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 06/06/2025 09:52:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2015' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 09:52:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2015' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '147.95' , '131.79' , NOW() , NOW() ) 06/06/2025 09:52:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97583' 06/06/2025 09:52:23 am >> DELETE FROM ps_document_detail WHERE id_document = '97583' 06/06/2025 09:52:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97583' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '30.00' ) 06/06/2025 09:52:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97583' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 06/06/2025 09:52:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97583' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 06/06/2025 09:52:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97583' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 06/06/2025 09:52:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97583' , '17257' , 'IO TI BATTEZZO ' , '15' , '-15' , '4' , '1.53' , '1.53' , '0' , '0' , '22.95' ) 06/06/2025 09:53:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2016' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 09:53: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 ( '11' , '2016' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 06/06/2025 09:53: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 = '97584' 06/06/2025 09:53:00 am >> DELETE FROM ps_document_detail WHERE id_document = '97584' 06/06/2025 09:53: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 ( '97584' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 06/06/2025 10:00:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2017' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 10:00:50 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' , '2017' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 06/06/2025 10:00:50 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 = '97585' 06/06/2025 10:00:50 am >> DELETE FROM ps_document_detail WHERE id_document = '97585' 06/06/2025 10:00:50 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 ( '97585' , '20516' , 'CROCE COMUNIONE - 42/08' , '20' , '-20' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '24.00' ) 06/06/2025 10:12:15 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 06/06/2025 10:12:15 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '758.57', price_tax_excluded = '633.16', date_upd = NOW() WHERE id_document = '95409' 06/06/2025 10:12: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 = '95409' 06/06/2025 10:12:15 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 06/06/2025 10:12: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 ( '95409' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '90.00' ) 06/06/2025 10:12: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 ( '95409' , '0' , '9/3/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 06/06/2025 10:12: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 ( '95409' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '25' , '-25' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '60.00' ) 06/06/2025 10:12: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 ( '95409' , '0' , '27/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 06/06/2025 10:12: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 ( '95409' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '18' , '-18' , '4' , '0.7000' , '0.7' , '0' , '0' , '12.60' ) 06/06/2025 10:12: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 ( '95409' , '0' , '26/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 06/06/2025 10:12: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 ( '95409' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 06/06/2025 10:12: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 ( '95409' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 06/06/2025 10:12: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 ( '95409' , '0' , '11/04' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 06/06/2025 10:12: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 ( '95409' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '145.00' ) 06/06/2025 10:12: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 ( '95409' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 06/06/2025 10:12: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 ( '95409' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 06/06/2025 10:12: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 ( '95409' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.3400' , '2.7377049180328' , '22' , '0' , '10.02' ) 06/06/2025 10:12: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 ( '95409' , '7202' , 'ARTICOLI RELIGIOSI buste palma' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 06/06/2025 10:12: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 ( '95409' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 06/06/2025 10:12: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 ( '95409' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 06/06/2025 10:12: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 ( '95409' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 06/06/2025 10:12: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 ( '95409' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '56.00' ) 06/06/2025 10:12: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 ( '95409' , '0' , '30/04/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 06/06/2025 10:12:16 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 ( '95409' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 06/06/2025 10:12:16 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 ( '95409' , '0' , '24/05' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 06/06/2025 10:12:16 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 ( '95409' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 06/06/2025 10:12:16 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 ( '95409' , '0' , '4/6/25' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 06/06/2025 10:12:16 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 ( '95409' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 06/06/2025 10:12:16 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 ( '95409' , '15463' , 'PICCOLO CATECHISMO DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 06/06/2025 10:12:16 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 ( '95409' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 06/06/2025 10:12:16 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 ( '95409' , '7202' , 'ARTICOLI RELIGIOSI PLACCA COMUNIONE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 06/06/2025 10:12:16 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 ( '95409' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '25' , '-25' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '55.00' ) 06/06/2025 10:12:16 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 ( '95409' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 06/06/2025 10:12:16 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 ( '95409' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 06/06/2025 10:12:16 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 ( '95409' , '' , '06/06' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 06/06/2025 10:12:16 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 ( '95409' , '6019' , 'LUMINO ROSSO - 10B' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 06/06/2025 10:12:16 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 ( '95409' , '5312' , 'INNO ALLO SPIRITO SANTO' , '50' , '-50' , '4' , '0.20' , '0.2' , '0' , '0' , '10.00' ) 06/06/2025 10:12:16 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 ( '95409' , '20516' , 'CROCE COMUNIONE - 42/08' , '10' , '-10' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '12.00' ) 06/06/2025 10:15:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2018' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 10:15:29 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' , '2018' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '59.02' , NOW() , NOW() ) 06/06/2025 10:15:29 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 = '97586' 06/06/2025 10:15:29 am >> DELETE FROM ps_document_detail WHERE id_document = '97586' 06/06/2025 10:15:29 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 ( '97586' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' , '-2' , '1' , '36' , '29.508196721311' , '22' , '0' , '72.00' ) 06/06/2025 10:15:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2019' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 10:15: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' , '2019' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 06/06/2025 10:15: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 = '97587' 06/06/2025 10:15:52 am >> DELETE FROM ps_document_detail WHERE id_document = '97587' 06/06/2025 10:15: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 ( '97587' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 06/06/2025 10:18:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2020' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 10:18:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2020' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 06/06/2025 10:18:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97588' 06/06/2025 10:18:42 am >> DELETE FROM ps_document_detail WHERE id_document = '97588' 06/06/2025 10:18:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97588' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '17.50' ) 06/06/2025 10:18:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97588' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 06/06/2025 11:01:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2021' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 11:01:20 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' , '2021' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.50' , '51.88' , NOW() , NOW() ) 06/06/2025 11:01:20 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 = '97589' 06/06/2025 11:01:20 am >> DELETE FROM ps_document_detail WHERE id_document = '97589' 06/06/2025 11:01:20 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 ( '97589' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 06/06/2025 11:01:20 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 ( '97589' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 06/06/2025 11:01:20 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 ( '97589' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 06/06/2025 11:01:20 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 ( '97589' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 06/06/2025 11:01:20 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 ( '97589' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '13.50' ) 06/06/2025 11:16:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2022' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 11:16:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2022' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.40' , '25.40' , NOW() , NOW() ) 06/06/2025 11:16:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97590' 06/06/2025 11:16:02 am >> DELETE FROM ps_document_detail WHERE id_document = '97590' 06/06/2025 11:16:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97590' , '4487' , 'GESÙ NEL CUORE - ALBUM PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 06/06/2025 11:16:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97590' , '19654' , 'ALBUM RICORDO PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.50' , '12.5' , '0' , '0' , '12.50' ) 06/06/2025 11:27:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2023' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 11:27:32 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' , '2023' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.10' , '65.76' , NOW() , NOW() ) 06/06/2025 11:27:32 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 = '97591' 06/06/2025 11:27:32 am >> DELETE FROM ps_document_detail WHERE id_document = '97591' 06/06/2025 11:27:32 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 ( '97591' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 06/06/2025 11:27:32 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 ( '97591' , '17881' , 'CROCE FAGGIO CORPO MET CM 20 - 167' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 06/06/2025 11:27:32 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 ( '97591' , '4185' , 'FILOTEA - S. FRANCESCO DI SALES - 8240' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 06/06/2025 11:27:32 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 ( '97591' , '23789' , 'SAN PIERGIORGIO FRASSATI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 06/06/2025 11:43: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 ( '31' , 'A2445' , '2025-06-05' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '393.02' , '322.15' , NOW() , NOW() ) 06/06/2025 11:43: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 = '97592' 06/06/2025 11:43:12 am >> DELETE FROM ps_document_detail WHERE id_document = '97592' 06/06/2025 11:43: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 ( '97592' , '21095' , 'QUADRETTO DA POGGIO EFFETTO PIETRA - 2950' , '20' , '20' , '1' , '2.62' , '2.1475409836066' , '22' , '0' , '63.9280' ) 06/06/2025 11:43:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21095' AND id_supplier = '28' 06/06/2025 11:43:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21095' , '28' , '1' ) 06/06/2025 11:43: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 ( '97592' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '5' , '5' , '1' , '3.29' , '2.6967213114754' , '22' , '0' , '20.0690' ) 06/06/2025 11:43:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '22409' AND id_supplier = '28' 06/06/2025 11:43:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22409' , '28' , '1' ) 06/06/2025 11:43: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 ( '97592' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '3' , '3' , '1' , '9.06' , '7.4262295081967' , '22' , '0' , '33.1596' ) 06/06/2025 11:43:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21561' AND id_supplier = '28' 06/06/2025 11:43:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21561' , '28' , '1' ) 06/06/2025 11:43: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 ( '97592' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '4' , '4' , '1' , '4.53' , '3.7131147540984' , '22' , '0' , '22.1064' ) 06/06/2025 11:43:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21096' AND id_supplier = '28' 06/06/2025 11:43:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21096' , '28' , '1' ) 06/06/2025 11:43:13 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 ( '97592' , '18276' , 'CINGOLO CON NODI - 3280' , '100' , '100' , '1' , '1.09' , '0.89344262295082' , '22' , '0' , '132.9800' ) 06/06/2025 11:43:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '18276' AND id_supplier = '28' 06/06/2025 11:43:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18276' , '28' , '1' ) 06/06/2025 11:43:13 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 ( '97592' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '20' , '20' , '1' , '3.15' , '2.5819672131148' , '22' , '0' , '76.8600' ) 06/06/2025 11:43:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '22198' AND id_supplier = '28' 06/06/2025 11:43:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22198' , '28' , '1' ) 06/06/2025 11:43:13 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 ( '97592' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '10' , '10' , '1' , '2.1' , '1.7213114754098' , '22' , '0' , '25.6200' ) 06/06/2025 11:43:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '13562' AND id_supplier = '28' 06/06/2025 11:43:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13562' , '28' , '1' ) 06/06/2025 11:56:42 am >> SELECT document_num FROM ps_document WHERE document_num = '13/S' AND id_document != '14817' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 11:56:42 am >> UPDATE ps_document SET id_document_type = '22', document_num = '13/S', document_date = '2025-06-06', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO MAGGIO 2025', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '857.10', price_tax_excluded = '857.10', date_upd = NOW() WHERE id_document = '14817' 06/06/2025 11:56:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14817' 06/06/2025 11:56:42 am >> DELETE FROM ps_document_detail WHERE id_document = '14817' 06/06/2025 11:56:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '17' , 'LA FEDE NELLO ZAINETTO' , '5' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '15.00' ) 06/06/2025 11:56:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '3' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 06/06/2025 11:56:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '75' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '56.25' ) 06/06/2025 11:56:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '18' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '22.50' ) 06/06/2025 11:56:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 06/06/2025 11:56: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 ( '14817' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 06/06/2025 11:56: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 ( '14817' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 06/06/2025 11:56: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 ( '14817' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '71' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '88.75' ) 06/06/2025 11:56: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 ( '14817' , '33' , '100 GIORNI CON LO SPIRITO' , '11' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '41.25' ) 06/06/2025 11:56: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 ( '14817' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '5' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '7.50' ) 06/06/2025 11:56: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 ( '14817' , '44' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '0' , '4' , '9.9000' , '9.9' , '0' , '50' , '4.95' ) 06/06/2025 11:56: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 ( '14817' , '46' , 'LE LETTERE DI SAN PAOLO' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 06/06/2025 11:56: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 ( '14817' , '50' , 'PERDONAMI SIGNORE' , '126' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '157.50' ) 06/06/2025 11:56: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 ( '14817' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 06/06/2025 11:56: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 ( '14817' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '8' , '0' , '4' , '30.0000' , '30' , '0' , '50' , '120.00' ) 06/06/2025 11:56: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 ( '14817' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 06/06/2025 11:56: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 ( '14817' , '80' , 'MISERICORDIA' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 06/06/2025 11:56: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 ( '14817' , '88' , 'GESÙ È RISORTO' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 06/06/2025 11:56: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 ( '14817' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '8' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '7.20' ) 06/06/2025 11:56: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 ( '14817' , '92' , 'LA PREGHIERA DEL ROSARIO' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 06/06/2025 11:56: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 ( '14817' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 06/06/2025 11:56: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 ( '14817' , '110' , 'SE MI AMI NON PIANGERE' , '9' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '8.10' ) 06/06/2025 11:56: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 ( '14817' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '6' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '9.00' ) 06/06/2025 11:56: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 ( '14817' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 06/06/2025 11:56: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 ( '14817' , '117' , 'La preghiera delle cinque dita n.e.' , '6' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '5.40' ) 06/06/2025 11:56: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 ( '14817' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '55' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '68.75' ) 06/06/2025 11:56: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 ( '14817' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '8' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '10.00' ) 06/06/2025 11:56: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 ( '14817' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '12' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '18.00' ) 06/06/2025 11:56: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 ( '14817' , '138' , 'LA NASCITA DI GESU' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 06/06/2025 11:56: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 ( '14817' , '139' , 'E NATO - n.e.' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '5.00' ) 06/06/2025 11:56: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 ( '14817' , '136' , 'ANGELO DI DIO N.E.' , '10' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '9.00' ) 06/06/2025 11:56: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 ( '14817' , '137' , 'AVVENTO' , '8' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '10.00' ) 06/06/2025 11:56: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 ( '14817' , '126' , 'SACRAMENTO DEL PERDONO' , '134' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '134.00' ) 06/06/2025 11:57:04 am >> SELECT document_num FROM ps_document WHERE document_num = '14/S' AND id_document != '14818' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 11:57:04 am >> UPDATE ps_document SET id_document_type = '25', document_num = '14/S', document_date = '2025-06-06', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA MAGGIO 2025', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '19.85', price_tax_excluded = '19.85', date_upd = NOW() WHERE id_document = '14818' 06/06/2025 11:57:04 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 = '14818' 06/06/2025 11:57:04 am >> DELETE FROM ps_document_detail WHERE id_document = '14818' 06/06/2025 11:57:04 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 ( '14818' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 06/06/2025 11:57:04 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 ( '14818' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 06/06/2025 11:57:04 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 ( '14818' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '2' , '2' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 06/06/2025 11:57:04 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 ( '14818' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '3' , '3' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 06/06/2025 11:57:04 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 ( '14818' , '117' , 'La preghiera delle cinque dita n.e.' , '6' , '6' , '4' , '1.8000' , '1.8' , '0' , '50' , '5.40' ) 06/06/2025 11:57:04 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 ( '14818' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '2' , '2' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 06/06/2025 11:57:04 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 ( '14818' , '138' , 'LA NASCITA DI GESU' , '1' , '1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 06/06/2025 11:57:04 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 ( '14818' , '139' , 'E NATO - n.e.' , '2' , '2' , '4' , '2.0000' , '2' , '0' , '50' , '2.00' ) 06/06/2025 12:07:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2024' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 12:07:45 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' , '2024' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.50' , '72.54' , NOW() , NOW() ) 06/06/2025 12:07:45 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 = '97593' 06/06/2025 12:07:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '97593' 06/06/2025 12:07:45 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 ( '97593' , '1823' , 'CATECHISMO DELLA CHIESA CATTOLICA - COMPENDIO' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '0' , '50.00' ) 06/06/2025 12:07:45 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 ( '97593' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 06/06/2025 12:07:45 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 ( '97593' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '3' , '-3' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '24.00' ) 06/06/2025 12:08:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2025' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 12:08:55 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' , '2025' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '62.30' , NOW() , NOW() ) 06/06/2025 12:08:55 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 = '97594' 06/06/2025 12:08:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97594' 06/06/2025 12:08:55 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 ( '97594' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 06/06/2025 12:08:55 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 ( '97594' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '36.50' ) 06/06/2025 12:09:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2026' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 12:09:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2026' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 06/06/2025 12:09:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97595' 06/06/2025 12:09:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '97595' 06/06/2025 12:09:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97595' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 06/06/2025 12:09:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97595' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 06/06/2025 12:09:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2027' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 12:09:46 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' , '2027' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.10' , '104.10' , NOW() , NOW() ) 06/06/2025 12:09:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97596' 06/06/2025 12:09:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '97596' 06/06/2025 12:09:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97596' , '1090' , 'BIBBIA' , '10' , '-10' , '4' , '9.90' , '9.9' , '0' , '5' , '94.10' ) 06/06/2025 12:09:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97596' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 06/06/2025 12:13:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872037713' AND id_product != '23725' AND ean13 != '' 06/06/2025 12:13:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788872037713', date_upd = NOW() WHERE id_product = '23725' 06/06/2025 12:13:14 pm >> UPDATE ps_product_lang SET name = 'RISPOSTE SEMPLICI A DOMANDE INTERESSANTI', description = '' WHERE id_product = '23725' 06/06/2025 12:13:14 pm >> UPDATE ps_product SET wholesale_price = '7.50', on_sale = '0', price = '15.0000' WHERE id_product = '23725' 06/06/2025 12:13:14 pm >> UPDATE ps_product_shop SET wholesale_price = '7.50', price = '15.0000', id_tax_rules_group = '4', id_category_default = '501', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23725' 06/06/2025 12:13:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '23725' 06/06/2025 12:13:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2028' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 12:13:52 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' , '2028' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.80' , '31.71' , NOW() , NOW() ) 06/06/2025 12:13:52 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 = '97597' 06/06/2025 12:13:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '97597' 06/06/2025 12:13:52 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 ( '97597' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 06/06/2025 12:13:52 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 ( '97597' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 06/06/2025 12:13:52 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 ( '97597' , '23725' , 'RISPOSTE SEMPLICI A DOMANDE INTERESSANTI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 06/06/2025 12:13:52 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 ( '97597' , '23663' , 'SPIAZZATI DALLO SPIRITO - P. CURTAZ' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 06/06/2025 12:44:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2029' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 12:44:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2029' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '430.00' , '352.46' , NOW() , NOW() ) 06/06/2025 12:44:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97598' 06/06/2025 12:44:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '97598' 06/06/2025 12:44:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97598' , '16040' , 'STOLA ROMANA S/MOIRE - 7336S' , '1' , '-1' , '1' , '390' , '319.67213114754' , '22' , '0' , '390.00' ) 06/06/2025 12:44:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97598' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 06/06/2025 01:03:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2030' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 01:03:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2030' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.50' , '23.34' , NOW() , NOW() ) 06/06/2025 01:03:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97599' 06/06/2025 01:03:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '97599' 06/06/2025 01:03:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97599' , '12169' , 'NOVITA DI DIO' , '5' , '-5' , '4' , '2.00' , '2' , '0' , '0' , '10.00' ) 06/06/2025 01:03:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97599' , '21573' , 'CON LA FORZA DELLO SPIRITO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 06/06/2025 01:03:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97599' , '20072' , 'BRACCIALE - BC1759N' , '5' , '-5' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '10.00' ) 06/06/2025 01:03:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97599' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 06/06/2025 03:05:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2031' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 03:05:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2031' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '83.51' , NOW() , NOW() ) 06/06/2025 03:05:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97600' 06/06/2025 03:05:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '97600' 06/06/2025 03:05:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97600' , '22497' , 'QUADRETTO CRESIMA - 31/264-1K' , '8' , '-8' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '39.20' ) 06/06/2025 03:05:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97600' , '23283' , 'LIBRO DELLA VITA - M. ZAPPELLA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 06/06/2025 03:05:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97600' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '14.2' , '14.2' , '0' , '' , '14.20' ) 06/06/2025 03:05:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97600' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 06/06/2025 04:53:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2032' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 04:53:27 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' , '2032' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 06/06/2025 04:53:27 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 = '97601' 06/06/2025 04:53:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '97601' 06/06/2025 04:53:27 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 ( '97601' , '22357' , 'CROCE RESINA - 692/02' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 06/06/2025 04:53:27 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 ( '97601' , '2655' , 'CONFEZIONE CARTONCINO CONFESSIONE - 2331/J44' , '8' , '-8' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '20.00' ) 06/06/2025 04:53:27 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 ( '97601' , '19312' , 'PORTACHIAVE COMUNIONE - 1828/K25' , '6' , '-6' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '16.20' ) 06/06/2025 04:53:27 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 ( '97601' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '1' , '-1' , '1' , '22.3' , '18.27868852459' , '22' , '0' , '22.30' ) 06/06/2025 05:11:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 05:11:45 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' , '2033' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.13' , '46.77' , NOW() , NOW() ) 06/06/2025 05:11:45 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 = '97602' 06/06/2025 05:11:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '97602' 06/06/2025 05:11:45 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 ( '97602' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 06/06/2025 05:11:45 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 ( '97602' , '17415' , 'BIBBIA - SCRUTATE LE SCRITTURE' , '1' , '-1' , '4' , '29.00' , '29' , '0' , '5' , '27.55' ) 06/06/2025 05:11:45 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 ( '97602' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 06/06/2025 05:11:45 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 ( '97602' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 06/06/2025 05:26:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '87/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 05:26:38 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' , '87/A' , '2025-06-06' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10150.00' , '10150.00' , NOW() , NOW() ) 06/06/2025 05:26:38 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 = '97603' 06/06/2025 05:26:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '97603' 06/06/2025 05:26:38 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 ( '97603' , '' , 'PORTACHIAVI - SAN CESARE' , '550' , '-550' , '0' , '3' , '3' , '' , '0' , '1650.00' ) 06/06/2025 05:26:39 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 ( '97603' , '' , 'ROSARIO CRISTALLO - SAN CESARE' , '1000' , '-1000' , '0' , '5' , '5' , '' , '0' , '5000.00' ) 06/06/2025 05:26:39 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 ( '97603' , '' , 'ROSARIO VETRO - SAN CESARE' , '1000' , '-1000' , '0' , '3.5' , '3.5' , '' , '0' , '3500.00' ) 06/06/2025 05:26:54 pm >> DELETE FROM ps_document WHERE id_document = '97603' 06/06/2025 05:26:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '97603' 06/06/2025 05:44:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2025' AND id_document != '97594' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 05:44:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2025', document_date = '2025-06-06', 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 = '76.00', price_tax_excluded = '62.30', date_upd = NOW() WHERE id_document = '97594' 06/06/2025 05:44:55 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 = '97594' 06/06/2025 05:44:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97594' 06/06/2025 05:44:55 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 ( '97594' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '39.50' ) 06/06/2025 05:44:55 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 ( '97594' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '36.5' , '29.918032786885' , '22' , '0' , '36.50' ) 06/06/2025 05:45:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2019' AND id_document != '97587' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 05:45:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2019', document_date = '2025-06-06', 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 = '36.00', price_tax_excluded = '29.51', date_upd = NOW() WHERE id_document = '97587' 06/06/2025 05:45:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97587' 06/06/2025 05:45:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '97587' 06/06/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97587' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 06/06/2025 06:25:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2034' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 06:25:25 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' , '2034' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 06/06/2025 06:25:25 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 = '97604' 06/06/2025 06:25:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '97604' 06/06/2025 06:25:25 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 ( '97604' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/06/2025 07:22:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2035' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-06') 06/06/2025 07:22:55 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' , '2035' , '2025-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 06/06/2025 07:22:55 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 = '97605' 06/06/2025 07:22:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97605' 06/06/2025 07:22:55 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 ( '97605' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' )