28/05/2022 08:46:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1685' AND id_document != '58482' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 28/05/2022 08:46:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1685', document_date = '2022-05-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 = '60.00', price_tax_excluded = '51.25', date_upd = NOW() WHERE id_document = '58482' 28/05/2022 08:46:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58482' 28/05/2022 08:46:59 am >> DELETE FROM ps_document_detail WHERE id_document = '58482' 28/05/2022 08:46:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58482' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '29.5000' , '24.180327868852' , '22' , '0' , '29.50' ) 28/05/2022 08:46:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 28/05/2022 08:46:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 28/05/2022 08:46:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58482' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11.2000' , '9.1803278688525' , '22' , '0' , '11.20' ) 28/05/2022 08:46:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 28/05/2022 08:46:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 28/05/2022 08:46:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58482' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '11.5000' , '11.5' , '0' , '0' , '11.50' ) 28/05/2022 08:46:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 28/05/2022 08:46:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 28/05/2022 08:46:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58482' , '13733' , 'DECINA - 356/14' , '3' , '-3' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '5.10' ) 28/05/2022 08:46:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '13733' AND id_supplier = '' 28/05/2022 08:46:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13733' , '' , '1' ) 28/05/2022 08:46:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58482' , '13364' , 'CORONA MM 6 ' , '1' , '-1' , '1' , '2.7' , '2.2131147540984' , '22' , '0' , '2.70' ) 28/05/2022 08:46:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '13364' AND id_supplier = '' 28/05/2022 08:46:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13364' , '' , '1' ) 28/05/2022 08:52:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1673' AND id_document != '58470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 28/05/2022 08:52:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1673', document_date = '2022-05-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 = '148.50', price_tax_excluded = '121.72', date_upd = NOW() WHERE id_document = '58470' 28/05/2022 08:52: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 = '58470' 28/05/2022 08:52:09 am >> DELETE FROM ps_document_detail WHERE id_document = '58470' 28/05/2022 08:52: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 ( '58470' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '65' , '-65' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '32.50' ) 28/05/2022 08:52:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 28/05/2022 08:52:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 28/05/2022 08:52: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 ( '58470' , '15774' , 'INCENSO NARJAN - 500G' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 28/05/2022 08:52:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = '' 28/05/2022 08:52:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' ) 28/05/2022 08:52: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 ( '58470' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '5' , '-5' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '6.00' ) 28/05/2022 08:52:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 28/05/2022 08:52:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 28/05/2022 08:52: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 ( '58470' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '3' , '-3' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '18.00' ) 28/05/2022 08:52:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '13562' AND id_supplier = '' 28/05/2022 08:52:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13562' , '' , '1' ) 28/05/2022 08:52: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 ( '58470' , '7202' , 'ARTICOLI RELIGIOSI' , '7' , '-7' , '1' , '6' , '4.9180327868852' , '22' , '0' , '42.00' ) 28/05/2022 08:52:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 28/05/2022 08:52:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 28/05/2022 09:28:23 am >> DELETE FROM ps_document WHERE id_document = '58421' 28/05/2022 09:28:23 am >> DELETE FROM ps_document_detail WHERE id_document = '58421' 28/05/2022 09:41:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1688' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-28') 28/05/2022 09:41:53 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' , '1688' , '2022-05-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.80' , '5.57' , NOW() , NOW() ) 28/05/2022 09:41:53 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 = '58485' 28/05/2022 09:41:53 am >> DELETE FROM ps_document_detail WHERE id_document = '58485' 28/05/2022 09:41:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58485' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '6.80' , '5.5737704918033' , '22' , '0' , '6.80' ) 28/05/2022 09:41:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '1621' AND id_supplier = '' 28/05/2022 09:41:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1621' , '' , '1' ) 28/05/2022 09:49:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1689' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-28') 28/05/2022 09:49:32 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' , '1689' , '2022-05-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.70' , '6.31' , NOW() , NOW() ) 28/05/2022 09:49:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58486' 28/05/2022 09:49:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58486' 28/05/2022 09:49:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58486' , '18222' , 'ROSARIO COLORATO - R316' , '11' , '-11' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.70' ) 28/05/2022 09:49:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 28/05/2022 09:49:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 28/05/2022 09:49:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1690' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-28') 28/05/2022 09:49:52 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' , '1690' , '2022-05-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.65' , '6.65' , NOW() , NOW() ) 28/05/2022 09:49:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58487' 28/05/2022 09:49:52 am >> DELETE FROM ps_document_detail WHERE id_document = '58487' 28/05/2022 09:49:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58487' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7' , '7' , '0' , '5' , '6.65' ) 28/05/2022 09:49:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 28/05/2022 09:49:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 28/05/2022 11:42:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1691' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-28') 28/05/2022 11:42: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' , '1691' , '2022-05-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.40' , '27.38' , NOW() , NOW() ) 28/05/2022 11:42: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 = '58488' 28/05/2022 11:42:02 am >> DELETE FROM ps_document_detail WHERE id_document = '58488' 28/05/2022 11:42: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 ( '58488' , '4243' , 'FORMELLA 15X15 ANGELO - F1087MI' , '1' , '-1' , '1' , '31.00' , '25.409836065574' , '22' , '0' , '31.00' ) 28/05/2022 11:42:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '4243' AND id_supplier = '' 28/05/2022 11:42:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4243' , '' , '1' ) 28/05/2022 11:42: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 ( '58488' , '18318' , 'CONFEZIONE BRACCIALE MULTICOLORE COMUNIONE - 2377/K0001' , '1' , '-1' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '2.40' ) 28/05/2022 11:42:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18318' AND id_supplier = '' 28/05/2022 11:42:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18318' , '' , '1' ) 28/05/2022 11:50:56 am >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-28') 28/05/2022 11:50:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '40/A' , '2022-05-28' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.50' , '45.49' , NOW() , NOW() ) 28/05/2022 11:50:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58489' 28/05/2022 11:50:56 am >> DELETE FROM ps_document_detail WHERE id_document = '58489' 28/05/2022 11:50:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58489' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '15' , '-15' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '18.00' ) 28/05/2022 11:50:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58489' , '15097' , 'CORONA MATRIMONIO - ORO' , '5' , '-5' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '37.50' ) 28/05/2022 12:07:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1692' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-28') 28/05/2022 12:07:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1692' , '2022-05-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '99.41' , NOW() , NOW() ) 28/05/2022 12:07:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58490' 28/05/2022 12:07:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '58490' 28/05/2022 12:07:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58490' , '12661' , 'CAMICE BIANCO - MISTO COT. 150' , '1' , '-1' , '1' , '49.7' , '40.737704918033' , '22' , '0' , '49.70' ) 28/05/2022 12:07:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12661' AND id_supplier = '' 28/05/2022 12:07:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12661' , '' , '1' ) 28/05/2022 12:07:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58490' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 28/05/2022 12:07:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3977' AND id_supplier = '' 28/05/2022 12:07:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3977' , '' , '1' ) 28/05/2022 12:07:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58490' , '6317' , 'MEDAGLIA MIRACOLOSA - 8332' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/05/2022 12:07:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6317' AND id_supplier = '' 28/05/2022 12:07:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6317' , '' , '1' ) 28/05/2022 12:07:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58490' , '6322' , 'MEDAGLIA MIRACOLOSA BAGNO ORO 24KT MM22 - 064022MI ' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 28/05/2022 12:07:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6322' AND id_supplier = '' 28/05/2022 12:07:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6322' , '' , '1' ) 28/05/2022 12:07:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58490' , '17414' , 'BIBBIA SCRUTATE LE SCRITTURE - TELATA' , '1' , '-1' , '4' , '34.00' , '34' , '0' , '5' , '32.30' ) 28/05/2022 12:07:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17414' AND id_supplier = '' 28/05/2022 12:07:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17414' , '' , '1' ) 28/05/2022 12:35:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1693' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-28') 28/05/2022 12:35:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1693' , '2022-05-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 28/05/2022 12:35:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58491' 28/05/2022 12:35:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '58491' 28/05/2022 12:35:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58491' , '16190' , 'VESTINA BATTESIMALE CANDELA/FONTE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 28/05/2022 12:35:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16190' AND id_supplier = '' 28/05/2022 12:35:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16190' , '' , '1' ) 28/05/2022 12:49:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 28/05/2022 12:49:39 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTI 50,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2788.00', price_tax_excluded = '2285.25', date_upd = NOW() WHERE id_document = '56617' 28/05/2022 12:49: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 = '56617' 28/05/2022 12:49:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 28/05/2022 12:49: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 ( '56617' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '875.0000' , '717.2131147541' , '22' , '0' , '875.00' ) 28/05/2022 12:49:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 28/05/2022 12:49:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 28/05/2022 12:49: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 28/05/2022 12:49:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 28/05/2022 12:49:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 28/05/2022 12:49: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 ( '56617' , '18239' , 'SERVIZIO MESSA - MARIANO m/l - 7051' , '1' , '-1' , '1' , '63.00' , '51.639344262295' , '22' , '0' , '63.00' ) 28/05/2022 12:49:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18239' AND id_supplier = '' 28/05/2022 12:49:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18239' , '' , '1' ) 28/05/2022 12:49:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 28/05/2022 12:49:58 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTI 50,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2725.00', price_tax_excluded = '2233.61', date_upd = NOW() WHERE id_document = '56617' 28/05/2022 12:49:58 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 = '56617' 28/05/2022 12:49:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 28/05/2022 12:49:58 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 ( '56617' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '875.0000' , '717.2131147541' , '22' , '0' , '875.00' ) 28/05/2022 12:49:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 28/05/2022 12:49:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 28/05/2022 12:49:58 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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 28/05/2022 12:49:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 28/05/2022 12:49:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 28/05/2022 12:50:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '59/A' AND id_document != '29452' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-06-28') 28/05/2022 12:50:33 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '59/A', document_date = '2021-06-28', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '627.00', price_tax_excluded = '570.74', date_upd = NOW() WHERE id_document = '29452' 28/05/2022 12:50:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '29452' 28/05/2022 12:50:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '29452' 28/05/2022 12:50:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '1914' , 'CERA DELLA LITURGIA*******' , '72' , '-72' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '252.00' ) 28/05/2022 12:50:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 28/05/2022 12:50:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 28/05/2022 12:50:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '1914' , 'CERA DELLA LITURGIA****' , '12' , '-12' , '1' , '3.5000' , '2.8688524590164' , '22' , '100' , '0.00' ) 28/05/2022 12:50:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 28/05/2022 12:50:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 28/05/2022 12:50:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 27' , '2' , '-2' , '0' , '25.0000' , '25' , '0' , '0' , '50.00' ) 28/05/2022 12:50:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 28/05/2022 12:50:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 28/05/2022 12:50:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 35' , '2' , '-2' , '0' , '35.0000' , '35' , '0' , '0' , '70.00' ) 28/05/2022 12:50:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 28/05/2022 12:50:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 28/05/2022 12:50:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 55' , '1' , '-1' , '0' , '75.0000' , '75' , '0' , '0' , '75.00' ) 28/05/2022 12:50:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 28/05/2022 12:50:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 28/05/2022 12:50:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 70' , '1' , '-1' , '0' , '120.0000' , '120' , '0' , '0' , '120.00' ) 28/05/2022 12:50:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 28/05/2022 12:50:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 28/05/2022 12:50:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '18239' , 'SERVIZIO MESSA - MARIANO m/l - 7051' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 28/05/2022 12:50:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18239' AND id_supplier = '' 28/05/2022 12:50:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18239' , '' , '1' ) 28/05/2022 12:53:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1691' AND id_document != '58488' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-28') 28/05/2022 12:53:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1691', document_date = '2022-05-28', 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 = '33.40', price_tax_excluded = '27.38', date_upd = NOW() WHERE id_document = '58488' 28/05/2022 12:53:27 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 = '58488' 28/05/2022 12:53:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '58488' 28/05/2022 12:53:27 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 ( '58488' , '905' , 'BACIO - FORM. 14X18 - OGGETTI' , '1' , '-1' , '1' , '31.00' , '25.409836065574' , '22' , '0' , '31.00' ) 28/05/2022 12:53:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '905' AND id_supplier = '' 28/05/2022 12:53:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '905' , '' , '1' ) 28/05/2022 12:53:27 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 ( '58488' , '18318' , 'CONFEZIONE BRACCIALE MULTICOLORE COMUNIONE - 2377/K0001' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 28/05/2022 12:53:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18318' AND id_supplier = '' 28/05/2022 12:53:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18318' , '' , '1' )