11/08/2022 09:30:22 am >> SELECT document_num FROM ps_document WHERE document_num = '43' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 09:30:22 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 ( '21' , '43' , '2022-08-11' , '' , '3417' , '0' , '9340285' , 'VIA LEON BATTISTA ALBERTI, 37 50055 LASTRA A SIGNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 11/08/2022 09:30:22 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 = '5396' 11/08/2022 09:30:22 am >> DELETE FROM ps_document_detail WHERE id_document = '5396' 11/08/2022 09:30:22 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 ( '5396' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 11/08/2022 09:43:55 am >> SELECT document_num FROM ps_document WHERE document_num = '35/A' AND id_document != '56634' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-06') 11/08/2022 09:43:55 am >> UPDATE ps_document SET id_document_type = '24', document_num = '35/A', document_date = '2022-05-06', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '203.80', price_tax_excluded = '172.24', date_upd = NOW() WHERE id_document = '56634' 11/08/2022 09:43:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56634' 11/08/2022 09:43:56 am >> DELETE FROM ps_document_detail WHERE id_document = '56634' 11/08/2022 09:43: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 ( '56634' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '78.0000' , '63.934426229508' , '22' , '0' , '78.00' ) 11/08/2022 09:43:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '14920' AND id_supplier = '' 11/08/2022 09:43:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14920' , '' , '1' ) 11/08/2022 09:43: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 ( '56634' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '960' , '-960' , '4' , '0.03' , '0.03' , '0' , '0' , '28.80' ) 11/08/2022 09:43:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 11/08/2022 09:43:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 11/08/2022 09:43: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 ( '56634' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 11/08/2022 09:43:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 11/08/2022 09:43:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 11/08/2022 09:43: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 ( '56634' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '11.00' ) 11/08/2022 09:43:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 11/08/2022 09:43:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 11/08/2022 09:43: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 ( '56634' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 11/08/2022 09:43:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 11/08/2022 09:43:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 11/08/2022 09:43: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 ( '56634' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '46.00' ) 11/08/2022 09:43:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '' 11/08/2022 09:43:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '' , '1' ) 11/08/2022 09:53:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2499' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 09:53:53 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' , '2499' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 11/08/2022 09:53: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 = '59980' 11/08/2022 09:53:53 am >> DELETE FROM ps_document_detail WHERE id_document = '59980' 11/08/2022 09:53: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 ( '59980' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 11/08/2022 09:53:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 11/08/2022 09:53:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 11/08/2022 09:53:54 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 ( '59980' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 11/08/2022 09:53:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 11/08/2022 09:53:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 11/08/2022 10:01:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2500' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 10:01: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' , '2500' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.70' , '3.03' , NOW() , NOW() ) 11/08/2022 10:01: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 = '59981' 11/08/2022 10:01:30 am >> DELETE FROM ps_document_detail WHERE id_document = '59981' 11/08/2022 10:01: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 ( '59981' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 11/08/2022 10:01:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '9695' AND id_supplier = '' 11/08/2022 10:01:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9695' , '' , '1' ) 11/08/2022 10:01: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 ( '59981' , '16986' , 'QUADRETTO SMUSSATO 7X10 SACRO CUORE' , '1' , '-1' , '1' , '2.3' , '1.8852459016393' , '22' , '0' , '2.30' ) 11/08/2022 10:01:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '16986' AND id_supplier = '' 11/08/2022 10:01:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16986' , '' , '1' ) 11/08/2022 10:15:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2501' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 10:15:57 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' , '2501' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '134.64' , NOW() , NOW() ) 11/08/2022 10:15:57 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 = '59982' 11/08/2022 10:15:57 am >> DELETE FROM ps_document_detail WHERE id_document = '59982' 11/08/2022 10:15:57 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 ( '59982' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 11/08/2022 10:15:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '5888' AND id_supplier = '' 11/08/2022 10:15:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5888' , '' , '1' ) 11/08/2022 10:15:57 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 ( '59982' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 11/08/2022 10:15:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = '' 11/08/2022 10:15:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '' , '1' ) 11/08/2022 10:15:57 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 ( '59982' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 11/08/2022 10:15:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '' 11/08/2022 10:15:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '' , '1' ) 11/08/2022 10:15:57 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 ( '59982' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 11/08/2022 10:15:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '' 11/08/2022 10:15:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '' , '1' ) 11/08/2022 10:15:57 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 ( '59982' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 11/08/2022 10:15:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 11/08/2022 10:15:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 11/08/2022 10:25:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2502' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 10:25:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2502' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 11/08/2022 10:25: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 = '59983' 11/08/2022 10:25:49 am >> DELETE FROM ps_document_detail WHERE id_document = '59983' 11/08/2022 10:25: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 ( '59983' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '100.00' ) 11/08/2022 10:25:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 11/08/2022 10:25:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 11/08/2022 10:31:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2503' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 10:31: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' , '2503' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.92' , '58.86' , NOW() , NOW() ) 11/08/2022 10:31: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 = '59984' 11/08/2022 10:31:51 am >> DELETE FROM ps_document_detail WHERE id_document = '59984' 11/08/2022 10:31: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 ( '59984' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 11/08/2022 10:31:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 11/08/2022 10:31:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 11/08/2022 10:31: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 ( '59984' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 11/08/2022 10:31:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 11/08/2022 10:31:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 11/08/2022 10:31: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 ( '59984' , '18748' , 'OSTIA MAGNA 125mm' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 11/08/2022 10:31:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '18748' AND id_supplier = '' 11/08/2022 10:31:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18748' , '' , '1' ) 11/08/2022 10:31: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 ( '59984' , '19685' , 'AMEN - OTT 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 11/08/2022 10:31:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 11/08/2022 10:31:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 11/08/2022 10:31: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 ( '59984' , '19684' , 'AMEN - SET. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 11/08/2022 10:31:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '' 11/08/2022 10:31:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' ) 11/08/2022 10:43:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2504' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 10:43: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' , '2504' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.40' , '5.40' , NOW() , NOW() ) 11/08/2022 10:43: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 = '59985' 11/08/2022 10:43:31 am >> DELETE FROM ps_document_detail WHERE id_document = '59985' 11/08/2022 10:43: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 ( '59985' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.4' , '5.4' , '0' , '0' , '5.40' ) 11/08/2022 10:43:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 11/08/2022 10:43:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 11/08/2022 10:59:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2505' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 10:59:09 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' , '2505' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.07' , NOW() , NOW() ) 11/08/2022 10:59:09 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 = '59986' 11/08/2022 10:59:09 am >> DELETE FROM ps_document_detail WHERE id_document = '59986' 11/08/2022 10:59:09 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 ( '59986' , '1312' , 'BRACCIALE DECINA' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 11/08/2022 10:59:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 11/08/2022 10:59:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 11/08/2022 11:04:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1846' AND id_document != '58679' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 11/08/2022 11:04:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1846', document_date = '2022-06-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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '58679' 11/08/2022 11:04:41 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 = '58679' 11/08/2022 11:04:41 am >> DELETE FROM ps_document_detail WHERE id_document = '58679' 11/08/2022 11:04:41 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 ( '58679' , '12047' , 'MAXI CARD - M0107/K131' , '8' , '-8' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '9.60' ) 11/08/2022 11:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '12047' AND id_supplier = '' 11/08/2022 11:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12047' , '' , '1' ) 11/08/2022 11:04:41 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 ( '58679' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 11/08/2022 11:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '7916' AND id_supplier = '' 11/08/2022 11:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7916' , '' , '1' ) 11/08/2022 11:04:41 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 ( '58679' , '9719' , 'SCATOLINA CON PERGAMENA IN POLIMERO - COMUNIONE - 2301 ' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 11/08/2022 11:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '9719' AND id_supplier = '' 11/08/2022 11:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9719' , '' , '1' ) 11/08/2022 11:04:41 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 ( '58679' , '16969' , 'CORONA DELLE ROSE - 10974' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 11/08/2022 11:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16969' AND id_supplier = '' 11/08/2022 11:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16969' , '' , '1' ) 11/08/2022 11:04:41 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 ( '58679' , '19560' , 'PERGAMENA 17X25' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 11/08/2022 11:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19560' AND id_supplier = '' 11/08/2022 11:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19560' , '' , '1' ) 11/08/2022 11:04:41 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 ( '58679' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 11/08/2022 11:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '14772' AND id_supplier = '' 11/08/2022 11:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14772' , '' , '1' ) 11/08/2022 11:14:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2506' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 11:14:27 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' , '2506' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.60' , '0.49' , NOW() , NOW() ) 11/08/2022 11:14: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 = '59987' 11/08/2022 11:14:27 am >> DELETE FROM ps_document_detail WHERE id_document = '59987' 11/08/2022 11:14: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 ( '59987' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '3' , '-3' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.60' ) 11/08/2022 11:14:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19468' AND id_supplier = '' 11/08/2022 11:14:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19468' , '' , '1' ) 11/08/2022 11:16:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2507' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 11:16:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2507' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 11/08/2022 11:16:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59988' 11/08/2022 11:16:55 am >> DELETE FROM ps_document_detail WHERE id_document = '59988' 11/08/2022 11:16:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59988' , '17914' , 'FAMMI SAPERE PERCHE - S. CAROTTA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 11/08/2022 11:16:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17914' AND id_supplier = '' 11/08/2022 11:16:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17914' , '' , '1' ) 11/08/2022 11:24:59 am >> SELECT document_num FROM ps_document WHERE document_num = '75/A' AND id_document != '32723' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-09-17') 11/08/2022 11:25:00 am >> UPDATE ps_document SET id_document_type = '24', document_num = '75/A', document_date = '2021-09-17', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = 'acconto € 100,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 = '620.00', price_tax_excluded = '508.20', date_upd = NOW() WHERE id_document = '32723' 11/08/2022 11:25: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 = '32723' 11/08/2022 11:25:00 am >> DELETE FROM ps_document_detail WHERE id_document = '32723' 11/08/2022 11:25: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 ( '32723' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '620.0000' , '508.19672131148' , '22' , '0' , '620.00' ) 11/08/2022 11:25:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19448' AND id_supplier = '' 11/08/2022 11:25:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19448' , '' , '1' ) 11/08/2022 11:26:24 am >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '57793' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-16') 11/08/2022 11:26:24 am >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2022-05-16', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = 'acconto € 50,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 = '139.30', price_tax_excluded = '121.76', date_upd = NOW() WHERE id_document = '57793' 11/08/2022 11:26: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 = '57793' 11/08/2022 11:26:24 am >> DELETE FROM ps_document_detail WHERE id_document = '57793' 11/08/2022 11:26: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 ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '11.40' ) 11/08/2022 11:26:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 11/08/2022 11:26:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 11/08/2022 11:26:25 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 ( '57793' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' , '-15' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '4.50' ) 11/08/2022 11:26:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 11/08/2022 11:26:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 11/08/2022 11:26:25 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 ( '57793' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 11/08/2022 11:26:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 11/08/2022 11:26:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 11/08/2022 11:26:25 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 ( '57793' , '7673' , 'PARTICOLE MM38' , '12' , '-12' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '42.00' ) 11/08/2022 11:26:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 11/08/2022 11:26:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 11/08/2022 11:26:25 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 ( '57793' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 11/08/2022 11:26:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 11/08/2022 11:26:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 11/08/2022 11:26:25 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 ( '57793' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 11/08/2022 11:26:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 11/08/2022 11:26:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 11/08/2022 11:33:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1619' AND id_document != '57884' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-21') 11/08/2022 11:33:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1619', document_date = '2022-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 = '47.00', price_tax_excluded = '38.52', date_upd = NOW() WHERE id_document = '57884' 11/08/2022 11:33:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57884' 11/08/2022 11:33:48 am >> DELETE FROM ps_document_detail WHERE id_document = '57884' 11/08/2022 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57884' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '22' , '-22' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '22.00' ) 11/08/2022 11:33:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 11/08/2022 11:33:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 11/08/2022 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57884' , '3260' , 'CUSTODIA LITURGIA DELLE ORE IN PELLE - 4 VOL ' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 11/08/2022 11:33:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '3260' AND id_supplier = '' 11/08/2022 11:33:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3260' , '' , '1' ) 11/08/2022 11:43:35 am >> DELETE FROM ps_document WHERE id_document = '59701' 11/08/2022 11:43:35 am >> DELETE FROM ps_document_detail WHERE id_document = '59701' 11/08/2022 11:57:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2508' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 11:57:13 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' , '2508' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 11/08/2022 11:57:13 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 = '59989' 11/08/2022 11:57:13 am >> DELETE FROM ps_document_detail WHERE id_document = '59989' 11/08/2022 11:57:13 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 ( '59989' , '19150' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 11/08/2022 11:57:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 11/08/2022 11:57:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 11/08/2022 12:07:58 pm >> DELETE FROM ps_document WHERE id_document = '59866' 11/08/2022 12:07:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '59866' 11/08/2022 12:08:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1580' AND id_document != '57840' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 11/08/2022 12:08:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1580', document_date = '2022-05-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 = '46.00', price_tax_excluded = '37.70', date_upd = NOW() WHERE id_document = '57840' 11/08/2022 12:08:39 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 = '57840' 11/08/2022 12:08:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '57840' 11/08/2022 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57840' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 11/08/2022 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5473' AND id_supplier = '' 11/08/2022 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5473' , '' , '1' ) 11/08/2022 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57840' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '45.00' ) 11/08/2022 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 11/08/2022 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 11/08/2022 12:18:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2509' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 12:18: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' , '2509' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 11/08/2022 12:18: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 = '59990' 11/08/2022 12:18:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '59990' 11/08/2022 12:18: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 ( '59990' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 11/08/2022 12:18:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '' 11/08/2022 12:18:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' ) 11/08/2022 12:18: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 ( '59990' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 11/08/2022 12:18:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 11/08/2022 12:18:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 11/08/2022 12:18:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2510' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 12:18:43 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' , '2510' , '2022-08-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '11.89' , NOW() , NOW() ) 11/08/2022 12:18:43 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 = '59991' 11/08/2022 12:18:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '59991' 11/08/2022 12:18:43 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 ( '59991' , '15028' , 'ROSARIO CRISTALLO E ARGENTO - 17800' , '1' , '-1' , '1' , '14.50' , '11.885245901639' , '22' , '0' , '14.50' ) 11/08/2022 12:18:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15028' AND id_supplier = '' 11/08/2022 12:18:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15028' , '' , '1' ) 11/08/2022 12:20:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-11') 11/08/2022 12:20:32 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 ( '21' , '107' , '2022-08-11' , '' , '618' , '0' , '4671023' , 'S. ANGELO 84085 MERCATO S. SEVERINO' , '' , 'COPIE OMAGGIO AUTORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 11/08/2022 12:20:32 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 = '59992' 11/08/2022 12:20:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '59992' 11/08/2022 12:20:32 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 ( '59992' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '72' , '-72' , '4' , '35.00' , '35' , '0' , '100' , '0.00' ) 11/08/2022 12:50:50 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '89', document_date = '2022-07-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4671100', address1 = 'STRADA DEL LAVORO 211 47894 CHIESANUOVA R.S.M.', address2 = '', note = '', price_shipping = '25.01', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3222.39', price_tax_excluded = '2641.31', date_upd = NOW() WHERE id_document = '59844' 11/08/2022 12:50: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 = '59844' 11/08/2022 12:50:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '59844' 11/08/2022 12:50: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 ( '59844' , '19842' , 'CALICE OTTONE SABBIATO - 083' , '1' , '1' , '1' , '148.0000' , '121.31147540984' , '22' , '10' , '162.50' ) 11/08/2022 12:50:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19842' AND id_supplier = '' 11/08/2022 12:50:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19842' , '' , '1' ) 11/08/2022 12:50: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 ( '59844' , '19843' , 'CALICE IN OTTONE - 122' , '1' , '1' , '1' , '122.0000' , '100' , '22' , '10' , '133.96' ) 11/08/2022 12:50:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19843' AND id_supplier = '' 11/08/2022 12:50:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19843' , '' , '1' ) 11/08/2022 12:50: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 ( '59844' , '19844' , 'CALICE OTTONE - 131' , '1' , '1' , '1' , '133.0000' , '109.01639344262' , '22' , '10' , '146.03' ) 11/08/2022 12:50:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19844' AND id_supplier = '' 11/08/2022 12:50:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19844' , '' , '1' ) 11/08/2022 12:50: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 ( '59844' , '19845' , 'CALICE IN FUSIONE ARGENTATA - 190' , '1' , '1' , '1' , '299.0000' , '245.08196721311' , '22' , '10' , '328.30' ) 11/08/2022 12:50:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19845' AND id_supplier = '' 11/08/2022 12:50:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19845' , '' , '1' ) 11/08/2022 12:50: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 ( '59844' , '19846' , 'CALICE IN ARG. EVANGELISTI - 175/A' , '1' , '1' , '1' , '1620.0000' , '1327.868852459' , '22' , '0' , '1976.40' ) 11/08/2022 12:50:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19846' AND id_supplier = '' 11/08/2022 12:50:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19846' , '' , '1' ) 11/08/2022 12:50: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 ( '59844' , '19847' , 'PATENA IN ARGENTO' , '1' , '1' , '1' , '270.0000' , '221.31147540984' , '22' , '0' , '329.40' ) 11/08/2022 12:50:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19847' AND id_supplier = '' 11/08/2022 12:50:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19847' , '' , '1' ) 11/08/2022 12:50: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 ( '59844' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '1' , '1' , '45.0000' , '36.885245901639' , '22' , '10' , '49.41' ) 11/08/2022 12:50:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19848' AND id_supplier = '' 11/08/2022 12:50:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19848' , '' , '1' ) 11/08/2022 12:50:51 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 ( '59844' , '19852' , 'PATENA CON GRECA CM 19 - 999/7 D' , '1' , '1' , '1' , '60.0000' , '49.180327868852' , '22' , '10' , '65.88' ) 11/08/2022 12:50:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19852' AND id_supplier = '' 11/08/2022 12:50:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19852' , '' , '1' )