12/08/2022 09:04:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2511' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 09:04:24 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' , '2511' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 12/08/2022 09:04:24 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 = '59993' 12/08/2022 09:04:24 am >> DELETE FROM ps_document_detail WHERE id_document = '59993' 12/08/2022 09:04:24 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 ( '59993' , '7202' , 'ARTICOLI RELIGIOSI' , '20' , '-20' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '24.00' ) 12/08/2022 09:04:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/08/2022 09:04:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/08/2022 09:48:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2512' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 09:48:14 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' , '2512' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.70' , '91.72' , NOW() , NOW() ) 12/08/2022 09:48:14 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 = '59994' 12/08/2022 09:48:14 am >> DELETE FROM ps_document_detail WHERE id_document = '59994' 12/08/2022 09:48:14 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 ( '59994' , '6008' , 'LUMINELLI AD OLIO - 1021C' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 12/08/2022 09:48:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '6008' AND id_supplier = '' 12/08/2022 09:48:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6008' , '' , '1' ) 12/08/2022 09:48:14 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 ( '59994' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 12/08/2022 09:48:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 12/08/2022 09:48:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 12/08/2022 09:48:15 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 ( '59994' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 12/08/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 12/08/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 12/08/2022 09:48:15 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 ( '59994' , '1929' , 'CERCHIETTO CON FIORI LUSSO' , '8' , '-8' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '76.00' ) 12/08/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '1929' AND id_supplier = '' 12/08/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1929' , '' , '1' ) 12/08/2022 09:48:15 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 ( '59994' , '7202' , 'ARTICOLI RELIGIOSI' , '15' , '-15' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '18.00' ) 12/08/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/08/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/08/2022 10:20:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2513' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 10:20:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2513' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 12/08/2022 10:20:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59995' 12/08/2022 10:20:07 am >> DELETE FROM ps_document_detail WHERE id_document = '59995' 12/08/2022 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59995' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 12/08/2022 10:20:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 12/08/2022 10:20:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 12/08/2022 10:21:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2514' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 10:21: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' , '2514' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 12/08/2022 10:21: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 = '59996' 12/08/2022 10:21:00 am >> DELETE FROM ps_document_detail WHERE id_document = '59996' 12/08/2022 10:21: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 ( '59996' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 12/08/2022 10:21:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '' 12/08/2022 10:21:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '' , '1' ) 12/08/2022 10:22:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2515' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 10:22:17 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' , '2515' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 12/08/2022 10:22:17 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 = '59997' 12/08/2022 10:22:17 am >> DELETE FROM ps_document_detail WHERE id_document = '59997' 12/08/2022 10:22:17 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 ( '59997' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 12/08/2022 10:22:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16060' AND id_supplier = '' 12/08/2022 10:22:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16060' , '' , '1' ) 12/08/2022 10:23:18 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 12/08/2022 10:23:18 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', 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 = '351.10', price_tax_excluded = '291.35', date_upd = NOW() WHERE id_document = '59768' 12/08/2022 10:23:18 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 = '59768' 12/08/2022 10:23:18 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 12/08/2022 10:23:18 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 ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 12/08/2022 10:23:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 12/08/2022 10:23:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 12/08/2022 10:23:18 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 ( '59768' , '15774' , 'INCENSO NARJAN - 500G' , '1' , '-1' , '1' , '26.0000' , '21.311475409836' , '22' , '0' , '26.00' ) 12/08/2022 10:23:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = '' 12/08/2022 10:23:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' ) 12/08/2022 10:23:19 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 ( '59768' , '0' , '23/07/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 12/08/2022 10:23:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 12/08/2022 10:23:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 12/08/2022 10:23:19 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 ( '59768' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 12/08/2022 10:23:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 12/08/2022 10:23:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 12/08/2022 10:23:19 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 ( '59768' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 12/08/2022 10:23:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 12/08/2022 10:23:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 12/08/2022 10:23:19 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 ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/08/2022 10:23:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 12/08/2022 10:23:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 12/08/2022 10:23:19 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 ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 12/08/2022 10:23:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 12/08/2022 10:23:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 12/08/2022 10:25:32 am >> 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') 12/08/2022 10:25:32 am >> 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 850,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 = '2872.60', price_tax_excluded = '2354.59', date_upd = NOW() WHERE id_document = '56617' 12/08/2022 10:25: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 = '56617' 12/08/2022 10:25:32 am >> DELETE FROM ps_document_detail WHERE id_document = '56617' 12/08/2022 10:25: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 ( '56617' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '875.0000' , '717.2131147541' , '22' , '0' , '875.00' ) 12/08/2022 10:25:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 12/08/2022 10:25:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 12/08/2022 10:25: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 12/08/2022 10:25:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 12/08/2022 10:25:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 12/08/2022 10:25: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 ( '56617' , '19594' , 'POLO JERSEY COTONE 100%' , '4' , '-4' , '1' , '36.9000' , '30.245901639344' , '22' , '0' , '147.60' ) 12/08/2022 10:25:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 12/08/2022 10:25:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 12/08/2022 10:26:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2516' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 10:26:31 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' , '2516' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.60' , '5.41' , NOW() , NOW() ) 12/08/2022 10:26:31 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 = '59998' 12/08/2022 10:26:31 am >> DELETE FROM ps_document_detail WHERE id_document = '59998' 12/08/2022 10:26:31 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 ( '59998' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '6.60' ) 12/08/2022 10:26:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 12/08/2022 10:26:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 12/08/2022 10:28:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2517' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 10:28:15 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' , '2517' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 12/08/2022 10:28:15 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 = '59999' 12/08/2022 10:28:15 am >> DELETE FROM ps_document_detail WHERE id_document = '59999' 12/08/2022 10:28:15 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 ( '59999' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 12/08/2022 10:28:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/08/2022 10:28:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/08/2022 10:31:38 am >> 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') 12/08/2022 10:31:38 am >> 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 875,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 = '2872.60', price_tax_excluded = '2354.59', date_upd = NOW() WHERE id_document = '56617' 12/08/2022 10:31:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56617' 12/08/2022 10:31:38 am >> DELETE FROM ps_document_detail WHERE id_document = '56617' 12/08/2022 10:31:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '875.0000' , '717.2131147541' , '22' , '0' , '875.00' ) 12/08/2022 10:31:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 12/08/2022 10:31:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 12/08/2022 10:31:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 12/08/2022 10:31:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 12/08/2022 10:31:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 12/08/2022 10:31:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '19594' , 'POLO JERSEY COTONE 100%' , '4' , '-4' , '1' , '36.9000' , '30.245901639344' , '22' , '0' , '147.60' ) 12/08/2022 10:31:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 12/08/2022 10:31:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 12/08/2022 10:32:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2518' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 10:32:29 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' , '2518' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '285.00' , '233.61' , NOW() , NOW() ) 12/08/2022 10:32:29 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 = '60000' 12/08/2022 10:32:29 am >> DELETE FROM ps_document_detail WHERE id_document = '60000' 12/08/2022 10:32:29 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 ( '60000' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '285' , '233.60655737705' , '22' , '0' , '285.00' ) 12/08/2022 10:32:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/08/2022 10:32:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/08/2022 10:48:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2519' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 10:48:11 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' , '2519' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '410.20' , '343.35' , NOW() , NOW() ) 12/08/2022 10:48:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60001' 12/08/2022 10:48:11 am >> DELETE FROM ps_document_detail WHERE id_document = '60001' 12/08/2022 10:48:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60001' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' , '90.00' , '73.770491803279' , '22' , '0' , '90.00' ) 12/08/2022 10:48:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '15356' AND id_supplier = '' 12/08/2022 10:48:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15356' , '' , '1' ) 12/08/2022 10:48:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60001' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 12/08/2022 10:48:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 12/08/2022 10:48:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 12/08/2022 10:48:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60001' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '15.20' ) 12/08/2022 10:48:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 12/08/2022 10:48:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 12/08/2022 10:48:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60001' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 12/08/2022 10:48:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 12/08/2022 10:48:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 12/08/2022 10:55:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2520' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 10:55: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' , '2520' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.50' , '42.79' , NOW() , NOW() ) 12/08/2022 10:55: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 = '60002' 12/08/2022 10:55:26 am >> DELETE FROM ps_document_detail WHERE id_document = '60002' 12/08/2022 10:55: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 ( '60002' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 12/08/2022 10:55:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 12/08/2022 10:55:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 12/08/2022 10:55: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 ( '60002' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 12/08/2022 10:55:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 12/08/2022 10:55:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 12/08/2022 11:10:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2521' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 11:10:31 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' , '2521' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '62.30' , NOW() , NOW() ) 12/08/2022 11:10:31 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 = '60003' 12/08/2022 11:10:31 am >> DELETE FROM ps_document_detail WHERE id_document = '60003' 12/08/2022 11:10:31 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 ( '60003' , '14606' , 'CLERGY CELESTE ML - COTONE - 46' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 12/08/2022 11:10:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '14606' AND id_supplier = '' 12/08/2022 11:10:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14606' , '' , '1' ) 12/08/2022 11:10:31 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 ( '60003' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 12/08/2022 11:10:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 12/08/2022 11:10:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 12/08/2022 11:12:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2522' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 11: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' , '2522' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '20.00' , NOW() , NOW() ) 12/08/2022 11: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 = '60004' 12/08/2022 11:12:00 am >> DELETE FROM ps_document_detail WHERE id_document = '60004' 12/08/2022 11: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 ( '60004' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '20' , '20' , '0' , '0' , '20.00' ) 12/08/2022 11:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 12/08/2022 11:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 12/08/2022 11:18:15 am >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 11:18:15 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' , '22' , '2022-08-12' , '' , '3213' , '0' , '4669539' , 'VIA MONTICELLI DI SOTTO 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '12.47' , NOW() , NOW() ) 12/08/2022 11:18:15 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 = '60005' 12/08/2022 11:18:15 am >> DELETE FROM ps_document_detail WHERE id_document = '60005' 12/08/2022 11:18:15 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 ( '60005' , '14129' , 'SANTO STEFANO PROTO MARTIRE - 57' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 12/08/2022 11:18:15 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 ( '60005' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 12/08/2022 11:23:02 am >> 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') 12/08/2022 11:23:02 am >> 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 = '', 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 = '1850.00', price_tax_excluded = '1516.39', date_upd = NOW() WHERE id_document = '56617' 12/08/2022 11:23: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 = '56617' 12/08/2022 11:23:02 am >> DELETE FROM ps_document_detail WHERE id_document = '56617' 12/08/2022 11:23: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 12/08/2022 11:23:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 12/08/2022 11:23:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 12/08/2022 11:28:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2052' AND id_document != '58910' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 12/08/2022 11:28:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2052', document_date = '2022-06-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 = '1150.00', price_tax_excluded = '942.62', date_upd = NOW() WHERE id_document = '58910' 12/08/2022 11:28: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 = '58910' 12/08/2022 11:28:01 am >> DELETE FROM ps_document_detail WHERE id_document = '58910' 12/08/2022 11:28: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 ( '58910' , '19346' , 'CASULA MARIANA LANA LUREX - 65/002005-M' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 12/08/2022 11:28:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19346' AND id_supplier = '' 12/08/2022 11:28:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19346' , '' , '1' ) 12/08/2022 11:28: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 ( '58910' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '850' , '696.72131147541' , '22' , '0' , '850.00' ) 12/08/2022 11:28:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 12/08/2022 11:28:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 12/08/2022 11:32:18 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 12/08/2022 11:32:18 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', 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 = '270.00', price_tax_excluded = '221.31', date_upd = NOW() WHERE id_document = '59768' 12/08/2022 11:32:18 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 = '59768' 12/08/2022 11:32:18 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 12/08/2022 11:32:19 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 ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 12/08/2022 11:32:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 12/08/2022 11:32:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 12/08/2022 11:35:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'OGGETTI' AND id_product != '7202' AND ean13 != '' 12/08/2022 11:35:22 am >> UPDATE ps_product SET id_supplier = '20', reference = '', ean13 = 'OGGETTI', date_upd = NOW() WHERE id_product = '7202' 12/08/2022 11:35:22 am >> UPDATE ps_product_lang SET name = 'ARTICOLI RELIGIOSI', description = '' WHERE id_product = '7202' 12/08/2022 11:35:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '7202' 12/08/2022 11:35:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7202' 12/08/2022 11:35:22 am >> DELETE FROM ps_specific_price WHERE id_product = '7202' 12/08/2022 11:36:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1979' AND id_document != '58829' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-18') 12/08/2022 11:36:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1979', document_date = '2022-06-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '58.30', price_tax_excluded = '47.79', date_upd = NOW() WHERE id_document = '58829' 12/08/2022 11:36: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 = '58829' 12/08/2022 11:36:00 am >> DELETE FROM ps_document_detail WHERE id_document = '58829' 12/08/2022 11:36: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 ( '58829' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '15' , '32.30' ) 12/08/2022 11:36:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '12818' AND id_supplier = '' 12/08/2022 11:36:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12818' , '' , '1' ) 12/08/2022 11:36: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 ( '58829' , '15774' , 'INCENSO NARJAN - 500G' , '1' , '-1' , '1' , '26.00' , '21.311475409836' , '22' , '0' , '26.00' ) 12/08/2022 11:36:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = '' 12/08/2022 11:36:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' ) 12/08/2022 11:36:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1680' AND id_document != '58477' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 12/08/2022 11:36:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1680', 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 = '29.50', price_tax_excluded = '24.18', date_upd = NOW() WHERE id_document = '58477' 12/08/2022 11:36:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58477' 12/08/2022 11:36:45 am >> DELETE FROM ps_document_detail WHERE id_document = '58477' 12/08/2022 11:36:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58477' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 12/08/2022 11:36:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 12/08/2022 11:36:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 12/08/2022 11:36:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58477' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '9.50' ) 12/08/2022 11:36:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 12/08/2022 11:36:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 12/08/2022 11:37:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2511' AND id_document != '59993' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 11:37:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2511', document_date = '2022-08-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 = '24.00', price_tax_excluded = '19.67', date_upd = NOW() WHERE id_document = '59993' 12/08/2022 11:37: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 = '59993' 12/08/2022 11:37:32 am >> DELETE FROM ps_document_detail WHERE id_document = '59993' 12/08/2022 11:37: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 ( '59993' , '19857' , 'CINGOLO COL/ORO - CING 21' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 12/08/2022 11:37:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19857' AND id_supplier = '' 12/08/2022 11:37:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19857' , '' , '1' ) 12/08/2022 11:38:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1206' AND id_document != '55346' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-22') 12/08/2022 11:38:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1206', document_date = '2022-04-22', 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 = '230.00', price_tax_excluded = '188.52', date_upd = NOW() WHERE id_document = '55346' 12/08/2022 11:38: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 = '55346' 12/08/2022 11:38:26 am >> DELETE FROM ps_document_detail WHERE id_document = '55346' 12/08/2022 11:38:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55346' , '12127' , 'MERLETTO IN COTONE' , '18' , '-18' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '144.00' ) 12/08/2022 11:38:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '12127' AND id_supplier = '' 12/08/2022 11:38:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12127' , '' , '1' ) 12/08/2022 11:38:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55346' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 12/08/2022 11:38:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/08/2022 11:38:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/08/2022 11:38:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55346' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '78.00' , '63.934426229508' , '22' , '0' , '78.00' ) 12/08/2022 11:38:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '14920' AND id_supplier = '' 12/08/2022 11:38:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14920' , '' , '1' ) 12/08/2022 11:40:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1410' AND id_document != '56609' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 12/08/2022 11:40:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1410', document_date = '2022-05-05', 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 = '52.50', price_tax_excluded = '43.03', date_upd = NOW() WHERE id_document = '56609' 12/08/2022 11:40: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 = '56609' 12/08/2022 11:40:32 am >> DELETE FROM ps_document_detail WHERE id_document = '56609' 12/08/2022 11:40: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 ( '56609' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '15' , '-15' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '15.00' ) 12/08/2022 11:40:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 12/08/2022 11:40:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 12/08/2022 11:40: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 ( '56609' , '18243' , 'CLERGY GRIGIO NIDO DAPE MM - M' , '1' , '-1' , '1' , '37.5' , '30.737704918033' , '22' , '0' , '37.50' ) 12/08/2022 11:40:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '18243' AND id_supplier = '' 12/08/2022 11:40:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18243' , '' , '1' ) 12/08/2022 11:41:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1235' AND id_document != '55891' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23') 12/08/2022 11:41:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1235', document_date = '2022-04-23', 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 = '500.00', price_tax_excluded = '409.84', date_upd = NOW() WHERE id_document = '55891' 12/08/2022 11: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 = '55891' 12/08/2022 11:41:49 am >> DELETE FROM ps_document_detail WHERE id_document = '55891' 12/08/2022 11: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 ( '55891' , '17404' , 'CASULA RIGATA' , '1' , '-1' , '1' , '270.0000' , '221.31147540984' , '22' , '0' , '270.00' ) 12/08/2022 11:41:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '17404' AND id_supplier = '' 12/08/2022 11:41:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17404' , '' , '1' ) 12/08/2022 11: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 ( '55891' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '15.9000' , '13.032786885246' , '22' , '0' , '31.80' ) 12/08/2022 11:41:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19147' AND id_supplier = '' 12/08/2022 11:41:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19147' , '' , '1' ) 12/08/2022 11: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 ( '55891' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 12/08/2022 11:41:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 12/08/2022 11:41:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 12/08/2022 11: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 ( '55891' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 12/08/2022 11:41:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 12/08/2022 11:41:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 12/08/2022 11: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 ( '55891' , '794' , 'ASTUCCIO 3 BOTTIGLIE CC125 - 964' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 12/08/2022 11:41:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '794' AND id_supplier = '' 12/08/2022 11:41:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '794' , '' , '1' ) 12/08/2022 11: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 ( '55891' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10.7' , '8.7704918032787' , '22' , '0' , '10.70' ) 12/08/2022 11:41:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/08/2022 11:41:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/08/2022 11: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 ( '55891' , '18247' , 'CLERGY JEANS NIDO DAPE MM - M' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 12/08/2022 11:41:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '18247' AND id_supplier = '' 12/08/2022 11:41:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18247' , '' , '1' ) 12/08/2022 11:42:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1585' AND id_document != '57846' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 12/08/2022 11:42:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1585', document_date = '2022-05-19', 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 = '102.00', price_tax_excluded = '83.61', date_upd = NOW() WHERE id_document = '57846' 12/08/2022 11:42:19 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 = '57846' 12/08/2022 11:42:19 am >> DELETE FROM ps_document_detail WHERE id_document = '57846' 12/08/2022 11:42:19 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 ( '57846' , '8106' , 'POLO CELESTE - XL' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 12/08/2022 11:42:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '8106' AND id_supplier = '' 12/08/2022 11:42:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8106' , '' , '1' ) 12/08/2022 11:42:19 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 ( '57846' , '18252' , 'CLERGY BLU NIDO DAPE MM - M' , '1' , '-1' , '1' , '33' , '27.049180327869' , '22' , '0' , '33.00' ) 12/08/2022 11:42:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '18252' AND id_supplier = '' 12/08/2022 11:42:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18252' , '' , '1' ) 12/08/2022 11:42:19 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 ( '57846' , '18244' , 'CLERGY GRIGIO NIDO DAPE MM - XXL' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 12/08/2022 11:42:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '18244' AND id_supplier = '' 12/08/2022 11:42:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18244' , '' , '1' ) 12/08/2022 11:43:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1451' AND id_document != '56660' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-07') 12/08/2022 11:43:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1451', document_date = '2022-05-07', 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 = '49.18', date_upd = NOW() WHERE id_document = '56660' 12/08/2022 11:43:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56660' 12/08/2022 11:43:11 am >> DELETE FROM ps_document_detail WHERE id_document = '56660' 12/08/2022 11:43:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56660' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' , '30' , '24.590163934426' , '22' , '0' , '60.00' ) 12/08/2022 11:43:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 12/08/2022 11:43:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 12/08/2022 11:43:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1514' AND id_document != '57252' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-13') 12/08/2022 11:43:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1514', document_date = '2022-05-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 83029 SOLOFRA', 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 = '170.00', price_tax_excluded = '139.34', date_upd = NOW() WHERE id_document = '57252' 12/08/2022 11:43: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 = '57252' 12/08/2022 11:43:32 am >> DELETE FROM ps_document_detail WHERE id_document = '57252' 12/08/2022 11:43: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 ( '57252' , '15921' , 'SERVIZIO MESSA LINO 100% - 74301' , '1' , '-1' , '1' , '115.0000' , '94.262295081967' , '22' , '0' , '115.00' ) 12/08/2022 11:43:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '15921' AND id_supplier = '' 12/08/2022 11:43:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15921' , '' , '1' ) 12/08/2022 11:43: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 ( '57252' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 12/08/2022 11:43:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/08/2022 11:43:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/08/2022 11:43: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 ( '57252' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 12/08/2022 11:43:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 12/08/2022 11:43:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 12/08/2022 11:44:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1604' AND id_document != '57867' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 12/08/2022 11:44:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1604', document_date = '2022-05-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '57867' 12/08/2022 11:44:04 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 = '57867' 12/08/2022 11:44:04 am >> DELETE FROM ps_document_detail WHERE id_document = '57867' 12/08/2022 11:44:04 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 ( '57867' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 12/08/2022 11:44:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 12/08/2022 11:44:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 12/08/2022 11:44:04 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 ( '57867' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/08/2022 11:44:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/08/2022 11:44:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/08/2022 11:44:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1632' AND id_document != '57899' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-23') 12/08/2022 11:44:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1632', document_date = '2022-05-23', 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 = '72.80', price_tax_excluded = '59.67', date_upd = NOW() WHERE id_document = '57899' 12/08/2022 11:44: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 = '57899' 12/08/2022 11:44:30 am >> DELETE FROM ps_document_detail WHERE id_document = '57899' 12/08/2022 11:44: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 ( '57899' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '31.2' , '25.573770491803' , '22' , '0' , '31.20' ) 12/08/2022 11:44:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 12/08/2022 11:44:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 12/08/2022 11:44: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 ( '57899' , '14775' , 'SIMBOLI CRISTOLOGICI CON LACCIO ' , '32' , '-32' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '41.60' ) 12/08/2022 11:44:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '14775' AND id_supplier = '' 12/08/2022 11:44:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14775' , '' , '1' ) 12/08/2022 11:45:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1206' AND id_document != '55346' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-22') 12/08/2022 11:45:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1206', document_date = '2022-04-22', 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 = '230.00', price_tax_excluded = '188.52', date_upd = NOW() WHERE id_document = '55346' 12/08/2022 11:45: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 = '55346' 12/08/2022 11:45:49 am >> DELETE FROM ps_document_detail WHERE id_document = '55346' 12/08/2022 11:45: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 ( '55346' , '12127' , 'MERLETTO IN COTONE' , '18' , '-18' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '144.00' ) 12/08/2022 11:45:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '12127' AND id_supplier = '' 12/08/2022 11:45:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12127' , '' , '1' ) 12/08/2022 11:45: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 ( '55346' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 12/08/2022 11:45:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 12/08/2022 11:45:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 12/08/2022 11:45: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 ( '55346' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '78.0000' , '63.934426229508' , '22' , '0' , '78.00' ) 12/08/2022 11:45:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '14920' AND id_supplier = '' 12/08/2022 11:45:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14920' , '' , '1' ) 12/08/2022 11:45: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 ( '55346' , '792' , 'ASSUNZIONE - 178' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 12/08/2022 11:45:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '792' AND id_supplier = '' 12/08/2022 11:45:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '792' , '' , '1' ) 12/08/2022 11:47:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2228' AND id_document != '59126' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 12/08/2022 11:47:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2228', document_date = '2022-07-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.30', price_tax_excluded = '37.22', date_upd = NOW() WHERE id_document = '59126' 12/08/2022 11:47:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59126' 12/08/2022 11:47:27 am >> DELETE FROM ps_document_detail WHERE id_document = '59126' 12/08/2022 11:47:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59126' , '12467' , 'TAU PRIMA COMUNIONE' , '24' , '-24' , '1' , '1.6000' , '1.3114754098361' , '22' , '0' , '38.40' ) 12/08/2022 11:47:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '12467' AND id_supplier = '' 12/08/2022 11:47:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12467' , '' , '1' ) 12/08/2022 11:47:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59126' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 12/08/2022 11:47:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 12/08/2022 11:47:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 12/08/2022 11:47:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59126' , '13313' , 'MARIA CHE SCIOGLIE I NODI - 401' , '2' , '-2' , '1' , '3.2' , '2.6229508196721' , '22' , '0' , '6.40' ) 12/08/2022 11:47:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '13313' AND id_supplier = '' 12/08/2022 11:47:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13313' , '' , '1' ) 12/08/2022 11:50:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2523' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 11:50: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' , '2523' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '16.76' , NOW() , NOW() ) 12/08/2022 11:50: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 = '60006' 12/08/2022 11:50:52 am >> DELETE FROM ps_document_detail WHERE id_document = '60006' 12/08/2022 11:50: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 ( '60006' , '18222' , 'ROSARIO COLORATO - R316' , '20' , '-20' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.00' ) 12/08/2022 11:50:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 12/08/2022 11:50:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 12/08/2022 11:50: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 ( '60006' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 12/08/2022 11:50:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 12/08/2022 11:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 12/08/2022 11:50: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 ( '60006' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 12/08/2022 11:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 12/08/2022 11:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 12/08/2022 11:52:19 am >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '59992' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-11') 12/08/2022 11:52:19 am >> UPDATE ps_document SET id_document_type = '21', document_num = '107', document_date = '2022-08-11', document_letter = '', id_customer = '618', id_supplier = '', id_address = '4671023', address1 = 'S. ANGELO 84085 MERCATO S. SEVERINO', address2 = '', note = 'COPIE OMAGGIO AUTORE', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '59992' 12/08/2022 11:52:19 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 = '59992' 12/08/2022 11:52:19 am >> DELETE FROM ps_document_detail WHERE id_document = '59992' 12/08/2022 11:52:19 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 ( '59992' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '92' , '-92' , '4' , '35.0000' , '35' , '0' , '100' , '0.00' ) 12/08/2022 11:52:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 12/08/2022 11:52:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 12/08/2022 11:57:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2517' AND id_document != '59999' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 11:57:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2517', document_date = '2022-08-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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '59999' 12/08/2022 11:57:21 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 = '59999' 12/08/2022 11:57:21 am >> DELETE FROM ps_document_detail WHERE id_document = '59999' 12/08/2022 11:57:21 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 ( '59999' , '13533' , 'S. ANTONIO CM 20 - SAT/20E' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 12/08/2022 11:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '13533' AND id_supplier = '' 12/08/2022 11:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13533' , '' , '1' ) 12/08/2022 12:12:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2524' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 12:12:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2524' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.40' , '50.64' , NOW() , NOW() ) 12/08/2022 12:12:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60007' 12/08/2022 12:12:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '60007' 12/08/2022 12:12:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60007' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '25' , '-25' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '37.50' ) 12/08/2022 12:12:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13392' AND id_supplier = '' 12/08/2022 12:12:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13392' , '' , '1' ) 12/08/2022 12:12:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60007' , '8384' , 'PREGHIERE PER LA CORONA DEL DISCEPOLO A 33 GRANI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 12/08/2022 12:12:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8384' AND id_supplier = '' 12/08/2022 12:12:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8384' , '' , '1' ) 12/08/2022 12:12:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60007' , '8333' , 'PREGHIERE A SAN GIUDA TADDEO APOSTOLO - 8159' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 12/08/2022 12:12:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8333' AND id_supplier = '' 12/08/2022 12:12:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8333' , '' , '1' ) 12/08/2022 12:12:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60007' , '5411' , 'INVITO ALLAMORE - 8251' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 12/08/2022 12:12:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5411' AND id_supplier = '' 12/08/2022 12:12:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5411' , '' , '1' ) 12/08/2022 12:21:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2525' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 12:21:14 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' , '2525' , '2022-08-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 12/08/2022 12:21:14 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 = '60008' 12/08/2022 12:21:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '60008' 12/08/2022 12:21:14 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 ( '60008' , '19750' , 'INCENSO LUCAS' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 12/08/2022 12:21:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19750' AND id_supplier = '' 12/08/2022 12:21:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19750' , '' , '1' ) 12/08/2022 12:50:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '60005' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-08-12') 12/08/2022 12:50:26 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2022-08-12', document_letter = 'A', id_customer = '3213', id_supplier = '', id_address = '4669539', address1 = 'VIA MONTICELLI DI SOTTO 84085 MERCATO SAN SEVERINO', 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 = '14.00', price_tax_excluded = '12.47', date_upd = NOW() WHERE id_document = '60005' 12/08/2022 12:50:26 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 = '60005' 12/08/2022 12:50:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '60005' 12/08/2022 12:50:26 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 ( '60005' , '14129' , 'SANTO STEFANO PROTO MARTIRE - 57' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 12/08/2022 12:50:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14129' AND id_supplier = '' 12/08/2022 12:50:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14129' , '' , '1' ) 12/08/2022 12:50:26 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 ( '60005' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 12/08/2022 12:50:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 12/08/2022 12:50:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' )