22/04/2025 07:18:13 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/04/2025 07:18:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23685' , '1' , '' , 'nuovo-prodotto' ) 22/04/2025 07:18:13 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23685' , '1' , '1' , '2' , NOW() , NOW() ) 22/04/2025 07:18:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23685' , '0' , '1' , '0' , '0' ) 22/04/2025 09:08:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1329' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 09:08:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1329' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.00' , '35.45' , NOW() , NOW() ) 22/04/2025 09:08:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96786' 22/04/2025 09:08:55 am >> DELETE FROM ps_document_detail WHERE id_document = '96786' 22/04/2025 09:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96786' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 22/04/2025 09:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96786' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 22/04/2025 09:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96786' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/04/2025 09:10:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1330' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 09:10: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' , '1330' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.00' , '35.45' , NOW() , NOW() ) 22/04/2025 09:10: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 = '96787' 22/04/2025 09:10:07 am >> DELETE FROM ps_document_detail WHERE id_document = '96787' 22/04/2025 09:10: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 ( '96787' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 22/04/2025 09:10: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 ( '96787' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 22/04/2025 09:10: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 ( '96787' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/04/2025 10:26:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1331' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 10:26:48 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' , '1331' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 22/04/2025 10:26: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 = '96788' 22/04/2025 10:26:48 am >> DELETE FROM ps_document_detail WHERE id_document = '96788' 22/04/2025 10:26: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 ( '96788' , '19756' , 'CAMICIA STOCK' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 22/04/2025 10:35:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1332' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/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' , '1332' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '145.10' , '127.16' , NOW() , NOW() ) 22/04/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 = '96789' 22/04/2025 10:35:25 am >> DELETE FROM ps_document_detail WHERE id_document = '96789' 22/04/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 ( '96789' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '11' , '-11' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '49.50' ) 22/04/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 ( '96789' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 22/04/2025 10:35:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96789' , '23511' , 'ALLENA LA SPERANZA - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 22/04/2025 10:35:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96789' , '22727' , 'SETTE SEGNI PER CREDERE - S. STEVAN' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 22/04/2025 10:35:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96789' , '20312' , 'LIETA E LA NOTTE - O. MANGIACAPRA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 22/04/2025 10:41:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1333' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 10:41: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' , '1333' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 22/04/2025 10:41: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 = '96790' 22/04/2025 10:41:31 am >> DELETE FROM ps_document_detail WHERE id_document = '96790' 22/04/2025 10:41: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 ( '96790' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '6' , '-6' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '9.00' ) 22/04/2025 10:57:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1334' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 10:57: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' , '1334' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 22/04/2025 10:57: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 = '96791' 22/04/2025 10:57:41 am >> DELETE FROM ps_document_detail WHERE id_document = '96791' 22/04/2025 10:57: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 ( '96791' , '23680' , 'REGISTRO DELLE MESSE - SHA' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/04/2025 11:39:54 am >> SELECT document_num FROM ps_document WHERE document_num = '60/A' AND id_document != '96226' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-13') 22/04/2025 11:39:54 am >> UPDATE ps_document SET id_document_type = '24', document_num = '60/A', document_date = '2025-03-13', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = 'MATERIALE india', 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 = '3243.70', price_tax_excluded = '2678.61', date_upd = NOW() WHERE id_document = '96226' 22/04/2025 11:39:54 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 = '96226' 22/04/2025 11:39:54 am >> DELETE FROM ps_document_detail WHERE id_document = '96226' 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '7202' , 'CASULE' , '13' , '-13' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '910.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '21377' , 'CASULA POLIESTERE IHS' , '2' , '-2' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '130.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '0' , 'CASULA' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '11265' , 'COPRILEGGIO - 881' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '0' , 'COPRI AMBONE' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '0' , 'COPRI AMBONE' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '14924' , 'STOLA - PST015' , '2' , '-2' , '1' , '90.0000' , '73.770491803279' , '22' , '0' , '180.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '16188' , 'STOLA QUATTRO EVANGELISTI - PST009' , '1' , '-1' , '1' , '70.8000' , '58.032786885246' , '22' , '0' , '70.80' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '0' , 'STOLA' , '4' , '-4' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '240.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '0' , 'STOLA' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '20644' , 'STOLA - PST022' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '23547' , 'STOLA RICAMO CROCE - 652' , '2' , '-2' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '100.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '10251' , 'STOLA ST 340' , '1' , '-1' , '1' , '130.0000' , '106.55737704918' , '22' , '0' , '130.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '10244' , 'STOLE' , '4' , '-4' , '1' , '130.0000' , '106.55737704918' , '22' , '0' , '520.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '33.9000' , '27.786885245902' , '22' , '0' , '33.90' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '545' , 'AMPOLLE STYLE CON RICAMBIO - CC100 - 1507' , '1' , '-1' , '1' , '87.0000' , '71.311475409836' , '22' , '0' , '87.00' ) 22/04/2025 11:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '11624' , 'PALLA 16X16 - SERV 3 ' , '5' , '-5' , '1' , '5.9000' , '4.8360655737705' , '22' , '0' , '29.50' ) 22/04/2025 11:39:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '5' , '-5' , '1' , '7.8000' , '6.3934426229508' , '22' , '0' , '39.00' ) 22/04/2025 11:39:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '5' , '-5' , '1' , '6.7000' , '5.4918032786885' , '22' , '0' , '33.50' ) 22/04/2025 11:39:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '5' , '-5' , '1' , '12.2000' , '10' , '22' , '0' , '61.00' ) 22/04/2025 11:39:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '' , 'CAMICE' , '2' , '-2' , '0' , '55' , '55' , '' , '0' , '110.00' ) 22/04/2025 11:39:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96226' , '12662' , 'CAMICE BIANCO - MISTO COT. 155' , '2' , '-2' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '110.00' ) 22/04/2025 11:43:03 am >> SELECT document_num FROM ps_document WHERE document_num = '67/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 11:43:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '67/A' , '2025-04-22' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2240.00' , '2240.00' , NOW() , NOW() ) 22/04/2025 11:43:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96792' 22/04/2025 11:43:03 am >> DELETE FROM ps_document_detail WHERE id_document = '96792' 22/04/2025 11:43:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96792' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '640' , '-640' , '4' , '3.50' , '3.5' , '0' , '0' , '2240.00' ) 22/04/2025 11:43:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96792' , '21290' , 'ROSARIO ADDOLORATA' , '275' , '-275' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 22/04/2025 11:55:47 am >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 11:55:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '68/A' , '2025-04-22' , 'A' , '3882' , '0' , '4674171' , 'PLACE D\\\'ABOURD 25 - 84300 CAVAILLON' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.20' , '101.80' , NOW() , NOW() ) 22/04/2025 11:55:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96793' 22/04/2025 11:55:47 am >> DELETE FROM ps_document_detail WHERE id_document = '96793' 22/04/2025 11:55:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96793' , '11756' , 'VINO BIANCO SECCO - 14%' , '18' , '-18' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '124.20' ) 22/04/2025 11:58:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1335' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 11:58:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1335' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , 'PADRE ENZO DE MARTINO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '180.33' , NOW() , NOW() ) 22/04/2025 11:58:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96794' 22/04/2025 11:58:36 am >> DELETE FROM ps_document_detail WHERE id_document = '96794' 22/04/2025 11:58:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96794' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '10' , '-10' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '220.00' ) 22/04/2025 11:58:46 am >> DELETE FROM ps_document WHERE id_document = '96794' 22/04/2025 11:58:46 am >> DELETE FROM ps_document_detail WHERE id_document = '96794' 22/04/2025 11:59:24 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 11:59: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 ( '24' , '69/A' , '2025-04-22' , 'A' , '0' , '0' , '0' , '' , '' , 'PADRE ENZO DE MARTINO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '180.33' , NOW() , NOW() ) 22/04/2025 11:59: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 = '96795' 22/04/2025 11:59:24 am >> DELETE FROM ps_document_detail WHERE id_document = '96795' 22/04/2025 11:59: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 ( '96795' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '10' , '-10' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '220.00' ) 22/04/2025 12:16:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1335' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 12:16:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1335' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '6.00' , NOW() , NOW() ) 22/04/2025 12:16:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96796' 22/04/2025 12:16:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '96796' 22/04/2025 12:16:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96796' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6' , '6' , '0' , '0' , '6.00' ) 22/04/2025 12:34:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 22/04/2025 12:34:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '43.70', price_tax_excluded = '39.31', date_upd = NOW() WHERE id_document = '94912' 22/04/2025 12:34: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 = '94912' 22/04/2025 12:34:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '94912' 22/04/2025 12:34: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 ( '94912' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/04/2025 12:34: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 ( '94912' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 22/04/2025 12:34: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 ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 22/04/2025 12:34: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 ( '94912' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 22/04/2025 12:34: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 ( '94912' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 22/04/2025 12:34: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 ( '94912' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '0' , '10.00' ) 22/04/2025 12:56:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1336' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 12:56:49 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' , '1336' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '971.00' , '811.40' , NOW() , NOW() ) 22/04/2025 12:56: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 = '96797' 22/04/2025 12:56:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '96797' 22/04/2025 12:56: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 ( '96797' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '15' , '15' , '0' , '0' , '60.00' ) 22/04/2025 12:56: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 ( '96797' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '24' , '19.672131147541' , '22' , '0' , '48.00' ) 22/04/2025 12:56: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 ( '96797' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145' , '118.85245901639' , '22' , '0' , '145.00' ) 22/04/2025 12:56: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 ( '96797' , '16796' , 'LUMINO 5B BIANCO' , '3360' , '-3360' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '672.00' ) 22/04/2025 12:56: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 ( '96797' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/04/2025 12:56: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 ( '96797' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 22/04/2025 12:56: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 ( '96797' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 22/04/2025 12:56: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 ( '96797' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 22/04/2025 12:58:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1337' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 12:58:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1337' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1046.80' , '880.10' , NOW() , NOW() ) 22/04/2025 12:58: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 = '96798' 22/04/2025 12:58:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '96798' 22/04/2025 12:58: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 ( '96798' , '16796' , 'LUMINO 5B BIANCO' , '2016' , '-2016' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '403.20' ) 22/04/2025 12:58: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 ( '96798' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '24' , '19.672131147541' , '22' , '0' , '120.00' ) 22/04/2025 12:58: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 ( '96798' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145' , '118.85245901639' , '22' , '0' , '145.00' ) 22/04/2025 12:58: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 ( '96798' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/04/2025 12:58: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 ( '96798' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 22/04/2025 12:58: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 ( '96798' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 22/04/2025 12:58: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 ( '96798' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 22/04/2025 12:58: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 ( '96798' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 22/04/2025 12:58: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 ( '96798' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 22/04/2025 12:58: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 ( '96798' , '6405' , 'MENSA DIAM 40X250 - M4025' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 22/04/2025 12:58: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 ( '96798' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '8' , '-8' , '4' , '0.70' , '0.7' , '0' , '0' , '5.60' ) 22/04/2025 12:58: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 ( '96798' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 22/04/2025 12:58: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 ( '96798' , '17141' , 'RICAMBIO VETRO - 34/V' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 22/04/2025 12:58: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 ( '96798' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '15' , '15' , '0' , '0' , '90.00' ) 22/04/2025 01:01:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '95744' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-14') 22/04/2025 01:01:30 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2025-02-14', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '366.00', price_tax_excluded = '300.00', date_upd = NOW() WHERE id_document = '95744' 22/04/2025 01:01:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95744' 22/04/2025 01:01:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '95744' 22/04/2025 01:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '22316' , 'PIVIALE - P1P858' , '1' , '-1' , '1' , '315.0000' , '258.19672131148' , '22' , '0' , '315.00' ) 22/04/2025 01:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '20516' , 'CROCE COMUNIONE - 42/08' , '30' , '-30' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '36.00' ) 22/04/2025 01:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '7907' , 'PERGAMENE' , '30' , '-30' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '15.00' ) 22/04/2025 02:20:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1194' AND id_document != '96633' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-11') 22/04/2025 02:20:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1194', document_date = '2025-04-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.00', price_tax_excluded = '33.31', date_upd = NOW() WHERE id_document = '96633' 22/04/2025 02:20:41 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 = '96633' 22/04/2025 02:20:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '96633' 22/04/2025 02:20:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96633' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 22/04/2025 02:20:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96633' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 22/04/2025 02:20:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96633' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 22/04/2025 02:20:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96633' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/04/2025 02:20:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96633' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 22/04/2025 02:20:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96633' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 22/04/2025 02:23:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '801' AND id_document != '96146' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-10') 22/04/2025 02:23:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '801', document_date = '2025-03-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 = '293.82', price_tax_excluded = '248.15', date_upd = NOW() WHERE id_document = '96146' 22/04/2025 02:23: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 = '96146' 22/04/2025 02:23:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '96146' 22/04/2025 02:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96146' , '23409' , 'VIA CRUCIS DEL GIUBILEO - RUCCIA/SCALERA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 22/04/2025 02:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96146' , '14553' , 'LECTIO DIVINA - G. ZEVINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 22/04/2025 02:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96146' , '23365' , 'VIA CRUCIS DEL PELLEGRINO ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 22/04/2025 02:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96146' , '23357' , 'QUARESIMA 2025 - ALLE SORGENTI DELLA SPERANZA' , '1' , '-1' , '4' , '3.6000' , '3.6' , '0' , '5' , '3.42' ) 22/04/2025 02:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96146' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 22/04/2025 02:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96146' , '23137' , 'PREGHIERE ALLO SPIRITO SANTO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 22/04/2025 02:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96146' , '23605' , 'CALICE BAROCCO - 1887' , '1' , '-1' , '1' , '253' , '207.37704918033' , '22' , '0' , '253.00' ) 22/04/2025 02:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96146' , '20969' , 'MEDAGLIA ADDOLORATA' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 22/04/2025 02:25:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '945' AND id_document != '96329' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-21') 22/04/2025 02:25:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '945', document_date = '2025-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '67.00', price_tax_excluded = '54.92', date_upd = NOW() WHERE id_document = '96329' 22/04/2025 02:25: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 = '96329' 22/04/2025 02:25:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '96329' 22/04/2025 02:25: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 ( '96329' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '17.75' , '14.549180327869' , '22' , '0' , '17.75' ) 22/04/2025 02:25: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 ( '96329' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 22/04/2025 02:25: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 ( '96329' , '17783' , 'MEDAGLIA OVALE S. GIUSEPPE CM 2,2 ' , '89' , '-89' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '22.25' ) 22/04/2025 02:25: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 ( '96329' , '13712' , 'SERIE VIA CRUCIS - 22X30 ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 22/04/2025 02:42:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1123' AND id_document != '96550' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-07') 22/04/2025 02:42:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1123', document_date = '2025-04-07', 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 = '186.00', price_tax_excluded = '152.46', date_upd = NOW() WHERE id_document = '96550' 22/04/2025 02:42: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 = '96550' 22/04/2025 02:42:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '96550' 22/04/2025 02:42: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 ( '96550' , '12126' , 'MERLETTO CM 15 - CROCE E CALICE' , '3' , '-3' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '36.00' ) 22/04/2025 02:42: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 ( '96550' , '12541' , 'COMPLETO CROCE E CANDELIERE - KOL/M' , '1' , '-1' , '1' , '90.0000' , '73.770491803279' , '22' , '0' , '90.00' ) 22/04/2025 02:42: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 ( '96550' , '16796' , 'LUMINO 5B BIANCO' , '200' , '-200' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '60.00' ) 22/04/2025 02:43:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '948' AND id_document != '96332' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-21') 22/04/2025 02:43:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '948', document_date = '2025-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '96332' 22/04/2025 02:43:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96332' 22/04/2025 02:43:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '96332' 22/04/2025 02:43:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96332' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 22/04/2025 02:43:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96332' , '16796' , 'LUMINO 5B BIANCO' , '180' , '-180' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '54.00' ) 22/04/2025 02:44:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '991' AND id_document != '96383' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 22/04/2025 02:44:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '991', document_date = '2025-03-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '87.00', price_tax_excluded = '71.31', date_upd = NOW() WHERE id_document = '96383' 22/04/2025 02:44: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 = '96383' 22/04/2025 02:44:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '96383' 22/04/2025 02:44: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 ( '96383' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 22/04/2025 02:44: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 ( '96383' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/04/2025 02:44: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 ( '96383' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '2' , '-2' , '1' , '11.5000' , '9.4262295081967' , '22' , '0' , '23.00' ) 22/04/2025 02:44: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 ( '96383' , '16796' , 'LUMINO 5B BIANCO' , '180' , '-180' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '54.00' ) 22/04/2025 02:44:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '999' AND id_document != '96394' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 22/04/2025 02:44:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '999', document_date = '2025-03-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '84.50', price_tax_excluded = '69.53', date_upd = NOW() WHERE id_document = '96394' 22/04/2025 02:44:22 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 = '96394' 22/04/2025 02:44:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '96394' 22/04/2025 02:44:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96394' , '22211' , 'CROCE IN RESINA 29X20 - 1017' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 22/04/2025 02:44:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96394' , '23550' , 'SAN CARLO ACUTIS - 8361' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 22/04/2025 02:44:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96394' , '16796' , 'LUMINO 5B BIANCO' , '150' , '-150' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '45.00' ) 22/04/2025 02:44:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1026' AND id_document != '96434' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 22/04/2025 02:44:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1026', document_date = '2025-03-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '96434' 22/04/2025 02:44:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96434' 22/04/2025 02:44:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '96434' 22/04/2025 02:44:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96434' , '16796' , 'LUMINO 5B BIANCO' , '150' , '-150' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '45.00' ) 22/04/2025 02:45:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1044' AND id_document != '96457' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-01') 22/04/2025 02:45:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1044', document_date = '2025-04-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '96457' 22/04/2025 02:45:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96457' 22/04/2025 02:45:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '96457' 22/04/2025 02:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96457' , '16796' , 'LUMINO 5B BIANCO' , '150' , '-150' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '45.00' ) 22/04/2025 02:46:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1049' AND id_document != '96463' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-01') 22/04/2025 02:46:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1049', document_date = '2025-04-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '103.50', price_tax_excluded = '94.52', date_upd = NOW() WHERE id_document = '96463' 22/04/2025 02:46: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 = '96463' 22/04/2025 02:46:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '96463' 22/04/2025 02:46: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 ( '96463' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 22/04/2025 02:46: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 ( '96463' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 22/04/2025 02:46: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 ( '96463' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 22/04/2025 02:46: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 ( '96463' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '5' , '28.50' ) 22/04/2025 02:46: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 ( '96463' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/04/2025 02:46: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 ( '96463' , '16796' , 'LUMINO 5B BIANCO' , '110' , '-110' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '33.00' ) 22/04/2025 02:46:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1082' AND id_document != '96506' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-04') 22/04/2025 02:46:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1082', document_date = '2025-04-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '96506' 22/04/2025 02:46:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96506' 22/04/2025 02:46:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '96506' 22/04/2025 02:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96506' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 22/04/2025 02:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96506' , '16796' , 'LUMINO 5B BIANCO' , '120' , '-120' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '36.00' ) 22/04/2025 02:47:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1177' AND id_document != '96614' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-10') 22/04/2025 02:47:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1177', document_date = '2025-04-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA BRIGNANO INF 84135 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 = '131.50', price_tax_excluded = '113.91', date_upd = NOW() WHERE id_document = '96614' 22/04/2025 02:47:38 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 = '96614' 22/04/2025 02:47:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '96614' 22/04/2025 02:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96614' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '0' , '7.00' ) 22/04/2025 02:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96614' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '3' , '-3' , '4' , '3.5000' , '3.5' , '0' , '0' , '10.50' ) 22/04/2025 02:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96614' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 22/04/2025 02:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96614' , '16796' , 'LUMINO 5B BIANCO' , '150' , '-150' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '45.00' ) 22/04/2025 02:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96614' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 22/04/2025 02:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96614' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/04/2025 02:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96614' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '49.0000' , '40.16393442623' , '22' , '0' , '49.00' ) 22/04/2025 02:48:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1294' AND id_document != '96744' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 22/04/2025 02:48:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1294', document_date = '2025-04-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '61.00', price_tax_excluded = '50.00', date_upd = NOW() WHERE id_document = '96744' 22/04/2025 02:48: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 = '96744' 22/04/2025 02:48:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '96744' 22/04/2025 02:48: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 ( '96744' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 22/04/2025 02:48: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 ( '96744' , '16796' , 'LUMINO 5B BIANCO' , '200' , '-200' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '60.00' ) 22/04/2025 02:50:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1337' AND id_document != '96798' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 02:50:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1337', document_date = '2025-04-22', 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 = '1046.80', price_tax_excluded = '880.10', date_upd = NOW() WHERE id_document = '96798' 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96798' 22/04/2025 02:50:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '96798' 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '16796' , 'LUMINO 5B BIANCO' , '476' , '-476' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '95.20' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '120.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '145.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '28.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '6405' , 'MENSA DIAM 40X250 - M4025' , '10' , '-10' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '35.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '8' , '-8' , '4' , '0.7000' , '0.7' , '0' , '0' , '5.60' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '17141' , 'RICAMBIO VETRO - 34/V' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '15.0000' , '15' , '0' , '0' , '90.00' ) 22/04/2025 02:50:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '23605' , 'CALICE BAROCCO - 1887' , '1' , '-1' , '1' , '308' , '252.45901639344' , '22' , '0' , '308.00' ) 22/04/2025 03:06:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1030' AND id_document != '96439' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 22/04/2025 03:06:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1030', document_date = '2025-03-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '56.20', price_tax_excluded = '46.07', date_upd = NOW() WHERE id_document = '96439' 22/04/2025 03:06: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 = '96439' 22/04/2025 03:06:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '96439' 22/04/2025 03:06: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 ( '96439' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 22/04/2025 03:06: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 ( '96439' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '25' , '-25' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '55.00' ) 22/04/2025 03:06:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1051' AND id_document != '96465' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-01') 22/04/2025 03:06:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1051', document_date = '2025-04-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '52.00', price_tax_excluded = '42.62', date_upd = NOW() WHERE id_document = '96465' 22/04/2025 03:06:41 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 = '96465' 22/04/2025 03:06:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '96465' 22/04/2025 03:06:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96465' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '26' , '-26' , '1' , '2' , '1.6393442622951' , '22' , '0' , '52.00' ) 22/04/2025 03:07:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1076' AND id_document != '96500' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-03') 22/04/2025 03:07:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1076', document_date = '2025-04-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '47.50', price_tax_excluded = '38.93', date_upd = NOW() WHERE id_document = '96500' 22/04/2025 03:07: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 = '96500' 22/04/2025 03:07:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '96500' 22/04/2025 03:07: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 ( '96500' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 22/04/2025 03:07: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 ( '96500' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 22/04/2025 03:07: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 ( '96500' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 22/04/2025 03:07: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 ( '96500' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '20' , '-20' , '1' , '2' , '1.6393442622951' , '22' , '0' , '40.00' ) 22/04/2025 03:08:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1091' AND id_document != '96517' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-04') 22/04/2025 03:08:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1091', document_date = '2025-04-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '52.50', price_tax_excluded = '43.03', date_upd = NOW() WHERE id_document = '96517' 22/04/2025 03:08:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96517' 22/04/2025 03:08:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '96517' 22/04/2025 03:08:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96517' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 22/04/2025 03:08:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96517' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '26' , '-26' , '1' , '2' , '1.6393442622951' , '22' , '0' , '52.00' ) 22/04/2025 03:09:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1064' AND id_document != '96482' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 22/04/2025 03:09:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1064', document_date = '2025-04-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '29.00', price_tax_excluded = '25.26', date_upd = NOW() WHERE id_document = '96482' 22/04/2025 03:09:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96482' 22/04/2025 03:09:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '96482' 22/04/2025 03:09:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96482' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 22/04/2025 03:09:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96482' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 22/04/2025 03:09:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96482' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '9' , '-9' , '1' , '2' , '1.6393442622951' , '22' , '0' , '18.00' ) 22/04/2025 03:11:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1099' AND id_document != '96525' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-05') 22/04/2025 03:11:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1099', document_date = '2025-04-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 = '205.00', price_tax_excluded = '177.77', date_upd = NOW() WHERE id_document = '96525' 22/04/2025 03:11:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96525' 22/04/2025 03:11:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '96525' 22/04/2025 03:11:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96525' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '27.00' ) 22/04/2025 03:11:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96525' , '18045' , 'TECA INCISA - 515' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '28.00' ) 22/04/2025 03:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96525' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '8' , '-8' , '1' , '2' , '1.6393442622951' , '22' , '0' , '16.00' ) 22/04/2025 03:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96525' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 22/04/2025 03:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96525' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '10.0000' , '10' , '0' , '0' , '50.00' ) 22/04/2025 03:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96525' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/04/2025 03:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96525' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 22/04/2025 03:12:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1197' AND id_document != '96636' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-11') 22/04/2025 03:12:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1197', document_date = '2025-04-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '47.40', price_tax_excluded = '38.85', date_upd = NOW() WHERE id_document = '96636' 22/04/2025 03:12: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 = '96636' 22/04/2025 03:12:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '96636' 22/04/2025 03:12: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 ( '96636' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 22/04/2025 03:12: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 ( '96636' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '8' , '-8' , '1' , '2' , '1.6393442622951' , '22' , '0' , '16.00' ) 22/04/2025 03:12: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 ( '96636' , '13506' , 'SANTO ROSARIO' , '20' , '-20' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '6.00' ) 22/04/2025 03:12: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 ( '96636' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 22/04/2025 03:38:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1338' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 03:38:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1338' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 22/04/2025 03:38: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 = '96799' 22/04/2025 03:38:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '96799' 22/04/2025 03:38: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 ( '96799' , '23516' , 'MESSALINO QUOTIDIANO MAG GIU LUG' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 22/04/2025 03:43:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '878' AND id_document != '96248' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-15') 22/04/2025 03:43:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '878', document_date = '2025-03-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '58.90', price_tax_excluded = '48.98', date_upd = NOW() WHERE id_document = '96248' 22/04/2025 03:43:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96248' 22/04/2025 03:43:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '96248' 22/04/2025 03:43: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 ( '96248' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12.8' , '10.491803278689' , '22' , '0' , '12.80' ) 22/04/2025 03:43: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 ( '96248' , '18551' , 'IO CREDO' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/04/2025 03:43: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 ( '96248' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 22/04/2025 03:43: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 ( '96248' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 22/04/2025 03:55:17 pm >> DELETE FROM ps_document WHERE id_document = '96795' 22/04/2025 03:55:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '96795' 22/04/2025 03:55:43 pm >> DELETE FROM ps_document WHERE id_document = '96793' 22/04/2025 03:55:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '96793' 22/04/2025 03:56:02 pm >> DELETE FROM ps_document WHERE id_document = '96792' 22/04/2025 03:56:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '96792' 22/04/2025 03:56:33 pm >> DELETE FROM ps_document WHERE id_document = '96226' 22/04/2025 03:56:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '96226' 22/04/2025 03:59:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '540' AND id_document != '95812' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 22/04/2025 03:59:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '540', document_date = '2025-02-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 = '159.04', price_tax_excluded = '148.34', date_upd = NOW() WHERE id_document = '95812' 22/04/2025 03:59: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 = '95812' 22/04/2025 03:59:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '95812' 22/04/2025 03:59: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 ( '95812' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.92' ) 22/04/2025 03:59: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 ( '95812' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.92' ) 22/04/2025 03:59: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 ( '95812' , '4443' , 'GESÙ ENTRÒ PER RIMANERE CON LORO - A. FONTANA' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 22/04/2025 03:59: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 ( '95812' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 22/04/2025 03:59: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 ( '95812' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 22/04/2025 03:59: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 ( '95812' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 22/04/2025 03:59: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 ( '95812' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 22/04/2025 03:59: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 ( '95812' , '23165' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 22/04/2025 03:59: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 ( '95812' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 22/04/2025 03:59: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 ( '95812' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 22/04/2025 03:59: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 ( '95812' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '10' , '-10' , '4' , '1.9000' , '1.9' , '0' , '5' , '18.10' ) 22/04/2025 03:59: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 ( '95812' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '11.00' ) 22/04/2025 03:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '20301' , 'CREDIAMO - LE PRINCIPALI VERITA DI FEDE' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '0' , '0.90' ) 22/04/2025 03:59:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '878' AND id_document != '96248' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-15') 22/04/2025 03:59:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '878', document_date = '2025-03-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '58.90', price_tax_excluded = '48.98', date_upd = NOW() WHERE id_document = '96248' 22/04/2025 03:59:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96248' 22/04/2025 03:59:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '96248' 22/04/2025 03:59:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96248' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.4' , '5.2459016393443' , '22' , '0' , '12.80' ) 22/04/2025 03:59:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96248' , '18551' , 'IO CREDO' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/04/2025 03:59:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96248' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 22/04/2025 03:59:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96248' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 22/04/2025 04:00:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '945' AND id_document != '96329' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-21') 22/04/2025 04:00:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '945', document_date = '2025-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '67.00', price_tax_excluded = '54.92', date_upd = NOW() WHERE id_document = '96329' 22/04/2025 04:00:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96329' 22/04/2025 04:00:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '96329' 22/04/2025 04:00: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 ( '96329' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' , '11.75' , '9.6311475409836' , '22' , '0' , '11.75' ) 22/04/2025 04:00: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 ( '96329' , '17783' , 'MEDAGLIA OVALE S. GIUSEPPE CM 2,2 ' , '89' , '-89' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '22.25' ) 22/04/2025 04:00: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 ( '96329' , '13712' , 'SERIE VIA CRUCIS - 22X30 ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 22/04/2025 04:00: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 ( '96329' , '11756' , 'VINO BIANCO SECCO - 14%' , '3' , '-3' , '1' , '6' , '4.9180327868852' , '22' , '0' , '18.00' ) 22/04/2025 04:00:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1072' AND id_document != '96495' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-03') 22/04/2025 04:00:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1072', document_date = '2025-04-03', 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 = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '96495' 22/04/2025 04:00:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96495' 22/04/2025 04:00:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '96495' 22/04/2025 04:00:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96495' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 22/04/2025 04:00:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96495' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 22/04/2025 04:01:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1100' AND id_document != '96526' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-05') 22/04/2025 04:01:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1100', document_date = '2025-04-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 = '75.00', price_tax_excluded = '61.48', date_upd = NOW() WHERE id_document = '96526' 22/04/2025 04:01:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96526' 22/04/2025 04:01:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '96526' 22/04/2025 04:01: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 ( '96526' , '15000' , 'TECA ALTA IHS - 825' , '2' , '-2' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '68.00' ) 22/04/2025 04:01: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 ( '96526' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 22/04/2025 04:01:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1151' AND id_document != '96582' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-09') 22/04/2025 04:01:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1151', document_date = '2025-04-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '344.48', price_tax_excluded = '291.86', date_upd = NOW() WHERE id_document = '96582' 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96582' 22/04/2025 04:01:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '96582' 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '170.0000' , '139.34426229508' , '22' , '0' , '170.00' ) 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '13.00' ) 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '28.00' ) 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '7952' , 'PERSONAGGI BIBLICI DEL TEMPO PASQUALE' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '5' , '9.03' ) 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '22259' , 'SETTIMANA SANTA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '30' , '-30' , '4' , '0.8500' , '0.85' , '0' , '0' , '25.50' ) 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '17.90' ) 22/04/2025 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96582' , '2756' , 'CORONA ANGELICA - 8197' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 22/04/2025 04:02:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1137' AND id_document != '96567' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-08') 22/04/2025 04:02:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1137', document_date = '2025-04-08', 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 = '95.00', price_tax_excluded = '77.87', date_upd = NOW() WHERE id_document = '96567' 22/04/2025 04:02: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 = '96567' 22/04/2025 04:02:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '96567' 22/04/2025 04:02: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 ( '96567' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '11.00' ) 22/04/2025 04:02: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 ( '96567' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '84.00' ) 22/04/2025 04:02:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1038' AND id_document != '96450' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-01') 22/04/2025 04:02:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1038', document_date = '2025-04-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '176.00', price_tax_excluded = '144.26', date_upd = NOW() WHERE id_document = '96450' 22/04/2025 04:02: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 = '96450' 22/04/2025 04:02:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '96450' 22/04/2025 04:02: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 ( '96450' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 22/04/2025 04:02:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96450' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '10' , '-10' , '1' , '15' , '12.295081967213' , '22' , '0' , '150.00' ) 22/04/2025 04:03:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1099' AND id_document != '96525' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-05') 22/04/2025 04:03:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1099', document_date = '2025-04-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 = '205.00', price_tax_excluded = '177.77', date_upd = NOW() WHERE id_document = '96525' 22/04/2025 04:03: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 = '96525' 22/04/2025 04:03:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '96525' 22/04/2025 04:03: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 ( '96525' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '27.00' ) 22/04/2025 04:03: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 ( '96525' , '18045' , 'TECA INCISA - 515' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '28.00' ) 22/04/2025 04:03: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 ( '96525' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '8' , '-8' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '16.00' ) 22/04/2025 04:03: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 ( '96525' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 22/04/2025 04:03: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 ( '96525' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/04/2025 04:03: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 ( '96525' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 22/04/2025 04:03: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 ( '96525' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '20' , '-20' , '4' , '2.5' , '2.5' , '0' , '0' , '50.00' ) 22/04/2025 04:04:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1108' AND id_document != '96534' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-05') 22/04/2025 04:04:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1108', document_date = '2025-04-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 = '34.00', price_tax_excluded = '30.77', date_upd = NOW() WHERE id_document = '96534' 22/04/2025 04:04:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96534' 22/04/2025 04:04:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '96534' 22/04/2025 04:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96534' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '9.00' ) 22/04/2025 04:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96534' , '19618' , 'CARLO ACUTIS' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 22/04/2025 04:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96534' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '16.00' ) 22/04/2025 04:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96534' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2.17' , '2.17' , '0' , '0' , '4.34' ) 22/04/2025 04:04:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1112' AND id_document != '96538' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-07') 22/04/2025 04:04:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1112', document_date = '2025-04-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.00', price_tax_excluded = '3.00', date_upd = NOW() WHERE id_document = '96538' 22/04/2025 04:04:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96538' 22/04/2025 04:04:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '96538' 22/04/2025 04:04:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96538' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 22/04/2025 04:05:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1113' AND id_document != '96539' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-07') 22/04/2025 04:05:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1113', document_date = '2025-04-07', 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 = '129.00', price_tax_excluded = '118.01', date_upd = NOW() WHERE id_document = '96539' 22/04/2025 04:05: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 = '96539' 22/04/2025 04:05:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '96539' 22/04/2025 04:05: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 ( '96539' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 22/04/2025 04:05: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 ( '96539' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 22/04/2025 04:05: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 ( '96539' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 22/04/2025 04:05: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 ( '96539' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '9.00' ) 22/04/2025 04:05: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 ( '96539' , '22259' , 'SETTIMANA SANTA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 22/04/2025 04:05: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 ( '96539' , '23407' , 'PROCESSO AL PROCESSETTO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 22/04/2025 04:05: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 ( '96539' , '23443' , 'MA COME SI FA?' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 22/04/2025 04:05: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 ( '96539' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2.45' , '2.45' , '0' , '0' , '4.90' ) 22/04/2025 04:06:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1167' AND id_document != '96601' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-10') 22/04/2025 04:06:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1167', document_date = '2025-04-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 = '187.00', price_tax_excluded = '159.95', date_upd = NOW() WHERE id_document = '96601' 22/04/2025 04:06:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96601' 22/04/2025 04:06:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '96601' 22/04/2025 04:06: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 ( '96601' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 22/04/2025 04:06: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 ( '96601' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 22/04/2025 04:06: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 ( '96601' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/04/2025 04:06: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 ( '96601' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 22/04/2025 04:06: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 ( '96601' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 22/04/2025 04:06: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 ( '96601' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '6.7000' , '6.7' , '0' , '0' , '6.70' ) 22/04/2025 04:06: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 ( '96601' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '4' , '-4' , '4' , '2.5' , '2.5' , '0' , '0' , '10.00' ) 22/04/2025 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96601' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '145.00' ) 22/04/2025 04:07:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1125' AND id_document != '96553' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-08') 22/04/2025 04:07:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1125', document_date = '2025-04-08', 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 = '22.00', price_tax_excluded = '22.00', date_upd = NOW() WHERE id_document = '96553' 22/04/2025 04:07:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96553' 22/04/2025 04:07:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '96553' 22/04/2025 04:07:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96553' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '10' , '-10' , '4' , '2.2' , '2.2' , '0' , '0' , '22.00' ) 22/04/2025 04:08:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1146' AND id_document != '96577' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-09') 22/04/2025 04:08:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1146', document_date = '2025-04-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '160.00', price_tax_excluded = '151.89', date_upd = NOW() WHERE id_document = '96577' 22/04/2025 04:08: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 = '96577' 22/04/2025 04:08:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '96577' 22/04/2025 04:08: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 ( '96577' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '120' , '-120' , '4' , '0.7000' , '0.7' , '0' , '0' , '84.00' ) 22/04/2025 04:08: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 ( '96577' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 22/04/2025 04:08: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 ( '96577' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 22/04/2025 04:08: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 ( '96577' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '10' , '-10' , '4' , '2.5' , '2.5' , '0' , '0' , '25.00' ) 22/04/2025 04:08: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 ( '96577' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.2500' , '1.25' , '0' , '0' , '1.25' ) 22/04/2025 04:08:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1154' AND id_document != '96585' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-09') 22/04/2025 04:08:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1154', document_date = '2025-04-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '37.00', price_tax_excluded = '37.00', date_upd = NOW() WHERE id_document = '96585' 22/04/2025 04:08: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 = '96585' 22/04/2025 04:08:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '96585' 22/04/2025 04:08: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 ( '96585' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '15' , '-15' , '4' , '2.4' , '2.4' , '0' , '0' , '36.00' ) 22/04/2025 04:08: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 ( '96585' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 22/04/2025 04:09:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1183' AND id_document != '96620' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-11') 22/04/2025 04:09:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1183', document_date = '2025-04-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '103.30', price_tax_excluded = '89.18', date_upd = NOW() WHERE id_document = '96620' 22/04/2025 04:09:46 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 = '96620' 22/04/2025 04:09:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '96620' 22/04/2025 04:09:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96620' , '14401' , 'BALZA CM 19' , '3' , '-3' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '45.00' ) 22/04/2025 04:09:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96620' , '17617' , 'IMMAGINI ISONZO X 100' , '10' , '-10' , '1' , '3.3300' , '2.7295081967213' , '22' , '0' , '33.30' ) 22/04/2025 04:09:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96620' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '10' , '-10' , '4' , '2.5' , '2.5' , '0' , '0' , '25.00' ) 22/04/2025 04:10:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1190' AND id_document != '96628' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-11') 22/04/2025 04:10:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1190', document_date = '2025-04-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '185.00', price_tax_excluded = '158.13', date_upd = NOW() WHERE id_document = '96628' 22/04/2025 04:10:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96628' 22/04/2025 04:10:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '96628' 22/04/2025 04:10:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96628' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 22/04/2025 04:10:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96628' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/04/2025 04:10:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96628' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '139.0000' , '113.93442622951' , '22' , '0' , '139.00' ) 22/04/2025 04:10:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96628' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '12' , '-12' , '4' , '3' , '3' , '0' , '0' , '36.00' ) 22/04/2025 04:11:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1157' AND id_document != '96589' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-09') 22/04/2025 04:11:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1157', document_date = '2025-04-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.25', price_tax_excluded = '6.25', date_upd = NOW() WHERE id_document = '96589' 22/04/2025 04:11:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96589' 22/04/2025 04:11:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '96589' 22/04/2025 04:11:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96589' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 22/04/2025 04:11:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96589' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3.25' , '3.25' , '0' , '0' , '3.25' ) 22/04/2025 04:12:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1256' AND id_document != '96700' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 22/04/2025 04:12:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1256', document_date = '2025-04-15', 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 = '2.40', price_tax_excluded = '2.40', date_upd = NOW() WHERE id_document = '96700' 22/04/2025 04:12:22 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 = '96700' 22/04/2025 04:12:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '96700' 22/04/2025 04:12:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96700' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.4' , '2.4' , '0' , '0' , '2.40' ) 22/04/2025 04:12:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1287' AND id_document != '96735' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-16') 22/04/2025 04:12:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1287', document_date = '2025-04-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 = '13.10', price_tax_excluded = '12.70', date_upd = NOW() WHERE id_document = '96735' 22/04/2025 04:12:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96735' 22/04/2025 04:12:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '96735' 22/04/2025 04:12:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96735' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 22/04/2025 04:12:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96735' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.6' , '2.6' , '0' , '0' , '2.60' ) 22/04/2025 04:13:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1273' AND id_document != '96719' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 22/04/2025 04:13:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1273', document_date = '2025-04-15', 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 = '55.00', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '96719' 22/04/2025 04:13:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96719' 22/04/2025 04:13:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '96719' 22/04/2025 04:13:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96719' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '22' , '-22' , '4' , '2.5' , '2.5' , '0' , '0' , '55.00' ) 22/04/2025 05:26:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 05:26:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '16' , '2025-04-22' , '' , '3030' , '0' , '4671709' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , 'RITIRA SIG.RA PINA CON ACCONTO € 3080,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3950.00' , '3950.00' , NOW() , NOW() ) 22/04/2025 05:26:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96800' 22/04/2025 05:26:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '96800' 22/04/2025 05:26:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96800' , '19846' , 'CALICE IN ARG. EVANGELISTI - 175/A' , '1' , '-1' , '0' , '3400' , '3400' , '' , '0' , '3400.00' ) 22/04/2025 05:26:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96800' , '19847' , 'PATENA IN ARGENTO' , '1' , '-1' , '0' , '550' , '550' , '' , '0' , '550.00' ) 22/04/2025 06:18:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1339' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 06:18:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1339' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.50' , '19.26' , NOW() , NOW() ) 22/04/2025 06:18:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96801' 22/04/2025 06:18:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '96801' 22/04/2025 06:18:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96801' , '17343' , 'CROCE SAN BENEDETTO LEGNO SMALTATA - CZ6NIKSM' , '1' , '-1' , '1' , '23.50' , '19.262295081967' , '22' , '0' , '23.50' ) 22/04/2025 06:19:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1340' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 06:19: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' , '1340' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/04/2025 06:19: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 = '96802' 22/04/2025 06:19:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '96802' 22/04/2025 06:19: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 ( '96802' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/04/2025 06:32:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '67/A' AND id_document != '96800' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 06:32:52 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '67/A', document_date = '2025-04-22', document_letter = 'A', id_customer = '3030', id_supplier = '', id_address = '4671709', address1 = 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO', address2 = '', note = 'RITIRA SIG.RA PINA CON ACCONTO € 3080,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3950.00', price_tax_excluded = '3237.70', date_upd = NOW() WHERE id_document = '96800' 22/04/2025 06:32:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96800' 22/04/2025 06:32:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '96800' 22/04/2025 06:32:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96800' , '19846' , 'CALICE IN ARG. EVANGELISTI - 175/A' , '1' , '-1' , '1' , '3400.0000' , '2786.8852459016' , '22' , '0' , '3400.00' ) 22/04/2025 06:32:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96800' , '19847' , 'PATENA IN ARGENTO' , '1' , '-1' , '1' , '550.0000' , '450.81967213115' , '22' , '0' , '550.00' ) 22/04/2025 06:56:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1341' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 06:56:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1341' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 22/04/2025 06:56:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96803' 22/04/2025 06:56:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '96803' 22/04/2025 06:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96803' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 22/04/2025 06:58:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1342' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 06:58:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1342' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 22/04/2025 06:58:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96804' 22/04/2025 06:58:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '96804' 22/04/2025 06:58:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96804' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 22/04/2025 07:18:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1229' AND id_document != '96670' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14') 22/04/2025 07:18:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1229', document_date = '2025-04-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 = '53.50', price_tax_excluded = '43.85', date_upd = NOW() WHERE id_document = '96670' 22/04/2025 07:18:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96670' 22/04/2025 07:18:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '96670' 22/04/2025 07:18:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96670' , '19771' , 'ROSARIO ARGENTO/EMATITE - 1931CAV' , '1' , '-1' , '1' , '37.5000' , '30.737704918033' , '22' , '0' , '37.50' ) 22/04/2025 07:18:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96670' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 22/04/2025 07:18:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96670' , '6403' , 'MENSA BIANCA 80X150 ' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 22/04/2025 07:27:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1343' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 22/04/2025 07:27:29 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' , '1343' , '2025-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.60' , '7.87' , NOW() , NOW() ) 22/04/2025 07:27:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96805' 22/04/2025 07:27:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '96805' 22/04/2025 07:27:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96805' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '2' , '-2' , '1' , '4.80' , '3.9344262295082' , '22' , '0' , '9.60' )