19/12/2024 08:31:26 am >> SELECT document_num FROM ps_document WHERE document_num = '134/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 19/12/2024 08:31:26 am >> UPDATE ps_document SET id_document_type = '24', document_num = '134/A', document_date = '2024-12-18', 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 = '134.00', price_tax_excluded = '109.84', date_upd = NOW() WHERE id_document = '94912' 19/12/2024 08:31: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 = '94912' 19/12/2024 08:31:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94912' 19/12/2024 08:31: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 ( '94912' , '22907' , 'AGENDINA 2025 - 40827' , '2' , '-2' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '14.00' ) 19/12/2024 08:31: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 ( '94912' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '60' , '-60' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '120.00' ) 19/12/2024 09:02:33 am >> SELECT document_num FROM ps_document WHERE document_num = '270' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 09:02:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '270' , '2024-12-19' , '' , '321' , '0' , '4672782' , 'VIA VICENZA 45 84099 FILETTA S. CIPRIANO PIC.' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '545.00' , '545.00' , NOW() , NOW() ) 19/12/2024 09:02:33 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 = '94928' 19/12/2024 09:02:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94928' 19/12/2024 09:02:33 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 ( '94928' , '2679' , 'CONOSCERE GESU\'' , '21' , '-21' , '4' , '3.5000' , '3.5' , '0' , '15' , '62.48' ) 19/12/2024 09:02:33 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 ( '94928' , '5457' , 'IO SONO CON VOI 1 PARTE' , '17' , '-17' , '4' , '2.8000' , '2.8' , '0' , '15' , '40.46' ) 19/12/2024 09:02:33 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 ( '94928' , '5444' , 'IO SONO CON VOI - CAT.' , '17' , '-17' , '4' , '5.5000' , '5.5' , '0' , '5' , '88.82' ) 19/12/2024 09:02:33 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 ( '94928' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '23' , '-23' , '4' , '3.4000' , '3.4' , '0' , '15' , '66.47' ) 19/12/2024 09:02:33 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 ( '94928' , '4154' , 'FESTA DEL PERDONO' , '23' , '-23' , '4' , '3.0000' , '3' , '0' , '15' , '58.65' ) 19/12/2024 09:02:33 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 ( '94928' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 19/12/2024 09:02:33 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 ( '94928' , '8408' , 'PRENDETE E MANGIATE' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 19/12/2024 09:02:33 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 ( '94928' , '8408' , 'PRENDETE E MANGIATE' , '21' , '-21' , '4' , '3.0000' , '3' , '0' , '15' , '53.55' ) 19/12/2024 09:02:33 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 ( '94928' , '11192' , 'VENITE CON ME 2 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 19/12/2024 09:02:33 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 ( '94928' , '' , 'arrotondamento ' , '1' , '-1' , '4' , '-0.53' , '-0.53' , '0' , '0' , '-0.53' ) 19/12/2024 09:08:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 09:08: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' , '3995' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.98' , '32.77' , NOW() , NOW() ) 19/12/2024 09:08: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 = '94929' 19/12/2024 09:08:22 am >> DELETE FROM ps_document_detail WHERE id_document = '94929' 19/12/2024 09:08: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 ( '94929' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 19/12/2024 09:08: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 ( '94929' , '17617' , 'IMMAGINI ISONZO X 100' , '6' , '-6' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '19.98' ) 19/12/2024 09:14:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 09:14:54 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' , '3996' , '2024-12-19' , '' , '0' , '0' , '0' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.40' , '32.87' , NOW() , NOW() ) 19/12/2024 09:14: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 = '94930' 19/12/2024 09:14:54 am >> DELETE FROM ps_document_detail WHERE id_document = '94930' 19/12/2024 09:14: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 ( '94930' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 19/12/2024 09:14: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 ( '94930' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.8197' , '22' , '0' , '1.00' ) 19/12/2024 09:14: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 ( '94930' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 19/12/2024 09:14: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 ( '94930' , '21800' , 'LAUDATO SI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 19/12/2024 09:14: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 ( '94930' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.00' ) 19/12/2024 09:15:28 am >> DELETE FROM ps_document WHERE id_document = '94315' 19/12/2024 09:15:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94315' 19/12/2024 09:18:53 am >> DELETE FROM ps_document WHERE id_document = '94448' 19/12/2024 09:18:53 am >> DELETE FROM ps_document_detail WHERE id_document = '94448' 19/12/2024 09:24:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 09:24:37 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' , '3997' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 19/12/2024 09:24:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94931' 19/12/2024 09:24:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94931' 19/12/2024 09:24:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94931' , '20561' , 'CONFEZIONE CARTONCINO CON BAMBINO - P762' , '100' , '-100' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '60.00' ) 19/12/2024 09:24:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94931' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 19/12/2024 09:31:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 09:31:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3998' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '218.72' , '218.72' , NOW() , NOW() ) 19/12/2024 09:31:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94932' 19/12/2024 09:31:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94932' 19/12/2024 09:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94932' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '32' , '-32' , '4' , '5.00' , '5' , '0' , '5' , '152.00' ) 19/12/2024 09:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94932' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '100' , '0.00' ) 19/12/2024 09:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94932' , '23120' , 'AMEN - GEN 25' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 19/12/2024 09:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94932' , '23119' , 'AMEN - FEB 25' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 19/12/2024 09:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94932' , '23142' , 'MESSA MEDITAZIONE - GEN FEB 2025' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 19/12/2024 09:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94932' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.70' , '0.7' , '0' , '0' , '7.00' ) 19/12/2024 09:40:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 09:40:59 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' , '3999' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 19/12/2024 09:40:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94933' 19/12/2024 09:40:59 am >> DELETE FROM ps_document_detail WHERE id_document = '94933' 19/12/2024 09:40:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94933' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 19/12/2024 09:40:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94933' , '23227' , 'STOLA GIUBILEO STAMPATA - ST16GBR' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 19/12/2024 09:50:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3676' AND id_document != '94529' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 19/12/2024 09:50:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3676', document_date = '2024-11-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 = '70.09', price_tax_excluded = '57.83', date_upd = NOW() WHERE id_document = '94529' 19/12/2024 09:50:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94529' 19/12/2024 09:50:04 am >> DELETE FROM ps_document_detail WHERE id_document = '94529' 19/12/2024 09:50:05 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 ( '94529' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14.7' , '12.049180327869' , '22' , '0' , '14.70' ) 19/12/2024 09:50:05 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 ( '94529' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '5' , '2.09' ) 19/12/2024 09:50:05 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 ( '94529' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '5' , '38.00' ) 19/12/2024 09:50:05 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 ( '94529' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '13' , '-13' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '3.90' ) 19/12/2024 09:50:05 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 ( '94529' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 19/12/2024 09:50:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3945' AND id_document != '94863' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-14') 19/12/2024 09:50:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3945', document_date = '2024-12-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 = '197.93', price_tax_excluded = '167.65', date_upd = NOW() WHERE id_document = '94863' 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94863' 19/12/2024 09:50:52 am >> DELETE FROM ps_document_detail WHERE id_document = '94863' 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '21860' , 'BAMBINELLO CM 10 - PKS10-C' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '22420' , 'CROCE MURRINE CM 21' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '935' , 'BAMBINO CM 7,5 DIPINTO - P3' , '17' , '-17' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '34.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '20028' , 'CANDELA ALTARE 26X350' , '4' , '-4' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '8.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '20005' , 'GESU BAMBINO CON AUREOLA CM 20 - BJ148-20' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '23120' , 'AMEN - GEN 25' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '0' , '9.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '23119' , 'AMEN - FEB 25' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '0' , '9.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '23278' , 'AMEN - MAR 25' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '0' , '9.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '6356' , 'MEDAGLIA S.CUORE- MAD. CARMINE' , '1' , '-1' , '1' , '0.1300' , '0.10655737704918' , '22' , '0' , '0.13' ) 19/12/2024 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/12/2024 09:51:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3642' AND id_document != '94489' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 19/12/2024 09:51:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3642', document_date = '2024-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.00', price_tax_excluded = '3.00', date_upd = NOW() WHERE id_document = '94489' 19/12/2024 09:51:05 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 = '94489' 19/12/2024 09:51:05 am >> DELETE FROM ps_document_detail WHERE id_document = '94489' 19/12/2024 09:51:05 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 ( '94489' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 19/12/2024 09:51:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3873' AND id_document != '94774' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 19/12/2024 09:51:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3873', document_date = '2024-12-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 = '3.00', price_tax_excluded = '3.00', date_upd = NOW() WHERE id_document = '94774' 19/12/2024 09:51:19 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 = '94774' 19/12/2024 09:51:19 am >> DELETE FROM ps_document_detail WHERE id_document = '94774' 19/12/2024 09:51:19 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 ( '94774' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 19/12/2024 09:51:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3778' AND id_document != '94660' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-03') 19/12/2024 09:51:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3778', document_date = '2024-12-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 = '70.00', price_tax_excluded = '69.85', date_upd = NOW() WHERE id_document = '94660' 19/12/2024 09:51:51 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 = '94660' 19/12/2024 09:51:51 am >> DELETE FROM ps_document_detail WHERE id_document = '94660' 19/12/2024 09:51:51 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 ( '94660' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 19/12/2024 09:51:51 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 ( '94660' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 19/12/2024 09:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94660' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 19/12/2024 09:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94660' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 19/12/2024 09:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94660' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 19/12/2024 09:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94660' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 19/12/2024 09:52:50 am >> SELECT document_num FROM ps_document WHERE document_num = '268' AND id_document != '94921' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-18') 19/12/2024 09:52:50 am >> UPDATE ps_document SET id_document_type = '21', document_num = '268', document_date = '2024-12-18', document_letter = '', id_customer = '321', id_supplier = '', id_address = '4672782', address1 = 'VIA LUIGI ANGRISANI 36 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '545.00', price_tax_excluded = '545.00', date_upd = NOW() WHERE id_document = '94921' 19/12/2024 09:52: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 = '94921' 19/12/2024 09:52:50 am >> DELETE FROM ps_document_detail WHERE id_document = '94921' 19/12/2024 09:52: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 ( '94921' , '2679' , 'CONOSCERE GESU\'' , '21' , '-21' , '4' , '3.5000' , '3.5' , '0' , '15' , '62.48' ) 19/12/2024 09:52: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 ( '94921' , '5457' , 'IO SONO CON VOI 1 PARTE' , '17' , '-17' , '4' , '2.8000' , '2.8' , '0' , '15' , '40.46' ) 19/12/2024 09:52: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 ( '94921' , '5444' , 'IO SONO CON VOI - CAT.' , '17' , '-17' , '4' , '5.5000' , '5.5' , '0' , '5' , '88.82' ) 19/12/2024 09:52: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 ( '94921' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '23' , '-23' , '4' , '3.4000' , '3.4' , '0' , '15' , '66.47' ) 19/12/2024 09:52: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 ( '94921' , '4154' , 'FESTA DEL PERDONO' , '23' , '-23' , '4' , '3.0000' , '3' , '0' , '15' , '58.65' ) 19/12/2024 09:52: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 ( '94921' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 19/12/2024 09:52: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 ( '94921' , '8408' , 'PRENDETE E MANGIATE' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 19/12/2024 09:52: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 ( '94921' , '8408' , 'PRENDETE E MANGIATE' , '21' , '-21' , '4' , '3.0000' , '3' , '0' , '15' , '53.55' ) 19/12/2024 09:52: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 ( '94921' , '11192' , 'VENITE CON ME 2 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 19/12/2024 09:52: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 ( '94921' , '0' , 'arrotondamento ' , '1' , '-1' , '4' , '-0.5300' , '-0.53' , '0' , '0' , '-0.53' ) 19/12/2024 09:52:55 am >> DELETE FROM ps_document WHERE id_document = '94928' 19/12/2024 09:52:55 am >> DELETE FROM ps_document_detail WHERE id_document = '94928' 19/12/2024 09:54:22 am >> SELECT document_num FROM ps_document WHERE document_num = '4000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 09:54:23 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' , '4000' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 19/12/2024 09:54:23 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 = '94934' 19/12/2024 09:54:23 am >> DELETE FROM ps_document_detail WHERE id_document = '94934' 19/12/2024 09:54:23 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 ( '94934' , '21701' , 'NASCITA DI GESU' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 19/12/2024 09:57:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3999' AND id_document != '94933' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 09:57:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3999', document_date = '2024-12-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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '94933' 19/12/2024 09:57:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94933' 19/12/2024 09:57:39 am >> DELETE FROM ps_document_detail WHERE id_document = '94933' 19/12/2024 09:57:39 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 ( '94933' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 19/12/2024 09:57:39 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 ( '94933' , '23227' , 'STOLA GIUBILEO STAMPATA - ST16GBR' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 19/12/2024 09:57:39 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 ( '94933' , '22305' , 'NAVETTA CM 13' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 19/12/2024 09:57:50 am >> SELECT document_num FROM ps_document WHERE document_num = '135/A' AND id_document != '94923' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 19/12/2024 09:57:50 am >> UPDATE ps_document SET id_document_type = '24', document_num = '135/A', document_date = '2024-12-18', document_letter = 'A', id_customer = '362', id_supplier = '', id_address = '362', address1 = 'UNITÀ PASTORALE MONTORO 83025 MONTORO', 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 = '155.00', price_tax_excluded = '127.05', date_upd = NOW() WHERE id_document = '94923' 19/12/2024 09:57: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 = '94923' 19/12/2024 09:57:50 am >> DELETE FROM ps_document_detail WHERE id_document = '94923' 19/12/2024 09:57: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 ( '94923' , '18022' , 'TURIBOLO H 24' , '1' , '-1' , '1' , '155.0000' , '127.04918032787' , '22' , '0' , '155.00' ) 19/12/2024 09:58:06 am >> DELETE FROM ps_document WHERE id_document = '94923' 19/12/2024 09:58:06 am >> DELETE FROM ps_document_detail WHERE id_document = '94923' 19/12/2024 10:15:10 am >> SELECT document_num FROM ps_document WHERE document_num = '4001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 10:15:10 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' , '4001' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 19/12/2024 10:15:10 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 = '94935' 19/12/2024 10:15:10 am >> DELETE FROM ps_document_detail WHERE id_document = '94935' 19/12/2024 10:15:10 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 ( '94935' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/12/2024 10:18:55 am >> SELECT document_num FROM ps_document WHERE document_num = '4002' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 10:18: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' , '4002' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 19/12/2024 10:18: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 = '94936' 19/12/2024 10:18:55 am >> DELETE FROM ps_document_detail WHERE id_document = '94936' 19/12/2024 10:18: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 ( '94936' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 19/12/2024 10:33:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3495' AND id_document != '94287' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-15') 19/12/2024 10:33:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3495', document_date = '2024-11-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P. ZZA S. CATERINA 1 84090 GIFFONI SEI CASALI', 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 = '499.95', price_tax_excluded = '498.51', date_upd = NOW() WHERE id_document = '94287' 19/12/2024 10:33:18 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 = '94287' 19/12/2024 10:33:18 am >> DELETE FROM ps_document_detail WHERE id_document = '94287' 19/12/2024 10:33:18 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 ( '94287' , '10748' , 'TU MI CHIAMI PER NOME' , '20' , '-20' , '4' , '6.3000' , '6.3' , '0' , '0' , '126.00' ) 19/12/2024 10:33:18 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 ( '94287' , '10751' , 'TU MI PERDONI' , '27' , '-27' , '4' , '6.3000' , '6.3' , '0' , '0' , '170.10' ) 19/12/2024 10:33:18 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 ( '94287' , '14719' , 'TU MI AMI DAVVERO' , '18' , '-18' , '4' , '6.3000' , '6.3' , '0' , '0' , '113.40' ) 19/12/2024 10:33:18 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 ( '94287' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 19/12/2024 10:33:18 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 ( '94287' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '8.00' ) 19/12/2024 10:33:18 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 ( '94287' , '22099' , 'YOUCAT' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 19/12/2024 10:33:18 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 ( '94287' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 19/12/2024 10:33:18 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 ( '94287' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 19/12/2024 10:33:18 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 ( '94287' , '22956' , 'GENERATI MEDIANTE IL VANGELO - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 19/12/2024 10:33:18 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 ( '94287' , '21814' , 'VIVERE IL LUTTO INSIEME A DIO - C. GALATOLO' , '1' , '-1' , '4' , '13.1' , '13.1' , '0' , '0' , '13.10' ) 19/12/2024 11:03:40 am >> SELECT document_num FROM ps_document WHERE document_num = '4003' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 11:03:40 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' , '4003' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.90' , '16.90' , NOW() , NOW() ) 19/12/2024 11:03:40 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 = '94937' 19/12/2024 11:03:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94937' 19/12/2024 11:03:40 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 ( '94937' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 19/12/2024 11:18:38 am >> SELECT document_num FROM ps_document WHERE document_num = '4004' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 11:18:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4004' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '215.00' , '176.23' , NOW() , NOW() ) 19/12/2024 11:18:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94938' 19/12/2024 11:18:38 am >> DELETE FROM ps_document_detail WHERE id_document = '94938' 19/12/2024 11:18:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94938' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '140' , '-140' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '168.00' ) 19/12/2024 11:18:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94938' , '13506' , 'SANTO ROSARIO' , '150' , '-150' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '45.00' ) 19/12/2024 11:18:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94938' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '4' , '-4' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '2.00' ) 19/12/2024 11:19:36 am >> SELECT document_num FROM ps_document WHERE document_num = '4005' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 11:19: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' , '4005' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 19/12/2024 11:19: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 = '94939' 19/12/2024 11:19:36 am >> DELETE FROM ps_document_detail WHERE id_document = '94939' 19/12/2024 11:19: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 ( '94939' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 19/12/2024 11:40:46 am >> SELECT document_num FROM ps_document WHERE document_num = '4006' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 11:40:46 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' , '4006' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '261.00' , '213.93' , NOW() , NOW() ) 19/12/2024 11:40: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 = '94940' 19/12/2024 11:40:46 am >> DELETE FROM ps_document_detail WHERE id_document = '94940' 19/12/2024 11:40: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 ( '94940' , '22342' , 'LAMPADA IN CRISTALLO VARI COLORI' , '9' , '-9' , '1' , '29' , '23.770491803279' , '22' , '0' , '261.00' ) 19/12/2024 11:54:46 am >> SELECT document_num FROM ps_document WHERE document_num = '4007' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 11:54:46 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' , '4007' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1110.00' , '917.20' , NOW() , NOW() ) 19/12/2024 11:54: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 = '94941' 19/12/2024 11:54:46 am >> DELETE FROM ps_document_detail WHERE id_document = '94941' 19/12/2024 11:54: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 ( '94941' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 19/12/2024 11:54: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 ( '94941' , '18903' , 'TURIBOLO CM 28' , '1' , '-1' , '1' , '187.00' , '153.27868852459' , '22' , '0' , '187.00' ) 19/12/2024 11:54: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 ( '94941' , '21792' , 'BAMBINO CM 60 - PB11786' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 19/12/2024 11:54: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 ( '94941' , '13565' , 'NAVETTA CLASSICA CM 13' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 19/12/2024 11:54: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 ( '94941' , '22780' , 'CASULA LANA - 661' , '1' , '-1' , '1' , '578.00' , '473.77049180328' , '22' , '0' , '578.00' ) 19/12/2024 11:54: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 ( '94941' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26.15' , '21.434426229508' , '22' , '0' , '26.15' ) 19/12/2024 11:54: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 ( '94941' , '23285' , 'CHI E GESU - G. LAJOLO' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 19/12/2024 11:54: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 ( '94941' , '22885' , 'MINISTERO DEL CATECHISTA E I MINISTERI LAICALI... ' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 19/12/2024 11:57:38 am >> SELECT document_num FROM ps_document WHERE document_num = '4008' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 11:57:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4008' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.63' , '40.79' , NOW() , NOW() ) 19/12/2024 11:57:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94942' 19/12/2024 11:57:38 am >> DELETE FROM ps_document_detail WHERE id_document = '94942' 19/12/2024 11:57:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94942' , '22938' , 'INSIEME NELLA MESSA - DIC 2024' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 19/12/2024 11:57:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94942' , '23066' , 'INSIEME NELLA MESSA - GEN 2025' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 19/12/2024 11:57:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94942' , '23244' , 'INSIEME NELLA MESSA - FEB 2025' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 19/12/2024 11:57:39 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 ( '94942' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 19/12/2024 11:57:39 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 ( '94942' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '100' , '-100' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '30.00' ) 19/12/2024 11:57:39 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 ( '94942' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/12/2024 11:59:37 am >> SELECT document_num FROM ps_document WHERE document_num = '4009' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 11:59:37 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' , '4009' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.90' , NOW() , NOW() ) 19/12/2024 11:59:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94943' 19/12/2024 11:59:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94943' 19/12/2024 11:59:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94943' , '23300' , 'DOMENICA DELLA PAROLA 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/12/2024 12:00:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '4010' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 12:00:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4010' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.80' , '5.80' , NOW() , NOW() ) 19/12/2024 12: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 = '94944' 19/12/2024 12:00:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '94944' 19/12/2024 12:00:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94944' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/12/2024 12:00:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94944' , '23014' , 'GIUBILEO 2025 - SUSSIDIO RAGAZZI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/12/2024 12:34:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3902' AND id_document != '94807' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 19/12/2024 12:34:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3902', document_date = '2024-12-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 = '135.00', price_tax_excluded = '110.66', date_upd = NOW() WHERE id_document = '94807' 19/12/2024 12:34: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 = '94807' 19/12/2024 12:34:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94807' 19/12/2024 12:34: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 ( '94807' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 19/12/2024 12:34: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 ( '94807' , '23228' , 'CASULA GIUBILEO RICAMATA - CS64' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 19/12/2024 12:34: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 ( '94807' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 19/12/2024 12:38:06 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '4903' 19/12/2024 12:38:06 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '4903' 19/12/2024 12:38:50 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '4898' 19/12/2024 12:38:50 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '4898' 19/12/2024 12:44:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '4011' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 12:44: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' , '4011' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.78' , '9.61' , NOW() , NOW() ) 19/12/2024 12:44: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 = '94945' 19/12/2024 12:44:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '94945' 19/12/2024 12:44: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 ( '94945' , '7442' , 'PANE QUOTIDIANO' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 19/12/2024 12:44: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 ( '94945' , '14886' , 'ANGELO IN RESINA CON STELLA CM 9 - KS122-S' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 19/12/2024 12:57:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '4012' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 12:57:55 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' , '4012' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.40' , '11.80' , NOW() , NOW() ) 19/12/2024 12:57: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 = '94946' 19/12/2024 12:57:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '94946' 19/12/2024 12:57: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 ( '94946' , '7202' , 'ARTICOLI RELIGIOSI' , '18' , '-18' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '14.40' ) 19/12/2024 01:08:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '4013' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 01:08:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4013' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '111.00' , '100.91' , NOW() , NOW() ) 19/12/2024 01:08: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 = '94947' 19/12/2024 01:08:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '94947' 19/12/2024 01:08: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 ( '94947' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '9.05' , '7.4180327868852' , '22' , '0' , '9.05' ) 19/12/2024 01:08: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 ( '94947' , '23298' , 'RIMETTI A NOI I NOSTRI DEBITI' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 19/12/2024 01:08: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 ( '94947' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 19/12/2024 01:08: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 ( '94947' , '23278' , 'AMEN - MAR 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 19/12/2024 01:08: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 ( '94947' , '23279' , 'AMEN - APR 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 19/12/2024 01:08: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 ( '94947' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 19/12/2024 01:08: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 ( '94947' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 19/12/2024 01:08: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 ( '94947' , '23276' , 'TELA POLIESTERE' , '3' , '-3' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '37.50' ) 19/12/2024 01:09:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '4014' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 01:09:31 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' , '4014' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 19/12/2024 01:09:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94948' 19/12/2024 01:09:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94948' 19/12/2024 01:09:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94948' , '23278' , 'AMEN - MAR 25' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 19/12/2024 01:09:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94948' , '23279' , 'AMEN - APR 25' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 19/12/2024 02:30:19 pm >> DELETE FROM ps_document WHERE id_document = '94615' 19/12/2024 02:30:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '94615' 19/12/2024 02:36:47 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '3167' 19/12/2024 02:36:47 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '3167' 19/12/2024 02:39:17 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '4907' 19/12/2024 02:39:17 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '4907' 19/12/2024 02:39:29 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '6291' 19/12/2024 02:39:29 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '6291' 19/12/2024 03:48:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '4015' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 03:48:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4015' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '365.71' , '321.17' , NOW() , NOW() ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94949' 19/12/2024 03:48:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94949' 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '22706' , 'FRANCESCO DASSISI - A. COMASTRI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '22703' , 'UNA LOTTA PER LA VITA - E. BIANCHI' , '2' , '-2' , '4' , '14.00' , '14' , '0' , '5' , '26.60' ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '22707' , 'CUORI INQUIETI - G. RAVASI' , '2' , '-2' , '4' , '14.00' , '14' , '0' , '5' , '26.60' ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '22705' , 'NUDE DOMANDE DEL VANGELO - E. RONCHI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '23291' , 'PEZZO DI CIELO SOLO PER TE - D. BANZATO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '23300' , 'DOMENICA DELLA PAROLA 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 19/12/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94949' , '20561' , 'CONFEZIONE CARTONCINO CON BAMBINO - P762' , '50' , '-50' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '30.00' ) 19/12/2024 04:15:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '4016' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 04:15:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4016' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 19/12/2024 04:15: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 = '94950' 19/12/2024 04:15:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '94950' 19/12/2024 04:15: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 ( '94950' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 19/12/2024 04:15: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 ( '94950' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 19/12/2024 04:25:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 04:25:38 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' , '137/A' , '2024-12-19' , 'A' , '230' , '0' , '4668969' , 'VIA G. NICOTERA, 66 84080 PELLEZZANO' , '' , 'acconto € 50,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '143.80' , '117.87' , NOW() , NOW() ) 19/12/2024 04:25: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 = '94951' 19/12/2024 04:25:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '94951' 19/12/2024 04:25: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 ( '94951' , '16795' , 'LUMINO 5F ROSSO' , '30' , '-30' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '9.00' ) 19/12/2024 04:25: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 ( '94951' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 19/12/2024 04:25: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 ( '94951' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '100' , '-100' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '40.00' ) 19/12/2024 04:25: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 ( '94951' , '23189' , 'GRUPPO NATIVITA STILIZZATA - PB18073' , '36' , '-36' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '64.80' ) 19/12/2024 04:28:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '94951' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 04:28:45 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '137/A', document_date = '2024-12-19', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto € 50,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 = '165.40', price_tax_excluded = '135.57', date_upd = NOW() WHERE id_document = '94951' 19/12/2024 04:28:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94951' 19/12/2024 04:28:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '94951' 19/12/2024 04:28:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '16795' , 'LUMINO 5F ROSSO' , '30' , '-30' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '9.00' ) 19/12/2024 04:28:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 19/12/2024 04:28:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '100' , '-100' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '40.00' ) 19/12/2024 04:28:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '23189' , 'GRUPPO NATIVITA STILIZZATA - PB18073' , '48' , '-48' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '86.40' ) 19/12/2024 05:49:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '4017' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 05:49:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4017' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.70' , '9.70' , NOW() , NOW() ) 19/12/2024 05:49: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 = '94952' 19/12/2024 05:49:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94952' 19/12/2024 05:49: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 ( '94952' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 19/12/2024 05:49: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 ( '94952' , '17583' , 'FRATELLI TUTTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/12/2024 05:49: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 ( '94952' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/12/2024 05:52:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '4018' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 05:52:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4018' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.20' , '14.94' , NOW() , NOW() ) 19/12/2024 05:52: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 = '94953' 19/12/2024 05:52:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '94953' 19/12/2024 05:52: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 ( '94953' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 19/12/2024 05:52: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 ( '94953' , '23142' , 'MESSA MEDITAZIONE - GEN FEB 2025' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 19/12/2024 05:52: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 ( '94953' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 19/12/2024 06:48:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001114' AND id_product != '14792' AND ean13 != '' 19/12/2024 06:48:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001114', date_upd = NOW() WHERE id_product = '14792' 19/12/2024 06:48:33 pm >> UPDATE ps_product_lang SET name = 'PRESEPE ALABASTRO 1921/22', description = '' WHERE id_product = '14792' 19/12/2024 06:48:33 pm >> UPDATE ps_product SET wholesale_price = '5.70', on_sale = '0', price = '10.655737704918034' WHERE id_product = '14792' 19/12/2024 06:48:33 pm >> UPDATE ps_product_shop SET wholesale_price = '5.70', price = '10.655737704918034', id_tax_rules_group = '1', id_category_default = '187', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14792' 19/12/2024 06:48:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '14792' 19/12/2024 06:49:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8024299300902' AND id_product != '13299' AND ean13 != '' 19/12/2024 06:49:41 pm >> UPDATE ps_product SET id_supplier = '102', reference = '', ean13 = '8024299300902', date_upd = NOW() WHERE id_product = '13299' 19/12/2024 06:49:41 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' CON LED CM 13 - 30090', description = '' WHERE id_product = '13299' 19/12/2024 06:49:41 pm >> UPDATE ps_product SET wholesale_price = '3.69', on_sale = '0', price = '8.1967' WHERE id_product = '13299' 19/12/2024 06:49:41 pm >> UPDATE ps_product_shop SET wholesale_price = '3.69', price = '8.1967', id_tax_rules_group = '1', id_category_default = '415', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13299' 19/12/2024 06:49:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '13299' 19/12/2024 07:07:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '4019' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 07:07:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4019' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 19/12/2024 07:07:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94954' 19/12/2024 07:07:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '94954' 19/12/2024 07:07:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '14792' , 'PRESEPE ALABASTRO 1921/22' , '3' , '-3' , '1' , '11' , '9.016393442623' , '22' , '0' , '33.00' ) 19/12/2024 07:07:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '13299' , 'NATIVITA\' CON LED CM 13 - 30090' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 19/12/2024 07:07:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '14790' , 'NATIVITA STELLATA 13,5 CM' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 19/12/2024 07:07:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '15007' , 'PRESEPE LEGNO CON LUCI CM 20 - 31130' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 19/12/2024 07:07:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '14789' , 'NATIVITA STELLATA 18 CM' , '2' , '-2' , '1' , '13.5' , '11.065573770492' , '22' , '0' , '27.00' ) 19/12/2024 07:10:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4019' AND id_document != '94954' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 07:10:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4019', document_date = '2024-12-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 = '130.00', price_tax_excluded = '106.56', date_upd = NOW() WHERE id_document = '94954' 19/12/2024 07:10: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 = '94954' 19/12/2024 07:10:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '94954' 19/12/2024 07:10:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '14792' , 'PRESEPE ALABASTRO 1921/22' , '3' , '-3' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '33.00' ) 19/12/2024 07:10:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '13299' , 'NATIVITA\' CON LED CM 13 - 30090' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 19/12/2024 07:10:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '14790' , 'NATIVITA STELLATA 13,5 CM' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 19/12/2024 07:10:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '15007' , 'PRESEPE LEGNO CON LUCI CM 20 - 31130' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 19/12/2024 07:10:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '14789' , 'NATIVITA STELLATA 18 CM ' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 19/12/2024 07:10:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94954' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 19/12/2024 07:11:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '4019' AND id_document != '94954' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 07:11:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4019', document_date = '2024-12-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 = '130.00', price_tax_excluded = '106.56', date_upd = NOW() WHERE id_document = '94954' 19/12/2024 07:11: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 = '94954' 19/12/2024 07:11:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '94954' 19/12/2024 07:11: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 ( '94954' , '14792' , 'PRESEPE ALABASTRO 1921/22' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 19/12/2024 07:11: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 ( '94954' , '13299' , 'NATIVITA\' CON LED CM 13 - 30090' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 19/12/2024 07:11: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 ( '94954' , '14790' , 'NATIVITA STELLATA 13,5 CM' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 19/12/2024 07:11: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 ( '94954' , '15007' , 'PRESEPE LEGNO CON LUCI CM 20 - 31130' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 19/12/2024 07:11: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 ( '94954' , '14789' , 'NATIVITA STELLATA 18 CM ' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 19/12/2024 07:11: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 ( '94954' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 19/12/2024 07:48:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '4020' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 07:48:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4020' , '2024-12-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.00' , '54.10' , NOW() , NOW() ) 19/12/2024 07:48:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94955' 19/12/2024 07:48:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '94955' 19/12/2024 07:48: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 ( '94955' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 19/12/2024 07:48: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 ( '94955' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 19/12/2024 07:50:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '4020' AND id_document != '94955' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 19/12/2024 07:50:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4020', document_date = '2024-12-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 = '66.00', price_tax_excluded = '54.10', date_upd = NOW() WHERE id_document = '94955' 19/12/2024 07:50: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 = '94955' 19/12/2024 07:50:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '94955' 19/12/2024 07:50: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 ( '94955' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 19/12/2024 07:50: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 ( '94955' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' )