01/09/2025 09:24:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2780' AND id_document != '98498' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-29') 01/09/2025 09:24:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2780', document_date = '2025-08-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.00', price_tax_excluded = '2.88', date_upd = NOW() WHERE id_document = '98498' 01/09/2025 09:24:28 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 = '98498' 01/09/2025 09:24:28 am >> DELETE FROM ps_document_detail WHERE id_document = '98498' 01/09/2025 09:24:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98498' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 01/09/2025 09:30: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 ( '32' , '2025010001384' , '2025-08-30' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6.01' , '4' , '1' , '0' , '0' , '' , '0' , '0' , '58.00' , '57.30' , NOW() , NOW() ) 01/09/2025 09:30: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 = '98499' 01/09/2025 09:30:13 am >> DELETE FROM ps_document_detail WHERE id_document = '98499' 01/09/2025 09:30: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 ( '98499' , '23931' , 'IO HO FATTO LA MIA PARTE 2026' , '1' , '0' , '1' , '4.91' , '4.0245901639344' , '22' , '35' , '3.8936' ) 01/09/2025 09:30:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23931' AND id_supplier = '107' 01/09/2025 09:30:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23931' , '107' , '1' ) 01/09/2025 09:30: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 ( '98499' , '23864' , 'MARIOLOGIA BIBLICA - S. MANELLI' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 01/09/2025 09:30:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23864' AND id_supplier = '107' 01/09/2025 09:30:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23864' , '107' , '1' ) 01/09/2025 09:30: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 ( '98499' , '23747' , 'PADRE NELLE TUE MANI... - E. DELLA CORTE' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '35' , '20.80' ) 01/09/2025 09:30:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23747' AND id_supplier = '107' 01/09/2025 09:30:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23747' , '107' , '1' ) 01/09/2025 09:30: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 ( '98499' , '841' , 'AUTOBIOGRAFIA S. M. M. ALACOQUE' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 01/09/2025 09:30:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '841' AND id_supplier = '107' 01/09/2025 09:30:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '841' , '107' , '1' ) 01/09/2025 09:33:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 09:33:45 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' , '2781' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '45.19' , NOW() , NOW() ) 01/09/2025 09:33:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98500' 01/09/2025 09:33:45 am >> DELETE FROM ps_document_detail WHERE id_document = '98500' 01/09/2025 09:33:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98500' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 01/09/2025 09:33:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98500' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 01/09/2025 09:35:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2698' AND id_document != '98411' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 01/09/2025 09:35:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2698', document_date = '2025-08-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '400.00', price_tax_excluded = '337.25', date_upd = NOW() WHERE id_document = '98411' 01/09/2025 09:35: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 = '98411' 01/09/2025 09:35:56 am >> DELETE FROM ps_document_detail WHERE id_document = '98411' 01/09/2025 09:35: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 ( '98411' , '19351' , 'SERVIZIO MESSA MISTO LINO - 7050' , '1' , '-1' , '1' , '52.0000' , '42.622950819672' , '22' , '0' , '52.00' ) 01/09/2025 09:35: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 ( '98411' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 01/09/2025 09:35: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 ( '98411' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.0000' , '52' , '0' , '0' , '52.00' ) 01/09/2025 09:35: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 ( '98411' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '290' , '237.70491803279' , '22' , '0' , '290.00' ) 01/09/2025 09:40:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 09:40:44 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' , '2782' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.36' , NOW() , NOW() ) 01/09/2025 09:40: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 = '98501' 01/09/2025 09:40:44 am >> DELETE FROM ps_document_detail WHERE id_document = '98501' 01/09/2025 09:40: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 ( '98501' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2025 09:40: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 ( '98501' , '5538' , 'LACCIO MARRONE' , '5' , '-5' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.25' ) 01/09/2025 09:40: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 ( '98501' , '9714' , 'SCATOLA OTTOGONALE - 7328' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 01/09/2025 10:41:33 am >> SELECT document_num FROM ps_document WHERE document_num = '89/A' AND id_document != '97713' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-14') 01/09/2025 10:41:33 am >> UPDATE ps_document SET id_document_type = '24', document_num = '89/A', document_date = '2025-06-14', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '+++ GIA\' SCALATI', 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 = '442.30', price_tax_excluded = '375.72', date_upd = NOW() WHERE id_document = '97713' 01/09/2025 10:41: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 = '97713' 01/09/2025 10:41:33 am >> DELETE FROM ps_document_detail WHERE id_document = '97713' 01/09/2025 10:41: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 ( '97713' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 01/09/2025 10:41: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 ( '97713' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 01/09/2025 10:41: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 ( '97713' , '1077' , 'BERNADETTE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 01/09/2025 10:41: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 ( '97713' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 01/09/2025 10:41: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 ( '97713' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '0' , '15.00' ) 01/09/2025 10:41: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 ( '97713' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 01/09/2025 10:41: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 ( '97713' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 01/09/2025 10:41: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 ( '97713' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '33.0000' , '27.049180327869' , '22' , '0' , '33.00' ) 01/09/2025 10:41: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 ( '97713' , '20547' , 'MEDAGLIA LOURDES - OV22/L' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 01/09/2025 10:41: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 ( '97713' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '6' , '-6' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '10.80' ) 01/09/2025 10:41: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 ( '97713' , '2168' , 'CLERGY BASIC - ML - B&P' , '4' , '-4' , '1' , '36.0000' , '29.508196721311' , '22' , '0' , '144.00' ) 01/09/2025 10:41: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 ( '97713' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 01/09/2025 10:41: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 ( '97713' , '19906' , 'FASCIA PER TALARE' , '1' , '-1' , '1' , '90.0000' , '73.770491803279' , '22' , '0' , '90.00' ) 01/09/2025 10:41: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 ( '97713' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25 +++' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '0' , '10.00' ) 01/09/2025 10:41: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 ( '97713' , '23822' , 'AMEN - OTT 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 01/09/2025 10:41: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 ( '97713' , '23823' , 'AMEN - SET 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 01/09/2025 10:41: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 ( '97713' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '0' , '15.00' ) 01/09/2025 10:41: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 ( '97713' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 01/09/2025 10:41: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 ( '97713' , '2178' , 'CLERGY BASIC EXTRA - MM - B&P' , '2' , '-2' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '79.00' ) 01/09/2025 11:01:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2783' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 11:01:07 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' , '2783' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.75' , '42.19' , NOW() , NOW() ) 01/09/2025 11:01: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 = '98502' 01/09/2025 11:01:07 am >> DELETE FROM ps_document_detail WHERE id_document = '98502' 01/09/2025 11:01: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 ( '98502' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '28' , '-28' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '14.00' ) 01/09/2025 11:01: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 ( '98502' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 01/09/2025 11:01: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 ( '98502' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 01/09/2025 11:01: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 ( '98502' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2025 11:04:42 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 01/09/2025 11:04:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23958' , '1' , '' , 'nuovo-prodotto' ) 01/09/2025 11:04:42 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23958' , '1' , '1' , '2' , NOW() , NOW() ) 01/09/2025 11:04:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23958' , '0' , '1' , '0' , '0' ) 01/09/2025 11:05:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788893183352' AND id_product != '23958' AND ean13 != '' 01/09/2025 11:05:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788893183352', date_upd = NOW() WHERE id_product = '23958' 01/09/2025 11:05:20 am >> UPDATE ps_product_lang SET name = 'DIARIO SPIRITUALE SEGRETO', description = '' WHERE id_product = '23958' 01/09/2025 11:05:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '23958' 01/09/2025 11:05:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '47', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23958' 01/09/2025 11:05:20 am >> DELETE FROM ps_specific_price WHERE id_product = '23958' 01/09/2025 11:05:22 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23958' 01/09/2025 11:05:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23959' , '1' , '' , 'nuovo-prodotto' ) 01/09/2025 11:05:22 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23959' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23958' 01/09/2025 11:05:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23959' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23958' 01/09/2025 11:06:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788871527864' AND id_product != '23959' AND ean13 != '' 01/09/2025 11:06:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788871527864', date_upd = NOW() WHERE id_product = '23959' 01/09/2025 11:06:15 am >> UPDATE ps_product_lang SET name = 'SEME NEL DESERTO CHARLES DE FOUCAULD - PRONZATO A.', description = '' WHERE id_product = '23959' 01/09/2025 11:06:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '23959' 01/09/2025 11:06:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '24', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23959' 01/09/2025 11:06:15 am >> DELETE FROM ps_specific_price WHERE id_product = '23959' 01/09/2025 11:06:16 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23959' 01/09/2025 11:06:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23960' , '1' , '' , 'nuovo-prodotto' ) 01/09/2025 11:06:16 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23960' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23959' 01/09/2025 11:06:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23960' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23959' 01/09/2025 11:07: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 ( '33' , '3728' , '2025-08-28' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.15' , '50.15' , NOW() , NOW() ) 01/09/2025 11:07: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 = '98503' 01/09/2025 11:07:33 am >> DELETE FROM ps_document_detail WHERE id_document = '98503' 01/09/2025 11:07: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 ( '98503' , '23958' , 'DIARIO SPIRITUALE SEGRETO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 01/09/2025 11:07:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '23958' AND id_supplier = '47' 01/09/2025 11:07:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23958' , '47' , '1' ) 01/09/2025 11:07: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 ( '98503' , '20879' , 'SALITA DEL MONTE CARMELO - G. DELLA CROCE' , '2' , '2' , '4' , '18.00' , '18' , '0' , '30' , '25.2000' ) 01/09/2025 11:07:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20879' AND id_supplier = '47' 01/09/2025 11:07:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20879' , '47' , '1' ) 01/09/2025 11:07: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 ( '98503' , '23959' , 'SEME NEL DESERTO CHARLES DE FOUCAULD - PRONZATO A.' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '30' , '11.5500' ) 01/09/2025 11:07:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23959' AND id_supplier = '47' 01/09/2025 11:07:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23959' , '47' , '1' ) 01/09/2025 11:19:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2784' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 11:19:36 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' , '2784' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.85' , '117.53' , NOW() , NOW() ) 01/09/2025 11:19: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 = '98504' 01/09/2025 11:19:36 am >> DELETE FROM ps_document_detail WHERE id_document = '98504' 01/09/2025 11:19: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 ( '98504' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 01/09/2025 11:19: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 ( '98504' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2025 11:19: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 ( '98504' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 01/09/2025 11:19: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 ( '98504' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 01/09/2025 11:19: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 ( '98504' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 01/09/2025 11:22:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2785' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 11:22:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2785' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.66' , '44.66' , NOW() , NOW() ) 01/09/2025 11:22:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98505' 01/09/2025 11:22:59 am >> DELETE FROM ps_document_detail WHERE id_document = '98505' 01/09/2025 11:22:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98505' , '9420' , 'SAN FRANCESCO DASSISI' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 01/09/2025 11:22:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98505' , '9462' , 'SAN GIUSEPPE - T. STRAMARE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2025 11:22:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98505' , '12858' , 'ANTONIO DI PADOVA' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 01/09/2025 11:22:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98505' , '9487' , 'SAN MICHELE ARCANGELO - F.INNOCENTE' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 01/09/2025 11:22:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98505' , '23405' , 'DIARIO SANTA FAUSTINA - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 01/09/2025 11:22:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98505' , '11281' , 'VI PARLO DI ME - S. GEMMA GALGANI - 8581' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 01/09/2025 11:32:07 am >> DELETE FROM ps_document WHERE id_document = '97713' 01/09/2025 11:32:08 am >> DELETE FROM ps_document_detail WHERE id_document = '97713' 01/09/2025 11:33:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2176/25' , '2025-08-26' , '25' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '894.40' , '860.00' , NOW() , NOW() ) 01/09/2025 11:33:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98506' 01/09/2025 11:33:08 am >> DELETE FROM ps_document_detail WHERE id_document = '98506' 01/09/2025 11:33:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98506' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '400' , '400' , '3' , '2.15' , '2.0673076923077' , '4' , '0' , '894.4000' ) 01/09/2025 11:33:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '22' 01/09/2025 11:33:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '22' , '1' ) 01/09/2025 11:35:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 11:35:16 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' , '2786' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 01/09/2025 11:35:16 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 = '98507' 01/09/2025 11:35:16 am >> DELETE FROM ps_document_detail WHERE id_document = '98507' 01/09/2025 11:35:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98507' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 01/09/2025 11:36:32 am >> SELECT document_num FROM ps_document WHERE document_num = '110/A' AND id_document != '98409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-08') 01/09/2025 11:36:32 am >> UPDATE ps_document SET id_document_type = '24', document_num = '110/A', document_date = '2025-08-08', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = 'MATERIALE NOVIZI', 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 = '712.00', price_tax_excluded = '700.46', date_upd = NOW() WHERE id_document = '98409' 01/09/2025 11:36:32 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 = '98409' 01/09/2025 11:36:32 am >> DELETE FROM ps_document_detail WHERE id_document = '98409' 01/09/2025 11:36:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98409' , '0' , 'SOTTOTALARE' , '6' , '-6' , '0' , '39.0000' , '39' , '0' , '0' , '234.00' ) 01/09/2025 11:36:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98409' , '0' , 'FASCIA PER TALARE' , '4' , '-4' , '0' , '90.0000' , '90' , '0' , '0' , '360.00' ) 01/09/2025 11:36:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98409' , '0' , 'POLO' , '1' , '-1' , '0' , '40.0000' , '40' , '0' , '0' , '40.00' ) 01/09/2025 11:36:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98409' , '0' , 'COLLETTO' , '4' , '-4' , '0' , '3.5000' , '3.5' , '0' , '0' , '14.00' ) 01/09/2025 11:36:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98409' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '4' , '-4' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '12.00' ) 01/09/2025 11:36:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98409' , '0' , 'PETTINA' , '4' , '-4' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '52.00' ) 01/09/2025 11:39:49 am >> SELECT document_num FROM ps_document WHERE document_num = '103/A' AND id_document != '98318' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-31') 01/09/2025 11:39:49 am >> UPDATE ps_document SET id_document_type = '24', document_num = '103/A', document_date = '2025-07-31', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1750.30', price_tax_excluded = '1451.77', date_upd = NOW() WHERE id_document = '98318' 01/09/2025 11:39: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 = '98318' 01/09/2025 11:39:49 am >> DELETE FROM ps_document_detail WHERE id_document = '98318' 01/09/2025 11:39: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 ( '98318' , '19756' , 'CAMICIA STOCK' , '1' , '-1' , '1' , '49.0000' , '40.16393442623' , '22' , '0' , '49.00' ) 01/09/2025 11:39: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 ( '98318' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 01/09/2025 11:39: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 ( '98318' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 01/09/2025 11:39: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 ( '98318' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '3' , '-3' , '1' , '36.5000' , '29.918032786885' , '22' , '0' , '109.50' ) 01/09/2025 11:39: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 ( '98318' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 01/09/2025 11:39: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 ( '98318' , '19973' , 'AMPOLLINE - ART. 194/1' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 01/09/2025 11:39: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 ( '98318' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 01/09/2025 11:39: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 ( '98318' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '0' , '20.00' ) 01/09/2025 11:39: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 ( '98318' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 01/09/2025 11:39: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 ( '98318' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '102.00' ) 01/09/2025 11:39: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 ( '98318' , '7202' , 'ARTICOLI RELIGIOSI - dalmatica bianca' , '1' , '-1' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '100.00' ) 01/09/2025 11:39: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 ( '98318' , '17087' , 'POLO COTONE MM' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 01/09/2025 11:39: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 ( '98318' , '8082' , 'POLO LIMITED ' , '2' , '-2' , '1' , '33.0000' , '27.049180327869' , '22' , '0' , '66.00' ) 01/09/2025 11:39: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 ( '98318' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '41.0000' , '33.606557377049' , '22' , '0' , '41.00' ) 01/09/2025 11:39: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 ( '98318' , '18682' , 'CLERGY ROMANO ML - C17' , '2' , '-2' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '99.80' ) 01/09/2025 11:39: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 ( '98318' , '17408' , 'CAMICE MISTO COT. 70/001035' , '3' , '-3' , '1' , '175.0000' , '143.44262295082' , '22' , '0' , '525.00' ) 01/09/2025 11:39: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 ( '98318' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '39.90' ) 01/09/2025 11:39: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 ( '98318' , '15019' , 'PREGHIAMO CON MARIA' , '5' , '-5' , '4' , '0.8000' , '0.8' , '0' , '0' , '4.00' ) 01/09/2025 11:39: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 ( '98318' , '0' , 'PALLA ' , '2' , '-2' , '0' , '20.0000' , '20' , '0' , '0' , '40.00' ) 01/09/2025 11:39: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 ( '98318' , '0' , 'CLERGY COCO NUOVO' , '1' , '-1' , '0' , '30' , '30' , '' , '0' , '30.00' ) 01/09/2025 11:39: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 ( '98318' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 01/09/2025 11:55:19 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') 01/09/2025 11:55:19 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' 01/09/2025 11:55: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 = '98345' 01/09/2025 11:55:19 am >> DELETE FROM ps_document_detail WHERE id_document = '98345' 01/09/2025 11:55: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 ( '98345' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 01/09/2025 11:55: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 ( '98345' , '20547' , 'MEDAGLIA LOURDES - OV22/L' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 01/09/2025 11:55: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 ( '98345' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '6' , '-6' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '4.50' ) 01/09/2025 11:56:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2003' AND id_document != '97569' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 01/09/2025 11:56:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2003', document_date = '2025-06-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '165.00', price_tax_excluded = '135.25', date_upd = NOW() WHERE id_document = '97569' 01/09/2025 11:56:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97569' 01/09/2025 11:56:34 am >> DELETE FROM ps_document_detail WHERE id_document = '97569' 01/09/2025 11:56: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 ( '97569' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '91.0000' , '74.590163934426' , '22' , '0' , '91.00' ) 01/09/2025 11:56: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 ( '97569' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 01/09/2025 11:56: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 ( '97569' , '2178' , 'CLERGY BASIC EXTRA - MM - B&P' , '2' , '-2' , '1' , '25' , '20.491803278689' , '22' , '0' , '50.00' ) 01/09/2025 12:02:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 12:02:40 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' , '2787' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.42' , '45.42' , NOW() , NOW() ) 01/09/2025 12:02:40 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 = '98508' 01/09/2025 12:02:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '98508' 01/09/2025 12:02:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98508' , '23058' , 'INTERCESSIONI - K. RAHNER' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 01/09/2025 12:02:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98508' , '22745' , 'VANGELO DEL CORAGGIO - TONINO BELLO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 01/09/2025 12:02:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98508' , '16664' , 'DON BOSCO LA STORIA INFINITA - B. FERRERO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 01/09/2025 12:02:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98508' , '20869' , 'CARA MAMMA - TONINO BELLO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 01/09/2025 12:03:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2788' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 12:03:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2788' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 01/09/2025 12:03:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98509' 01/09/2025 12:03:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '98509' 01/09/2025 12:03:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98509' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 01/09/2025 12:03:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98509' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 01/09/2025 12:06:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 12:06:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2789' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.30' , '59.93' , NOW() , NOW() ) 01/09/2025 12:06:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98510' 01/09/2025 12:06:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '98510' 01/09/2025 12:06:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 01/09/2025 12:06:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '15483' , 'CROCE - 075 ALV' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 01/09/2025 12:06:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '17529' , 'NUOVO RITO DELLA MESSA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 01/09/2025 12:06:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '19540' , 'CRESIMA N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 01/09/2025 12:06:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '18290' , 'BATTESIMO - N.E. ' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 01/09/2025 12:06:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 01/09/2025 12:06:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 01/09/2025 12:06:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '23853' , 'COMPRENDI DAVVERO LA MESSA? - 8184' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 01/09/2025 12:06:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 01/09/2025 12:06:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '23443' , 'MA COME SI FA?' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 01/09/2025 12:06:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 01/09/2025 12:06:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98510' , '23748' , 'FORMAZIONE DEI PRESBITERI NELLE CHIESE IN ITALIA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 01/09/2025 12:08:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2790' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 12:08: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' , '2790' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 01/09/2025 12:08: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 = '98511' 01/09/2025 12:08:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '98511' 01/09/2025 12:08: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 ( '98511' , '23372' , 'LAVANDA DEI PIEDI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 01/09/2025 12:14:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2532' AND id_document != '98202' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-23') 01/09/2025 12:14:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2532', document_date = '2025-07-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '-0.08', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '413.97', price_tax_excluded = '376.60', date_upd = NOW() WHERE id_document = '98202' 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98202' 01/09/2025 12:14:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '98202' 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '56.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '15463' , 'PICCOLO CATECHISMO DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '20516' , 'CROCE COMUNIONE - 42/08' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '15.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '10' , '-10' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '22.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '21' , '-21' , '4' , '0.7000' , '0.7' , '0' , '0' , '14.70' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '14.70' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '-1' , '4' , '90.0000' , '90' , '0' , '0' , '90.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '0' , '60.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 01/09/2025 12:14:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98202' , '23557' , 'STATUA S. MICHELE BIANCA - ST203-BSM' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 01/09/2025 12:22:00 pm >> 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') 01/09/2025 12:22:00 pm >> 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' 01/09/2025 12:22: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 = '98480' 01/09/2025 12:22:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '98480' 01/09/2025 12:22: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 ( '98480' , '23897' , 'QUADRETTO CON FIOCCO S. ROCCO - 12/39-C' , '25' , '-25' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '82.50' ) 01/09/2025 12:22: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 ( '98480' , '23898' , 'QUADRETTO CON FIOCCO S. ROCCO - 12/39-R' , '24' , '-24' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '79.20' ) 01/09/2025 12:22: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 ( '98480' , '23903' , 'BRACCIALE CON MEDAGLIA SAN ROCCO - 800/W2158-RH' , '12' , '-12' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '36.00' ) 01/09/2025 12:22: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 ( '98480' , '23902' , 'BRACCIALE SAN ROCCO - 800/CA4' , '36' , '-36' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '108.00' ) 01/09/2025 12:22: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 ( '98480' , '22656' , 'PORTACHIAVI SAN ROCCO' , '183' , '-183' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '256.20' ) 01/09/2025 12:22: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 ( '98480' , '22653' , 'GIROCOLLO PERSONALIZZATO SAN ROCCO' , '48' , '-48' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '144.00' ) 01/09/2025 12:22: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 ( '98480' , '23901' , 'MEDAGLIA SAN ROCCO SMALTATA - 400/6573M' , '200' , '-200' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '80.00' ) 01/09/2025 12:22: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 ( '98480' , '23896' , 'MAGNETE SAN ROCCO - 1181-0' , '109' , '-109' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '141.70' ) 01/09/2025 12:22: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 ( '98480' , '23899' , 'ROSARIO SAN ROCCO - 163/8' , '36' , '-36' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '162.00' ) 01/09/2025 12:22:01 pm >> INSERT INTO ps_document_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' ) 01/09/2025 12:33:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '91/A' AND id_document != '87349' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-19') 01/09/2025 12:33:01 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '91/A', document_date = '2023-09-19', document_letter = 'A', id_customer = '3892', id_supplier = '', id_address = '4679228', address1 = 'OGLIARA 84100 OGLIARA', address2 = '', note = 'ACCONTO AL 01/09 € 1210,00', 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 = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87349' 01/09/2025 12:33:01 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 = '87349' 01/09/2025 12:33:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '87349' 01/09/2025 12:33:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '0' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 01/09/2025 12:33:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '0' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 01/09/2025 12:33:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '0' , 'PALLA MARIANA - 50/372' , '1' , '0' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 01/09/2025 12:33:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '0' , '1' , '305.0000' , '250' , '22' , '0' , '305.00' ) 01/09/2025 12:33:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' , '0' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 01/09/2025 12:33:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '0' , 'PISSIDE 099PA' , '1' , '0' , '1' , '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 01/09/2025 12:33:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '0' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 01/09/2025 12:36:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2791' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 12:36:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2791' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/09/2025 12:36:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98512' 01/09/2025 12:36:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '98512' 01/09/2025 12:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98512' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2025 12:45:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2792' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 12:45:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2792' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 01/09/2025 12:45:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98513' 01/09/2025 12:45:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '98513' 01/09/2025 12:45:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98513' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 01/09/2025 12:50:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2793' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 12:50:40 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' , '2793' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 01/09/2025 12:50:40 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 = '98514' 01/09/2025 12:50:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '98514' 01/09/2025 12:50:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98514' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 01/09/2025 12:58:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2794' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 12:58:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2794' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '55.77' , NOW() , NOW() ) 01/09/2025 12:58:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98515' 01/09/2025 12:58:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '98515' 01/09/2025 12:58:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98515' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '58' , '55.769230769231' , '4' , '0' , '58.00' ) 01/09/2025 01:00:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 01:00: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' , '2795' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.80' , '22.03' , NOW() , NOW() ) 01/09/2025 01:00: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 = '98516' 01/09/2025 01:00:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '98516' 01/09/2025 01:00: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 ( '98516' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 01/09/2025 01:00: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 ( '98516' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '4' , '-4' , '4' , '0.70' , '0.7' , '0' , '0' , '2.80' ) 01/09/2025 01:04:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2796' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 01:04:27 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' , '2796' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '265.00' , '217.21' , NOW() , NOW() ) 01/09/2025 01:04:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98517' 01/09/2025 01:04:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '98517' 01/09/2025 01:04:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98517' , '18184' , 'STOLA RASO CON RICAMO UVA - 7877' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 01/09/2025 01:04:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98517' , '22836' , 'PALLA - 75/1634' , '1' , '-1' , '1' , '95' , '77.868852459016' , '22' , '0' , '95.00' ) 01/09/2025 02:30:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2424' AND id_document != '98066' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-11') 01/09/2025 02:30:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2424', document_date = '2025-07-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 = '40.00', price_tax_excluded = '32.97', date_upd = NOW() WHERE id_document = '98066' 01/09/2025 02:30:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98066' 01/09/2025 02:30:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '98066' 01/09/2025 02:30:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98066' , '22968' , 'TURIBOLO H10' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 01/09/2025 02:30:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98066' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 01/09/2025 02:30:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98066' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 01/09/2025 02:30:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2684' AND id_document != '98394' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 01/09/2025 02:30:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2684', document_date = '2025-08-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 = '87.00', price_tax_excluded = '85.56', date_upd = NOW() WHERE id_document = '98394' 01/09/2025 02:30: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 = '98394' 01/09/2025 02:30:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '98394' 01/09/2025 02:30: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 ( '98394' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '20' , '-20' , '4' , '2.4000' , '2.4' , '0' , '0' , '48.00' ) 01/09/2025 02:30: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 ( '98394' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '2' , '-2' , '4' , '0.75' , '0.75' , '0' , '0' , '1.50' ) 01/09/2025 02:30: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 ( '98394' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 01/09/2025 02:30: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 ( '98394' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 01/09/2025 02:31:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2478' AND id_document != '98130' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-17') 01/09/2025 02:31:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2478', document_date = '2025-07-17', 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 = '25.80', price_tax_excluded = '21.38', date_upd = NOW() WHERE id_document = '98130' 01/09/2025 02:31:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98130' 01/09/2025 02:31:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '98130' 01/09/2025 02:31:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98130' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '24.50' ) 01/09/2025 02:31:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98130' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '2' , '-2' , '4' , '0.65' , '0.65' , '0' , '0' , '1.30' ) 01/09/2025 02:34:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2741' AND id_document != '98456' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 01/09/2025 02:34:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2741', 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 = '29.50', price_tax_excluded = '29.33', date_upd = NOW() WHERE id_document = '98456' 01/09/2025 02:34:49 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 = '98456' 01/09/2025 02:34:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '98456' 01/09/2025 02:34:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98456' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 01/09/2025 02:34:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98456' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 01/09/2025 02:34:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98456' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 01/09/2025 02:34:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98456' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 01/09/2025 02:34:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98456' , '1077' , 'BERNADETTE' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 01/09/2025 02:34:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98456' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 01/09/2025 02:34:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98456' , '23822' , 'AMEN - OTT 25' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 01/09/2025 02:34:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98456' , '23823' , 'AMEN - SET 25' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 01/09/2025 02:36:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2003' AND id_document != '97569' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 01/09/2025 02:36:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2003', document_date = '2025-06-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '165.00', price_tax_excluded = '135.25', date_upd = NOW() WHERE id_document = '97569' 01/09/2025 02:36:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97569' 01/09/2025 02:36:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '97569' 01/09/2025 02:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97569' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '61' , '50' , '22' , '0' , '61.00' ) 01/09/2025 02:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97569' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 01/09/2025 02:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97569' , '2178' , 'CLERGY BASIC EXTRA - MM - B&P' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 01/09/2025 02:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97569' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 01/09/2025 02:38:40 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 ( '32' , '25V604478' , '2025-08-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.53' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.19' , '160.19' , NOW() , NOW() ) 01/09/2025 02:38:40 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 = '98518' 01/09/2025 02:38:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '98518' 01/09/2025 02:38:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23953' , 'VANGELO DELLA GRAZIA' , '1' , '0' , '4' , '13.9000' , '13.9' , '0' , '30' , '9.73' ) 01/09/2025 02:38:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23953' AND id_supplier = '7' 01/09/2025 02:38:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23953' , '7' , '1' ) 01/09/2025 02:38:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23942' , 'INSIEME NELLA MESSA - NOV 2025' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 01/09/2025 02:38:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23942' AND id_supplier = '7' 01/09/2025 02:38:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23942' , '7' , '1' ) 01/09/2025 02:38:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23941' , 'PAROLA E PREGHIERA - NOV 25' , '2' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '3.89' ) 01/09/2025 02:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23941' AND id_supplier = '7' 01/09/2025 02:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23941' , '7' , '1' ) 01/09/2025 02:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23946' , 'MONDI DIVERSI, UN UNICO PANE - I. ZIZIC' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '30' , '21.00' ) 01/09/2025 02:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23946' AND id_supplier = '7' 01/09/2025 02:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23946' , '7' , '1' ) 01/09/2025 02:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23952' , 'BELLEZZA E STUPORE DELL\'EVENTO LITURGICO -G. CAVAGNOLI' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 01/09/2025 02:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23952' AND id_supplier = '7' 01/09/2025 02:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23952' , '7' , '1' ) 01/09/2025 02:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23947' , 'SPIRITO SANTO QUESTO SCONOSCIUTO - R. LAURENTIN' , '1' , '0' , '4' , '47.0000' , '47' , '0' , '30' , '32.90' ) 01/09/2025 02:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23947' AND id_supplier = '7' 01/09/2025 02:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23947' , '7' , '1' ) 01/09/2025 02:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23945' , 'TELEMACO NON SI SBAGLIAVA - L.M. EPICOCO' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 01/09/2025 02:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23945' AND id_supplier = '7' 01/09/2025 02:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23945' , '7' , '1' ) 01/09/2025 02:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23944' , 'PERLE DI PAOLO - S. DIANICH' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 01/09/2025 02:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23944' AND id_supplier = '7' 01/09/2025 02:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23944' , '7' , '1' ) 01/09/2025 02:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23943' , 'UN AMORE SENZA CONFINI - V. PAGLIA' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 01/09/2025 02:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23943' AND id_supplier = '7' 01/09/2025 02:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23943' , '7' , '1' ) 01/09/2025 02:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23940' , 'ROSARIO CON PADRE PIO' , '12' , '0' , '4' , '2.0000' , '2' , '0' , '33' , '16.08' ) 01/09/2025 02:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23940' AND id_supplier = '7' 01/09/2025 02:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23940' , '7' , '1' ) 01/09/2025 02:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23940' , 'ROSARIO CON PADRE PIO' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '100' , '0.00' ) 01/09/2025 02:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23940' AND id_supplier = '7' 01/09/2025 02:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23940' , '7' , '1' ) 01/09/2025 02:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23948' , 'DIVENTARE PRETI OGGI - S. G. OPORTO' , '1' , '0' , '4' , '17.0000' , '17' , '0' , '33' , '11.39' ) 01/09/2025 02:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23948' AND id_supplier = '7' 01/09/2025 02:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23948' , '7' , '1' ) 01/09/2025 02:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23950' , '60 CONSIGLI PER UN MATRIMONIO FELICE - C.E. COMMENTZ' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '4.20' ) 01/09/2025 02:38:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23950' AND id_supplier = '7' 01/09/2025 02:38:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23950' , '7' , '1' ) 01/09/2025 02:38:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23949' , 'UN BUON CONFESSORE - C.E. COMMENTZ' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '30' , '5.60' ) 01/09/2025 02:38:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23949' AND id_supplier = '7' 01/09/2025 02:38:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23949' , '7' , '1' ) 01/09/2025 02:38:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98518' , '23951' , 'POVERI PRETI - O. DE BORTOLIS' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 01/09/2025 02:38:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23951' AND id_supplier = '7' 01/09/2025 02:38:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23951' , '7' , '1' ) 01/09/2025 02:48: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 ( '32' , '2025010001384' , '2025-08-30' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6.01' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '57.30' , NOW() , NOW() ) 01/09/2025 02:48: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 = '98519' 01/09/2025 02:48:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '98519' 01/09/2025 02:48: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 ( '98519' , '23931' , 'IO HO FATTO LA MIA PARTE 2026' , '1' , '0' , '1' , '4.9' , '4.016393442623' , '22' , '35' , '3.8857' ) 01/09/2025 02:48:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23931' AND id_supplier = '107' 01/09/2025 02:48:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23931' , '107' , '1' ) 01/09/2025 02:48: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 ( '98519' , '23864' , 'MARIOLOGIA BIBLICA - S. MANELLI' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 01/09/2025 02:48:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23864' AND id_supplier = '107' 01/09/2025 02:48:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23864' , '107' , '1' ) 01/09/2025 02:48: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 ( '98519' , '23747' , 'PADRE NELLE TUE MANI... - E. DELLA CORTE' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '35' , '20.80' ) 01/09/2025 02:48:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23747' AND id_supplier = '107' 01/09/2025 02:48:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23747' , '107' , '1' ) 01/09/2025 02:48: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 ( '98519' , '841' , 'AUTOBIOGRAFIA S. M. M. ALACOQUE' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 01/09/2025 02:48:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '841' AND id_supplier = '107' 01/09/2025 02:48:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '841' , '107' , '1' ) 01/09/2025 03:09:49 pm >> DELETE FROM ps_document WHERE id_document = '98409' 01/09/2025 03:09:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '98409' 01/09/2025 03:09:56 pm >> DELETE FROM ps_document WHERE id_document = '98322' 01/09/2025 03:09:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '98322' 01/09/2025 03:10:03 pm >> DELETE FROM ps_document WHERE id_document = '98318' 01/09/2025 03:10:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '98318' 01/09/2025 03:10:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2641' AND id_document != '98338' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-04') 01/09/2025 03:10:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2641', 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 = '5.50', price_tax_excluded = '4.51', date_upd = NOW() WHERE id_document = '98338' 01/09/2025 03:10:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98338' 01/09/2025 03:10:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '98338' 01/09/2025 03:10:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98338' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 01/09/2025 03:10:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98338' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 01/09/2025 03:12:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2003' AND id_document != '97569' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 01/09/2025 03:12:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2003', document_date = '2025-06-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '165.00', price_tax_excluded = '135.25', date_upd = NOW() WHERE id_document = '97569' 01/09/2025 03:12:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97569' 01/09/2025 03:12:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '97569' 01/09/2025 03:12:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97569' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 01/09/2025 03:12:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97569' , '2178' , 'CLERGY BASIC EXTRA - MM - B&P' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 01/09/2025 03:12:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97569' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 01/09/2025 03:12:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97569' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '3' , '-3' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 01/09/2025 03:12:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97569' , '11154' , 'VASETTO BASSO CON ANELLO - 820' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 01/09/2025 03:12:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97569' , '19756' , 'CAMICIA STOCK' , '1' , '-1' , '1' , '33' , '27.049180327869' , '22' , '0' , '33.00' ) 01/09/2025 03:12:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2111' AND id_document != '97690' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-12') 01/09/2025 03:12:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2111', 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 = '115.00', price_tax_excluded = '94.26', date_upd = NOW() WHERE id_document = '97690' 01/09/2025 03:12:50 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 = '97690' 01/09/2025 03:12:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '97690' 01/09/2025 03:12:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97690' , '15481' , 'CROCE IHS - 2389/CZ' , '2' , '-2' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '5.00' ) 01/09/2025 03:12:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97690' , '18164' , 'RELIQUIARIO H 28' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 01/09/2025 03:13:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2050' AND id_document != '97622' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-09') 01/09/2025 03:13:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2050', document_date = '2025-06-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '97622' 01/09/2025 03:13:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97622' 01/09/2025 03:13:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '97622' 01/09/2025 03:13:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97622' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 01/09/2025 03:13:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97622' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 01/09/2025 03:13:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97622' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 01/09/2025 03:14:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2077' AND id_document != '97650' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-10') 01/09/2025 03:14:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2077', document_date = '2025-06-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 = '53.00', price_tax_excluded = '43.44', date_upd = NOW() WHERE id_document = '97650' 01/09/2025 03:14:11 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 = '97650' 01/09/2025 03:14:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '97650' 01/09/2025 03:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97650' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 01/09/2025 03:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97650' , '17087' , 'POLO COTONE MM' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 01/09/2025 03:16:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2104' AND id_document != '97683' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-12') 01/09/2025 03:16:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2104', 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 = '165.00', price_tax_excluded = '135.25', date_upd = NOW() WHERE id_document = '97683' 01/09/2025 03:16:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97683' 01/09/2025 03:16:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '97683' 01/09/2025 03:16:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97683' , '17037' , 'CLERGY M/LINO MM ' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 01/09/2025 03:16:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97683' , '21132' , 'CLERGY F/F MC - C03' , '2' , '-2' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '79.00' ) 01/09/2025 03:16:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97683' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 01/09/2025 03:16:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97683' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 01/09/2025 03:17:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2110' AND id_document != '97689' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-12') 01/09/2025 03:17:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2110', document_date = '2025-06-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '73.00', price_tax_excluded = '59.84', date_upd = NOW() WHERE id_document = '97689' 01/09/2025 03:17: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 = '97689' 01/09/2025 03:17:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '97689' 01/09/2025 03:17: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 ( '97689' , '11384' , 'VINO BIANCO DOLCE - 102' , '10' , '-10' , '1' , '7.3' , '5.983606557377' , '22' , '0' , '73.00' ) 01/09/2025 03:18:36 pm >> 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') 01/09/2025 03:18:36 pm >> 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' 01/09/2025 03:18:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97693' 01/09/2025 03:18:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '97693' 01/09/2025 03:18:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 01/09/2025 03:18:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 01/09/2025 03:18:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '22352' , 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K' , '10' , '-10' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '14.00' ) 01/09/2025 03:18:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 01/09/2025 03:18:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 01/09/2025 03:18:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97693' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '6.50' ) 01/09/2025 03:29:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '109/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 03:29:56 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' , '109/A' , '2025-09-01' , 'A' , '2893' , '0' , '4672074' , 'VIA CONVENTO 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '136.50' , '111.89' , NOW() , NOW() ) 01/09/2025 03:29:56 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 = '98520' 01/09/2025 03:29:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '98520' 01/09/2025 03:29:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98520' , '15094' , 'BRACCIALE DECINA CORDA TAU' , '105' , '-105' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '136.50' ) 01/09/2025 03:42:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2794' AND id_document != '98515' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 03:42:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2794', document_date = '2025-09-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 = '58.00', price_tax_excluded = '55.77', date_upd = NOW() WHERE id_document = '98515' 01/09/2025 03:42: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 = '98515' 01/09/2025 03:42:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '98515' 01/09/2025 03:42: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 ( '98515' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 01/09/2025 03:42: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 ( '98515' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '10' , '-10' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '45.00' ) 01/09/2025 03:42: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 ( '98515' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 01/09/2025 03:54:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 03:54: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' , '2797' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 01/09/2025 03:54: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 = '98521' 01/09/2025 03:54:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '98521' 01/09/2025 03:54: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 ( '98521' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 01/09/2025 04:44:41 pm >> DELETE FROM ps_document WHERE id_document = '98375' 01/09/2025 04:44:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '98375' 01/09/2025 04:46:57 pm >> DELETE FROM ps_document WHERE id_document = '98034' 01/09/2025 04:46:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '98034' 01/09/2025 04:47:35 pm >> DELETE FROM ps_document WHERE id_document = '97563' 01/09/2025 04:47:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '97563' 01/09/2025 05:09:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2282' AND id_document != '97892' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-27') 01/09/2025 05:09:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2282', document_date = '2025-06-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 = '163.00', price_tax_excluded = '133.61', date_upd = NOW() WHERE id_document = '97892' 01/09/2025 05:09:37 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 = '97892' 01/09/2025 05:09:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '97892' 01/09/2025 05:09:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97892' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 01/09/2025 05:09:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97892' , '16962' , 'SERVIZIO MESSA LINO ' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 01/09/2025 05:14:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2156' AND id_document != '97742' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 01/09/2025 05:14:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2156', document_date = '2025-06-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 = '238.10', price_tax_excluded = '209.70', date_upd = NOW() WHERE id_document = '97742' 01/09/2025 05:14:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97742' 01/09/2025 05:14:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '97742' 01/09/2025 05:14:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97742' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 01/09/2025 05:14:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97742' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 01/09/2025 05:14: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 ( '97742' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '6' , '-6' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '27.00' ) 01/09/2025 05:14: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 ( '97742' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 01/09/2025 05:14: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 ( '97742' , '22672' , 'PORTATECA CAMOSCIO E TECA - A26' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 01/09/2025 05:14: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 ( '97742' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '-1' , '4' , '16.1000' , '16.1' , '0' , '0' , '16.10' ) 01/09/2025 05:14: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 ( '97742' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 01/09/2025 05:15:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2502' AND id_document != '98162' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-21') 01/09/2025 05:15:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2502', document_date = '2025-07-21', 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 = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '98162' 01/09/2025 05:15:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98162' 01/09/2025 05:15:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '98162' 01/09/2025 05:15:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98162' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.6' , '7.0491803278689' , '22' , '0' , '8.60' ) 01/09/2025 05:15:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98162' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 01/09/2025 05:17:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2546' AND id_document != '98219' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 01/09/2025 05:17:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2546', document_date = '2025-07-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '514.00', price_tax_excluded = '421.31', date_upd = NOW() WHERE id_document = '98219' 01/09/2025 05:17: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 = '98219' 01/09/2025 05:17:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '98219' 01/09/2025 05:17: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 ( '98219' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '264' , '216.39344262295' , '22' , '0' , '264.00' ) 01/09/2025 05:17: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 ( '98219' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 01/09/2025 05:17: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 ( '98219' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '28.00' ) 01/09/2025 05:17: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 ( '98219' , '19973' , 'AMPOLLINE - ART. 194/1' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 01/09/2025 05:17:44 pm >> 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') 01/09/2025 05:17:44 pm >> 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' 01/09/2025 05:17: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 = '97693' 01/09/2025 05:17:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '97693' 01/09/2025 05:17: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 ( '97693' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 01/09/2025 05:17: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 ( '97693' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 01/09/2025 05:17: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 ( '97693' , '22352' , 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K' , '10' , '-10' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '14.00' ) 01/09/2025 05:17: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 ( '97693' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 01/09/2025 05:17: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 ( '97693' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 01/09/2025 05:17: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 ( '97693' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 01/09/2025 05:19:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2546' AND id_document != '98219' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 01/09/2025 05:19:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2546', document_date = '2025-07-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '514.00', price_tax_excluded = '421.31', date_upd = NOW() WHERE id_document = '98219' 01/09/2025 05:19:01 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 = '98219' 01/09/2025 05:19:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '98219' 01/09/2025 05:19:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98219' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 01/09/2025 05:19: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 ( '98219' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '28.00' ) 01/09/2025 05:19: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 ( '98219' , '19973' , 'AMPOLLINE - ART. 194/1' , '1' , '-1' , '1' , '200.0000' , '163.93442622951' , '22' , '0' , '200.00' ) 01/09/2025 05:19: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 ( '98219' , '17408' , 'CAMICE MISTO COT. 70/001035' , '2' , '-2' , '1' , '132' , '108.19672131148' , '22' , '0' , '264.00' ) 01/09/2025 05:19:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2268' AND id_document != '97878' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-26') 01/09/2025 05:19:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2268', document_date = '2025-06-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '116.00', price_tax_excluded = '95.08', date_upd = NOW() WHERE id_document = '97878' 01/09/2025 05:19:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97878' 01/09/2025 05:19:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '97878' 01/09/2025 05:19:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97878' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 01/09/2025 05:19:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97878' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 01/09/2025 05:20:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2126' AND id_document != '97709' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-13') 01/09/2025 05:20:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2126', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '97709' 01/09/2025 05:20:04 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 = '97709' 01/09/2025 05:20:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '97709' 01/09/2025 05:20:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97709' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 01/09/2025 05:20:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2225' AND id_document != '97823' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 01/09/2025 05:20:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2225', document_date = '2025-06-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '39.50', price_tax_excluded = '32.38', date_upd = NOW() WHERE id_document = '97823' 01/09/2025 05:20:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97823' 01/09/2025 05:20:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '97823' 01/09/2025 05:20:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97823' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '39.5' , '32.377049180328' , '22' , '0' , '39.50' ) 01/09/2025 05:21:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2570' AND id_document != '98245' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-25') 01/09/2025 05:21:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2570', document_date = '2025-07-25', 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 = '117.00', price_tax_excluded = '96.26', date_upd = NOW() WHERE id_document = '98245' 01/09/2025 05:21:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98245' 01/09/2025 05:21:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '98245' 01/09/2025 05:21:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98245' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '80.00' ) 01/09/2025 05:21:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98245' , '8765' , 'QUINDICI ORAZIONI DI SANTA BRIGIDA - 8193' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 01/09/2025 05:21:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98245' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 01/09/2025 05:23:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2182' AND id_document != '97774' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-19') 01/09/2025 05:23:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2182', document_date = '2025-06-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '122.00', price_tax_excluded = '100.00', date_upd = NOW() WHERE id_document = '97774' 01/09/2025 05:23:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97774' 01/09/2025 05:23:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '97774' 01/09/2025 05:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 01/09/2025 05:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 01/09/2025 05:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '2' , '-2' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '2.60' ) 01/09/2025 05:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '1' , '-1' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '1.40' ) 01/09/2025 05:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '18080' , 'BAMBINO DI PRAGA CM 20 - 311' , '1' , '-1' , '1' , '32.0000' , '26.229508196721' , '22' , '0' , '32.00' ) 01/09/2025 05:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 01/09/2025 05:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '5107' , 'SAN GIOVANNI BATTISTA - 63' , '8' , '-8' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '24.00' ) 01/09/2025 05:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '5108' , 'SAN GIOVANNI PAOLO II - 366' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 01/09/2025 05:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 01/09/2025 05:23:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2578' AND id_document != '98254' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-25') 01/09/2025 05:23:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2578', document_date = '2025-07-25', 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 = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '98254' 01/09/2025 05:23:56 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 = '98254' 01/09/2025 05:23:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '98254' 01/09/2025 05:23:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98254' , '22294' , 'RELIQUIARIO CON PIETRE CM 32' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 01/09/2025 05:25:19 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') 01/09/2025 05:25:19 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' 01/09/2025 05:25:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98047' 01/09/2025 05:25:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '98047' 01/09/2025 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98047' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.5000' , '29.918032786885' , '22' , '0' , '36.50' ) 01/09/2025 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98047' , '2177' , 'CLERGY BASIC - MM - B&P' , '2' , '-2' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '70.00' ) 01/09/2025 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98047' , '23858' , 'TALARE FRESCO LANA 100% - 88/000100' , '1' , '-1' , '1' , '930.0000' , '762.29508196721' , '22' , '0' , '930.00' ) 01/09/2025 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98047' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '98.5' , '80.737704918033' , '22' , '0' , '98.50' ) 01/09/2025 05:32:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 05:32:26 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' , '2798' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.40' , '11.76' , NOW() , NOW() ) 01/09/2025 05:32:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98522' 01/09/2025 05:32:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '98522' 01/09/2025 05:32:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98522' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 01/09/2025 05:32:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98522' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 01/09/2025 05:32:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98522' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 01/09/2025 05:55:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2799' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 05:55:52 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' , '2799' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/09/2025 05:55:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98523' 01/09/2025 05:55:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '98523' 01/09/2025 05:55:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98523' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2025 06:12:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 06:12:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2800' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/09/2025 06:12:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98524' 01/09/2025 06:12:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '98524' 01/09/2025 06:12:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98524' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2025 06:18:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2801' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 06:18: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' , '2801' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '10.58' , NOW() , NOW() ) 01/09/2025 06:18: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 = '98525' 01/09/2025 06:18:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '98525' 01/09/2025 06:18: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 ( '98525' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 01/09/2025 06:18: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 ( '98525' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 01/09/2025 06:22:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2802' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 06:22:26 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' , '2802' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 01/09/2025 06:22:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98526' 01/09/2025 06:22:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '98526' 01/09/2025 06:22:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98526' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 01/09/2025 06:22:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98526' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 01/09/2025 06:24:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2803' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 06:24:30 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' , '2803' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '240.00' , '202.41' , NOW() , NOW() ) 01/09/2025 06:24:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98527' 01/09/2025 06:24:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '98527' 01/09/2025 06:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98527' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.1' , '14.016393442623' , '22' , '0' , '17.10' ) 01/09/2025 06:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98527' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 01/09/2025 06:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98527' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 01/09/2025 06:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98527' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 01/09/2025 06:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98527' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 01/09/2025 06:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98527' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '39.00' ) 01/09/2025 06:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98527' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 01/09/2025 06:26:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2804' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 06:26:05 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' , '2804' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '40.00' , NOW() , NOW() ) 01/09/2025 06:26:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98528' 01/09/2025 06:26:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '98528' 01/09/2025 06:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98528' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '0' , '40.00' ) 01/09/2025 06:34:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2805' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 06:34: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' , '2805' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 01/09/2025 06:34: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 = '98529' 01/09/2025 06:34:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '98529' 01/09/2025 06:34: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 ( '98529' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 01/09/2025 07:05:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2806' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 07:05: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' , '2806' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '319.00' , '261.48' , NOW() , NOW() ) 01/09/2025 07:05: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 = '98530' 01/09/2025 07:05:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '98530' 01/09/2025 07:05: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 ( '98530' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '319' , '261.47540983607' , '22' , '0' , '319.00' ) 01/09/2025 07:08:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2807' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 07:08:34 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' , '2807' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 01/09/2025 07:08:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98531' 01/09/2025 07:08:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '98531' 01/09/2025 07:08:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98531' , '17986' , 'PATENA 15,5 - 1900' , '1' , '-1' , '1' , '51.00' , '41.803278688525' , '22' , '0' , '51.00' ) 01/09/2025 07:10:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2808' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 07:10: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' , '2808' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.10' , '11.10' , NOW() , NOW() ) 01/09/2025 07:10: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 = '98532' 01/09/2025 07:10:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '98532' 01/09/2025 07:10: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 ( '98532' , '23807' , 'CALENDARIO LITURGICO 2026' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 01/09/2025 07:10: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 ( '98532' , '23690' , 'CARLO ACUTIS E IL POTERE DELLAMICIZIA - M.T. ANTOGNAZZA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '0' , '9.50' ) 01/09/2025 07:13:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2809' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 07:13: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' , '2809' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 01/09/2025 07:13: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 = '98533' 01/09/2025 07:13:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '98533' 01/09/2025 07:13: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 ( '98533' , '18184' , 'STOLA RASO CON RICAMO UVA - 7877' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 01/09/2025 07:14:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2810' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 07:14:50 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' , '2810' , '2025-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 01/09/2025 07:14:50 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 = '98534' 01/09/2025 07:14:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '98534' 01/09/2025 07:14:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98534' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 01/09/2025 07:21:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2806' AND id_document != '98530' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-01') 01/09/2025 07:21:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2806', document_date = '2025-09-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 = '319.00', price_tax_excluded = '261.48', date_upd = NOW() WHERE id_document = '98530' 01/09/2025 07:21:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98530' 01/09/2025 07:21:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '98530' 01/09/2025 07:21:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98530' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '319.0000' , '261.47540983607' , '22' , '0' , '319.00' ) 01/09/2025 07:22:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2698' AND id_document != '98411' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 01/09/2025 07:22:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2698', document_date = '2025-08-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '400.00', price_tax_excluded = '337.25', date_upd = NOW() WHERE id_document = '98411' 01/09/2025 07:22:53 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 = '98411' 01/09/2025 07:22:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '98411' 01/09/2025 07:22:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98411' , '19351' , 'SERVIZIO MESSA MISTO LINO - 7050' , '1' , '-1' , '1' , '52.0000' , '42.622950819672' , '22' , '0' , '52.00' ) 01/09/2025 07:22:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98411' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 01/09/2025 07:22:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98411' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.0000' , '52' , '0' , '0' , '52.00' ) 01/09/2025 07:22:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98411' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 01/09/2025 07:22:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98411' , '22648' , 'COMPLETO MESSA LINO - 60/1014' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' )