10/09/2022 08:19:56 am >> SELECT document_num FROM ps_document WHERE document_num = '66/A' AND id_document != '61145' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-03') 10/09/2022 08:19:56 am >> UPDATE ps_document SET id_document_type = '24', document_num = '66/A', document_date = '2022-09-03', document_letter = 'A', id_customer = '189', id_supplier = '', id_address = '4670598', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', 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 = '936.00', price_tax_excluded = '767.21', date_upd = NOW() WHERE id_document = '61145' 10/09/2022 08:19: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 = '61145' 10/09/2022 08:19:56 am >> DELETE FROM ps_document_detail WHERE id_document = '61145' 10/09/2022 08:19: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 ( '61145' , '12817' , 'LIBRO DEI MATRIMONI' , '24' , '-24' , '1' , '40.0000' , '32.786885245902' , '22' , '35' , '624.00' ) 10/09/2022 08:19:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 10/09/2022 08:19:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 10/09/2022 08:19: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 ( '61145' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '35' , '312.00' ) 10/09/2022 08:19:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = '' 10/09/2022 08:19:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' ) 10/09/2022 09:56:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2701' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-10') 10/09/2022 09:56: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' , '2701' , '2022-09-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.65' , '11.65' , NOW() , NOW() ) 10/09/2022 09:56: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 = '61755' 10/09/2022 09:56:55 am >> DELETE FROM ps_document_detail WHERE id_document = '61755' 10/09/2022 09:56: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 ( '61755' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 10/09/2022 09:56:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '' 10/09/2022 09:56:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' ) 10/09/2022 09:56: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 ( '61755' , '14712' , 'VERGINE DEL SILENZIO - E. ANTENUCCI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 10/09/2022 09:56:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '14712' AND id_supplier = '' 10/09/2022 09:56:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14712' , '' , '1' ) 10/09/2022 09:56: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 ( '61755' , '17525' , 'SANTI MEDICI COSMA E DAMIANO - 8990' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 10/09/2022 09:56:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17525' AND id_supplier = '' 10/09/2022 09:56:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17525' , '' , '1' ) 10/09/2022 11:05:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2644' AND id_document != '61176' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-06') 10/09/2022 11:05:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2644', document_date = '2022-09-06', 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 = '152.00', price_tax_excluded = '127.23', date_upd = NOW() WHERE id_document = '61176' 10/09/2022 11:05: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 = '61176' 10/09/2022 11:05:02 am >> DELETE FROM ps_document_detail WHERE id_document = '61176' 10/09/2022 11:05: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 ( '61176' , '15991' , 'SOSTARE CON DIO' , '4' , '-4' , '4' , '2.4000' , '2.4' , '0' , '5' , '9.12' ) 10/09/2022 11:05:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '15991' AND id_supplier = '' 10/09/2022 11:05:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15991' , '' , '1' ) 10/09/2022 11:05: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 ( '61176' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 10/09/2022 11:05:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 10/09/2022 11:05:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 10/09/2022 11:05: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 ( '61176' , '18133' , 'CROCE SAN BENEDETTO CM 11 - CSB2' , '2' , '-2' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '19.00' ) 10/09/2022 11:05:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18133' AND id_supplier = '' 10/09/2022 11:05:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18133' , '' , '1' ) 10/09/2022 11:05: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 ( '61176' , '2989' , 'CROCE GHIACCIO CM 21' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 10/09/2022 11:05:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '2989' AND id_supplier = '' 10/09/2022 11:05:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2989' , '' , '1' ) 10/09/2022 11:05: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 ( '61176' , '3025' , 'CROCE LUCE 25 CM' , '1' , '-1' , '1' , '26.8800' , '22.032786885246' , '22' , '0' , '26.88' ) 10/09/2022 11:05:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '3025' AND id_supplier = '' 10/09/2022 11:05:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3025' , '' , '1' ) 10/09/2022 11:05: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 ( '61176' , '19886' , 'FAMIGLIA SEDUTA 10X10 ARG. - 4241/785' , '1' , '-1' , '1' , '19' , '15.573770491803' , '22' , '0' , '19.00' ) 10/09/2022 11:05:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19886' AND id_supplier = '' 10/09/2022 11:05:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19886' , '' , '1' ) 10/09/2022 11:05: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 ( '61176' , '18251' , 'CLERGY JEANS NIDO DAPE MM - 3XL' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 10/09/2022 11:05:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '18251' AND id_supplier = '' 10/09/2022 11:05:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18251' , '' , '1' ) 10/09/2022 11:05: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 ( '61176' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '7.00' ) 10/09/2022 11:05:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 10/09/2022 11:05:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 10/09/2022 11:28:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2702' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-10') 10/09/2022 11:28: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' , '2702' , '2022-09-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 10/09/2022 11:28: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 = '61756' 10/09/2022 11:28:00 am >> DELETE FROM ps_document_detail WHERE id_document = '61756' 10/09/2022 11:28: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 ( '61756' , '16308' , 'PORTACHIAVI TAU' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 10/09/2022 11:28:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '16308' AND id_supplier = '' 10/09/2022 11:28:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16308' , '' , '1' ) 10/09/2022 12:14:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '2703' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-10') 10/09/2022 12:14:07 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' , '2703' , '2022-09-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 10/09/2022 12:14:07 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 = '61757' 10/09/2022 12:14:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '61757' 10/09/2022 12:14:07 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 ( '61757' , '17602' , 'BRACCIALE SIMIL PELLE BLU - AC120P' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 10/09/2022 12:14:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17602' AND id_supplier = '' 10/09/2022 12:14:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17602' , '' , '1' ) 10/09/2022 12:16:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2704' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-10') 10/09/2022 12:16:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2704' , '2022-09-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 10/09/2022 12:16:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61758' 10/09/2022 12:16:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '61758' 10/09/2022 12:16:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61758' , '18222' , 'ROSARIO COLORATO - R316' , '10' , '-10' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.00' ) 10/09/2022 12:16:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 10/09/2022 12:16:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 10/09/2022 12:28:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2705' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-10') 10/09/2022 12:28:11 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' , '2705' , '2022-09-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 10/09/2022 12:28:11 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 = '61759' 10/09/2022 12:28:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '61759' 10/09/2022 12:28:11 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 ( '61759' , '17875' , 'VITA COME FINE DEL MONDO - L. EPICOCO' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 10/09/2022 12:28:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17875' AND id_supplier = '' 10/09/2022 12:28:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17875' , '' , '1' ) 10/09/2022 12:32:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2706' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-10') 10/09/2022 12:32: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' , '2706' , '2022-09-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '156.18' , '131.11' , NOW() , NOW() ) 10/09/2022 12:32: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 = '61760' 10/09/2022 12:32:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '61760' 10/09/2022 12:32: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 ( '61760' , '9009' , 'RITO DEL BATTESIMO DEI BAMBINI' , '1' , '-1' , '4' , '18.08' , '18.08' , '0' , '5' , '17.18' ) 10/09/2022 12:32:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9009' AND id_supplier = '' 10/09/2022 12:32:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9009' , '' , '1' ) 10/09/2022 12:32: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 ( '61760' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '139.00' , '113.93442622951' , '22' , '0' , '139.00' ) 10/09/2022 12:32:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 10/09/2022 12:32:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' )