04/03/2024 08:24:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '87/X' , '2024-02-22' , 'X' , '0' , '73' , '2668' , 'VIA P. TRIBOLDI, 4 26015 SORESINA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '309.20' , '253.44' , NOW() , NOW() ) 04/03/2024 08:24: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 = '90593' 04/03/2024 08:24:35 am >> DELETE FROM ps_document_detail WHERE id_document = '90593' 04/03/2024 08:24: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 ( '90593' , '20437' , 'LUMINO BIANCO 10BTS000' , '1152' , '1152' , '1' , '0.22' , '0.18032786885246' , '22' , '0' , '309.1968' ) 04/03/2024 08:24:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20437' AND id_supplier = '73' 04/03/2024 08:24:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20437' , '73' , '1' ) 04/03/2024 08:33:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '69/X' , '2024-02-08' , 'X' , '0' , '73' , '2668' , 'VIA P. TRIBOLDI, 4 26015 SORESINA' , '' , '' , '110' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '3602.48' , '2952.85' , NOW() , NOW() ) 04/03/2024 08:33:23 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 = '90594' 04/03/2024 08:33:23 am >> DELETE FROM ps_document_detail WHERE id_document = '90594' 04/03/2024 08:33:23 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 ( '90594' , '19363' , 'CERO MINIATO 80X100' , '6' , '6' , '1' , '41.65' , '34.139344262295' , '22' , '0' , '304.8780' ) 04/03/2024 08:33:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19363' AND id_supplier = '73' 04/03/2024 08:33:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19363' , '73' , '1' ) 04/03/2024 08:33:23 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 ( '90594' , '19364' , 'CERO MINIATO 80X120' , '6' , '6' , '1' , '49.3' , '40.409836065574' , '22' , '0' , '360.8760' ) 04/03/2024 08:33:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19364' AND id_supplier = '73' 04/03/2024 08:33:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19364' , '73' , '1' ) 04/03/2024 08:33:23 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 ( '90594' , '15210' , 'CERO PASQUALE API 80X120' , '40' , '40' , '1' , '31.9' , '26.147540983607' , '22' , '0' , '1556.7200' ) 04/03/2024 08:33:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '15210' AND id_supplier = '73' 04/03/2024 08:33:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15210' , '73' , '1' ) 04/03/2024 08:33:23 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 ( '90594' , '20029' , 'MOCCOLO 80X200' , '10' , '10' , '1' , '5.115' , '4.1926229508197' , '22' , '0' , '62.4030' ) 04/03/2024 08:33:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '20029' AND id_supplier = '73' 04/03/2024 08:33:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20029' , '73' , '1' ) 04/03/2024 08:33:23 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 ( '90594' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '60' , '60' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '402.6000' ) 04/03/2024 08:33:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19147' AND id_supplier = '73' 04/03/2024 08:33:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19147' , '73' , '1' ) 04/03/2024 08:33:23 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 ( '90594' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '20' , '20' , '1' , '32' , '26.229508196721' , '22' , '0' , '780.8000' ) 04/03/2024 08:33:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '73' 04/03/2024 08:33:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '73' , '1' ) 04/03/2024 08:59:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 04/03/2024 08:59:44 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '134.90', price_tax_excluded = '134.90', date_upd = NOW() WHERE id_document = '89846' 04/03/2024 08:59:44 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 = '89846' 04/03/2024 08:59:44 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 04/03/2024 08:59:44 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 ( '89846' , '22041' , 'SECONDO MARCO - P. RICCA' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 04/03/2024 08:59: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 ( '89846' , '22107' , 'SIGNORE INSEGNACI A PREGARE - F. SHEEN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 04/03/2024 08:59: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 ( '89846' , '22108' , 'PERCHE CREDERE VOL.2 - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 04/03/2024 08:59: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 ( '89846' , '22068' , 'PAROLA E PREGHIERA - MAR 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/03/2024 08:59: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 ( '89846' , '22069' , 'PAROLA E PREGHIERA - APR 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/03/2024 08:59: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 ( '89846' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 04/03/2024 08:59: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 ( '89846' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 04/03/2024 08:59: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 ( '89846' , '22166' , 'PAROLA E PREGHIERA - MAG. 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/03/2024 08:59: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 ( '89846' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 04/03/2024 08:59: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 ( '89846' , '22213' , 'STUPORE DI DIO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 04/03/2024 08:59: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 ( '89846' , '22228' , 'PAROLA MI RACCONTA - P. CURTAZ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 04/03/2024 08:59: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 ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 04/03/2024 09:00:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 04/03/2024 09:00:13 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '133.50', price_tax_excluded = '133.50', date_upd = NOW() WHERE id_document = '89846' 04/03/2024 09:00: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 = '89846' 04/03/2024 09:00:13 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 04/03/2024 09:00: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 ( '89846' , '22041' , 'SECONDO MARCO - P. RICCA' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 04/03/2024 09:00: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 ( '89846' , '22107' , 'SIGNORE INSEGNACI A PREGARE - F. SHEEN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 04/03/2024 09:00: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 ( '89846' , '22108' , 'PERCHE CREDERE VOL.2 - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 04/03/2024 09:00: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 ( '89846' , '22068' , 'PAROLA E PREGHIERA - MAR 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/03/2024 09:00: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 ( '89846' , '22069' , 'PAROLA E PREGHIERA - APR 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/03/2024 09:00: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 ( '89846' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 04/03/2024 09:00: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 ( '89846' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 04/03/2024 09:00: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 ( '89846' , '22166' , 'PAROLA E PREGHIERA - MAG. 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/03/2024 09:00: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 ( '89846' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 04/03/2024 09:00: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 ( '89846' , '22213' , 'STUPORE DI DIO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 04/03/2024 09:00: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 ( '89846' , '22228' , 'PAROLA MI RACCONTA - P. CURTAZ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 04/03/2024 09:00:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 04/03/2024 09:00:46 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1.40', price_tax_excluded = '1.40', date_upd = NOW() WHERE id_document = '89846' 04/03/2024 09:00: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 = '89846' 04/03/2024 09:00:46 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 04/03/2024 09:00: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 ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 04/03/2024 09:01:44 am >> SELECT document_num FROM ps_document WHERE document_num = '244' AND id_document != '90081' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-25') 04/03/2024 09:01:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '244', document_date = '2024-01-25', 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 = '5.00', price_tax_excluded = '4.50', date_upd = NOW() WHERE id_document = '90081' 04/03/2024 09:01:44 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 = '90081' 04/03/2024 09:01:44 am >> DELETE FROM ps_document_detail WHERE id_document = '90081' 04/03/2024 09:01: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 ( '90081' , '19599' , 'ROSARIO PER LA PRIMA COMUNIONE - 197/13' , '1' , '-1' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '2.80' ) 04/03/2024 09:01: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 ( '90081' , '22068' , 'PAROLA E PREGHIERA - MAR 2024' , '1' , '-1' , '4' , '2.2' , '2.2' , '0' , '0' , '2.20' ) 04/03/2024 09:02:25 am >> SELECT document_num FROM ps_document WHERE document_num = '307' AND id_document != '90156' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 04/03/2024 09:02:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '307', document_date = '2024-01-30', 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 = '5.40', price_tax_excluded = '4.86', date_upd = NOW() WHERE id_document = '90156' 04/03/2024 09:02: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 = '90156' 04/03/2024 09:02:25 am >> DELETE FROM ps_document_detail WHERE id_document = '90156' 04/03/2024 09:02: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 ( '90156' , '22069' , 'PAROLA E PREGHIERA - APR 2024' , '1' , '-1' , '4' , '2.4' , '2.4' , '0' , '0' , '2.40' ) 04/03/2024 09:02: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 ( '90156' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/03/2024 09:02: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 ( '90156' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/03/2024 09:04:05 am >> SELECT document_num FROM ps_document WHERE document_num = '308' AND id_document != '90157' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 04/03/2024 09:04:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '308', document_date = '2024-01-30', 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 = '55.00', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '90157' 04/03/2024 09:04: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 = '90157' 04/03/2024 09:04:05 am >> DELETE FROM ps_document_detail WHERE id_document = '90157' 04/03/2024 09:04: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 ( '90157' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.07' , '2.07' , '0' , '0' , '2.07' ) 04/03/2024 09:04: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 ( '90157' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '5' , '28.50' ) 04/03/2024 09:04: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 ( '90157' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 04/03/2024 09:04: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 ( '90157' , '22081' , 'NE LUPI NE AGNELLI - A. CARRIERO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 04/03/2024 09:04: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 ( '90157' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 04/03/2024 09:04: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 ( '90157' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 04/03/2024 09:04: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 ( '90157' , '22166' , 'PAROLA E PREGHIERA - MAG. 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 04/03/2024 09:06:04 am >> SELECT document_num FROM ps_document WHERE document_num = '318' AND id_document != '90171' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 04/03/2024 09:06:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '318', document_date = '2024-01-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 = '80.00', date_upd = NOW() WHERE id_document = '90171' 04/03/2024 09:06: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 = '90171' 04/03/2024 09:06:04 am >> DELETE FROM ps_document_detail WHERE id_document = '90171' 04/03/2024 09:06: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 ( '90171' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.85' , '6.85' , '0' , '0' , '6.85' ) 04/03/2024 09:06: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 ( '90171' , '22041' , 'SECONDO MARCO - P. RICCA' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 04/03/2024 09:06: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 ( '90171' , '22107' , 'SIGNORE INSEGNACI A PREGARE - F. SHEEN' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 04/03/2024 09:06: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 ( '90171' , '22108' , 'PERCHE CREDERE VOL.2 - F. SHEEN' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 04/03/2024 09:06: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 ( '90171' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 04/03/2024 09:06:52 am >> SELECT document_num FROM ps_document WHERE document_num = '521' AND id_document != '90445' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-21') 04/03/2024 09:06:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '521', document_date = '2024-02-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 = '20.00', price_tax_excluded = '20.00', date_upd = NOW() WHERE id_document = '90445' 04/03/2024 09:06: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 = '90445' 04/03/2024 09:06:52 am >> DELETE FROM ps_document_detail WHERE id_document = '90445' 04/03/2024 09:06: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 ( '90445' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.75' , '5.75' , '0' , '0' , '5.75' ) 04/03/2024 09:06: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 ( '90445' , '22228' , 'PAROLA MI RACCONTA - P. CURTAZ' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 04/03/2024 09:07:40 am >> SELECT document_num FROM ps_document WHERE document_num = '583' AND id_document != '90532' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-28') 04/03/2024 09:07:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '583', document_date = '2024-02-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 = '73.43', price_tax_excluded = '66.52', date_upd = NOW() WHERE id_document = '90532' 04/03/2024 09:07: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 = '90532' 04/03/2024 09:07:40 am >> DELETE FROM ps_document_detail WHERE id_document = '90532' 04/03/2024 09:07: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 ( '90532' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/03/2024 09:07: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 ( '90532' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 04/03/2024 09:07: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 ( '90532' , '22165' , 'INSIEME NELLA MESSA - MAG. 2024' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 04/03/2024 09:07: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 ( '90532' , '22071' , 'INSIEME NELLA MESSA - APR 2024' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 04/03/2024 09:07: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 ( '90532' , '22070' , 'INSIEME NELLA MESSA - MAR 2024' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 04/03/2024 09:07:41 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 ( '90532' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 04/03/2024 09:07:41 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 ( '90532' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.25' , '6.25' , '0' , '0' , '6.25' ) 04/03/2024 09:07:41 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 ( '90532' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '1' , '-1' , '1' , '11.5000' , '9.4262295081967' , '22' , '0' , '11.50' ) 04/03/2024 09:07:41 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 ( '90532' , '22213' , 'STUPORE DI DIO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 04/03/2024 09:21:06 am >> SELECT document_num FROM ps_document WHERE document_num = '626' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 09:21: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' , '626' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.50' , '95.07' , NOW() , NOW() ) 04/03/2024 09:21: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 = '90595' 04/03/2024 09:21:06 am >> DELETE FROM ps_document_detail WHERE id_document = '90595' 04/03/2024 09:21: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 ( '90595' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '120' , '-120' , '4' , '0.70' , '0.7' , '0' , '0' , '84.00' ) 04/03/2024 09:21: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 ( '90595' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 04/03/2024 09:21: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 ( '90595' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/03/2024 09:34:26 am >> SELECT document_num FROM ps_document WHERE document_num = '627' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 09:34:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '627' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.33' , '32.53' , NOW() , NOW() ) 04/03/2024 09:34:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90596' 04/03/2024 09:34:26 am >> DELETE FROM ps_document_detail WHERE id_document = '90596' 04/03/2024 09:34: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 ( '90596' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '5' , '3.80' ) 04/03/2024 09:34: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 ( '90596' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 04/03/2024 09:34: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 ( '90596' , '15293' , 'BENEDIZIONI - RISURREZIONE A' , '100' , '-100' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '10.00' ) 04/03/2024 09:34: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 ( '90596' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 04/03/2024 09:41:44 am >> SELECT document_num FROM ps_document WHERE document_num = '628' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 09:41:44 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' , '628' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '43.69' , NOW() , NOW() ) 04/03/2024 09:41:44 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 = '90597' 04/03/2024 09:41:44 am >> DELETE FROM ps_document_detail WHERE id_document = '90597' 04/03/2024 09:41:44 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 ( '90597' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 04/03/2024 09:41:44 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 ( '90597' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 04/03/2024 09:41:44 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 ( '90597' , '18290' , 'BATTESIMO - N.E. ' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/03/2024 09:41:44 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 ( '90597' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 04/03/2024 09:41:44 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 ( '90597' , '17529' , 'NUOVO RITO DELLA MESSA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/03/2024 09:41:44 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 ( '90597' , '19539' , 'PRESBITERI DIACONI - N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 04/03/2024 09:41:44 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 ( '90597' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 04/03/2024 09:41:44 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 ( '90597' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.96' , '1.96' , '0' , '0' , '1.96' ) 04/03/2024 09:41:44 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 ( '90597' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 04/03/2024 10:08:14 am >> SELECT document_num FROM ps_document WHERE document_num = '629' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 10:08: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' , '629' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '29.43' , NOW() , NOW() ) 04/03/2024 10:08: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 = '90598' 04/03/2024 10:08:14 am >> DELETE FROM ps_document_detail WHERE id_document = '90598' 04/03/2024 10:08: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 ( '90598' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 04/03/2024 10:08: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 ( '90598' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 04/03/2024 10:08: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 ( '90598' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 04/03/2024 10:08:27 am >> SELECT document_num FROM ps_document WHERE document_num = '630' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 10:08:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '630' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 04/03/2024 10:08:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90599' 04/03/2024 10:08:27 am >> DELETE FROM ps_document_detail WHERE id_document = '90599' 04/03/2024 10:08:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90599' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 04/03/2024 10:52:54 am >> SELECT document_num FROM ps_document WHERE document_num = '631' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 10:52:54 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' , '631' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.20' , '50.98' , NOW() , NOW() ) 04/03/2024 10:52:54 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 = '90600' 04/03/2024 10:52:54 am >> DELETE FROM ps_document_detail WHERE id_document = '90600' 04/03/2024 10:52:54 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 ( '90600' , '22221' , 'FINTA CANDELA COMPLETA 3,2X80 - 1136' , '2' , '-2' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '60.00' ) 04/03/2024 10:52:54 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 ( '90600' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 04/03/2024 10:56:24 am >> UPDATE ps_document SET id_document_type = '31', document_num = '325/2024', document_date = '2024-02-29', document_letter = '2024', id_customer = '0', id_supplier = '', id_address = '2638', address1 = 'VIA COSTABIANCA, 43 60025 LORETO', address2 = '', note = '', price_shipping = '8.5', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '77.80', price_tax_excluded = '63.77', date_upd = NOW() WHERE id_document = '90402' 04/03/2024 10:56: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 = '90402' 04/03/2024 10:56:24 am >> DELETE FROM ps_document_detail WHERE id_document = '90402' 04/03/2024 10:56:24 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 ( '90402' , '22011' , 'CROCE SAN DAMIANO MOGANO 26X19 - PG552' , '2' , '2' , '1' , '7.6200' , '6.2459016393443' , '22' , '10' , '16.73' ) 04/03/2024 10:56:24 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 ( '90402' , '22154' , 'STATUA MEDAGLIA MIRACOLOSA - ST312MIR' , '1' , '1' , '1' , '7.7700' , '6.3688524590164' , '22' , '10' , '8.53' ) 04/03/2024 10:56:24 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 ( '90402' , '22156' , 'CROCE MET. SMALTATA DOR. - CL271D' , '4' , '4' , '1' , '3.5500' , '2.9098360655738' , '22' , '10' , '15.59' ) 04/03/2024 10:56:24 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 ( '90402' , '22155' , 'CROCE MET. SMALTATA ARG. - CL271' , '4' , '4' , '1' , '3.0000' , '2.4590163934426' , '22' , '10' , '13.18' ) 04/03/2024 10:56:24 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 ( '90402' , '22157' , 'CROCE MET. SMALTATA - CL272' , '2' , '2' , '1' , '6.1000' , '5' , '22' , '10' , '13.40' ) 04/03/2024 11:00:34 am >> UPDATE ps_document SET id_document_type = '31', document_num = '8500000', document_date = '2024-02-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670947', address1 = 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI', address2 = '', note = 'cambiare numero', price_shipping = '18', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2978.68', price_tax_excluded = '2441.54', date_upd = NOW() WHERE id_document = '90577' 04/03/2024 11:00: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 = '90577' 04/03/2024 11:00:34 am >> DELETE FROM ps_document_detail WHERE id_document = '90577' 04/03/2024 11:00: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 ( '90577' , '22231' , 'CASULA - 65/060154' , '4' , '4' , '1' , '198.0000' , '162.29508196721' , '22' , '3' , '937.2528' ) 04/03/2024 11:00: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 ( '90577' , '22232' , 'CASULA TESSUTO MAREZZATO - 65/019344' , '1' , '1' , '1' , '150.0000' , '122.95081967213' , '22' , '3' , '177.5100' ) 04/03/2024 11:00: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 ( '90577' , '17408' , 'CAMICE MISTO COT. 70/001035' , '2' , '2' , '1' , '70.0000' , '57.377049180328' , '22' , '3' , '165.6760' ) 04/03/2024 11:00: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 ( '90577' , '22233' , 'CAMICE MISTO LANA - 70/000150' , '16' , '16' , '1' , '115' , '94.262295081967' , '22' , '40' , '1346.8800' ) 04/03/2024 11:00: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 ( '90577' , '22234' , 'CAMICE MISTO LANA - 70/002020' , '3' , '3' , '1' , '150' , '122.95081967213' , '22' , '40' , '329.4000' ) 04/03/2024 11:01:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002234' AND id_product != '22233' AND ean13 != '' 04/03/2024 11:01:24 am >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '002234', date_upd = NOW() WHERE id_product = '22233' 04/03/2024 11:01:24 am >> UPDATE ps_product_lang SET name = 'CAMICE MISTO LANA - 70/000150', description = '' WHERE id_product = '22233' 04/03/2024 11:01:24 am >> UPDATE ps_product SET wholesale_price = '70.00', on_sale = '0', price = '184.4262295081967' WHERE id_product = '22233' 04/03/2024 11:01:24 am >> UPDATE ps_product_shop SET wholesale_price = '70.00', price = '184.4262295081967', id_tax_rules_group = '1', id_category_default = '468', 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 = '22233' 04/03/2024 11:01:24 am >> DELETE FROM ps_specific_price WHERE id_product = '22233' 04/03/2024 11:01:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002235' AND id_product != '22234' AND ean13 != '' 04/03/2024 11:01:51 am >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '002235', date_upd = NOW() WHERE id_product = '22234' 04/03/2024 11:01:51 am >> UPDATE ps_product_lang SET name = 'CAMICE MISTO LANA - 70/002020', description = '' WHERE id_product = '22234' 04/03/2024 11:01:51 am >> UPDATE ps_product SET wholesale_price = '90.00', on_sale = '0', price = '270.4918032786885' WHERE id_product = '22234' 04/03/2024 11:01:51 am >> UPDATE ps_product_shop SET wholesale_price = '90.00', price = '270.4918032786885', id_tax_rules_group = '1', id_category_default = '468', 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 = '22234' 04/03/2024 11:01:51 am >> DELETE FROM ps_specific_price WHERE id_product = '22234' 04/03/2024 11:20:55 am >> SELECT document_num FROM ps_document WHERE document_num = '30/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 11:20: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 ( '24' , '30/A' , '2024-03-04' , 'A' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '141.10' , '123.61' , NOW() , NOW() ) 04/03/2024 11:20: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 = '90601' 04/03/2024 11:20:55 am >> DELETE FROM ps_document_detail WHERE id_document = '90601' 04/03/2024 11:20: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 ( '90601' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '-1' , '1' , '85.00' , '69.672131147541' , '22' , '0' , '85.00' ) 04/03/2024 11:20: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 ( '90601' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 04/03/2024 11:20: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 ( '90601' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 04/03/2024 11:20: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 ( '90601' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 04/03/2024 11:20: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 ( '90601' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 04/03/2024 12:11:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '632' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 12:11:57 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' , '632' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '134.27' , NOW() , NOW() ) 04/03/2024 12:11:57 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 = '90602' 04/03/2024 12:11:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '90602' 04/03/2024 12:11:57 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 ( '90602' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 04/03/2024 12:11:57 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 ( '90602' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 04/03/2024 12:11:57 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 ( '90602' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '138' , '113.11475409836' , '22' , '0' , '138.00' ) 04/03/2024 12:14:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '632' AND id_document != '90602' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 12:14:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '632', document_date = '2024-03-04', 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 = '160.00', price_tax_excluded = '134.27', date_upd = NOW() WHERE id_document = '90602' 04/03/2024 12:14: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 = '90602' 04/03/2024 12:14:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90602' 04/03/2024 12:14: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 ( '90602' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 04/03/2024 12:14: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 ( '90602' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 04/03/2024 12:14: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 ( '90602' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '2' , '-2' , '1' , '69' , '56.55737704918' , '22' , '0' , '138.00' ) 04/03/2024 12:16:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '632' AND id_document != '90602' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 12:16:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '632', document_date = '2024-03-04', 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 = '160.00', price_tax_excluded = '134.27', date_upd = NOW() WHERE id_document = '90602' 04/03/2024 12:16:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90602' 04/03/2024 12:16:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90602' 04/03/2024 12:16:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90602' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 04/03/2024 12:16:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90602' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 04/03/2024 12:16:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90602' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '69' , '56.55737704918' , '22' , '0' , '138.00' ) 04/03/2024 12:29:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '633' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 12:29: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' , '633' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/03/2024 12:29: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 = '90603' 04/03/2024 12:29:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '90603' 04/03/2024 12:29: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 ( '90603' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/03/2024 12:55:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '624' AND id_document != '90591' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-02') 04/03/2024 12:55:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '624', document_date = '2024-03-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '195.50', price_tax_excluded = '160.25', date_upd = NOW() WHERE id_document = '90591' 04/03/2024 12:55:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90591' 04/03/2024 12:55:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '90591' 04/03/2024 12:55:21 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 ( '90591' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '3' , '-3' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '111.00' ) 04/03/2024 12:55:21 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 ( '90591' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.5' , '32.377049180328' , '22' , '0' , '39.50' ) 04/03/2024 12:55:21 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 ( '90591' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 04/03/2024 02:42:55 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '182', document_date = '2024-02-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2687', address1 = 'via Trapani, C.DA Venera, 7 91025 MARSALA', address2 = '', note = '', price_shipping = '1.82', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '2354.04', price_tax_excluded = '1929.54', date_upd = NOW() WHERE id_document = '90511' 04/03/2024 02:42: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 = '90511' 04/03/2024 02:42:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90511' 04/03/2024 02:42: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 ( '90511' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '264' , '264' , '1' , '3.8247' , '3.135' , '22' , '0' , '1231.86' ) 04/03/2024 02:42: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 ( '90511' , '11756' , 'VINO BIANCO SECCO - 14%' , '90' , '90' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '307.44' ) 04/03/2024 02:42: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 ( '90511' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '180' , '180' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '812.5200' ) 04/03/2024 02:45:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '228' , '2024-02-28' , '' , '0' , '80' , '2687' , 'via Trapani, C.DA Venera, 7 91025 MARSALA' , '' , '' , '2.45' , '4' , '0' , '0' , '0' , '' , '10' , '0' , '814.97' , '668.45' , NOW() , NOW() ) 04/03/2024 02:45:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90604' 04/03/2024 02:45:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '90604' 04/03/2024 02:45:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90604' , '22199' , 'VINO LIQUOROSO ROSSO ' , '180' , '180' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '812.5200' ) 04/03/2024 02:45:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22199' AND id_supplier = '80' 04/03/2024 02:45:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22199' , '80' , '1' ) 04/03/2024 04:00:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '634' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 04:00:57 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' , '634' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.90' , '27.71' , NOW() , NOW() ) 04/03/2024 04:00:57 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 = '90605' 04/03/2024 04:00:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '90605' 04/03/2024 04:00:57 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 ( '90605' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 04/03/2024 04:00:57 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 ( '90605' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 04/03/2024 04:00:57 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 ( '90605' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 04/03/2024 04:00:57 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 ( '90605' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 04/03/2024 04:00:57 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 ( '90605' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 04/03/2024 04:26:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 04:26:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '3' , '2024-03-04' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '750.00' , '750.00' , NOW() , NOW() ) 04/03/2024 04:26:18 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 = '14197' 04/03/2024 04:26:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '14197' 04/03/2024 04:26:18 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 ( '14197' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '300' , '-300' , '4' , '2.50' , '2.5' , '0' , '0' , '750.00' ) 04/03/2024 04:29:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 04:29:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '10' , '2024-03-04' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4512.00' , '4512.00' , NOW() , NOW() ) 04/03/2024 04:29:27 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 = '90606' 04/03/2024 04:29:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '90606' 04/03/2024 04:29:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90606' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '200' , '-200' , '4' , '1.00' , '1' , '0' , '0' , '200.00' ) 04/03/2024 04:29:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90606' , '17257' , 'IO TI BATTEZZO ' , '290' , '-290' , '4' , '1.80' , '1.8' , '0' , '0' , '522.00' ) 04/03/2024 04:29:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90606' , '21899' , 'SACRA BIBBIA cei/uelci ' , '100' , '-100' , '4' , '18.50' , '18.5' , '0' , '0' , '1850.00' ) 04/03/2024 04:29:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90606' , '22151' , 'MA DIO LO HA RISUSCITATO' , '80' , '-80' , '4' , '10.00' , '10' , '0' , '0' , '800.00' ) 04/03/2024 04:29:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90606' , '22152' , 'A TE RICORRIAMO' , '260' , '-260' , '4' , '3.00' , '3' , '0' , '0' , '780.00' ) 04/03/2024 04:29:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90606' , '22153' , 'UNA VITA CONSUMATA NELL\'AMORE' , '60' , '-60' , '4' , '6.00' , '6' , '0' , '0' , '360.00' ) 04/03/2024 04:38:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '90606' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 04:38:15 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '10', document_date = '2024-03-04', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '3462.00', price_tax_excluded = '3462.00', date_upd = NOW() WHERE id_document = '90606' 04/03/2024 04:38:15 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 = '90606' 04/03/2024 04:38:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '90606' 04/03/2024 04:38:15 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 ( '90606' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '200' , '-200' , '4' , '1.0000' , '1' , '0' , '0' , '200.00' ) 04/03/2024 04:38:15 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 ( '90606' , '17257' , 'IO TI BATTEZZO ' , '290' , '-290' , '4' , '1.8000' , '1.8' , '0' , '0' , '522.00' ) 04/03/2024 04:38:15 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 ( '90606' , '22151' , 'MA DIO LO HA RISUSCITATO' , '160' , '-160' , '4' , '10.0000' , '10' , '0' , '0' , '1600.00' ) 04/03/2024 04:38:15 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 ( '90606' , '22152' , 'A TE RICORRIAMO' , '260' , '-260' , '4' , '3.0000' , '3' , '0' , '0' , '780.00' ) 04/03/2024 04:38:15 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 ( '90606' , '22153' , 'UNA VITA CONSUMATA NELL\'AMORE' , '60' , '-60' , '4' , '6.0000' , '6' , '0' , '0' , '360.00' ) 04/03/2024 04:39:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '9/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 04:39:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '9/E' , '2024-03-04' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '925.00' , '925.00' , NOW() , NOW() ) 04/03/2024 04:39:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90607' 04/03/2024 04:39:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '90607' 04/03/2024 04:39:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90607' , '21899' , 'SACRA BIBBIA cei/uelci ' , '100' , '-100' , '4' , '18.50' , '18.5' , '0' , '50' , '925.00' ) 04/03/2024 06:40:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '635' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 06:40:15 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' , '635' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 04/03/2024 06:40:15 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 = '90608' 04/03/2024 06:40:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '90608' 04/03/2024 06:40:15 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 ( '90608' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '51' , '41.803278688525' , '22' , '0' , '51.00' ) 04/03/2024 06:41:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '635' AND id_document != '90608' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 06:41:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '635', document_date = '2024-03-04', 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 = '51.00', price_tax_excluded = '41.80', date_upd = NOW() WHERE id_document = '90608' 04/03/2024 06:41:51 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 = '90608' 04/03/2024 06:41:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '90608' 04/03/2024 06:41:51 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 ( '90608' , '20516' , 'CROCE COMUNIONE - 42/08' , '27' , '-27' , '1' , '1' , '0.81967213114754' , '22' , '0' , '27.00' ) 04/03/2024 06:41:51 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 ( '90608' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '4' , '-4' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '24.00' ) 04/03/2024 06:45:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '341' AND id_document != '90203' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-01') 04/03/2024 06:45:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '341', document_date = '2024-02-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 = '82.80', price_tax_excluded = '73.69', date_upd = NOW() WHERE id_document = '90203' 04/03/2024 06:45:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90203' 04/03/2024 06:45:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90203' 04/03/2024 06:45:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90203' , '20823' , 'BRUCIA INCENSO CM 9' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 04/03/2024 06:45:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90203' , '20656' , 'PAURA COME DONO - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 04/03/2024 06:45:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90203' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 04/03/2024 06:45:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90203' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 04/03/2024 06:45:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90203' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '3' , '-3' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.50' ) 04/03/2024 06:45:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '325' AND id_document != '90181' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 04/03/2024 06:45:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '325', document_date = '2024-01-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 = '4.50', price_tax_excluded = '4.32', date_upd = NOW() WHERE id_document = '90181' 04/03/2024 06:45: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 = '90181' 04/03/2024 06:45:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90181' 04/03/2024 06:45: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 ( '90181' , '18051' , 'MIA BIBBIA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 04/03/2024 06:45: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 ( '90181' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/03/2024 07:02:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '636' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 07:02:43 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' , '636' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.20' , '11.64' , NOW() , NOW() ) 04/03/2024 07:02:43 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 = '90609' 04/03/2024 07:02:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90609' 04/03/2024 07:02:43 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 ( '90609' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/03/2024 07:02:43 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 ( '90609' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/03/2024 07:02:43 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 ( '90609' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/03/2024 07:02:43 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 ( '90609' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 04/03/2024 07:33:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '637' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 07:33:52 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' , '637' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '18.81' , NOW() , NOW() ) 04/03/2024 07:33:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90610' 04/03/2024 07:33:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '90610' 04/03/2024 07:33:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90610' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '4' , '-4' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '18.00' ) 04/03/2024 07:33:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90610' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/03/2024 07:34:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '638' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/03/2024 07:34:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '638' , '2024-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 04/03/2024 07:34:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90611' 04/03/2024 07:34:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '90611' 04/03/2024 07:34:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90611' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' )