27/09/2025 09:04:58 am >> UPDATE ps_document SET id_document_type = '31', document_num = '000275/25', document_date = '2025-09-16', document_letter = '25', id_customer = '0', id_supplier = '0', id_address = '4671003', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '85.00', price_tax_excluded = '85.00', date_upd = NOW() WHERE id_document = '98807' 27/09/2025 09:04:58 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 = '98807' 27/09/2025 09:04:58 am >> DELETE FROM ps_document_detail WHERE id_document = '98807' 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9516' , 'SAN TOMMASO APOSTOLO - G. POLIDORO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9475' , 'SAN MARCO EV. - G.PESENTI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '6062' , 'MADONNA DELLE GRAZIE - G. PESENTI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '24035' , 'UN ARCOBALENO DI SANTITA - SR C. SCANDURA' , '2' , '2' , '4' , '13.0000' , '13' , '0' , '50' , '13.00' ) 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '5' , '5' , '4' , '5.5000' , '5.5' , '0' , '50' , '13.75' ) 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '24036' , 'BEATO DOMENICO DA LENTINI' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9420' , 'SAN FRANCESCO DASSISI' , '2' , '2' , '4' , '5.5000' , '5.5' , '0' , '50' , '5.50' ) 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '24037' , 'SANTANTONIO IL SANTO DEL MONDO - L. GJERGJI' , '2' , '2' , '4' , '5.5000' , '5.5' , '0' , '50' , '5.50' ) 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9462' , 'SAN GIUSEPPE - T. STRAMARE' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/09/2025 09:04:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9438' , 'SAN GENNARO VESCOVO' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 27/09/2025 09:04: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 ( '98807' , '9487' , 'SAN MICHELE ARCANGELO - F.INNOCENTE' , '2' , '2' , '4' , '5.5000' , '5.5' , '0' , '50' , '5.50' ) 27/09/2025 09:04: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 ( '98807' , '19664' , 'ANTONIO ROSMINI - V. SALVOLDI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:04: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 ( '98807' , '9459' , 'SAN GIUDA TADDEO - M. SIGNORONI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/09/2025 09:04: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 ( '98807' , '23159' , 'EDITH STEIN - V. SALVOLDI' , '1' , '1' , '4' , '5.5000' , '5.5' , '0' , '50' , '2.75' ) 27/09/2025 09:04: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 ( '98807' , '9479' , 'SAN MATTEO APOSTOLO ED EVANGELISTA' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 27/09/2025 09:04: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 ( '98807' , '23726' , 'SAN GIUSEPPE MOSCATI - F. OCCHETTA' , '1' , '1' , '4' , '5.5000' , '5.5' , '0' , '50' , '2.75' ) 27/09/2025 09:04: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 ( '98807' , '24038' , 'VITA CRISTIANA 2026' , '2' , '2' , '4' , '7.0000' , '7' , '0' , '50' , '7.00' ) 27/09/2025 09:04: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 ( '98807' , '24039' , 'SANTANASTASIO - AAVV' , '1' , '1' , '4' , '5.5000' , '5.5' , '0' , '50' , '2.75' ) 27/09/2025 09:05:22 am >> UPDATE ps_document SET id_document_type = '31', document_num = '000275/25', document_date = '2025-09-16', document_letter = '25', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '85.00', price_tax_excluded = '85.00', date_upd = NOW() WHERE id_document = '98807' 27/09/2025 09:05:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98807' 27/09/2025 09:05:22 am >> DELETE FROM ps_document_detail WHERE id_document = '98807' 27/09/2025 09:05:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9516' , 'SAN TOMMASO APOSTOLO - G. POLIDORO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:05:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '9516' AND id_supplier = '17' 27/09/2025 09:05:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9516' , '17' , '1' ) 27/09/2025 09:05:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9475' , 'SAN MARCO EV. - G.PESENTI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:05:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '9475' AND id_supplier = '17' 27/09/2025 09:05:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9475' , '17' , '1' ) 27/09/2025 09:05:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/09/2025 09:05:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '7385' AND id_supplier = '17' 27/09/2025 09:05:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7385' , '17' , '1' ) 27/09/2025 09:05:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '6062' , 'MADONNA DELLE GRAZIE - G. PESENTI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:05:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '6062' AND id_supplier = '17' 27/09/2025 09:05:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6062' , '17' , '1' ) 27/09/2025 09:05:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '24035' , 'UN ARCOBALENO DI SANTITA - SR C. SCANDURA' , '2' , '2' , '4' , '13.0000' , '13' , '0' , '50' , '13.00' ) 27/09/2025 09:05:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24035' AND id_supplier = '17' 27/09/2025 09:05:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24035' , '17' , '1' ) 27/09/2025 09:05:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '5' , '5' , '4' , '5.5000' , '5.5' , '0' , '50' , '13.75' ) 27/09/2025 09:05:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '17' 27/09/2025 09:05:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '17' , '1' ) 27/09/2025 09:05:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '24036' , 'BEATO DOMENICO DA LENTINI' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 27/09/2025 09:05:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24036' AND id_supplier = '17' 27/09/2025 09:05:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24036' , '17' , '1' ) 27/09/2025 09:05:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9420' , 'SAN FRANCESCO DASSISI' , '2' , '2' , '4' , '5.5000' , '5.5' , '0' , '50' , '5.50' ) 27/09/2025 09:05:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '9420' AND id_supplier = '17' 27/09/2025 09:05:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9420' , '17' , '1' ) 27/09/2025 09:05:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '24037' , 'SANTANTONIO IL SANTO DEL MONDO - L. GJERGJI' , '2' , '2' , '4' , '5.5000' , '5.5' , '0' , '50' , '5.50' ) 27/09/2025 09:05:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24037' AND id_supplier = '17' 27/09/2025 09:05:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24037' , '17' , '1' ) 27/09/2025 09:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9462' , 'SAN GIUSEPPE - T. STRAMARE' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/09/2025 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '9462' AND id_supplier = '17' 27/09/2025 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9462' , '17' , '1' ) 27/09/2025 09:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9438' , 'SAN GENNARO VESCOVO' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 27/09/2025 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '9438' AND id_supplier = '17' 27/09/2025 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9438' , '17' , '1' ) 27/09/2025 09:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9487' , 'SAN MICHELE ARCANGELO - F.INNOCENTE' , '2' , '2' , '4' , '5.5000' , '5.5' , '0' , '50' , '5.50' ) 27/09/2025 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '9487' AND id_supplier = '17' 27/09/2025 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9487' , '17' , '1' ) 27/09/2025 09:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '19664' , 'ANTONIO ROSMINI - V. SALVOLDI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19664' AND id_supplier = '17' 27/09/2025 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19664' , '17' , '1' ) 27/09/2025 09:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9459' , 'SAN GIUDA TADDEO - M. SIGNORONI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/09/2025 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '9459' AND id_supplier = '17' 27/09/2025 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9459' , '17' , '1' ) 27/09/2025 09:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '23159' , 'EDITH STEIN - V. SALVOLDI' , '1' , '1' , '4' , '5.5000' , '5.5' , '0' , '50' , '2.75' ) 27/09/2025 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '23159' AND id_supplier = '17' 27/09/2025 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23159' , '17' , '1' ) 27/09/2025 09:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '9479' , 'SAN MATTEO APOSTOLO ED EVANGELISTA' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 27/09/2025 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '9479' AND id_supplier = '17' 27/09/2025 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9479' , '17' , '1' ) 27/09/2025 09:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '23726' , 'SAN GIUSEPPE MOSCATI - F. OCCHETTA' , '1' , '1' , '4' , '5.5000' , '5.5' , '0' , '50' , '2.75' ) 27/09/2025 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '23726' AND id_supplier = '17' 27/09/2025 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23726' , '17' , '1' ) 27/09/2025 09:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '24038' , 'VITA CRISTIANA 2026' , '2' , '2' , '4' , '7.0000' , '7' , '0' , '50' , '7.00' ) 27/09/2025 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '24038' AND id_supplier = '17' 27/09/2025 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24038' , '17' , '1' ) 27/09/2025 09:05:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98807' , '24039' , 'SANTANASTASIO - AAVV' , '1' , '1' , '4' , '5.5000' , '5.5' , '0' , '50' , '2.75' ) 27/09/2025 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '24039' AND id_supplier = '17' 27/09/2025 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24039' , '17' , '1' ) 27/09/2025 09:05:47 am >> UPDATE ps_document SET id_document_type = '31', document_num = '336/23', document_date = '2023-11-14', document_letter = '23', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = '', 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 = '56.75', price_tax_excluded = '56.75', date_upd = NOW() WHERE id_document = '89020' 27/09/2025 09:05:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89020' 27/09/2025 09:05:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89020' 27/09/2025 09:05:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9603' , 'SANTA RITA DA CASCIA - V. PERI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/09/2025 09:05:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '9603' AND id_supplier = '17' 27/09/2025 09:05:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9603' , '17' , '1' ) 27/09/2025 09:05:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '21843' , 'SAN GIOVANNI DI DIO - J. REDRADO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:05:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21843' AND id_supplier = '17' 27/09/2025 09:05:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21843' , '17' , '1' ) 27/09/2025 09:05:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/09/2025 09:05:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19667' AND id_supplier = '17' 27/09/2025 09:05:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19667' , '17' , '1' ) 27/09/2025 09:05:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '4926' , 'IGNAZIO DI LOYOLA - F. OCCHETTA' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/09/2025 09:05:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '4926' AND id_supplier = '17' 27/09/2025 09:05:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4926' , '17' , '1' ) 27/09/2025 09:05:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9454' , 'SAN GIOVANNI DELLA CROCE - G.PESENTI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:05:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '9454' AND id_supplier = '17' 27/09/2025 09:05:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9454' , '17' , '1' ) 27/09/2025 09:05:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9399' , 'SAN CAMILLO DE LELLIS - F. RUFFINI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/09/2025 09:05:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '9399' AND id_supplier = '17' 27/09/2025 09:05:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9399' , '17' , '1' ) 27/09/2025 09:05:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9429' , 'SAN FRANCESCO DI PAOLA - R. BENVENUTO' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 27/09/2025 09:05:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '9429' AND id_supplier = '17' 27/09/2025 09:05:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9429' , '17' , '1' ) 27/09/2025 09:05:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9420' , 'SAN FRANCESCO DASSISI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/09/2025 09:05:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '9420' AND id_supplier = '17' 27/09/2025 09:05:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9420' , '17' , '1' ) 27/09/2025 09:05:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/09/2025 09:05:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '7385' AND id_supplier = '17' 27/09/2025 09:05:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7385' , '17' , '1' ) 27/09/2025 09:05:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9441' , 'SAN GERARDO MAIELLA' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:05:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '9441' AND id_supplier = '17' 27/09/2025 09:05:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9441' , '17' , '1' ) 27/09/2025 09:05:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '21844' , 'SETTE DONI DELLO SPIRITO SANTO' , '20' , '20' , '4' , '0.6000' , '0.6' , '0' , '50' , '6.00' ) 27/09/2025 09:05:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21844' AND id_supplier = '17' 27/09/2025 09:05:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21844' , '17' , '1' ) 27/09/2025 09:05:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9513' , 'SAN SIMONE APOSTOLO - F. INNOCENTE' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:05:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '9513' AND id_supplier = '17' 27/09/2025 09:05:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9513' , '17' , '1' ) 27/09/2025 09:05:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9516' , 'SAN TOMMASO APOSTOLO - G. POLIDORO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:05:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '9516' AND id_supplier = '17' 27/09/2025 09:05:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9516' , '17' , '1' ) 27/09/2025 09:05:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9630' , 'SANTI FILIPPO E GIACOMO APOSTOLI - A. GOVERNALE' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/09/2025 09:05:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '9630' AND id_supplier = '17' 27/09/2025 09:05:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9630' , '17' , '1' ) 27/09/2025 09:05:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '21845' , 'VIENI SIGNORE GESU!' , '3' , '3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 27/09/2025 09:05:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21845' AND id_supplier = '17' 27/09/2025 09:05:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21845' , '17' , '1' ) 27/09/2025 09:05:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '21846' , 'AGENDINA VITA CRISTIANA 2024' , '3' , '3' , '4' , '7.0000' , '7' , '0' , '50' , '10.50' ) 27/09/2025 09:05:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21846' AND id_supplier = '17' 27/09/2025 09:05:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21846' , '17' , '1' ) 27/09/2025 09:06:01 am >> UPDATE ps_supplier SET active = '0' , date_upd = NOW() WHERE id_supplier = '189' 27/09/2025 09:06:01 am >> UPDATE ps_address SET deleted='1' , active = '0' , date_upd = NOW() WHERE id_supplier = '189' 27/09/2025 09:06:04 am >> UPDATE ps_supplier SET active = '0' , date_upd = NOW() WHERE id_supplier = '194' 27/09/2025 09:06:04 am >> UPDATE ps_address SET deleted='1' , active = '0' , date_upd = NOW() WHERE id_supplier = '194' 27/09/2025 09:06:06 am >> UPDATE ps_supplier SET active = '0' , date_upd = NOW() WHERE id_supplier = '196' 27/09/2025 09:06:06 am >> UPDATE ps_address SET deleted='1' , active = '0' , date_upd = NOW() WHERE id_supplier = '196' 27/09/2025 09:06:08 am >> UPDATE ps_supplier SET active = '0' , date_upd = NOW() WHERE id_supplier = '198' 27/09/2025 09:06:08 am >> UPDATE ps_address SET deleted='1' , active = '0' , date_upd = NOW() WHERE id_supplier = '198' 27/09/2025 09:06:10 am >> UPDATE ps_supplier SET active = '0' , date_upd = NOW() WHERE id_supplier = '200' 27/09/2025 09:06:10 am >> UPDATE ps_address SET deleted='1' , active = '0' , date_upd = NOW() WHERE id_supplier = '200' 27/09/2025 09:06:11 am >> UPDATE ps_supplier SET active = '0' , date_upd = NOW() WHERE id_supplier = '202' 27/09/2025 09:06:11 am >> UPDATE ps_address SET deleted='1' , active = '0' , date_upd = NOW() WHERE id_supplier = '202' 27/09/2025 09:06:13 am >> UPDATE ps_supplier SET active = '0' , date_upd = NOW() WHERE id_supplier = '204' 27/09/2025 09:06:13 am >> UPDATE ps_address SET deleted='1' , active = '0' , date_upd = NOW() WHERE id_supplier = '204' 27/09/2025 09:51:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3134' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-27') 27/09/2025 09:51:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3134' , '2025-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.20' , '14.10' , NOW() , NOW() ) 27/09/2025 09:51:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98937' 27/09/2025 09:51:06 am >> DELETE FROM ps_document_detail WHERE id_document = '98937' 27/09/2025 09:51:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98937' , '6403' , 'MENSA BIANCA 80X150 ' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 27/09/2025 09:51:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98937' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 27/09/2025 10:17:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000405' AND id_product != '6403' AND ean13 != '' 27/09/2025 10:17:42 am >> UPDATE ps_product SET id_supplier = '31', reference = '', ean13 = '000405', date_upd = NOW() WHERE id_product = '6403' 27/09/2025 10:17:42 am >> UPDATE ps_product_lang SET name = 'MENSA BIANCA 80X150 ', description = '' WHERE id_product = '6403' 27/09/2025 10:17:42 am >> UPDATE ps_product SET wholesale_price = '2.70', on_sale = '0', price = '6.1475' WHERE id_product = '6403' 27/09/2025 10:17:43 am >> UPDATE ps_product_shop SET wholesale_price = '2.70', price = '6.1475', id_tax_rules_group = '1', id_category_default = '169', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6403' 27/09/2025 10:17:43 am >> DELETE FROM ps_specific_price WHERE id_product = '6403' 27/09/2025 10:18:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2607' AND id_document != '98287' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-30') 27/09/2025 10:18:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2607', document_date = '2025-07-30', 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 = '98287' 27/09/2025 10:18:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98287' 27/09/2025 10:18:27 am >> DELETE FROM ps_document_detail WHERE id_document = '98287' 27/09/2025 10:18:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98287' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 27/09/2025 10:18:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98287' , '11624' , 'PALLA 16X16 - SERV 3 ' , '3' , '-3' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '15.00' ) 27/09/2025 10:18:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98287' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 27/09/2025 10:18:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98287' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '3' , '-3' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '18.00' ) 27/09/2025 10:18:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98287' , '6403' , 'MENSA BIANCA 80X150 ' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 27/09/2025 10:26:08 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '8187' 27/09/2025 10:26:08 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '8187' 27/09/2025 10:31:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3135' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-27') 27/09/2025 10:31:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3135' , '2025-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.80' , '82.55' , NOW() , NOW() ) 27/09/2025 10:31: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 = '98938' 27/09/2025 10:31:56 am >> DELETE FROM ps_document_detail WHERE id_document = '98938' 27/09/2025 10:31: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 ( '98938' , '22257' , 'QUADRO DECORATO 36X22' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 27/09/2025 10:31: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 ( '98938' , '15932' , 'PORTAFOTO - PFR' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 27/09/2025 10:31: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 ( '98938' , '16904' , 'GIOVANNI, CHIAVI DI LETTURA DEL QUARTO VANGELO - F. LA GIOIA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 27/09/2025 10:31:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98938' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 27/09/2025 10:31:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98938' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 27/09/2025 10:37:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3136' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-27') 27/09/2025 10:37:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3136' , '2025-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.40' , '39.29' , NOW() , NOW() ) 27/09/2025 10:37:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98939' 27/09/2025 10:37:47 am >> DELETE FROM ps_document_detail WHERE id_document = '98939' 27/09/2025 10:37:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98939' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 27/09/2025 10:37:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98939' , '23807' , 'CALENDARIO LITURGICO 2026' , '3' , '-3' , '4' , '0.80' , '0.8' , '0' , '0' , '2.40' ) 27/09/2025 11:15:50 am >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '98376' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-06') 27/09/2025 11:15:50 am >> UPDATE ps_document SET id_document_type = '24', document_num = '108/A', document_date = '2025-08-06', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. 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 = '0', id_causal = '0', price_tax_included = '413.85', price_tax_excluded = '350.70', date_upd = NOW() WHERE id_document = '98376' 27/09/2025 11:15:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98376' 27/09/2025 11:15:50 am >> DELETE FROM ps_document_detail WHERE id_document = '98376' 27/09/2025 11:15: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 ( '98376' , '1914' , 'CERA DELLA LITURGIA' , '36' , '-36' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '169.20' ) 27/09/2025 11:15: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 ( '98376' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 27/09/2025 11:15: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 ( '98376' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 27/09/2025 11:15: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 ( '98376' , '23975' , 'MESSALINO QUOTIDIANO - NOV DIC GEN' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 27/09/2025 11:15: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 ( '98376' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 27/09/2025 11:15: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 ( '98376' , '3908' , 'ESERCIZI SPIRITUALI - IGNAZIO DI LOYOLA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 27/09/2025 11:15: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 ( '98376' , '18114' , 'MIA VITA - TERESA DI GESU' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '5' , '26.60' ) 27/09/2025 11:15: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 ( '98376' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 27/09/2025 11:15: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 ( '98376' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 27/09/2025 11:15: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 ( '98376' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '100' , '0.00' ) 27/09/2025 11:15: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 ( '98376' , '24082' , 'INNESTO PER CERO PASQUALE - 167/G' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 27/09/2025 11:15: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 ( '98376' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 27/09/2025 11:15: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 ( '98376' , '24080' , 'SAN FRANCESCO - A. BARBERO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 27/09/2025 11:22:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3137' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-27') 27/09/2025 11:22:01 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' , '3137' , '2025-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.20' , '89.94' , NOW() , NOW() ) 27/09/2025 11:22:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98940' 27/09/2025 11:22:01 am >> DELETE FROM ps_document_detail WHERE id_document = '98940' 27/09/2025 11:22:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98940' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '5' , '13.30' ) 27/09/2025 11:22:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98940' , '20556' , 'CROCE ULIVO CM 22 - PG036' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 27/09/2025 11:22:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98940' , '9209' , 'SACRA FAMIGLIA BABY - PB19080' , '5' , '-5' , '1' , '12.90' , '10.573770491803' , '22' , '0' , '64.50' ) 27/09/2025 11:22:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98940' , '23807' , 'CALENDARIO LITURGICO 2026' , '3' , '-3' , '4' , '0.80' , '0.8' , '0' , '0' , '2.40' ) 27/09/2025 11:44:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3138' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-27') 27/09/2025 11:44:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3138' , '2025-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 27/09/2025 11:44:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98941' 27/09/2025 11:44:52 am >> DELETE FROM ps_document_detail WHERE id_document = '98941' 27/09/2025 11:44:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98941' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/09/2025 11:48:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3139' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-27') 27/09/2025 11:48:10 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' , '3139' , '2025-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 27/09/2025 11:48:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98942' 27/09/2025 11:48:10 am >> DELETE FROM ps_document_detail WHERE id_document = '98942' 27/09/2025 11:48:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98942' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/09/2025 12:06:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3140' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-27') 27/09/2025 12:06: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' , '3140' , '2025-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '103.70' , '87.06' , NOW() , NOW() ) 27/09/2025 12:06: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 = '98943' 27/09/2025 12:06:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '98943' 27/09/2025 12:06: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 ( '98943' , '13334' , 'CROCE IN ULIVO CON LACCIO' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 27/09/2025 12:06: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 ( '98943' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 27/09/2025 12:06: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 ( '98943' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 27/09/2025 12:06: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 ( '98943' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 27/09/2025 12:06: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 ( '98943' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 27/09/2025 12:06: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 ( '98943' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '10' , '9.6153846153846' , '4' , '0' , '10.00' ) 27/09/2025 12:12:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3141' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-09-27') 27/09/2025 12:12:36 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' , '3141' , '2025-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '118.50' , '100.61' , NOW() , NOW() ) 27/09/2025 12:12: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 = '98944' 27/09/2025 12:12:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '98944' 27/09/2025 12:12: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 ( '98944' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 27/09/2025 12:12: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 ( '98944' , '5998' , 'LUME VETRO SOFFIATO - CM 20 - 1023' , '2' , '-2' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '84.00' ) 27/09/2025 12:12: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 ( '98944' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '100' , '0.00' ) 27/09/2025 12:12: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 ( '98944' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '2' , '-2' , '3' , '10' , '9.6153846153846' , '4' , '0' , '20.00' ) 27/09/2025 12:12: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 ( '98944' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 27/09/2025 12:12: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 ( '98944' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 27/09/2025 12:50:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3142' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-27') 27/09/2025 12:50: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' , '3142' , '2025-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 27/09/2025 12:50: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 = '98945' 27/09/2025 12:50:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '98945' 27/09/2025 12:50: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 ( '98945' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 27/09/2025 12:50: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 ( '98945' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' )