27/03/2024 09:11:10 am >> SELECT document_num FROM ps_document WHERE document_num = '925' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 09:11:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '925' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '35.25' , NOW() , NOW() ) 27/03/2024 09:11:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90977' 27/03/2024 09:11:10 am >> DELETE FROM ps_document_detail WHERE id_document = '90977' 27/03/2024 09:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90977' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '43' , '35.245901639344' , '22' , '0' , '43.00' ) 27/03/2024 10:02:50 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/03/2024 10:02:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22345' , '1' , '' , 'nuovo-prodotto' ) 27/03/2024 10:02:50 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22345' , '1' , '1' , '2' , NOW() , NOW() ) 27/03/2024 10:02:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22345' , '0' , '1' , '0' , '0' ) 27/03/2024 10:03:45 am >> SELECT document_num FROM ps_document WHERE document_num = '14/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 10:03:45 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' , '14/E' , '2024-03-27' , 'E' , '3479' , '0' , '4673306' , 'VIA SAN GREGORIO VII 28 84091 BATTIPAGLIA' , '' , 'fattura errata numerazione' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '156.00' , '156.00' , NOW() , NOW() ) 27/03/2024 10:03:45 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 = '90978' 27/03/2024 10:03:45 am >> DELETE FROM ps_document_detail WHERE id_document = '90978' 27/03/2024 10:03:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90978' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.0000' , '8.1967' , '22' , '0' , '30.00' ) 27/03/2024 10:03:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90978' , '17161' , 'CARBONCINI NERI - CARNE' , '3' , '-3' , '1' , '12.0000' , '9.8361' , '22' , '0' , '36.00' ) 27/03/2024 10:03:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90978' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '-3' , '1' , '30.0000' , '24.5902' , '22' , '0' , '90.00' ) 27/03/2024 10:04:44 am >> SELECT document_num FROM ps_document WHERE document_num = '15/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 10:04:44 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 ( '25' , '15/E' , '2024-03-27' , 'E' , '3479' , '0' , '4673306' , 'VIA SAN GREGORIO VII 28 84091 BATTIPAGLIA' , '' , 'storno fattura 14/E' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '156.00' , '156.00' , NOW() , NOW() ) 27/03/2024 10:04:44 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 = '90979' 27/03/2024 10:04:44 am >> DELETE FROM ps_document_detail WHERE id_document = '90979' 27/03/2024 10:04:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90979' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '3' , '1' , '10.0000' , '8.1967' , '22' , '0' , '30.00' ) 27/03/2024 10:04:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90979' , '17161' , 'CARBONCINI NERI - CARNE' , '3' , '3' , '1' , '12.0000' , '9.8361' , '22' , '0' , '36.00' ) 27/03/2024 10:04:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90979' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '3' , '1' , '30.0000' , '24.5902' , '22' , '0' , '90.00' ) 27/03/2024 10:23:55 am >> SELECT document_num FROM ps_document WHERE document_num = '926' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 10:23:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '926' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '285.00' , '239.26' , NOW() , NOW() ) 27/03/2024 10:23:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90980' 27/03/2024 10:23:55 am >> DELETE FROM ps_document_detail WHERE id_document = '90980' 27/03/2024 10:23: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 ( '90980' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 27/03/2024 10:23: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 ( '90980' , '22224' , 'PASSIONE DI NOSTRO SIGNORE GESU CRISTO' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 27/03/2024 10:23: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 ( '90980' , '17885' , 'CROCE FAGGIO CORPO MET CM 28 - 169' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 27/03/2024 10:23: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 ( '90980' , '20968' , 'CROCE SAN BENEDETTO - PG598' , '1' , '-1' , '1' , '13.90' , '11.393442622951' , '22' , '0' , '13.90' ) 27/03/2024 10:23: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 ( '90980' , '21857' , 'CROCE SAN BENEDETTO CM 19 - PG599.RSS' , '1' , '-1' , '1' , '30.75' , '25.204918032787' , '22' , '0' , '30.75' ) 27/03/2024 10:23: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 ( '90980' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 27/03/2024 10:23: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 ( '90980' , '9387' , 'SAN BENEDETTO - CM 13 ' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 27/03/2024 10:23: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 ( '90980' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '6.60' ) 27/03/2024 10:23: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 ( '90980' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '3.40' ) 27/03/2024 10:23: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 ( '90980' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 27/03/2024 10:29:26 am >> SELECT document_num FROM ps_document WHERE document_num = '927' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 10:29:26 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' , '927' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 27/03/2024 10:29:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90981' 27/03/2024 10:29:26 am >> DELETE FROM ps_document_detail WHERE id_document = '90981' 27/03/2024 10:29:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90981' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '10' , '-10' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '14.00' ) 27/03/2024 10:29:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90981' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '40' , '-40' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '20.00' ) 27/03/2024 10:31:39 am >> SELECT document_num FROM ps_document WHERE document_num = '14/E' AND id_document != '90978' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-26') 27/03/2024 10:31:39 am >> UPDATE ps_document SET id_document_type = '23', document_num = '14/E', document_date = '2024-03-26', document_letter = 'E', id_customer = '3479', id_supplier = '', id_address = '4673306', address1 = 'VIA SAN GREGORIO VII 28 84091 BATTIPAGLIA', address2 = '', note = 'fattura errata numerazione', 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 = '156.00', price_tax_excluded = '127.87', date_upd = NOW() WHERE id_document = '90978' 27/03/2024 10:31: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 = '90978' 27/03/2024 10:31:39 am >> DELETE FROM ps_document_detail WHERE id_document = '90978' 27/03/2024 10:31: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 ( '90978' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 27/03/2024 10:31: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 ( '90978' , '17161' , 'CARBONCINI NERI - CARNE' , '3' , '-3' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '36.00' ) 27/03/2024 10:31: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 ( '90978' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '-3' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '90.00' ) 27/03/2024 10:31:58 am >> SELECT document_num FROM ps_document WHERE document_num = '15/E' AND id_document != '90979' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-26') 27/03/2024 10:31:58 am >> UPDATE ps_document SET id_document_type = '25', document_num = '15/E', document_date = '2024-03-26', document_letter = 'E', id_customer = '3479', id_supplier = '', id_address = '4673306', address1 = 'VIA SAN GREGORIO VII 28 84091 BATTIPAGLIA', address2 = '', note = 'storno fattura 14/E', 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 = '156.00', price_tax_excluded = '127.87', date_upd = NOW() WHERE id_document = '90979' 27/03/2024 10:31: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 = '90979' 27/03/2024 10:31:58 am >> DELETE FROM ps_document_detail WHERE id_document = '90979' 27/03/2024 10:31: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 ( '90979' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 27/03/2024 10:31: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 ( '90979' , '17161' , 'CARBONCINI NERI - CARNE' , '3' , '3' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '36.00' ) 27/03/2024 10:31: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 ( '90979' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '3' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '90.00' ) 27/03/2024 10:39:28 am >> SELECT document_num FROM ps_document WHERE document_num = '928' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 10:39:28 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' , '928' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.80' , '73.61' , NOW() , NOW() ) 27/03/2024 10:39:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90982' 27/03/2024 10:39:28 am >> DELETE FROM ps_document_detail WHERE id_document = '90982' 27/03/2024 10:39:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90982' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 27/03/2024 10:39:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90982' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 27/03/2024 10:41:07 am >> SELECT document_num FROM ps_document WHERE document_num = '929' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 10:41:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '929' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '137.90' , '113.03' , NOW() , NOW() ) 27/03/2024 10:41: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 = '90983' 27/03/2024 10:41:07 am >> DELETE FROM ps_document_detail WHERE id_document = '90983' 27/03/2024 10:41: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 ( '90983' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '95.00' ) 27/03/2024 10:41: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 ( '90983' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 27/03/2024 10:41: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 ( '90983' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 27/03/2024 10:41:57 am >> SELECT document_num FROM ps_document WHERE document_num = '930' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 10:41:57 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' , '930' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.92' , NOW() , NOW() ) 27/03/2024 10:41:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90984' 27/03/2024 10:41:57 am >> DELETE FROM ps_document_detail WHERE id_document = '90984' 27/03/2024 10:41:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90984' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 27/03/2024 10:57:35 am >> SELECT document_num FROM ps_document WHERE document_num = '931' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 10:57:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '931' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '13.46' , NOW() , NOW() ) 27/03/2024 10:57:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90985' 27/03/2024 10:57:35 am >> DELETE FROM ps_document_detail WHERE id_document = '90985' 27/03/2024 10:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90985' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 27/03/2024 11:51:57 am >> SELECT document_num FROM ps_document WHERE document_num = '791' AND id_document != '90805' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 27/03/2024 11:51:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '791', document_date = '2024-03-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 = '47.40', price_tax_excluded = '38.85', date_upd = NOW() WHERE id_document = '90805' 27/03/2024 11:51:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90805' 27/03/2024 11:51:57 am >> DELETE FROM ps_document_detail WHERE id_document = '90805' 27/03/2024 11:51:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90805' , '11756' , 'VINO BIANCO SECCO - 14%' , '7' , '-7' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '45.50' ) 27/03/2024 11:51:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90805' , '3069' , 'CROCE PENITENZA 10X13 - 1380' , '1' , '-1' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '1.90' ) 27/03/2024 11:52:11 am >> SELECT document_num FROM ps_document WHERE document_num = '784' AND id_document != '90798' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-16') 27/03/2024 11:52:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '784', document_date = '2024-03-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '43.90', price_tax_excluded = '43.58', date_upd = NOW() WHERE id_document = '90798' 27/03/2024 11:52: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 = '90798' 27/03/2024 11:52:11 am >> DELETE FROM ps_document_detail WHERE id_document = '90798' 27/03/2024 11:52: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 ( '90798' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' , '37.1000' , '37.1' , '0' , '0' , '37.10' ) 27/03/2024 11:52: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 ( '90798' , '22152' , 'A TE RICORRIAMO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 27/03/2024 11:52: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 ( '90798' , '14936' , 'E NATO, ALBUM DA COLORARE' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 27/03/2024 11:52: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 ( '90798' , '3069' , 'CROCE PENITENZA 10X13 - 1380' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' ) 27/03/2024 11:52:26 am >> SELECT document_num FROM ps_document WHERE document_num = '578' AND id_document != '90527' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-27') 27/03/2024 11:52:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '578', document_date = '2024-02-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 = '50.00', price_tax_excluded = '42.52', date_upd = NOW() WHERE id_document = '90527' 27/03/2024 11:52:27 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 = '90527' 27/03/2024 11:52:27 am >> DELETE FROM ps_document_detail WHERE id_document = '90527' 27/03/2024 11:52:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90527' , '21006' , 'MOSE E MIRIAM' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 27/03/2024 11:52:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90527' , '21015' , 'PASQUA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 27/03/2024 11:52:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90527' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 27/03/2024 11:52:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90527' , '21012' , 'PECORELLA SMARRITA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 27/03/2024 11:52:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90527' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 27/03/2024 11:52:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90527' , '15318' , 'PERDONAMI SIGNORE ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 27/03/2024 11:52:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90527' , '3069' , 'CROCE PENITENZA 10X13 - 1380' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/03/2024 11:52:49 am >> SELECT document_num FROM ps_document WHERE document_num = '411' AND id_document != '90304' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 27/03/2024 11:52:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '411', document_date = '2024-02-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 = '315.00', price_tax_excluded = '261.25', date_upd = NOW() WHERE id_document = '90304' 27/03/2024 11:52:49 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 = '90304' 27/03/2024 11:52:49 am >> DELETE FROM ps_document_detail WHERE id_document = '90304' 27/03/2024 11:52:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90304' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 27/03/2024 11:52:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90304' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 27/03/2024 11:52:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90304' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 27/03/2024 11:52:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90304' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 27/03/2024 11:52:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90304' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/03/2024 11:52:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90304' , '18770' , 'STOLA DIACONALE MARIANA - 36006' , '1' , '-1' , '1' , '140.0000' , '114.75409836066' , '22' , '0' , '140.00' ) 27/03/2024 11:52:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90304' , '13110' , 'S. PAOLO BABY - 023 SGD 9 BB' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 27/03/2024 11:52:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90304' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' , '3.7000' , '3.0327868852459' , '22' , '0' , '3.70' ) 27/03/2024 11:52:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90304' , '3069' , 'CROCE PENITENZA 10X13 - 1380' , '3' , '-3' , '1' , '1.6' , '1.3114754098361' , '22' , '0' , '4.80' ) 27/03/2024 11:53:33 am >> SELECT document_num FROM ps_document WHERE document_num = '515' AND id_document != '90433' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 27/03/2024 11:53:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '515', document_date = '2024-02-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.00', price_tax_excluded = '34.84', date_upd = NOW() WHERE id_document = '90433' 27/03/2024 11:53: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 = '90433' 27/03/2024 11:53:33 am >> DELETE FROM ps_document_detail WHERE id_document = '90433' 27/03/2024 11:53: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 ( '90433' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '24.6' , '20.16393442623' , '22' , '0' , '24.60' ) 27/03/2024 11:53: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 ( '90433' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 27/03/2024 11:53: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 ( '90433' , '3069' , 'CROCE PENITENZA 10X13 - 1380' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 27/03/2024 11:59:03 am >> UPDATE ps_document SET id_document_type = '33', document_num = '2024-DL000837', document_date = '2024-03-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '176.88', price_tax_excluded = '176.88', date_upd = NOW() WHERE id_document = '90780' 27/03/2024 11:59:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90780' 27/03/2024 11:59:03 am >> DELETE FROM ps_document_detail WHERE id_document = '90780' 27/03/2024 11:59:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90780' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 27/03/2024 11:59:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90780' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 27/03/2024 11:59:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90780' , '22290' , 'CHIESA IN PREGHIERA' , '10' , '10' , '4' , '8.5000' , '8.5' , '0' , '45' , '46.75' ) 27/03/2024 11:59:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90780' , '22291' , 'DOMANDE DI DIO, DOMANDE A DIO' , '1' , '1' , '4' , '25.0000' , '25' , '0' , '45' , '13.75' ) 27/03/2024 11:59:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90780' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '1' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 27/03/2024 11:59:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90780' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '1' , '1' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 27/03/2024 11:59:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90780' , '22111' , 'PREGARE OGGI' , '5' , '5' , '4' , '8.50' , '8.5' , '0' , '45' , '23.3750' ) 27/03/2024 12:00:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2024-FV 000426' , '2024-03-27' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '6.5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '183.38' , '183.38' , NOW() , NOW() ) 27/03/2024 12:00:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90986' 27/03/2024 12:00:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '90986' 27/03/2024 12:00:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90986' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 27/03/2024 12:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2549' AND id_supplier = '79' 27/03/2024 12:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2549' , '79' , '1' ) 27/03/2024 12:00:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90986' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 27/03/2024 12:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 27/03/2024 12:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 27/03/2024 12:00:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90986' , '22290' , 'CHIESA IN PREGHIERA' , '10' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '46.75' ) 27/03/2024 12:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22290' AND id_supplier = '79' 27/03/2024 12:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22290' , '79' , '1' ) 27/03/2024 12:00:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90986' , '22291' , 'DOMANDE DI DIO, DOMANDE A DIO' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '45' , '13.75' ) 27/03/2024 12:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22291' AND id_supplier = '79' 27/03/2024 12:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22291' , '79' , '1' ) 27/03/2024 12:00:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90986' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 27/03/2024 12:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18956' AND id_supplier = '79' 27/03/2024 12:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18956' , '79' , '1' ) 27/03/2024 12:00:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90986' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 27/03/2024 12:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20798' AND id_supplier = '79' 27/03/2024 12:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20798' , '79' , '1' ) 27/03/2024 12:00: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 ( '90986' , '22111' , 'PREGARE OGGI' , '5' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '23.38' ) 27/03/2024 12:00:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22111' AND id_supplier = '79' 27/03/2024 12:00:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22111' , '79' , '1' ) 27/03/2024 12:28:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '932' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 12:28:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '932' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 27/03/2024 12:28:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90987' 27/03/2024 12:28:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '90987' 27/03/2024 12:28:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90987' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 27/03/2024 04:06:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '933' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 04:06:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '933' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.60' , '11.15' , NOW() , NOW() ) 27/03/2024 04:06:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90988' 27/03/2024 04:06:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '90988' 27/03/2024 04:06:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90988' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '6.8' , '5.5737704918033' , '22' , '0' , '13.60' ) 27/03/2024 04:58:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '934' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 04:58:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '934' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 27/03/2024 04:58:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90989' 27/03/2024 04:58:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90989' 27/03/2024 04:58:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90989' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '22' , '18.032786885246' , '22' , '0' , '110.00' ) 27/03/2024 04:58:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90989' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 27/03/2024 04:58:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '935' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 04:58:57 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' , '935' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 27/03/2024 04:58:57 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 = '90990' 27/03/2024 04:58:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '90990' 27/03/2024 04:58:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90990' , '19139' , 'IMMACOLATA MADRE DI DIO ......' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 27/03/2024 05:33:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '936' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 05:33:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '936' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 27/03/2024 05:33:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90991' 27/03/2024 05:33:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '90991' 27/03/2024 05:33:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90991' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/03/2024 05:33:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90991' , '22308' , 'MESSA MEDITAZIONE - MAG/GIU ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 27/03/2024 07:32:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '937' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 27/03/2024 07:32: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' , '937' , '2024-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 27/03/2024 07:32:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90992' 27/03/2024 07:32:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '90992' 27/03/2024 07:32:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90992' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' )