26/11/2024 10:11:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3646' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 10:11:30 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' , '3646' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 26/11/2024 10:11:30 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 = '94493' 26/11/2024 10:11:30 am >> DELETE FROM ps_document_detail WHERE id_document = '94493' 26/11/2024 10:11:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94493' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 26/11/2024 10:11:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3647' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 10:11: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 ( '11' , '3647' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 26/11/2024 10:11: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 = '94494' 26/11/2024 10:11:45 am >> DELETE FROM ps_document_detail WHERE id_document = '94494' 26/11/2024 10:11: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 ( '94494' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 26/11/2024 10:12:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3647' AND id_document != '94494' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 10:12:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3647', document_date = '2024-11-26', 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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '94494' 26/11/2024 10:12: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 = '94494' 26/11/2024 10:12:44 am >> DELETE FROM ps_document_detail WHERE id_document = '94494' 26/11/2024 10:12: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 ( '94494' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 26/11/2024 10:12:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3646' AND id_document != '94493' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 10:12:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3646', document_date = '2024-11-26', 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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '94493' 26/11/2024 10:12: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 = '94493' 26/11/2024 10:12:57 am >> DELETE FROM ps_document_detail WHERE id_document = '94493' 26/11/2024 10:12: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 ( '94493' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 26/11/2024 10:17:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3648' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 10:17:02 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' , '3648' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 26/11/2024 10:17:02 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 = '94495' 26/11/2024 10:17:02 am >> DELETE FROM ps_document_detail WHERE id_document = '94495' 26/11/2024 10:17:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94495' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 26/11/2024 10:32:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3649' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 10:32:00 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' , '3649' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '344.00' , '294.11' , NOW() , NOW() ) 26/11/2024 10:32: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 = '94496' 26/11/2024 10:32:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94496' 26/11/2024 10:32: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 ( '94496' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 26/11/2024 10:32: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 ( '94496' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 26/11/2024 10:32: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 ( '94496' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '15' , '-15' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '52.50' ) 26/11/2024 10:32:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94496' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 26/11/2024 10:32:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94496' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/11/2024 10:32:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94496' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 26/11/2024 10:32:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94496' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3' , '2.4590163934426' , '22' , '0' , '72.00' ) 26/11/2024 10:32:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94496' , '12819' , 'REGISTRO DEL CATECHISTA ' , '7' , '-7' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '7.00' ) 26/11/2024 10:32:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94496' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 26/11/2024 10:32:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94496' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 26/11/2024 11:01:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3647' AND id_document != '94494' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 11:01:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3647', document_date = '2024-11-26', 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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '94494' 26/11/2024 11:01:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94494' 26/11/2024 11:01:38 am >> DELETE FROM ps_document_detail WHERE id_document = '94494' 26/11/2024 11:01:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94494' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '2' , '-2' , '1' , '9' , '7.3770491803279' , '22' , '0' , '18.00' ) 26/11/2024 11:14:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3650' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 11:14:27 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' , '3650' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '149.70' , '124.45' , NOW() , NOW() ) 26/11/2024 11:14: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 = '94497' 26/11/2024 11:14:27 am >> DELETE FROM ps_document_detail WHERE id_document = '94497' 26/11/2024 11:14: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 ( '94497' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '9.7' , '9.7' , '0' , '0' , '9.70' ) 26/11/2024 11:14: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 ( '94497' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 26/11/2024 11:18:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3651' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 11:18:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3651' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.45' , '12.57' , NOW() , NOW() ) 26/11/2024 11:18:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94498' 26/11/2024 11:18:41 am >> DELETE FROM ps_document_detail WHERE id_document = '94498' 26/11/2024 11:18:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94498' , '22913' , 'CALENDARIO A STRAPPO 2025 - 8710' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 26/11/2024 11:18:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94498' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 26/11/2024 11:22:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3652' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 11:22:09 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' , '3652' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.90' , '12.24' , NOW() , NOW() ) 26/11/2024 11:22:09 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 = '94499' 26/11/2024 11:22:09 am >> DELETE FROM ps_document_detail WHERE id_document = '94499' 26/11/2024 11:22:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94499' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 26/11/2024 11:22:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94499' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 26/11/2024 11:24:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3653' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 11:24:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3653' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '107.41' , NOW() , NOW() ) 26/11/2024 11:24:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94500' 26/11/2024 11:24:38 am >> DELETE FROM ps_document_detail WHERE id_document = '94500' 26/11/2024 11:24:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '23093' , 'CONFEZIONE CAPANNA - P622-ITA' , '12' , '-12' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '14.40' ) 26/11/2024 11:24:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '14835' , 'STELLA COMETA - P581' , '12' , '-12' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '28.80' ) 26/11/2024 11:24:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '23094' , 'CANDELA NATIVITA - P690' , '11' , '-11' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '30.80' ) 26/11/2024 11:24:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '14957' , 'QUADRETTO NATIVITA 16X12 - P577' , '3' , '-3' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '13.50' ) 26/11/2024 11:24:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 26/11/2024 11:24:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11.85' , '9.7131147540984' , '22' , '0' , '11.85' ) 26/11/2024 11:24:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/11/2024 11:24:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 26/11/2024 11:53:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3654' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 11:53: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' , '3654' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 26/11/2024 11:53: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 = '94501' 26/11/2024 11:53:07 am >> DELETE FROM ps_document_detail WHERE id_document = '94501' 26/11/2024 11:53: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 ( '94501' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 26/11/2024 12:15:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3655' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 12:15:18 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' , '3655' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.50' , '24.70' , NOW() , NOW() ) 26/11/2024 12:15:18 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 = '94502' 26/11/2024 12:15:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '94502' 26/11/2024 12:15:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94502' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 26/11/2024 12:15:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94502' , '22300' , 'BRUCIA INCENSO NIKEL CM 8' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 26/11/2024 12:15:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94502' , '17554' , 'GRANDI SANTI AMICI DI GESU' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 26/11/2024 12:16:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3656' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 12:16:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3656' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '6.85' , NOW() , NOW() ) 26/11/2024 12:16:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94503' 26/11/2024 12:16:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '94503' 26/11/2024 12:16:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94503' , '17670' , 'NOVENA ALLA BEATA VERGINE ' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 26/11/2024 12:16:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94503' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 26/11/2024 12:23:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3520' AND id_document != '94320' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 26/11/2024 12:23:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3520', document_date = '2024-11-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 = '21.81', price_tax_excluded = '21.81', date_upd = NOW() WHERE id_document = '94320' 26/11/2024 12:23: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 = '94320' 26/11/2024 12:23:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '94320' 26/11/2024 12:23: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 ( '94320' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 26/11/2024 12:23: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 ( '94320' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.17' , '2.17' , '0' , '0' , '2.17' ) 26/11/2024 12:23: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 ( '94320' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 26/11/2024 12:23: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 ( '94320' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 26/11/2024 12:24:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3172' AND id_document != '93813' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 26/11/2024 12:24:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3172', document_date = '2024-10-24', 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 = '563.50', price_tax_excluded = '487.63', date_upd = NOW() WHERE id_document = '93813' 26/11/2024 12:24:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93813' 26/11/2024 12:24:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '93813' 26/11/2024 12:24:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 26/11/2024 12:24:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 26/11/2024 12:24:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '21.50' ) 26/11/2024 12:24:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '40' , '-40' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '140.00' ) 26/11/2024 12:24:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 26/11/2024 12:24:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 26/11/2024 12:30:23 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '14835' 26/11/2024 12:30:23 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '14835' 26/11/2024 12:31:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3653' AND id_document != '94500' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 12:31:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3653', document_date = '2024-11-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '130.00', price_tax_excluded = '107.41', date_upd = NOW() WHERE id_document = '94500' 26/11/2024 12:31:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94500' 26/11/2024 12:31:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '94500' 26/11/2024 12:31:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '23093' , 'CONFEZIONE CAPANNA - P622-ITA' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 26/11/2024 12:31:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '14835' , 'STELLA COMETA - P581' , '12' , '-12' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '28.80' ) 26/11/2024 12:31:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '23094' , 'CANDELA NATIVITA - P690' , '11' , '-11' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '30.80' ) 26/11/2024 12:31:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '14957' , 'QUADRETTO NATIVITA 16X12 - P577' , '3' , '-3' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '13.50' ) 26/11/2024 12:31:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 26/11/2024 12:31:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25.35' , '20.77868852459' , '22' , '0' , '25.35' ) 26/11/2024 12:31:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 26/11/2024 12:31:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94500' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 26/11/2024 12:45:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3657' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 12:45: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' , '3657' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.90' , '48.10' , NOW() , NOW() ) 26/11/2024 12:45: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 = '94504' 26/11/2024 12:45:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94504' 26/11/2024 12:45: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 ( '94504' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 26/11/2024 12:45: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 ( '94504' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 26/11/2024 12:45: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 ( '94504' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '5' , '39.90' ) 26/11/2024 12:52:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3658' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 12:52:15 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' , '3658' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 26/11/2024 12:52:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94505' 26/11/2024 12:52:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '94505' 26/11/2024 12:52:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94505' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 26/11/2024 04:09:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3659' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 04:09:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3659' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.95' , '18.94' , NOW() , NOW() ) 26/11/2024 04:09:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94506' 26/11/2024 04:09:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '94506' 26/11/2024 04:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94506' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '3' , '-3' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '2.40' ) 26/11/2024 04:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94506' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 26/11/2024 04:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94506' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 26/11/2024 04:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94506' , '10870' , 'UN MESE CON LA MEDAGLIA MIRACOLOSA - 8382' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/11/2024 04:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94506' , '23093' , 'CONFEZIONE CAPANNA - P622-ITA' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 26/11/2024 04:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94506' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/11/2024 04:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94506' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 26/11/2024 04:53: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 ( '31' , '3053/24' , '2024-11-21' , '24' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '707.40' , '680.19' , NOW() , NOW() ) 26/11/2024 04:53: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 = '94507' 26/11/2024 04:53:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '94507' 26/11/2024 04:53: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 ( '94507' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '53' , '53' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '59.3477' ) 26/11/2024 04:53:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20429' AND id_supplier = '22' 26/11/2024 04:53:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20429' , '22' , '1' ) 26/11/2024 04:53:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94507' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '292' , '292' , '3' , '2.2' , '2.1153846153846' , '4' , '3' , '648.0531' ) 26/11/2024 04:53:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20433' AND id_supplier = '22' 26/11/2024 04:53:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20433' , '22' , '1' ) 26/11/2024 05:44:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3660' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 05:44:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3660' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 26/11/2024 05:44: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 = '94508' 26/11/2024 05:44:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '94508' 26/11/2024 05:44: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 ( '94508' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 26/11/2024 05:44: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 ( '94508' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 26/11/2024 06:00:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3661' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 06:00: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' , '3661' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '42.62' , NOW() , NOW() ) 26/11/2024 06:00: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 = '94509' 26/11/2024 06:00:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '94509' 26/11/2024 06:00: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 ( '94509' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '34.00' ) 26/11/2024 06:00: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 ( '94509' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '18.00' ) 26/11/2024 06:00:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3662' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 06:00:15 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' , '3662' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 26/11/2024 06:00:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94510' 26/11/2024 06:00:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '94510' 26/11/2024 06:00:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94510' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '18.00' ) 26/11/2024 06:17:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3663' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 26/11/2024 06:17:28 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' , '3663' , '2024-11-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 26/11/2024 06:17:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94511' 26/11/2024 06:17:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '94511' 26/11/2024 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94511' , '22265' , 'DIO ATTRAVERSA LA CITTA - TONINO BELLO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' )