16/12/2025 08:58:22 am >> SELECT document_num FROM ps_document WHERE document_num = '278' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 08:58: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 ( '21' , '278' , '2025-12-16' , '' , '2755' , '0' , '4679629' , 'VIA APPIA 1425 04026 MINTURNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '46.75' , '45.64' , NOW() , NOW() ) 16/12/2025 08:58: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 = '100497' 16/12/2025 08:58:22 am >> DELETE FROM ps_document_detail WHERE id_document = '100497' 16/12/2025 08:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100497' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 16/12/2025 08:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100497' , '23870' , 'RAGAZZO DEL LENZUOLO - M. VIANI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 16/12/2025 08:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100497' , '24201' , 'PORTA IL DONO' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 16/12/2025 08:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100497' , '24413' , 'SOTTO QUESTO CIELO' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '5' , '6.18' ) 16/12/2025 08:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100497' , '24414' , 'AGENDA DELLA FAMIGLIA 2026' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 16/12/2025 08:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100497' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 16/12/2025 08:59:27 am >> SELECT document_num FROM ps_document WHERE document_num = '271' AND id_document != '100344' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-09') 16/12/2025 08:59:27 am >> UPDATE ps_document SET id_document_type = '21', document_num = '271', document_date = '2025-12-09', document_letter = '', id_customer = '2755', id_supplier = '', id_address = '4679629', address1 = 'VIA APPIA 1425 04026 MINTURNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '92.73', price_tax_excluded = '92.73', date_upd = NOW() WHERE id_document = '100344' 16/12/2025 08:59:27 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 = '100344' 16/12/2025 08:59:27 am >> DELETE FROM ps_document_detail WHERE id_document = '100344' 16/12/2025 08:59: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 ( '100344' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 16/12/2025 08:59: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 ( '100344' , '18357' , 'MIE PREGHIERINE N.E.' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '5' , '2.85' ) 16/12/2025 08:59: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 ( '100344' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.75' ) 16/12/2025 08:59: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 ( '100344' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.75' ) 16/12/2025 08:59: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 ( '100344' , '23347' , 'PREGHIERA DEL ROSARIO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 16/12/2025 08:59: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 ( '100344' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '5' , '1.80' ) 16/12/2025 08:59: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 ( '100344' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 16/12/2025 08:59: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 ( '100344' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 16/12/2025 08:59: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 ( '100344' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 16/12/2025 08:59: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 ( '100344' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 16/12/2025 08:59: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 ( '100344' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 16/12/2025 08:59: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 ( '100344' , '24097' , 'AVVENTO E NATALE 2025 - BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '24096' , 'AVVENTO E NATALE 2025/26' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.75' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 16/12/2025 08:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100344' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '50' , '-50' , '0' , '0.4500' , '0.45' , '0' , '0' , '22.50' ) 16/12/2025 09:27:14 am >> SELECT document_num FROM ps_document WHERE document_num = '4244' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 09:27:15 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' , '4244' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 16/12/2025 09:27: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 = '100498' 16/12/2025 09:27:15 am >> DELETE FROM ps_document_detail WHERE id_document = '100498' 16/12/2025 09:27: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 ( '100498' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 16/12/2025 09:40:29 am >> SELECT document_num FROM ps_document WHERE document_num = '4245' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 09:40:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4245' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '141.05' , '120.54' , NOW() , NOW() ) 16/12/2025 09:40:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100499' 16/12/2025 09:40:29 am >> DELETE FROM ps_document_detail WHERE id_document = '100499' 16/12/2025 09:40:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100499' , '24425' , 'DIO E LA VERA REALTA - BENEDETTO XVI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 16/12/2025 09:40:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100499' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 16/12/2025 09:40:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100499' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 16/12/2025 09:41:55 am >> SELECT document_num FROM ps_document WHERE document_num = '4246' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 09:41: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' , '4246' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.89' , '62.20' , NOW() , NOW() ) 16/12/2025 09:41: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 = '100500' 16/12/2025 09:41:55 am >> DELETE FROM ps_document_detail WHERE id_document = '100500' 16/12/2025 09:41: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 ( '100500' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '9.99' ) 16/12/2025 09:41: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 ( '100500' , '16588' , 'CLERGY DIAGONALE ML - C06' , '1' , '-1' , '1' , '46.90' , '38.44262295082' , '22' , '0' , '46.90' ) 16/12/2025 09:41:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100500' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '5' , '19.00' ) 16/12/2025 09:51:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4247' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 09:51:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4247' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 16/12/2025 09:51:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100501' 16/12/2025 09:51:13 am >> DELETE FROM ps_document_detail WHERE id_document = '100501' 16/12/2025 09:51:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100501' , '16535' , 'CLERGY MARANGEL ML - C20' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 16/12/2025 09:51:55 am >> SELECT document_num FROM ps_document WHERE document_num = '4248' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 09:51: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' , '4248' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 16/12/2025 09:51: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 = '100502' 16/12/2025 09:51:55 am >> DELETE FROM ps_document_detail WHERE id_document = '100502' 16/12/2025 09:51: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 ( '100502' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/12/2025 10:33:47 am >> SELECT document_num FROM ps_document WHERE document_num = '4249' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 10:33:47 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' , '4249' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 16/12/2025 10:33:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100503' 16/12/2025 10:33:47 am >> DELETE FROM ps_document_detail WHERE id_document = '100503' 16/12/2025 10:33:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100503' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 16/12/2025 10:49:02 am >> SELECT document_num FROM ps_document WHERE document_num = '145/A' AND id_document != '100115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-27') 16/12/2025 10:49:02 am >> UPDATE ps_document SET id_document_type = '24', document_num = '145/A', document_date = '2025-11-27', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4679587', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'LIBRI SCONTI 10/15% --- OGGETTISTICA 15%', 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 = '225.60', price_tax_excluded = '225.60', date_upd = NOW() WHERE id_document = '100115' 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100115' 16/12/2025 10:49:02 am >> DELETE FROM ps_document_detail WHERE id_document = '100115' 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '4' , '34.0000' , '34' , '0' , '0' , '34.00' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '0' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24284' , 'CUORE NATIVITA CM 16 - PB17823' , '1' , '-1' , '0' , '4.5000' , '4.5' , '' , '0' , '4.50' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '3' , '-3' , '4' , '12.9000' , '12.9' , '0' , '0' , '38.70' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '0' , '6.0000' , '6' , '' , '0' , '6.00' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '1' , '-1' , '0' , '17.0000' , '17' , '0' , '0' , '17.00' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '1' , '-1' , '0' , '4.8000' , '4.8' , '0' , '0' , '4.80' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '19602' , 'QUADRETTO EFFETTO PIETRA - 2952 VARI MODELLI' , '1' , '-1' , '0' , '4.0000' , '4' , '' , '0' , '4.00' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24174' , 'CUORE DI MAMMA - CALENDARIO 2026' , '1' , '-1' , '0' , '7.0000' , '7' , '0' , '0' , '7.00' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24069' , 'CINQUE PANI DORZO 2026' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24015' , 'UN ANNO CON GESU' , '1' , '-1' , '0' , '5.0000' , '5' , '0' , '0' , '5.00' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '23998' , 'PENSIERI EUCARISTICI 2026' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '0' , '6.90' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21202' , 'PREGHIAMO CON IL NONNO E LA NONNA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 16/12/2025 10:49:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '13840' , 'NONNI SONO UN TESORO' , '2' , '-2' , '4' , '1.8000' , '1.8' , '0' , '0' , '3.60' ) 16/12/2025 10:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '3' , '-3' , '4' , '3.5000' , '3.5' , '0' , '0' , '10.50' ) 16/12/2025 10:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '16309' , 'BRACCIALE EMATITE SANTI - BC38' , '2' , '-2' , '0' , '2.0000' , '2' , '0' , '0' , '4.00' ) 16/12/2025 10:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '0' , '3.0000' , '3' , '' , '0' , '3.00' ) 16/12/2025 10:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '2' , '-2' , '0' , '1.0000' , '1' , '0' , '0' , '2.00' ) 16/12/2025 10:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '18129' , 'TAU COLORATO - T56' , '1' , '-1' , '0' , '1.2000' , '1.2' , '' , '0' , '1.20' ) 16/12/2025 10:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '16075' , 'SCOPRI E DIPINGI LA BIBBIA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 16/12/2025 10:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 16/12/2025 10:49:52 am >> SELECT document_num FROM ps_document WHERE document_num = '4250' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 10:49:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4250' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 16/12/2025 10:49:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100504' 16/12/2025 10:49:52 am >> DELETE FROM ps_document_detail WHERE id_document = '100504' 16/12/2025 10:49:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100504' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 16/12/2025 11:17:47 am >> SELECT document_num FROM ps_document WHERE document_num = '4251' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 11:17:47 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' , '4251' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 16/12/2025 11:17:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100505' 16/12/2025 11:17:47 am >> DELETE FROM ps_document_detail WHERE id_document = '100505' 16/12/2025 11:17:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100505' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 16/12/2025 11:18:59 am >> SELECT document_num FROM ps_document WHERE document_num = '4252' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 11: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' , '4252' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 16/12/2025 11: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 = '100506' 16/12/2025 11:18:59 am >> DELETE FROM ps_document_detail WHERE id_document = '100506' 16/12/2025 11: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 ( '100506' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/12/2025 11:29:54 am >> SELECT document_num FROM ps_document WHERE document_num = '4253' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 11:29:54 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' , '4253' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '26.23' , NOW() , NOW() ) 16/12/2025 11:29:54 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 = '100507' 16/12/2025 11:29:54 am >> DELETE FROM ps_document_detail WHERE id_document = '100507' 16/12/2025 11:29:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100507' , '12582' , 'VETRO ANTIVENTO PER F. CANDELA DIAM 3,2 - 73/32' , '2' , '-2' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '32.00' ) 16/12/2025 11:40:27 am >> SELECT document_num FROM ps_document WHERE document_num = '4254' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 11:40:27 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' , '4254' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 16/12/2025 11:40:27 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 = '100508' 16/12/2025 11:40:27 am >> DELETE FROM ps_document_detail WHERE id_document = '100508' 16/12/2025 11:40: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 ( '100508' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '6' , '-6' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '21.00' ) 16/12/2025 11:40: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 ( '100508' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 16/12/2025 11:55:06 am >> SELECT document_num FROM ps_document WHERE document_num = '4255' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 11:55:06 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' , '4255' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 16/12/2025 11:55:06 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 = '100509' 16/12/2025 11:55:06 am >> DELETE FROM ps_document_detail WHERE id_document = '100509' 16/12/2025 11:55:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100509' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 16/12/2025 11:55:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100509' , '11681' , 'CROCE TRAFORATA CON LACCIO' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 16/12/2025 11:55:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100509' , '20523' , 'CROCE - 094 ALV' , '2' , '-2' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '8.00' ) 16/12/2025 12:05:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '4256' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 12:05:15 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' , '4256' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '29.92' , NOW() , NOW() ) 16/12/2025 12:05:15 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 = '100510' 16/12/2025 12:05:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '100510' 16/12/2025 12:05:15 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 ( '100510' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '4' , '-4' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '26.00' ) 16/12/2025 12:05:15 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 ( '100510' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 16/12/2025 12:12:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '4257' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 12:12:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4257' , '2025-12-16' , '' , '0' , '0' , '0' , 'VIA SANTA TERESA 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '23.08' , NOW() , NOW() ) 16/12/2025 12:12:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100511' 16/12/2025 12:12:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '100511' 16/12/2025 12:12:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100511' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 16/12/2025 12:12:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100511' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3654' , '4' , '0' , '14.00' ) 16/12/2025 12:12:47 pm >> DELETE FROM ps_document WHERE id_document = '100452' 16/12/2025 12:12:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '100452' 16/12/2025 12:20:25 pm >> DELETE FROM ps_document WHERE id_document = '100115' 16/12/2025 12:20:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '100115' 16/12/2025 12:22:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '38/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 12:22: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 ( '23' , '38/L' , '2025-12-16' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , 'HOSPICE CASA DI LARA' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '74.00' , '62.50' , NOW() , NOW() ) 16/12/2025 12:22: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 = '100512' 16/12/2025 12:22:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '100512' 16/12/2025 12:22: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 ( '100512' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '4' , '-4' , '1' , '7.9000' , '6.4754' , '22' , '0' , '31.60' ) 16/12/2025 12:22: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 ( '100512' , '1914' , 'CERA DELLA LITURGIA' , '6' , '-6' , '1' , '4.9000' , '4.0164' , '22' , '0' , '29.40' ) 16/12/2025 12:22: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 ( '100512' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 16/12/2025 12:22: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 ( '100512' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9231' , '4' , '0' , '6.00' ) 16/12/2025 12:22:55 pm >> DELETE FROM ps_document WHERE id_document = '97674' 16/12/2025 12:22:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97674' 16/12/2025 12:59:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '4258' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 12:59:29 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' , '4258' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.53' , '22.53' , NOW() , NOW() ) 16/12/2025 12:59:29 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 = '100513' 16/12/2025 12:59:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '100513' 16/12/2025 12:59:29 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 ( '100513' , '24069' , 'CINQUE PANI DORZO 2026' , '3' , '-3' , '4' , '7.90' , '7.9' , '0' , '5' , '22.53' ) 16/12/2025 12:59:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '4259' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 12:59:44 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' , '4259' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.02' , '15.02' , NOW() , NOW() ) 16/12/2025 12:59:44 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 = '100514' 16/12/2025 12:59:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '100514' 16/12/2025 12:59:44 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 ( '100514' , '24069' , 'CINQUE PANI D\'ORZO 2026' , '2' , '-2' , '4' , '7.90' , '7.9' , '0' , '5' , '15.02' ) 16/12/2025 02:29:31 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 ( '33' , '719688' , '2025-12-15' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.16' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.72' , '90.72' , NOW() , NOW() ) 16/12/2025 02:29:31 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 = '100515' 16/12/2025 02:29:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '100515' 16/12/2025 02:29:31 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 ( '100515' , '5775' , 'LEZIONARIO PER LE MESSE RITUALI' , '1' , '1' , '4' , '90.00' , '90' , '0' , '15' , '76.5000' ) 16/12/2025 02:29:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5775' AND id_supplier = '7' 16/12/2025 02:29:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5775' , '7' , '1' ) 16/12/2025 02:29:31 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 ( '100515' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 16/12/2025 02:29:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '7' 16/12/2025 02:29:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '7' , '1' ) 16/12/2025 02:30:17 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/12/2025 02:30:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24429' , '1' , '' , 'nuovo-prodotto' ) 16/12/2025 02:30:17 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24429' , '1' , '1' , '2' , NOW() , NOW() ) 16/12/2025 02:30:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24429' , '0' , '1' , '0' , '0' ) 16/12/2025 02:30:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825046335' AND id_product != '24429' AND ean13 != '' 16/12/2025 02:30:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788825046335', date_upd = NOW() WHERE id_product = '24429' 16/12/2025 02:30:56 pm >> UPDATE ps_product_lang SET name = 'ILLUSTRISSIMI ALBINO LUCIANI', description = '' WHERE id_product = '24429' 16/12/2025 02:30:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '24429' 16/12/2025 02:30:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24429' 16/12/2025 02:30:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '24429' 16/12/2025 02:30:56 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24429' 16/12/2025 02:30:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24430' , '1' , '' , 'nuovo-prodotto' ) 16/12/2025 02:30:56 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24430' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24429' 16/12/2025 02:30:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24430' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24429' 16/12/2025 02:31:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831522854' AND id_product != '21835' AND ean13 != '' 16/12/2025 02:31:18 pm >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '9788831522854', date_upd = NOW() WHERE id_product = '21835' 16/12/2025 02:31:18 pm >> UPDATE ps_product_lang SET name = 'DIDACHE\' ', description = '' WHERE id_product = '21835' 16/12/2025 02:31:18 pm >> UPDATE ps_product SET wholesale_price = '5.03', on_sale = '0', price = '8.5' WHERE id_product = '21835' 16/12/2025 02:31:18 pm >> UPDATE ps_product_shop SET wholesale_price = '5.03', price = '8.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21835' 16/12/2025 02:31:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '21835' 16/12/2025 02:31:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '719527' , '2025-12-12' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.4' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.85' , '83.85' , NOW() , NOW() ) 16/12/2025 02:31:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100516' 16/12/2025 02:31:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '100516' 16/12/2025 02:31:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100516' , '24334' , 'EMMANUELE' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 16/12/2025 02:31:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24334' AND id_supplier = '7' 16/12/2025 02:31:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24334' , '7' , '1' ) 16/12/2025 02:31:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100516' , '24429' , 'ILLUSTRISSIMI ALBINO LUCIANI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 16/12/2025 02:31:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24429' AND id_supplier = '7' 16/12/2025 02:31:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24429' , '7' , '1' ) 16/12/2025 02:31:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100516' , '21835' , 'DIDACHE ' , '10' , '10' , '4' , '8.50' , '8.5' , '0' , '33' , '56.9500' ) 16/12/2025 02:31:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21835' AND id_supplier = '7' 16/12/2025 02:31:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21835' , '7' , '1' ) 16/12/2025 02:38:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '4164' AND id_document != '100394' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-11') 16/12/2025 02:38:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4164', document_date = '2025-12-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '67.10', price_tax_excluded = '58.08', date_upd = NOW() WHERE id_document = '100394' 16/12/2025 02:38:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100394' 16/12/2025 02:38:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '100394' 16/12/2025 02:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100394' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 16/12/2025 02:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100394' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 16/12/2025 02:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100394' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '1' , '31' , '25.409836065574' , '22' , '0' , '31.00' ) 16/12/2025 02:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100394' , '24284' , 'CUORE NATIVITA CM 16 - PB17823' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 16/12/2025 02:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100394' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 16/12/2025 02:40:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4036' AND id_document != '100235' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-03') 16/12/2025 02:40:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4036', document_date = '2025-12-03', 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 = '95.00', price_tax_excluded = '81.66', date_upd = NOW() WHERE id_document = '100235' 16/12/2025 02:40:12 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 = '100235' 16/12/2025 02:40:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '100235' 16/12/2025 02:40:12 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 ( '100235' , '18225' , 'SAN LEONARDO ABATE' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 16/12/2025 02:40:12 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 ( '100235' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 16/12/2025 02:40:12 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 ( '100235' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '3' , '-3' , '1' , '12' , '9.8360655737705' , '22' , '0' , '36.00' ) 16/12/2025 02:40:12 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 ( '100235' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '1' , '19' , '15.573770491803' , '22' , '0' , '19.00' ) 16/12/2025 02:40:12 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 ( '100235' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 16/12/2025 02:40:12 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 ( '100235' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 16/12/2025 02:41:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4144' AND id_document != '100370' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-10') 16/12/2025 02:41:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4144', document_date = '2025-12-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '203.50', price_tax_excluded = '166.80', date_upd = NOW() WHERE id_document = '100370' 16/12/2025 02:41:12 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 = '100370' 16/12/2025 02:41:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '100370' 16/12/2025 02:41:12 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 ( '100370' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 - AVRSTEL' , '25' , '-25' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '20.00' ) 16/12/2025 02:41:12 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 ( '100370' , '21858' , 'ANELLO S. LUCIA' , '300' , '-300' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '180.00' ) 16/12/2025 02:41:12 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 ( '100370' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 16/12/2025 02:42:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3848' AND id_document != '99983' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 16/12/2025 02:42:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3848', document_date = '2025-11-19', 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 = '46.50', price_tax_excluded = '43.43', date_upd = NOW() WHERE id_document = '99983' 16/12/2025 02:42: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 = '99983' 16/12/2025 02:42:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '99983' 16/12/2025 02:42: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 ( '99983' , '16309' , 'BRACCIALE EMATITE SANTI - BC38' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 16/12/2025 02:42: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 ( '99983' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 16/12/2025 02:42: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 ( '99983' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 16/12/2025 02:42: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 ( '99983' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 16/12/2025 02:42: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 ( '99983' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 16/12/2025 02:42: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 ( '99983' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 16/12/2025 02:43:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '4012' AND id_document != '100202' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-02') 16/12/2025 02:43:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4012', document_date = '2025-12-02', 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 = '10.90', price_tax_excluded = '8.93', date_upd = NOW() WHERE id_document = '100202' 16/12/2025 02:43: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 = '100202' 16/12/2025 02:43:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '100202' 16/12/2025 02:43: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 ( '100202' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.7' , '2.2131147540984' , '22' , '0' , '2.70' ) 16/12/2025 02:43: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 ( '100202' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 16/12/2025 02:43: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 ( '100202' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 16/12/2025 02:43: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 ( '100202' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 16/12/2025 02:43: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 ( '100202' , '18129' , 'TAU COLORATO - T56' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 16/12/2025 02:44:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3483' AND id_document != '99432' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 16/12/2025 02:44:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3483', document_date = '2025-10-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 = '97.21', price_tax_excluded = '89.86', date_upd = NOW() WHERE id_document = '99432' 16/12/2025 02:44:30 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 = '99432' 16/12/2025 02:44:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '99432' 16/12/2025 02:44:30 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 ( '99432' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 16/12/2025 02:44:30 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 ( '99432' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/12/2025 02:44:30 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 ( '99432' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 16/12/2025 02:44:30 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 ( '99432' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 16/12/2025 02:44:31 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 ( '99432' , '24047' , 'GESU E IL MIO AMICO SPECIALE - LA RICONCILIAZIONE GUIDA' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 16/12/2025 02:44:31 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 ( '99432' , '24045' , 'GESU E IL MIO AMICO SPECIALE - LA RICONCILIAZIONE' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 16/12/2025 02:44:31 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 ( '99432' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '13.12' , '13.12' , '0' , '0' , '13.12' ) 16/12/2025 02:44:31 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 ( '99432' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 16/12/2025 02:44:31 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 ( '99432' , '997' , 'BEATITUDINI SPIEGATE AI RAGAZZI - V. BOCCI' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 16/12/2025 02:44:31 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 ( '99432' , '24107' , 'IO E IL MIO AMICO GESU - GUIDA - B. FERRERO' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 16/12/2025 02:45:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3632' AND id_document != '99649' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-03') 16/12/2025 02:45:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3632', document_date = '2025-11-03', 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 = '22.00', price_tax_excluded = '18.03', date_upd = NOW() WHERE id_document = '99649' 16/12/2025 02:45:05 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 = '99649' 16/12/2025 02:45:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '99649' 16/12/2025 02:45:05 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 ( '99649' , '22968' , 'TURIBOLO H10' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 16/12/2025 02:45:05 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 ( '99649' , '24174' , 'CUORE DI MAMMA - CALENDARIO 2026' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 16/12/2025 02:45:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3631' AND id_document != '99647' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-03') 16/12/2025 02:45:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3631', document_date = '2025-11-03', 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 = '7.50', price_tax_excluded = '7.50', date_upd = NOW() WHERE id_document = '99647' 16/12/2025 02:45:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99647' 16/12/2025 02:45:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '99647' 16/12/2025 02:45:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99647' , '24069' , 'CINQUE PANI DORZO 2026' , '1' , '-1' , '4' , '7.5' , '7.5' , '0' , '0' , '7.50' ) 16/12/2025 02:47:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '4099' AND id_document != '100317' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 16/12/2025 02:47:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4099', document_date = '2025-12-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.00', price_tax_excluded = '4.00', date_upd = NOW() WHERE id_document = '100317' 16/12/2025 02:47:28 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 = '100317' 16/12/2025 02:47:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '100317' 16/12/2025 02:47:28 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 ( '100317' , '13840' , 'NONNI SONO UN TESORO' , '2' , '-2' , '4' , '1.25' , '1.25' , '0' , '0' , '2.50' ) 16/12/2025 02:47:28 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 ( '100317' , '21202' , 'PREGHIAMO CON IL NONNO E LA NONNA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 16/12/2025 02:48:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3854' AND id_document != '99991' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 16/12/2025 02:48:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3854', document_date = '2025-11-19', 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 = '176.84', price_tax_excluded = '161.48', date_upd = NOW() WHERE id_document = '99991' 16/12/2025 02:48:18 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 = '99991' 16/12/2025 02:48:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '99991' 16/12/2025 02:48:18 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 ( '99991' , '23919' , 'CE SPAZIO PER TE 2026 - 12-14 ANNI' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '5' , '15.68' ) 16/12/2025 02:48: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 ( '99991' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '8.00' ) 16/12/2025 02:48: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 ( '99991' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '0' , '22.00' ) 16/12/2025 02:48: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 ( '99991' , '23998' , 'PENSIERI EUCARISTICI 2026' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 16/12/2025 02:48: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 ( '99991' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '3' , '-3' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '3.60' ) 16/12/2025 02:48: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 ( '99991' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 16/12/2025 02:48: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 ( '99991' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 16/12/2025 02:48: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 ( '99991' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 16/12/2025 02:48: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 ( '99991' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 16/12/2025 02:48: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 ( '99991' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 16/12/2025 02:48: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 ( '99991' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '0' , '12.00' ) 16/12/2025 02:49:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '4200' AND id_document != '100439' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 16/12/2025 02:49:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4200', document_date = '2025-12-12', 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 = '39.23', date_upd = NOW() WHERE id_document = '100439' 16/12/2025 02:49:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100439' 16/12/2025 02:49:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '100439' 16/12/2025 02:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '20061' , 'BRACCIALE DECINA - BC528' , '8' , '-8' , '1' , '1.6000' , '1.3114754098361' , '22' , '0' , '12.80' ) 16/12/2025 02:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '18214' , 'BRACCIALE DECINA LEGNO CORDA - BC566' , '1' , '-1' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '1.80' ) 16/12/2025 02:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '2766' , 'CORONA PLASTICA VARI COLORI - 07' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 16/12/2025 02:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 16/12/2025 02:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 16/12/2025 02:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 16/12/2025 02:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '24015' , 'UN ANNO CON GESU' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 16/12/2025 02:50:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3885' AND id_document != '100039' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-22') 16/12/2025 02:50:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3885', document_date = '2025-11-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.90', price_tax_excluded = '35.97', date_upd = NOW() WHERE id_document = '100039' 16/12/2025 02:50:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100039' 16/12/2025 02:50:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '100039' 16/12/2025 02:50:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100039' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.9000' , '5.655737704918' , '22' , '0' , '6.90' ) 16/12/2025 02:50:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100039' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 16/12/2025 02:50:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100039' , '16075' , 'SCOPRI E DIPINGI LA BIBBIA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 16/12/2025 02:50:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100039' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '20.00' ) 16/12/2025 02:51:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3736' AND id_document != '99819' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-10') 16/12/2025 02:51:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3736', document_date = '2025-11-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '17.50', price_tax_excluded = '16.33', date_upd = NOW() WHERE id_document = '99819' 16/12/2025 02:51:10 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 = '99819' 16/12/2025 02:51:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '99819' 16/12/2025 02:51:10 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 ( '99819' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 16/12/2025 02:51:10 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 ( '99819' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 16/12/2025 02:51:10 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 ( '99819' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 16/12/2025 03:38:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '4260' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 03:38:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4260' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '11.89' , NOW() , NOW() ) 16/12/2025 03:38:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100517' 16/12/2025 03:38:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '100517' 16/12/2025 03:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100517' , '24427' , 'SACRA FAMIGLIA CM 6 - P696' , '5' , '-5' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '14.50' ) 16/12/2025 04:02:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '4261' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 04:02:06 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' , '4261' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 16/12/2025 04:02:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100518' 16/12/2025 04:02:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '100518' 16/12/2025 04:02:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100518' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 16/12/2025 04:02:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100518' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 16/12/2025 04:02:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100518' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 16/12/2025 04:28:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '279' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 04:28: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 ( '21' , '279' , '2025-12-16' , '' , '316' , '0' , '4669506' , 'VIA VITO LEMBO, 2 84020 PALOMONTE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.51' , '59.51' , NOW() , NOW() ) 16/12/2025 04:28: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 = '100519' 16/12/2025 04:28:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '100519' 16/12/2025 04:28: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 ( '100519' , '13397' , 'MIO GESU' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 16/12/2025 04:28: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 ( '100519' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 16/12/2025 04:28: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 ( '100519' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 16/12/2025 04:30:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '4262' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 04:30:47 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' , '4262' , '2025-12-16' , '' , '316' , '0' , '4669506' , 'VIA VITO LEMBO, 2 84020 PALOMONTE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '37.97' , NOW() , NOW() ) 16/12/2025 04:30:47 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 = '100520' 16/12/2025 04:30:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '100520' 16/12/2025 04:30:47 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 ( '100520' , '18804' , 'NOVENA AL NATALE - 8045' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '' , '6.00' ) 16/12/2025 04:30:47 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 ( '100520' , '20505' , 'CARTONCINO SAGOMATO - P720' , '60' , '-60' , '1' , '0.65' , '0.5327868852459' , '22' , '0' , '39.00' ) 16/12/2025 04:31:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '143/A' AND id_document != '100002' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-19') 16/12/2025 04:31:19 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '143/A', document_date = '2025-11-19', document_letter = 'A', id_customer = '316', id_supplier = '', id_address = '4669506', address1 = 'VIA VITO LEMBO, 2 84020 PALOMONTE', 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 = '338.77', price_tax_excluded = '329.57', date_upd = NOW() WHERE id_document = '100002' 16/12/2025 04:31: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 = '100002' 16/12/2025 04:31:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '100002' 16/12/2025 04:31: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 ( '100002' , '10751' , 'TU MI PERDONI' , '15' , '-15' , '4' , '6.9000' , '6.9' , '0' , '5' , '98.33' ) 16/12/2025 04:31: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 ( '100002' , '14719' , 'TU MI AMI DAVVERO' , '25' , '-25' , '4' , '6.9000' , '6.9' , '0' , '5' , '163.88' ) 16/12/2025 04:31: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 ( '100002' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '-1' , '1' , '51.0000' , '41.803278688525' , '22' , '0' , '51.00' ) 16/12/2025 04:31: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 ( '100002' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 16/12/2025 04:31: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 ( '100002' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '5' , '19.00' ) 16/12/2025 04:33:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '4263' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 04:33: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' , '4263' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.10' , '18.93' , NOW() , NOW() ) 16/12/2025 04:33: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 = '100521' 16/12/2025 04:33:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '100521' 16/12/2025 04:33: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 ( '100521' , '17617' , 'IMMAGINI ISONZO X 100' , '7' , '-7' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '23.10' ) 16/12/2025 05:05:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '4264' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 05:05:43 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' , '4264' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '122.00' , '106.10' , NOW() , NOW() ) 16/12/2025 05:05:43 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 = '100522' 16/12/2025 05:05:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '100522' 16/12/2025 05:05:43 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 ( '100522' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 16/12/2025 05:05:43 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 ( '100522' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 16/12/2025 05:05:43 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 ( '100522' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '79' , '64.754098360656' , '22' , '0' , '79.00' ) 16/12/2025 05:25:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '4265' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 05:25:08 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' , '4265' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '11.90' , NOW() , NOW() ) 16/12/2025 05:25: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 = '100523' 16/12/2025 05:25:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '100523' 16/12/2025 05:25: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 ( '100523' , '24179' , 'DILEXI TE' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '0' , '6.00' ) 16/12/2025 05:25: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 ( '100523' , '24298' , 'DISEGNARE NUOVE MAPPE DI SPERANZA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 16/12/2025 05:25: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 ( '100523' , '24400' , 'MATER POPULI FIDELIS' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '' , '3.90' ) 16/12/2025 05:27:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3490' AND id_document != '99446' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-24') 16/12/2025 05:27:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3490', document_date = '2025-10-24', 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 = '38.90', price_tax_excluded = '37.82', date_upd = NOW() WHERE id_document = '99446' 16/12/2025 05:27:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99446' 16/12/2025 05:27:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '99446' 16/12/2025 05:27:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 16/12/2025 05:27:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 16/12/2025 05:27:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 16/12/2025 05:27:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.38' , '6.38' , '0' , '0' , '6.38' ) 16/12/2025 05:27:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 16/12/2025 05:27:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 16/12/2025 05:28:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '4103' AND id_document != '100321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 16/12/2025 05:28:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4103', document_date = '2025-12-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '100321' 16/12/2025 05:28:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100321' 16/12/2025 05:28:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '100321' 16/12/2025 05:28:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100321' , '21688' , 'ANGELO PIEGHEVOLE CM 15' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/12/2025 05:28:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100321' , '21689' , 'ANGELO PIEGHEVOLE CM 12' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/12/2025 05:29:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '4169' AND id_document != '100402' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-11') 16/12/2025 05:29:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4169', document_date = '2025-12-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.70', price_tax_excluded = '15.33', date_upd = NOW() WHERE id_document = '100402' 16/12/2025 05:29:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100402' 16/12/2025 05:29:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '100402' 16/12/2025 05:29:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100402' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 16/12/2025 05:29:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100402' , '14875' , 'ANGELO IN RESINA CON FLAUTO CM 9 - KS124-F' , '1' , '-1' , '1' , '6.7' , '5.4918032786885' , '22' , '0' , '6.70' ) 16/12/2025 05:44:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '4266' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 05:44:43 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' , '4266' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 16/12/2025 05:44:43 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 = '100524' 16/12/2025 05:44:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '100524' 16/12/2025 05:44:43 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 ( '100524' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 16/12/2025 05:51:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4267' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 05:51:14 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' , '4267' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.35' , '0.29' , NOW() , NOW() ) 16/12/2025 05:51:14 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 = '100525' 16/12/2025 05:51:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '100525' 16/12/2025 05:51:14 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 ( '100525' , '20758' , 'SEGNALIBRO 5X15' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 16/12/2025 05:51:15 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 ( '100525' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 16/12/2025 06:00:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '4264' AND id_document != '100522' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 06:00:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4264', document_date = '2025-12-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 = '122.00', price_tax_excluded = '106.10', date_upd = NOW() WHERE id_document = '100522' 16/12/2025 06:00:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100522' 16/12/2025 06:00:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '100522' 16/12/2025 06:00:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100522' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 16/12/2025 06:00:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100522' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 16/12/2025 06:00:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100522' , '22756' , 'CROCIFISSO SAGOMATO nazareno 30X19 - 1030161' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 16/12/2025 06:00:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '4262' AND id_document != '100520' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 06:00:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4262', document_date = '2025-12-16', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA VITO LEMBO, 2 84020 PALOMONTE', 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 = '37.97', date_upd = NOW() WHERE id_document = '100520' 16/12/2025 06:00:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100520' 16/12/2025 06:00:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '100520' 16/12/2025 06:00:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100520' , '18804' , 'NOVENA AL NATALE - 8045' , '2' , '-2' , '4' , '3.0000' , '3' , '0' , '' , '6.00' ) 16/12/2025 06:00:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100520' , '20505' , 'CARTONCINO SAGOMATO - P720' , '60' , '-60' , '1' , '0.6500' , '0.5327868852459' , '22' , '0' , '39.00' ) 16/12/2025 06:10:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '4268' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 06:10:39 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' , '4268' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 16/12/2025 06:10:39 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 = '100526' 16/12/2025 06:10:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100526' 16/12/2025 06:10:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100526' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 16/12/2025 06:17:52 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '1/787', document_date = '2025-03-31', document_letter = '787', id_customer = '0', id_supplier = '', id_address = '4670575', address1 = 'VIA RAFFAELE RUGGI, 29 80125 NAPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '45.21', price_tax_excluded = '37.06', date_upd = NOW() WHERE id_document = '96426' 16/12/2025 06:17:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96426' 16/12/2025 06:17:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '96426' 16/12/2025 06:17:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96426' , '23146' , 'SPILLA PORTA CIUCCIO CEL.' , '1' , '1' , '1' , '5.3279' , '4.367131147541' , '22' , '0' , '6.5000' ) 16/12/2025 06:17:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96426' , '23621' , 'MEDAGLIA S. RITA ARG' , '2' , '2' , '1' , '13.2000' , '10.819672131148' , '22' , '0' , '32.21' ) 16/12/2025 06:17:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96426' , '23147' , 'SPILLA PORTA CIUCCIO ROSA' , '1' , '1' , '1' , '5.327' , '4.366393442623' , '22' , '0' , '6.4989' ) 16/12/2025 06:19:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3688' AND id_document != '99748' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 16/12/2025 06:19:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3688', document_date = '2025-11-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '99748' 16/12/2025 06:19: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 = '99748' 16/12/2025 06:19:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '99748' 16/12/2025 06:19: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 ( '99748' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '100' , '-100' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '35.00' ) 16/12/2025 06:19: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 ( '99748' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 16/12/2025 06:19: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 ( '99748' , '23146' , 'SPILLA PORTA CIUCCIO CEL.' , '2' , '-2' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '32.00' ) 16/12/2025 07:10:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '4269' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 07:10: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 ( '11' , '4269' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.80' , '57.30' , NOW() , NOW() ) 16/12/2025 07:10: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 = '100527' 16/12/2025 07:10:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '100527' 16/12/2025 07:10: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 ( '100527' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 16/12/2025 07:10: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 ( '100527' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '2' , '-2' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '23.00' ) 16/12/2025 07:10: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 ( '100527' , '17872' , 'GIGLER PER LUMINELLO - 474/G' , '2' , '-2' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '7.80' ) 16/12/2025 07:10: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 ( '100527' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '13.00' ) 16/12/2025 07:10: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 ( '100527' , '22681' , 'OGNI GIORNO PREGHIAMO' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 16/12/2025 07:34:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '4269' AND id_document != '100527' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 07:34:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4269', document_date = '2025-12-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 = '68.80', price_tax_excluded = '57.30', date_upd = NOW() WHERE id_document = '100527' 16/12/2025 07:34:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100527' 16/12/2025 07:34:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '100527' 16/12/2025 07:34:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100527' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 16/12/2025 07:34:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100527' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '2' , '-2' , '1' , '11.5000' , '9.4262295081967' , '22' , '0' , '23.00' ) 16/12/2025 07:34:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100527' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '3.9' , '3.1967213114754' , '22' , '0' , '7.80' ) 16/12/2025 07:34:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100527' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '13.00' ) 16/12/2025 07:34:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100527' , '22681' , 'OGNI GIORNO PREGHIAMO' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 16/12/2025 07:41:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4270' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 16/12/2025 07:41:14 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' , '4270' , '2025-12-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 16/12/2025 07:41:14 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 = '100528' 16/12/2025 07:41:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '100528' 16/12/2025 07:41:14 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 ( '100528' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' )