04/06/2022 09:06:06 am >> SELECT document_num FROM ps_document WHERE document_num = '1777' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 09:06: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' , '1777' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '133.20' , '133.20' , NOW() , NOW() ) 04/06/2022 09:06: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 = '58594' 04/06/2022 09:06:06 am >> DELETE FROM ps_document_detail WHERE id_document = '58594' 04/06/2022 09:06: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 ( '58594' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '40' , '-40' , '4' , '3.50' , '3.5' , '0' , '5' , '133.20' ) 04/06/2022 09:06:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '11105' AND id_supplier = '' 04/06/2022 09:06:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11105' , '' , '1' ) 04/06/2022 09:08:33 am >> SELECT document_num FROM ps_document WHERE document_num = '96' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 09:08: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 ( '21' , '96' , '2022-06-04' , '' , '690' , '0' , '4670873' , 'VIA MUNICIPIO, 2 31014 COLLE UMBERTO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '42.10' , '42.10' , NOW() , NOW() ) 04/06/2022 09:08: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 = '58595' 04/06/2022 09:08:33 am >> DELETE FROM ps_document_detail WHERE id_document = '58595' 04/06/2022 09:08: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 ( '58595' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '0' , '0.18' , '0.18' , '' , '5' , '34.20' ) 04/06/2022 09:08: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 ( '58595' , '' , 'contrassegno' , '1' , '-1' , '0' , '2.9' , '2.9' , '' , '0' , '2.90' ) 04/06/2022 09:24:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1048' AND id_document != '54649' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-08') 04/06/2022 09:24:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1048', document_date = '2022-04-08', 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 = '597.68', price_tax_excluded = '519.94', date_upd = NOW() WHERE id_document = '54649' 04/06/2022 09:24:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '54649' 04/06/2022 09:24:25 am >> DELETE FROM ps_document_detail WHERE id_document = '54649' 04/06/2022 09:24: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 ( '54649' , '16842' , 'BOTTIGLIE PER ACQUA BENEDETTA - 100PZ ' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 04/06/2022 09:24:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '16842' AND id_supplier = '' 04/06/2022 09:24:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16842' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.7000' , '1.6346153846154' , '4' , '0' , '17.00' ) 04/06/2022 09:24:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 04/06/2022 09:24:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 04/06/2022 09:24:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 04/06/2022 09:24:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/06/2022 09:24:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 04/06/2022 09:24:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '12237' , 'TURIBOLO H28 CM' , '1' , '-1' , '1' , '165.0000' , '135.24590163934' , '22' , '0' , '165.00' ) 04/06/2022 09:24:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '12237' AND id_supplier = '' 04/06/2022 09:24:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12237' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '12238' , 'NAVETTA CLASSICA H13 CM' , '1' , '-1' , '1' , '48.0000' , '39.344262295082' , '22' , '0' , '48.00' ) 04/06/2022 09:24:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '12238' AND id_supplier = '' 04/06/2022 09:24:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12238' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '19115' , 'NOTTE DI PASSIONE - 8051' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 04/06/2022 09:24:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '19115' AND id_supplier = '' 04/06/2022 09:24:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19115' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '15272' , 'BEATITUDINI ALLA LUCE DELLA CROCE - VIA CRUCIS' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 04/06/2022 09:24:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '15272' AND id_supplier = '' 04/06/2022 09:24:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15272' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '17520' , 'LUMINO SMERALDO' , '100' , '-100' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '40.00' ) 04/06/2022 09:24:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '17520' AND id_supplier = '' 04/06/2022 09:24:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17520' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '110.00' ) 04/06/2022 09:24:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '' 04/06/2022 09:24:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/06/2022 09:24:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 04/06/2022 09:24:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.99' , '3.99' , '0' , '0' , '3.99' ) 04/06/2022 09:24:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/06/2022 09:24:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/06/2022 09:24: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 ( '54649' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '8' , '-8' , '4' , '18.5000' , '18.5' , '0' , '5' , '140.64' ) 04/06/2022 09:24:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 04/06/2022 09:24:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 04/06/2022 09:25:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1062' AND id_document != '54665' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-09') 04/06/2022 09:25:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1062', document_date = '2022-04-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '445.00', price_tax_excluded = '411.60', date_upd = NOW() WHERE id_document = '54665' 04/06/2022 09:25:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '54665' 04/06/2022 09:25:13 am >> DELETE FROM ps_document_detail WHERE id_document = '54665' 04/06/2022 09:25:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54665' , '7311' , 'OSTIA SOTTILE 74MM' , '14' , '-14' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '21.00' ) 04/06/2022 09:25:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 04/06/2022 09:25:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 04/06/2022 09:25:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54665' , '11264' , 'VESTINA BATTESIMALE' , '20' , '-20' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '40.00' ) 04/06/2022 09:25:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '11264' AND id_supplier = '' 04/06/2022 09:25:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11264' , '' , '1' ) 04/06/2022 09:25:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54665' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '24.00' ) 04/06/2022 09:25:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 04/06/2022 09:25:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 04/06/2022 09:25:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54665' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 04/06/2022 09:25:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 04/06/2022 09:25:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 04/06/2022 09:25:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54665' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '19.50' ) 04/06/2022 09:25:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 04/06/2022 09:25:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 04/06/2022 09:25:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54665' , '7673' , 'PARTICOLE MM38' , '22' , '-22' , '3' , '2.8000' , '2.6923076923077' , '4' , '0' , '61.60' ) 04/06/2022 09:25:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 04/06/2022 09:25:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 04/06/2022 09:25: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 ( '54665' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '25' , '-25' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '5.00' ) 04/06/2022 09:25:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 04/06/2022 09:25:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 04/06/2022 09:25: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 ( '54665' , '17940' , 'MIRACOLOSA - ISONZO 152bis' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/06/2022 09:25:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '17940' AND id_supplier = '' 04/06/2022 09:25:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17940' , '' , '1' ) 04/06/2022 09:25: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 ( '54665' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '30' , '-30' , '4' , '2.0000' , '2' , '0' , '5' , '57.00' ) 04/06/2022 09:25:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 04/06/2022 09:25:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 04/06/2022 09:25: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 ( '54665' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 04/06/2022 09:25:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '' 04/06/2022 09:25:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '' , '1' ) 04/06/2022 09:25: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 ( '54665' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.42' , '2.42' , '0' , '0' , '2.42' ) 04/06/2022 09:25:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/06/2022 09:25:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/06/2022 09:25: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 ( '54665' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/06/2022 09:25:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '9333' AND id_supplier = '' 04/06/2022 09:25:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9333' , '' , '1' ) 04/06/2022 09:25: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 ( '54665' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 04/06/2022 09:25:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '' 04/06/2022 09:25:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '' , '1' ) 04/06/2022 09:25: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 ( '54665' , '4372' , 'GESÙ BAMBINO - 265 ' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/06/2022 09:25:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '4372' AND id_supplier = '' 04/06/2022 09:25:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4372' , '' , '1' ) 04/06/2022 09:25:16 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 ( '54665' , '6872' , 'NASCITA DI GESÙ BAMBINO - 189' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 04/06/2022 09:25:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '6872' AND id_supplier = '' 04/06/2022 09:25:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6872' , '' , '1' ) 04/06/2022 09:25:16 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 ( '54665' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '5' , '104.50' ) 04/06/2022 09:25:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 04/06/2022 09:25:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 04/06/2022 09:25:16 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 ( '54665' , '16464' , 'CLERGY BLU NIDO DAPE ML 43 - C22' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 04/06/2022 09:25:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '16464' AND id_supplier = '' 04/06/2022 09:25:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16464' , '' , '1' ) 04/06/2022 09:25:16 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 ( '54665' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 04/06/2022 09:25:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 04/06/2022 09:25:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 04/06/2022 09:25:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1176' AND id_document != '55309' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-19') 04/06/2022 09:25:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1176', document_date = '2022-04-19', 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.70', price_tax_excluded = '56.50', date_upd = NOW() WHERE id_document = '55309' 04/06/2022 09:25:56 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 = '55309' 04/06/2022 09:25:56 am >> DELETE FROM ps_document_detail WHERE id_document = '55309' 04/06/2022 09:25:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55309' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '9.84' , '9.84' , '0' , '0' , '9.84' ) 04/06/2022 09:25:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/06/2022 09:25:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/06/2022 09:25:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55309' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 04/06/2022 09:25:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '8368' AND id_supplier = '' 04/06/2022 09:25:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8368' , '' , '1' ) 04/06/2022 09:25:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55309' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 04/06/2022 09:25:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 04/06/2022 09:25:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 04/06/2022 09:25:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55309' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '2' , '-2' , '4' , '18.50' , '18.5' , '0' , '5' , '35.16' ) 04/06/2022 09:25:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 04/06/2022 09:25:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 04/06/2022 09:26:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1365' AND id_document != '56553' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02') 04/06/2022 09:26:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1365', document_date = '2022-05-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 = '89.25', price_tax_excluded = '89.25', date_upd = NOW() WHERE id_document = '56553' 04/06/2022 09:26:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56553' 04/06/2022 09:26:48 am >> DELETE FROM ps_document_detail WHERE id_document = '56553' 04/06/2022 09:26:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56553' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 04/06/2022 09:26:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '' 04/06/2022 09:26:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '' , '1' ) 04/06/2022 09:26:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56553' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '3.26' , '3.26' , '0' , '0' , '3.26' ) 04/06/2022 09:26:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 04/06/2022 09:26:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 04/06/2022 09:26: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 ( '56553' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '3' , '-3' , '4' , '18.50' , '18.5' , '0' , '5' , '52.74' ) 04/06/2022 09:26:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 04/06/2022 09:26:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 04/06/2022 09:28:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1255' AND id_document != '56427' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-26') 04/06/2022 09:28:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1255', document_date = '2022-04-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.02', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '20.00', date_upd = NOW() WHERE id_document = '56427' 04/06/2022 09:28:04 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 = '56427' 04/06/2022 09:28:04 am >> DELETE FROM ps_document_detail WHERE id_document = '56427' 04/06/2022 09:28:04 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 ( '56427' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 04/06/2022 09:28:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 04/06/2022 09:28:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 04/06/2022 09:28:04 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 ( '56427' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '0.80' , '0.8' , '0' , '0' , '2.40' ) 04/06/2022 09:28:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 04/06/2022 09:28:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 04/06/2022 09:35:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1778' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 09:35: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' , '1778' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '1.20' , NOW() , NOW() ) 04/06/2022 09:35: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 = '58596' 04/06/2022 09:35:02 am >> DELETE FROM ps_document_detail WHERE id_document = '58596' 04/06/2022 09:35: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 ( '58596' , '19489' , 'ATTO DI CONSACRAZIONE A MARIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '1.20' , '1.2' , '0' , '0' , '1.20' ) 04/06/2022 09:35:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19489' AND id_supplier = '' 04/06/2022 09:35:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19489' , '' , '1' ) 04/06/2022 09:36:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1462' AND id_document != '56673' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 04/06/2022 09:36:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1462', document_date = '2022-05-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '56673' 04/06/2022 09:36: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 = '56673' 04/06/2022 09:36:01 am >> DELETE FROM ps_document_detail WHERE id_document = '56673' 04/06/2022 09:36: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 ( '56673' , '18133' , 'CROCE SAN BENEDETTO CM 11 - CSB2' , '1' , '-1' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '9.50' ) 04/06/2022 09:36:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18133' AND id_supplier = '' 04/06/2022 09:36:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18133' , '' , '1' ) 04/06/2022 09:36: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 ( '56673' , '16917' , 'CROCE SAN BENEDETTO CON BASE - PG375-B' , '2' , '-2' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '32.00' ) 04/06/2022 09:36:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '16917' AND id_supplier = '' 04/06/2022 09:36:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16917' , '' , '1' ) 04/06/2022 09:36: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 ( '56673' , '13354' , 'ROSARIO LEGNO S. BENEDETTO + SCATOLINA' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 04/06/2022 09:36:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '13354' AND id_supplier = '' 04/06/2022 09:36:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13354' , '' , '1' ) 04/06/2022 09:36: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 ( '56673' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 04/06/2022 09:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 04/06/2022 09:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 04/06/2022 09:36: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 ( '56673' , '9148' , 'ROSARIO LEGNO S. BENEDETTO ' , '3' , '-3' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '15.00' ) 04/06/2022 09:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '9148' AND id_supplier = '' 04/06/2022 09:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9148' , '' , '1' ) 04/06/2022 09:36: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 ( '56673' , '18893' , 'ROSARIO PIETRA - R472' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 04/06/2022 09:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18893' AND id_supplier = '' 04/06/2022 09:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18893' , '' , '1' ) 04/06/2022 09:36: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 ( '56673' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 04/06/2022 09:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '3104' AND id_supplier = '' 04/06/2022 09:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3104' , '' , '1' ) 04/06/2022 09:36: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 ( '56673' , '9149' , 'ROSARIO LEGNO S. BENEDETTO CUBO ' , '2' , '-2' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '8.00' ) 04/06/2022 09:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '9149' AND id_supplier = '' 04/06/2022 09:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9149' , '' , '1' ) 04/06/2022 09:36: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 ( '56673' , '13363' , 'CORONA MM 6 ' , '5' , '-5' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '14.50' ) 04/06/2022 09:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '13363' AND id_supplier = '' 04/06/2022 09:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13363' , '' , '1' ) 04/06/2022 09:36: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 ( '56673' , '19233' , 'ANELLO CON MIRACOLOSA - RA086' , '1' , '-1' , '1' , '14.5' , '11.885245901639' , '22' , '0' , '14.50' ) 04/06/2022 09:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19233' AND id_supplier = '' 04/06/2022 09:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19233' , '' , '1' ) 04/06/2022 09:43:36 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 ( '34' , '8/2022' , '2022-06-04' , '2022' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '223.26' , '183.00' , NOW() , NOW() ) 04/06/2022 09:43:36 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 = '58597' 04/06/2022 09:43:36 am >> DELETE FROM ps_document_detail WHERE id_document = '58597' 04/06/2022 09:43:36 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 ( '58597' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '30' , '0' , '1' , '10' , '8.1967213114754' , '22' , '50' , '183.0000' ) 04/06/2022 09:43:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '50' 04/06/2022 09:43:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '50' , '1' ) 04/06/2022 09:43:36 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 ( '58597' , '7202' , 'ARTICOLI RELIGIOSI' , '30' , '0' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '21.9600' ) 04/06/2022 09:43:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '50' 04/06/2022 09:43:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '50' , '1' ) 04/06/2022 09:43:55 am >> UPDATE ps_document SET id_document_type = '34', document_num = '8/2022', document_date = '2022-05-31', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '2645', address1 = 'VIA P. G. SEMERIA, 19 70014 CONVERSANO', address2 = '', note = '', price_shipping = '15.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '223.26', price_tax_excluded = '183.00', date_upd = NOW() WHERE id_document = '58597' 04/06/2022 09:43:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58597' 04/06/2022 09:43:55 am >> DELETE FROM ps_document_detail WHERE id_document = '58597' 04/06/2022 09:43:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58597' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '30' , '-30' , '1' , '10.0000' , '8.1967213114754' , '22' , '50' , '183.00' ) 04/06/2022 09:43:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 04/06/2022 09:43:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 04/06/2022 09:43:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58597' , '7202' , 'ARTICOLI RELIGIOSI' , '30' , '-30' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '21.96' ) 04/06/2022 09:43:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/06/2022 09:43:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/06/2022 10:08:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1779' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 10:08: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' , '1779' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 04/06/2022 10:08: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 = '58598' 04/06/2022 10:08:45 am >> DELETE FROM ps_document_detail WHERE id_document = '58598' 04/06/2022 10:08: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 ( '58598' , '18663' , 'CUORE IN MET. LISCIO - 18074MET' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 04/06/2022 10:08:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '18663' AND id_supplier = '' 04/06/2022 10:08:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18663' , '' , '1' ) 04/06/2022 10:11:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1780' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 10:11: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' , '1780' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.50' , '12.70' , NOW() , NOW() ) 04/06/2022 10:11: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 = '58599' 04/06/2022 10:11:15 am >> DELETE FROM ps_document_detail WHERE id_document = '58599' 04/06/2022 10:11: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 ( '58599' , '18764' , 'STELLARIO PLEX CM 20' , '1' , '-1' , '1' , '15.50' , '12.704918032787' , '22' , '0' , '15.50' ) 04/06/2022 10:11:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '18764' AND id_supplier = '' 04/06/2022 10:11:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18764' , '' , '1' ) 04/06/2022 10:14:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 10:14: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' , '1781' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.45' , '19.22' , NOW() , NOW() ) 04/06/2022 10:14: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 = '58600' 04/06/2022 10:14:25 am >> DELETE FROM ps_document_detail WHERE id_document = '58600' 04/06/2022 10:14: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 ( '58600' , '12407' , 'SEME DELLA FEDE ORO - 10X15' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 04/06/2022 10:14:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '12407' AND id_supplier = '' 04/06/2022 10:14:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12407' , '' , '1' ) 04/06/2022 10:14: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 ( '58600' , '9799' , 'SEGNALIBRO M. TERESA - 126' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 04/06/2022 10:14:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '9799' AND id_supplier = '' 04/06/2022 10:14:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9799' , '' , '1' ) 04/06/2022 10:14: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 ( '58600' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 04/06/2022 10:14:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 04/06/2022 10:14:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 04/06/2022 10:14: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 ( '58600' , '1737' , 'CARTA DI IDENTITÀ - RP66' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 04/06/2022 10:14:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '1737' AND id_supplier = '' 04/06/2022 10:14:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1737' , '' , '1' ) 04/06/2022 10:28:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 10:28:46 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' , '1782' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 04/06/2022 10:28:46 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 = '58601' 04/06/2022 10:28:46 am >> DELETE FROM ps_document_detail WHERE id_document = '58601' 04/06/2022 10:28:46 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 ( '58601' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 04/06/2022 10:28:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/06/2022 10:28:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/06/2022 11:20:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 11:20:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1783' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '939.42' , '925.35' , NOW() , NOW() ) 04/06/2022 11:20: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 = '58602' 04/06/2022 11:20:49 am >> DELETE FROM ps_document_detail WHERE id_document = '58602' 04/06/2022 11:20: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 ( '58602' , '17520' , 'LUMINO SMERALDO' , '90' , '-90' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '36.00' ) 04/06/2022 11:20:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '17520' AND id_supplier = '' 04/06/2022 11:20:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17520' , '' , '1' ) 04/06/2022 11:20: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 ( '58602' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '49' , '-49' , '4' , '18.50' , '18.5' , '0' , '5' , '861.42' ) 04/06/2022 11:20:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 04/06/2022 11:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 04/06/2022 11:20: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 ( '58602' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7' , '5.7377049180328' , '22' , '0' , '42.00' ) 04/06/2022 11:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 04/06/2022 11:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 04/06/2022 11:29:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1784' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 11:29: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' , '1784' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 04/06/2022 11:29: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 = '58603' 04/06/2022 11:29:10 am >> DELETE FROM ps_document_detail WHERE id_document = '58603' 04/06/2022 11:29: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 ( '58603' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 04/06/2022 11:29:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/06/2022 11:29:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/06/2022 11:33:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1785' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 11:33: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' , '1785' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.20' , '26.39' , NOW() , NOW() ) 04/06/2022 11:33: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 = '58604' 04/06/2022 11:33:15 am >> DELETE FROM ps_document_detail WHERE id_document = '58604' 04/06/2022 11:33: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 ( '58604' , '7202' , 'ARTICOLI RELIGIOSI' , '23' , '-23' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '32.20' ) 04/06/2022 11:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/06/2022 11:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/06/2022 11:50:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1730' AND id_document != '58537' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-01') 04/06/2022 11:50:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1730', document_date = '2022-06-01', 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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '58537' 04/06/2022 11:50: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 = '58537' 04/06/2022 11:50:35 am >> DELETE FROM ps_document_detail WHERE id_document = '58537' 04/06/2022 11:50: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 ( '58537' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 04/06/2022 11:50:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/06/2022 11:50:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/06/2022 11:50: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 ( '58537' , '2425' , 'COLLETTO DOPPIO CM 3,5 IN LINO' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 04/06/2022 11:50:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '2425' AND id_supplier = '' 04/06/2022 11:50:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2425' , '' , '1' ) 04/06/2022 11:51:47 am >> SELECT document_num FROM ps_document WHERE document_num = '828' AND id_document != '53353' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-21') 04/06/2022 11:51:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '828', document_date = '2022-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '279.00', price_tax_excluded = '228.69', date_upd = NOW() WHERE id_document = '53353' 04/06/2022 11:51:47 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 = '53353' 04/06/2022 11:51:47 am >> DELETE FROM ps_document_detail WHERE id_document = '53353' 04/06/2022 11:51:47 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 ( '53353' , '16842' , 'BOTTIGLIE PER ACQUA BENEDETTA - 100PZ ' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 04/06/2022 11:51:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '16842' AND id_supplier = '' 04/06/2022 11:51:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16842' , '' , '1' ) 04/06/2022 11:51:47 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 ( '53353' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 04/06/2022 11:51:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '15331' AND id_supplier = '' 04/06/2022 11:51:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15331' , '' , '1' ) 04/06/2022 11:51:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53353' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '104' , '85.245901639344' , '22' , '0' , '104.00' ) 04/06/2022 11:51:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 04/06/2022 11:51:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 04/06/2022 12:02:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 12:02:14 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' , '1786' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.90' , '10.92' , NOW() , NOW() ) 04/06/2022 12:02:14 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 = '58605' 04/06/2022 12:02:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '58605' 04/06/2022 12:02:14 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 ( '58605' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 04/06/2022 12:02:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14063' AND id_supplier = '' 04/06/2022 12:02:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14063' , '' , '1' ) 04/06/2022 12:02:14 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 ( '58605' , '9157' , 'ROSARIO MEDITATO SUL S. CUORE DI GESÙ - M. RATTA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 04/06/2022 12:02:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9157' AND id_supplier = '' 04/06/2022 12:02:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9157' , '' , '1' ) 04/06/2022 12:17:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 12:17:26 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' , '1787' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.90' , '5.27' , NOW() , NOW() ) 04/06/2022 12:17: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 = '58606' 04/06/2022 12:17:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '58606' 04/06/2022 12:17:27 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 ( '58606' , '11888' , 'CORONA GESU BAMBINO DI PRAGA' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/06/2022 12:17:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11888' AND id_supplier = '' 04/06/2022 12:17:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11888' , '' , '1' ) 04/06/2022 12:17:27 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 ( '58606' , '11376' , 'VIENI SPIRITO SANTO' , '12' , '-12' , '4' , '0.20' , '0.2' , '0' , '0' , '2.40' ) 04/06/2022 12:17:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11376' AND id_supplier = '' 04/06/2022 12:17:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11376' , '' , '1' ) 04/06/2022 12:21:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1684' AND id_document != '58481' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 04/06/2022 12:21:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1684', document_date = '2022-05-27', 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 = '2.50', price_tax_excluded = '2.05', date_upd = NOW() WHERE id_document = '58481' 04/06/2022 12:21: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 = '58481' 04/06/2022 12:21:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '58481' 04/06/2022 12:21: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 ( '58481' , '18318' , 'CONFEZIONE BRACCIALE MULTICOLORE COMUNIONE - 2377/K0001' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 04/06/2022 12:21:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18318' AND id_supplier = '' 04/06/2022 12:21:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18318' , '' , '1' ) 04/06/2022 12:35:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 12:35:30 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' , '1788' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 04/06/2022 12:35:30 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 = '58607' 04/06/2022 12:35:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '58607' 04/06/2022 12:35:30 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 ( '58607' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/06/2022 12:35:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 04/06/2022 12:35:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 04/06/2022 12:45:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1789' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 12:45:56 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' , '1789' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 04/06/2022 12:45: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 = '58608' 04/06/2022 12:45:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '58608' 04/06/2022 12:45: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 ( '58608' , '15781' , 'VEGLIA DI PENTECOSTE' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 04/06/2022 12:45:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15781' AND id_supplier = '' 04/06/2022 12:45:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15781' , '' , '1' ) 04/06/2022 12:47:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1790' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 12: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' , '1790' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '10.82' , NOW() , NOW() ) 04/06/2022 12: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 = '58609' 04/06/2022 12:47:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '58609' 04/06/2022 12: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 ( '58609' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '4' , '-4' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '13.20' ) 04/06/2022 12:47:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 04/06/2022 12:47:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 04/06/2022 12:54:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1791' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 04/06/2022 12:54:41 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' , '1791' , '2022-06-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '350.00' , '286.89' , NOW() , NOW() ) 04/06/2022 12:54:41 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 = '58610' 04/06/2022 12:54:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '58610' 04/06/2022 12:54:41 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 ( '58610' , '16500' , 'IMMACOLATA CONCEZIONE CM 35' , '1' , '-1' , '1' , '350' , '286.88524590164' , '22' , '0' , '350.00' ) 04/06/2022 12:54:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16500' AND id_supplier = '' 04/06/2022 12:54:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16500' , '' , '1' )