09/07/2022 10:12:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 10:12: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' , '2227' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '19.03' , NOW() , NOW() ) 09/07/2022 10:12: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 = '59125' 09/07/2022 10:12:00 am >> DELETE FROM ps_document_detail WHERE id_document = '59125' 09/07/2022 10:12: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 ( '59125' , '8195' , 'GIGLER COMPLETO DORATO - 250 ' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 09/07/2022 10:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '8195' AND id_supplier = '' 09/07/2022 10:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8195' , '' , '1' ) 09/07/2022 10:12: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 ( '59125' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' , '-1' , '1' , '3.20' , '2.6229508196721' , '22' , '0' , '3.20' ) 09/07/2022 10:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '564' AND id_supplier = '' 09/07/2022 10:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '564' , '' , '1' ) 09/07/2022 10:12: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 ( '59125' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 09/07/2022 10:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 09/07/2022 10:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 09/07/2022 10:12: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 ( '59125' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 09/07/2022 10:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '18176' AND id_supplier = '' 09/07/2022 10:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18176' , '' , '1' ) 09/07/2022 10:12: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 ( '59125' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9.9' , '8.1147540983607' , '22' , '0' , '9.90' ) 09/07/2022 10:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 09/07/2022 10:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 09/07/2022 10:34:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2228' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 10:34:20 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' , '2228' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.30' , '37.22' , NOW() , NOW() ) 09/07/2022 10:34:20 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 = '59126' 09/07/2022 10:34:20 am >> DELETE FROM ps_document_detail WHERE id_document = '59126' 09/07/2022 10:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59126' , '12467' , 'TAU PRIMA COMUNIONE' , '24' , '-24' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '38.40' ) 09/07/2022 10:34:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '12467' AND id_supplier = '' 09/07/2022 10:34:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12467' , '' , '1' ) 09/07/2022 10:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59126' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.4' , '3.6065573770492' , '22' , '0' , '4.40' ) 09/07/2022 10:34:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 09/07/2022 10:34:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 09/07/2022 10:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59126' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 09/07/2022 10:34:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 09/07/2022 10:34:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 09/07/2022 10:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59126' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '1' , '0.81967213114754' , '22' , '0' , '2.00' ) 09/07/2022 10:34:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 09/07/2022 10:34:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 09/07/2022 10:34:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2229' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 10:34: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' , '2229' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 09/07/2022 10:34: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 = '59127' 09/07/2022 10:34:30 am >> DELETE FROM ps_document_detail WHERE id_document = '59127' 09/07/2022 10:34: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 ( '59127' , '12659' , 'CAMICE BIANCO - MISTO COT. 140' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 09/07/2022 10:34:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '12659' AND id_supplier = '' 09/07/2022 10:34:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12659' , '' , '1' ) 09/07/2022 10:41:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2230' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 10:41:49 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' , '2230' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 09/07/2022 10:41:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59128' 09/07/2022 10:41:49 am >> DELETE FROM ps_document_detail WHERE id_document = '59128' 09/07/2022 10:41:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59128' , '18760' , 'BRACCIALE ARG -1819' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 09/07/2022 10:41:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '18760' AND id_supplier = '' 09/07/2022 10:41:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18760' , '' , '1' ) 09/07/2022 10:43:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2231' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 10:43:48 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' , '2231' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '10.28' , NOW() , NOW() ) 09/07/2022 10:43:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59129' 09/07/2022 10:43:48 am >> DELETE FROM ps_document_detail WHERE id_document = '59129' 09/07/2022 10:43:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59129' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 09/07/2022 10:43:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 09/07/2022 10:43:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 09/07/2022 10:43:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59129' , '15922' , 'PARTICOLE 3MM - P3M' , '1' , '-1' , '3' , '6.00' , '5.7692307692308' , '4' , '0' , '6.00' ) 09/07/2022 10:43:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '15922' AND id_supplier = '' 09/07/2022 10:43:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15922' , '' , '1' ) 09/07/2022 11:00:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2232' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 11:00:12 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' , '2232' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '179.00' , '146.72' , NOW() , NOW() ) 09/07/2022 11:00:12 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 = '59130' 09/07/2022 11:00:12 am >> DELETE FROM ps_document_detail WHERE id_document = '59130' 09/07/2022 11:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59130' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '15' , '-15' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '18.00' ) 09/07/2022 11:00:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 09/07/2022 11:00:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 09/07/2022 11:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59130' , '15097' , 'CORONA MATRIMONIO - ORO' , '8' , '-8' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '60.00' ) 09/07/2022 11:00:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '' 09/07/2022 11:00:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' ) 09/07/2022 11:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59130' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 09/07/2022 11:00:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 09/07/2022 11:00:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 09/07/2022 11:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59130' , '2652' , 'CONFEZIONE CARTONCINO COMUNIONE - 2331/K126' , '5' , '-5' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '11.00' ) 09/07/2022 11:00:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '2652' AND id_supplier = '' 09/07/2022 11:00:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2652' , '' , '1' ) 09/07/2022 11:05:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2233' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 11:05:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2233' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.35' , '13.17' , NOW() , NOW() ) 09/07/2022 11:05:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59131' 09/07/2022 11:05:26 am >> DELETE FROM ps_document_detail WHERE id_document = '59131' 09/07/2022 11:05:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59131' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 09/07/2022 11:05:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 09/07/2022 11:05:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 09/07/2022 11:05:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59131' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/07/2022 11:05:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 09/07/2022 11:05:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 09/07/2022 11:05:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59131' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/07/2022 11:05:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 09/07/2022 11:05:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 09/07/2022 11:05:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59131' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 09/07/2022 11:05:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 09/07/2022 11:05:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 09/07/2022 11:07:37 am >> DELETE FROM ps_document WHERE id_document = '58489' 09/07/2022 11:07:37 am >> DELETE FROM ps_document_detail WHERE id_document = '58489' 09/07/2022 11:29:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1105' AND id_document != '54718' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-12') 09/07/2022 11:29:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1105', document_date = '2022-04-12', 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 = '198.94', price_tax_excluded = '168.55', date_upd = NOW() WHERE id_document = '54718' 09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '54718' 09/07/2022 11:29:42 am >> DELETE FROM ps_document_detail WHERE id_document = '54718' 09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '18120' , 'COPRILEGGIO AGNELLO ' , '1' , '-1' , '1' , '160.0000' , '131.14754098361' , '22' , '0' , '160.00' ) 09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18120' AND id_supplier = '' 09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18120' , '' , '1' ) 09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '16309' , 'BRACCIALE LEGNO SANTI' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16309' AND id_supplier = '' 09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16309' , '' , '1' ) 09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '19303' , 'NOVENA AI PASTORELLI DI FATIMA - 8070' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19303' AND id_supplier = '' 09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19303' , '' , '1' ) 09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19301' AND id_supplier = '' 09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19301' , '' , '1' ) 09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' , '-1' , '4' , '4.4800' , '4.48' , '0' , '0' , '4.48' ) 09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '14145' AND id_supplier = '' 09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14145' , '' , '1' ) 09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18049' AND id_supplier = '' 09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18049' , '' , '1' ) 09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '14929' AND id_supplier = '' 09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14929' , '' , '1' ) 09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '19184' , 'FARE LA STORIA 1' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19184' AND id_supplier = '' 09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19184' , '' , '1' ) 09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.4300' , '1.43' , '0' , '0' , '1.43' ) 09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '' 09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' ) 09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '14935' , 'GESU E RISORTO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '14935' AND id_supplier = '' 09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14935' , '' , '1' ) 09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '19281' , 'SE IL CHICCO DI GRANO - VIA CRUCIS' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19281' AND id_supplier = '' 09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19281' , '' , '1' ) 09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '18597' AND id_supplier = '' 09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18597' , '' , '1' ) 09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '16309' , 'BRACCIALE LEGNO SANTI' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '16309' AND id_supplier = '' 09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16309' , '' , '1' ) 09/07/2022 11:37:01 am >> SELECT document_num FROM ps_document WHERE document_num = '51/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 11:37:01 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' , '51/A' , '2022-07-09' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , 'p. enzo' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 09/07/2022 11:37:01 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 = '59132' 09/07/2022 11:37:01 am >> DELETE FROM ps_document_detail WHERE id_document = '59132' 09/07/2022 11:37: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 ( '59132' , '8340' , 'PREGHIERE AL PREZIOSISSIMO SANGUE - 8158' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 09/07/2022 11:37: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 ( '59132' , '15816' , 'CHI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 09/07/2022 12:12:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2234' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 12:12: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' , '2234' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '106.75' , NOW() , NOW() ) 09/07/2022 12:12: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 = '59133' 09/07/2022 12:12:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '59133' 09/07/2022 12:12: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 ( '59133' , '12337' , 'LUMINI ART. ECO 2 ROSSO' , '3' , '-3' , '1' , '7.1' , '5.8196721311475' , '22' , '0' , '21.30' ) 09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12337' AND id_supplier = '' 09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12337' , '' , '1' ) 09/07/2022 12:12: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 ( '59133' , '19429' , 'QUADRO DECORATO 35X29 - RC' , '1' , '-1' , '1' , '48.80' , '40' , '22' , '0' , '48.80' ) 09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19429' AND id_supplier = '' 09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19429' , '' , '1' ) 09/07/2022 12:12: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 ( '59133' , '6058' , 'MADONNA DEL CARMINE - 117 BIS ' , '1' , '-1' , '1' , '3.35' , '2.7459016393443' , '22' , '0' , '3.35' ) 09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6058' AND id_supplier = '' 09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6058' , '' , '1' ) 09/07/2022 12:12: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 ( '59133' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19050' AND id_supplier = '' 09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19050' , '' , '1' ) 09/07/2022 12:12: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 ( '59133' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19361' AND id_supplier = '' 09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19361' , '' , '1' ) 09/07/2022 12:12: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 ( '59133' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5643' AND id_supplier = '' 09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5643' , '' , '1' ) 09/07/2022 12:12: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 ( '59133' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5644' AND id_supplier = '' 09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5644' , '' , '1' ) 09/07/2022 12:12: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 ( '59133' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5645' AND id_supplier = '' 09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5645' , '' , '1' ) 09/07/2022 12:15:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2235' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 12:15:13 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' , '2235' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.36' , '10.36' , NOW() , NOW() ) 09/07/2022 12:15:13 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 = '59134' 09/07/2022 12:15:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '59134' 09/07/2022 12:15:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59134' , '15785' , 'IN PREGHIERA CON MARIA - MADRE DECORO CARMELO' , '1' , '-1' , '4' , '10.90' , '10.9' , '0' , '5' , '10.36' ) 09/07/2022 12:15:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15785' AND id_supplier = '' 09/07/2022 12:15:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15785' , '' , '1' ) 09/07/2022 12:19:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2236' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 12:19:58 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' , '2236' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.30' , NOW() , NOW() ) 09/07/2022 12:19: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 = '59135' 09/07/2022 12:19:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '59135' 09/07/2022 12:19: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 ( '59135' , '15334' , 'CANDELA VOTIVA 20X40' , '4' , '-4' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.80' ) 09/07/2022 12:19:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15334' AND id_supplier = '' 09/07/2022 12:19:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15334' , '' , '1' ) 09/07/2022 12:20:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2237' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 12:20:44 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' , '2237' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.50' , '47.50' , NOW() , NOW() ) 09/07/2022 12:20:44 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 = '59136' 09/07/2022 12:20:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '59136' 09/07/2022 12:20:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59136' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '5' , '47.50' ) 09/07/2022 12:20:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 09/07/2022 12:20:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 09/07/2022 12:39:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2238' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 09/07/2022 12:39:40 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' , '2238' , '2022-07-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '13.73' , NOW() , NOW() ) 09/07/2022 12:39:40 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 = '59137' 09/07/2022 12:39:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '59137' 09/07/2022 12:39:40 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 ( '59137' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.70' , '0.7' , '0' , '0' , '7.00' ) 09/07/2022 12:39:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 09/07/2022 12:39:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 09/07/2022 12:39:40 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 ( '59137' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 09/07/2022 12:39:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 09/07/2022 12:39:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )