10/06/2024 08:42:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1562' AND id_document != '91771' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-13') 10/06/2024 08:42:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1562', document_date = '2024-05-13', 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 = '16.50', price_tax_excluded = '13.52', date_upd = NOW() WHERE id_document = '91771' 10/06/2024 08:42:05 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 = '91771' 10/06/2024 08:42:05 am >> DELETE FROM ps_document_detail WHERE id_document = '91771' 10/06/2024 08:42:06 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 ( '91771' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.25' , '2.6639344262295' , '22' , '0' , '6.50' ) 10/06/2024 08:42:06 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 ( '91771' , '3095' , 'CROCE SACERDOTALE METALLO COLOR ARGENTO - OGGETTI' , '10' , '-10' , '1' , '1' , '0.81967213114754' , '22' , '0' , '10.00' ) 10/06/2024 10:10:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1932' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 10:10:28 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' , '1932' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 10/06/2024 10:10:28 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 = '92230' 10/06/2024 10:10:28 am >> DELETE FROM ps_document_detail WHERE id_document = '92230' 10/06/2024 10:10:28 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 ( '92230' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 10/06/2024 10:22:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1933' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 10:22: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' , '1933' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '152.00' , '124.59' , NOW() , NOW() ) 10/06/2024 10:22: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 = '92231' 10/06/2024 10:22:31 am >> DELETE FROM ps_document_detail WHERE id_document = '92231' 10/06/2024 10:22: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 ( '92231' , '20026' , 'CANDELA VOTIVA 20X40' , '20' , '-20' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '12.00' ) 10/06/2024 10:22: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 ( '92231' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '140.00' ) 10/06/2024 10:37:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1934' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 10:37:21 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' , '1934' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 10/06/2024 10:37: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 = '92232' 10/06/2024 10:37:21 am >> DELETE FROM ps_document_detail WHERE id_document = '92232' 10/06/2024 10:37: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 ( '92232' , '18840' , 'CAPOCULLA ' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 10/06/2024 11:03:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1935' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 11:03:37 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' , '1935' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.07' , NOW() , NOW() ) 10/06/2024 11:03:37 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 = '92233' 10/06/2024 11:03:37 am >> DELETE FROM ps_document_detail WHERE id_document = '92233' 10/06/2024 11:03:37 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 ( '92233' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/06/2024 11:10:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1936' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 11:10: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' , '1936' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 10/06/2024 11:10: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 = '92234' 10/06/2024 11:10:14 am >> DELETE FROM ps_document_detail WHERE id_document = '92234' 10/06/2024 11:10: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 ( '92234' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/06/2024 11:40:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1937' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 11:40:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1937' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 10/06/2024 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 = '92235' 10/06/2024 11:40:32 am >> DELETE FROM ps_document_detail WHERE id_document = '92235' 10/06/2024 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 ( '92235' , '7202' , 'ARTICOLI RELIGIOSI' , '5' , '-5' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '14.00' ) 10/06/2024 11:48:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1938' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 11:48: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' , '1938' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 10/06/2024 11:48: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 = '92236' 10/06/2024 11:48:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92236' 10/06/2024 11:48: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 ( '92236' , '19595' , 'POLO JERSEY COTONE 100% - EXTRA' , '2' , '-2' , '1' , '40' , '32.786885245902' , '22' , '0' , '80.00' ) 10/06/2024 12:13:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1939' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 12:13:55 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' , '1939' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 10/06/2024 12:13:55 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 = '92237' 10/06/2024 12:13:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '92237' 10/06/2024 12:13:55 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 ( '92237' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 10/06/2024 12:13:55 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 ( '92237' , '16535' , 'CLERGY MARANGEL ML - C20' , '1' , '-1' , '1' , '47' , '38.524590163934' , '22' , '0' , '47.00' ) 10/06/2024 12:13:55 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 ( '92237' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '34' , '27.868852459016' , '22' , '0' , '34.00' ) 10/06/2024 02:00:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1935' AND id_document != '92233' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 02:00:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1935', document_date = '2024-06-10', 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 = '1.30', price_tax_excluded = '1.07', date_upd = NOW() WHERE id_document = '92233' 10/06/2024 02:00:52 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 = '92233' 10/06/2024 02:00:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '92233' 10/06/2024 02:00:52 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 ( '92233' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/06/2024 02:01:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1933' AND id_document != '92231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 02:01:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1933', document_date = '2024-06-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '152.00', price_tax_excluded = '124.59', date_upd = NOW() WHERE id_document = '92231' 10/06/2024 02:01:47 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 = '92231' 10/06/2024 02:01:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '92231' 10/06/2024 02:01:47 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 ( '92231' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 10/06/2024 02:01:47 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 ( '92231' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '140.00' ) 10/06/2024 03:27:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1940' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 03:27:55 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' , '1940' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 10/06/2024 03:27:55 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 = '92238' 10/06/2024 03:27:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '92238' 10/06/2024 03:27:55 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 ( '92238' , '17037' , 'CLERGY M/LINO MM ' , '2' , '-2' , '1' , '60' , '49.180327868852' , '22' , '0' , '120.00' ) 10/06/2024 03:27:55 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 ( '92238' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '37.5' , '30.737704918033' , '22' , '0' , '37.50' ) 10/06/2024 03:27:56 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 ( '92238' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '32.5' , '26.639344262295' , '22' , '0' , '32.50' ) 10/06/2024 03:43:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1941' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 03:43: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' , '1941' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 10/06/2024 03:43: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 = '92239' 10/06/2024 03:43:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '92239' 10/06/2024 03:43: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 ( '92239' , '17628' , 'PREGHIERE A SAN CHARBEL - 8946' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 10/06/2024 05:20:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1695' AND id_document != '91929' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 10/06/2024 05:20:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1695', document_date = '2024-05-21', 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 = '66.00', price_tax_excluded = '54.10', date_upd = NOW() WHERE id_document = '91929' 10/06/2024 05:20:50 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 = '91929' 10/06/2024 05:20:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '91929' 10/06/2024 05:20:50 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 ( '91929' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 10/06/2024 05:20:50 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 ( '91929' , '17037' , 'CLERGY M/LINO MM ' , '1' , '-1' , '1' , '57' , '46.72131147541' , '22' , '0' , '57.00' ) 10/06/2024 05:45:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1942' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 10/06/2024 05:45:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1942' , '2024-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.69' , NOW() , NOW() ) 10/06/2024 05:45:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92240' 10/06/2024 05:45:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '92240' 10/06/2024 05:45:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92240' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 10/06/2024 06:13:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1512' AND id_document != '91715' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 10/06/2024 06:13:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1512', document_date = '2024-05-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.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91715' 10/06/2024 06:13:53 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 = '91715' 10/06/2024 06:13:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '91715' 10/06/2024 06:13:53 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 ( '91715' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 10/06/2024 06:13:53 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 ( '91715' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' )