31/07/2025 08:49:03 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' , '705444' , '2025-07-29' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.58' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.54' , '66.54' , NOW() , NOW() ) 31/07/2025 08:49:03 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 = '98300' 31/07/2025 08:49:03 am >> DELETE FROM ps_document_detail WHERE id_document = '98300' 31/07/2025 08:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98300' , '1115' , 'BIBBIA DEGLI SPOSI' , '10' , '10' , '4' , '12.90' , '12.9' , '0' , '33+26' , '63.9582' ) 31/07/2025 08:49:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '1115' AND id_supplier = '7' 31/07/2025 08:49:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1115' , '7' , '1' ) 31/07/2025 08:56:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '4407/2025' , '2025-07-28' , '2025' , '0' , '129' , '4670237' , 'VIA ROMA, 10 54035 FOSDINOVO' , '' , '' , '4.51' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '222.06' , '182.02' , NOW() , NOW() ) 31/07/2025 08:56:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98301' 31/07/2025 08:56:29 am >> DELETE FROM ps_document_detail WHERE id_document = '98301' 31/07/2025 08:56:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98301' , '15541' , 'STOLA LINO/POL CON GIGLIUCCIO A MANO - 60/3096' , '2' , '2' , '1' , '91.5' , '75' , '22' , '3' , '216.5622' ) 31/07/2025 08:56:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '15541' AND id_supplier = '129' 31/07/2025 08:56:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15541' , '129' , '1' ) 31/07/2025 09:30:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2619' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 09:30:14 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' , '2619' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '24.50' , NOW() , NOW() ) 31/07/2025 09:30:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98302' 31/07/2025 09:30:14 am >> DELETE FROM ps_document_detail WHERE id_document = '98302' 31/07/2025 09:30:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98302' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 31/07/2025 09:56:31 am >> SELECT document_num FROM ps_document WHERE document_num = '83' AND id_document != '98091' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-07-15') 31/07/2025 09:56:31 am >> UPDATE ps_document SET id_document_type = '21', document_num = '83', document_date = '2025-07-15', document_letter = '', id_customer = '65', id_supplier = '', id_address = '4679517', address1 = 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE', address2 = '', note = '', price_shipping = '2.93', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '87.00', price_tax_excluded = '87.00', date_upd = NOW() WHERE id_document = '98091' 31/07/2025 09:56:31 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 = '98091' 31/07/2025 09:56:31 am >> DELETE FROM ps_document_detail WHERE id_document = '98091' 31/07/2025 09:56: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 ( '98091' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 31/07/2025 09:56: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 ( '98091' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.05' ) 31/07/2025 09:56: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 ( '98091' , '23853' , 'COMPRENDI DAVVERO LA MESSA? - 8184' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 31/07/2025 09:56: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 ( '98091' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 31/07/2025 09:56: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 ( '98091' , '23747' , 'PADRE NELLE TUE MANI... - E. DELLA CORTE' , '1' , '-1' , '4' , '32.0000' , '32' , '0' , '5' , '30.40' ) 31/07/2025 09:56: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 ( '98091' , '15019' , 'PREGHIAMO CON MARIA' , '12' , '-12' , '4' , '0.80' , '0.8' , '0' , '5' , '9.12' ) 31/07/2025 09:58:59 am >> SELECT document_num FROM ps_document WHERE document_num = '86' AND id_document != '98199' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-07-23') 31/07/2025 09:58:59 am >> UPDATE ps_document SET id_document_type = '21', document_num = '86', document_date = '2025-07-23', document_letter = '', id_customer = '3859', id_supplier = '', id_address = '4679261', address1 = 'VIA G.B.VENTURI , 140 42021 BIBBIANO', address2 = '', note = '', price_shipping = '3.46', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '38.26', price_tax_excluded = '38.26', date_upd = NOW() WHERE id_document = '98199' 31/07/2025 09:58: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 = '98199' 31/07/2025 09:58:59 am >> DELETE FROM ps_document_detail WHERE id_document = '98199' 31/07/2025 09:58: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 ( '98199' , '15019' , 'PREGHIAMO CON MARIA' , '30' , '-30' , '4' , '0.80' , '0.8' , '0' , '5' , '22.80' ) 31/07/2025 09:58: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 ( '98199' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '4' , '-4' , '4' , '3' , '3' , '0' , '0' , '12.00' ) 31/07/2025 10:16:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2620' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 10:16:28 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' , '2620' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.42' , '40.21' , NOW() , NOW() ) 31/07/2025 10:16: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 = '98303' 31/07/2025 10:16:28 am >> DELETE FROM ps_document_detail WHERE id_document = '98303' 31/07/2025 10:16: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 ( '98303' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/07/2025 10:16: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 ( '98303' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/07/2025 10:16: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 ( '98303' , '17934' , 'PURIFICHINO DORATO - 711' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 31/07/2025 11:22:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2620' AND id_document != '98303' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 11:22:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2620', document_date = '2025-07-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '47.42', price_tax_excluded = '40.21', date_upd = NOW() WHERE id_document = '98303' 31/07/2025 11:22:25 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 = '98303' 31/07/2025 11:22:25 am >> DELETE FROM ps_document_detail WHERE id_document = '98303' 31/07/2025 11:22:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98303' , '17934' , 'PURIFICHINO DORATO - 711' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 31/07/2025 11:22:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98303' , '23822' , 'AMEN - OTT 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/07/2025 11:22:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98303' , '23823' , 'AMEN - SET 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/07/2025 11:43: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 ( '32' , '1664/2025' , '2025-07-31' , '2025' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '11.51' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '88.13' , '72.24' , NOW() , NOW() ) 31/07/2025 11:43: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 = '98304' 31/07/2025 11:43:52 am >> DELETE FROM ps_document_detail WHERE id_document = '98304' 31/07/2025 11:43: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 ( '98304' , '22012' , 'CROCE SAN DAMIANO MOGANO 26X19 - PG092' , '1' , '0' , '1' , '11.5800' , '9.4918' , '22' , '10' , '12.71' ) 31/07/2025 11:43:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '22012' AND id_supplier = '43' 31/07/2025 11:43:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22012' , '43' , '1' ) 31/07/2025 11:43: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 ( '98304' , '23601' , 'STATUA SAN CARLO ACUTIS - ST213AC' , '1' , '0' , '1' , '13.1300' , '10.7623' , '22' , '10' , '14.42' ) 31/07/2025 11:43:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '23601' AND id_supplier = '43' 31/07/2025 11:43:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23601' , '43' , '1' ) 31/07/2025 11:43: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 ( '98304' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA810' , '1' , '0' , '1' , '4.9100' , '4.0246' , '22' , '10' , '5.39' ) 31/07/2025 11:43:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '19596' AND id_supplier = '43' 31/07/2025 11:43:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19596' , '43' , '1' ) 31/07/2025 11:43: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 ( '98304' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '200' , '0' , '1' , '0.1386' , '0.11360655737705' , '22' , '10' , '30.4366' ) 31/07/2025 11:43:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '16060' AND id_supplier = '43' 31/07/2025 11:43:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16060' , '43' , '1' ) 31/07/2025 11:43: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 ( '98304' , '16058' , 'MEDAGLIA S. GIUSEPPE - FM022' , '100' , '0' , '1' , '0.1014' , '0.0831' , '22' , '10' , '11.13' ) 31/07/2025 11:43:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '16058' AND id_supplier = '43' 31/07/2025 11:43:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16058' , '43' , '1' ) 31/07/2025 12:17:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2621' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 12:17:20 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' , '2621' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 31/07/2025 12:17: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 = '98305' 31/07/2025 12:17:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '98305' 31/07/2025 12:17: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 ( '98305' , '20069' , 'SACCHETTO' , '15' , '-15' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '3.00' ) 31/07/2025 12:17: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 ( '98305' , '7202' , 'ARTICOLI RELIGIOSI' , '15' , '-15' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '42.00' ) 31/07/2025 12:28:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2622' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 12:28: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' , '2622' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 31/07/2025 12:28: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 = '98306' 31/07/2025 12:28:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '98306' 31/07/2025 12:28: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 ( '98306' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '12.50' ) 31/07/2025 12:37:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2623' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 12:37: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' , '2623' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '25.00' , NOW() , NOW() ) 31/07/2025 12:37: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 = '98307' 31/07/2025 12:37:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '98307' 31/07/2025 12:37: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 ( '98307' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 31/07/2025 04:08:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2624' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 04:08:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2624' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.99' , '133.32' , NOW() , NOW() ) 31/07/2025 04:08:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98308' 31/07/2025 04:08:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '98308' 31/07/2025 04:08:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98308' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '9.99' ) 31/07/2025 04:08:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98308' , '19910' , 'LUCERNA COLORATA - 1490/KIT' , '1' , '-1' , '1' , '17.50' , '14.344262295082' , '22' , '0' , '17.50' ) 31/07/2025 04:08:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98308' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 31/07/2025 04:08:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98308' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 31/07/2025 04:08:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98308' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 31/07/2025 04:33:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2625' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 04:33:37 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' , '2625' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '432.00' , '354.10' , NOW() , NOW() ) 31/07/2025 04:33: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 = '98309' 31/07/2025 04:33:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '98309' 31/07/2025 04:33: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 ( '98309' , '23849' , 'CALICE ULIVO COPPA METALLO - 244/0' , '1' , '-1' , '1' , '400' , '327.86885245902' , '22' , '0' , '400.00' ) 31/07/2025 04:33: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 ( '98309' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '1' , '32.00' , '26.229508196721' , '22' , '0' , '32.00' ) 31/07/2025 04:35:08 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/07/2025 04:35:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23916' , '1' , '' , 'nuovo-prodotto' ) 31/07/2025 04:35:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23916' , '1' , '1' , '2' , NOW() , NOW() ) 31/07/2025 04:35:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23916' , '0' , '1' , '0' , '0' ) 31/07/2025 04:36:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832715026' AND id_product != '23916' AND ean13 != '' 31/07/2025 04:36:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832715026', date_upd = NOW() WHERE id_product = '23916' 31/07/2025 04:36:44 pm >> UPDATE ps_product_lang SET name = 'C\'E\' SPAZIO PER TE 2026 - 3-5 ANNI', description = '' WHERE id_product = '23916' 31/07/2025 04:36:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '23916' 31/07/2025 04:36:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23916' 31/07/2025 04:36:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '23916' 31/07/2025 04:36:45 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23916' 31/07/2025 04:36:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23917' , '1' , '' , 'nuovo-prodotto' ) 31/07/2025 04:36:45 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23917' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23916' 31/07/2025 04:36:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23917' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23916' 31/07/2025 04:37:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832715033' AND id_product != '23917' AND ean13 != '' 31/07/2025 04:37:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832715033', date_upd = NOW() WHERE id_product = '23917' 31/07/2025 04:37:08 pm >> UPDATE ps_product_lang SET name = 'C\'E\' SPAZIO PER TE 2026 - 6-8 ANNI', description = '' WHERE id_product = '23917' 31/07/2025 04:37:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '23917' 31/07/2025 04:37:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23917' 31/07/2025 04:37:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '23917' 31/07/2025 04:37:09 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23917' 31/07/2025 04:37:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23918' , '1' , '' , 'nuovo-prodotto' ) 31/07/2025 04:37:09 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23918' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23917' 31/07/2025 04:37:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23918' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23917' 31/07/2025 04:37:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832715040' AND id_product != '23918' AND ean13 != '' 31/07/2025 04:37:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832715040', date_upd = NOW() WHERE id_product = '23918' 31/07/2025 04:37:30 pm >> UPDATE ps_product_lang SET name = 'C\'E\' SPAZIO PER TE 2026 - 9-11 ANNI', description = '' WHERE id_product = '23918' 31/07/2025 04:37:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '23918' 31/07/2025 04:37:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23918' 31/07/2025 04:37:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '23918' 31/07/2025 04:37:31 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23918' 31/07/2025 04:37:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23919' , '1' , '' , 'nuovo-prodotto' ) 31/07/2025 04:37:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23919' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23918' 31/07/2025 04:37:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23919' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23918' 31/07/2025 04:37:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832715057' AND id_product != '23919' AND ean13 != '' 31/07/2025 04:37:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832715057', date_upd = NOW() WHERE id_product = '23919' 31/07/2025 04:37:56 pm >> UPDATE ps_product_lang SET name = 'C\'E\' SPAZIO PER TE 2026 - 12-14 ANNI', description = '' WHERE id_product = '23919' 31/07/2025 04:37:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '23919' 31/07/2025 04:37:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23919' 31/07/2025 04:37:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '23919' 31/07/2025 04:37:57 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23919' 31/07/2025 04:37:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23920' , '1' , '' , 'nuovo-prodotto' ) 31/07/2025 04:37:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23920' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23919' 31/07/2025 04:37:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23920' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23919' 31/07/2025 04:38:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832715064' AND id_product != '23920' AND ean13 != '' 31/07/2025 04:38:45 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832715064', date_upd = NOW() WHERE id_product = '23920' 31/07/2025 04:38:45 pm >> UPDATE ps_product_lang SET name = 'WORK IN PROGRESS ANNO A - EDUCATORI', description = '' WHERE id_product = '23920' 31/07/2025 04:38:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '23920' 31/07/2025 04:38:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23920' 31/07/2025 04:38:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '23920' 31/07/2025 04:38:46 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23920' 31/07/2025 04:38:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23921' , '1' , '' , 'nuovo-prodotto' ) 31/07/2025 04:38:46 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23921' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23920' 31/07/2025 04:38:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23921' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23920' 31/07/2025 04:39:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810916728' AND id_product != '23921' AND ean13 != '' 31/07/2025 04:39:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810916728', date_upd = NOW() WHERE id_product = '23921' 31/07/2025 04:39:30 pm >> UPDATE ps_product_lang SET name = 'GESU\' CRISTO, FIGLIO DI DIO', description = '' WHERE id_product = '23921' 31/07/2025 04:39:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '23921' 31/07/2025 04:39:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23921' 31/07/2025 04:39:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '23921' 31/07/2025 04:39:32 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23921' 31/07/2025 04:39:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23922' , '1' , '' , 'nuovo-prodotto' ) 31/07/2025 04:39:32 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23922' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23921' 31/07/2025 04:39:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23922' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23921' 31/07/2025 04:41:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831114493' AND id_product != '3908' AND ean13 != '' 31/07/2025 04:41:02 pm >> UPDATE ps_product SET id_supplier = '109', reference = '7/2', ean13 = '9788831114493', date_upd = NOW() WHERE id_product = '3908' 31/07/2025 04:41:02 pm >> UPDATE ps_product_lang SET name = 'ESERCIZI SPIRITUALI - IGNAZIO DI LOYOLA', description = '' WHERE id_product = '3908' 31/07/2025 04:41:02 pm >> UPDATE ps_product SET wholesale_price = '4.23', on_sale = '0', price = '8' WHERE id_product = '3908' 31/07/2025 04:41:02 pm >> UPDATE ps_product_shop SET wholesale_price = '4.23', price = '8', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3908' 31/07/2025 04:41:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '3908' 31/07/2025 04:43:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '00227054' , '2025-07-29' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '147.23' , '147.23' , NOW() , NOW() ) 31/07/2025 04:43: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 = '98310' 31/07/2025 04:43:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '98310' 31/07/2025 04:43: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 ( '98310' , '3908' , 'ESERCIZI SPIRITUALI - IGNAZIO DI LOYOLA' , '2' , '2' , '4' , '8.00' , '8' , '0' , '30' , '11.2000' ) 31/07/2025 04:43:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3908' AND id_supplier = '109' 31/07/2025 04:43:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3908' , '109' , '1' ) 31/07/2025 04:43: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 ( '98310' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 31/07/2025 04:43:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17413' AND id_supplier = '109' 31/07/2025 04:43:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17413' , '109' , '1' ) 31/07/2025 04:43: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 ( '98310' , '23921' , 'GESU CRISTO, FIGLIO DI DIO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '40' , '6.0000' ) 31/07/2025 04:43:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23921' AND id_supplier = '109' 31/07/2025 04:43:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23921' , '109' , '1' ) 31/07/2025 04:43: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 ( '98310' , '23918' , 'CE SPAZIO PER TE 2026 - 9-11 ANNI' , '3' , '3' , '4' , '16.50' , '16.5' , '0' , '25' , '37.1250' ) 31/07/2025 04:43:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23918' AND id_supplier = '109' 31/07/2025 04:43:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23918' , '109' , '1' ) 31/07/2025 04:43: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 ( '98310' , '23917' , 'CE SPAZIO PER TE 2026 - 6-8 ANNI' , '2' , '2' , '4' , '16.50' , '16.5' , '0' , '25' , '24.7500' ) 31/07/2025 04:43:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23917' AND id_supplier = '109' 31/07/2025 04:43:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23917' , '109' , '1' ) 31/07/2025 04:43: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 ( '98310' , '23919' , 'CE SPAZIO PER TE 2026 - 12-14 ANNI' , '3' , '3' , '4' , '16.50' , '16.5' , '0' , '25' , '37.1250' ) 31/07/2025 04:43:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23919' AND id_supplier = '109' 31/07/2025 04:43:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23919' , '109' , '1' ) 31/07/2025 04:43: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 ( '98310' , '23920' , 'WORK IN PROGRESS ANNO A - EDUCATORI' , '1' , '1' , '4' , '7.00' , '7' , '0' , '25' , '5.2500' ) 31/07/2025 04:43:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23920' AND id_supplier = '109' 31/07/2025 04:43:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23920' , '109' , '1' ) 31/07/2025 04:43: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 ( '98310' , '23916' , 'CE SPAZIO PER TE 2026 - 3-5 ANNI' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '25' , '12.3750' ) 31/07/2025 04:43:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23916' AND id_supplier = '109' 31/07/2025 04:43:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23916' , '109' , '1' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2025010001272' , '2025-07-31' , '' , '0' , '0' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '122.03' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4944.36' , '4944.36' , NOW() , NOW() ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98311' 31/07/2025 04:47:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '98311' 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '9017' , 'RITO DELLA PENITENZA' , '3' , '0' , '4' , '10.5000' , '10.5' , '0' , '22' , '24.57' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '9013' , 'RITO DELL\'INIZIAZIONE CRISTIANA DEGLI ADULTI' , '5' , '0' , '4' , '20.6600' , '20.66' , '0' , '22' , '80.57' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '5' , '0' , '4' , '25.0000' , '25' , '0' , '22' , '97.50' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '3' , '0' , '4' , '60.0000' , '60' , '0' , '22' , '140.40' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '3' , '0' , '4' , '60.0000' , '60' , '0' , '22' , '140.40' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '5' , '0' , '4' , '110.0000' , '110' , '0' , '22' , '429.00' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '17330' , 'MESSALE ROMANO DALTARE N. E. TAGLIO ORO' , '1' , '0' , '4' , '130.0000' , '130' , '0' , '22' , '101.40' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '18580' , 'ORAZIONALE PER LA PREGHIERA UNIVERSALE - N.E.' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '22' , '23.40' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '22112' , 'LITURGIA DELLE ORE VOL. III - N.E.' , '3' , '0' , '4' , '35.0000' , '35' , '0' , '22' , '81.90' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '2' , '0' , '4' , '60.0000' , '60' , '0' , '22' , '93.60' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '3' , '0' , '4' , '35.0000' , '35' , '0' , '22' , '81.90' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '3' , '0' , '4' , '35.0000' , '35' , '0' , '22' , '81.90' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '5' , '0' , '4' , '20.0000' , '20' , '0' , '22' , '78.00' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '5' , '0' , '4' , '20.0000' , '20' , '0' , '22' , '78.00' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '21655' , 'BENEDIZIONALE N. E. ' , '5' , '0' , '4' , '40.0000' , '40' , '0' , '22' , '156.00' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '5' , '0' , '4' , '30.0000' , '30' , '0' , '22' , '117.00' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '21656' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE N.E.' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '22' , '46.80' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '23859' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '30' , '0' , '4' , '5.5000' , '5.5' , '0' , '22' , '128.70' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '5444' , 'IO SONO CON VOI - CAT.' , '334' , '0' , '4' , '5.5000' , '5.5' , '0' , '22' , '1432.86' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '11193' , 'VENITE CON ME CAT.' , '198' , '0' , '4' , '5.5000' , '5.5' , '0' , '22' , '849.42' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '5754' , 'LEZIONARI KIT CELEBRAZIONE DEI SANTI' , '1' , '0' , '4' , '250.0000' , '250' , '0' , '22' , '195.00' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '51' , '0' , '4' , '5.5000' , '5.5' , '0' , '22' , '218.79' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '3' , '0' , '4' , '35.0000' , '35' , '0' , '22' , '81.90' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '23863' , 'NELLA LITURGIA LA VERA PREGHIERA DELLA CHIESA ' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '8798' , 'RACCONTO DI MATTEO - B. MAGGIONI' , '1' , '0' , '4' , '22.5000' , '22.5' , '0' , '35' , '14.63' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '818' , 'ATTI DEGLI APOSTOLI - B. MAGGIONI' , '1' , '0' , '4' , '14.9000' , '14.9' , '0' , '35' , '9.69' ) 31/07/2025 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98311' , '23864' , 'MARIOLOGIA BIBBLICA - S. MANELLI' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 31/07/2025 05:24:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2626' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 05:24:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2626' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.00' , '57.20' , NOW() , NOW() ) 31/07/2025 05:24:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98312' 31/07/2025 05:24:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '98312' 31/07/2025 05:24:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98312' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 31/07/2025 05:24:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98312' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 31/07/2025 05:24:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98312' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 31/07/2025 05:24:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98312' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 31/07/2025 05:24:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98312' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '12.9' , '10.573770491803' , '22' , '0' , '12.90' ) 31/07/2025 05:34:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2627' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 05:34: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' , '2627' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '7.00' , NOW() , NOW() ) 31/07/2025 05:34: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 = '98313' 31/07/2025 05:34:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '98313' 31/07/2025 05:34: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 ( '98313' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.70' , '0.7' , '0' , '0' , '7.00' ) 31/07/2025 05:36:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2628' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 05:36:24 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' , '2628' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 31/07/2025 05:36:24 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 = '98314' 31/07/2025 05:36:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '98314' 31/07/2025 05:36:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98314' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '13.00' ) 31/07/2025 06:45:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2629' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 06:45:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2629' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.90' , '28.44' , NOW() , NOW() ) 31/07/2025 06:45:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98315' 31/07/2025 06:45:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '98315' 31/07/2025 06:45:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98315' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 31/07/2025 06:45:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98315' , '23801' , 'MIA SPERANZA E IN TE - SPARTITO' , '1' , '-1' , '3' , '12.00' , '11.538461538462' , '4' , '0' , '12.00' ) 31/07/2025 07:15:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2630' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 07:15:24 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' , '2630' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '116.00' , '95.08' , NOW() , NOW() ) 31/07/2025 07:15:24 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 = '98316' 31/07/2025 07:15:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '98316' 31/07/2025 07:15:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98316' , '10687' , 'TORCIA A VENTO ' , '29' , '-29' , '1' , '4' , '3.2786885245902' , '22' , '0' , '116.00' ) 31/07/2025 07:17:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2631' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 07:17: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' , '2631' , '2025-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 31/07/2025 07:17: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 = '98317' 31/07/2025 07:17:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '98317' 31/07/2025 07:17: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 ( '98317' , '15351' , 'PORTATECA A BUSTINA - 928' , '1' , '-1' , '1' , '34' , '27.868852459016' , '22' , '0' , '34.00' ) 31/07/2025 07:23:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '103/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-31') 31/07/2025 07:23:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '103/A' , '2025-07-31' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '324.40' , '265.90' , NOW() , NOW() ) 31/07/2025 07:23:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98318' 31/07/2025 07:23:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '98318' 31/07/2025 07:23:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '19756' , 'CAMICIA STOCK' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 31/07/2025 07:23:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 31/07/2025 07:23:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 31/07/2025 07:23:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '3' , '-3' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '109.50' ) 31/07/2025 07:23:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' )