03/04/2025 09:29:26 am >> UPDATE ps_document SET id_document_type = '31', document_num = '1/187', document_date = '2025-03-31', document_letter = '187', id_customer = '0', id_supplier = '', id_address = '4670575', address1 = 'VIA RAFFAELE RUGGI, 29 80125 NAPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '45.21', price_tax_excluded = '37.06', date_upd = NOW() WHERE id_document = '96426' 03/04/2025 09:29:26 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 = '96426' 03/04/2025 09:29:26 am >> DELETE FROM ps_document_detail WHERE id_document = '96426' 03/04/2025 09:29: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 ( '96426' , '23146' , 'SPILLA PORTA CIUCCIO CEL.' , '2' , '2' , '1' , '5.3279' , '4.367131147541' , '22' , '0' , '13.00' ) 03/04/2025 09:29: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 ( '96426' , '23621' , 'MEDAGLIA S. RITA ARG' , '2' , '2' , '1' , '13.2' , '10.819672131148' , '22' , '0' , '32.2080' ) 03/04/2025 09:29:46 am >> UPDATE ps_document SET id_document_type = '31', document_num = '1/787', document_date = '2025-03-31', document_letter = '787', id_customer = '0', id_supplier = '', id_address = '4670575', address1 = 'VIA RAFFAELE RUGGI, 29 80125 NAPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '45.21', price_tax_excluded = '37.06', date_upd = NOW() WHERE id_document = '96426' 03/04/2025 09:29:46 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 = '96426' 03/04/2025 09:29:46 am >> DELETE FROM ps_document_detail WHERE id_document = '96426' 03/04/2025 09:29:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96426' , '23146' , 'SPILLA PORTA CIUCCIO CEL.' , '2' , '2' , '1' , '5.3279' , '4.367131147541' , '22' , '0' , '13.00' ) 03/04/2025 09:29:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96426' , '23621' , 'MEDAGLIA S. RITA ARG' , '2' , '2' , '1' , '13.2000' , '10.819672131148' , '22' , '0' , '32.21' ) 03/04/2025 10:02:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1071' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-03') 03/04/2025 10:02:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1071' , '2025-04-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '344.00' , '281.97' , NOW() , NOW() ) 03/04/2025 10:02:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96494' 03/04/2025 10:02:50 am >> DELETE FROM ps_document_detail WHERE id_document = '96494' 03/04/2025 10:02:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96494' , '23605' , 'CALICE BAROCCO - 1887' , '1' , '-1' , '1' , '344.00' , '281.96721311475' , '22' , '0' , '344.00' ) 03/04/2025 10:40:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1072' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-03') 03/04/2025 10:40:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1072' , '2025-04-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 03/04/2025 10:40: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 = '96495' 03/04/2025 10:40:24 am >> DELETE FROM ps_document_detail WHERE id_document = '96495' 03/04/2025 10:40: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 ( '96495' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 03/04/2025 10:40: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 ( '96495' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 03/04/2025 10:48:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1073' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-03') 03/04/2025 10:48:22 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' , '1073' , '2025-04-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.20' , '35.83' , NOW() , NOW() ) 03/04/2025 10:48:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96496' 03/04/2025 10:48:22 am >> DELETE FROM ps_document_detail WHERE id_document = '96496' 03/04/2025 10:48:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96496' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 03/04/2025 10:48:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96496' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '26.70' ) 03/04/2025 10:48:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96496' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 03/04/2025 11:03:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1074' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-03') 03/04/2025 11:03:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1074' , '2025-04-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '184.00' , '150.82' , NOW() , NOW() ) 03/04/2025 11:03:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96497' 03/04/2025 11:03:56 am >> DELETE FROM ps_document_detail WHERE id_document = '96497' 03/04/2025 11:03:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96497' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '2' , '-2' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '140.00' ) 03/04/2025 11:03:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96497' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 03/04/2025 11:03:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96497' , '22552' , 'TORCIA IN TELA ANTIVENTO - TORCT' , '6' , '-6' , '1' , '4' , '3.2786885245902' , '22' , '0' , '24.00' ) 03/04/2025 11:25:28 am >> UPDATE ps_document SET id_document_type = '31', document_num = '223', document_date = '2025-03-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4674530', address1 = 'VIA CORTI 29 24126 BERGAMO', 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 = '839.36', price_tax_excluded = '688.00', date_upd = NOW() WHERE id_document = '96222' 03/04/2025 11:25:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96222' 03/04/2025 11:25:28 am >> DELETE FROM ps_document_detail WHERE id_document = '96222' 03/04/2025 11:25:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96222' , '23549' , 'STOLA CROCE - 860' , '3' , '3' , '1' , '42' , '34.426229508197' , '22' , '0' , '153.7200' ) 03/04/2025 11:25:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96222' , '19798' , 'CAMICE ARIANNA MISTO LINO' , '1' , '1' , '1' , '130.0000' , '106.55737704918' , '22' , '0' , '158.60' ) 03/04/2025 11:25:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96222' , '20272' , 'CASULA CROCE - 652' , '6' , '6' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '204.96' ) 03/04/2025 11:25:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96222' , '23547' , 'stola ricamo croce - 652' , '8' , '8' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '146.40' ) 03/04/2025 11:25:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96222' , '23548' , 'STOLA DIACONALE CROCE - 652' , '8' , '8' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '175.68' ) 03/04/2025 11:30:57 am >> SELECT document_num FROM ps_document WHERE document_num = '917' AND id_document != '96296' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-19') 03/04/2025 11:30:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '917', document_date = '2025-03-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 = '92.34', price_tax_excluded = '79.36', date_upd = NOW() WHERE id_document = '96296' 03/04/2025 11:30:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96296' 03/04/2025 11:30:57 am >> DELETE FROM ps_document_detail WHERE id_document = '96296' 03/04/2025 11:30:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96296' , '11409' , 'VISITE AL SANTISSIMO SACRAMENTO... - 8424' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 03/04/2025 11:30:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96296' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 03/04/2025 11:30:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96296' , '22809' , 'O LUCE BEATISSIMA' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 03/04/2025 11:30:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96296' , '22397' , 'AFFERRATI DALLAMORE' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 03/04/2025 11:30:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96296' , '20646' , 'STOLA DIACONALE - 881D' , '1' , '-1' , '1' , '72' , '59.016393442623' , '22' , '0' , '72.00' ) 03/04/2025 12:23: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 ( '31' , 'Z601' , '2025-03-31' , '' , '0' , '192' , '4679421' , 'VIA CIRO MENOTTI 6 35030 CASELLE DI SELVAZZANO' , '' , '' , '120' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '1769.24' , '1450.20' , NOW() , NOW() ) 03/04/2025 12:23: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 = '96498' 03/04/2025 12:23:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '96498' 03/04/2025 12:23: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 ( '96498' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '20' , '20' , '1' , '32' , '26.229508196721' , '22' , '0' , '780.8000' ) 03/04/2025 12:23:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '192' 03/04/2025 12:23:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '192' , '1' ) 03/04/2025 12:23: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 ( '96498' , '15210' , 'CERO PASQUALE API 80X120' , '20' , '20' , '1' , '34.51' , '28.286885245902' , '22' , '0' , '842.0440' ) 03/04/2025 12:23:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15210' AND id_supplier = '192' 03/04/2025 12:23:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15210' , '192' , '1' ) 03/04/2025 02:32:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '95283' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-01-15') 03/04/2025 02:32:26 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1', document_date = '2025-01-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4679057', address1 = 'VIA G. VERDI 8 20057 ASSAGO', address2 = '', note = 'RESA - NOTA CREDITO RICEVUTA', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '209.50', price_tax_excluded = '209.50', date_upd = NOW() WHERE id_document = '95283' 03/04/2025 02:32: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 = '95283' 03/04/2025 02:32:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '95283' 03/04/2025 02:32: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 ( '95283' , '23007' , 'GRANDE AMICO - S. PINNA' , '2' , '-2' , '4' , '19.5000' , '19.5' , '0' , '0' , '39.00' ) 03/04/2025 02:32: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 ( '95283' , '23010' , 'RELIGIONE E DEMOCRAZIA' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 03/04/2025 02:32: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 ( '95283' , '23009' , 'DEMOCRAZIA CONTRO LA REALTA ' , '1' , '-1' , '4' , '14.6000' , '14.6' , '0' , '0' , '14.60' ) 03/04/2025 02:32: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 ( '95283' , '23175' , 'FAVORITE' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 03/04/2025 02:32: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 ( '95283' , '22458' , 'LUPA DI MARE - M. POZZA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 03/04/2025 02:32: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 ( '95283' , '22375' , 'SEGRETI DI SUOR LUCIA - S. GAETA' , '1' , '-1' , '4' , '19.9000' , '19.9' , '0' , '0' , '19.90' ) 03/04/2025 02:32: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 ( '95283' , '23011' , 'JACQUES MARITAIN AMBASCIATORE' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 03/04/2025 02:32: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 ( '95283' , '17893' , 'POTENZA DELLA LODE - M. CAROTHERS' , '2' , '-2' , '4' , '11.0000' , '11' , '0' , '0' , '22.00' ) 03/04/2025 02:32: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 ( '95283' , '22762' , 'SAN CHARBEL IL MISTERO DEL CORPO INTATTO - P. CATTANEO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 03/04/2025 05:31:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1075' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-03') 03/04/2025 05:31:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1075' , '2025-04-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 03/04/2025 05:31:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96499' 03/04/2025 05:31:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '96499' 03/04/2025 05:31:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96499' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 03/04/2025 06:22:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '96095' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-07') 03/04/2025 06:22:49 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2025-03-07', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'mariani francesco', 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 = '300.00', price_tax_excluded = '300.00', date_upd = NOW() WHERE id_document = '96095' 03/04/2025 06:22: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 = '96095' 03/04/2025 06:22:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '96095' 03/04/2025 06:22: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 ( '96095' , '15210' , 'CERO PASQUALE API 80X120' , '9' , '-9' , '0' , '60.0000' , '60' , '' , '0' , '540.00' ) 03/04/2025 06:22: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 ( '96095' , '0' , 'CERI RICONSEGNATI DA PAGARE - FOGLIA ORO' , '6' , '-6' , '0' , '-40.0000' , '-40' , '' , '0' , '-240.00' ) 03/04/2025 06:22: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 ( '96095' , '0' , 'CERO PASQUALE API 80X 120 da fare disegni' , '3' , '-3' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 03/04/2025 06:35:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1076' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-03') 03/04/2025 06:35:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1076' , '2025-04-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.50' , '38.93' , NOW() , NOW() ) 03/04/2025 06:35:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96500' 03/04/2025 06:35:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '96500' 03/04/2025 06:35: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 ( '96500' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40.5' , '33.196721311475' , '22' , '0' , '40.50' ) 03/04/2025 06:35: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 ( '96500' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 03/04/2025 06:35: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 ( '96500' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 03/04/2025 07:02:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1077' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-03') 03/04/2025 07:02:22 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' , '1077' , '2025-04-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 03/04/2025 07:02: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 = '96501' 03/04/2025 07:02:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '96501' 03/04/2025 07:02: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 ( '96501' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' )