20/06/2023 09:36:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 09:36:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2112' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/06/2023 09:36: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 = '86420' 20/06/2023 09:36:02 am >> DELETE FROM ps_document_detail WHERE id_document = '86420' 20/06/2023 09:36: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 ( '86420' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/06/2023 09:55:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 09:55:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2113' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 20/06/2023 09:55:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86421' 20/06/2023 09:55:12 am >> DELETE FROM ps_document_detail WHERE id_document = '86421' 20/06/2023 09:55:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86421' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 20/06/2023 10:22:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 10:22: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' , '2114' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 20/06/2023 10:22: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 = '86422' 20/06/2023 10:22:00 am >> DELETE FROM ps_document_detail WHERE id_document = '86422' 20/06/2023 10:22: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 ( '86422' , '20073' , 'ROSARIO CRISTALLO - 01M46' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 20/06/2023 10:22: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 ( '86422' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '3' , '-3' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '37.50' ) 20/06/2023 10:29:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2115' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 10:29:47 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' , '2115' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.40' , '67.53' , NOW() , NOW() ) 20/06/2023 10:29:47 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 = '86423' 20/06/2023 10:29:47 am >> DELETE FROM ps_document_detail WHERE id_document = '86423' 20/06/2023 10:29:47 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 ( '86423' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 20/06/2023 10:29:47 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 ( '86423' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/06/2023 10:29:47 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 ( '86423' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 20/06/2023 10:29:47 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 ( '86423' , '21143' , 'AGGIUNTA CANTI 2023' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '0' , '4.50' ) 20/06/2023 10:30:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2116' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 10:30:51 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' , '2116' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.08' , '7.77' , NOW() , NOW() ) 20/06/2023 10:30:51 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 = '86424' 20/06/2023 10:30:51 am >> DELETE FROM ps_document_detail WHERE id_document = '86424' 20/06/2023 10:30:51 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 ( '86424' , '21142' , 'AGGIUNTA SPARTITI 2023' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '5' , '8.08' ) 20/06/2023 10:32:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2117' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 10:32:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2117' , '2023-06-20' , '' , '0' , '0' , '0' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.40' , '136.84' , NOW() , NOW() ) 20/06/2023 10:32: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 = '86425' 20/06/2023 10:32:30 am >> DELETE FROM ps_document_detail WHERE id_document = '86425' 20/06/2023 10:32: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 ( '86425' , '11384' , 'VINO BIANCO DOLCE - 102' , '5' , '-5' , '1' , '8.5000' , '6.9672' , '22' , '0' , '42.50' ) 20/06/2023 10:32: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 ( '86425' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.00' ) 20/06/2023 10:32: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 ( '86425' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 20/06/2023 10:32: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 ( '86425' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8361' , '22' , '0' , '12.00' ) 20/06/2023 10:32: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 ( '86425' , '0' , 'BUSTE PER PALMA' , '5' , '-5' , '1' , '9.5000' , '7.7869' , '22' , '0' , '47.50' ) 20/06/2023 10:33:53 am >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '81226' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-04') 20/06/2023 10:33:53 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2023-02-04', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = 'acconto € 4,60', 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 = '146.40', price_tax_excluded = '121.26', date_upd = NOW() WHERE id_document = '81226' 20/06/2023 10:33:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81226' 20/06/2023 10:33:53 am >> DELETE FROM ps_document_detail WHERE id_document = '81226' 20/06/2023 10:33: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 ( '81226' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '3' , '-3' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '53.70' ) 20/06/2023 10:33: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 ( '81226' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '2' , '-2' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '2.80' ) 20/06/2023 10:33: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 ( '81226' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/06/2023 10:33: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 ( '81226' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 20/06/2023 10:33: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 ( '81226' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 20/06/2023 10:33: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 ( '81226' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 20/06/2023 11:20:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 11:20:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2118' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '264.10' , '239.53' , NOW() , NOW() ) 20/06/2023 11:20:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86426' 20/06/2023 11:20:56 am >> DELETE FROM ps_document_detail WHERE id_document = '86426' 20/06/2023 11:20:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86426' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '4' , '-4' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '5.60' ) 20/06/2023 11:20:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86426' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '35' , '-35' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '122.50' ) 20/06/2023 11:20:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86426' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 20/06/2023 11:20:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86426' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8' , '6.5573770491803' , '22' , '0' , '96.00' ) 20/06/2023 11:28:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1435' AND id_document != '83039' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 20/06/2023 11:28:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1435', document_date = '2023-04-29', 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 = '151.00', price_tax_excluded = '123.77', date_upd = NOW() WHERE id_document = '83039' 20/06/2023 11:28: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 = '83039' 20/06/2023 11:28:49 am >> DELETE FROM ps_document_detail WHERE id_document = '83039' 20/06/2023 11:28: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 ( '83039' , '11389' , 'VINO ROSSO DOLCE - 103' , '18' , '-18' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '144.00' ) 20/06/2023 11:28: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 ( '83039' , '19104' , 'LUMINELLI A OLIO' , '7' , '-7' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '7.00' ) 20/06/2023 12:19:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '2119' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 12:19:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2119' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '135.57' , NOW() , NOW() ) 20/06/2023 12:19:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86427' 20/06/2023 12:19:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '86427' 20/06/2023 12:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86427' , '19595' , 'POLO JERSEY COTONE 100% - EXTRA' , '2' , '-2' , '1' , '40' , '32.786885245902' , '22' , '0' , '80.00' ) 20/06/2023 12:19:08 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 ( '86427' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55.48' , '45.475409836066' , '22' , '0' , '55.48' ) 20/06/2023 12:19:08 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 ( '86427' , '21115' , 'PAROLA E PREGHIERA - AGO. 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/06/2023 12:19:08 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 ( '86427' , '20998' , 'PAROLA E PREGHIERA - LUG. 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/06/2023 12:19:08 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 ( '86427' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 20/06/2023 12:37:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2120' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 12:37:03 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' , '2120' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 20/06/2023 12:37:03 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 = '86428' 20/06/2023 12:37:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '86428' 20/06/2023 12:37:03 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 ( '86428' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '39.00' ) 20/06/2023 12:37:03 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 ( '86428' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 20/06/2023 12:39:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2117' AND id_document != '86425' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 12:39:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2117', document_date = '2023-06-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '165.40', price_tax_excluded = '136.84', date_upd = NOW() WHERE id_document = '86425' 20/06/2023 12:39:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86425' 20/06/2023 12:39:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '86425' 20/06/2023 12:39:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '11384' , 'VINO BIANCO DOLCE - 102' , '5' , '-5' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '42.50' ) 20/06/2023 12:39:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.00' ) 20/06/2023 12:39:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/06/2023 12:39:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 20/06/2023 12:39:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '47.5' , '38.934426229508' , '22' , '0' , '47.50' ) 20/06/2023 12:57:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2121' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 12:57:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2121' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/06/2023 12:57:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86429' 20/06/2023 12:57:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '86429' 20/06/2023 12:57:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86429' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/06/2023 03:38:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2122' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 03:38:08 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' , '2122' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.90' , '17.90' , NOW() , NOW() ) 20/06/2023 03:38:08 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 = '86430' 20/06/2023 03:38:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '86430' 20/06/2023 03:38:08 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 ( '86430' , '14899' , 'ATTENTO AL LUPO' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 20/06/2023 04:34:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '48/A' AND id_document != '82684' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-05') 20/06/2023 04:34:59 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '48/A', document_date = '2023-04-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 = '393.00', price_tax_excluded = '322.13', date_upd = NOW() WHERE id_document = '82684' 20/06/2023 04:34:59 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 = '82684' 20/06/2023 04:34:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '82684' 20/06/2023 04:34:59 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 ( '82684' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 20/06/2023 04:34:59 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 ( '82684' , '0' , '20/05/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/06/2023 04:34:59 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 ( '82684' , '0' , 'ROSA' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 20/06/2023 04:34:59 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 ( '82684' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '4' , '-4' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '8.00' ) 20/06/2023 04:36:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2123' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 04:36:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2123' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '56.19' , NOW() , NOW() ) 20/06/2023 04:36:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86431' 20/06/2023 04:36:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '86431' 20/06/2023 04:36:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86431' , '15768' , 'RICAMBIO PER TORCIA ORO DIAM. 5 - 35' , '1' , '-1' , '1' , '41' , '33.606557377049' , '22' , '0' , '41.00' ) 20/06/2023 04:36:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86431' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 20/06/2023 04:36:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86431' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 20/06/2023 04:36:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86431' , '12686' , 'SAN LUIGI GONZAGA - 76' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 20/06/2023 05:06:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2124' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 05:06:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2124' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 20/06/2023 05:06:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86432' 20/06/2023 05:06:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '86432' 20/06/2023 05:06:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86432' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 20/06/2023 05:25:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2125' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 05:25:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2125' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/06/2023 05:25:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86433' 20/06/2023 05:25:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '86433' 20/06/2023 05:25:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86433' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/06/2023 06:37:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2126' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 06:37:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2126' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 20/06/2023 06:37:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86434' 20/06/2023 06:37:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '86434' 20/06/2023 06:37:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86434' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 20/06/2023 07:48:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1941' AND id_document != '85692' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-05') 20/06/2023 07:48:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1941', document_date = '2023-06-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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '85692' 20/06/2023 07:48:59 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 = '85692' 20/06/2023 07:48:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '85692' 20/06/2023 07:48:59 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 ( '85692' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 20/06/2023 07:48:59 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 ( '85692' , '20185' , 'ANGELO SU CONCHIGLIA CM 13 - AR113' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 20/06/2023 07:55:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2127' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 20/06/2023 07:55:22 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' , '2127' , '2023-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.80' , '26.00' , NOW() , NOW() ) 20/06/2023 07:55:22 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 = '86435' 20/06/2023 07:55:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '86435' 20/06/2023 07:55:22 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 ( '86435' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 20/06/2023 07:55:22 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 ( '86435' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '4.50' ) 20/06/2023 07:55:22 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 ( '86435' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '' , '4.00' ) 20/06/2023 07:55:22 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 ( '86435' , '12255' , 'IN CAMMINO CON GESU' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '' , '3.80' ) 20/06/2023 07:55:22 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 ( '86435' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' )