31/05/2024 09:10:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1819' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 09:10:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1819' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 31/05/2024 09:10:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92086' 31/05/2024 09:10:30 am >> DELETE FROM ps_document_detail WHERE id_document = '92086' 31/05/2024 09:10:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92086' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 31/05/2024 09:27:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1820' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 09:27:48 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' , '1820' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 31/05/2024 09:27: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 = '92087' 31/05/2024 09:27:48 am >> DELETE FROM ps_document_detail WHERE id_document = '92087' 31/05/2024 09:27: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 ( '92087' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 31/05/2024 10:00:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1821' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 10:00:58 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' , '1821' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.90' , '10.90' , NOW() , NOW() ) 31/05/2024 10:00:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92088' 31/05/2024 10:00:58 am >> DELETE FROM ps_document_detail WHERE id_document = '92088' 31/05/2024 10:00:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92088' , '20326' , 'SEGRETO DI MIO FIGLIO - A. ACUTIS' , '1' , '-1' , '4' , '10.90' , '10.9' , '0' , '0' , '10.90' ) 31/05/2024 10:04:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400029246' AND id_product != '9688' AND ean13 != '' 31/05/2024 10:04:29 am >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '8058400029246', date_upd = NOW() WHERE id_product = '9688' 31/05/2024 10:04:29 am >> UPDATE ps_product_lang SET name = 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ', description = '' WHERE id_product = '9688' 31/05/2024 10:04:29 am >> UPDATE ps_product SET wholesale_price = '1.19', on_sale = '0', price = '2.459016393442623' WHERE id_product = '9688' 31/05/2024 10:04:29 am >> UPDATE ps_product_shop SET wholesale_price = '1.19', price = '2.459016393442623', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9688' 31/05/2024 10:04:29 am >> DELETE FROM ps_specific_price WHERE id_product = '9688' 31/05/2024 10:34:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1822' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 10:34:52 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' , '1822' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 31/05/2024 10:34:52 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 = '92089' 31/05/2024 10:34:52 am >> DELETE FROM ps_document_detail WHERE id_document = '92089' 31/05/2024 10:34:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92089' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 31/05/2024 10:56:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '1038' , '2024-05-30' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '2.09' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '420.69' , '420.69' , NOW() , NOW() ) 31/05/2024 10:56:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92090' 31/05/2024 10:56:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92090' 31/05/2024 10:56:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92090' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '46' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '418.6000' ) 31/05/2024 10:56:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '22214' AND id_supplier = '47' 31/05/2024 10:56:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22214' , '47' , '1' ) 31/05/2024 10:58:39 am >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '92026' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-05-27') 31/05/2024 10:58:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '15', document_date = '2024-05-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2642', address1 = 'V.LE BACCHIGLIONE, 20 20139 MILANO', address2 = '', note = 'RESA - RICEVUTA N.C. 30/05/2024 N. 1039', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '81.55', price_tax_excluded = '81.55', date_upd = NOW() WHERE id_document = '92026' 31/05/2024 10:58: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 = '92026' 31/05/2024 10:58:39 am >> DELETE FROM ps_document_detail WHERE id_document = '92026' 31/05/2024 10:58: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 ( '92026' , '14547' , 'SUOR FAUSTINA E IL VOLTO ... - D. MURGIA' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 31/05/2024 10:58: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 ( '92026' , '17494' , 'SAN PADRE PIO MIRACOLO EUCARISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 31/05/2024 10:58: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 ( '92026' , '21603' , 'SAN PIO DA PIETRALCINA MAESTRO DI VITA - GUARINO/STANZIONE' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 31/05/2024 10:58: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 ( '92026' , '18952' , 'SFIDA DELLA SPERANZA - L. ROMANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 31/05/2024 10:58: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 ( '92026' , '19975' , 'POSTINO DI DIO - A. LUCIANI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '30' , '13.30' ) 31/05/2024 10:58: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 ( '92026' , '19833' , 'PADRE PIO MODELLO DI SANTITA - GUARINO/STANZIONE' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 31/05/2024 10:58: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 ( '92026' , '3295' , 'DAL SINAI AL CALVARIO - C. RIVAS' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '30' , '2.10' ) 31/05/2024 10:58: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 ( '92026' , '19634' , 'IN CAMMINO ALLA RICERCA DELLA VERITA - RATZINGER - P. ODIFREDDI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '30' , '12.95' ) 31/05/2024 10:58: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 ( '92026' , '20019' , 'DARE IL CUORE AI MISERI - G. PAIS' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 31/05/2024 11:10:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1376' AND id_document != '91547' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 31/05/2024 11:10:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1376', document_date = '2024-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 = '72.00', price_tax_excluded = '59.38', date_upd = NOW() WHERE id_document = '91547' 31/05/2024 11:10:40 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 = '91547' 31/05/2024 11:10:40 am >> DELETE FROM ps_document_detail WHERE id_document = '91547' 31/05/2024 11:10:40 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 ( '91547' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 31/05/2024 11:10:40 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 ( '91547' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 31/05/2024 11:10:40 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 ( '91547' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '25' , '-25' , '1' , '1' , '0.81967213114754' , '22' , '0' , '25.00' ) 31/05/2024 11:11:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1451' AND id_document != '91640' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 31/05/2024 11:11:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1451', document_date = '2024-05-06', 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 = '61.90', price_tax_excluded = '51.98', date_upd = NOW() WHERE id_document = '91640' 31/05/2024 11:11:05 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 = '91640' 31/05/2024 11:11:05 am >> DELETE FROM ps_document_detail WHERE id_document = '91640' 31/05/2024 11:11:05 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 ( '91640' , '3636' , 'DON BOSCO LA MAGNIFICA STORIA' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '0' , '6.90' ) 31/05/2024 11:11:05 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 ( '91640' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '55' , '-55' , '1' , '1' , '0.81967213114754' , '22' , '0' , '55.00' ) 31/05/2024 11:17:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1823' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 11:17:19 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' , '1823' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 31/05/2024 11:17:19 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 = '92091' 31/05/2024 11:17:19 am >> DELETE FROM ps_document_detail WHERE id_document = '92091' 31/05/2024 11:17:19 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 ( '92091' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 31/05/2024 11:19:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1824' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 11:19:47 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' , '1824' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.75' , '61.75' , NOW() , NOW() ) 31/05/2024 11:19: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 = '92092' 31/05/2024 11:19:47 am >> DELETE FROM ps_document_detail WHERE id_document = '92092' 31/05/2024 11:19: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 ( '92092' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '13' , '-13' , '4' , '5.00' , '5' , '0' , '5' , '61.75' ) 31/05/2024 11:21:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1825' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 11:21:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1825' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.10' , '2.10' , NOW() , NOW() ) 31/05/2024 11:21: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 = '92093' 31/05/2024 11:21:55 am >> DELETE FROM ps_document_detail WHERE id_document = '92093' 31/05/2024 11:21: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 ( '92093' , '19323' , 'PREGHIERE DI SANTA BRIGIDA' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 31/05/2024 11:33:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1826' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 11:33:34 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' , '1826' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 31/05/2024 11:33:34 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 = '92094' 31/05/2024 11:33:34 am >> DELETE FROM ps_document_detail WHERE id_document = '92094' 31/05/2024 11:33:34 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 ( '92094' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 31/05/2024 11:34:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1827' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 11:34:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1827' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.00' , '74.59' , NOW() , NOW() ) 31/05/2024 11:34:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92095' 31/05/2024 11:34:00 am >> DELETE FROM ps_document_detail WHERE id_document = '92095' 31/05/2024 11:34: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 ( '92095' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 31/05/2024 11:34: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 ( '92095' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '30' , '-30' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '36.00' ) 31/05/2024 11:34: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 ( '92095' , '7910' , 'PERGAMENE - 1A COMUNIONE MOD. A' , '30' , '-30' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '15.00' ) 31/05/2024 11:34:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1828' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 11:34:14 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' , '1828' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 31/05/2024 11:34:14 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 = '92096' 31/05/2024 11:34:14 am >> DELETE FROM ps_document_detail WHERE id_document = '92096' 31/05/2024 11:34: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 ( '92096' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '55' , '45.081967213115' , '22' , '0' , '110.00' ) 31/05/2024 11:56:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1829' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 11:56:32 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' , '1829' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '212.50' , '174.18' , NOW() , NOW() ) 31/05/2024 11:56:32 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 = '92097' 31/05/2024 11:56:32 am >> DELETE FROM ps_document_detail WHERE id_document = '92097' 31/05/2024 11:56:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92097' , '19594' , 'POLO JERSEY COTONE 100%' , '4' , '-4' , '1' , '40' , '32.786885245902' , '22' , '0' , '160.00' ) 31/05/2024 11:56:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92097' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 31/05/2024 11:56:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92097' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 31/05/2024 11:56:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92097' , '15484' , 'CROCE - 076BIS ALV.' , '5' , '-5' , '1' , '1.90' , '1.5573770491803' , '22' , '0' , '9.50' ) 31/05/2024 12:04:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1830' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 12:04:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1830' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 31/05/2024 12:04: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 = '92098' 31/05/2024 12:04:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '92098' 31/05/2024 12:04: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 ( '92098' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '2' , '-2' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '36.00' ) 31/05/2024 12:16:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1831' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 12:16:02 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' , '1831' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '540.00' , '442.62' , NOW() , NOW() ) 31/05/2024 12:16:02 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 = '92099' 31/05/2024 12:16:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '92099' 31/05/2024 12:16:02 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 ( '92099' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '540' , '442.62295081967' , '22' , '0' , '540.00' ) 31/05/2024 12:30:06 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 ( '32' , '2024-FV000865' , '2024-05-31' , '' , '2983' , '79' , '4669436' , 'VIA DELLA POSTA 00120 CITTA\\\' DEL VATICANO' , '' , '' , '13' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '402.48' , '402.48' , NOW() , NOW() ) 31/05/2024 12:30:06 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 = '92100' 31/05/2024 12:30:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '92100' 31/05/2024 12:30:06 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 ( '92100' , '22507' , 'SPES NON CONFUNDIT' , '30' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '33.00' ) 31/05/2024 12:30:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 31/05/2024 12:30:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 31/05/2024 12:30:06 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 ( '92100' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '15' , '0' , '4' , '2.8000' , '2.8' , '0' , '45' , '23.10' ) 31/05/2024 12:30:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22529' AND id_supplier = '79' 31/05/2024 12:30:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22529' , '79' , '1' ) 31/05/2024 12:30:06 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 ( '92100' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '5' , '0' , '4' , '2.8000' , '2.8' , '0' , '45' , '7.70' ) 31/05/2024 12:30:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22148' AND id_supplier = '79' 31/05/2024 12:30:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22148' , '79' , '1' ) 31/05/2024 12:30:06 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 ( '92100' , '17862' , 'DALL\'INFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '45' , '6.60' ) 31/05/2024 12:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17862' AND id_supplier = '79' 31/05/2024 12:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17862' , '79' , '1' ) 31/05/2024 12:30:07 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 ( '92100' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '10' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '42.00' ) 31/05/2024 12:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '79' 31/05/2024 12:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '79' , '1' ) 31/05/2024 12:30:07 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 ( '92100' , '9013' , 'RITO DELLINIZIAZIONE CRISTIANA DEGLI ADULTI' , '1' , '0' , '4' , '20.6600' , '20.66' , '0' , '30' , '14.46' ) 31/05/2024 12:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9013' AND id_supplier = '79' 31/05/2024 12:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9013' , '79' , '1' ) 31/05/2024 12:30:07 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 ( '92100' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '3' , '0' , '4' , '2.8000' , '2.8' , '0' , '45' , '4.62' ) 31/05/2024 12:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22148' AND id_supplier = '79' 31/05/2024 12:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22148' , '79' , '1' ) 31/05/2024 12:30:07 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 ( '92100' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '2' , '0' , '4' , '25.0000' , '25' , '0' , '35' , '32.50' ) 31/05/2024 12:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '79' 31/05/2024 12:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '79' , '1' ) 31/05/2024 12:30:07 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 ( '92100' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 31/05/2024 12:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21509' AND id_supplier = '79' 31/05/2024 12:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21509' , '79' , '1' ) 31/05/2024 12:30:07 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 ( '92100' , '22112' , 'LITURGIA DELLE ORE VOL. III - N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 31/05/2024 12:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22112' AND id_supplier = '79' 31/05/2024 12:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22112' , '79' , '1' ) 31/05/2024 12:30:07 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 ( '92100' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 31/05/2024 12:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2549' AND id_supplier = '79' 31/05/2024 12:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2549' , '79' , '1' ) 31/05/2024 12:30:07 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 ( '92100' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '2' , '0' , '4' , '90.0000' , '90' , '0' , '35' , '117.00' ) 31/05/2024 12:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '79' 31/05/2024 12:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '79' , '1' ) 31/05/2024 12:30:07 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 ( '92100' , '10565' , 'TEOLOGIA DELLA LITURGIA - J. RATZINGER' , '1' , '0' , '4' , '55.0000' , '55' , '0' , '45' , '30.25' ) 31/05/2024 12:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10565' AND id_supplier = '79' 31/05/2024 12:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10565' , '79' , '1' ) 31/05/2024 12:37:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1831' AND id_document != '92099' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 12:37:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1831', document_date = '2024-05-31', 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 = '540.00', price_tax_excluded = '442.62', date_upd = NOW() WHERE id_document = '92099' 31/05/2024 12:37:55 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 = '92099' 31/05/2024 12:37:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '92099' 31/05/2024 12:37:55 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 ( '92099' , '8191' , 'PORTAPILLOLA OVALE GRANDE - 299/K52 - OGGETTI' , '60' , '-60' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '228.00' ) 31/05/2024 12:37:55 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 ( '92099' , '22671' , 'ROSARIO IN METALLO' , '60' , '-60' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '240.00' ) 31/05/2024 12:37:55 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 ( '92099' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '72' , '59.016393442623' , '22' , '0' , '72.00' ) 31/05/2024 12:40:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1785' AND id_document != '92047' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 31/05/2024 12:40:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1785', document_date = '2024-05-28', 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 = '39.00', price_tax_excluded = '37.50', date_upd = NOW() WHERE id_document = '92047' 31/05/2024 12:40:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92047' 31/05/2024 12:40:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '92047' 31/05/2024 12:40:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92047' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' , '1.75' , '1.6826923076923' , '4' , '0' , '35.00' ) 31/05/2024 12:40:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92047' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 31/05/2024 12:41:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1832' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 12:41:55 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' , '1832' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 31/05/2024 12:41:55 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 = '92101' 31/05/2024 12:41:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '92101' 31/05/2024 12:41:55 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 ( '92101' , '545' , 'AMPOLLE STYLE CON RICAMBIO - CC100 - 1507' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 31/05/2024 12:43:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '91941' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-22') 31/05/2024 12:43:01 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2024-05-22', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '260.90', price_tax_excluded = '223.15', date_upd = NOW() WHERE id_document = '91941' 31/05/2024 12:43:02 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 = '91941' 31/05/2024 12:43:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '91941' 31/05/2024 12:43:02 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 ( '91941' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 31/05/2024 12:43:02 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 ( '91941' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 31/05/2024 12:43:02 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 ( '91941' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 31/05/2024 12:43:02 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 ( '91941' , '22040' , 'LOTTANDO INSIEME A GIOBBE - P. RIBET' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 31/05/2024 12:43:02 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 ( '91941' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 31/05/2024 12:43:02 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 ( '91941' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 31/05/2024 12:43:02 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 ( '91941' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 31/05/2024 12:43:02 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 ( '91941' , '22314' , 'CASULA MARIANA - C1P855' , '1' , '-1' , '1' , '90.00' , '73.770491803279' , '22' , '0' , '90.00' ) 31/05/2024 12:43:02 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 ( '91941' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 31/05/2024 12:44:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1833' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 12:44:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1833' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.34' , '20.34' , NOW() , NOW() ) 31/05/2024 12:44:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92102' 31/05/2024 12:44:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '92102' 31/05/2024 12:44:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92102' , '22511' , 'VIVE - CD' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 31/05/2024 12:44:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92102' , '22512' , 'VIVE - AGGIUNTA CANTI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 31/05/2024 12:52:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1834' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 12:52:50 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' , '1834' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 31/05/2024 12:52:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92103' 31/05/2024 12:52:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '92103' 31/05/2024 12:52:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92103' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 31/05/2024 01:02:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1835' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 01:02: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' , '1835' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.28' , '8.28' , NOW() , NOW() ) 31/05/2024 01:02: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 = '92104' 31/05/2024 01:02:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '92104' 31/05/2024 01:02: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 ( '92104' , '22322' , 'PAROLA E PREGHIERA - GIU 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 31/05/2024 01:02: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 ( '92104' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 31/05/2024 01:02:31 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 ( '92104' , '22557' , 'PAROLA E PREGHIERA - AGO 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 31/05/2024 03:23:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1836' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 03:23: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' , '1836' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.40' , '30.53' , NOW() , NOW() ) 31/05/2024 03:23: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 = '92105' 31/05/2024 03:23:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '92105' 31/05/2024 03:23:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92105' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 31/05/2024 03:23:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92105' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '4' , '-4' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '4.40' ) 31/05/2024 03:43:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1832' AND id_document != '92101' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 03:43:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1832', document_date = '2024-05-31', 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 = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '92101' 31/05/2024 03:43:07 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 = '92101' 31/05/2024 03:43:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '92101' 31/05/2024 03:43:07 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 ( '92101' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 31/05/2024 03:43:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000580' AND id_product != '8191' AND ean13 != '' 31/05/2024 03:43:24 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2014', ean13 = '000580', date_upd = NOW() WHERE id_product = '8191' 31/05/2024 03:43:24 pm >> UPDATE ps_product_lang SET name = 'PORTAPILLOLA OVALE GRANDE - 299/K52 ', description = '' WHERE id_product = '8191' 31/05/2024 03:43:24 pm >> UPDATE ps_product SET wholesale_price = '2.00', on_sale = '0', price = '3.1148' WHERE id_product = '8191' 31/05/2024 03:43:24 pm >> UPDATE ps_product_shop SET wholesale_price = '2.00', price = '3.1148', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8191' 31/05/2024 03:43:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '8191' 31/05/2024 03:44:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1827' AND id_document != '92095' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 03:44:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1827', document_date = '2024-05-31', 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 = '91.00', price_tax_excluded = '74.59', date_upd = NOW() WHERE id_document = '92095' 31/05/2024 03:44: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 = '92095' 31/05/2024 03:44:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '92095' 31/05/2024 03:44: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 ( '92095' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 31/05/2024 03:44: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 ( '92095' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '30' , '-30' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '36.00' ) 31/05/2024 03:44: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 ( '92095' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 31/05/2024 03:48:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1454' AND id_document != '91644' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 31/05/2024 03:48:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1454', document_date = '2024-05-06', 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 = '39.00', price_tax_excluded = '31.97', date_upd = NOW() WHERE id_document = '91644' 31/05/2024 03:48:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91644' 31/05/2024 03:48:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '91644' 31/05/2024 03:48:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91644' , '21765' , 'BRACCIALE IN ARG. - 7593/1' , '1' , '-1' , '1' , '26.0000' , '21.311475409836' , '22' , '0' , '26.00' ) 31/05/2024 03:48:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91644' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 31/05/2024 04:03:29 pm >> DELETE FROM ps_document WHERE id_document = '90934' 31/05/2024 04:03:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '90934' 31/05/2024 04:41:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1837' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 04:41:55 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' , '1837' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 31/05/2024 04:41:55 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 = '92106' 31/05/2024 04:41:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '92106' 31/05/2024 04:41:55 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 ( '92106' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 31/05/2024 04:48:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1838' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 04:48:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1838' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.80' , '35.08' , NOW() , NOW() ) 31/05/2024 04:48:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92107' 31/05/2024 04:48:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '92107' 31/05/2024 04:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92107' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '4' , '-4' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.80' ) 31/05/2024 04:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92107' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 31/05/2024 05:16:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1839' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 05:16:06 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' , '1839' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.60' , '7.87' , NOW() , NOW() ) 31/05/2024 05:16:06 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 = '92108' 31/05/2024 05:16:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '92108' 31/05/2024 05:16:06 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 ( '92108' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '8' , '-8' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '9.60' ) 31/05/2024 05:36: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 ( '32' , '361' , '2024-05-31' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1562.59' , '1280.81' , NOW() , NOW() ) 31/05/2024 05:36: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 = '92109' 31/05/2024 05:36:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '92109' 31/05/2024 05:36:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92109' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '60' , '0' , '1' , '2.7500' , '2.2541' , '22' , '0' , '201.30' ) 31/05/2024 05:36:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '60' 31/05/2024 05:36:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '60' , '1' ) 31/05/2024 05:36:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92109' , '22650' , 'QUADRETTO S. FAMIGLIA ARG. - 25/101-15' , '53' , '0' , '1' , '2.5000' , '2.0492' , '22' , '0' , '161.65' ) 31/05/2024 05:36:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22650' AND id_supplier = '60' 31/05/2024 05:36:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22650' , '60' , '1' ) 31/05/2024 05:36:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92109' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '10' , '0' , '1' , '3.5000' , '2.8689' , '22' , '0' , '42.70' ) 31/05/2024 05:36:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22651' AND id_supplier = '60' 31/05/2024 05:36:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22651' , '60' , '1' ) 31/05/2024 05:36:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92109' , '22652' , 'CROCE SEMPLICE VARI COLORI' , '500' , '0' , '1' , '0.1300' , '0.1066' , '22' , '0' , '79.30' ) 31/05/2024 05:36:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22652' AND id_supplier = '60' 31/05/2024 05:36:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22652' , '60' , '1' ) 31/05/2024 05:36: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 ( '92109' , '22654' , 'TAVOLETTA PERSONALIZZATA SAN ROCCO' , '123' , '0' , '1' , '0.3900' , '0.3197' , '22' , '0' , '58.52' ) 31/05/2024 05:36:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22654' AND id_supplier = '60' 31/05/2024 05:36:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22654' , '60' , '1' ) 31/05/2024 05:36: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 ( '92109' , '22653' , 'GIROCOLLO PERSONALIZZATO SAN ROCCO' , '60' , '0' , '1' , '1.5000' , '1.2295' , '22' , '0' , '109.80' ) 31/05/2024 05:36:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22653' AND id_supplier = '60' 31/05/2024 05:36:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22653' , '60' , '1' ) 31/05/2024 05:36: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 ( '92109' , '22655' , 'ROSARIO F.MADRE PERLA SAN ROCCO' , '125' , '0' , '1' , '1.0000' , '0.8197' , '22' , '0' , '152.50' ) 31/05/2024 05:36:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22655' AND id_supplier = '60' 31/05/2024 05:36:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22655' , '60' , '1' ) 31/05/2024 05:36: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 ( '92109' , '1312' , 'BRACCIALE DECINA' , '200' , '0' , '1' , '0.5000' , '0.4098' , '22' , '0' , '122.00' ) 31/05/2024 05:36:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '60' 31/05/2024 05:36:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '60' , '1' ) 31/05/2024 05:36: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 ( '92109' , '22656' , 'PORTACHIAVI SAN ROCCO' , '100' , '0' , '1' , '0.9000' , '0.7377' , '22' , '0' , '109.80' ) 31/05/2024 05:36:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22656' AND id_supplier = '60' 31/05/2024 05:36:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22656' , '60' , '1' ) 31/05/2024 05:36: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 ( '92109' , '22657' , 'MAGNETE SAN ROCCO' , '114' , '0' , '1' , '0.9000' , '0.7377' , '22' , '0' , '125.17' ) 31/05/2024 05:36:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22657' AND id_supplier = '60' 31/05/2024 05:36:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22657' , '60' , '1' ) 31/05/2024 05:36: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 ( '92109' , '22658' , 'CROCE PADRE NOSTRO - 646/PN' , '321' , '0' , '1' , '0.5500' , '0.4508' , '22' , '0' , '215.39' ) 31/05/2024 05:36:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22658' AND id_supplier = '60' 31/05/2024 05:36:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22658' , '60' , '1' ) 31/05/2024 05:36: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 ( '92109' , '22659' , 'CROCETTA COMUNIONE CON CART. - 200/COM' , '378' , '0' , '1' , '0.4000' , '0.3279' , '22' , '0' , '184.46' ) 31/05/2024 05:36:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22659' AND id_supplier = '60' 31/05/2024 05:36:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22659' , '60' , '1' ) 31/05/2024 06:07:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1840' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 06:07: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' , '1840' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 31/05/2024 06:07: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 = '92110' 31/05/2024 06:07:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '92110' 31/05/2024 06:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92110' , '22628' , 'BRACCIALE ARG - ASB925-0228S' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 31/05/2024 06:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92110' , '7290' , 'SCATOLA CONFETTI CON CALAMITA' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 31/05/2024 06:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92110' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 31/05/2024 06:16:00 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 ( '32' , '2024010000981' , '2024-05-31' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6.00' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '143.72' , '143.72' , NOW() , NOW() ) 31/05/2024 06:16:00 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 = '92111' 31/05/2024 06:16:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '92111' 31/05/2024 06:16:00 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 ( '92111' , '22675' , 'OGNI GIORNO NELLA VERITA - O. DE BERTOLIS' , '1' , '0' , '4' , '17.0000' , '17' , '0' , '35' , '11.05' ) 31/05/2024 06:16:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22675' AND id_supplier = '107' 31/05/2024 06:16:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22675' , '107' , '1' ) 31/05/2024 06:16:00 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 ( '92111' , '22682' , 'GUIDATI DALLO SPIRITO - M. BELDA' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '35' , '16.25' ) 31/05/2024 06:16:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22682' AND id_supplier = '107' 31/05/2024 06:16:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22682' , '107' , '1' ) 31/05/2024 06:16:01 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 ( '92111' , '22676' , 'MI STAI A CUORE - M. SEBASTIANI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '35' , '11.70' ) 31/05/2024 06:16:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22676' AND id_supplier = '107' 31/05/2024 06:16:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22676' , '107' , '1' ) 31/05/2024 06:16:01 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 ( '92111' , '22681' , 'OGNI GIORNO PREGHIAMO' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '35' , '4.88' ) 31/05/2024 06:16:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22681' AND id_supplier = '107' 31/05/2024 06:16:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22681' , '107' , '1' ) 31/05/2024 06:16:01 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 ( '92111' , '22680' , 'LUCE DI GRAZIA - M. DI LORENZO' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '13.00' ) 31/05/2024 06:16:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22680' AND id_supplier = '107' 31/05/2024 06:16:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22680' , '107' , '1' ) 31/05/2024 06:16:01 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 ( '92111' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '30' , '22.40' ) 31/05/2024 06:16:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 31/05/2024 06:16:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 31/05/2024 06:16:01 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 ( '92111' , '22679' , 'ESISTE UN DIO? - R. SWINBURNE' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 31/05/2024 06:16:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22679' AND id_supplier = '107' 31/05/2024 06:16:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22679' , '107' , '1' ) 31/05/2024 06:16:01 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 ( '92111' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 31/05/2024 06:16:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17385' AND id_supplier = '107' 31/05/2024 06:16:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17385' , '107' , '1' ) 31/05/2024 06:16:01 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 ( '92111' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 31/05/2024 06:16:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21466' AND id_supplier = '107' 31/05/2024 06:16:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21466' , '107' , '1' ) 31/05/2024 06:16:01 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 ( '92111' , '22678' , 'FORMA LITURGICA DELLE FEDE - D. GARGANESE' , '1' , '0' , '4' , '15.9000' , '15.9' , '0' , '35' , '10.34' ) 31/05/2024 06:16:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22678' AND id_supplier = '107' 31/05/2024 06:16:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22678' , '107' , '1' ) 31/05/2024 06:16:01 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 ( '92111' , '22677' , 'LITURGIA MANOMESSA ' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 31/05/2024 06:16:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22677' AND id_supplier = '107' 31/05/2024 06:16:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22677' , '107' , '1' ) 31/05/2024 06:57:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1841' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 31/05/2024 06:57:59 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' , '1841' , '2024-05-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 31/05/2024 06:57:59 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 = '92112' 31/05/2024 06:57:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '92112' 31/05/2024 06:57:59 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 ( '92112' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' )