09/09/2025 09:27:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1206' AND id_document != '96646' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-12') 09/09/2025 09:27:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1206', document_date = '2025-04-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 = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '96646' 09/09/2025 09:27: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 = '96646' 09/09/2025 09:27:53 am >> DELETE FROM ps_document_detail WHERE id_document = '96646' 09/09/2025 09:27: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 ( '96646' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '9.00' ) 09/09/2025 09:29:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2187' AND id_document != '97779' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-20') 09/09/2025 09:29:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2187', document_date = '2025-06-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '226.00', price_tax_excluded = '185.25', date_upd = NOW() WHERE id_document = '97779' 09/09/2025 09:29:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97779' 09/09/2025 09:29:07 am >> DELETE FROM ps_document_detail WHERE id_document = '97779' 09/09/2025 09:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97779' , '19343' , 'BALZA IN RASO - P455' , '7' , '-7' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '117.00' ) 09/09/2025 09:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97779' , '19710' , 'CINGOLO ORO - 55/8898' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 09/09/2025 09:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97779' , '16456' , 'CINGOLO - CING03' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 09/09/2025 09:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97779' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 09/09/2025 09:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97779' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '100' , '0.00' ) 09/09/2025 09:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97779' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 09/09/2025 09:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97779' , '23553' , ' CONFEZIONE LIBRO + CORONCINA ACUTIS - 10941' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 09/09/2025 09:34:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1971' AND id_document != '92275' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-13') 09/09/2025 09:34:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1971', document_date = '2024-06-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '84.50', price_tax_excluded = '71.75', date_upd = NOW() WHERE id_document = '92275' 09/09/2025 09:34: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 = '92275' 09/09/2025 09:34:49 am >> DELETE FROM ps_document_detail WHERE id_document = '92275' 09/09/2025 09:34: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 ( '92275' , '15497' , 'CROCE PLEX - 086' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 09/09/2025 09:34: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 ( '92275' , '15094' , 'BRACCIALE DECINA CORDA TAU' , '2' , '-2' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '2.60' ) 09/09/2025 09:34: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 ( '92275' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 09/09/2025 09:34: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 ( '92275' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 09/09/2025 09:34: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 ( '92275' , '15419' , 'CROCE ICE CM 25 ' , '1' , '-1' , '1' , '36.5000' , '29.918032786885' , '22' , '0' , '36.50' ) 09/09/2025 09:34: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 ( '92275' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16.9' , '13.852459016393' , '22' , '0' , '16.90' ) 09/09/2025 09:35:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2330' AND id_document != '97946' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 09/09/2025 09:35:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2330', document_date = '2025-07-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '24.00', price_tax_excluded = '19.67', date_upd = NOW() WHERE id_document = '97946' 09/09/2025 09:35: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 = '97946' 09/09/2025 09:35:23 am >> DELETE FROM ps_document_detail WHERE id_document = '97946' 09/09/2025 09:35: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 ( '97946' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '10' , '-10' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '20.00' ) 09/09/2025 09:35: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 ( '97946' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 09/09/2025 09:35:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2329' AND id_document != '97945' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 09/09/2025 09:35:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2329', document_date = '2025-07-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '31.00', price_tax_excluded = '25.41', date_upd = NOW() WHERE id_document = '97945' 09/09/2025 09:35: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 = '97945' 09/09/2025 09:35:50 am >> DELETE FROM ps_document_detail WHERE id_document = '97945' 09/09/2025 09:35: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 ( '97945' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 09/09/2025 09:35: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 ( '97945' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 09/09/2025 09:35: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 ( '97945' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 09/09/2025 09:35: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 ( '97945' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 09/09/2025 09:37:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2893' AND id_document != '98639' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-06') 09/09/2025 09:37:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2893', document_date = '2025-09-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 = '98.01', price_tax_excluded = '81.69', date_upd = NOW() WHERE id_document = '98639' 09/09/2025 09:37: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 = '98639' 09/09/2025 09:37:13 am >> DELETE FROM ps_document_detail WHERE id_document = '98639' 09/09/2025 09:37: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 ( '98639' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 09/09/2025 09:37: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 ( '98639' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 09/09/2025 09:37: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 ( '98639' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '39.5' , '32.377049180328' , '22' , '0' , '39.50' ) 09/09/2025 09:37:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2114' AND id_document != '97693' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-13') 09/09/2025 09:37:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2114', document_date = '2025-06-13', 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 = '159.00', price_tax_excluded = '132.95', date_upd = NOW() WHERE id_document = '97693' 09/09/2025 09:37:44 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 = '97693' 09/09/2025 09:37:44 am >> DELETE FROM ps_document_detail WHERE id_document = '97693' 09/09/2025 09:37:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 09/09/2025 09:37:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 09/09/2025 09:37:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '22352' , 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K' , '10' , '-10' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '14.00' ) 09/09/2025 09:37:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 09/09/2025 09:37:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 09/09/2025 09:37:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 09/09/2025 09:38:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2736' AND id_document != '98451' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 09/09/2025 09:38:10 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2736', document_date = '2025-08-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '460.00', price_tax_excluded = '377.05', date_upd = NOW() WHERE id_document = '98451' 09/09/2025 09:38: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 = '98451' 09/09/2025 09:38:11 am >> DELETE FROM ps_document_detail WHERE id_document = '98451' 09/09/2025 09:38: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 ( '98451' , '23162' , 'SERVIZIO MESSA - 5837' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 09/09/2025 09:38: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 ( '98451' , '19351' , 'SERVIZIO MESSA MISTO LINO - 7050' , '1' , '-1' , '1' , '52.0000' , '42.622950819672' , '22' , '0' , '52.00' ) 09/09/2025 09:38: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 ( '98451' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '51.1000' , '41.885245901639' , '22' , '0' , '51.10' ) 09/09/2025 09:38: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 ( '98451' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '157' , '128.68852459016' , '22' , '0' , '157.00' ) 09/09/2025 09:38: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 ( '98451' , '22464' , 'CASULA LEGGERA - 1212' , '2' , '-2' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '150.00' ) 09/09/2025 09:38:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2499' AND id_document != '98159' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-18') 09/09/2025 09:38:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2499', document_date = '2025-07-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '245.00', price_tax_excluded = '200.82', date_upd = NOW() WHERE id_document = '98159' 09/09/2025 09:38:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98159' 09/09/2025 09:38:37 am >> DELETE FROM ps_document_detail WHERE id_document = '98159' 09/09/2025 09:38:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98159' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '245' , '200.81967213115' , '22' , '0' , '245.00' ) 09/09/2025 09:39:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2100' AND id_document != '97679' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-12') 09/09/2025 09:39:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2100', document_date = '2025-06-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 = '2.90', price_tax_excluded = '2.38', date_upd = NOW() WHERE id_document = '97679' 09/09/2025 09:39:11 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 = '97679' 09/09/2025 09:39:11 am >> DELETE FROM ps_document_detail WHERE id_document = '97679' 09/09/2025 09:39: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 ( '97679' , '13364' , 'CORONA MM 6 ' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 09/09/2025 09:41:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2092' AND id_document != '97665' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-11') 09/09/2025 09:41:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2092', document_date = '2025-06-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 = '11.60', price_tax_excluded = '9.51', date_upd = NOW() WHERE id_document = '97665' 09/09/2025 09:41:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97665' 09/09/2025 09:41:48 am >> DELETE FROM ps_document_detail WHERE id_document = '97665' 09/09/2025 09:41:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97665' , '19362' , 'LUMINO DIAMANTE VARI COLORI' , '3' , '-3' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '1.50' ) 09/09/2025 09:41:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97665' , '16061' , 'MEDAGLIA S. RITA- FM022' , '4' , '-4' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '1.20' ) 09/09/2025 09:41:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97665' , '6331' , 'MEDAGLIA OVALE DECORATA - MIRACOLOSA - G011.3' , '2' , '-2' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '1.60' ) 09/09/2025 09:41:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97665' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 09/09/2025 09:41:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97665' , '6336' , 'MEDAGLIA OVALE DECORATA - S.RITA - G291-D' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 09/09/2025 09:41:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97665' , '18276' , 'CINGOLO CON NODI - 3280' , '2' , '-2' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '5.00' ) 09/09/2025 09:42:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2647' AND id_document != '98345' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-04') 09/09/2025 09:42:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2647', document_date = '2025-08-04', 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 = '14.00', price_tax_excluded = '11.48', date_upd = NOW() WHERE id_document = '98345' 09/09/2025 09:42:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98345' 09/09/2025 09:42:35 am >> DELETE FROM ps_document_detail WHERE id_document = '98345' 09/09/2025 09:42:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98345' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 09/09/2025 09:42:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98345' , '20547' , 'MEDAGLIA LOURDES - OV22/L' , '7' , '-7' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.75' ) 09/09/2025 09:42:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98345' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '6' , '-6' , '1' , '0.7500' , '0.61475409836066' , '22' , '0' , '4.50' ) 09/09/2025 09:42:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98345' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '3' , '-3' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.75' ) 09/09/2025 09:43:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2524' AND id_document != '98192' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-22') 09/09/2025 09:43:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2524', document_date = '2025-07-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 = '49.30', price_tax_excluded = '49.30', date_upd = NOW() WHERE id_document = '98192' 09/09/2025 09:43:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98192' 09/09/2025 09:43:01 am >> DELETE FROM ps_document_detail WHERE id_document = '98192' 09/09/2025 09:43:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98192' , '21541' , 'OMELIE SUI SANTI - A. COMASTRI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 09/09/2025 09:43:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98192' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '11.4' , '11.4' , '0' , '0' , '11.40' ) 09/09/2025 09:43:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98192' , '23856' , 'SANTI DEL MESSALINO - SILVIO DISSEGNA - 8897' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 09/09/2025 09:43:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98192' , '20896' , 'SANTI DEL MESSALINO. MONICA LA VITA 8467' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 09/09/2025 09:43:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98192' , '23855' , 'SANTI DEL MESSALINO - GIANNA BERETTA MOLLA - 8277' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 09/09/2025 09:43:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98192' , '22986' , 'GIOVANNI DI DIO - 8692' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 09/09/2025 09:43:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98192' , '9490' , 'SAN NICOLA - A. DURSO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 09/09/2025 09:43:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98192' , '9532' , 'SANTALFONSO MARIA DE LIGUORI - E. MARCELLI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 09/09/2025 09:44:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2334' AND id_document != '97952' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 09/09/2025 09:44:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2334', document_date = '2025-07-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.70', price_tax_excluded = '11.49', date_upd = NOW() WHERE id_document = '97952' 09/09/2025 09:44:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97952' 09/09/2025 09:44:35 am >> DELETE FROM ps_document_detail WHERE id_document = '97952' 09/09/2025 09:44:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 09/09/2025 09:44:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 09/09/2025 09:44:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '4406' , 'GESÙ CONFIDO IN TE - ARS 70' , '10' , '-10' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '1.50' ) 09/09/2025 09:44:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '7481' , 'PAPA FRANCESCO' , '2' , '-2' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.40' ) 09/09/2025 09:44:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '20969' , 'MEDAGLIA ADDOLORATA' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 09/09/2025 09:44:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 09/09/2025 09:44:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '5538' , 'LACCIO MARRONE' , '1' , '-1' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.05' ) 09/09/2025 09:44:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2414' AND id_document != '98052' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-10') 09/09/2025 09:44:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2414', document_date = '2025-07-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 = '11.00', price_tax_excluded = '11.00', date_upd = NOW() WHERE id_document = '98052' 09/09/2025 09:44:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98052' 09/09/2025 09:44:56 am >> DELETE FROM ps_document_detail WHERE id_document = '98052' 09/09/2025 09:44: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 ( '98052' , '9556' , 'SANTA ELISABETTA DELLA TRINITÀ - G. PESENTI' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 09/09/2025 09:44: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 ( '98052' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 09/09/2025 09:44: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 ( '98052' , '9513' , 'SAN SIMONE APOSTOLO - F. INNOCENTE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 09/09/2025 09:45:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2316' AND id_document != '97932' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 09/09/2025 09:45:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2316', document_date = '2025-07-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '57.00', price_tax_excluded = '57.00', date_upd = NOW() WHERE id_document = '97932' 09/09/2025 09:45:51 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 = '97932' 09/09/2025 09:45:51 am >> DELETE FROM ps_document_detail WHERE id_document = '97932' 09/09/2025 09:45:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97932' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '5' , '19.00' ) 09/09/2025 09:45:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97932' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '38' , '38' , '0' , '0' , '38.00' ) 09/09/2025 09:58:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2912' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 09:58: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' , '2912' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 09/09/2025 09:58: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 = '98664' 09/09/2025 09:58:33 am >> DELETE FROM ps_document_detail WHERE id_document = '98664' 09/09/2025 09:58: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 ( '98664' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/09/2025 10:08:09 am >> SELECT document_num FROM ps_document WHERE document_num = '22/L' AND id_document != '98480' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-01') 09/09/2025 10:08:09 am >> UPDATE ps_document SET id_document_type = '23', document_num = '22/L', document_date = '2025-09-01', document_letter = 'L', id_customer = '4226', id_supplier = '', id_address = '4679523', address1 = 'P. ZZA SAN ROCCO 84088 SIANO', 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 = '1209.60', price_tax_excluded = '991.48', date_upd = NOW() WHERE id_document = '98480' 09/09/2025 10:08: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 = '98480' 09/09/2025 10:08:09 am >> DELETE FROM ps_document_detail WHERE id_document = '98480' 09/09/2025 10:08: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 ( '98480' , '23897' , 'QUADRETTO CON FIOCCO S. ROCCO - 12/39-C' , '25' , '-25' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '82.50' ) 09/09/2025 10:08: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 ( '98480' , '23898' , 'QUADRETTO CON FIOCCO S. ROCCO - 12/39-R' , '24' , '-24' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '79.20' ) 09/09/2025 10:08: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 ( '98480' , '23903' , 'BRACCIALE CON MEDAGLIA SAN ROCCO - 800/W2158-RH' , '12' , '-12' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '36.00' ) 09/09/2025 10:08: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 ( '98480' , '23902' , 'BRACCIALE SAN ROCCO - 800/CA4' , '36' , '-36' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '108.00' ) 09/09/2025 10:08: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 ( '98480' , '23895' , 'PORTACHIAVI SAN ROCCO - 100/6569P' , '183' , '-183' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '256.20' ) 09/09/2025 10:08: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 ( '98480' , '22653' , 'GIROCOLLO PERSONALIZZATO SAN ROCCO' , '48' , '-48' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '144.00' ) 09/09/2025 10:08: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 ( '98480' , '23901' , 'MEDAGLIA SAN ROCCO SMALTATA - 400/6573M' , '200' , '-200' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '80.00' ) 09/09/2025 10:08: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 ( '98480' , '23896' , 'MAGNETE SAN ROCCO - 1181-0' , '109' , '-109' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '141.70' ) 09/09/2025 10:08: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 ( '98480' , '23899' , 'ROSARIO SAN ROCCO - 163/8' , '36' , '-36' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '162.00' ) 09/09/2025 10:08: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 ( '98480' , '23900' , 'BRACCIALE 1/2 CRISTALLO - 20/6-B' , '48' , '-48' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '120.00' ) 09/09/2025 10:09:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2587' AND id_document != '98264' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-28') 09/09/2025 10:09:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2587', document_date = '2025-07-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.20', price_tax_excluded = '21.48', date_upd = NOW() WHERE id_document = '98264' 09/09/2025 10:09:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98264' 09/09/2025 10:09:19 am >> DELETE FROM ps_document_detail WHERE id_document = '98264' 09/09/2025 10:09:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98264' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 09/09/2025 10:09:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98264' , '23091' , 'PORTAFOTO CON COFANETTO' , '2' , '-2' , '1' , '12.5' , '10.245901639344' , '22' , '0' , '25.00' ) 09/09/2025 10:09:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2329' AND id_document != '97945' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 09/09/2025 10:09:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2329', document_date = '2025-07-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '31.00', price_tax_excluded = '25.41', date_upd = NOW() WHERE id_document = '97945' 09/09/2025 10:09:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97945' 09/09/2025 10:09:48 am >> DELETE FROM ps_document_detail WHERE id_document = '97945' 09/09/2025 10:09:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 09/09/2025 10:09:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 09/09/2025 10:09:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 09/09/2025 10:09:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 09/09/2025 10:09:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '23091' , 'PORTAFOTO CON COFANETTO' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 09/09/2025 10:11:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2114' AND id_document != '97693' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-13') 09/09/2025 10:11:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2114', document_date = '2025-06-13', 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 = '159.00', price_tax_excluded = '132.95', date_upd = NOW() WHERE id_document = '97693' 09/09/2025 10:11:36 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 = '97693' 09/09/2025 10:11:36 am >> DELETE FROM ps_document_detail WHERE id_document = '97693' 09/09/2025 10:11:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 09/09/2025 10:11:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 09/09/2025 10:11:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '22352' , 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K' , '10' , '-10' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '14.00' ) 09/09/2025 10:11:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 09/09/2025 10:11:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '23610' , 'LUMETTO 17X17 - RL' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 09/09/2025 10:11:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 09/09/2025 10:13:24 am >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '97771' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-06-19') 09/09/2025 10:13:24 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18', document_date = '2025-06-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P.ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = 'RESA', 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 = '1221.30', price_tax_excluded = '1221.30', date_upd = NOW() WHERE id_document = '97771' 09/09/2025 10:13:24 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 = '97771' 09/09/2025 10:13:24 am >> DELETE FROM ps_document_detail WHERE id_document = '97771' 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '4' , '-4' , '4' , '16.0000' , '16' , '0' , '0' , '64.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23517' , 'PROCLAMERO LANNO DI GRAZIA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23143' , 'CATECHISTI DI SPERANZA - F. VANNOTTI' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23208' , 'SPERANZA NELLA TRADIZIONE EBRAICA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23211' , 'VIVERE IL GIUBILEO - E. FORTUNATO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23361' , 'PERCORSI DEL GIUBILEO - L. FERRAIUOLO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22171' , 'AMORE DI DIO E PER TUTTI - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23012' , 'COME GESU CI HA INSEGNATO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23145' , 'SEI GRANDE! - PAPA FRANCESCO' , '2' , '-2' , '4' , '14.0000' , '14' , '0' , '0' , '28.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22766' , 'CONNESSI COL CIELO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23307' , 'AVETE FATTO A ME - E. BOLIS' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22172' , 'NEL GREMBO DELLA PAROLA - R. MANGOLINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23132' , 'RINASCERE - E. BIANCHI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 09/09/2025 10:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23483' , 'INDAGINE SULLA MORTE DI GESU - S. LEONE' , '3' , '-3' , '4' , '18.0000' , '18' , '0' , '0' , '54.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22401' , 'CHRISTIAN DE CHERGE - C. SALENSON' , '1' , '-1' , '4' , '32.0000' , '32' , '0' , '0' , '32.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20476' , 'NON GUARDARE AI NOSTRI PECCATI - B.P. FLANAGAN' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20727' , 'RINNOVAMENTO E UNITA - K. KOCH' , '1' , '-1' , '4' , '32.0000' , '32' , '0' , '0' , '32.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20873' , 'SILENZIO DI DIO - M. STRIET' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20927' , 'FEDE SENZA VERITA - M. SEEWALD' , '1' , '-1' , '4' , '33.0000' , '33' , '0' , '0' , '33.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22180' , 'LASCIATE CHE CRESCANO INSIEME - A. ANGENENDT' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '0' , '39.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20772' , 'VADO E TORNERO DA VOI - L. VOZZA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20871' , 'NELLA STORIA ACCOMPAGNATI DA MARIA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '0' , '12.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23514' , 'TU SEI LA LUCE - A. COMASTRI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23457' , 'QUARESIMA 2025 GIORNO PER GIORNO' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '0' , '24.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23357' , 'QUARESIMA 2025 - ALLE SORGENTI DELLA SPERANZA' , '7' , '-7' , '4' , '3.6000' , '3.6' , '0' , '0' , '25.20' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22139' , 'TRAFITTI PER AMORE - SEREGNI/DI STEFANO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23356' , 'PAROLA E PREGHIERA - MAR 25' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23452' , 'TUTTO RICOMINCIA ' , '2' , '-2' , '4' , '2.8000' , '2.8' , '0' , '0' , '5.60' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23359' , 'SUSSIDIO DI QUARESIMA E PASQUA 2025' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23453' , 'COLPO DI SCENA' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '0' , '17.50' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22136' , 'PER DI QUA - BASTIA/RIMINITTI' , '2' , '-2' , '4' , '6.5000' , '6.5' , '0' , '0' , '13.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '1' , '-1' , '4' , '1.2000' , '1.2' , '0' , '0' , '1.20' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23358' , 'MIO FIGLIO E TORNATO' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '0' , '3.80' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22687' , 'DARANNO ANCORA FRUTTI - AAVV' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '19544' , 'SENTIERI DI SINODALITA' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '21172' , 'CAMMINARE INSIEME - L. FALLICA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '18688' , 'GLI ULTIMI CENTO GIORNI DI GESU - A. GINOTTA' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23657' , 'DENTRO I VELI - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22228' , 'PAROLA MI RACCONTA - P. CURTAZ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23221' , 'CHE BELLA STORIA QUELLA DI GESU - P. VILLANUEVA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23438' , 'ANTIQUA ET NOVA' , '20' , '-20' , '4' , '2.0000' , '2' , '0' , '0' , '40.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23165' , 'DILEXIT NOS' , '20' , '-20' , '4' , '2.2000' , '2.2' , '0' , '0' , '44.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22873' , 'COME ESSERE CHIESA SINODALE MISSIONARIA' , '9' , '-9' , '4' , '3.5000' , '3.5' , '0' , '0' , '31.50' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23169' , 'DILEXIT NOS ' , '19' , '-19' , '4' , '2.2000' , '2.2' , '0' , '0' , '41.80' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23441' , 'ANTIQUA ET NOVA' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '0' , '7.80' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22506' , 'DIGNITAS INFINITA' , '4' , '-4' , '4' , '2.5000' , '2.5' , '0' , '0' , '10.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '9011' , 'RITO DEL MATRIMONIO - RP29 - CONF 25 PZ' , '3' , '-3' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22351' , 'AMORE CELIBE - A. FUMAGALLI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22758' , 'PICCOLO LESSICO DEL FINE VITA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 09/09/2025 10:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '1731' , 'CARO AMICO SANTO TI SCRIVO ...' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 09/09/2025 10:13: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 ( '97771' , '22719' , '101 PENSIERI SU DIO - D. BONHOEFFER' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 09/09/2025 10:13: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 ( '97771' , '21924' , '101 PENSIERI PER RESISTERE ALLODIO - E. HILLESUM' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 09/09/2025 10:13: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 ( '97771' , '22227' , 'MALE NEGLI OCCHI DELLAMORE - G. BORGHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 09/09/2025 10:13: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 ( '97771' , '11412' , 'VITA AUTENTICA DEL CURATO DARS - CURATO DARS' , '1' , '-1' , '4' , '24.0000' , '24' , '0' , '0' , '24.00' ) 09/09/2025 10:13: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 ( '97771' , '20728' , 'OCCHI CHE SI APRONO' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '0' , '12.00' ) 09/09/2025 10:13: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 ( '97771' , '23493' , 'PAROLA E PREGHIERA - MAG 25' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 09/09/2025 10:13: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 ( '97771' , '23516' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 25' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 09/09/2025 10:13: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 ( '97771' , '21502' , 'SALMI PER PICCOLI CUORI' , '2' , '-2' , '4' , '4.9000' , '4.9' , '0' , '0' , '9.80' ) 09/09/2025 10:13: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 ( '97771' , '13409' , 'MESSIA - LA MERAVIGLIOSA STORIA DI PASQUA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 09/09/2025 10:13: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 ( '97771' , '19540' , 'CRESIMA N.E.' , '4' , '-4' , '4' , '3.0000' , '3' , '0' , '0' , '12.00' ) 09/09/2025 10:13: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 ( '97771' , '19538' , 'MESSA DEI FANCIULLI - N.E.' , '5' , '-5' , '4' , '2.0000' , '2' , '0' , '0' , '10.00' ) 09/09/2025 10:13: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 ( '97771' , '12053' , 'MIA CRESIMA CON PAPA FRANCESCO' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '0' , '15.00' ) 09/09/2025 10:13: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 ( '97771' , '22450' , 'DIO E SEMPRE CON NOI' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 09/09/2025 10:13: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 ( '97771' , '19157' , 'GUASTI' , '1' , '-1' , '4' , '0.0000' , '0' , '0' , '0' , '0.00' ) 09/09/2025 10:13: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 ( '97771' , '20778' , 'PASSIO N.E.' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 09/09/2025 10:13: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 ( '97771' , '22149' , 'LEZIONARIO FERIALE TEMPI FORTI - N.E.' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 09/09/2025 10:13: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 ( '97771' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '11' , '-11' , '4' , '2.0000' , '2' , '0' , '0' , '22.00' ) 09/09/2025 10:18:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2913' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 10:18: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' , '2913' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 09/09/2025 10:18: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 = '98665' 09/09/2025 10:18:13 am >> DELETE FROM ps_document_detail WHERE id_document = '98665' 09/09/2025 10:18: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 ( '98665' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 09/09/2025 10:53:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2914' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 10:53:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2914' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 09/09/2025 10:53:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98666' 09/09/2025 10:53:48 am >> DELETE FROM ps_document_detail WHERE id_document = '98666' 09/09/2025 10:53:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98666' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 09/09/2025 10:53:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98666' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 09/09/2025 11:06:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2915' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 11:06:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2915' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.05' , '37.05' , NOW() , NOW() ) 09/09/2025 11:06: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 = '98667' 09/09/2025 11:06:50 am >> DELETE FROM ps_document_detail WHERE id_document = '98667' 09/09/2025 11:06: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 ( '98667' , '23976' , 'GIULLARE DI DIO - AAVV' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 09/09/2025 11:15:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2916' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 11:15:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2916' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '534.40' , '444.80' , NOW() , NOW() ) 09/09/2025 11:15:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98668' 09/09/2025 11:15:37 am >> DELETE FROM ps_document_detail WHERE id_document = '98668' 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '6.60' ) 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '3.40' ) 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '11151' , 'LIBRI - supplica' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '23984' , 'AGENDA 2026' , '4' , '-4' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '40.00' ) 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '23724' , 'PORTA TORCE IN METALLO 2 POSTI - 381' , '1' , '-1' , '1' , '153.00' , '125.40983606557' , '22' , '0' , '153.00' ) 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '23034' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X100 - 1143' , '2' , '-2' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '78.00' ) 09/09/2025 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98668' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '100.00' ) 09/09/2025 11:35:22 am >> SELECT document_num FROM ps_document WHERE document_num = '38/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 11:35: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 ( '23' , '38/E' , '2025-09-09' , 'E' , '2938' , '0' , '4678844' , 'VIA ARCIVESCOVATO 31 55100 LUCCA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '376.00' , '374.20' , NOW() , NOW() ) 09/09/2025 11:35: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 = '98669' 09/09/2025 11:35:22 am >> DELETE FROM ps_document_detail WHERE id_document = '98669' 09/09/2025 11:35: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 ( '98669' , '23870' , 'RAGAZZO DEL LENZUOLO - M. VIANI' , '50' , '-50' , '4' , '10.00' , '10' , '0' , '40' , '300.00' ) 09/09/2025 11:35: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 ( '98669' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '11' , '-11' , '4' , '10.00' , '10' , '0' , '40' , '66.00' ) 09/09/2025 11:35: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 ( '98669' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 09/09/2025 11:41:55 am >> SELECT document_num FROM ps_document WHERE document_num = '38/E' AND id_document != '98669' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 11:41:55 am >> UPDATE ps_document SET id_document_type = '23', document_num = '38/E', document_date = '2025-09-09', document_letter = 'E', id_customer = '2938', id_supplier = '', id_address = '4678844', address1 = 'VIA ARCIVESCOVATO 31 55100 LUCCA', 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 = '376.00', price_tax_excluded = '376.00', date_upd = NOW() WHERE id_document = '98669' 09/09/2025 11: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 = '98669' 09/09/2025 11:41:55 am >> DELETE FROM ps_document_detail WHERE id_document = '98669' 09/09/2025 11: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 ( '98669' , '23870' , 'RAGAZZO DEL LENZUOLO - M. VIANI' , '50' , '-50' , '4' , '10.0000' , '10' , '0' , '40' , '300.00' ) 09/09/2025 11: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 ( '98669' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '11' , '-11' , '4' , '10.0000' , '10' , '0' , '40' , '66.00' ) 09/09/2025 11: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 ( '98669' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 09/09/2025 11:57:33 am >> SELECT document_num FROM ps_document WHERE document_num = '36/E' AND id_document != '98658' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-08') 09/09/2025 11:57:33 am >> UPDATE ps_document SET id_document_type = '23', document_num = '36/E', document_date = '2025-09-08', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '884.45', price_tax_excluded = '881.20', date_upd = NOW() WHERE id_document = '98658' 09/09/2025 11:57: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 = '98658' 09/09/2025 11:57:33 am >> DELETE FROM ps_document_detail WHERE id_document = '98658' 09/09/2025 11:57: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 ( '98658' , '20460' , 'AVE MARIA SPIEGATA AI BAMBINI' , '14' , '-14' , '4' , '1.8000' , '1.8' , '0' , '50' , '12.60' ) 09/09/2025 11:57: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 ( '98658' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '4' , '-4' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 09/09/2025 11:57: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 ( '98658' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 09/09/2025 11:57: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 ( '98658' , '18357' , 'MIE PREGHIERINE N.E.' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 09/09/2025 11:57: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 ( '98658' , '14330' , '100 GIORNI CON LO SPIRITO' , '3' , '-3' , '4' , '7.5000' , '7.5' , '0' , '50' , '11.25' ) 09/09/2025 11:57: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 ( '98658' , '2866' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '50' , '4.95' ) 09/09/2025 11:57: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 ( '98658' , '15318' , 'PERDONAMI SIGNORE ' , '3' , '-3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 09/09/2025 11:57: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 ( '98658' , '15602' , 'AMICO GESU ALBUM' , '51' , '-51' , '4' , '2.0000' , '2' , '0' , '50' , '51.00' ) 09/09/2025 11:57: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 ( '98658' , '475' , 'AMICO GESÙ - FIGURINE' , '5' , '-5' , '4' , '30.0000' , '30' , '0' , '50' , '75.00' ) 09/09/2025 11:57: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 ( '98658' , '16094' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS' , '3' , '-3' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 09/09/2025 11:57: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 ( '98658' , '15317' , 'SACRAMENTI SPIEGATI AI RAGAZZI - LA COMUNIONE' , '3' , '-3' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 09/09/2025 11:57: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 ( '98658' , '15743' , 'PREGHIERA DEL ROSARIO' , '14' , '-14' , '4' , '2.5000' , '2.5' , '0' , '50' , '17.50' ) 09/09/2025 11:57: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 ( '98658' , '15742' , 'AVE MARIA - PREGHIERE MARIANE' , '3' , '-3' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 09/09/2025 11:57: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 ( '98658' , '15744' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 09/09/2025 11:57: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 ( '98658' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '29' , '-29' , '4' , '2.5000' , '2.5' , '0' , '50' , '36.25' ) 09/09/2025 11:57: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 ( '98658' , '13840' , 'NONNI SONO UN TESORO' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '50' , '0.90' ) 09/09/2025 11:57: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 ( '98658' , '14143' , 'SAN FRANCESCO DASSISI - RACCONTATO AI RAGAZZI' , '34' , '-34' , '4' , '4.0000' , '4' , '0' , '50' , '68.00' ) 09/09/2025 11:57: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 ( '98658' , '23985' , 'DIZIONARIO DE SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 09/09/2025 11:57: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 ( '98658' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 09/09/2025 11:57: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 ( '98658' , '21701' , 'NASCITA DI GESU' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 09/09/2025 11:57: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 ( '98658' , '17034' , 'SACRAMENTO DEL PERDONO' , '3' , '-3' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 09/09/2025 11:57: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 ( '98658' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '50' , '1.40' ) 09/09/2025 11:57: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 ( '98658' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '50' , '1.40' ) 09/09/2025 11:57: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 ( '98658' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '50' , '1.40' ) 09/09/2025 11:57: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 ( '98658' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '50' , '1.70' ) 09/09/2025 11:57: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 ( '98658' , '6629' , 'MIA PREGHIERA' , '2' , '-2' , '4' , '0.9000' , '0.9' , '0' , '50' , '0.90' ) 09/09/2025 11:57: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 ( '98658' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '3' , '-3' , '4' , '8.5000' , '8.5' , '0' , '50' , '12.75' ) 09/09/2025 11:57: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 ( '98658' , '12819' , 'REGISTRO DEL CATECHISTA ' , '36' , '-36' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '18.00' ) 09/09/2025 11:57: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 ( '98658' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 09/09/2025 11:57: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 ( '98658' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '7' , '-7' , '4' , '6.0000' , '6' , '0' , '50' , '21.00' ) 09/09/2025 11:57: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 ( '98658' , '14032' , 'AVE MARIA' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 09/09/2025 11:57: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 ( '98658' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '5' , '-5' , '4' , '1.0000' , '1' , '0' , '50' , '2.50' ) 09/09/2025 11:57: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 ( '98658' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 09/09/2025 11:57: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 ( '98658' , '15019' , 'PREGHIAMO CON MARIA' , '5' , '-5' , '4' , '0.8000' , '0.8' , '0' , '50' , '2.00' ) 09/09/2025 11:57: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 ( '98658' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '50' , '0.50' ) 09/09/2025 11:57: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 ( '98658' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 09/09/2025 11:57: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 ( '98658' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '3' , '-3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 09/09/2025 11:57: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 ( '98658' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '2' , '-2' , '4' , '15.0000' , '15' , '0' , '50' , '15.00' ) 09/09/2025 11:57: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 ( '98658' , '17257' , 'IO TI BATTEZZO ' , '5' , '-5' , '4' , '1.8000' , '1.8' , '0' , '50' , '4.50' ) 09/09/2025 11:57: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 ( '98658' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '50' , '1.90' ) 09/09/2025 11:57: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 ( '98658' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '3' , '-3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '1' , '-1' , '4' , '4.8000' , '4.8' , '0' , '50' , '2.40' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '12' , '-12' , '4' , '1.9000' , '1.9' , '0' , '50' , '11.40' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '11' , '-11' , '4' , '7.0000' , '7' , '0' , '50' , '38.50' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '4' , '-4' , '4' , '2.0000' , '2' , '0' , '50' , '4.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '3' , '-3' , '4' , '12.0000' , '12' , '0' , '50' , '18.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '5' , '-5' , '4' , '4.5000' , '4.5' , '0' , '50' , '11.25' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '6' , '-6' , '4' , '3.0000' , '3' , '0' , '50' , '9.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '50' , '12.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '10' , '-10' , '4' , '2.8000' , '2.8' , '0' , '50' , '14.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '4' , '-4' , '4' , '2.8000' , '2.8' , '0' , '50' , '5.60' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '22152' , 'A TE RICORRIAMO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23092' , 'SPERANZA CHE E IN NOI' , '5' , '-5' , '4' , '3.0000' , '3' , '0' , '50' , '7.50' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '6' , '-6' , '4' , '3.0000' , '3' , '0' , '50' , '9.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23347' , 'PREGHIERA DEL ROSARIO' , '31' , '-31' , '4' , '2.5000' , '2.5' , '0' , '50' , '38.75' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '22809' , 'O LUCE BEATISSIMA' , '13' , '-13' , '4' , '2.5000' , '2.5' , '0' , '50' , '16.25' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '13' , '-13' , '4' , '2.8000' , '2.8' , '0' , '50' , '18.20' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '12' , '-12' , '4' , '3.0000' , '3' , '0' , '50' , '18.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23380' , 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA' , '4' , '-4' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '7' , '-7' , '4' , '3.0000' , '3' , '0' , '50' , '10.50' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23677' , 'RICETTE DI MAMMA ROSA' , '4' , '-4' , '4' , '20.0000' , '20' , '0' , '50' , '40.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '8' , '-8' , '4' , '5.0000' , '5' , '0' , '50' , '20.00' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23673' , 'RIVESTITI DI SPERANZA! - V. SIRACUSA' , '61' , '-61' , '4' , '5.0000' , '5' , '0' , '50' , '152.50' ) 09/09/2025 11:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98658' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 09/09/2025 12:02:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2917' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 12:02: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' , '2917' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 09/09/2025 12:02: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 = '98670' 09/09/2025 12:02:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '98670' 09/09/2025 12:02: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 ( '98670' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '0' , '35.00' ) 09/09/2025 12:15:23 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'LUEI8s2JyiqJwXC0' , NOW() , NOW() ) 09/09/2025 12:15:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4230' , '1' ) 09/09/2025 12:15:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4230' , '2' ) 09/09/2025 12:15:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4230' , '3' ) 09/09/2025 12:17:26 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4230' 09/09/2025 12:17:26 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4230' , '10' , '' , 'DICASTERO PER L\'EVANGELIZZAZIONE - II SEZIONE' , '' , '' , 'P. ZZA DI SPAGNA 48' , '' , '00120' , 'CITTA DEL VATICANO' , '' , '' , '' , '' , '80196770582' , NOW() , NOW() ) 09/09/2025 12:17:26 pm >> UPDATE ps_customer SET email = '', sdi = '0000000', pec = '', date_upd = NOW() WHERE id_customer = '4230' 09/09/2025 12:25:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 12:25: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 ( '26' , '2' , '2025-09-09' , '' , '4230' , '0' , '4679527' , 'P. ZZA DI SPAGNA 48 00120 CITTA DEL VATICANO' , '' , 'tempi di consegna circa 30 giorni dalla conferma dell\'ordine' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '2813.20' , '2813.20' , NOW() , NOW() ) 09/09/2025 12:25: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 = '98671' 09/09/2025 12:25:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '98671' 09/09/2025 12:25: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 ( '98671' , '' , 'STOLA VERDE' , '33' , '0' , '0' , '27.05' , '27.05' , '' , '0' , '892.65' ) 09/09/2025 12:25: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 ( '98671' , '' , 'STOLA VIOLA' , '17' , '0' , '0' , '27.05' , '27.05' , '' , '0' , '459.85' ) 09/09/2025 12:25: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 ( '98671' , '' , 'STOLA BIANCA' , '22' , '0' , '0' , '27.05' , '27.05' , '' , '0' , '595.10' ) 09/09/2025 12:25: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 ( '98671' , '' , 'STOLA ROSSA' , '32' , '0' , '0' , '27.05' , '27.05' , '' , '0' , '865.60' ) 09/09/2025 12:25: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 ( '98671' , '' , 'non imp. ai fini iva ai sens. art. 71 DPR n. 633/1972' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 09/09/2025 12:51:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2918' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 12:51:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2918' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '27.86' , NOW() , NOW() ) 09/09/2025 12:51: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 = '98672' 09/09/2025 12:51:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '98672' 09/09/2025 12:51: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 ( '98672' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 09/09/2025 12:51: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 ( '98672' , '14143' , 'SAN FRANCESCO DASSISI - RACCONTATO AI RAGAZZI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 09/09/2025 12:51: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 ( '98672' , '23979' , 'AGENDA DEL CATECHISTA 25/26' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 09/09/2025 12:51: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 ( '98672' , '22432' , 'IN SINU JESU' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 09/09/2025 12:51: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 ( '98672' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 09/09/2025 12:53:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2919' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 12:53:28 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' , '2919' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.50' , '15.16' , NOW() , NOW() ) 09/09/2025 12:53: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 = '98673' 09/09/2025 12:53:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '98673' 09/09/2025 12:53: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 ( '98673' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 09/09/2025 12:53: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 ( '98673' , '18354' , 'PORTA ROSARIO IN VELLUTO GRANDE - 314- NT 4' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 09/09/2025 12:53: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 ( '98673' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 09/09/2025 02:28: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 ( '31' , '1/319' , '2025-09-08' , '319' , '0' , '71' , '2666' , 'VIA DEL SOLE, 6/A 40128 BOLOGNA' , '' , '' , '16' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '516.06' , '423.00' , NOW() , NOW() ) 09/09/2025 02:28: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 = '98674' 09/09/2025 02:28:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '98674' 09/09/2025 02:28: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 ( '98674' , '22674' , 'BORSELLO CELEBRAZIONEPELLE - B2-01' , '2' , '2' , '1' , '129' , '105.73770491803' , '22' , '0' , '314.7600' ) 09/09/2025 02:28:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22674' AND id_supplier = '71' 09/09/2025 02:28:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22674' , '71' , '1' ) 09/09/2025 02:28: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 ( '98674' , '22673' , 'PORTA TECA PELLE E TECA' , '10' , '10' , '1' , '14.9' , '12.213114754098' , '22' , '0' , '181.7800' ) 09/09/2025 02:28:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22673' AND id_supplier = '71' 09/09/2025 02:28:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22673' , '71' , '1' ) 09/09/2025 02:41:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '98671' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 02:41:22 pm >> UPDATE ps_document SET id_document_type = '26', document_num = '2', document_date = '2025-09-09', document_letter = '', id_customer = '4230', id_supplier = '', id_address = '4679527', address1 = 'P. ZZA DI SPAGNA 48 00120 CITTA DEL VATICANO', address2 = '', note = 'tempi di consegna circa 30 giorni dalla conferma dell\'ordine', 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 = '2813.20', price_tax_excluded = '2813.20', date_upd = NOW() WHERE id_document = '98671' 09/09/2025 02:41: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 = '98671' 09/09/2025 02:41:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '98671' 09/09/2025 02:41: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 ( '98671' , '0' , 'STOLA VERDE' , '33' , '0' , '0' , '27.0500' , '27.05' , '' , '0' , '892.65' ) 09/09/2025 02:41: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 ( '98671' , '0' , 'STOLA VIOLA' , '17' , '0' , '0' , '27.0500' , '27.05' , '' , '0' , '459.85' ) 09/09/2025 02:41: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 ( '98671' , '0' , 'STOLA BIANCA' , '22' , '0' , '0' , '27.0500' , '27.05' , '' , '0' , '595.10' ) 09/09/2025 02:41: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 ( '98671' , '0' , 'STOLA ROSSA' , '32' , '0' , '0' , '27.0500' , '27.05' , '' , '0' , '865.60' ) 09/09/2025 02:41: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 ( '98671' , '0' , 'non imp. ai fini iva ai sens. art. 71 DPR n. 633/1972' , '0' , '0' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 09/09/2025 02:41:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '98671' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 02:41:59 pm >> UPDATE ps_document SET id_document_type = '26', document_num = '2', document_date = '2025-09-09', document_letter = '', id_customer = '4230', id_supplier = '', id_address = '4679527', address1 = 'P. ZZA DI SPAGNA 48 00120 CITTA DEL VATICANO', address2 = '', note = 'tempi di consegna circa 30 giorni dalla conferma dell\'ordine', 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 = '2813.20', price_tax_excluded = '2813.20', date_upd = NOW() WHERE id_document = '98671' 09/09/2025 02:41:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98671' 09/09/2025 02:41:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '98671' 09/09/2025 02:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98671' , '0' , 'STOLA VERDE' , '33' , '0' , '0' , '27.0500' , '27.05' , '' , '0' , '892.65' ) 09/09/2025 02:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98671' , '0' , 'STOLA VIOLA' , '17' , '0' , '0' , '27.0500' , '27.05' , '0' , '0' , '459.85' ) 09/09/2025 02:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98671' , '0' , 'STOLA BIANCA' , '22' , '0' , '0' , '27.0500' , '27.05' , '0' , '0' , '595.10' ) 09/09/2025 02:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98671' , '0' , 'STOLA ROSSA' , '32' , '0' , '0' , '27.0500' , '27.05' , '0' , '0' , '865.60' ) 09/09/2025 02:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98671' , '0' , 'non imp. ai fini iva ai sens. art. 71 DPR n. 633/1972' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 09/09/2025 03:04:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2920' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 03:04: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' , '2920' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '17.31' , NOW() , NOW() ) 09/09/2025 03:04: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 = '98675' 09/09/2025 03:04:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '98675' 09/09/2025 03:04: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 ( '98675' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '4' , '-4' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '18.00' ) 09/09/2025 03:51:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2921' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 03:51: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' , '2921' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '574.00' , '495.37' , NOW() , NOW() ) 09/09/2025 03:51: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 = '98676' 09/09/2025 03:51:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '98676' 09/09/2025 03:51: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 ( '98676' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '90' , '-90' , '1' , '3' , '2.4590163934426' , '22' , '0' , '270.00' ) 09/09/2025 03:51: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 ( '98676' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 09/09/2025 03:51: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 ( '98676' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 09/09/2025 03:51: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 ( '98676' , '23891' , 'BATTEZZATI IN SPIRITO SANTO E FUOCO - GUIDA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 09/09/2025 03:51: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 ( '98676' , '23304' , 'PREGHIERA DI GUARIGIONE - M. LA GRUA' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 09/09/2025 03:51: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 ( '98676' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 09/09/2025 03:51: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 ( '98676' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/09/2025 03:51: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 ( '98676' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 09/09/2025 03:51: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 ( '98676' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/09/2025 03:51: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 ( '98676' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 09/09/2025 03:51: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 ( '98676' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/09/2025 03:51: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 ( '98676' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 09/09/2025 03:51: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 ( '98676' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 09/09/2025 03:51: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 ( '98676' , '23775' , 'FIGLIO DELLUOMO BOCCA DI DIO - A. CANOPI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 09/09/2025 03:51: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 ( '98676' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '39.24' , '32.16393442623' , '22' , '0' , '39.24' ) 09/09/2025 04:14:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2922' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 04: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 ( '11' , '2922' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '38.70' , NOW() , NOW() ) 09/09/2025 04: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 = '98677' 09/09/2025 04:14:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '98677' 09/09/2025 04: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 ( '98677' , '23385' , 'DECINA LEGNO - FR18' , '3' , '-3' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '1.80' ) 09/09/2025 04: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 ( '98677' , '23383' , 'BRACCIALE DECINA - BD020' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 09/09/2025 04: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 ( '98677' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '42' , '34.426229508197' , '22' , '0' , '42.00' ) 09/09/2025 04: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 ( '98677' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 09/09/2025 04:18:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2923' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 04:18:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2923' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.50' , '47.95' , NOW() , NOW() ) 09/09/2025 04:18:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98678' 09/09/2025 04:18:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '98678' 09/09/2025 04:18:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98678' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 09/09/2025 04:18:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98678' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 09/09/2025 04:18:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98678' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 09/09/2025 04:21:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2922' AND id_document != '98677' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 04:21:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2922', document_date = '2025-09-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '47.00', price_tax_excluded = '38.70', date_upd = NOW() WHERE id_document = '98677' 09/09/2025 04:21:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98677' 09/09/2025 04:21:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '98677' 09/09/2025 04:21:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98677' , '23385' , 'DECINA LEGNO - FR18' , '3' , '-3' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '1.80' ) 09/09/2025 04:21:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98677' , '23383' , 'BRACCIALE DECINA - BD020' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 09/09/2025 04:21:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98677' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 09/09/2025 04:21:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98677' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 09/09/2025 04:21:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98677' , '23609' , 'CALAMITA 8X8 ' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 09/09/2025 04:37:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '113/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 04:37:23 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' , '113/A' , '2025-09-09' , 'A' , '371' , '0' , '4679091' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1500.00' , '1475.66' , NOW() , NOW() ) 09/09/2025 04:37:23 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 = '98679' 09/09/2025 04:37:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '98679' 09/09/2025 04:37:23 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 ( '98679' , '16407' , 'ASPERGES MAXI PER SECCHIELLO - 690' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 09/09/2025 04:37:23 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 ( '98679' , '9780' , 'SECCHIELLO PER ASPERGES IN ACCIAIO - 695' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 09/09/2025 04:37:23 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 ( '98679' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '0' , '40.00' ) 09/09/2025 04:37:23 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 ( '98679' , '' , 'LEGGIO PLEX ' , '1' , '-1' , '4' , '375' , '375' , '0' , '0' , '375.00' ) 09/09/2025 04:37:23 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 ( '98679' , '' , 'CROCE ASTILE' , '1' , '-1' , '4' , '950' , '950' , '0' , '0' , '950.00' ) 09/09/2025 05:06:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2924' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 05:06:02 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' , '2924' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 09/09/2025 05:06: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 = '98680' 09/09/2025 05:06:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '98680' 09/09/2025 05:06: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 ( '98680' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 09/09/2025 05:18:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2925' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 05:18:18 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' , '2925' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.50' , '36.55' , NOW() , NOW() ) 09/09/2025 05:18: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 = '98681' 09/09/2025 05:18:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '98681' 09/09/2025 05:18: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 ( '98681' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 09/09/2025 05:18: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 ( '98681' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 09/09/2025 05:18: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 ( '98681' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 09/09/2025 05:18: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 ( '98681' , '23954' , 'SAN BARTOLO LONGO ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 09/09/2025 05:42:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2926' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 05:42:32 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' , '2926' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 09/09/2025 05:42:32 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 = '98682' 09/09/2025 05:42:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '98682' 09/09/2025 05:42:32 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 ( '98682' , '15801' , 'ARGENTO A PESO' , '2' , '-2' , '1' , '15' , '12.295081967213' , '22' , '0' , '30.00' ) 09/09/2025 05:50:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2927' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 05:50: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' , '2927' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 09/09/2025 05:50: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 = '98683' 09/09/2025 05:50:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '98683' 09/09/2025 05:50: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 ( '98683' , '9702' , 'SCAPOLARE TIPO GRANDE - 1216/ITA ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 09/09/2025 06:27:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2928' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 06:27: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' , '2928' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '181.55' , '157.21' , NOW() , NOW() ) 09/09/2025 06:27: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 = '98684' 09/09/2025 06:27:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '98684' 09/09/2025 06:27: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 ( '98684' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 09/09/2025 06:27: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 ( '98684' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '49' , '49' , '0' , '5' , '46.55' ) 09/09/2025 06:33:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2929' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 06:33:09 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' , '2929' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '8.00' , NOW() , NOW() ) 09/09/2025 06:33:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98685' 09/09/2025 06:33:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '98685' 09/09/2025 06:33:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98685' , '23807' , 'CALENDARIO LITURGICO 2026' , '10' , '-10' , '4' , '0.80' , '0.8' , '0' , '0' , '8.00' ) 09/09/2025 06:36:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2930' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 06:36:02 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' , '2930' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '9.75' , NOW() , NOW() ) 09/09/2025 06:36: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 = '98686' 09/09/2025 06:36:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '98686' 09/09/2025 06:36: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 ( '98686' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11.9' , '9.7540983606557' , '22' , '0' , '11.90' ) 09/09/2025 06:41:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2410' AND id_document != '98047' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-10') 09/09/2025 06:41:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2410', document_date = '2025-07-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 = '1135.00', price_tax_excluded = '930.33', date_upd = NOW() WHERE id_document = '98047' 09/09/2025 06:41: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 = '98047' 09/09/2025 06:41:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '98047' 09/09/2025 06:41: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 ( '98047' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.5000' , '29.918032786885' , '22' , '0' , '36.50' ) 09/09/2025 06:41: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 ( '98047' , '2177' , 'CLERGY BASIC - MM - B&P' , '2' , '-2' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '70.00' ) 09/09/2025 06:41: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 ( '98047' , '23858' , 'TALARE FRESCO LANA 100% - 88/000100' , '1' , '-1' , '1' , '930.0000' , '762.29508196721' , '22' , '0' , '930.00' ) 09/09/2025 06:41: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 ( '98047' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '' , '8.50' ) 09/09/2025 06:41: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 ( '98047' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '90.00' , '73.770491803279' , '22' , '0' , '90.00' ) 09/09/2025 07:13:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2931' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-09') 09/09/2025 07:13:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2931' , '2025-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 09/09/2025 07:13:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98687' 09/09/2025 07:13:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '98687' 09/09/2025 07:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98687' , '546' , 'AMPOLLE SU VASSOIO VETRO - 1500' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' )