18/12/2024 09:02:42 am >> SELECT document_num FROM ps_document WHERE document_num = '133/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 09:02:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '133/A' , '2024-12-18' , 'A' , '178' , '0' , '4679446' , 'VIA S. MARGHERITA 1 84129 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 18/12/2024 09:02:43 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 = '94902' 18/12/2024 09:02:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94902' 18/12/2024 09:02:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94902' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '150' , '-150' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '45.00' ) 18/12/2024 09:22:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3978' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 09:22:58 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' , '3978' , '2024-12-18' , '' , '0' , '0' , '0' , 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.65' , '13.65' , NOW() , NOW() ) 18/12/2024 09:22:58 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 = '94903' 18/12/2024 09:22:58 am >> DELETE FROM ps_document_detail WHERE id_document = '94903' 18/12/2024 09:22:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94903' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '16.65' ) 18/12/2024 09:29:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3979' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 09:29:39 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' , '3979' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1568.66' , '1290.73' , NOW() , NOW() ) 18/12/2024 09:29:39 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 = '94904' 18/12/2024 09:29:39 am >> DELETE FROM ps_document_detail WHERE id_document = '94904' 18/12/2024 09:29: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 ( '94904' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '10' , '-10' , '3' , '2.0000' , '1.9231' , '4' , '0' , '20.00' ) 18/12/2024 09:29: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 ( '94904' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.6557' , '22' , '0' , '26.00' ) 18/12/2024 09:29: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 ( '94904' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '30.0000' , '24.5902' , '22' , '0' , '60.00' ) 18/12/2024 09:29: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 ( '94904' , '6538' , 'MESSA SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 18/12/2024 09:29: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 ( '94904' , '22982' , 'MESSA IN CHIESA INSIEME AI GRANDI' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 18/12/2024 09:29: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 ( '94904' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '1' , '-1' , '1' , '10.0000' , '8.1967' , '22' , '0' , '10.00' ) 18/12/2024 09:29: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 ( '94904' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '1' , '-1' , '1' , '11.0000' , '9.0164' , '22' , '0' , '11.00' ) 18/12/2024 09:29: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 ( '94904' , '18370' , 'CAMICE MISTO LANA - 70/000214' , '1' , '-1' , '1' , '315.0000' , '258.1967' , '22' , '0' , '315.00' ) 18/12/2024 09:29: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 ( '94904' , '22464' , 'CASULA LEGGERA - 1212' , '8' , '-8' , '1' , '70.0000' , '57.377' , '22' , '0' , '560.00' ) 18/12/2024 09:29: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 ( '94904' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '80.0000' , '65.5738' , '22' , '0' , '80.00' ) 18/12/2024 09:29: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 ( '94904' , '23168' , 'CAMICE IN MICROFIBRA COCOLLE - 434TPMA' , '3' , '-3' , '1' , '66.67' , '54.647540983607' , '22' , '0' , '200.01' ) 18/12/2024 09:29: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 ( '94904' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 18/12/2024 09:29: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 ( '94904' , '23092' , 'SPERANZA CHE E IN NOI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 18/12/2024 09:29: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 ( '94904' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 18/12/2024 09:31:32 am >> SELECT document_num FROM ps_document WHERE document_num = '96/A' AND id_document != '93088' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-11') 18/12/2024 09:31:32 am >> UPDATE ps_document SET id_document_type = '24', document_num = '96/A', document_date = '2024-09-11', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4679091', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'ACCONTO € 200 25/9/24 + € 140,00 29/10/24 + € 200,00 18/12 ', 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 = '1079.80', price_tax_excluded = '885.08', date_upd = NOW() WHERE id_document = '93088' 18/12/2024 09:31:32 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 = '93088' 18/12/2024 09:31:32 am >> DELETE FROM ps_document_detail WHERE id_document = '93088' 18/12/2024 09:31:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '21695' , 'CASULA MARIANA - 65/027108-M' , '1' , '-1' , '1' , '975.0000' , '799.18032786885' , '22' , '0' , '975.00' ) 18/12/2024 09:31:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 18/12/2024 09:31:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 18/12/2024 09:31:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 18/12/2024 09:31:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 18/12/2024 09:35:54 am >> DELETE FROM ps_document WHERE id_document = '92569' 18/12/2024 09:35:55 am >> DELETE FROM ps_document_detail WHERE id_document = '92569' 18/12/2024 09:38:38 am >> DELETE FROM ps_document WHERE id_document = '94865' 18/12/2024 09:38:38 am >> DELETE FROM ps_document_detail WHERE id_document = '94865' 18/12/2024 09:39:08 am >> DELETE FROM ps_document WHERE id_document = '92947' 18/12/2024 09:39:08 am >> DELETE FROM ps_document_detail WHERE id_document = '92947' 18/12/2024 09:49:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3978' AND id_document != '94903' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 09:49:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3978', document_date = '2024-12-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '16.65', price_tax_excluded = '13.65', date_upd = NOW() WHERE id_document = '94903' 18/12/2024 09:49:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94903' 18/12/2024 09:49:48 am >> DELETE FROM ps_document_detail WHERE id_document = '94903' 18/12/2024 09:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94903' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '10.50' ) 18/12/2024 09:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94903' , '9257' , 'SACRA FAMIGLIA' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 18/12/2024 09:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94903' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.65' , '2.9918032786885' , '22' , '0' , '3.65' ) 18/12/2024 09:53:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3901' AND id_document != '94806' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 18/12/2024 09:53:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3901', 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 = '368.05', price_tax_excluded = '337.32', date_upd = NOW() WHERE id_document = '94806' 18/12/2024 09:53: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 = '94806' 18/12/2024 09:53:19 am >> DELETE FROM ps_document_detail WHERE id_document = '94806' 18/12/2024 09:53: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 ( '94806' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '2' , '-2' , '4' , '42.0000' , '42' , '0' , '5' , '79.80' ) 18/12/2024 09:53: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 ( '94806' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '36' , '-36' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '50.40' ) 18/12/2024 09:53: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 ( '94806' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '-1' , '1' , '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 18/12/2024 09:53: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 ( '94806' , '23252' , 'BREVE INTRODUZIONE AL CRISTIANESIMO - J. RATZINGER' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 18/12/2024 09:53: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 ( '94806' , '23282' , 'CASTITA - E. VARDEN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 18/12/2024 09:53: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 ( '94806' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 18/12/2024 09:53: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 ( '94806' , '18183' , 'VANGELI SINOTTICI E ATTI DEGLI APOSTOLI - G. DE VIRGILIO' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 18/12/2024 09:53: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 ( '94806' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2024 09:55:22 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') 18/12/2024 09:55:22 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' 18/12/2024 09:55: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 = '94529' 18/12/2024 09:55:22 am >> DELETE FROM ps_document_detail WHERE id_document = '94529' 18/12/2024 09:55: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 ( '94529' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26.1' , '21.393442622951' , '22' , '0' , '26.10' ) 18/12/2024 09:55: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 ( '94529' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '5' , '2.09' ) 18/12/2024 09:55: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 ( '94529' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '5' , '38.00' ) 18/12/2024 09:55: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 ( '94529' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '13' , '-13' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '3.90' ) 18/12/2024 09:56:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3939' AND id_document != '94853' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-13') 18/12/2024 09:56:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3939', document_date = '2024-12-13', 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.20', price_tax_excluded = '2.62', date_upd = NOW() WHERE id_document = '94853' 18/12/2024 09:56: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 = '94853' 18/12/2024 09:56:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94853' 18/12/2024 09:56: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 ( '94853' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.2' , '2.6229508196721' , '22' , '0' , '3.20' ) 18/12/2024 09:58:44 am >> UPDATE ps_customer SET deleted='1' , active = '0' WHERE id_customer = '94659' 18/12/2024 09:59:04 am >> DELETE FROM ps_document WHERE id_document = '94659' 18/12/2024 09:59:04 am >> DELETE FROM ps_document_detail WHERE id_document = '94659' 18/12/2024 09:59:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3618' AND id_document != '94459' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-23') 18/12/2024 09:59:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3618', document_date = '2024-11-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.25', price_tax_excluded = '24.09', date_upd = NOW() WHERE id_document = '94459' 18/12/2024 09:59:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94459' 18/12/2024 09:59:42 am >> DELETE FROM ps_document_detail WHERE id_document = '94459' 18/12/2024 09:59:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94459' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 18/12/2024 09:59:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94459' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 18/12/2024 10:05:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3940' AND id_document != '94854' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-13') 18/12/2024 10:05:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3940', document_date = '2024-12-13', 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 = '900.00', price_tax_excluded = '761.06', date_upd = NOW() WHERE id_document = '94854' 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94854' 18/12/2024 10:05:11 am >> DELETE FROM ps_document_detail WHERE id_document = '94854' 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '16796' , 'LUMINO 5B BIANCO' , '1680' , '-1680' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '336.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '1914' , 'CERA DELLA LITURGIA' , '30' , '-30' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '135.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '12.50' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '60.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '18.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '9716' , 'SCATOLA PORTA OSTIE INOX IHS - CM 9,5 X 12,5 - 682' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '9715' , 'SCATOLA PORTA OSTIE - CM 17 - 683' , '1' , '-1' , '1' , '41.0000' , '33.606557377049' , '22' , '0' , '41.00' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '22496' , 'PREGHIERA CATECHESI PAPA FRANCESCO - 8654' , '1' , '-1' , '4' , '5.9500' , '5.95' , '0' , '0' , '5.95' ) 18/12/2024 10:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '23169' , 'DILEXIT NOS ' , '45' , '-45' , '4' , '2.2000' , '2.2' , '0' , '5' , '94.05' ) 18/12/2024 10:07:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3980' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 10:07: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 ( '11' , '3980' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.80' , '60.41' , NOW() , NOW() ) 18/12/2024 10:07: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 = '94905' 18/12/2024 10:07:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94905' 18/12/2024 10:07: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 ( '94905' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 18/12/2024 10:07: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 ( '94905' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 18/12/2024 10:07: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 ( '94905' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 18/12/2024 10:07: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 ( '94905' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 18/12/2024 10:10:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3940' AND id_document != '94854' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-13') 18/12/2024 10:10:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3940', document_date = '2024-12-13', 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 = '900.00', price_tax_excluded = '761.06', date_upd = NOW() WHERE id_document = '94854' 18/12/2024 10:10:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94854' 18/12/2024 10:10:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94854' 18/12/2024 10:10:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '16796' , 'LUMINO 5B BIANCO' , '1680' , '-1680' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '336.00' ) 18/12/2024 10:10:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '1914' , 'CERA DELLA LITURGIA' , '30' , '-30' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '135.00' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '12.50' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '60.00' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '18.00' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '9715' , 'SCATOLA PORTA OSTIE - CM 17 - 683' , '1' , '-1' , '1' , '41.0000' , '33.606557377049' , '22' , '0' , '41.00' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '22496' , 'PREGHIERA CATECHESI PAPA FRANCESCO - 8654' , '1' , '-1' , '4' , '5.9500' , '5.95' , '0' , '0' , '5.95' ) 18/12/2024 10:10:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94854' , '23169' , 'DILEXIT NOS ' , '45' , '-45' , '4' , '2.2000' , '2.2' , '0' , '5' , '94.05' ) 18/12/2024 10:14:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3966' AND id_document != '94889' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-17') 18/12/2024 10:14:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3966', document_date = '2024-12-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '694.20', price_tax_excluded = '569.02', date_upd = NOW() WHERE id_document = '94889' 18/12/2024 10:14: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 = '94889' 18/12/2024 10:14:18 am >> DELETE FROM ps_document_detail WHERE id_document = '94889' 18/12/2024 10:14: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 ( '94889' , '19626' , 'STATUA S .ESPEDITO CM 30 - 642 ' , '1' , '-1' , '1' , '88.0000' , '72.131147540984' , '22' , '0' , '88.00' ) 18/12/2024 10:14: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 ( '94889' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '-3' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '90.00' ) 18/12/2024 10:14: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 ( '94889' , '22920' , 'SERVIZIO MESSA GIUBILEO 2025' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 18/12/2024 10:14: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 ( '94889' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/12/2024 10:14: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 ( '94889' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '8.50' ) 18/12/2024 10:14: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 ( '94889' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 18/12/2024 10:14: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 ( '94889' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 18/12/2024 10:14: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 ( '94889' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 18/12/2024 10:14: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 ( '94889' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/12/2024 10:14: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 ( '94889' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 18/12/2024 10:14: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 ( '94889' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/12/2024 10:14: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 ( '94889' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '2' , '-2' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '99.80' ) 18/12/2024 10:17:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3769' AND id_document != '94649' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-03') 18/12/2024 10:17:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3769', 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 = '49.90', price_tax_excluded = '40.90', date_upd = NOW() WHERE id_document = '94649' 18/12/2024 10:17: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 = '94649' 18/12/2024 10:17:05 am >> DELETE FROM ps_document_detail WHERE id_document = '94649' 18/12/2024 10:17: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 ( '94649' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '99' , '-99' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '19.80' ) 18/12/2024 10:17: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 ( '94649' , '9202' , 'SANTANNA - 4 ' , '7' , '-7' , '1' , '3' , '2.4590163934426' , '22' , '0' , '21.00' ) 18/12/2024 10:17: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 ( '94649' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '9.1' , '7.4590163934426' , '22' , '0' , '9.10' ) 18/12/2024 10:18:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3618' AND id_document != '94459' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-23') 18/12/2024 10:18:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3618', document_date = '2024-11-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.25', price_tax_excluded = '24.09', date_upd = NOW() WHERE id_document = '94459' 18/12/2024 10:18: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 = '94459' 18/12/2024 10:18:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94459' 18/12/2024 10:18: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 ( '94459' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 18/12/2024 10:18: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 ( '94459' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '6' , '4.9180327868852' , '22' , '0' , '12.00' ) 18/12/2024 10:19:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3878' AND id_document != '94779' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 18/12/2024 10:19:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3878', 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 = '14.90', price_tax_excluded = '12.21', date_upd = NOW() WHERE id_document = '94779' 18/12/2024 10:19:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94779' 18/12/2024 10:19:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94779' 18/12/2024 10:19:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94779' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 18/12/2024 10:19:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94779' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 18/12/2024 10:19:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3903' AND id_document != '94808' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 18/12/2024 10:19:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3903', document_date = '2024-12-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA S. MARGHERITA 1 84129 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '676.40', price_tax_excluded = '555.04', date_upd = NOW() WHERE id_document = '94808' 18/12/2024 10:19:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94808' 18/12/2024 10:19:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94808' 18/12/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94808' , '17617' , 'IMMAGINI ISONZO X 100' , '17' , '-17' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '56.10' ) 18/12/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94808' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 18/12/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94808' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 18/12/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94808' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 18/12/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94808' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '10' , '-10' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '11.00' ) 18/12/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94808' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 18/12/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94808' , '8054' , 'PISSIDE DUE SPECIE - 873' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 18/12/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94808' , '22215' , 'CALICE MALTA - 341' , '1' , '-1' , '1' , '280.0000' , '229.50819672131' , '22' , '0' , '280.00' ) 18/12/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94808' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 18/12/2024 10:20:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3970' AND id_document != '94893' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-17') 18/12/2024 10:20:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3970', document_date = '2024-12-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '59.90', price_tax_excluded = '50.47', date_upd = NOW() WHERE id_document = '94893' 18/12/2024 10:20:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94893' 18/12/2024 10:20:16 am >> DELETE FROM ps_document_detail WHERE id_document = '94893' 18/12/2024 10:20:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94893' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '3' , '-3' , '1' , '6.2000' , '5.0819672131148' , '22' , '0' , '18.60' ) 18/12/2024 10:20:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94893' , '22437' , 'BRACCIALE ELASTICO S. BENEDETTO - 434M79' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 18/12/2024 10:20:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94893' , '8336' , 'PREGHIERE A SANTA RITA DA CASCIA - 8352' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 18/12/2024 10:20:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94893' , '8645' , 'QUADRETTO SANTA RITA - 1269/S59' , '3' , '-3' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '7.50' ) 18/12/2024 10:20:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94893' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '5.6' , '4.5901639344262' , '22' , '0' , '11.20' ) 18/12/2024 10:21:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3966' AND id_document != '94889' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-17') 18/12/2024 10:21:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3966', document_date = '2024-12-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '694.20', price_tax_excluded = '569.02', date_upd = NOW() WHERE id_document = '94889' 18/12/2024 10:21:32 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 = '94889' 18/12/2024 10:21:32 am >> DELETE FROM ps_document_detail WHERE id_document = '94889' 18/12/2024 10:21:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '19626' , 'STATUA S .ESPEDITO CM 30 - 642 ' , '1' , '-1' , '1' , '88.0000' , '72.131147540984' , '22' , '0' , '88.00' ) 18/12/2024 10:21:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '-3' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '90.00' ) 18/12/2024 10:21:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '22920' , 'SERVIZIO MESSA GIUBILEO 2025' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 18/12/2024 10:21: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 ( '94889' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18.5' , '15.16393442623' , '22' , '0' , '18.50' ) 18/12/2024 10:21: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 ( '94889' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 18/12/2024 10:21: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 ( '94889' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 18/12/2024 10:21: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 ( '94889' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 18/12/2024 10:21: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 ( '94889' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/12/2024 10:21: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 ( '94889' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 18/12/2024 10:21: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 ( '94889' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/12/2024 10:21: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 ( '94889' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '2' , '-2' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '99.80' ) 18/12/2024 10:21:59 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') 18/12/2024 10:21:59 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' 18/12/2024 10:21: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 = '94863' 18/12/2024 10:22:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94863' 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '21860' , 'BAMBINELLO CM 10 - PKS10-C' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '22420' , 'CROCE MURRINE CM 21' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '935' , 'BAMBINO CM 7,5 DIPINTO - P3' , '17' , '-17' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '34.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '20028' , 'CANDELA ALTARE 26X350' , '4' , '-4' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '8.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '20005' , 'GESU BAMBINO CON AUREOLA CM 20 - BJ148-20' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '23120' , 'AMEN - GEN 25' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '0' , '9.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '23119' , 'AMEN - FEB 25' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '0' , '9.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '23278' , 'AMEN - MAR 25' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '0' , '9.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '6356' , 'MEDAGLIA S.CUORE- MAD. CARMINE' , '1' , '-1' , '1' , '0.1300' , '0.10655737704918' , '22' , '0' , '0.13' ) 18/12/2024 10:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94863' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/12/2024 10:29:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3981' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 10:29:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3981' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.40' , '12.40' , NOW() , NOW() ) 18/12/2024 10:29: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 = '94906' 18/12/2024 10:29:04 am >> DELETE FROM ps_document_detail WHERE id_document = '94906' 18/12/2024 10:29:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94906' , '23300' , 'DOMENICA DELLA PAROLA 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 18/12/2024 10:29:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94906' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '0' , '9.50' ) 18/12/2024 10:29:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3982' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 10:29:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3982' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 18/12/2024 10:29:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94907' 18/12/2024 10:29:31 am >> DELETE FROM ps_document_detail WHERE id_document = '94907' 18/12/2024 10:29:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94907' , '23194' , 'DILEXIT NOS - 8992' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 18/12/2024 10:52:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3983' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 10:52: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' , '3983' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.80' , '62.31' , NOW() , NOW() ) 18/12/2024 10:52: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 = '94908' 18/12/2024 10:52:54 am >> DELETE FROM ps_document_detail WHERE id_document = '94908' 18/12/2024 10:52: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 ( '94908' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 18/12/2024 10:52: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 ( '94908' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 18/12/2024 10:52: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 ( '94908' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 18/12/2024 10:52: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 ( '94908' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 18/12/2024 10:52: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 ( '94908' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 18/12/2024 11:04:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3984' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 11:04: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' , '3984' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 18/12/2024 11:04: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 = '94909' 18/12/2024 11:04:54 am >> DELETE FROM ps_document_detail WHERE id_document = '94909' 18/12/2024 11:04: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 ( '94909' , '935' , 'BAMBINO CM 7,5 DIPINTO - P3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 18/12/2024 11:10:36 am >> SELECT document_num FROM ps_document WHERE document_num = '22/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 11:10: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 ( '23' , '22/L' , '2024-12-18' , 'L' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '680.45' , '667.12' , NOW() , NOW() ) 18/12/2024 11:10: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 = '94910' 18/12/2024 11:10:36 am >> DELETE FROM ps_document_detail WHERE id_document = '94910' 18/12/2024 11:10: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 ( '94910' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.00' ) 18/12/2024 11:10: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 ( '94910' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '12' , '-12' , '3' , '3.5000' , '3.3654' , '4' , '0' , '42.00' ) 18/12/2024 11:10: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 ( '94910' , '7311' , 'OSTIA SOTTILE 74MM' , '7' , '-7' , '3' , '2.0000' , '1.9231' , '4' , '0' , '14.00' ) 18/12/2024 11:10: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 ( '94910' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '1.0000' , '0.8197' , '22' , '0' , '6.00' ) 18/12/2024 11:10: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 ( '94910' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.5000' , '4.3269' , '4' , '0' , '4.50' ) 18/12/2024 11:10: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 ( '94910' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '19.0000' , '15.5738' , '22' , '0' , '19.00' ) 18/12/2024 11:10: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 ( '94910' , '17030' , 'MARIA - UN CAMMINO - A. DEHO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 18/12/2024 11:10: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 ( '94910' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '5' , '104.50' ) 18/12/2024 11:10: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 ( '94910' , '6809' , 'MOCCOLO 60X165' , '8' , '-8' , '1' , '4.5000' , '3.6885' , '22' , '0' , '36.00' ) 18/12/2024 11:10: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 ( '94910' , '23257' , 'CON UN PIEDE IN PARADISO' , '35' , '-35' , '4' , '12.0000' , '12' , '0' , '5' , '399.00' ) 18/12/2024 11:10: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 ( '94910' , '23256' , 'CELEBRIAMO MARIA -MESSALE MARIANO' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '5' , '39.90' ) 18/12/2024 11:12:07 am >> SELECT document_num FROM ps_document WHERE document_num = '22/L' AND id_document != '94910' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 11:12:07 am >> UPDATE ps_document SET id_document_type = '23', document_num = '22/L', document_date = '2024-12-18', document_letter = 'L', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '680.45', price_tax_excluded = '667.12', date_upd = NOW() WHERE id_document = '94910' 18/12/2024 11:12:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94910' 18/12/2024 11:12:07 am >> DELETE FROM ps_document_detail WHERE id_document = '94910' 18/12/2024 11:12:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.00' ) 18/12/2024 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '12' , '-12' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '42.00' ) 18/12/2024 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '7311' , 'OSTIA SOTTILE 74MM' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 18/12/2024 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 18/12/2024 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 18/12/2024 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 18/12/2024 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '17030' , 'MARIA - UN CAMMINO - A. DEHO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 18/12/2024 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '5' , '104.50' ) 18/12/2024 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '6809' , 'MOCCOLO 60X165' , '8' , '-8' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '36.00' ) 18/12/2024 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '23257' , 'CON UN PIEDE IN PARADISO' , '35' , '-35' , '4' , '12.0000' , '12' , '0' , '5' , '399.00' ) 18/12/2024 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94910' , '23256' , 'CELEBRIAMO MARIA -MESSALE MARIANO' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '5' , '39.90' ) 18/12/2024 11:12:23 am >> DELETE FROM ps_document WHERE id_document = '92691' 18/12/2024 11:12:23 am >> DELETE FROM ps_document_detail WHERE id_document = '92691' 18/12/2024 11:14:54 am >> SELECT document_num FROM ps_document WHERE document_num = '23/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 11: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 ( '23' , '23/L' , '2024-12-18' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '43.10' , '37.67' , NOW() , NOW() ) 18/12/2024 11: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 = '94911' 18/12/2024 11:14:54 am >> DELETE FROM ps_document_detail WHERE id_document = '94911' 18/12/2024 11: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 ( '94911' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3654' , '4' , '0' , '3.50' ) 18/12/2024 11: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 ( '94911' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9231' , '4' , '0' , '6.00' ) 18/12/2024 11: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 ( '94911' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2951' , '22' , '0' , '8.90' ) 18/12/2024 11: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 ( '94911' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 18/12/2024 11: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 ( '94911' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754' , '22' , '0' , '7.90' ) 18/12/2024 11: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 ( '94911' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.0164' , '22' , '0' , '9.80' ) 18/12/2024 11:16:57 am >> DELETE FROM ps_document WHERE id_document = '93134' 18/12/2024 11:16:57 am >> DELETE FROM ps_document_detail WHERE id_document = '93134' 18/12/2024 11:57:11 am >> SELECT document_num FROM ps_document WHERE document_num = '134/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 11:57:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '134/A' , '2024-12-18' , 'A' , '2739' , '0' , '4671014' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 18/12/2024 11:57:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94912' 18/12/2024 11:57:11 am >> DELETE FROM ps_document_detail WHERE id_document = '94912' 18/12/2024 11:57:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '22907' , 'AGENDINA 2025 - 40827' , '2' , '-2' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '14.00' ) 18/12/2024 12:16:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3985' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 12:16:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3985' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 18/12/2024 12:16: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 = '94913' 18/12/2024 12:16:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '94913' 18/12/2024 12:16: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 ( '94913' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 18/12/2024 12:29:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3986' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 12:29: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' , '3986' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '35.25' , NOW() , NOW() ) 18/12/2024 12:29: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 = '94914' 18/12/2024 12:29:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '94914' 18/12/2024 12:29: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 ( '94914' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 18/12/2024 12:29: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 ( '94914' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 18/12/2024 12:32:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3987' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 12:32:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3987' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.40' , '35.57' , NOW() , NOW() ) 18/12/2024 12:32:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94915' 18/12/2024 12:32:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '94915' 18/12/2024 12:32:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94915' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 18/12/2024 12:32:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94915' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.35' , '2.7459016393443' , '22' , '0' , '13.40' ) 18/12/2024 03:49:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3988' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 03:49:06 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' , '3988' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.80' , '23.53' , NOW() , NOW() ) 18/12/2024 03:49:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94916' 18/12/2024 03:49:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '94916' 18/12/2024 03:49:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94916' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 18/12/2024 03:49:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94916' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 18/12/2024 03:49:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94916' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 18/12/2024 03:53:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3989' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 03:53:02 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' , '3989' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 18/12/2024 03:53:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94917' 18/12/2024 03:53:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94917' 18/12/2024 03:53:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94917' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '4' , '-4' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '1.20' ) 18/12/2024 03:56:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 03:56:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3990' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.22' , '11.22' , NOW() , NOW() ) 18/12/2024 03:56: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 = '94918' 18/12/2024 03:56:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94918' 18/12/2024 03:56: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 ( '94918' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 18/12/2024 03:56: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 ( '94918' , '23143' , 'CATECHISTI DI SPERANZA - F. VANNOTTI' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 18/12/2024 04:21:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 04:21:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3991' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.66' , '4.66' , NOW() , NOW() ) 18/12/2024 04:21:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94919' 18/12/2024 04:21:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '94919' 18/12/2024 04:21:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94919' , '16856' , 'PADRE NOSTRO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 18/12/2024 04:29:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 04:29: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' , '3992' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.30' , '7.62' , NOW() , NOW() ) 18/12/2024 04:29: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 = '94920' 18/12/2024 04:29:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94920' 18/12/2024 04:29: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 ( '94920' , '19786' , 'ROSARIO MADREPERLA MM5 - 10M5' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 18/12/2024 04:29: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 ( '94920' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' ) 18/12/2024 04:33:33 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'lQ9ZrJjjrCXJxR2q' , NOW() , NOW() ) 18/12/2024 04:33:33 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4150' , '1' ) 18/12/2024 04:33:33 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4150' , '2' ) 18/12/2024 04:33:33 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4150' , '3' ) 18/12/2024 04:34:10 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4150' 18/12/2024 04:34:10 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4150' , '10' , '210' , '' , 'BARRA' , 'DAVIDE ' , 'VIA LUIGI ANGRISANI 36' , '' , '84100' , 'SALERNO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 18/12/2024 04:34:10 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4150' 18/12/2024 04:35:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '268' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 04:35:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '268' , '2024-12-18' , '' , '4150' , '0' , '4679449' , 'VIA LUIGI ANGRISANI 36 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '300.00' , NOW() , NOW() ) 18/12/2024 04:35:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94921' 18/12/2024 04:35:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94921' 18/12/2024 04:35:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94921' , '18371' , 'CAMICE MISTO LANA - 70/000403' , '1' , '-1' , '0' , '300' , '300' , '' , '0' , '300.00' ) 18/12/2024 04:41:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '269' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 04:41:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '269' , '2024-12-18' , '' , '4044' , '0' , '4679161' , 'VIA NAZIONALE 137 18100 IMPERIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '72.20' , '72.20' , NOW() , NOW() ) 18/12/2024 04:41:35 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 = '94922' 18/12/2024 04:41:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '94922' 18/12/2024 04:41:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94922' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '25' , '-25' , '4' , '2.40' , '2.4' , '0' , '5' , '57.00' ) 18/12/2024 04:41:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94922' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 18/12/2024 05:12:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '135/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 05:12:02 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' , '135/A' , '2024-12-18' , 'A' , '362' , '0' , '362' , 'UNITÀ PASTORALE MONTORO 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 18/12/2024 05:12:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94923' 18/12/2024 05:12:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94923' 18/12/2024 05:12:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94923' , '18022' , 'TURIBOLO H 24' , '1' , '-1' , '1' , '155.00' , '127.04918032787' , '22' , '0' , '155.00' ) 18/12/2024 05:12:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94923' , '22305' , 'NAVETTA CM 13' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 18/12/2024 05:13:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '136/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 05:13:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '136/A' , '2024-12-18' , 'A' , '4150' , '0' , '4679449' , 'VIA LUIGI ANGRISANI 36 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '245.90' , NOW() , NOW() ) 18/12/2024 05:13:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94924' 18/12/2024 05:13:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '94924' 18/12/2024 05:13:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94924' , '18371' , 'CAMICE MISTO LANA - 70/000403' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 18/12/2024 05:14:33 pm >> 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') 18/12/2024 05:14:33 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '268', document_date = '2024-12-18', document_letter = '', id_customer = '4150', id_supplier = '', id_address = '4679449', 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 = '11.00', price_tax_excluded = '11.00', date_upd = NOW() WHERE id_document = '94921' 18/12/2024 05:14:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94921' 18/12/2024 05:14:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '94921' 18/12/2024 05:14:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94921' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 18/12/2024 05:15:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '136/A' AND id_document != '94924' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 05:15:02 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '136/A', document_date = '2024-12-18', document_letter = 'A', id_customer = '4150', id_supplier = '', id_address = '4679449', address1 = 'VIA LUIGI ANGRISANI 36 84100 SALERNO', address2 = '', note = 'E C 268', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '300.00', price_tax_excluded = '245.90', date_upd = NOW() WHERE id_document = '94924' 18/12/2024 05:15:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94924' 18/12/2024 05:15:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94924' 18/12/2024 05:15:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94924' , '18371' , 'CAMICE MISTO LANA - 70/000403' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 18/12/2024 05:25:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3992' AND id_document != '94920' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 05:25:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3992', document_date = '2024-12-18', 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 = '9.30', price_tax_excluded = '7.62', date_upd = NOW() WHERE id_document = '94920' 18/12/2024 05:25: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 = '94920' 18/12/2024 05:25:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94920' 18/12/2024 05:25: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 ( '94920' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '1.80' ) 18/12/2024 05:25: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 ( '94920' , '22437' , 'BRACCIALE ELASTICO S. BENEDETTO - 434M79' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 18/12/2024 06:20:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 06:20:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3993' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.81' , '20.81' , NOW() , NOW() ) 18/12/2024 06:20:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94925' 18/12/2024 06:20:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '94925' 18/12/2024 06:20:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94925' , '21670' , 'PER CUSTODIRE IL FUOCO - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 18/12/2024 06:20:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94925' , '16664' , 'DON BOSCO LA STORIA INFINITA - B. FERRERO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 18/12/2024 06:22:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '60/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 06:22:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '60/E' , '2024-12-18' , 'E' , '2938' , '0' , '4678844' , 'VIA ARCIVESCOVATO 31 55100 LUCCA' , '' , '' , '10' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '100.00' , '100.00' , NOW() , NOW() ) 18/12/2024 06:22:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94926' 18/12/2024 06:22:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '94926' 18/12/2024 06:22: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 ( '94926' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '15' , '-15' , '4' , '10.00' , '10' , '0' , '40' , '90.00' ) 18/12/2024 06:56:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 18/12/2024 06:56:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3994' , '2024-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 18/12/2024 06:56:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94927' 18/12/2024 06:56:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '94927' 18/12/2024 06:56:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94927' , '23100' , 'MEDAGLIA MIRACOLOSA ARG. MEDIA - M057' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' )