24/01/2026 09:10:26 am >> SELECT document_num FROM ps_document WHERE document_num = '15/A' AND id_document != '101051' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-22') 24/01/2026 09:10:26 am >> UPDATE ps_document SET id_document_type = '24', document_num = '15/A', document_date = '2026-01-22', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '17', id_causal = '0', price_tax_included = '1081.00', price_tax_excluded = '1081.00', date_upd = NOW() WHERE id_document = '101051' 24/01/2026 09:10:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101051' 24/01/2026 09:10:27 am >> DELETE FROM ps_document_detail WHERE id_document = '101051' 24/01/2026 09:10: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 ( '101051' , '0' , 'clergy mm tinta unita bianco/blu' , '73' , '-73' , '0' , '12.0000' , '12' , '0' , '0' , '876.00' ) 24/01/2026 09:10: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 ( '101051' , '0' , 'croce sacerdotale - 797 spilla' , '150' , '-150' , '0' , '0.7000' , '0.7' , '0' , '0' , '105.00' ) 24/01/2026 09:10: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 ( '101051' , '19906' , 'FASCIA PER TALARE' , '1' , '-1' , '0' , '100.00' , '100' , '' , '0' , '100.00' ) 24/01/2026 09:27:00 am >> SELECT document_num FROM ps_document WHERE document_num = '20/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 09:27:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '20/A' , '2026-01-24' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '338.40' , '277.38' , NOW() , NOW() ) 24/01/2026 09:27:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101079' 24/01/2026 09:27:00 am >> DELETE FROM ps_document_detail WHERE id_document = '101079' 24/01/2026 09:27:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101079' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 24/01/2026 09:27:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101079' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 24/01/2026 09:27:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101079' , '6014' , 'LUMINO BIANCO - 10B' , '384' , '-384' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '192.00' ) 24/01/2026 09:33:14 am >> SELECT document_num FROM ps_document WHERE document_num = '17/A' AND id_document != '101060' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-23') 24/01/2026 09:33:14 am >> UPDATE ps_document SET id_document_type = '24', document_num = '17/A', document_date = '2026-01-23', document_letter = 'A', id_customer = '1175', id_supplier = '', id_address = '4679143', address1 = 'VIA BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = 'VEDI SCONTRINO N. 251 DEL 23/01/2026 - pagati € 222,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '17', id_causal = '0', price_tax_included = '278.00', price_tax_excluded = '227.87', date_upd = NOW() WHERE id_document = '101060' 24/01/2026 09:33:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101060' 24/01/2026 09:33:14 am >> DELETE FROM ps_document_detail WHERE id_document = '101060' 24/01/2026 09:33:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101060' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '500.0000' , '409.83606557377' , '22' , '0' , '500.00' ) 24/01/2026 09:33:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101060' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '-222.0000' , '-181.96721311475' , '22' , '0' , '-222.00' ) 24/01/2026 09:36:04 am >> DELETE FROM ps_document WHERE id_document = '101079' 24/01/2026 09:36:04 am >> DELETE FROM ps_document_detail WHERE id_document = '101079' 24/01/2026 09:37:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3932' AND id_document != '100102' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26') 24/01/2026 09:37:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3932', document_date = '2025-11-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '17', id_causal = '0', price_tax_included = '74.00', price_tax_excluded = '61.93', date_upd = NOW() WHERE id_document = '100102' 24/01/2026 09:37:17 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 = '100102' 24/01/2026 09:37:17 am >> DELETE FROM ps_document_detail WHERE id_document = '100102' 24/01/2026 09:37:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '22962' , 'VINO BIANCO DOLCE MIGNON' , '5' , '-5' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '16.50' ) 24/01/2026 09:37:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 24/01/2026 09:37:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 24/01/2026 09:37:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '2' , '-2' , '1' , '6.7000' , '5.4918032786885' , '22' , '0' , '13.40' ) 24/01/2026 09:37:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' , '7.8000' , '6.3934426229508' , '22' , '0' , '15.60' ) 24/01/2026 09:37:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '9' , '-9' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '18.00' ) 24/01/2026 09:37:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '6014' , 'LUMINO BIANCO - 10B' , '3' , '-3' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.50' ) 24/01/2026 09:38:53 am >> SELECT document_num FROM ps_document WHERE document_num = '4228' AND id_document != '100470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-15') 24/01/2026 09:38:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4228', document_date = '2025-12-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '17', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '100470' 24/01/2026 09:38:53 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 = '100470' 24/01/2026 09:38:53 am >> DELETE FROM ps_document_detail WHERE id_document = '100470' 24/01/2026 09:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100470' , '17872' , 'GIGLER PER LUMINELLO - 474/G' , '1' , '-1' , '1' , '3.9000' , '3.1967213114754' , '22' , '0' , '3.90' ) 24/01/2026 09:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100470' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '1' , '-1' , '1' , '11.5000' , '9.4262295081967' , '22' , '0' , '11.50' ) 24/01/2026 09:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100470' , '20969' , 'MEDAGLIA ADDOLORATA' , '1' , '-1' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '0.10' ) 24/01/2026 09:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100470' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 24/01/2026 09:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100470' , '6014' , 'LUMINO BIANCO - 10B' , '20' , '-20' , '1' , '0.48' , '0.39344262295082' , '22' , '0' , '9.60' ) 24/01/2026 09:39:42 am >> SELECT document_num FROM ps_document WHERE document_num = '4389' AND id_document != '100669' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 24/01/2026 09:39:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4389', document_date = '2025-12-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 = '17', id_causal = '0', price_tax_included = '127.00', price_tax_excluded = '104.10', date_upd = NOW() WHERE id_document = '100669' 24/01/2026 09:39:43 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 = '100669' 24/01/2026 09:39:43 am >> DELETE FROM ps_document_detail WHERE id_document = '100669' 24/01/2026 09:39:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100669' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 24/01/2026 09:39:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100669' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '10' , '-10' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '18.00' ) 24/01/2026 09:39:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100669' , '6014' , 'LUMINO BIANCO - 10B' , '38' , '-38' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '19.00' ) 24/01/2026 09:40:18 am >> SELECT document_num FROM ps_document WHERE document_num = '4381' AND id_document != '100661' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 24/01/2026 09:40:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4381', document_date = '2025-12-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 = '17', id_causal = '0', price_tax_included = '51.70', price_tax_excluded = '45.97', date_upd = NOW() WHERE id_document = '100661' 24/01/2026 09:40:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100661' 24/01/2026 09:40:18 am >> DELETE FROM ps_document_detail WHERE id_document = '100661' 24/01/2026 09:40:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100661' , '24210' , 'LIBERI DI AMARE - CHIARA AMIRANTE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 24/01/2026 09:40:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100661' , '14143' , 'SAN FRANCESCO D\'ASSISI - RACCONTATO AI RAGAZZI' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 24/01/2026 09:40:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100661' , '15414' , 'CROCE VETRO CM 25 LINEA ROMA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 24/01/2026 09:40:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100661' , '20896' , 'SANTI DEL MESSALINO. MONICA LA VITA 8467' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 24/01/2026 09:40:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100661' , '6014' , 'LUMINO BIANCO - 10B' , '6' , '-6' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '1.80' ) 24/01/2026 09:41:27 am >> SELECT document_num FROM ps_document WHERE document_num = '4384' AND id_document != '100664' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 24/01/2026 09:41:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4384', document_date = '2025-12-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 = '17', id_causal = '0', price_tax_included = '28.80', price_tax_excluded = '25.59', date_upd = NOW() WHERE id_document = '100664' 24/01/2026 09:41: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 = '100664' 24/01/2026 09:41:27 am >> DELETE FROM ps_document_detail WHERE id_document = '100664' 24/01/2026 09:41: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 ( '100664' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 24/01/2026 09:41: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 ( '100664' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/01/2026 09:41: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 ( '100664' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '2' , '-2' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.30' ) 24/01/2026 09:41: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 ( '100664' , '18141' , 'TAU SNODATO PADRE NOSTRO GRANDE' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 24/01/2026 09:41: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 ( '100664' , '6014' , 'LUMINO BIANCO - 10B' , '7' , '-7' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '3.50' ) 24/01/2026 09:41:53 am >> SELECT document_num FROM ps_document WHERE document_num = '4385' AND id_document != '100665' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 24/01/2026 09:41:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4385', document_date = '2025-12-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 = '17', id_causal = '0', price_tax_included = '11.30', price_tax_excluded = '9.26', date_upd = NOW() WHERE id_document = '100665' 24/01/2026 09:41:53 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 = '100665' 24/01/2026 09:41:53 am >> DELETE FROM ps_document_detail WHERE id_document = '100665' 24/01/2026 09:41:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100665' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '1' , '-1' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '9.50' ) 24/01/2026 09:41:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100665' , '6014' , 'LUMINO BIANCO - 10B' , '6' , '-6' , '1' , '.3' , '0.24590163934426' , '22' , '0' , '1.80' ) 24/01/2026 09:42:26 am >> SELECT document_num FROM ps_document WHERE document_num = '4400' AND id_document != '100683' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/01/2026 09:42:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4400', document_date = '2025-12-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 = '17', id_causal = '0', price_tax_included = '16.90', price_tax_excluded = '14.50', date_upd = NOW() WHERE id_document = '100683' 24/01/2026 09:42:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100683' 24/01/2026 09:42:26 am >> DELETE FROM ps_document_detail WHERE id_document = '100683' 24/01/2026 09:42:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100683' , '20162' , 'ROSARIO SAN BENEDETTO - 195/23' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 24/01/2026 09:42:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100683' , '23892' , 'CROCE S. BENEDETTO - 730' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 24/01/2026 09:42:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100683' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '2' , '-2' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.30' ) 24/01/2026 09:42:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100683' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 24/01/2026 09:42:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100683' , '9586' , 'SANTA MESSA - CATALINA RIVAS' , '2' , '-2' , '4' , '1.4000' , '1.4' , '0' , '0' , '2.80' ) 24/01/2026 09:42:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100683' , '6014' , 'LUMINO BIANCO - 10B' , '7' , '-7' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '3.50' ) 24/01/2026 09:42:43 am >> SELECT document_num FROM ps_document WHERE document_num = '4430' AND id_document != '100716' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 24/01/2026 09:42:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4430', document_date = '2025-12-29', 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 = '17', id_causal = '0', price_tax_included = '3.00', price_tax_excluded = '2.46', date_upd = NOW() WHERE id_document = '100716' 24/01/2026 09:42:43 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 = '100716' 24/01/2026 09:42:43 am >> DELETE FROM ps_document_detail WHERE id_document = '100716' 24/01/2026 09:42:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100716' , '6014' , 'LUMINO BIANCO - 10B' , '6' , '-6' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '3.00' ) 24/01/2026 09:43:21 am >> SELECT document_num FROM ps_document WHERE document_num = '4433' AND id_document != '100722' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 24/01/2026 09:43:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4433', document_date = '2025-12-29', 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 = '17', id_causal = '0', price_tax_included = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '100722' 24/01/2026 09:43:21 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 = '100722' 24/01/2026 09:43:21 am >> DELETE FROM ps_document_detail WHERE id_document = '100722' 24/01/2026 09:43:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100722' , '6354' , 'MEDAGLIA S. MICHELE - G022.22' , '2' , '-2' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.40' ) 24/01/2026 09:43:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100722' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '2' , '-2' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '2.60' ) 24/01/2026 09:43:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100722' , '6014' , 'LUMINO BIANCO - 10B' , '11' , '-11' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.50' ) 24/01/2026 09:44:10 am >> SELECT document_num FROM ps_document WHERE document_num = '4415' AND id_document != '100698' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 24/01/2026 09:44:10 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4415', document_date = '2025-12-29', 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 = '17', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '100698' 24/01/2026 09:44:10 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 = '100698' 24/01/2026 09:44:10 am >> DELETE FROM ps_document_detail WHERE id_document = '100698' 24/01/2026 09:44:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 24/01/2026 09:44:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 24/01/2026 09:44:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '6354' , 'MEDAGLIA S. MICHELE - G022.22' , '1' , '-1' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '0.10' ) 24/01/2026 09:44:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '4' , '-4' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '4.40' ) 24/01/2026 09:44:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 24/01/2026 09:44:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '24413' , 'SOTTO QUESTO CIELO' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 24/01/2026 09:44:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '6014' , 'LUMINO BIANCO - 10B' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 24/01/2026 09:44:41 am >> SELECT document_num FROM ps_document WHERE document_num = '4267' AND id_document != '100525' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 24/01/2026 09:44:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4267', 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 = '17', id_causal = '0', price_tax_included = '0.35', price_tax_excluded = '0.29', date_upd = NOW() WHERE id_document = '100525' 24/01/2026 09:44:41 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 = '100525' 24/01/2026 09:44:41 am >> DELETE FROM ps_document_detail WHERE id_document = '100525' 24/01/2026 09:44:41 am >> INSERT INTO ps_document_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.2000' , '0.16393442622951' , '22' , '0' , '0.20' ) 24/01/2026 09:44:41 am >> INSERT INTO ps_document_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.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 24/01/2026 09:45:15 am >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '100765' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 24/01/2026 09:45:15 am >> UPDATE ps_document SET id_document_type = '11', document_num = '17', document_date = '2026-01-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 = '17', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '100765' 24/01/2026 09:45: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 = '100765' 24/01/2026 09:45:15 am >> DELETE FROM ps_document_detail WHERE id_document = '100765' 24/01/2026 09:45: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 ( '100765' , '6014' , 'LUMINO BIANCO - 10B' , '100' , '-100' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '50.00' ) 24/01/2026 09:45:40 am >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '100766' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 24/01/2026 09:45:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '18', document_date = '2026-01-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 = '17', id_causal = '0', price_tax_included = '3.00', price_tax_excluded = '2.46', date_upd = NOW() WHERE id_document = '100766' 24/01/2026 09:45:40 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 = '100766' 24/01/2026 09:45:41 am >> DELETE FROM ps_document_detail WHERE id_document = '100766' 24/01/2026 09:45:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100766' , '6014' , 'LUMINO BIANCO - 10B' , '6' , '-6' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '3.00' ) 24/01/2026 09:48:05 am >> SELECT document_num FROM ps_document WHERE document_num = '4422' AND id_document != '100707' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 24/01/2026 09:48:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4422', document_date = '2025-12-29', 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 = '17', id_causal = '0', price_tax_included = '1600.00', price_tax_excluded = '1311.48', date_upd = NOW() WHERE id_document = '100707' 24/01/2026 09:48:05 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 = '100707' 24/01/2026 09:48:05 am >> DELETE FROM ps_document_detail WHERE id_document = '100707' 24/01/2026 09:48:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100707' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '187' , '153.27868852459' , '22' , '0' , '187.00' ) 24/01/2026 09:48:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100707' , '15210' , 'CERO PASQUALE API 80X120' , '20' , '-20' , '1' , '60' , '49.180327868852' , '22' , '0' , '1200.00' ) 24/01/2026 09:48:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100707' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '75.00' ) 24/01/2026 09:48:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100707' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4' , '3.2786885245902' , '22' , '0' , '48.00' ) 24/01/2026 09:48:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100707' , '6014' , 'LUMINO BIANCO - 10B' , '300' , '-300' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '90.00' ) 24/01/2026 10:00:33 am >> DELETE FROM ps_document WHERE id_document = '101051' 24/01/2026 10:00:34 am >> DELETE FROM ps_document_detail WHERE id_document = '101051' 24/01/2026 10:01:35 am >> DELETE FROM ps_document WHERE id_document = '101078' 24/01/2026 10:01:35 am >> DELETE FROM ps_document_detail WHERE id_document = '101078' 24/01/2026 10:02:20 am >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '100759' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 24/01/2026 10:02:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '12', document_date = '2026-01-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 = '17', id_causal = '0', price_tax_included = '12.50', price_tax_excluded = '10.52', date_upd = NOW() WHERE id_document = '100759' 24/01/2026 10:02:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100759' 24/01/2026 10:02:20 am >> DELETE FROM ps_document_detail WHERE id_document = '100759' 24/01/2026 10:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100759' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 24/01/2026 10:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100759' , '17141' , 'RICAMBIO VETRO - 34/V' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 24/01/2026 10:02:45 am >> SELECT document_num FROM ps_document WHERE document_num = '49' AND id_document != '100803' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-05') 24/01/2026 10:02:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '49', document_date = '2026-01-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '17', id_causal = '0', price_tax_included = '13.00', price_tax_excluded = '10.66', date_upd = NOW() WHERE id_document = '100803' 24/01/2026 10:02:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100803' 24/01/2026 10:02:45 am >> DELETE FROM ps_document_detail WHERE id_document = '100803' 24/01/2026 10:02:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100803' , '17141' , 'RICAMBIO VETRO - 34/V' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 24/01/2026 10:04:22 am >> SELECT document_num FROM ps_document WHERE document_num = '48' AND id_document != '100798' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-05') 24/01/2026 10:04:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '48', document_date = '2026-01-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '17', id_causal = '0', price_tax_included = '393.41', price_tax_excluded = '356.08', date_upd = NOW() WHERE id_document = '100798' 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100798' 24/01/2026 10:04:23 am >> DELETE FROM ps_document_detail WHERE id_document = '100798' 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '6' , '-6' , '4' , '5.0000' , '5' , '0' , '5' , '28.50' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '10' , '-10' , '4' , '5.0000' , '5' , '0' , '5' , '47.50' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '7' , '-7' , '4' , '5.0000' , '5' , '0' , '5' , '33.25' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '5' , '-5' , '4' , '5.0000' , '5' , '0' , '5' , '23.75' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '782' , 'ASPERGES PER SECCHIELLO - 701' , '1' , '-1' , '1' , '47.0000' , '38.524590163934' , '22' , '0' , '47.00' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '24215' , 'DILEXI TE - 8429' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '23090' , 'ALBERO CON PRESEPE ' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '10' , '-10' , '4' , '2.1500' , '2.15' , '0' , '0' , '21.50' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '24348' , 'MESSALINO QUOTIDIANO - FEB MAR APR 26' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '5' , '11.40' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 24/01/2026 10:04:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100798' , '11756' , 'VINO BIANCO SECCO - 14%' , '18' , '-18' , '1' , '6' , '4.9180327868852' , '22' , '0' , '108.00' ) 24/01/2026 10:05:23 am >> SELECT document_num FROM ps_document WHERE document_num = '19/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 10:05:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '19/A' , '2026-01-24' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '6480.00' , '6480.00' , NOW() , NOW() ) 24/01/2026 10:05:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101080' 24/01/2026 10:05:23 am >> DELETE FROM ps_document_detail WHERE id_document = '101080' 24/01/2026 10:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101080' , '24478' , 'P. LODOVICO SANTORO - M. DRAGONE G. GAGLIARDUCCI' , '810' , '-810' , '4' , '8.00' , '8' , '0' , '0' , '6480.00' ) 24/01/2026 10:05:35 am >> DELETE FROM ps_document WHERE id_document = '101080' 24/01/2026 10:05:35 am >> DELETE FROM ps_document_detail WHERE id_document = '101080' 24/01/2026 10:29:49 am >> SELECT document_num FROM ps_document WHERE document_num = '269' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 10:29:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '269' , '2026-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 24/01/2026 10:29:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101081' 24/01/2026 10:29:49 am >> DELETE FROM ps_document_detail WHERE id_document = '101081' 24/01/2026 10:29:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101081' , '21289' , 'STELLARIO PLEX CM 22' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 24/01/2026 10:44:05 am >> SELECT document_num FROM ps_document WHERE document_num = '270' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 10:44:05 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' , '270' , '2026-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '94.00' , '77.05' , NOW() , NOW() ) 24/01/2026 10:44:05 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 = '101082' 24/01/2026 10:44:05 am >> DELETE FROM ps_document_detail WHERE id_document = '101082' 24/01/2026 10:44:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101082' , '18947' , 'CLERGY COMODA MISTO - ML' , '2' , '-2' , '1' , '42' , '34.426229508197' , '22' , '0' , '84.00' ) 24/01/2026 10:44:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101082' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 24/01/2026 10:46:54 am >> SELECT document_num FROM ps_document WHERE document_num = '271' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 10:46: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' , '271' , '2026-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '4.00' , '3.70' , NOW() , NOW() ) 24/01/2026 10:46: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 = '101083' 24/01/2026 10:46:54 am >> DELETE FROM ps_document_detail WHERE id_document = '101083' 24/01/2026 10:46: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 ( '101083' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 24/01/2026 10:46: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 ( '101083' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 24/01/2026 10:52:33 am >> SELECT document_num FROM ps_document WHERE document_num = '272' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 10:52:33 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' , '272' , '2026-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '48.50' , '40.39' , NOW() , NOW() ) 24/01/2026 10:52:33 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 = '101084' 24/01/2026 10:52:33 am >> DELETE FROM ps_document_detail WHERE id_document = '101084' 24/01/2026 10:52:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101084' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 24/01/2026 10:52:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101084' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 24/01/2026 11:19:33 am >> SELECT document_num FROM ps_document WHERE document_num = '273' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 11:19:33 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' , '273' , '2026-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 24/01/2026 11:19:33 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 = '101085' 24/01/2026 11:19:33 am >> DELETE FROM ps_document_detail WHERE id_document = '101085' 24/01/2026 11:19:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101085' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 24/01/2026 11:20:54 am >> SELECT document_num FROM ps_document WHERE document_num = '274' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 11:20: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' , '274' , '2026-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '10.20' , '10.20' , NOW() , NOW() ) 24/01/2026 11:20: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 = '101086' 24/01/2026 11:20:54 am >> DELETE FROM ps_document_detail WHERE id_document = '101086' 24/01/2026 11:20: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 ( '101086' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10.2' , '10.2' , '0' , '0' , '10.20' ) 24/01/2026 11:42:34 am >> SELECT document_num FROM ps_document WHERE document_num = '275' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 11:42:34 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' , '275' , '2026-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 24/01/2026 11:42:34 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 = '101087' 24/01/2026 11:42:34 am >> DELETE FROM ps_document_detail WHERE id_document = '101087' 24/01/2026 11:42:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101087' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' , '105.00' , '86.065573770492' , '22' , '0' , '105.00' ) 24/01/2026 11:47:20 am >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 11:47:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '16' , '2026-01-24' , '' , '3045' , '0' , '4679365' , 'VIA MAESTRI DEL LAVORO 17 85100 POTENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '224.00' , '224.00' , NOW() , NOW() ) 24/01/2026 11:47:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101088' 24/01/2026 11:47:20 am >> DELETE FROM ps_document_detail WHERE id_document = '101088' 24/01/2026 11:47:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101088' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '0' , '40.00' , '40' , '' , '5' , '38.00' ) 24/01/2026 11:47:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101088' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '0' , '40.00' , '40' , '' , '5' , '38.00' ) 24/01/2026 11:47:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101088' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '0' , '40.00' , '40' , '' , '5' , '38.00' ) 24/01/2026 11:47:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101088' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '0' , '110.00' ) 24/01/2026 11:53:08 am >> SELECT document_num FROM ps_document WHERE document_num = '276' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 11:53:09 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' , '276' , '2026-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '13.70' , '11.23' , NOW() , NOW() ) 24/01/2026 11:53:09 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 = '101089' 24/01/2026 11:53:09 am >> DELETE FROM ps_document_detail WHERE id_document = '101089' 24/01/2026 11:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101089' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 24/01/2026 11:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101089' , '22546' , 'ROSARIO LEGNO - MM5 - R944' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 24/01/2026 11:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101089' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' ) 24/01/2026 11:54:39 am >> SELECT document_num FROM ps_document WHERE document_num = '19/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 11:54:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '19/A' , '2026-01-24' , 'A' , '2033' , '0' , '4671607' , 'VIA PISACANE 12 85057 TRAMUTOLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '43.90' , '42.30' , NOW() , NOW() ) 24/01/2026 11:54:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101090' 24/01/2026 11:54:39 am >> DELETE FROM ps_document_detail WHERE id_document = '101090' 24/01/2026 11:54:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101090' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.70' , '0.7' , '0' , '0' , '35.00' ) 24/01/2026 11:54:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101090' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 24/01/2026 11:57:50 am >> SELECT document_num FROM ps_document WHERE document_num = '20/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 11:57:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '20/A' , '2026-01-24' , 'A' , '3191' , '0' , '4679345' , 'VIA QUINTINO DI VONA 84133 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '187.60' , '187.60' , NOW() , NOW() ) 24/01/2026 11:57:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101091' 24/01/2026 11:57:50 am >> DELETE FROM ps_document_detail WHERE id_document = '101091' 24/01/2026 11:57:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101091' , '21899' , 'SACRA BIBBIA cei/uelci ' , '8' , '-8' , '4' , '18.50' , '18.5' , '0' , '0' , '148.00' ) 24/01/2026 11:57:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101091' , '1090' , 'BIBBIA' , '4' , '-4' , '4' , '9.90' , '9.9' , '0' , '0' , '39.60' ) 24/01/2026 12:14:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 12:14:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '21/A' , '2026-01-24' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'univerità' , '0' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 24/01/2026 12:14:21 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 = '101092' 24/01/2026 12:14:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '101092' 24/01/2026 12:14:21 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 ( '101092' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.70' , '0.7' , '0' , '0' , '35.00' ) 24/01/2026 12:49:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '277' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-24') 24/01/2026 12:49: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' , '277' , '2026-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '37.00' , '33.90' , NOW() , NOW() ) 24/01/2026 12:49: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 = '101093' 24/01/2026 12:49:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '101093' 24/01/2026 12:49: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 ( '101093' , '18812' , 'ANGELI NELLA BIBBIA' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 24/01/2026 12:49: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 ( '101093' , '4948' , 'IMITAZIONE DI CRISTO - TASC - 8818' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 24/01/2026 12:49: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 ( '101093' , '22406' , 'GESU CONFIDO IN TE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/01/2026 12:49: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 ( '101093' , '22152' , 'A TE RICORRIAMO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/01/2026 12:49: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 ( '101093' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 24/01/2026 12:49: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 ( '101093' , '3159' , 'CROCE ULIVO SAN BENEDETTO - GRANDE - 741' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 24/01/2026 12:49: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 ( '101093' , '20067' , 'CATENINA CON MED. SAN BENEDETTO - NS047' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 24/01/2026 12:49: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 ( '101093' , '19600' , 'ROSARIO SPIRITO SANTO' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 24/01/2026 12:49: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 ( '101093' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' )