29/07/2024 09:24:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2368' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 09:24:33 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' , '2368' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 29/07/2024 09:24:33 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 = '92749' 29/07/2024 09:24:33 am >> DELETE FROM ps_document_detail WHERE id_document = '92749' 29/07/2024 09:24:33 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 ( '92749' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 29/07/2024 09:29:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2046/24' , '2024-07-25' , '24' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '289.02' , '277.91' , NOW() , NOW() ) 29/07/2024 09:29:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92750' 29/07/2024 09:29:21 am >> DELETE FROM ps_document_detail WHERE id_document = '92750' 29/07/2024 09:29:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92750' , '16689' , 'OSTIA PAN DI CENA mm80' , '100' , '100' , '3' , '1.2' , '1.1538461538462' , '4' , '3' , '121.0560' ) 29/07/2024 09:29:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '22' 29/07/2024 09:29:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '22' , '1' ) 29/07/2024 09:29:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92750' , '7311' , 'OSTIA SOTTILE 74MM' , '150' , '150' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '167.9652' ) 29/07/2024 09:29:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '22' 29/07/2024 09:29:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '22' , '1' ) 29/07/2024 09:40:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2369' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 09:40:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2369' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.60' , '39.42' , NOW() , NOW() ) 29/07/2024 09:40:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92751' 29/07/2024 09:40:26 am >> DELETE FROM ps_document_detail WHERE id_document = '92751' 29/07/2024 09:40:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92751' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 29/07/2024 09:40:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92751' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 29/07/2024 09:49:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2370' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 09:49:59 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' , '2370' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '255.00' , '212.79' , NOW() , NOW() ) 29/07/2024 09:49:59 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 = '92752' 29/07/2024 09:49:59 am >> DELETE FROM ps_document_detail WHERE id_document = '92752' 29/07/2024 09:49: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 ( '92752' , '8147' , 'POLO BASIC' , '2' , '-2' , '1' , '27' , '22.131147540984' , '22' , '0' , '54.00' ) 29/07/2024 09:49: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 ( '92752' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 29/07/2024 09:49: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 ( '92752' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '140.1' , '114.83606557377' , '22' , '0' , '140.10' ) 29/07/2024 09:49: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 ( '92752' , '22773' , 'DONO E IL COMPITO DEL CULTO - A. GRILLO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 29/07/2024 10:49:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2371' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 10:49:06 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' , '2371' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.75' , '61.75' , NOW() , NOW() ) 29/07/2024 10:49:06 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 = '92753' 29/07/2024 10:49:06 am >> DELETE FROM ps_document_detail WHERE id_document = '92753' 29/07/2024 10:49:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92753' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '13' , '-13' , '4' , '5.00' , '5' , '0' , '5' , '61.75' ) 29/07/2024 10:51:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2372' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 10:51:59 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' , '2372' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 29/07/2024 10:51:59 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 = '92754' 29/07/2024 10:51:59 am >> DELETE FROM ps_document_detail WHERE id_document = '92754' 29/07/2024 10:51: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 ( '92754' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 29/07/2024 11:15:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2373' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 11:15: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' , '2373' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '305.00' , '270.17' , NOW() , NOW() ) 29/07/2024 11:15: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 = '92755' 29/07/2024 11:15:38 am >> DELETE FROM ps_document_detail WHERE id_document = '92755' 29/07/2024 11:15: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 ( '92755' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 29/07/2024 11:15: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 ( '92755' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 29/07/2024 11:15: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 ( '92755' , '11151' , 'LIBRI' , '20' , '-20' , '4' , '3.5' , '3.5' , '0' , '0' , '70.00' ) 29/07/2024 11:15: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 ( '92755' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 29/07/2024 11:15: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 ( '92755' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 29/07/2024 11:15: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 ( '92755' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 29/07/2024 11:15: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 ( '92755' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '57' , '46.72131147541' , '22' , '0' , '57.00' ) 29/07/2024 11:15: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 ( '92755' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '38' , '31.147540983607' , '22' , '0' , '38.00' ) 29/07/2024 11:15: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 ( '92755' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '36.8' , '30.16393442623' , '22' , '0' , '36.80' ) 29/07/2024 11:47:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2374' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 11:47: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' , '2374' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.70' , '24.71' , NOW() , NOW() ) 29/07/2024 11:47: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 = '92756' 29/07/2024 11:47:35 am >> DELETE FROM ps_document_detail WHERE id_document = '92756' 29/07/2024 11:47: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 ( '92756' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '4' , '-4' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '13.20' ) 29/07/2024 11:47: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 ( '92756' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 29/07/2024 11:47: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 ( '92756' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 29/07/2024 11:48:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2375' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 11:48:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2375' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '187.30' , '153.52' , NOW() , NOW() ) 29/07/2024 11:48:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92757' 29/07/2024 11:48:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92757' 29/07/2024 11:48:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92757' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 29/07/2024 11:48:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92757' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 29/07/2024 11:48:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92757' , '16461' , 'CLERGY NIDO D\'APE ML - C 22' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' ) 29/07/2024 11:48:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92757' , '22196' , 'CLERGY VERSUS ML - C25' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 29/07/2024 12:00:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2376' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 12:00:12 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' , '2376' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.10' , '8.22' , NOW() , NOW() ) 29/07/2024 12:00:12 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 = '92758' 29/07/2024 12:00:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '92758' 29/07/2024 12:00:12 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 ( '92758' , '22733' , 'BRACCIALE ELASTICO - RL436/435' , '2' , '-2' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '4.40' ) 29/07/2024 12:00:12 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 ( '92758' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.4' , '2.4' , '0' , '0' , '2.40' ) 29/07/2024 12:00:12 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 ( '92758' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 29/07/2024 12:00:12 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 ( '92758' , '21594' , 'CARTONCINO 16X23' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 29/07/2024 12:10:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001327' AND id_product != '16461' AND ean13 != '' 29/07/2024 12:10:47 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001327', date_upd = NOW() WHERE id_product = '16461' 29/07/2024 12:10:47 pm >> UPDATE ps_product_lang SET name = 'CLERGY NIDO D\'APE ML - C22', description = '' WHERE id_product = '16461' 29/07/2024 12:10:47 pm >> UPDATE ps_product SET wholesale_price = '24.61', on_sale = '0', price = '47.5410' WHERE id_product = '16461' 29/07/2024 12:10:47 pm >> UPDATE ps_product_shop SET wholesale_price = '24.61', price = '47.5410', id_tax_rules_group = '1', id_category_default = '462', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16461' 29/07/2024 12:10:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '16461' 29/07/2024 12:14:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2377' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 12:14:12 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' , '2377' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.90' , '33.88' , NOW() , NOW() ) 29/07/2024 12:14:12 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 = '92759' 29/07/2024 12:14:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '92759' 29/07/2024 12:14:12 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 ( '92759' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '2' , '-2' , '1' , '4.60' , '3.7704918032787' , '22' , '0' , '9.20' ) 29/07/2024 12:14:12 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 ( '92759' , '22668' , 'DIAVOLO RICONOSCERLO E VINCERLO - G. AMORT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 29/07/2024 12:14:12 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 ( '92759' , '20889' , 'GABRIELE PIETRO AMORTH - M. LANZA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 29/07/2024 12:14:12 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 ( '92759' , '21097' , 'BRACCIALE DECINA - BC1768N' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 29/07/2024 12:32:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 12:32: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 ( '24' , '21' , '2024-07-29' , '' , '0' , '0' , '4679306' , 'VIA CHIESA MADRE 25 84018 SCAFATI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '965.00' , '965.00' , NOW() , NOW() ) 29/07/2024 12:32: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 = '92760' 29/07/2024 12:32:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '92760' 29/07/2024 12:32: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 ( '92760' , '21616' , 'CARTEGGIO 1925-1926' , '2' , '-2' , '4' , '29.00' , '29' , '0' , '0' , '58.00' ) 29/07/2024 12:32: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 ( '92760' , '21725' , 'GIOVANNI AMENDOLA UNA VITA ....' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 29/07/2024 12:32: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 ( '92760' , '22786' , 'RASSEGNA STORICA SALERNITANA 81' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 29/07/2024 12:32: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 ( '92760' , '22787' , 'GIUSEPPE CASALE' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 29/07/2024 12:32: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 ( '92760' , '22788' , 'ALBERTA MARESCA' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 29/07/2024 12:32: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 ( '92760' , '22789' , 'GIUSEPPE CACCIATORE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 29/07/2024 12:32: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 ( '92760' , '22790' , 'GRAS' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 29/07/2024 12:32: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 ( '92760' , '22792' , 'STUDIIS FLORENS' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 29/07/2024 12:32: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 ( '92760' , '22793' , 'RINVENIMENTI MONETALI' , '1' , '-1' , '4' , '59.0000' , '59' , '0' , '0' , '59.00' ) 29/07/2024 12:32: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 ( '92760' , '22794' , 'PROFUMI NELLE SOCIETA ANTICHE' , '1' , '-1' , '4' , '36.0000' , '36' , '0' , '0' , '36.00' ) 29/07/2024 12:32: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 ( '92760' , '22795' , 'LONGO' , '1' , '-1' , '4' , '48.0000' , '48' , '0' , '0' , '48.00' ) 29/07/2024 12:32: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 ( '92760' , '22795' , 'POTRANDOLFO' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 29/07/2024 12:32: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 ( '92760' , '22797' , 'FRATTE' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 29/07/2024 12:32: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 ( '92760' , '22798' , 'FRATTE LE TERRECOTTE' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 29/07/2024 12:32: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 ( '92760' , '22799' , 'CUOZZO' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 29/07/2024 12:32: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 ( '92760' , '22800' , 'DIALOGHI SULL\'ARCHEOLOGIA' , '1' , '-1' , '4' , '120.0000' , '120' , '0' , '0' , '120.00' ) 29/07/2024 12:32: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 ( '92760' , '22801' , 'DIALOGHI SULLARCHEOLOGIA II' , '1' , '-1' , '4' , '180.0000' , '180' , '0' , '0' , '180.00' ) 29/07/2024 12:32: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 ( '92760' , '22802' , 'ETERNA CONTEMPORANEITA' , '1' , '-1' , '4' , '150.0000' , '150' , '0' , '0' , '150.00' ) 29/07/2024 03:34:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2378' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 03:34: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' , '2378' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 29/07/2024 03:34: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 = '92761' 29/07/2024 03:34:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '92761' 29/07/2024 03:34: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 ( '92761' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/07/2024 04:00:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2379' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 04:00:21 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' , '2379' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '83.61' , NOW() , NOW() ) 29/07/2024 04:00:21 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 = '92762' 29/07/2024 04:00:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '92762' 29/07/2024 04:00: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 ( '92762' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '102.00' ) 29/07/2024 04:03:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2380' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 04:03: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' , '2380' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 29/07/2024 04:03: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 = '92763' 29/07/2024 04:03:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '92763' 29/07/2024 04:03: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 ( '92763' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '105' , '86.065573770492' , '22' , '0' , '105.00' ) 29/07/2024 04:11:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2381' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 04:11:54 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' , '2381' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 29/07/2024 04:11:54 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 = '92764' 29/07/2024 04:11:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '92764' 29/07/2024 04:11:54 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 ( '92764' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '100.00' ) 29/07/2024 04:26:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '171' AND id_document != '89977' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 29/07/2024 04:26:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '171', document_date = '2024-01-17', 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 = '38.50', price_tax_excluded = '37.02', date_upd = NOW() WHERE id_document = '89977' 29/07/2024 04:26:37 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 = '89977' 29/07/2024 04:26:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '89977' 29/07/2024 04:26:37 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 ( '89977' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 29/07/2024 04:26:37 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 ( '89977' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 29/07/2024 04:26:37 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 ( '89977' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '21.50' ) 29/07/2024 04:27:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '549' AND id_document != '90488' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-24') 29/07/2024 04:27:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '549', document_date = '2024-02-24', 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 = '133.00', price_tax_excluded = '115.83', date_upd = NOW() WHERE id_document = '90488' 29/07/2024 04:27:56 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 = '90488' 29/07/2024 04:27:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '90488' 29/07/2024 04:27:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90488' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '16.00' ) 29/07/2024 04:27:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90488' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '8' , '-8' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '32.00' ) 29/07/2024 04:27:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90488' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 29/07/2024 04:27:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90488' , '778' , 'ASPERGES CON VASETTO O. S. - 1700 ' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 29/07/2024 04:28:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '623' AND id_document != '90589' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-02') 29/07/2024 04:28:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '623', document_date = '2024-03-02', 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 = '34.50', price_tax_excluded = '33.17', date_upd = NOW() WHERE id_document = '90589' 29/07/2024 04:28:37 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 = '90589' 29/07/2024 04:28:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '90589' 29/07/2024 04:28:37 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 ( '90589' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 29/07/2024 04:28:37 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 ( '90589' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 29/07/2024 04:28:37 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 ( '90589' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '21.50' ) 29/07/2024 04:58:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '99' AND id_document != '92576' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-07-09') 29/07/2024 04:58:26 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '99', document_date = '2024-07-09', document_letter = '', id_customer = '690', id_supplier = '', id_address = '4670873', address1 = 'VIA MUNICIPIO, 2 31014 COLLE UMBERTO', address2 = '', note = '', price_shipping = '5.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 = '35.60', price_tax_excluded = '35.60', date_upd = NOW() WHERE id_document = '92576' 29/07/2024 04:58:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92576' 29/07/2024 04:58:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '92576' 29/07/2024 04:58:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92576' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 29/07/2024 04:58:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92576' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '0' , '30.00' ) 29/07/2024 04:59:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '100' AND id_document != '92647' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-07-17') 29/07/2024 04:59:12 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '100', document_date = '2024-07-17', document_letter = '', id_customer = '2755', id_supplier = '', id_address = '4677545', address1 = 'VIA PRINCIPE DI PIEMONTE 04026 MINTURNO', address2 = '', note = '', price_shipping = '2.4', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '52.40', price_tax_excluded = '52.40', date_upd = NOW() WHERE id_document = '92647' 29/07/2024 04:59:12 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 = '92647' 29/07/2024 04:59:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '92647' 29/07/2024 04:59:12 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 ( '92647' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '0' , '50.00' ) 29/07/2024 06:04:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2382' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 06:04:05 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' , '2382' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '42.62' , NOW() , NOW() ) 29/07/2024 06:04:05 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 = '92765' 29/07/2024 06:04:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '92765' 29/07/2024 06:04:05 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 ( '92765' , '20078' , 'ROSARIO ARGENTO' , '1' , '-1' , '1' , '52.00' , '42.622950819672' , '22' , '0' , '52.00' ) 29/07/2024 06:47:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2383' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 29/07/2024 06:47: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 ( '11' , '2383' , '2024-07-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.70' , '3.85' , NOW() , NOW() ) 29/07/2024 06:47: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 = '92766' 29/07/2024 06:47:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '92766' 29/07/2024 06:47: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 ( '92766' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '6' , '-6' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.20' ) 29/07/2024 06:47: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 ( '92766' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' )