07/07/2025 09:38:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2375' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 09:38: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' , '2375' , '2025-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 07/07/2025 09:38: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 = '98006' 07/07/2025 09:38:52 am >> DELETE FROM ps_document_detail WHERE id_document = '98006' 07/07/2025 09:38: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 ( '98006' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 07/07/2025 11:04:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2376' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 11:04:13 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' , '2376' , '2025-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 07/07/2025 11:04:13 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 = '98007' 07/07/2025 11:04:13 am >> DELETE FROM ps_document_detail WHERE id_document = '98007' 07/07/2025 11:04: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 ( '98007' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '3' , '-3' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '4.50' ) 07/07/2025 11:09:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2323' AND id_document != '97939' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 07/07/2025 11:09:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2323', document_date = '2025-07-01', 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 = '5.80', price_tax_excluded = '4.75', date_upd = NOW() WHERE id_document = '97939' 07/07/2025 11:09: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 = '97939' 07/07/2025 11:09:14 am >> DELETE FROM ps_document_detail WHERE id_document = '97939' 07/07/2025 11:09: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 ( '97939' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 07/07/2025 11:09: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 ( '97939' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 07/07/2025 11:28:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2377' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 11:28: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' , '2377' , '2025-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 07/07/2025 11:28: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 = '98008' 07/07/2025 11:28:57 am >> DELETE FROM ps_document_detail WHERE id_document = '98008' 07/07/2025 11:28: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 ( '98008' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/07/2025 11:28: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 ( '98008' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/07/2025 11:45:37 am >> SELECT document_num FROM ps_document WHERE document_num = '24/E' AND id_document != '97618' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-30') 07/07/2025 11:45:37 am >> UPDATE ps_document SET id_document_type = '23', document_num = '24/E', document_date = '2025-06-30', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', 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 = '882.45', price_tax_excluded = '882.45', date_upd = NOW() WHERE id_document = '97618' 07/07/2025 11:45:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97618' 07/07/2025 11:45:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97618' 07/07/2025 11:45:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97618' , '21899' , 'SACRA BIBBIA cei/uelci ' , '90' , '-90' , '4' , '18.5000' , '18.5' , '0' , '47' , '882.45' ) 07/07/2025 04:40:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2378' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 04:40:58 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' , '2378' , '2025-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 07/07/2025 04:40:58 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 = '98009' 07/07/2025 04:40:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '98009' 07/07/2025 04:40:58 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 ( '98009' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 07/07/2025 04:43:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2215' AND id_document != '97808' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 07/07/2025 04:43:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2215', document_date = '2025-06-23', 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 = '54.00', price_tax_excluded = '44.26', date_upd = NOW() WHERE id_document = '97808' 07/07/2025 04:43:06 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 = '97808' 07/07/2025 04:43:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '97808' 07/07/2025 04:43:06 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 ( '97808' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 07/07/2025 04:43:06 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 ( '97808' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3' , '2.4590163934426' , '22' , '0' , '15.00' ) 07/07/2025 04:53:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2379' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 04:53:33 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' , '2379' , '2025-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 07/07/2025 04:53: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 = '98010' 07/07/2025 04:53:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '98010' 07/07/2025 04:53: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 ( '98010' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 07/07/2025 04:53: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 ( '98010' , '20026' , 'CANDELA VOTIVA 20X40' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 07/07/2025 05:03:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2380' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 05:03:17 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' , '2380' , '2025-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.28' , '4.28' , NOW() , NOW() ) 07/07/2025 05:03:17 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 = '98011' 07/07/2025 05:03:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '98011' 07/07/2025 05:03:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98011' , '7442' , 'PANE QUOTIDIANO' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 07/07/2025 05:48:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2381' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 05:48: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' , '2381' , '2025-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.90' , '25.60' , NOW() , NOW() ) 07/07/2025 05:48: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 = '98012' 07/07/2025 05:48:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '98012' 07/07/2025 05:48: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 ( '98012' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 07/07/2025 05:48: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 ( '98012' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '4' , '-4' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '4.40' ) 07/07/2025 05:48: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 ( '98012' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 07/07/2025 05:48: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 ( '98012' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 07/07/2025 05:48: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 ( '98012' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 07/07/2025 06:01:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '19' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 06:01:34 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' , '19' , '2025-07-07' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '880.00' , '880.00' , NOW() , NOW() ) 07/07/2025 06:01: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 = '98013' 07/07/2025 06:01:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '98013' 07/07/2025 06:01: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 ( '98013' , '15019' , 'PREGHIAMO CON MARIA' , '500' , '-500' , '4' , '0.80' , '0.8' , '0' , '0' , '400.00' ) 07/07/2025 06:01: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 ( '98013' , '17034' , 'SACRAMENTO DEL PERDONO' , '240' , '-240' , '4' , '2.00' , '2' , '0' , '0' , '480.00' ) 07/07/2025 06:16:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2382' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 06:16:22 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' , '2382' , '2025-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.10' , '36.10' , NOW() , NOW() ) 07/07/2025 06:16:22 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 = '98014' 07/07/2025 06:16:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '98014' 07/07/2025 06:16:22 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 ( '98014' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 07/07/2025 06:20:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '27/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 06:20:59 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 ( '23' , '27/E' , '2025-07-07' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '864.00' , '708.20' , NOW() , NOW() ) 07/07/2025 06:20:59 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 = '98015' 07/07/2025 06:20:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '98015' 07/07/2025 06:20:59 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 ( '98015' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 07/07/2025 06:20:59 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 ( '98015' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 07/07/2025 06:20:59 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 ( '98015' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 07/07/2025 06:21:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '27/E' AND id_document != '98015' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 06:21:46 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '27/E', document_date = '2025-07-07', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', 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 = '912.00', price_tax_excluded = '747.54', date_upd = NOW() WHERE id_document = '98015' 07/07/2025 06:21: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 = '98015' 07/07/2025 06:21:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '98015' 07/07/2025 06:21: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 ( '98015' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 07/07/2025 06:21: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 ( '98015' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 07/07/2025 06:21: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 ( '98015' , '12817' , 'LIBRO DEI MATRIMONI' , '14' , '-14' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '336.00' ) 07/07/2025 06:29:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '19' AND id_document != '98013' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 06:29:50 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '19', document_date = '2025-07-07', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '880.00', price_tax_excluded = '880.00', date_upd = NOW() WHERE id_document = '98013' 07/07/2025 06:29:50 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 = '98013' 07/07/2025 06:29:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '98013' 07/07/2025 06:29:50 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 ( '98013' , '15019' , 'PREGHIAMO CON MARIA' , '500' , '-500' , '4' , '0.8000' , '0.8' , '0' , '0' , '400.00' ) 07/07/2025 06:29:50 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 ( '98013' , '17034' , 'SACRAMENTO DEL PERDONO' , '240' , '-240' , '4' , '2.0000' , '2' , '0' , '0' , '480.00' ) 07/07/2025 06:32:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2383' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 06:32:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2383' , '2025-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '34.43' , NOW() , NOW() ) 07/07/2025 06:32:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98016' 07/07/2025 06:32:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '98016' 07/07/2025 06:32:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98016' , '22257' , 'QUADRO DECORATO 36X22' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 07/07/2025 06:36:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '90' AND id_document != '95216' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-09') 07/07/2025 06:36:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '90', document_date = '2025-01-09', 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 = '59.50', price_tax_excluded = '57.34', date_upd = NOW() WHERE id_document = '95216' 07/07/2025 06:36:09 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 = '95216' 07/07/2025 06:36:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '95216' 07/07/2025 06:36:09 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 ( '95216' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1' , '1' , '0' , '0' , '2.00' ) 07/07/2025 06:36:09 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 ( '95216' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '5' , '-5' , '4' , '2.7000' , '2.7' , '0' , '0' , '13.50' ) 07/07/2025 06:36:09 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 ( '95216' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 07/07/2025 06:36:09 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 ( '95216' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 07/07/2025 06:36:09 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 ( '95216' , '15019' , 'PREGHIAMO CON MARIA' , '40' , '-40' , '4' , '0.80' , '0.8' , '0' , '0' , '32.00' ) 07/07/2025 07:36:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2384' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-07') 07/07/2025 07:36:26 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' , '2384' , '2025-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 07/07/2025 07:36:26 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 = '98017' 07/07/2025 07:36:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '98017' 07/07/2025 07:36:26 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 ( '98017' , '23573' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT/25' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' )