25/11/2025 09:18:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3905' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 09:18:38 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' , '3905' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '33.00' , NOW() , NOW() ) 25/11/2025 09:18:38 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 = '100064' 25/11/2025 09:18:38 am >> DELETE FROM ps_document_detail WHERE id_document = '100064' 25/11/2025 09:18:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100064' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 25/11/2025 09:18:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100064' , '' , 'MOCCOLO 70X200' , '4' , '-4' , '4' , '7.5' , '7.5' , '0' , '0' , '30.00' ) 25/11/2025 09:21:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3906' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 09:21: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' , '3906' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 25/11/2025 09:21: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 = '100065' 25/11/2025 09:21:56 am >> DELETE FROM ps_document_detail WHERE id_document = '100065' 25/11/2025 09:21: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 ( '100065' , '' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 25/11/2025 09:57:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3907' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 09:57:55 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' , '3907' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 25/11/2025 09:57:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100066' 25/11/2025 09:57:55 am >> DELETE FROM ps_document_detail WHERE id_document = '100066' 25/11/2025 09:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100066' , '' , 'moccolo 70x200' , '4' , '-4' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '30.00' ) 25/11/2025 10:42:00 am >> SELECT document_num FROM ps_document WHERE document_num = '59/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 10:42:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '59/E' , '2025-11-25' , 'E' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '190.00' , '190.00' , NOW() , NOW() ) 25/11/2025 10:42:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100067' 25/11/2025 10:42:00 am >> DELETE FROM ps_document_detail WHERE id_document = '100067' 25/11/2025 10:42:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100067' , '2679' , 'CONOSCERE GESU' , '50' , '-50' , '4' , '3.50' , '3.5' , '0' , '38' , '108.50' ) 25/11/2025 10:42:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100067' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '20' , '-20' , '4' , '6.00' , '6' , '0' , '38' , '74.40' ) 25/11/2025 10:42:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100067' , '' , 'spese di trasporto' , '1' , '-1' , '4' , '7.1' , '7.1' , '0' , '0' , '7.10' ) 25/11/2025 10:50:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3908' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 10:50:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3908' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 25/11/2025 10:50:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100068' 25/11/2025 10:50:20 am >> DELETE FROM ps_document_detail WHERE id_document = '100068' 25/11/2025 10:50:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100068' , '9791' , 'SEGNABIBBIA - 3110' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 25/11/2025 10:51:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3909' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 10:51:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3909' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 25/11/2025 10:51:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100069' 25/11/2025 10:51:45 am >> DELETE FROM ps_document_detail WHERE id_document = '100069' 25/11/2025 10:51:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100069' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 25/11/2025 10:51:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100069' , '3115' , 'CROCE SAN DAMIANO SOTTILE - 1237' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 25/11/2025 11:08:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3910' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 11:08:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3910' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 25/11/2025 11:08:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100070' 25/11/2025 11:08:08 am >> DELETE FROM ps_document_detail WHERE id_document = '100070' 25/11/2025 11:08:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100070' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '' , '4.50' ) 25/11/2025 11:14:50 am >> SELECT document_num FROM ps_document WHERE document_num = '255' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 11:14:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '255' , '2025-11-25' , '' , '1138' , '0' , '4672220' , 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '74.38' , '74.38' , NOW() , NOW() ) 25/11/2025 11:14: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 = '100071' 25/11/2025 11:14:50 am >> DELETE FROM ps_document_detail WHERE id_document = '100071' 25/11/2025 11:14: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 ( '100071' , '2679' , 'CONOSCERE GESU' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 25/11/2025 11:18:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3907' AND id_document != '100066' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 11:18:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3907', document_date = '2025-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '100066' 25/11/2025 11:18:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100066' 25/11/2025 11:18:53 am >> DELETE FROM ps_document_detail WHERE id_document = '100066' 25/11/2025 11:18:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100066' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 25/11/2025 11:20:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3905' AND id_document != '100064' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 11:20:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3905', document_date = '2025-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '33.00', price_tax_excluded = '33.00', date_upd = NOW() WHERE id_document = '100064' 25/11/2025 11:20:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100064' 25/11/2025 11:20:11 am >> DELETE FROM ps_document_detail WHERE id_document = '100064' 25/11/2025 11:20:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100064' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 25/11/2025 11:20:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100064' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' ) 25/11/2025 11:20:31 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'NumtVow6usgkuhZI' , NOW() , NOW() ) 25/11/2025 11:20:31 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4289' , '1' ) 25/11/2025 11:20:31 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4289' , '2' ) 25/11/2025 11:20:31 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4289' , '3' ) 25/11/2025 11:21:51 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4289' 25/11/2025 11:21:51 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4289' , '10' , '157' , 'PARR. S. MARTINO A GANGALANDI' , 'VENTISETTE' , 'DON RENZO' , 'VIA LEON BATTISTA ALBERTI, 37' , '' , '50055' , 'LASTRA A SIGNA' , '' , '0558720008' , '' , '' , '' , NOW() , NOW() ) 25/11/2025 11:21:51 am >> UPDATE ps_customer SET email = 's.martino-gangalandi@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4289' 25/11/2025 11:23:14 am >> SELECT document_num FROM ps_document WHERE document_num = '256' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 11:23: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 ( '21' , '256' , '2025-11-25' , '' , '4289' , '0' , '4679659' , 'VIA LEON BATTISTA ALBERTI, 37 50055 LASTRA A SIGNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '285.00' , '285.00' , NOW() , NOW() ) 25/11/2025 11:23: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 = '100072' 25/11/2025 11:23:14 am >> DELETE FROM ps_document_detail WHERE id_document = '100072' 25/11/2025 11:23: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 ( '100072' , '4120' , 'FEDE NELLO ZAINETTO' , '50' , '-50' , '4' , '6.00' , '6' , '0' , '5' , '285.00' ) 25/11/2025 12:03:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3911' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 12:03:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3911' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.50' , '47.58' , NOW() , NOW() ) 25/11/2025 12:03:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100073' 25/11/2025 12:03:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100073' 25/11/2025 12:03:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100073' , '6810' , 'MOCCOLO 80X150' , '7' , '-7' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '49.00' ) 25/11/2025 12:03:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100073' , '6810' , 'MOCCOLO 80X150' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 25/11/2025 12:03:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100073' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 25/11/2025 12:05:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3912' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 12:05:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3912' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.65' , '3.65' , NOW() , NOW() ) 25/11/2025 12:05:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100074' 25/11/2025 12:05:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '100074' 25/11/2025 12:05:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100074' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 25/11/2025 12:05:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100074' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 25/11/2025 12:09:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '257' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 12:09:16 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 ( '21' , '257' , '2025-11-25' , '' , '3931' , '0' , '4679347' , 'VIALE DELLA LIBERA 11 80079 PROCIDA' , '' , '' , '13' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '44.88' , '44.88' , NOW() , NOW() ) 25/11/2025 12:09:16 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 = '100075' 25/11/2025 12:09:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '100075' 25/11/2025 12:09:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100075' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 25/11/2025 12:14:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3913' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 12:14:25 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' , '3913' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.40' , '6.40' , NOW() , NOW() ) 25/11/2025 12:14:25 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 = '100076' 25/11/2025 12:14:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '100076' 25/11/2025 12:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100076' , '23807' , 'CALENDARIO LITURGICO 2026' , '8' , '-8' , '4' , '0.80' , '0.8' , '0' , '0' , '6.40' ) 25/11/2025 03:29:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3914' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 03:29:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3914' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 25/11/2025 03:29:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100077' 25/11/2025 03:29:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '100077' 25/11/2025 03:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100077' , '23600' , 'STATUA SAN CARLO ACUTIS - ST212-AC' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 25/11/2025 03:31:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3915' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 03:31:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3915' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 25/11/2025 03:31:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100078' 25/11/2025 03:31:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '100078' 25/11/2025 03:31:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100078' , '10475' , 'TEALIGHTS X 50 ' , '4' , '-4' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '22.00' ) 25/11/2025 03:49:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3916' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 03:49: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' , '3916' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '129.70' , '110.21' , NOW() , NOW() ) 25/11/2025 03:49: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 = '100079' 25/11/2025 03:49:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '100079' 25/11/2025 03:49: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 ( '100079' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 25/11/2025 03:49: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 ( '100079' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 25/11/2025 03:49: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 ( '100079' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 25/11/2025 03:49: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 ( '100079' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '200' , '-200' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '60.00' ) 25/11/2025 03:49: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 ( '100079' , '16796' , 'LUMINO 5B BIANCO' , '104' , '-104' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '31.20' ) 25/11/2025 03:51:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3917' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 03:51: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' , '3917' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.25' , '8.25' , NOW() , NOW() ) 25/11/2025 03:51: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 = '100080' 25/11/2025 03:51:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '100080' 25/11/2025 03:51: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 ( '100080' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 25/11/2025 03:51: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 ( '100080' , '7125' , 'NOVENA E CORONCINA ALLANGELO RAFFAELE - 8262' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 25/11/2025 03:51: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 ( '100080' , '7124' , 'NOVENA E CORONCINA A SAN GABRIELE ARCANGELO - 8261' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 25/11/2025 03:52:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '116/A' AND id_document != '98877' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-23') 25/11/2025 03:52:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '116/A', document_date = '2025-09-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'DON LUIGI SAVINO acconto € 210,00+25/11 € 100', 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 = '420.00', price_tax_excluded = '344.26', date_upd = NOW() WHERE id_document = '98877' 25/11/2025 03:52:55 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 = '98877' 25/11/2025 03:52:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '98877' 25/11/2025 03:52:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98877' , '20113' , 'FATIMA CM 105 - 1038/P' , '1' , '-1' , '1' , '420.0000' , '344.26229508197' , '22' , '0' , '420.00' ) 25/11/2025 03:53:11 pm >> DELETE FROM ps_document WHERE id_document = '100005' 25/11/2025 03:53:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '100005' 25/11/2025 03:59:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3900' AND id_document != '100054' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-24') 25/11/2025 03:59:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3900', document_date = '2025-11-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '74.00', price_tax_excluded = '60.66', date_upd = NOW() WHERE id_document = '100054' 25/11/2025 03:59:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100054' 25/11/2025 03:59:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '100054' 25/11/2025 03:59:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100054' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' , '-1' , '1' , '74' , '60.655737704918' , '22' , '0' , '74.00' ) 25/11/2025 04:38:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '99314' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-17') 25/11/2025 04:38:31 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2025-10-17', document_letter = 'A', id_customer = '232', id_supplier = '', id_address = '4671450', address1 = 'VIA V. LASPRO, 8/A 84126 SALERNO', 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 = '182.10', price_tax_excluded = '176.90', date_upd = NOW() WHERE id_document = '99314' 25/11/2025 04:38:31 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 = '99314' 25/11/2025 04:38:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '99314' 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '6' , '-6' , '4' , '3.8000' , '3.8' , '0' , '15' , '19.38' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.8000' , '3.8' , '0' , '15' , '25.84' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '4' , '-4' , '4' , '3.8000' , '3.8' , '0' , '15' , '12.92' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '2679' , 'CONOSCERE GESU' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '15' , '11.90' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '8855' , 'REGISTRO DEL CATECHISTA' , '5' , '-5' , '1' , '0.7500' , '0.61475409836066' , '22' , '0' , '3.75' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '21097' , 'BRACCIALE DECINA - BC1768N' , '4' , '-4' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '8.00' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '3' , '-3' , '1' , '2' , '1.6393442622951' , '22' , '0' , '6.00' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '8' , '-8' , '4' , '2.80' , '2.8' , '0' , '15' , '19.04' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '1090' , 'BIBBIA' , '3' , '-3' , '4' , '9.90' , '9.9' , '0' , '5' , '28.22' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '18051' , 'MIA BIBBIA' , '6' , '-6' , '4' , '3.50' , '3.5' , '0' , '5' , '19.95' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '3' , '-3' , '4' , '2.50' , '2.5' , '0' , '0' , '7.50' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '15' , '8.50' ) 25/11/2025 04:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '3' , '-3' , '1' , '3.70' , '3.0327868852459' , '22' , '0' , '11.10' ) 25/11/2025 04:41:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3918' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 04:41:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3918' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.64' , '125.44' , NOW() , NOW() ) 25/11/2025 04:41:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100081' 25/11/2025 04:41:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '100081' 25/11/2025 04:41:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '3' , '-3' , '1' , '2' , '1.6393442622951' , '22' , '0' , '6.00' ) 25/11/2025 04:41:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '21097' , 'BRACCIALE DECINA - BC1768N' , '4' , '-4' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '8.00' ) 25/11/2025 04:41:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '3' , '-3' , '1' , '3.70' , '3.0327868852459' , '22' , '0' , '11.10' ) 25/11/2025 04:41:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '8855' , 'REGISTRO DEL CATECHISTA' , '5' , '-5' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '3.75' ) 25/11/2025 04:41:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '1090' , 'BIBBIA' , '3' , '-3' , '4' , '9.90' , '9.9' , '0' , '5' , '28.23' ) 25/11/2025 04:41:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '18783' , 'MIA BIBBIA PREFERITA ' , '6' , '-6' , '4' , '12.90' , '12.9' , '0' , '5' , '73.56' ) 25/11/2025 04:41:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '99314' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-17') 25/11/2025 04:41:59 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2025-10-17', document_letter = 'A', id_customer = '232', id_supplier = '', id_address = '4671450', address1 = 'VIA V. LASPRO, 8/A 84126 SALERNO', 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 = '103.96', price_tax_excluded = '103.96', date_upd = NOW() WHERE id_document = '99314' 25/11/2025 04:41:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99314' 25/11/2025 04:41:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '99314' 25/11/2025 04:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '6' , '-6' , '4' , '3.8000' , '3.8' , '0' , '15' , '19.38' ) 25/11/2025 04:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.8000' , '3.8' , '0' , '15' , '25.84' ) 25/11/2025 04:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '4' , '-4' , '4' , '3.8000' , '3.8' , '0' , '15' , '12.92' ) 25/11/2025 04:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '2679' , 'CONOSCERE GESU' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '15' , '11.90' ) 25/11/2025 04:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '8' , '-8' , '4' , '2.8000' , '2.8' , '0' , '15' , '19.04' ) 25/11/2025 04:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '3' , '-3' , '4' , '2.5000' , '2.5' , '0' , '15' , '6.38' ) 25/11/2025 04:41:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '4' , '-4' , '4' , '2.5000' , '2.5' , '0' , '15' , '8.50' ) 25/11/2025 04:56:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3919' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 04:56:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3919' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.10' , '20.57' , NOW() , NOW() ) 25/11/2025 04:56:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100082' 25/11/2025 04:56:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '100082' 25/11/2025 04:56:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100082' , '20030' , 'CANDELE ALTARE 40x20' , '10' , '-10' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '20.00' ) 25/11/2025 04:56:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100082' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 25/11/2025 04:56:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100082' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.60' , '3.7704918032787' , '22' , '0' , '4.60' ) 25/11/2025 05:03:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3920' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 05:03:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3920' , '2025-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 25/11/2025 05:03:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100083' 25/11/2025 05:03:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '100083' 25/11/2025 05:03:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100083' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 25/11/2025 05:15:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3918' AND id_document != '100081' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 05:15:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3918', document_date = '2025-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '130.64', price_tax_excluded = '125.44', date_upd = NOW() WHERE id_document = '100081' 25/11/2025 05:15:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100081' 25/11/2025 05:15:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '100081' 25/11/2025 05:15:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '3' , '-3' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '6.00' ) 25/11/2025 05:15:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '21097' , 'BRACCIALE DECINA - BC1768N' , '4' , '-4' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '8.00' ) 25/11/2025 05:15:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '3' , '-3' , '1' , '3.7000' , '3.0327868852459' , '22' , '0' , '11.10' ) 25/11/2025 05:15:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '8855' , 'REGISTRO DEL CATECHISTA' , '5' , '-5' , '1' , '0.7500' , '0.61475409836066' , '22' , '0' , '3.75' ) 25/11/2025 05:15:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '1090' , 'BIBBIA' , '3' , '-3' , '4' , '9.9000' , '9.9' , '0' , '5' , '28.23' ) 25/11/2025 05:15:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '18051' , 'MIA BIBBIA' , '6' , '-6' , '4' , '3.50' , '3.5' , '0' , '5' , '19.98' ) 25/11/2025 05:15:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '3' , '-3' , '4' , '2.125' , '2.125' , '0' , '0' , '6.39' ) 25/11/2025 05:15:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '4' , '-4' , '4' , '2.135' , '2.135' , '0' , '0' , '8.56' ) 25/11/2025 05:15:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '8' , '-8' , '4' , '2.38' , '2.38' , '0' , '0' , '19.04' ) 25/11/2025 05:15:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '2679' , 'CONOSCERE GESU\'' , '4' , '-4' , '4' , '3.11' , '3.11' , '0' , '0' , '12.44' ) 25/11/2025 05:15:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.57' , '3.57' , '0' , '0' , '3.57' ) 25/11/2025 05:15:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100081' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.58' , '3.58' , '0' , '0' , '3.58' ) 25/11/2025 05:16:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '99314' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-17') 25/11/2025 05:16:20 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2025-10-17', document_letter = 'A', id_customer = '232', id_supplier = '', id_address = '4671450', address1 = 'VIA V. LASPRO, 8/A 84126 SALERNO', address2 = '', note = 'VARI ARROTONDAMENTI', price_shipping = '-1.68', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '50.00', date_upd = NOW() WHERE id_document = '99314' 25/11/2025 05:16: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 = '99314' 25/11/2025 05:16:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '99314' 25/11/2025 05:16: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 ( '99314' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '6' , '-6' , '4' , '3.8000' , '3.8' , '0' , '15' , '19.38' ) 25/11/2025 05:16: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 ( '99314' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.8000' , '3.8' , '0' , '15' , '25.84' ) 25/11/2025 05:16: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 ( '99314' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '15' , '6.46' ) 25/11/2025 05:34:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '257' AND id_document != '100075' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-25') 25/11/2025 05:34:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '257', document_date = '2025-11-25', document_letter = '', id_customer = '3931', id_supplier = '', id_address = '4679347', address1 = 'VIALE DELLA LIBERA 11 80079 PROCIDA', address2 = '', note = '', price_shipping = '13.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '140.13', price_tax_excluded = '140.13', date_upd = NOW() WHERE id_document = '100075' 25/11/2025 05:34:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100075' 25/11/2025 05:34:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '100075' 25/11/2025 05:34:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100075' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 25/11/2025 05:34:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100075' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '15' , '38.25' ) 25/11/2025 05:34:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100075' , '17734' , 'VANGELO E ATTI BAMBINI' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '5' , '57.00' ) 25/11/2025 05:37:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '91/A' AND id_document != '87349' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-19') 25/11/2025 05:37:47 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '91/A', document_date = '2023-09-19', document_letter = 'A', id_customer = '3892', id_supplier = '', id_address = '4679228', address1 = 'OGLIARA 84100 OGLIARA', address2 = '', note = 'ACCONTO AL 25/11 € 1410,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87349' 25/11/2025 05:37: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 = '87349' 25/11/2025 05:37:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '87349' 25/11/2025 05:37: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 ( '87349' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '0' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 25/11/2025 05:37: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 ( '87349' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '0' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 25/11/2025 05:37: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 ( '87349' , '0' , 'PALLA MARIANA - 50/372' , '1' , '0' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 25/11/2025 05:37: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 ( '87349' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '0' , '1' , '305.0000' , '250' , '22' , '0' , '305.00' ) 25/11/2025 05:37: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 ( '87349' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' , '0' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 25/11/2025 05:37: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 ( '87349' , '0' , 'PISSIDE 099PA' , '1' , '0' , '1' , '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 25/11/2025 05:37: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 ( '87349' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '0' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' )