19/11/2025 09:12:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3844' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 09:12:34 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' , '3844' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.40' , '12.62' , NOW() , NOW() ) 19/11/2025 09:12:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99979' 19/11/2025 09:12:34 am >> DELETE FROM ps_document_detail WHERE id_document = '99979' 19/11/2025 09:12:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99979' , '18339' , 'CROCE SAN BENEDETTO - CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '11.90' , '9.7540983606557' , '22' , '0' , '11.90' ) 19/11/2025 09:12:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99979' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 19/11/2025 09:33:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3845' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 09:33: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' , '3845' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '189.00' , '154.92' , NOW() , NOW() ) 19/11/2025 09:33: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 = '99980' 19/11/2025 09:33:56 am >> DELETE FROM ps_document_detail WHERE id_document = '99980' 19/11/2025 09:33: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 ( '99980' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '5' , '-5' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '185.00' ) 19/11/2025 09:33: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 ( '99980' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 19/11/2025 09:34:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3846' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 09:34:35 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' , '3846' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.70' , '3.70' , NOW() , NOW() ) 19/11/2025 09:34:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99981' 19/11/2025 09:34:35 am >> DELETE FROM ps_document_detail WHERE id_document = '99981' 19/11/2025 09:34:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99981' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 19/11/2025 09:34:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99981' , '24180' , 'DILEXI TE' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/11/2025 10:04:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3847' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 10:04:31 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' , '3847' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '35.19' , NOW() , NOW() ) 19/11/2025 10:04: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 = '99982' 19/11/2025 10:04:31 am >> DELETE FROM ps_document_detail WHERE id_document = '99982' 19/11/2025 10:04:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99982' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 19/11/2025 10:04:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99982' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 19/11/2025 10:04:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99982' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 19/11/2025 10:04:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99982' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 19/11/2025 10:04:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99982' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '1' , '-1' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '1.60' ) 19/11/2025 10:08:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3848' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 10:08:41 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' , '3848' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.50' , '43.43' , NOW() , NOW() ) 19/11/2025 10:08:41 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 = '99983' 19/11/2025 10:08:41 am >> DELETE FROM ps_document_detail WHERE id_document = '99983' 19/11/2025 10:08:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99983' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '17.00' ) 19/11/2025 10:08:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99983' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/11/2025 10:08:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99983' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 19/11/2025 10:08:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99983' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/11/2025 10:09:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3849' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 10:09:42 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' , '3849' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.23' , '55.90' , NOW() , NOW() ) 19/11/2025 10:09:42 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 = '99984' 19/11/2025 10:09:42 am >> DELETE FROM ps_document_detail WHERE id_document = '99984' 19/11/2025 10:09:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99984' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 19/11/2025 10:09:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99984' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 19/11/2025 10:09:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99984' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '0' , '12.00' ) 19/11/2025 10:09:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99984' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 19/11/2025 10:09:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99984' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 19/11/2025 10:09:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99984' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 19/11/2025 10:09:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99984' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/11/2025 10:09:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99984' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 19/11/2025 10:33:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-GIU' AND id_product != '17783' AND ean13 != '' 19/11/2025 10:33:45 am >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = 'G022-GIU', date_upd = NOW() WHERE id_product = '17783' 19/11/2025 10:33:45 am >> UPDATE ps_product_lang SET name = 'MEDAGLIA OVALE S. GIUSEPPE CM 2,2 ', description = '' WHERE id_product = '17783' 19/11/2025 10:33:45 am >> UPDATE ps_product SET wholesale_price = '0.09', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '17783' 19/11/2025 10:33:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.09', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17783' 19/11/2025 10:33:45 am >> DELETE FROM ps_specific_price WHERE id_product = '17783' 19/11/2025 10:35:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3850' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 10:35:25 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' , '3850' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.10' , '14.38' , NOW() , NOW() ) 19/11/2025 10:35: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 = '99985' 19/11/2025 10:35:25 am >> DELETE FROM ps_document_detail WHERE id_document = '99985' 19/11/2025 10:35: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 ( '99985' , '17783' , 'MEDAGLIA OVALE S. GIUSEPPE CM 2,2 ' , '5' , '-5' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '1.50' ) 19/11/2025 10:35: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 ( '99985' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 19/11/2025 10:35: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 ( '99985' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 19/11/2025 10:35: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 ( '99985' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 19/11/2025 10:37:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3851' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 10:37: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' , '3851' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.35' , '36.17' , NOW() , NOW() ) 19/11/2025 10:37: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 = '99986' 19/11/2025 10:37:38 am >> DELETE FROM ps_document_detail WHERE id_document = '99986' 19/11/2025 10:37: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 ( '99986' , '24126' , 'AGENDA DEVOZIONALE 2026 PREGAGENDA - 40829' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '5' , '26.60' ) 19/11/2025 10:37: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 ( '99986' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 19/11/2025 10:37: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 ( '99986' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 19/11/2025 10:37: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 ( '99986' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 19/11/2025 10:37: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 ( '99986' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/11/2025 10:55:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3852' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 10:55:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3852' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.85' , '79.23' , NOW() , NOW() ) 19/11/2025 10:55:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99987' 19/11/2025 10:55:07 am >> DELETE FROM ps_document_detail WHERE id_document = '99987' 19/11/2025 10:55:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99987' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 19/11/2025 10:55: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 ( '99987' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 19/11/2025 10:55: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 ( '99987' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 19/11/2025 10:55: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 ( '99987' , '17617' , 'IMMAGINI ISONZO X 100' , '6' , '-6' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '19.98' ) 19/11/2025 10:55: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 ( '99987' , '6419' , 'MESE DI MARZO DEDICATO A SAN GIUSEPPE - 8340' , '1' , '-1' , '4' , '4.77' , '4.77' , '0' , '0' , '4.77' ) 19/11/2025 10:55: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 ( '99987' , '8334' , 'PREGHIERE A SAN GIUSEPPE - 8115' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 19/11/2025 10:55:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3853' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 10:55:24 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' , '3853' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '55.00' , NOW() , NOW() ) 19/11/2025 10:55:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99988' 19/11/2025 10:55:24 am >> DELETE FROM ps_document_detail WHERE id_document = '99988' 19/11/2025 10:55:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99988' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '10' , '-10' , '4' , '5.50' , '5.5' , '0' , '0' , '55.00' ) 19/11/2025 10:56:04 am >> SELECT document_num FROM ps_document WHERE document_num = '246' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 10:56:04 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' , '246' , '2025-11-19' , '' , '479' , '0' , '4679233' , 'VIA ORAZIO GAVIOLI 3 85100 POTENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.05' , '80.05' , NOW() , NOW() ) 19/11/2025 10:56:04 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 = '99989' 19/11/2025 10:56:04 am >> DELETE FROM ps_document_detail WHERE id_document = '99989' 19/11/2025 10:56:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99989' , '9675' , 'SARETE MIEI TESTIMONI' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 19/11/2025 10:56:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99989' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '0' , '35.00' ) 19/11/2025 10:56:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99989' , '6629' , 'MIA PREGHIERA' , '20' , '-20' , '4' , '0.90' , '0.9' , '0' , '15' , '15.30' ) 19/11/2025 11:00:08 am >> SELECT document_num FROM ps_document WHERE document_num = '247' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 11:00: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 ( '21' , '247' , '2025-11-19' , '' , '1083' , '0' , '4674059' , 'VIA CREMONA, 1 83020 S. MICHELE DI SERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '217.09' , '217.09' , NOW() , NOW() ) 19/11/2025 11:00: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 = '99990' 19/11/2025 11:00:08 am >> DELETE FROM ps_document_detail WHERE id_document = '99990' 19/11/2025 11:00: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 ( '99990' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '15' , '10.20' ) 19/11/2025 11:00: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 ( '99990' , '11183' , 'VENITE CON ME - GUIDA' , '4' , '-4' , '4' , '8.00' , '8' , '0' , '15' , '27.20' ) 19/11/2025 11:00: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 ( '99990' , '11192' , 'VENITE CON ME 2 PARTE' , '23' , '-23' , '4' , '2.80' , '2.8' , '0' , '15' , '54.74' ) 19/11/2025 11:00: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 ( '99990' , '11191' , 'VENITE CON ME 1 PARTE' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 19/11/2025 11:00: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 ( '99990' , '2679' , 'CONOSCERE GESU' , '26' , '-26' , '4' , '3.50' , '3.5' , '0' , '15' , '77.35' ) 19/11/2025 11:05:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3854' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 11:05:11 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' , '3854' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '176.84' , '161.48' , NOW() , NOW() ) 19/11/2025 11:05: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 = '99991' 19/11/2025 11:05:11 am >> DELETE FROM ps_document_detail WHERE id_document = '99991' 19/11/2025 11:05: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 ( '99991' , '23919' , 'CE SPAZIO PER TE 2026 - 12-14 ANNI' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 19/11/2025 11:05: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 ( '99991' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '8.00' ) 19/11/2025 11:05: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 ( '99991' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5.50' , '5.5' , '0' , '0' , '22.00' ) 19/11/2025 11:05: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 ( '99991' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 19/11/2025 11:05: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 ( '99991' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '3' , '-3' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '3.60' ) 19/11/2025 11:05: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 ( '99991' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 19/11/2025 11:05: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 ( '99991' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 19/11/2025 11:05: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 ( '99991' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 19/11/2025 11:05: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 ( '99991' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 19/11/2025 11:05: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 ( '99991' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 19/11/2025 11:05: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 ( '99991' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '0' , '12.00' ) 19/11/2025 11:16:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3854' AND id_document != '99991' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 11:16:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3854', document_date = '2025-11-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '176.84', price_tax_excluded = '161.48', date_upd = NOW() WHERE id_document = '99991' 19/11/2025 11:16: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 = '99991' 19/11/2025 11:16:59 am >> DELETE FROM ps_document_detail WHERE id_document = '99991' 19/11/2025 11:16: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 ( '99991' , '23919' , 'CE SPAZIO PER TE 2026 - 12-14 ANNI' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '5' , '15.68' ) 19/11/2025 11:16: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 ( '99991' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '8.00' ) 19/11/2025 11:16: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 ( '99991' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '0' , '22.00' ) 19/11/2025 11:16: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 ( '99991' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.9' , '6.9' , '0' , '5' , '6.56' ) 19/11/2025 11:16: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 ( '99991' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '3' , '-3' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '3.60' ) 19/11/2025 11:17: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 ( '99991' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 19/11/2025 11:17: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 ( '99991' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 19/11/2025 11:17: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 ( '99991' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 19/11/2025 11:17: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 ( '99991' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 19/11/2025 11:17: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 ( '99991' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 19/11/2025 11:17: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 ( '99991' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '0' , '12.00' ) 19/11/2025 11:24:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3490' AND id_document != '99446' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-24') 19/11/2025 11:24:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3490', document_date = '2025-10-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 = '38.90', price_tax_excluded = '37.82', date_upd = NOW() WHERE id_document = '99446' 19/11/2025 11:24: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 = '99446' 19/11/2025 11:24:56 am >> DELETE FROM ps_document_detail WHERE id_document = '99446' 19/11/2025 11:24:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 19/11/2025 11:24:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 19/11/2025 11:24:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 19/11/2025 11:24:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 19/11/2025 11:24:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.9' , '6.9' , '0' , '5' , '6.56' ) 19/11/2025 11:24:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 19/11/2025 11:24:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99446' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 19/11/2025 11:25:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3483' AND id_document != '99432' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 19/11/2025 11:25:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3483', document_date = '2025-10-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '97.21', price_tax_excluded = '89.86', date_upd = NOW() WHERE id_document = '99432' 19/11/2025 11:25:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99432' 19/11/2025 11:25:16 am >> DELETE FROM ps_document_detail WHERE id_document = '99432' 19/11/2025 11:25:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 19/11/2025 11:25:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/11/2025 11:25:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 19/11/2025 11:25:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 19/11/2025 11:25:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '24047' , 'GESU E IL MIO AMICO SPECIALE - LA RICONCILIAZIONE GUIDA' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 19/11/2025 11:25:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '24045' , 'GESU E IL MIO AMICO SPECIALE - LA RICONCILIAZIONE' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 19/11/2025 11:25:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.9' , '6.9' , '0' , '5' , '6.56' ) 19/11/2025 11:25:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 19/11/2025 11:25:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '997' , 'BEATITUDINI SPIEGATE AI RAGAZZI - V. BOCCI' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 19/11/2025 11:25:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '24107' , 'IO E IL MIO AMICO GESU - GUIDA - B. FERRERO' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 19/11/2025 11:25:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 19/11/2025 11:25:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3506' AND id_document != '94300' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-16') 19/11/2025 11:25:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3506', document_date = '2024-11-16', 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 = '725.00', price_tax_excluded = '720.49', date_upd = NOW() WHERE id_document = '94300' 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94300' 19/11/2025 11:25:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94300' 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '5444' , 'IO SONO CON VOI - CAT.' , '45' , '-45' , '4' , '5.5000' , '5.5' , '0' , '5' , '235.35' ) 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '11193' , 'VENITE CON ME CAT.' , '80' , '-80' , '4' , '5.5000' , '5.5' , '0' , '5' , '418.40' ) 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '100' , '-100' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '25.00' ) 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '22769' , 'COPPIE IN CAMMINO - MAIO/CALETTI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '13431' , 'PASSI VERSO LEUCARISTIA' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.04' , '6.04' , '0' , '' , '6.04' ) 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '23157' , 'ASPETTIAMO CON GIOIA IL NATALE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '23135' , 'SUSSIDIO AVVENTO E NATALE 2024/25 RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '23128' , 'CIACK, SI GIRA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '21709' , 'GESU E IL PANE DI VITA' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 19/11/2025 11:25:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94300' , '13033' , 'NOVENA ALLIMMACOLATA CONCEZIONE E AL SANTO NATALE - 8176' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 19/11/2025 11:27:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3490' AND id_document != '99446' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-24') 19/11/2025 11:27:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3490', document_date = '2025-10-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 = '38.90', price_tax_excluded = '37.82', date_upd = NOW() WHERE id_document = '99446' 19/11/2025 11:27: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 = '99446' 19/11/2025 11:27:29 am >> DELETE FROM ps_document_detail WHERE id_document = '99446' 19/11/2025 11:27: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 ( '99446' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 19/11/2025 11:27: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 ( '99446' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 19/11/2025 11:27: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 ( '99446' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 19/11/2025 11:27: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 ( '99446' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '19.68' , '19.68' , '0' , '0' , '19.68' ) 19/11/2025 11:27: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 ( '99446' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 19/11/2025 11:27:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3483' AND id_document != '99432' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 19/11/2025 11:27:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3483', document_date = '2025-10-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '97.21', price_tax_excluded = '89.86', date_upd = NOW() WHERE id_document = '99432' 19/11/2025 11:27:57 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 = '99432' 19/11/2025 11:27:57 am >> DELETE FROM ps_document_detail WHERE id_document = '99432' 19/11/2025 11:27:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 19/11/2025 11:27:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/11/2025 11:27:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 19/11/2025 11:27:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 19/11/2025 11:27:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '24047' , 'GESU E IL MIO AMICO SPECIALE - LA RICONCILIAZIONE GUIDA' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 19/11/2025 11:27:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '24045' , 'GESU E IL MIO AMICO SPECIALE - LA RICONCILIAZIONE' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 19/11/2025 11:27:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '13.12' , '13.12' , '0' , '0' , '13.12' ) 19/11/2025 11:27:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 19/11/2025 11:27:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '997' , 'BEATITUDINI SPIEGATE AI RAGAZZI - V. BOCCI' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 19/11/2025 11:27:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '24107' , 'IO E IL MIO AMICO GESU - GUIDA - B. FERRERO' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 19/11/2025 11:29:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3826' AND id_document != '99956' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-18') 19/11/2025 11:29:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3826', document_date = '2025-11-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA', 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 = '1176.40', price_tax_excluded = '1176.40', date_upd = NOW() WHERE id_document = '99956' 19/11/2025 11:29:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99956' 19/11/2025 11:29:48 am >> DELETE FROM ps_document_detail WHERE id_document = '99956' 19/11/2025 11:29:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99956' , '17244' , 'DIARIO DELLA MIA PRIMA CONFESSIONE' , '69' , '-69' , '4' , '5.9000' , '5.9' , '0' , '5' , '386.75' ) 19/11/2025 11:29:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99956' , '17245' , 'DIARIO DELLA MIA PRIMA COMUNIONE' , '66' , '-66' , '4' , '5.9000' , '5.9' , '0' , '5' , '369.93' ) 19/11/2025 11:29:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99956' , '12895' , 'PASSI VERSO LA CRESIMA' , '7' , '-7' , '4' , '7.9000' , '7.9' , '0' , '5' , '52.54' ) 19/11/2025 11:29:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99956' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '29' , '-29' , '4' , '5.0000' , '5' , '0' , '5' , '137.75' ) 19/11/2025 11:29:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99956' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '229.43' , '229.43' , '0' , '0' , '229.43' ) 19/11/2025 11:45:48 am >> SELECT document_num FROM ps_document WHERE document_num = '99/A' AND id_document != '98079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-14') 19/11/2025 11:45:48 am >> UPDATE ps_document SET id_document_type = '24', document_num = '99/A', document_date = '2025-07-14', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 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 = '467.10', price_tax_excluded = '388.38', date_upd = NOW() WHERE id_document = '98079' 19/11/2025 11:45:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98079' 19/11/2025 11:45:49 am >> DELETE FROM ps_document_detail WHERE id_document = '98079' 19/11/2025 11:45:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98079' , '8147' , 'POLO BASIC' , '4' , '-4' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '108.00' ) 19/11/2025 11:45:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98079' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '3' , '-3' , '4' , '2.8000' , '2.8' , '0' , '0' , '8.40' ) 19/11/2025 11:45:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98079' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 19/11/2025 11:45:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98079' , '22970' , 'RELIQUIARIO H 25CM' , '1' , '-1' , '1' , '189.0000' , '154.91803278689' , '22' , '0' , '189.00' ) 19/11/2025 11:45:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98079' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '23.70' ) 19/11/2025 11:45:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98079' , '22865' , 'CATECHISMO MAGGIORE - SAN PIO X' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 19/11/2025 11:45:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98079' , '' , '19/11' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 19/11/2025 11:45:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98079' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '500' , '-500' , '1' , '0.23' , '0.18852459016393' , '22' , '0' , '115.00' ) 19/11/2025 12:12:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3855' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 12:12: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' , '3855' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.60' , '115.50' , NOW() , NOW() ) 19/11/2025 12:12: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 = '99992' 19/11/2025 12:12:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '99992' 19/11/2025 12:12: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 ( '99992' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 19/11/2025 12:12: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 ( '99992' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '38.00' ) 19/11/2025 12:12: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 ( '99992' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 19/11/2025 12:12: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 ( '99992' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 19/11/2025 12:12: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 ( '99992' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 19/11/2025 12:12: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 ( '99992' , '24286' , 'DISEGNARE NUOVE MAPPE DI SPERANZA' , '2' , '-2' , '4' , '1.80' , '1.8' , '0' , '0' , '3.60' ) 19/11/2025 12:27:39 pm >> DELETE FROM ps_document WHERE id_document = '99823' 19/11/2025 12:27:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '99823' 19/11/2025 12:29:19 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' , '716508' , '2025-11-18' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.06' , '78.06' , NOW() , NOW() ) 19/11/2025 12:29: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 = '99993' 19/11/2025 12:29:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '99993' 19/11/2025 12:29: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 ( '99993' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '25' , '25' , '4' , '5.00' , '5' , '0' , '35+7' , '75.5625' ) 19/11/2025 12:29:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21436' AND id_supplier = '7' 19/11/2025 12:29:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21436' , '7' , '1' ) 19/11/2025 12:31:12 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' , '716509' , '2025-11-18' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.56' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.20' , '85.59' , NOW() , NOW() ) 19/11/2025 12:31:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99994' 19/11/2025 12:31:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '99994' 19/11/2025 12:31: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 ( '99994' , '24006' , 'TUTTI I COLORI DEL NATALE ' , '2' , '2' , '1' , '9.83' , '8.0573770491803' , '22' , '30' , '16.7896' ) 19/11/2025 12:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24006' AND id_supplier = '7' 19/11/2025 12:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24006' , '7' , '1' ) 19/11/2025 12:31: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 ( '99994' , '24007' , 'TUTTI I COLORI DEL NATALE ' , '2' , '2' , '3' , '10.48' , '10.076923076923' , '4' , '30' , '15.2589' ) 19/11/2025 12:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24007' AND id_supplier = '7' 19/11/2025 12:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24007' , '7' , '1' ) 19/11/2025 12:31: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 ( '99994' , '23789' , 'SAN PIERGIORGIO FRASSATI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35' , '9.1000' ) 19/11/2025 12:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23789' AND id_supplier = '7' 19/11/2025 12:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23789' , '7' , '1' ) 19/11/2025 12:31: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 ( '99994' , '22745' , 'VANGELO DEL CORAGGIO - TONINO BELLO' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '33' , '6.6330' ) 19/11/2025 12:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22745' AND id_supplier = '7' 19/11/2025 12:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22745' , '7' , '1' ) 19/11/2025 12:31: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 ( '99994' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '3' , '3' , '4' , '14.00' , '14' , '0' , '33' , '28.1400' ) 19/11/2025 12:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23966' AND id_supplier = '7' 19/11/2025 12:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23966' , '7' , '1' ) 19/11/2025 12:31: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 ( '99994' , '24255' , 'PAROLA DI CRISTO ANNO A - R. CANTALAMESSA' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 19/11/2025 12:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24255' AND id_supplier = '7' 19/11/2025 12:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24255' , '7' , '1' ) 19/11/2025 12:36:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '34' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 12:36:48 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' , '34' , '2025-11-19' , '' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , 'CATECHESI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '598.40' , '598.40' , NOW() , NOW() ) 19/11/2025 12:36:48 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 = '99995' 19/11/2025 12:36:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '99995' 19/11/2025 12:36:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99995' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:36:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99995' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:36:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99995' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '45' , '-45' , '4' , '3.80' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:36:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99995' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '45' , '-45' , '4' , '3.80' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:36:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99995' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.80' , '3.8' , '0' , '15' , '129.20' ) 19/11/2025 12:37:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '143/A' AND id_document != '99995' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 12:37:07 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '143/A', document_date = '2025-11-19', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'CATECHESI', 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 = '598.40', price_tax_excluded = '598.40', date_upd = NOW() WHERE id_document = '99995' 19/11/2025 12:37:07 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 = '99995' 19/11/2025 12:37:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '99995' 19/11/2025 12:37:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99995' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:37:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99995' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:37:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99995' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:37:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99995' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:37:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99995' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.8000' , '3.8' , '0' , '15' , '129.20' ) 19/11/2025 12:38:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '99774' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-07') 19/11/2025 12:38:17 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '137/A', document_date = '2025-11-07', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'CATECHESI', 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 = '598.40', price_tax_excluded = '598.40', date_upd = NOW() WHERE id_document = '99774' 19/11/2025 12:38: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 = '99774' 19/11/2025 12:38:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '99774' 19/11/2025 12:38: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 ( '99774' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:38: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 ( '99774' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:38: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 ( '99774' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:38: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 ( '99774' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:38: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 ( '99774' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.8000' , '3.8' , '0' , '15' , '129.20' ) 19/11/2025 12:38:25 pm >> DELETE FROM ps_document WHERE id_document = '99995' 19/11/2025 12:38:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '99995' 19/11/2025 12:48:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '99774' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-07') 19/11/2025 12:48:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '137/A', document_date = '2025-11-07', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'CATECHESI', 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 = '638.40', price_tax_excluded = '638.40', date_upd = NOW() WHERE id_document = '99774' 19/11/2025 12:48:54 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 = '99774' 19/11/2025 12:48:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '99774' 19/11/2025 12:48:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:48:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:48: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 ( '99774' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:48: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 ( '99774' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:48: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 ( '99774' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.8000' , '3.8' , '0' , '15' , '129.20' ) 19/11/2025 12:48: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 ( '99774' , '23583' , 'PIER GIORGIO FRASSATI - C. SICCARDI' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 19/11/2025 12:48: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 ( '99774' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 19/11/2025 12:50:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '99774' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-07') 19/11/2025 12:50:01 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '137/A', document_date = '2025-11-07', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'CATECHESI', 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 = '676.40', price_tax_excluded = '669.55', date_upd = NOW() WHERE id_document = '99774' 19/11/2025 12:50:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99774' 19/11/2025 12:50:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '99774' 19/11/2025 12:50:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:50:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:50:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:50:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:50:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.8000' , '3.8' , '0' , '15' , '129.20' ) 19/11/2025 12:50:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '23583' , 'PIER GIORGIO FRASSATI - C. SICCARDI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 19/11/2025 12:50:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 19/11/2025 12:50:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '38.00' ) 19/11/2025 12:52:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '99774' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-07') 19/11/2025 12:52:03 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '137/A', document_date = '2025-11-07', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'CATECHESI', 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 = '719.40', price_tax_excluded = '704.79', date_upd = NOW() WHERE id_document = '99774' 19/11/2025 12:52:03 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 = '99774' 19/11/2025 12:52:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '99774' 19/11/2025 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2025 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 19/11/2025 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.8000' , '3.8' , '0' , '15' , '129.20' ) 19/11/2025 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '23583' , 'PIER GIORGIO FRASSATI - C. SICCARDI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 19/11/2025 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 19/11/2025 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '38.00' ) 19/11/2025 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 19/11/2025 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99774' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 19/11/2025 12:57:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '246' AND id_document != '99989' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 12:57:06 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '246', document_date = '2025-11-19', document_letter = '', id_customer = '479', id_supplier = '', id_address = '4679233', address1 = 'VIA ORAZIO GAVIOLI 3 85100 POTENZA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '80.05', price_tax_excluded = '80.05', date_upd = NOW() WHERE id_document = '99989' 19/11/2025 12:57:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99989' 19/11/2025 12:57:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '99989' 19/11/2025 12:57:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99989' , '9675' , 'SARETE MIEI TESTIMONI' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 19/11/2025 12:57:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99989' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '0' , '35.00' ) 19/11/2025 12:57:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99989' , '6629' , 'MIA PREGHIERA' , '20' , '-20' , '4' , '0.9000' , '0.9' , '0' , '15' , '15.30' ) 19/11/2025 02:27: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 ( '33' , '249' , '2025-05-27' , '' , '0' , '95' , '2757' , 'VIA A. POLENGHI, 97 26845 CODOGNO' , '' , '' , '0.01' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.90' , '17.96' , NOW() , NOW() ) 19/11/2025 02:27: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 = '99996' 19/11/2025 02:27:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '99996' 19/11/2025 02:27: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 ( '99996' , '22433' , 'COPRI BOTTONE - 22178' , '1' , '1' , '1' , '9' , '7.3770491803279' , '22' , '3' , '10.6506' ) 19/11/2025 02:27:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22433' AND id_supplier = '95' 19/11/2025 02:27:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22433' , '95' , '1' ) 19/11/2025 02:27: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 ( '99996' , '16273' , 'GEMELLI MADREPERLA CROCE - 21774' , '1' , '1' , '1' , '9.5' , '7.7868852459016' , '22' , '3' , '11.2423' ) 19/11/2025 02:27:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16273' AND id_supplier = '95' 19/11/2025 02:27:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16273' , '95' , '1' ) 19/11/2025 03:28:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3845' AND id_document != '99980' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 03:28:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3845', document_date = '2025-11-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '189.00', price_tax_excluded = '154.92', date_upd = NOW() WHERE id_document = '99980' 19/11/2025 03: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 = '99980' 19/11/2025 03:28:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '99980' 19/11/2025 03: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 ( '99980' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 19/11/2025 03: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 ( '99980' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 19/11/2025 03: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 ( '99980' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 19/11/2025 03:30:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3796' AND id_document != '99907' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-14') 19/11/2025 03:30:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3796', document_date = '2025-11-14', 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 = '290.00', price_tax_excluded = '237.70', date_upd = NOW() WHERE id_document = '99907' 19/11/2025 03:30:03 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 = '99907' 19/11/2025 03:30:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '99907' 19/11/2025 03:30:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99907' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26' , '21.311475409836' , '22' , '0' , '26.00' ) 19/11/2025 03:30:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99907' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '88' , '-88' , '1' , '3' , '2.4590163934426' , '22' , '0' , '264.00' ) 19/11/2025 03:31:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3796' AND id_document != '99907' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-14') 19/11/2025 03:31:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3796', document_date = '2025-11-14', 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 = '290.00', price_tax_excluded = '237.70', date_upd = NOW() WHERE id_document = '99907' 19/11/2025 03:31: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 = '99907' 19/11/2025 03:31:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '99907' 19/11/2025 03:31: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 ( '99907' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '92' , '75.409836065574' , '22' , '0' , '92.00' ) 19/11/2025 03:31: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 ( '99907' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '66' , '-66' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '198.00' ) 19/11/2025 03:32:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3421' AND id_document != '99348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 19/11/2025 03:32:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3421', document_date = '2025-10-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1.30', price_tax_excluded = '1.07', date_upd = NOW() WHERE id_document = '99348' 19/11/2025 03:32:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99348' 19/11/2025 03:32:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '99348' 19/11/2025 03:32:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99348' , '17006' , 'SEGNALIBRO PR' , '1' , '-1' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '0.30' ) 19/11/2025 03:32:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99348' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/11/2025 03:33:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3501' AND id_document != '99462' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-24') 19/11/2025 03:33:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3501', document_date = '2025-10-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 = '15.20', price_tax_excluded = '12.46', date_upd = NOW() WHERE id_document = '99462' 19/11/2025 03:33:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99462' 19/11/2025 03:33:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '99462' 19/11/2025 03:33:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99462' , '13844' , 'COLLANINA IN ACCIAIO MADONNA - 1984/M14' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 19/11/2025 03:33:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99462' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 19/11/2025 03:33:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99462' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 19/11/2025 03:33:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99462' , '17006' , 'SEGNALIBRO PR' , '2' , '-2' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '0.70' ) 19/11/2025 03:33:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3487' AND id_document != '99441' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-24') 19/11/2025 03:33:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3487', document_date = '2025-10-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 = '200.00', price_tax_excluded = '189.68', date_upd = NOW() WHERE id_document = '99441' 19/11/2025 03:33: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 = '99441' 19/11/2025 03:33:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '99441' 19/11/2025 03:33: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 ( '99441' , '5929' , 'LODI E VESPRI' , '20' , '-20' , '4' , '4.5000' , '4.5' , '0' , '5' , '85.60' ) 19/11/2025 03:33: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 ( '99441' , '23916' , 'CE SPAZIO PER TE 2026 - 3-5 ANNI' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 19/11/2025 03:33: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 ( '99441' , '24076' , 'SAN CARLO ACUTIS - ARS 490' , '100' , '-100' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '15.00' ) 19/11/2025 03:33: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 ( '99441' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 19/11/2025 03:33: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 ( '99441' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '11.40' ) 19/11/2025 03:33: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 ( '99441' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '5' , '19.00' ) 19/11/2025 03:33: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 ( '99441' , '24016' , 'UN ANNO CON GESU - DA TAVOLO' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 19/11/2025 03:33: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 ( '99441' , '23802' , 'MIA SPERANZA E IN TE - AGGIUNTA LIBRETTO' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 19/11/2025 03:33: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 ( '99441' , '23803' , 'MIA SPERANZA E IN TE - AGGIUNTA SPARTITI' , '1' , '-1' , '3' , '10.0000' , '9.6153846153846' , '4' , '0' , '10.00' ) 19/11/2025 03:33: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 ( '99441' , '23931' , 'IO HO FATTO LA MIA PARTE 2026' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '5' , '5.70' ) 19/11/2025 03:33: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 ( '99441' , '24096' , 'AVVENTO E NATALE 2025/26' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 19/11/2025 03:33: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 ( '99441' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.6000' , '0.6' , '0' , '0' , '0.60' ) 19/11/2025 03:33: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 ( '99441' , '23920' , 'WORK IN PROGRESS ANNO A - EDUCATORI' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 19/11/2025 03:33: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 ( '99441' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '0.99' , '0.81147540983607' , '22' , '0' , '0.99' ) 19/11/2025 03:33: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 ( '99441' , '23807' , 'CALENDARIO LITURGICO 2026' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 19/11/2025 03:34:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3662' AND id_document != '99705' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 19/11/2025 03:34:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3662', document_date = '2025-11-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '7.90', price_tax_excluded = '6.48', date_upd = NOW() WHERE id_document = '99705' 19/11/2025 03:34:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99705' 19/11/2025 03:34:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '99705' 19/11/2025 03:34:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99705' , '19317' , 'ANGELO CON CUORE TORTORA - 4228' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 19/11/2025 03:34:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99705' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 19/11/2025 03:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99705' , '17006' , 'SEGNALIBRO PR' , '2' , '-2' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '0.70' ) 19/11/2025 03:34:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3671' AND id_document != '99721' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 19/11/2025 03:34:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3671', document_date = '2025-11-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '417.00', price_tax_excluded = '341.80', date_upd = NOW() WHERE id_document = '99721' 19/11/2025 03:34:48 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 = '99721' 19/11/2025 03:34:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '99721' 19/11/2025 03:34:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99721' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '2' , '-2' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '70.00' ) 19/11/2025 03:34:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99721' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '100.00' ) 19/11/2025 03:34:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99721' , '16767' , 'COPPIA CANDELIERI DA PROCESSIONE - 2591' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 19/11/2025 03:34:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99721' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 19/11/2025 03:34:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99721' , '20758' , 'SEGNALIBRO 5X15' , '20' , '-20' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '5.00' ) 19/11/2025 03:36:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3727' AND id_document != '99807' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-10') 19/11/2025 03:36:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3727', document_date = '2025-11-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '93.00', price_tax_excluded = '76.23', date_upd = NOW() WHERE id_document = '99807' 19/11/2025 03:36:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99807' 19/11/2025 03:36:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '99807' 19/11/2025 03:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99807' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '17.50' ) 19/11/2025 03:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99807' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 19/11/2025 03:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99807' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 19/11/2025 03:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99807' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 - AVRSTEL' , '25' , '-25' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '20.00' ) 19/11/2025 03:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99807' , '17006' , 'SEGNALIBRO PR' , '3' , '-3' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '1.20' ) 19/11/2025 03:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99807' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '38.00' ) 19/11/2025 03:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99807' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '3' , '-3' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '2.40' ) 19/11/2025 03:36:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3806' AND id_document != '99921' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-14') 19/11/2025 03:36:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3806', document_date = '2025-11-14', 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 = '13.00', price_tax_excluded = '10.66', date_upd = NOW() WHERE id_document = '99921' 19/11/2025 03:36:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99921' 19/11/2025 03:36:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '99921' 19/11/2025 03:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99921' , '24093' , 'ROSARIO ACUTIS - RE 1959-254' , '1' , '-1' , '1' , '5.6000' , '4.5901639344262' , '22' , '0' , '5.60' ) 19/11/2025 03:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99921' , '19600' , 'ROSARIO SPIRITO SANTO' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 19/11/2025 03:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99921' , '17006' , 'SEGNALIBRO PR' , '3' , '-3' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '1.20' ) 19/11/2025 03:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99921' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '3' , '-3' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '2.40' ) 19/11/2025 03:54:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3856' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 03:54: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 ( '11' , '3856' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 19/11/2025 03:54: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 = '99997' 19/11/2025 03:54:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '99997' 19/11/2025 03:54: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 ( '99997' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 19/11/2025 04:09:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3857' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 04:09:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3857' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.90' , '20.32' , NOW() , NOW() ) 19/11/2025 04:09:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99998' 19/11/2025 04:09:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '99998' 19/11/2025 04:09:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99998' , '24006' , 'TUTTI I COLORI DEL NATALE ' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 19/11/2025 04:09:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99998' , '24007' , 'TUTTI I COLORI DEL NATALE ' , '1' , '-1' , '3' , '10.90' , '10.480769230769' , '4' , '0' , '10.90' ) 19/11/2025 04:14:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '248' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 04:14:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '248' , '2025-11-19' , '' , '2021' , '0' , '4672489' , 'VIA ROMA, 134 80040 S. GENNARO VESUVIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '182.75' , '182.75' , NOW() , NOW() ) 19/11/2025 04:14:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99999' 19/11/2025 04:14:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '99999' 19/11/2025 04:14:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99999' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 19/11/2025 04:14:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99999' , '8408' , 'PRENDETE E MANGIATE' , '60' , '-60' , '4' , '3.00' , '3' , '0' , '15' , '153.00' ) 19/11/2025 04:35:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3858' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 04:35: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' , '3858' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 19/11/2025 04:35: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 = '100000' 19/11/2025 04:35:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '100000' 19/11/2025 04:35: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 ( '100000' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '15' , '-15' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '15.00' ) 19/11/2025 04:39:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3859' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 04:39: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' , '3859' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.90' , '20.32' , NOW() , NOW() ) 19/11/2025 04:39: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 = '100001' 19/11/2025 04:39:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '100001' 19/11/2025 04:39: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 ( '100001' , '24006' , 'TUTTI I COLORI DEL NATALE ' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 19/11/2025 04:39: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 ( '100001' , '24007' , 'TUTTI I COLORI DEL NATALE ' , '1' , '-1' , '3' , '10.90' , '10.480769230769' , '4' , '0' , '10.90' ) 19/11/2025 04:42:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '143/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 04:42:12 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' , '143/A' , '2025-11-19' , 'A' , '316' , '0' , '4669506' , 'VIA VITO LEMBO, 2 84020 PALOMONTE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.11' , '58.11' , NOW() , NOW() ) 19/11/2025 04:42:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100002' 19/11/2025 04:42:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '100002' 19/11/2025 04:42: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 ( '100002' , '13397' , 'MIO GESU' , '5' , '-5' , '4' , '3.50' , '3.5' , '0' , '15' , '14.88' ) 19/11/2025 04:42: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 ( '100002' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '5' , '43.23' ) 19/11/2025 05:10:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3860' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 05:10:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3860' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '34.35' , NOW() , NOW() ) 19/11/2025 05:10:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100003' 19/11/2025 05:10:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '100003' 19/11/2025 05:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100003' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 19/11/2025 05:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100003' , '14649' , 'COMPENDIO AL CATECHISMO DI PIO X' , '10' , '-10' , '4' , '1.60' , '1.6' , '0' , '0' , '16.00' ) 19/11/2025 05:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100003' , '16265' , 'MIE PREGHIERE' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '0' , '10.00' ) 19/11/2025 05:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100003' , '6629' , 'MIA PREGHIERA' , '6' , '-6' , '4' , '0.90' , '0.9' , '0' , '0' , '5.40' ) 19/11/2025 05:22:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3861' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 05:22: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' , '3861' , '2025-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 19/11/2025 05:22: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 = '100004' 19/11/2025 05:22:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '100004' 19/11/2025 05:22: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 ( '100004' , '24291' , 'STATUA S. RITA CM 20 - 324' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 19/11/2025 05:22: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 ( '100004' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 19/11/2025 05:33:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '144/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-19') 19/11/2025 05:33:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '144/A' , '2025-11-19' , 'A' , '1656' , '0' , '4679422' , 'VIA NAZIONALE 84060 OMIGNANO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.15' , '33.15' , NOW() , NOW() ) 19/11/2025 05:33:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100005' 19/11/2025 05:33:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '100005' 19/11/2025 05:33:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100005' , '4154' , 'FESTA DEL PERDONO' , '12' , '-12' , '4' , '3.00' , '3' , '0' , '15' , '30.60' ) 19/11/2025 05:33:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100005' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' )