16/05/2023 09:24:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 09:24: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' , '1671' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.50' , '33.17' , NOW() , NOW() ) 16/05/2023 09:24: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 = '84345' 16/05/2023 09:24:00 am >> DELETE FROM ps_document_detail WHERE id_document = '84345' 16/05/2023 09:24: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 ( '84345' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 16/05/2023 09:24: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 ( '84345' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 16/05/2023 09:46:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 09:46:38 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' , '1672' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '70.26' , NOW() , NOW() ) 16/05/2023 09:46:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84346' 16/05/2023 09:46:38 am >> DELETE FROM ps_document_detail WHERE id_document = '84346' 16/05/2023 09:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84346' , '19560' , 'PERGAMENA 17X25' , '50' , '-50' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '35.00' ) 16/05/2023 09:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84346' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 16/05/2023 09:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84346' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 16/05/2023 09:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84346' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 16/05/2023 09:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84346' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 16/05/2023 10:10:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 10:10:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1673' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.80' , '12.80' , NOW() , NOW() ) 16/05/2023 10:10:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84347' 16/05/2023 10:10:01 am >> DELETE FROM ps_document_detail WHERE id_document = '84347' 16/05/2023 10:10:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84347' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '320' , '-320' , '4' , '0.04' , '0.04' , '0' , '0' , '12.80' ) 16/05/2023 10:13:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1674' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 10:13:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1674' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.95' , '19.95' , NOW() , NOW() ) 16/05/2023 10:13:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84348' 16/05/2023 10:13:15 am >> DELETE FROM ps_document_detail WHERE id_document = '84348' 16/05/2023 10:13:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84348' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 16/05/2023 10:13:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84348' , '8287' , 'PREGHIERA DEL MATTINO E DELLA SERA - ECON.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/05/2023 10:28:27 am >> SELECT document_num FROM ps_document WHERE document_num = '1675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 10:28: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' , '1675' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '189.00' , '164.15' , NOW() , NOW() ) 16/05/2023 10:28: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 = '84349' 16/05/2023 10:28:27 am >> DELETE FROM ps_document_detail WHERE id_document = '84349' 16/05/2023 10:28: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 ( '84349' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '1280' , '-1280' , '4' , '0.04' , '0.04' , '0' , '0' , '51.20' ) 16/05/2023 10:28: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 ( '84349' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '137.8' , '112.95081967213' , '22' , '0' , '137.80' ) 16/05/2023 10:30:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1676' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 10:30: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' , '1676' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 16/05/2023 10:30: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 = '84350' 16/05/2023 10:30:02 am >> DELETE FROM ps_document_detail WHERE id_document = '84350' 16/05/2023 10:30: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 ( '84350' , '12296' , 'CASULA 100% POLIESTERE ' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 16/05/2023 10:30:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1677' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 10:30:50 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' , '1677' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.20' , '3.20' , NOW() , NOW() ) 16/05/2023 10:30:50 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 = '84351' 16/05/2023 10:30:50 am >> DELETE FROM ps_document_detail WHERE id_document = '84351' 16/05/2023 10:30:50 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 ( '84351' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.04' , '0.04' , '0' , '0' , '3.20' ) 16/05/2023 10:34:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 10:34:39 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' , '1678' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 16/05/2023 10:34:39 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 = '84352' 16/05/2023 10:34:39 am >> DELETE FROM ps_document_detail WHERE id_document = '84352' 16/05/2023 10:34:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84352' , '19208' , 'patena art. 1915' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 16/05/2023 10:48:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 10:48: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' , '1679' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '36.07' , NOW() , NOW() ) 16/05/2023 10:48: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 = '84353' 16/05/2023 10:48:30 am >> DELETE FROM ps_document_detail WHERE id_document = '84353' 16/05/2023 10:48: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 ( '84353' , '19775' , 'BRACCIALE ARGENTO/VETRO' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 16/05/2023 10:48: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 ( '84353' , '15492' , 'CROCE SAN BENEDETTO CON BASE E LEGNO - CZ6BSNIK' , '1' , '-1' , '1' , '26.00' , '21.311475409836' , '22' , '0' , '26.00' ) 16/05/2023 10:57:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 10:57: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' , '1680' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.70' , '28.65' , NOW() , NOW() ) 16/05/2023 10:57: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 = '84354' 16/05/2023 10:57:51 am >> DELETE FROM ps_document_detail WHERE id_document = '84354' 16/05/2023 10:57: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 ( '84354' , '15344' , 'IN ADORAZIONE - CATALINA RIVAS' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 16/05/2023 10:57: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 ( '84354' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 16/05/2023 10:57:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84354' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 16/05/2023 11:04:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1681' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 11:04:35 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' , '1681' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.92' , NOW() , NOW() ) 16/05/2023 11:04:35 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 = '84355' 16/05/2023 11:04:35 am >> DELETE FROM ps_document_detail WHERE id_document = '84355' 16/05/2023 11:04:35 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 ( '84355' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2' , '1.9230769230769' , '4' , '0' , '2.00' ) 16/05/2023 11:09:35 am >> SELECT document_num FROM ps_document WHERE document_num = '62/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 11:09:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '62/A' , '2023-05-16' , 'A' , '230' , '0' , '4668969' , 'VIA G. NICOTERA, 66 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '151.50' , '151.50' , NOW() , NOW() ) 16/05/2023 11:09:35 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 = '84356' 16/05/2023 11:09:35 am >> DELETE FROM ps_document_detail WHERE id_document = '84356' 16/05/2023 11:09:35 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 ( '84356' , '20118' , 'FATIMA CM 44 - 1035' , '1' , '-1' , '0' , '38' , '38' , '' , '0' , '38.00' ) 16/05/2023 11:09:35 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 ( '84356' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '0' , '28.00' , '28' , '' , '0' , '28.00' ) 16/05/2023 11:09:35 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 ( '84356' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '0' , '22.00' , '22' , '' , '0' , '22.00' ) 16/05/2023 11:09:35 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 ( '84356' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '0' , '16.00' , '16' , '' , '0' , '16.00' ) 16/05/2023 11:09:35 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 ( '84356' , '20123' , 'FATIMA CM 17 - 1012' , '1' , '-1' , '0' , '7.00' , '7' , '' , '0' , '7.00' ) 16/05/2023 11:09:35 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 ( '84356' , '20124' , 'FATIMA CM 11 - 1011' , '9' , '-9' , '0' , '4.50' , '4.5' , '' , '0' , '40.50' ) 16/05/2023 11:18:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1682' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 11:18:45 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' , '1682' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '145.00' , '129.99' , NOW() , NOW() ) 16/05/2023 11:18:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84357' 16/05/2023 11:18:45 am >> DELETE FROM ps_document_detail WHERE id_document = '84357' 16/05/2023 11:18:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84357' , '8260' , 'PREGHIAMO INSIEME E DICIAMO - M. BARZIZZA' , '2' , '-2' , '4' , '32.50' , '32.5' , '0' , '5' , '61.76' ) 16/05/2023 11:18:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84357' , '15527' , 'TUNICA SVASATA AVORIO- PTA001B05' , '1' , '-1' , '1' , '39.24' , '32.16393442623' , '22' , '0' , '39.24' ) 16/05/2023 11:18:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84357' , '20120' , 'FATIMA CM 27 -1025' , '2' , '-2' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '44.00' ) 16/05/2023 11:19:31 am >> 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') 16/05/2023 11:19:31 am >> 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 = '300.00', price_tax_excluded = '245.90', date_upd = NOW() WHERE id_document = '82684' 16/05/2023 11:19: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 = '82684' 16/05/2023 11:19:31 am >> DELETE FROM ps_document_detail WHERE id_document = '82684' 16/05/2023 11:19: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 ( '82684' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 16/05/2023 11:28:37 am >> SELECT document_num FROM ps_document WHERE document_num = '89' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 11:28: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 ( '21' , '89' , '2023-05-16' , '' , '3958' , '0' , '4676366' , 'PIAZZA SS SALVATORE 1 03040 PIGNATARO INTERAMNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '151.15' , '151.15' , NOW() , NOW() ) 16/05/2023 11:28: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 = '84358' 16/05/2023 11:28:37 am >> DELETE FROM ps_document_detail WHERE id_document = '84358' 16/05/2023 11:28: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 ( '84358' , '1090' , 'BIBBIA' , '15' , '-15' , '4' , '9.90' , '9.9' , '0' , '10' , '133.65' ) 16/05/2023 11:28: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 ( '84358' , '7907' , 'PERGAMENE' , '50' , '-50' , '0' , '0.35' , '0.35' , '' , '0' , '17.50' ) 16/05/2023 11:41:44 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3958' 16/05/2023 11:41:44 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3958' , '10' , '160' , 'PARROCCHIA SS SALVATORE' , '' , 'PADRE NICOLAS' , 'PIAZZA SS SALVATORE 1' , '' , '03040' , 'PIGNATARO INTERAMNA' , '' , '' , '3332005967' , '' , '90002080605' , NOW() , NOW() ) 16/05/2023 11:41:44 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3958' 16/05/2023 11:42:28 am >> SELECT document_num FROM ps_document WHERE document_num = '89' AND id_document != '84358' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 11:42:28 am >> UPDATE ps_document SET id_document_type = '21', document_num = '89', document_date = '2023-05-16', document_letter = '', id_customer = '3958', id_supplier = '', id_address = '4676366', address1 = 'PIAZZA SS SALVATORE 1 03040 PIGNATARO INTERAMNA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '151.15', price_tax_excluded = '151.15', date_upd = NOW() WHERE id_document = '84358' 16/05/2023 11:42: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 = '84358' 16/05/2023 11:42:28 am >> DELETE FROM ps_document_detail WHERE id_document = '84358' 16/05/2023 11:42: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 ( '84358' , '1090' , 'BIBBIA' , '15' , '-15' , '4' , '9.9000' , '9.9' , '0' , '10' , '133.65' ) 16/05/2023 11:42: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 ( '84358' , '7907' , 'PERGAMENE' , '50' , '-50' , '0' , '0.3500' , '0.35' , '0' , '0' , '17.50' ) 16/05/2023 11:42:58 am >> SELECT document_num FROM ps_document WHERE document_num = '89' AND id_document != '84358' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 11:42:58 am >> UPDATE ps_document SET id_document_type = '21', document_num = '89', document_date = '2023-05-16', document_letter = '', id_customer = '3958', id_supplier = '0', id_address = '4679048', address1 = 'PIAZZA SS SALVATORE 1 03040 PIGNATARO INTERAMNA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '151.15', price_tax_excluded = '151.15', date_upd = NOW() WHERE id_document = '84358' 16/05/2023 11:42:58 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 = '84358' 16/05/2023 11:42:58 am >> DELETE FROM ps_document_detail WHERE id_document = '84358' 16/05/2023 11:42:58 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 ( '84358' , '1090' , 'BIBBIA' , '15' , '-15' , '4' , '9.9000' , '9.9' , '0' , '10' , '133.65' ) 16/05/2023 11:42:59 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 ( '84358' , '7907' , 'PERGAMENE' , '50' , '-50' , '0' , '0.3500' , '0.35' , '0' , '0' , '17.50' ) 16/05/2023 12:07:59 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3958' 16/05/2023 12:07:59 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3958' , '10' , '160' , 'PARROCCHIA SS SALVATORE' , '' , 'PADRE NICOLAS' , 'PIAZZA SS SALVATORE 1' , '' , '03040' , 'PIGNATARO INTERAMNA' , '' , '' , '3332005967' , '' , '90002080605' , NOW() , NOW() ) 16/05/2023 12:07:59 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3958' 16/05/2023 12:12:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1683' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 12:12:53 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' , '1683' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.80' , '21.39' , NOW() , NOW() ) 16/05/2023 12:12: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 = '84359' 16/05/2023 12:12:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '84359' 16/05/2023 12:12: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 ( '84359' , '14875' , 'ANGELO IN RESINA CON FLAUTO CM 9 - KS124-F' , '1' , '-1' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '7.80' ) 16/05/2023 12:12: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 ( '84359' , '15580' , 'CHRISTUS VIVIT' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '0' , '6.00' ) 16/05/2023 12:12: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 ( '84359' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 16/05/2023 12:12: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 ( '84359' , '13882' , 'GAUDETE ET EXSULTATE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 16/05/2023 12:12: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 ( '84359' , '16179' , 'APERUIT ILLIS' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 16/05/2023 12:17:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1684' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 12:17:19 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' , '1684' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.60' , '15.25' , NOW() , NOW() ) 16/05/2023 12:17:19 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 = '84360' 16/05/2023 12:17:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '84360' 16/05/2023 12:17:19 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 ( '84360' , '15003' , 'GIGLER CON STOPPINO PER LUCERNA SS' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 16/05/2023 12:17:19 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 ( '84360' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '10' , '-10' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '11.00' ) 16/05/2023 12:17:19 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 ( '84360' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.8' , '3.1147540983607' , '22' , '0' , '3.80' ) 16/05/2023 12:17:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1685' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 12:17: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' , '1685' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '38.97' , NOW() , NOW() ) 16/05/2023 12:17: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 = '84361' 16/05/2023 12:17:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '84361' 16/05/2023 12:17: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 ( '84361' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 16/05/2023 12:17: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 ( '84361' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 16/05/2023 12:17: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 ( '84361' , '7907' , 'PERGAMENE' , '20' , '-20' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '10.00' ) 16/05/2023 12:36:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1686' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 12:36:34 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' , '1686' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 16/05/2023 12:36:34 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 = '84362' 16/05/2023 12:36:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '84362' 16/05/2023 12:36:34 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 ( '84362' , '19232' , 'ANELLO CON CROCE - RA087' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 16/05/2023 12:45:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1685' AND id_document != '84361' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 12:45:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1685', document_date = '2023-05-16', 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 = '42.00', price_tax_excluded = '38.97', date_upd = NOW() WHERE id_document = '84361' 16/05/2023 12:45: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 = '84361' 16/05/2023 12:45:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '84361' 16/05/2023 12:45: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 ( '84361' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '28.00' ) 16/05/2023 12:45: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 ( '84361' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 16/05/2023 12:45: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 ( '84361' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 16/05/2023 12:50:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1674' AND id_document != '84348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 12:50:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1674', document_date = '2023-05-16', 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 = '19.95', price_tax_excluded = '19.95', date_upd = NOW() WHERE id_document = '84348' 16/05/2023 12:50: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 = '84348' 16/05/2023 12:50:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '84348' 16/05/2023 12:50: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 ( '84348' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 16/05/2023 12:50: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 ( '84348' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/05/2023 12:51:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1684' AND id_document != '84360' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 12:51:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1684', document_date = '2023-05-16', 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.60', price_tax_excluded = '15.25', date_upd = NOW() WHERE id_document = '84360' 16/05/2023 12:51: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 = '84360' 16/05/2023 12:51:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '84360' 16/05/2023 12:51: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 ( '84360' , '15003' , 'GIGLER CON STOPPINO PER LUCERNA SS' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 16/05/2023 12:51: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 ( '84360' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '10' , '-10' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '11.00' ) 16/05/2023 12:51: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 ( '84360' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '0.80' ) 16/05/2023 12:51: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 ( '84360' , '6015' , 'LUMINO ELETTRICO A BASSA TENS. - LED - OGGETTI' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 16/05/2023 12:52:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1432' AND id_document != '83036' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 16/05/2023 12:52:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1432', 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 = '58.60', price_tax_excluded = '48.03', date_upd = NOW() WHERE id_document = '83036' 16/05/2023 12:52: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 = '83036' 16/05/2023 12:52:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '83036' 16/05/2023 12:52: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 ( '83036' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 16/05/2023 12:52: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 ( '83036' , '20062' , 'BRACCIALE DECINA - BD018' , '2' , '-2' , '1' , '1.7' , '1.3934426229508' , '22' , '0' , '3.40' ) 16/05/2023 12:52: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 ( '83036' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '2' , '-2' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '7.60' ) 16/05/2023 12:52: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 ( '83036' , '16398' , 'MADONNA DELLE GRAZIE - 143' , '2' , '-2' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '7.60' ) 16/05/2023 12:52: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 ( '83036' , '12490' , 'CROCE SAN BENEDETTO ULIVO - CZ6NIK' , '1' , '-1' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '17.00' ) 16/05/2023 02:06:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1687' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 02:06:48 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' , '1687' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '91.75' , NOW() , NOW() ) 16/05/2023 02:06:48 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 = '84363' 16/05/2023 02:06:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '84363' 16/05/2023 02:06:48 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 ( '84363' , '11265' , 'COPRILEGGIO - 881' , '1' , '-1' , '1' , '73.5' , '60.245901639344' , '22' , '0' , '73.50' ) 16/05/2023 02:06:48 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 ( '84363' , '11151' , 'LIBRI' , '7' , '-7' , '4' , '4.5' , '4.5' , '0' , '0' , '31.50' ) 16/05/2023 03:16:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1688' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 03:16:04 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' , '1688' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.60' , '77.85' , NOW() , NOW() ) 16/05/2023 03:16:04 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 = '84364' 16/05/2023 03:16:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '84364' 16/05/2023 03:16:04 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 ( '84364' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 16/05/2023 03:16:04 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 ( '84364' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 16/05/2023 03:16:04 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 ( '84364' , '15497' , 'CROCE PLEX - 086' , '5' , '-5' , '1' , '9' , '7.3770491803279' , '22' , '0' , '45.00' ) 16/05/2023 03:48:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 16/05/2023 03:48:45 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 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 = '27.70', price_tax_excluded = '27.70', date_upd = NOW() WHERE id_document = '81317' 16/05/2023 03:48:45 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 = '81317' 16/05/2023 03:48:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 16/05/2023 03:48:45 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 ( '81317' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 16/05/2023 03:48:45 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 ( '81317' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 16/05/2023 03:48:45 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 ( '81317' , '20998' , 'PAROLA E PREGHIERA - LUG. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 16/05/2023 03:48:45 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 ( '81317' , '21067' , 'AMEN - AGO 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 16/05/2023 03:48:45 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 ( '81317' , '21077' , 'ROSARIO UN VIAGGIO CHE CAMBIA LA VITA - SUOR E. MAILLARD' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 16/05/2023 05:00:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1689' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 05:00: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' , '1689' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 16/05/2023 05:00: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 = '84365' 16/05/2023 05:00:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '84365' 16/05/2023 05:00: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 ( '84365' , '5111' , 'SANTA RITA DA CASCIA - 11 BIS' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 16/05/2023 05:00:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '90' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 05:00:47 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' , '90' , '2023-05-16' , '' , '2312' , '0' , '4675584' , 'VIA SANT\\\'ANDREA 84081 ANTESSANO BARONISSI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '54.74' , '54.74' , NOW() , NOW() ) 16/05/2023 05:00: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 = '84366' 16/05/2023 05:00:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '84366' 16/05/2023 05:00: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 ( '84366' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '23' , '-23' , '4' , '2.80' , '2.8' , '0' , '15' , '54.74' ) 16/05/2023 05:03:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1690' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 05:03:45 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' , '1690' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 16/05/2023 05:03:45 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 = '84367' 16/05/2023 05:03:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '84367' 16/05/2023 05:03:45 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 ( '84367' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 16/05/2023 07:27:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1691' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 07:27:11 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' , '1691' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.50' , '48.79' , NOW() , NOW() ) 16/05/2023 07:27:11 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 = '84368' 16/05/2023 07:27:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '84368' 16/05/2023 07:27:11 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 ( '84368' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 16/05/2023 07:27:11 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 ( '84368' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 16/05/2023 07:27:11 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 ( '84368' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 16/05/2023 07:27:11 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 ( '84368' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '25.50' ) 16/05/2023 07:33:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1692' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 07:33:10 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' , '1692' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 16/05/2023 07:33:10 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 = '84369' 16/05/2023 07:33:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '84369' 16/05/2023 07:33:10 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 ( '84369' , '19795' , 'STOLA IN ASSISI CON RICAMO - 633' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 16/05/2023 07:36:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1693' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-16') 16/05/2023 07:36:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1693' , '2023-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.30' , NOW() , NOW() ) 16/05/2023 07:36:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84370' 16/05/2023 07:36:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '84370' 16/05/2023 07:36:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84370' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 16/05/2023 07:36:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84370' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '1' , '-1' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '0.60' )