18/04/2025 09:01:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1303' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 09:01:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1303' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.24' , '91.19' , NOW() , NOW() ) 18/04/2025 09:01:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96754' 18/04/2025 09:01:20 am >> DELETE FROM ps_document_detail WHERE id_document = '96754' 18/04/2025 09:01:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96754' , '2955' , 'CROCE COLOMBA DI PACE' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 18/04/2025 09:01:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96754' , '7290' , 'SCATOLA CONFETTI CON CALAMITA' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 18/04/2025 09:01:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96754' , '23553' , ' CONFEZIONE LIBRO + CORONCINA ACUTIS - 10941' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '5' , '8.55' ) 18/04/2025 09:01:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96754' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 18/04/2025 09:01:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96754' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '30' , '-30' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '45.00' ) 18/04/2025 09:01:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96754' , '23450' , 'GIOCHIAMO CON LA PASQUA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 18/04/2025 09:01:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96754' , '21596' , 'CARTOLINE PREGHIERE' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 18/04/2025 09:37:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1304' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 09:37:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1304' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.90' , '131.21' , NOW() , NOW() ) 18/04/2025 09:37:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96755' 18/04/2025 09:37:26 am >> DELETE FROM ps_document_detail WHERE id_document = '96755' 18/04/2025 09:37:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23279' , 'AMEN - APR 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 18/04/2025 09:37:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23278' , 'AMEN - MAR 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 18/04/2025 09:37:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '25.0000' , '20.4918' , '22' , '0' , '25.00' ) 18/04/2025 09:37:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2500' , '0.2049' , '22' , '0' , '25.00' ) 18/04/2025 09:37:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '1' , '-1' , '1' , '11.5000' , '9.4262' , '22' , '0' , '11.50' ) 18/04/2025 09:37:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23492' , 'AMEN - GIU 25' , '3' , '-3' , '4' , '3.90' , '3.9' , '0' , '5' , '11.13' ) 18/04/2025 09:37:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23491' , 'AMEN - MAG 25' , '3' , '-3' , '4' , '3.90' , '3.9' , '0' , '5' , '11.13' ) 18/04/2025 09:37:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '12' , '-12' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '14.40' ) 18/04/2025 09:37:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 18/04/2025 09:37:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1304' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 09:37:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1305' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 09:37:56 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' , '1305' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.90' , '131.21' , NOW() , NOW() ) 18/04/2025 09:37:56 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 = '96756' 18/04/2025 09:37:56 am >> DELETE FROM ps_document_detail WHERE id_document = '96756' 18/04/2025 09:39:10 am >> DELETE FROM ps_document WHERE id_document = '96756' 18/04/2025 09:39:10 am >> DELETE FROM ps_document_detail WHERE id_document = '96756' 18/04/2025 09:39:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1304' AND id_document != '96755' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 09:39:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1304', document_date = '2025-04-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '144.90', price_tax_excluded = '131.21', date_upd = NOW() WHERE id_document = '96755' 18/04/2025 09:39:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96755' 18/04/2025 09:39:18 am >> DELETE FROM ps_document_detail WHERE id_document = '96755' 18/04/2025 09:39:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23279' , 'AMEN - APR 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 18/04/2025 09:39:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23278' , 'AMEN - MAR 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 18/04/2025 09:39:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 18/04/2025 09:39:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '25.00' ) 18/04/2025 09:39:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '1' , '-1' , '1' , '11.5000' , '9.4262295081967' , '22' , '0' , '11.50' ) 18/04/2025 09:39:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23492' , 'AMEN - GIU 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.13' ) 18/04/2025 09:39:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23491' , 'AMEN - MAG 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.13' ) 18/04/2025 09:39:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 18/04/2025 09:39:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 18/04/2025 09:46:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1254' AND id_document != '96698' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 18/04/2025 09:46:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1254', document_date = '2025-04-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 = '80.00', price_tax_excluded = '65.84', date_upd = NOW() WHERE id_document = '96698' 18/04/2025 09:46: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 = '96698' 18/04/2025 09:46:59 am >> DELETE FROM ps_document_detail WHERE id_document = '96698' 18/04/2025 09:46: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 ( '96698' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '49.6000' , '40.655737704918' , '22' , '0' , '49.60' ) 18/04/2025 09:46: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 ( '96698' , '17628' , 'PREGHIERE A SAN CHARBEL - 8946' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 18/04/2025 09:46: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 ( '96698' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15.9000' , '13.032786885246' , '22' , '0' , '15.90' ) 18/04/2025 09:46: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 ( '96698' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/04/2025 09:46: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 ( '96698' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 18/04/2025 09:47:13 am >> DELETE FROM ps_document WHERE id_document = '96103' 18/04/2025 09:47:13 am >> DELETE FROM ps_document_detail WHERE id_document = '96103' 18/04/2025 09:49:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1304' AND id_document != '96755' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 09:49:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1304', document_date = '2025-04-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '144.90', price_tax_excluded = '131.21', date_upd = NOW() WHERE id_document = '96755' 18/04/2025 09:49:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96755' 18/04/2025 09:49:26 am >> DELETE FROM ps_document_detail WHERE id_document = '96755' 18/04/2025 09:49:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23279' , 'AMEN - APR 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 18/04/2025 09:49:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23278' , 'AMEN - MAR 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 18/04/2025 09:49:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 18/04/2025 09:49:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '25.00' ) 18/04/2025 09:49:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11.5' , '9.4262295081967' , '22' , '0' , '11.50' ) 18/04/2025 09:49:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23492' , 'AMEN - GIU 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.13' ) 18/04/2025 09:49:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '23491' , 'AMEN - MAG 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.13' ) 18/04/2025 09:49:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 18/04/2025 09:49:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96755' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 18/04/2025 10:13:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1305' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 10:13:55 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' , '1305' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 18/04/2025 10:13:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96757' 18/04/2025 10:13:55 am >> DELETE FROM ps_document_detail WHERE id_document = '96757' 18/04/2025 10:13:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96757' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '2' , '-2' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '23.00' ) 18/04/2025 11:13:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1306' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 11:13:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1306' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '50.65' , NOW() , NOW() ) 18/04/2025 11:13:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96758' 18/04/2025 11:13:18 am >> DELETE FROM ps_document_detail WHERE id_document = '96758' 18/04/2025 11:13:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96758' , '11151' , 'LIBRI' , '14' , '-14' , '4' , '3' , '3' , '0' , '0' , '42.00' ) 18/04/2025 11:13:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96758' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 18/04/2025 11:13:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96758' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 18/04/2025 11:17:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1307' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 11:17: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' , '1307' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 18/04/2025 11:17: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 = '96759' 18/04/2025 11:17:50 am >> DELETE FROM ps_document_detail WHERE id_document = '96759' 18/04/2025 11:17: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 ( '96759' , '22360' , 'CROCE CROMATA CM 27 - 37/1' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 18/04/2025 11:29:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1308' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 11:29:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1308' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 18/04/2025 11:29:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96760' 18/04/2025 11:29:22 am >> DELETE FROM ps_document_detail WHERE id_document = '96760' 18/04/2025 11:29:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96760' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 18/04/2025 11:50:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1309' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 11:50:08 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' , '1309' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 18/04/2025 11:50:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96761' 18/04/2025 11:50:08 am >> DELETE FROM ps_document_detail WHERE id_document = '96761' 18/04/2025 11:50:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96761' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '35' , '35' , '0' , '0' , '35.00' ) 18/04/2025 12:03:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1310' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 12:03:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1310' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.90' , '43.36' , NOW() , NOW() ) 18/04/2025 12:03:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96762' 18/04/2025 12:03:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '96762' 18/04/2025 12:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96762' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 18/04/2025 12:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96762' , '20758' , 'SEGNALIBRO 5X15' , '15' , '-15' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '3.00' ) 18/04/2025 12:13:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1311' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 12:13:19 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' , '1311' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.90' , '66.31' , NOW() , NOW() ) 18/04/2025 12:13:19 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 = '96763' 18/04/2025 12:13:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '96763' 18/04/2025 12:13:19 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 ( '96763' , '10122' , 'SPEGNICANDELA CON MANICO CM 50 - 609/50' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 18/04/2025 12:13:19 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 ( '96763' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/04/2025 12:13:19 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 ( '96763' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 18/04/2025 12:13:19 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 ( '96763' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 18/04/2025 12:13:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1312' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 12:13: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 ( '11' , '1312' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.37' , '27.37' , NOW() , NOW() ) 18/04/2025 12:13: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 = '96764' 18/04/2025 12:13:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '96764' 18/04/2025 12:13: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 ( '96764' , '1095' , 'BIBBIA - ED. RIL.' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 18/04/2025 12:13: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 ( '96764' , '23642' , 'LUCE SUL MIO CAMMINO - F. CRISTOFARO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 18/04/2025 12:13: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 ( '96764' , '23374' , 'VEDERE LA BELLA NOTIZIA - J. HERNANDEZ' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 18/04/2025 12:16:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1313' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 12:16: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' , '1313' , '2025-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.60' , '7.05' , NOW() , NOW() ) 18/04/2025 12:16: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 = '96765' 18/04/2025 12:16:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '96765' 18/04/2025 12:16: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 ( '96765' , '10687' , 'TORCIA A VENTO ' , '2' , '-2' , '1' , '4.30' , '3.5245901639344' , '22' , '0' , '8.60' ) 18/04/2025 12:21:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '64/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-18') 18/04/2025 12:21:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '64/A' , '2025-04-18' , 'A' , '1083' , '0' , '4674059' , 'VIA CREMONA, 1 83020 S. MICHELE DI SERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '634.50' , '634.50' , NOW() , NOW() ) 18/04/2025 12:21:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96766' 18/04/2025 12:21:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '96766' 18/04/2025 12:21:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96766' , '' , 'TUNICA' , '13' , '-13' , '0' , '45' , '45' , '' , '0' , '585.00' ) 18/04/2025 12:21:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96766' , '' , 'TUNICA' , '1' , '-1' , '0' , '49.5' , '49.5' , '' , '0' , '49.50' )