26/06/2023 09:02:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2196' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 09:02:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2196' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.40' , '21.40' , NOW() , NOW() ) 26/06/2023 09:02: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 = '86508' 26/06/2023 09:02:37 am >> DELETE FROM ps_document_detail WHERE id_document = '86508' 26/06/2023 09:02:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86508' , '21143' , 'AGGIUNTA CANTI 2023' , '5' , '-5' , '4' , '4.50' , '4.5' , '0' , '5' , '21.40' ) 26/06/2023 09:48:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2197' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 09:48:49 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' , '2197' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.65' , '16.81' , NOW() , NOW() ) 26/06/2023 09:48:49 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 = '86509' 26/06/2023 09:48:49 am >> DELETE FROM ps_document_detail WHERE id_document = '86509' 26/06/2023 09:48:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86509' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/06/2023 09:48:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86509' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 26/06/2023 09:48:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86509' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 26/06/2023 10:09:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1323' AND id_document != '82904' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 26/06/2023 10:09:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1323', document_date = '2023-04-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.00', price_tax_excluded = '6.00', date_upd = NOW() WHERE id_document = '82904' 26/06/2023 10:09: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 = '82904' 26/06/2023 10:09:04 am >> DELETE FROM ps_document_detail WHERE id_document = '82904' 26/06/2023 10:09: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 ( '82904' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 26/06/2023 10:09: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 ( '82904' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '1.5' , '1.5' , '0' , '0' , '3.00' ) 26/06/2023 10:09:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1374' AND id_document != '82969' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 26/06/2023 10:09:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1374', document_date = '2023-04-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '35.65', price_tax_excluded = '34.85', date_upd = NOW() WHERE id_document = '82969' 26/06/2023 10:09:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82969' 26/06/2023 10:09:25 am >> DELETE FROM ps_document_detail WHERE id_document = '82969' 26/06/2023 10:09:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82969' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.45' , '3.45' , '0' , '0' , '3.45' ) 26/06/2023 10:09:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82969' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '4' , '-4' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '16.00' ) 26/06/2023 10:09:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82969' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 26/06/2023 10:09:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82969' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 26/06/2023 10:09:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82969' , '6417' , 'MESE DI MAGGIO CON LE GLORIE DI MARIA - 8463' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 26/06/2023 10:12:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1401' AND id_document != '82998' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 26/06/2023 10:12:15 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1401', document_date = '2023-04-28', 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 = '250.00', price_tax_excluded = '211.84', date_upd = NOW() WHERE id_document = '82998' 26/06/2023 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 = '82998' 26/06/2023 10:12:15 am >> DELETE FROM ps_document_detail WHERE id_document = '82998' 26/06/2023 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 ( '82998' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 26/06/2023 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 ( '82998' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 26/06/2023 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 ( '82998' , '8243' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.62' , '0.62' , '0' , '0' , '0.62' ) 26/06/2023 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 ( '82998' , '15784' , 'COPRILEGGIO MARIANO - PCP004B05' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 26/06/2023 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 ( '82998' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '133.0000' , '109.01639344262' , '22' , '0' , '133.00' ) 26/06/2023 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 ( '82998' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '5' , '-5' , '4' , '5.0000' , '5' , '0' , '5' , '23.75' ) 26/06/2023 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 ( '82998' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.625' , '0.625' , '0' , '0' , '0.63' ) 26/06/2023 10:13:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1397' AND id_document != '82993' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 26/06/2023 10:13:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1397', document_date = '2023-04-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '82993' 26/06/2023 10:13:45 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 = '82993' 26/06/2023 10:13:45 am >> DELETE FROM ps_document_detail WHERE id_document = '82993' 26/06/2023 10:13:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82993' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 26/06/2023 10:13:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82993' , '20979' , 'BIBBIA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '5' , '36.10' ) 26/06/2023 10:13:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82993' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.9' , '0.9' , '0' , '0' , '0.90' ) 26/06/2023 10:14:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2198' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 10:14:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2198' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 26/06/2023 10:14: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 = '86510' 26/06/2023 10:14:12 am >> DELETE FROM ps_document_detail WHERE id_document = '86510' 26/06/2023 10:14: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 ( '86510' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/06/2023 10:17:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2199' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 10:17:58 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' , '2199' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '17.00' , NOW() , NOW() ) 26/06/2023 10:17:58 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 = '86511' 26/06/2023 10:17:58 am >> DELETE FROM ps_document_detail WHERE id_document = '86511' 26/06/2023 10:17:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86511' , '20886' , 'VIAGGIO NEL CIELO DELLANIMA CON TERESA DAVILA - R. TAVELLI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 26/06/2023 10:18:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2200' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 10:18:59 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' , '2200' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 26/06/2023 10:18:59 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 = '86512' 26/06/2023 10:18:59 am >> DELETE FROM ps_document_detail WHERE id_document = '86512' 26/06/2023 10:18:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86512' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 26/06/2023 10:21:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 10:21: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' , '2201' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '33.00' , NOW() , NOW() ) 26/06/2023 10:21: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 = '86513' 26/06/2023 10:21:48 am >> DELETE FROM ps_document_detail WHERE id_document = '86513' 26/06/2023 10:21: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 ( '86513' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '0' , '25.00' ) 26/06/2023 10:21: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 ( '86513' , '21048' , 'MESSA MEDITAZIONE - LUG/AGO 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 26/06/2023 10:22:01 am >> DELETE FROM ps_document WHERE id_document = '86513' 26/06/2023 10:22:01 am >> DELETE FROM ps_document_detail WHERE id_document = '86513' 26/06/2023 10:22:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 10:22:19 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' , '2201' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '90.00' , NOW() , NOW() ) 26/06/2023 10:22:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86514' 26/06/2023 10:22:19 am >> DELETE FROM ps_document_detail WHERE id_document = '86514' 26/06/2023 10:22:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86514' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '18' , '-18' , '4' , '5.00' , '5' , '0' , '0' , '90.00' ) 26/06/2023 10:22:30 am >> DELETE FROM ps_document WHERE id_document = '86514' 26/06/2023 10:22:30 am >> DELETE FROM ps_document_detail WHERE id_document = '86514' 26/06/2023 10:26:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2073' AND id_document != '86376' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-15') 26/06/2023 10:26:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2073', document_date = '2023-06-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '47.79', date_upd = NOW() WHERE id_document = '86376' 26/06/2023 10:26: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 = '86376' 26/06/2023 10:26:12 am >> DELETE FROM ps_document_detail WHERE id_document = '86376' 26/06/2023 10:26: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 ( '86376' , '21152' , 'BRACCIALE ARG. - 123/124' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 26/06/2023 10:26: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 ( '86376' , '21048' , 'MESSA MEDITAZIONE - LUG/AGO 2023' , '2' , '-2' , '4' , '7.5' , '7.5' , '0' , '' , '15.00' ) 26/06/2023 10:27:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2017' AND id_document != '85789' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-09') 26/06/2023 10:27:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2017', document_date = '2023-06-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 = '145.00', price_tax_excluded = '126.97', date_upd = NOW() WHERE id_document = '85789' 26/06/2023 10:27:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85789' 26/06/2023 10:27:07 am >> DELETE FROM ps_document_detail WHERE id_document = '85789' 26/06/2023 10:27:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85789' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '100.00' ) 26/06/2023 10:27:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85789' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.25' , '2.25' , '0' , '0' , '2.25' ) 26/06/2023 10:27:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85789' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '9' , '-9' , '4' , '5.00' , '5' , '0' , '5' , '42.75' ) 26/06/2023 11:31:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 11:31: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' , '2201' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 26/06/2023 11:31: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 = '86515' 26/06/2023 11:31:50 am >> DELETE FROM ps_document_detail WHERE id_document = '86515' 26/06/2023 11:31: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 ( '86515' , '11756' , 'VINO BIANCO SECCO - 14%' , '24' , '-24' , '1' , '6.25' , '5.1229508196721' , '22' , '0' , '150.00' ) 26/06/2023 11:32:04 am >> DELETE FROM ps_document WHERE id_document = '86515' 26/06/2023 11:32:04 am >> DELETE FROM ps_document_detail WHERE id_document = '86515' 26/06/2023 11:33:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 11:33:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2201' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 26/06/2023 11:33:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86516' 26/06/2023 11:33:35 am >> DELETE FROM ps_document_detail WHERE id_document = '86516' 26/06/2023 11:33:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86516' , '20758' , 'SEGNALIBRO 5X15 - 300 pezzi' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 26/06/2023 11:34:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2201' AND id_document != '86516' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 11:34:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2201', document_date = '2023-06-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '70.00', date_upd = NOW() WHERE id_document = '86516' 26/06/2023 11:34: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 = '86516' 26/06/2023 11:34:04 am >> DELETE FROM ps_document_detail WHERE id_document = '86516' 26/06/2023 11:34: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 ( '86516' , '20758' , 'SEGNALIBRO 5X15 - 300 pezzi' , '1' , '-1' , '0' , '70.0000' , '70' , '' , '0' , '70.00' ) 26/06/2023 11:34:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 11:34:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2202' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '150.00' , NOW() , NOW() ) 26/06/2023 11:34:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86517' 26/06/2023 11:34:35 am >> DELETE FROM ps_document_detail WHERE id_document = '86517' 26/06/2023 11:34:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86517' , '11756' , 'VINO BIANCO SECCO - 14%' , '24' , '-24' , '0' , '6.25' , '6.25' , '' , '0' , '150.00' ) 26/06/2023 11:34:43 am >> DELETE FROM ps_document WHERE id_document = '86516' 26/06/2023 11:34:43 am >> DELETE FROM ps_document_detail WHERE id_document = '86516' 26/06/2023 11:34:48 am >> DELETE FROM ps_document WHERE id_document = '86517' 26/06/2023 11:34:48 am >> DELETE FROM ps_document_detail WHERE id_document = '86517' 26/06/2023 11:35:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2079' AND id_document != '86382' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-16') 26/06/2023 11:35:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2079', document_date = '2023-06-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '187.00', price_tax_excluded = '160.51', date_upd = NOW() WHERE id_document = '86382' 26/06/2023 11:35: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 = '86382' 26/06/2023 11:35:37 am >> DELETE FROM ps_document_detail WHERE id_document = '86382' 26/06/2023 11:35:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86382' , '11756' , 'VINO BIANCO SECCO - 14%' , '10' , '-10' , '1' , '6' , '4.9180327868852' , '22' , '0' , '60.00' ) 26/06/2023 11:35:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86382' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 26/06/2023 11:35:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86382' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 26/06/2023 11:35:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86382' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '6' , '-6' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '8.40' ) 26/06/2023 11:35:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86382' , '15387' , 'VESTINA BATTESIMALE ' , '6' , '-6' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '18.00' ) 26/06/2023 11:35:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86382' , '16689' , 'OSTIA PAN DI CENA mm80' , '15' , '-15' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '30.00' ) 26/06/2023 11:35:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86382' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 26/06/2023 11:35:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86382' , '12685' , 'SACRO CUORE - 209' , '2' , '-2' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '7.60' ) 26/06/2023 11:36:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1756' AND id_document != '84443' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-20') 26/06/2023 11:36:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1756', document_date = '2023-05-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '84443' 26/06/2023 11:36:01 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 = '84443' 26/06/2023 11:36:01 am >> DELETE FROM ps_document_detail WHERE id_document = '84443' 26/06/2023 11:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84443' , '11756' , 'VINO BIANCO SECCO - 14%' , '10' , '-10' , '1' , '6' , '4.9180327868852' , '22' , '0' , '60.00' ) 26/06/2023 11:36:49 am >> SELECT document_num FROM ps_document WHERE document_num = '987' AND id_document != '82485' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 26/06/2023 11:36:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '987', document_date = '2023-03-27', 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 = '47.00', price_tax_excluded = '38.52', date_upd = NOW() WHERE id_document = '82485' 26/06/2023 11:36:49 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 = '82485' 26/06/2023 11:36:50 am >> DELETE FROM ps_document_detail WHERE id_document = '82485' 26/06/2023 11:36: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 ( '82485' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '21' , '17.213114754098' , '22' , '0' , '21.00' ) 26/06/2023 11:36: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 ( '82485' , '11756' , 'VINO BIANCO SECCO - 14%' , '4' , '-4' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '26.00' ) 26/06/2023 11:50:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 11:50:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2201' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 26/06/2023 11:50:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86518' 26/06/2023 11:50:39 am >> DELETE FROM ps_document_detail WHERE id_document = '86518' 26/06/2023 11:50:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86518' , '20026' , 'CANDELA VOTIVA 20X30' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 26/06/2023 11:53:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1934' AND id_document != '85684' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-05') 26/06/2023 11:53:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1934', document_date = '2023-06-05', 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 = '13.30', price_tax_excluded = '13.03', date_upd = NOW() WHERE id_document = '85684' 26/06/2023 11:53:01 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 = '85684' 26/06/2023 11:53:01 am >> DELETE FROM ps_document_detail WHERE id_document = '85684' 26/06/2023 11:53:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85684' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 26/06/2023 11:53:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85684' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.8' , '0.8' , '0' , '0' , '0.80' ) 26/06/2023 11:53:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85684' , '21022' , 'SE NON LO CERCHI LO TROVI - P. SQUIZZATO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 26/06/2023 12:17:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 12:17:51 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' , '2202' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.32' , '11.32' , NOW() , NOW() ) 26/06/2023 12:17:51 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 = '86519' 26/06/2023 12:17:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '86519' 26/06/2023 12:17:51 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 ( '86519' , '20304' , 'FAMIGLIA RACCONTATA AI BAMBINI - FERRERO/PAIRETTO' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 26/06/2023 12:17:51 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 ( '86519' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 26/06/2023 12:17:51 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 ( '86519' , '1839' , 'CATEQUIZ 11 DOMANDE E RISPOSTE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 26/06/2023 12:26:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 12:26:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2203' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.10' , '36.10' , NOW() , NOW() ) 26/06/2023 12:26:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86520' 26/06/2023 12:26:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '86520' 26/06/2023 12:26:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86520' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 26/06/2023 12:26:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2204' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 12:27:00 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' , '2204' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 26/06/2023 12:27:00 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 = '86521' 26/06/2023 12:27:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '86521' 26/06/2023 12:27:00 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 ( '86521' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 26/06/2023 12:28:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1687' AND id_document != '84363' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 26/06/2023 12:28:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1687', document_date = '2023-05-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '105.00', price_tax_excluded = '91.75', date_upd = NOW() WHERE id_document = '84363' 26/06/2023 12:28: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 = '84363' 26/06/2023 12:28:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '84363' 26/06/2023 12:28: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 ( '84363' , '11265' , 'COPRILEGGIO - 881' , '1' , '-1' , '1' , '73.5000' , '60.245901639344' , '22' , '0' , '73.50' ) 26/06/2023 12:28: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 ( '84363' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 26/06/2023 12:28: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 ( '84363' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 26/06/2023 12:29:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1790' AND id_document != '84486' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 26/06/2023 12:29:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1790', document_date = '2023-05-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 = '16.00', price_tax_excluded = '16.00', date_upd = NOW() WHERE id_document = '84486' 26/06/2023 12:29: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 = '84486' 26/06/2023 12:29:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '84486' 26/06/2023 12:29: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 ( '84486' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '1.75' , '1.75' , '0' , '0' , '1.75' ) 26/06/2023 12:29: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 ( '84486' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 26/06/2023 12:59:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2205' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 12:59:48 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' , '2205' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.00' , '141.63' , NOW() , NOW() ) 26/06/2023 12:59:48 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 = '86522' 26/06/2023 12:59:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '86522' 26/06/2023 12:59:48 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 ( '86522' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 26/06/2023 12:59:48 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 ( '86522' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 26/06/2023 12:59:48 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 ( '86522' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 26/06/2023 12:59:48 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 ( '86522' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 26/06/2023 12:59:48 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 ( '86522' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 26/06/2023 12:59:48 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 ( '86522' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '10' , '-10' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '14.00' ) 26/06/2023 01:02:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 01:02:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '68/A' , '2023-06-26' , 'A' , '177' , '0' , '4670959' , 'VIA S. FELICE IN FELLINE 84133 SALERNO' , '' , 'acconto € 150,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '550.00' , '450.82' , NOW() , NOW() ) 26/06/2023 01:02:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86523' 26/06/2023 01:02:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '86523' 26/06/2023 01:02:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86523' , '19447' , 'CASULA L/S MOIRE\' - RICAMO DIRETTO - 7976LS' , '1' , '-1' , '1' , '550' , '450.81967213115' , '22' , '0' , '550.00' ) 26/06/2023 01:08:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2206' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 01:08: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' , '2206' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 26/06/2023 01:08: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 = '86524' 26/06/2023 01:08:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '86524' 26/06/2023 01:08: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 ( '86524' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 26/06/2023 01:12:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2207' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 01:12: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' , '2207' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 26/06/2023 01:12: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 = '86525' 26/06/2023 01:12:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '86525' 26/06/2023 01:12: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 ( '86525' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/06/2023 01:12: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 ( '86525' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/06/2023 02:20:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2117' AND id_document != '86425' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 26/06/2023 02:20:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2117', document_date = '2023-06-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '165.40', price_tax_excluded = '136.84', date_upd = NOW() WHERE id_document = '86425' 26/06/2023 02:20:08 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 = '86425' 26/06/2023 02:20:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '86425' 26/06/2023 02:20:08 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 ( '86425' , '11384' , 'VINO BIANCO DOLCE - 102' , '5' , '-5' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '42.50' ) 26/06/2023 02:20:08 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 ( '86425' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.7000' , '0.7' , '0' , '0' , '4.20' ) 26/06/2023 02:20:08 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 ( '86425' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/06/2023 02:20:08 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 ( '86425' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 26/06/2023 02:20:08 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 ( '86425' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 26/06/2023 02:20:08 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 ( '86425' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '39.50' ) 26/06/2023 02:20:08 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 ( '86425' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '0.7' , '0.7' , '0' , '0' , '2.80' ) 26/06/2023 06:26:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2208' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 06:26:13 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' , '2208' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '117.00' , '95.90' , NOW() , NOW() ) 26/06/2023 06:26:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86526' 26/06/2023 06:26:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '86526' 26/06/2023 06:26:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86526' , '20704' , 'QUADRO 63X35' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 26/06/2023 06:26:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86526' , '20705' , 'CANDELA CUBO' , '2' , '-2' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '27.00' ) 26/06/2023 07:09:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2209' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-26') 26/06/2023 07:09:36 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' , '2209' , '2023-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.25' , '52.25' , NOW() , NOW() ) 26/06/2023 07:09:36 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 = '86527' 26/06/2023 07:09:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '86527' 26/06/2023 07:09:36 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 ( '86527' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '11' , '-11' , '4' , '5.00' , '5' , '0' , '5' , '52.25' )