30/07/2024 08:54:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '11099/00/2024' , '2024-07-26' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '240.00' , '240.00' , NOW() , NOW() ) 30/07/2024 08:54:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92767' 30/07/2024 08:54:49 am >> DELETE FROM ps_document_detail WHERE id_document = '92767' 30/07/2024 08:54:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92767' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '80' , '80' , '4' , '5.00' , '5' , '0' , '40' , '240.0000' ) 30/07/2024 08:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22693' AND id_supplier = '38' 30/07/2024 08:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22693' , '38' , '1' ) 30/07/2024 09:38:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2384' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-30') 30/07/2024 09:38:10 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' , '2384' , '2024-07-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.23' , '47.23' , NOW() , NOW() ) 30/07/2024 09:38:10 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 = '92768' 30/07/2024 09:38:10 am >> DELETE FROM ps_document_detail WHERE id_document = '92768' 30/07/2024 09:38:10 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 ( '92768' , '21613' , 'RITO DELLA CONFERMAZIONE N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 30/07/2024 09:38:10 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 ( '92768' , '1090' , 'BIBBIA' , '3' , '-3' , '4' , '9.90' , '9.9' , '0' , '5' , '28.23' ) 30/07/2024 11:01:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2385' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-30') 30/07/2024 11:01: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' , '2385' , '2024-07-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.60' , '24.66' , NOW() , NOW() ) 30/07/2024 11:01: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 = '92769' 30/07/2024 11:01:39 am >> DELETE FROM ps_document_detail WHERE id_document = '92769' 30/07/2024 11:01: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 ( '92769' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '6.60' ) 30/07/2024 11:01: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 ( '92769' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 30/07/2024 11:01: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 ( '92769' , '9948' , 'SFERA DIAMETRO MM 100' , '2' , '-2' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '13.00' ) 30/07/2024 11:01: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 ( '92769' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 30/07/2024 11:36:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2386' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-30') 30/07/2024 11:36:25 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' , '2386' , '2024-07-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 30/07/2024 11:36:25 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 = '92770' 30/07/2024 11:36:25 am >> DELETE FROM ps_document_detail WHERE id_document = '92770' 30/07/2024 11:36:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92770' , '19116' , 'ROSARIO ALLA VERGINE DI LOURDES - 8978' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 30/07/2024 12:10:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2332' AND id_document != '92703' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-23') 30/07/2024 12:10:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2332', document_date = '2024-07-23', 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 = '14.30', price_tax_excluded = '12.01', date_upd = NOW() WHERE id_document = '92703' 30/07/2024 12:10: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 = '92703' 30/07/2024 12:10:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '92703' 30/07/2024 12:10: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 ( '92703' , '6075' , 'LOURDES BABY - 023 LDS/9 BB' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 30/07/2024 12:10: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 ( '92703' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 30/07/2024 12:10: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 ( '92703' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.8000' , '0.8' , '0' , '0' , '1.60' ) 30/07/2024 12:10: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 ( '92703' , '19231' , 'CARD CARLO ACUTIS - RN93' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 30/07/2024 12:10: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 ( '92703' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.30' ) 30/07/2024 03:16:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '375' , '2024-07-30' , '' , '0' , '81' , '2696' , 'C.SO UMBERTO I , 70 80034 MARIGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '84.00' , '84.00' , NOW() , NOW() ) 30/07/2024 03:16:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92771' 30/07/2024 03:16:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '92771' 30/07/2024 03:16:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92771' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '3200' , '3200' , '4' , '0.035' , '0.035' , '0' , '25' , '84.0000' ) 30/07/2024 03:16:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 30/07/2024 03:16:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 30/07/2024 05:48:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2387' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-30') 30/07/2024 05:48:39 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' , '2387' , '2024-07-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 30/07/2024 05:48:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92772' 30/07/2024 05:48:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '92772' 30/07/2024 05:48:39 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 ( '92772' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '45' , '36.885245901639' , '22' , '0' , '90.00' ) 30/07/2024 06:28:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2388' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-30') 30/07/2024 06:28: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' , '2388' , '2024-07-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 30/07/2024 06:28: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 = '92773' 30/07/2024 06:28:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '92773' 30/07/2024 06:28: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 ( '92773' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '18.00' ) 30/07/2024 07:03:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2389' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-30') 30/07/2024 07:03:39 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' , '2389' , '2024-07-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.50' , '25.00' , NOW() , NOW() ) 30/07/2024 07:03:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92774' 30/07/2024 07:03:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '92774' 30/07/2024 07:03:39 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 ( '92774' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '12.50' ) 30/07/2024 07:03:39 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 ( '92774' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '18.00' ) 30/07/2024 08:14:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2390' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-30') 30/07/2024 08:14:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2390' , '2024-07-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 30/07/2024 08:14:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92775' 30/07/2024 08:14:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '92775' 30/07/2024 08:14:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92775' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' )