29/05/2025 09:31:39 am >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 09:31:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '83/A' , '2025-05-29' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '520.20' , '426.39' , NOW() , NOW() ) 29/05/2025 09:31:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97450' 29/05/2025 09:31:39 am >> DELETE FROM ps_document_detail WHERE id_document = '97450' 29/05/2025 09:31:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97450' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 29/05/2025 09:31: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 ( '97450' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/05/2025 09:31: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 ( '97450' , '6014' , 'LUMINO BIANCO - 10B' , '384' , '-384' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '192.00' ) 29/05/2025 09:31: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 ( '97450' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 29/05/2025 09:31: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 ( '97450' , '7202' , 'clergy roman' , '2' , '-2' , '1' , '49.9' , '40.901639344262' , '22' , '0' , '99.80' ) 29/05/2025 09:31: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 ( '97450' , '7202' , 'clergy nero' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 29/05/2025 10:59:41 am >> UPDATE ps_document SET id_document_type = '31', document_num = '474', document_date = '2018-07-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2729', address1 = 'VIA COLLE DI NAVA, 127D 12060 MAGLIANO ALPI', address2 = '', note = '', price_shipping = '12.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '10', id_causal = '0', price_tax_included = '494.95', price_tax_excluded = '405.70', date_upd = NOW() WHERE id_document = '9948' 29/05/2025 10:59:41 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 = '9948' 29/05/2025 10:59:41 am >> DELETE FROM ps_document_detail WHERE id_document = '9948' 29/05/2025 10:59:42 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 ( '9948' , '13931' , 'CINGOLO PER SACERDOTI AVORIO - 231/RYN' , '10' , '10' , '1' , '4.1000' , '3.3606557377049' , '22' , '0' , '50.02' ) 29/05/2025 10:59:42 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 ( '9948' , '13751' , 'TUNICA SVASATA AVORIO ' , '4' , '4' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '65.88' ) 29/05/2025 10:59:42 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 ( '9948' , '14088' , 'CAMICE IN MICROFIBRA' , '4' , '4' , '1' , '17.6000' , '14.426229508197' , '22' , '0' , '85.89' ) 29/05/2025 10:59:42 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 ( '9948' , '12744' , 'COPRILEGGIO MARIANO - 364/TP' , '1' , '1' , '1' , '25.8000' , '21.147540983607' , '22' , '0' , '31.48' ) 29/05/2025 10:59:42 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 ( '9948' , '21139' , 'COTTA CON TRAMEZZO - 906TPA' , '1' , '1' , '1' , '51.1' , '41.885245901639' , '22' , '0' , '62.3420' ) 29/05/2025 10:59:42 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 ( '9948' , '14361' , 'CASULA 100% POLIESTERE RICAMO CALICE' , '2' , '2' , '1' , '44.0000' , '36.065573770492' , '22' , '0' , '107.36' ) 29/05/2025 10:59:42 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 ( '9948' , '14362' , 'CAMICE SVASATO ' , '1' , '1' , '1' , '22.7000' , '18.606557377049' , '22' , '0' , '27.69' ) 29/05/2025 10:59:42 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 ( '9948' , '14363' , 'CAMICE DUE PIEGONI MISTO COTONE' , '1' , '1' , '1' , '23.1000' , '18.934426229508' , '22' , '0' , '28.18' ) 29/05/2025 10:59:42 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 ( '9948' , '14364' , 'CAMICE SVASATO MISTO COTONE' , '1' , '1' , '1' , '17.6000' , '14.426229508197' , '22' , '0' , '21.47' ) 29/05/2025 11:00:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002151' AND id_product != '21139' AND ean13 != '' 29/05/2025 11:00:21 am >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '002151', date_upd = NOW() WHERE id_product = '21139' 29/05/2025 11:00:21 am >> UPDATE ps_product_lang SET name = 'COTTA CON TRAMEZZO - 906/TPA', description = '' WHERE id_product = '21139' 29/05/2025 11:00:21 am >> UPDATE ps_product SET wholesale_price = '60.90', on_sale = '0', price = '121.3115' WHERE id_product = '21139' 29/05/2025 11:00:21 am >> UPDATE ps_product_shop SET wholesale_price = '60.90', price = '121.3115', id_tax_rules_group = '1', id_category_default = '396', 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 = '21139' 29/05/2025 11:00:21 am >> DELETE FROM ps_specific_price WHERE id_product = '21139' 29/05/2025 11:08:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1903' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 11:08:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1903' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '16.71' , NOW() , NOW() ) 29/05/2025 11:08: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 = '97451' 29/05/2025 11:08:52 am >> DELETE FROM ps_document_detail WHERE id_document = '97451' 29/05/2025 11:08: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 ( '97451' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 29/05/2025 11:08: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 ( '97451' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 29/05/2025 11:11:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1874' AND id_document != '97416' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-27') 29/05/2025 11:11:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1874', document_date = '2025-05-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '136.00', price_tax_excluded = '111.48', date_upd = NOW() WHERE id_document = '97416' 29/05/2025 11:11:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97416' 29/05/2025 11:11:32 am >> DELETE FROM ps_document_detail WHERE id_document = '97416' 29/05/2025 11:11:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97416' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 29/05/2025 11:11:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97416' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '100' , '0.00' ) 29/05/2025 11:11:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97416' , '13384' , 'COTTA AVORIO GIGLIUCCIO MACCHINA - MISTO COTONE' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 29/05/2025 11:26:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1904' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 11:26:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1904' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 29/05/2025 11:26:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97452' 29/05/2025 11:26:49 am >> DELETE FROM ps_document_detail WHERE id_document = '97452' 29/05/2025 11:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97452' , '21097' , 'BRACCIALE DECINA - BC1768N' , '7' , '-7' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '14.00' ) 29/05/2025 11:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97452' , '21097' , 'BRACCIALE DECINA - BC1768N' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 29/05/2025 11:42:27 am >> SELECT document_num FROM ps_document WHERE document_num = '1752' AND id_document != '97282' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 29/05/2025 11:42:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1752', document_date = '2025-05-20', 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 = '26.60', price_tax_excluded = '26.60', date_upd = NOW() WHERE id_document = '97282' 29/05/2025 11:42: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 = '97282' 29/05/2025 11:42:27 am >> DELETE FROM ps_document_detail WHERE id_document = '97282' 29/05/2025 11:42: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 ( '97282' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '4' , '-4' , '4' , '4.0000' , '4' , '0' , '5' , '15.20' ) 29/05/2025 11:42: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 ( '97282' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '' , '10.00' ) 29/05/2025 11:42: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 ( '97282' , '23771' , 'INSIEME NELLA MESSA - AGO 25' , '1' , '-1' , '4' , '1.4' , '1.4' , '0' , '0' , '1.40' ) 29/05/2025 11:43:35 am >> DELETE FROM ps_document WHERE id_document = '94912' 29/05/2025 11:43:35 am >> DELETE FROM ps_document_detail WHERE id_document = '94912' 29/05/2025 11:48:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1518' AND id_document != '97010' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 29/05/2025 11:48:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1518', document_date = '2025-05-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '34.00', price_tax_excluded = '34.00', date_upd = NOW() WHERE id_document = '97010' 29/05/2025 11:48: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 = '97010' 29/05/2025 11:48:54 am >> DELETE FROM ps_document_detail WHERE id_document = '97010' 29/05/2025 11:48: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 ( '97010' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6' , '6' , '0' , '0' , '6.00' ) 29/05/2025 11:48: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 ( '97010' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 29/05/2025 11:48: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 ( '97010' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 29/05/2025 11:48: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 ( '97010' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 29/05/2025 11:48: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 ( '97010' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '2' , '-2' , '4' , '4.5' , '4.5' , '0' , '0' , '9.00' ) 29/05/2025 11:50:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1231' AND id_document != '96672' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14') 29/05/2025 11:50:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1231', document_date = '2025-04-14', 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 = '42.50', price_tax_excluded = '34.84', date_upd = NOW() WHERE id_document = '96672' 29/05/2025 11:50:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96672' 29/05/2025 11:50:48 am >> DELETE FROM ps_document_detail WHERE id_document = '96672' 29/05/2025 11:50:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96672' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 29/05/2025 11:50:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96672' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 29/05/2025 11:50:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96672' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 29/05/2025 11:51:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1366' AND id_document != '96829' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-24') 29/05/2025 11:51:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1366', document_date = '2025-04-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.90', price_tax_excluded = '33.52', date_upd = NOW() WHERE id_document = '96829' 29/05/2025 11:51: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 = '96829' 29/05/2025 11:51:24 am >> DELETE FROM ps_document_detail WHERE id_document = '96829' 29/05/2025 11:51: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 ( '96829' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 29/05/2025 11:51: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 ( '96829' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '3' , '-3' , '1' , '10' , '8.1967213114754' , '22' , '0' , '30.00' ) 29/05/2025 11:51: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 ( '96829' , '20073' , 'ROSARIO CRISTALLO - 01M46' , '1' , '-1' , '1' , '9.9' , '8.1147540983607' , '22' , '0' , '9.90' ) 29/05/2025 11:51:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1556' AND id_document != '97051' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 29/05/2025 11:51:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1556', document_date = '2025-05-07', 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 = '97051' 29/05/2025 11:51:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97051' 29/05/2025 11:51:49 am >> DELETE FROM ps_document_detail WHERE id_document = '97051' 29/05/2025 11:51:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97051' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 29/05/2025 11:51:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97051' , '20073' , 'ROSARIO CRISTALLO - 01M46' , '5' , '-5' , '1' , '9' , '7.3770491803279' , '22' , '0' , '45.00' ) 29/05/2025 11:52:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1570' AND id_document != '97067' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-08') 29/05/2025 11:52:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1570', document_date = '2025-05-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '58.00', price_tax_excluded = '47.54', date_upd = NOW() WHERE id_document = '97067' 29/05/2025 11:52:17 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 = '97067' 29/05/2025 11:52:17 am >> DELETE FROM ps_document_detail WHERE id_document = '97067' 29/05/2025 11:52:17 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 ( '97067' , '20073' , 'ROSARIO CRISTALLO - 01M46' , '10' , '-10' , '1' , '5.8' , '4.7540983606557' , '22' , '0' , '58.00' ) 29/05/2025 11:53:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1775' AND id_document != '97306' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 29/05/2025 11:53:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1775', document_date = '2025-05-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 = '16.39', date_upd = NOW() WHERE id_document = '97306' 29/05/2025 11:53: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 = '97306' 29/05/2025 11:53:13 am >> DELETE FROM ps_document_detail WHERE id_document = '97306' 29/05/2025 11:53: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 ( '97306' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '8' , '-8' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.00' ) 29/05/2025 11:53: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 ( '97306' , '20073' , 'ROSARIO CRISTALLO - 01M46' , '3' , '-3' , '1' , '6' , '4.9180327868852' , '22' , '0' , '18.00' ) 29/05/2025 11:54:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1571' AND id_document != '97068' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-08') 29/05/2025 11:54:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1571', document_date = '2025-05-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.80', price_tax_excluded = '49.84', date_upd = NOW() WHERE id_document = '97068' 29/05/2025 11:54:18 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 = '97068' 29/05/2025 11:54:18 am >> DELETE FROM ps_document_detail WHERE id_document = '97068' 29/05/2025 11:54:18 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 ( '97068' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 29/05/2025 11:54:18 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 ( '97068' , '3144' , 'CROCE TRILOBATA ' , '2' , '-2' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '9.00' ) 29/05/2025 11:54:18 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 ( '97068' , '22196' , 'CLERGY VERSUS ML - C25' , '1' , '-1' , '1' , '43.8' , '35.901639344262' , '22' , '0' , '43.80' ) 29/05/2025 11:55:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1809' AND id_document != '97347' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-23') 29/05/2025 11:55:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1809', document_date = '2025-05-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '128.90', price_tax_excluded = '107.55', date_upd = NOW() WHERE id_document = '97347' 29/05/2025 11:55: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 = '97347' 29/05/2025 11:55:04 am >> DELETE FROM ps_document_detail WHERE id_document = '97347' 29/05/2025 11:55: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 ( '97347' , '9017' , 'RITO DELLA PENITENZA' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 29/05/2025 11:55: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 ( '97347' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '39.50' ) 29/05/2025 11:55: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 ( '97347' , '16454' , 'PALLA ORO CM 16' , '1' , '-1' , '1' , '78.9' , '64.672131147541' , '22' , '0' , '78.90' ) 29/05/2025 11:57:47 am >> DELETE FROM ps_document WHERE id_document = '97450' 29/05/2025 11:57:47 am >> DELETE FROM ps_document_detail WHERE id_document = '97450' 29/05/2025 11:59:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1488' AND id_document != '96969' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-02') 29/05/2025 11:59:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1488', document_date = '2025-05-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '85.00', price_tax_excluded = '70.57', date_upd = NOW() WHERE id_document = '96969' 29/05/2025 11:59: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 = '96969' 29/05/2025 11:59:40 am >> DELETE FROM ps_document_detail WHERE id_document = '96969' 29/05/2025 11:59: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 ( '96969' , '22501' , 'BRACCIALE COLORATO PRIMA COMUNIONE' , '11' , '-11' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '16.50' ) 29/05/2025 11:59: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 ( '96969' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '11' , '-11' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '13.20' ) 29/05/2025 11:59: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 ( '96969' , '19665' , 'SAN MATTIA AP. - SIMEONE/TESTI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 29/05/2025 11:59: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 ( '96969' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4' , '3.2786885245902' , '22' , '0' , '48.00' ) 29/05/2025 11:59: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 ( '96969' , '20516' , 'CROCE COMUNIONE - 42/08' , '2' , '-2' , '1' , '1.15' , '0.94262295081967' , '22' , '0' , '2.30' ) 29/05/2025 12:01:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1569' AND id_document != '97066' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-08') 29/05/2025 12:01:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1569', document_date = '2025-05-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '59.30', price_tax_excluded = '48.61', date_upd = NOW() WHERE id_document = '97066' 29/05/2025 12:01:01 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 = '97066' 29/05/2025 12:01:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '97066' 29/05/2025 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97066' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '1.73' , '1.4180327868852' , '22' , '0' , '17.30' ) 29/05/2025 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97066' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7' , '5.7377049180328' , '22' , '0' , '42.00' ) 29/05/2025 12:02:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1651' AND id_document != '97164' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-13') 29/05/2025 12:02:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1651', document_date = '2025-05-13', 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 = '52.00', price_tax_excluded = '42.62', date_upd = NOW() WHERE id_document = '97164' 29/05/2025 12:02:22 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 = '97164' 29/05/2025 12:02:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97164' 29/05/2025 12:02:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97164' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 29/05/2025 12:02:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97164' , '6014' , 'LUMINO BIANCO - 10B' , '34' , '-34' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '17.00' ) 29/05/2025 12:03:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1634' AND id_document != '97142' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-12') 29/05/2025 12:03:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1634', document_date = '2025-05-12', 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 = '123.75', price_tax_excluded = '104.00', date_upd = NOW() WHERE id_document = '97142' 29/05/2025 12:03:17 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 = '97142' 29/05/2025 12:03:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '97142' 29/05/2025 12:03:17 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 ( '97142' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 29/05/2025 12:03:17 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 ( '97142' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 29/05/2025 12:03:17 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 ( '97142' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 29/05/2025 12:03:17 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 ( '97142' , '19657' , 'STATUA ADDOLORATA CM 20 - 355' , '1' , '-1' , '1' , '44.0000' , '36.065573770492' , '22' , '0' , '44.00' ) 29/05/2025 12:03:17 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 ( '97142' , '6014' , 'LUMINO BIANCO - 10B' , '131' , '-131' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '65.50' ) 29/05/2025 12:03:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1665' AND id_document != '97181' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-14') 29/05/2025 12:03:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1665', document_date = '2025-05-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '97181' 29/05/2025 12:03:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97181' 29/05/2025 12:03:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '97181' 29/05/2025 12:03:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97181' , '6014' , 'LUMINO BIANCO - 10B' , '100' , '-100' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '50.00' ) 29/05/2025 12:04:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1684' AND id_document != '97203' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 29/05/2025 12:04:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1684', document_date = '2025-05-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '61.00', price_tax_excluded = '50.00', date_upd = NOW() WHERE id_document = '97203' 29/05/2025 12:04: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 = '97203' 29/05/2025 12:04:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '97203' 29/05/2025 12:04: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 ( '97203' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 29/05/2025 12:04: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 ( '97203' , '6014' , 'LUMINO BIANCO - 10B' , '110' , '-110' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '55.00' ) 29/05/2025 12:05:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1676' AND id_document != '97193' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 29/05/2025 12:05:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1676', document_date = '2025-05-15', 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 = '19.00', price_tax_excluded = '15.57', date_upd = NOW() WHERE id_document = '97193' 29/05/2025 12:05:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97193' 29/05/2025 12:05:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '97193' 29/05/2025 12:05:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97193' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11.8' , '9.672131147541' , '22' , '0' , '11.80' ) 29/05/2025 12:05:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97193' , '19312' , 'PORTACHIAVE COMUNIONE - 1828/K25' , '1' , '-1' , '1' , '2.7000' , '2.2131147540984' , '22' , '0' , '2.70' ) 29/05/2025 12:05:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97193' , '6014' , 'LUMINO BIANCO - 10B' , '9' , '-9' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '4.50' ) 29/05/2025 12:05:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1669' AND id_document != '97185' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-14') 29/05/2025 12:05:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1669', document_date = '2025-05-14', 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 = '45.70', price_tax_excluded = '37.46', date_upd = NOW() WHERE id_document = '97185' 29/05/2025 12:05:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97185' 29/05/2025 12:05:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '97185' 29/05/2025 12:05:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97185' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 29/05/2025 12:05: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 ( '97185' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '15' , '-15' , '1' , '3' , '2.4590163934426' , '22' , '0' , '45.00' ) 29/05/2025 12:06:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1676' AND id_document != '97193' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 29/05/2025 12:06:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1676', document_date = '2025-05-15', 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 = '19.00', price_tax_excluded = '15.57', date_upd = NOW() WHERE id_document = '97193' 29/05/2025 12:06:31 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 = '97193' 29/05/2025 12:06:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '97193' 29/05/2025 12:06:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97193' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 29/05/2025 12:06:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97193' , '19312' , 'PORTACHIAVE COMUNIONE - 1828/K25' , '1' , '-1' , '1' , '2.7000' , '2.2131147540984' , '22' , '0' , '2.70' ) 29/05/2025 12:06:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97193' , '6014' , 'LUMINO BIANCO - 10B' , '9' , '-9' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '4.50' ) 29/05/2025 12:06:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97193' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 29/05/2025 12:07:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1857' AND id_document != '97396' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-26') 29/05/2025 12:07:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1857', document_date = '2025-05-26', 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 = '54.00', price_tax_excluded = '44.26', date_upd = NOW() WHERE id_document = '97396' 29/05/2025 12:07:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97396' 29/05/2025 12:07:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '97396' 29/05/2025 12:07:47 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 ( '97396' , '22240' , 'PERGAMENA CRESIMA' , '20' , '-20' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '14.00' ) 29/05/2025 12:07:47 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 ( '97396' , '22532' , 'SPILLA COLOMBA - G023' , '20' , '-20' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '24.00' ) 29/05/2025 12:07:47 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 ( '97396' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '8' , '-8' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.00' ) 29/05/2025 12:07:47 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 ( '97396' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 29/05/2025 12:19:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1905' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 12:19:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1905' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.90' , '51.52' , NOW() , NOW() ) 29/05/2025 12:19: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 = '97453' 29/05/2025 12:19:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '97453' 29/05/2025 12:19: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 ( '97453' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 29/05/2025 12:19: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 ( '97453' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/05/2025 12:19: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 ( '97453' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 29/05/2025 12:28:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1906' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 12:28:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1906' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.40' , '17.40' , NOW() , NOW() ) 29/05/2025 12:28:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97454' 29/05/2025 12:28:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '97454' 29/05/2025 12:28:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97454' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/05/2025 12:28:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97454' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/05/2025 12:28:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97454' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.9' , '7.9' , '0' , '0' , '7.90' ) 29/05/2025 12:34:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1834' AND id_document != '97372' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 29/05/2025 12:34:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1834', document_date = '2025-05-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '34.30', price_tax_excluded = '30.69', date_upd = NOW() WHERE id_document = '97372' 29/05/2025 12:34:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97372' 29/05/2025 12:34:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '97372' 29/05/2025 12:34:47 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 ( '97372' , '18895' , 'BRACCIALE DECINA COLORATA - B1757N' , '10' , '-10' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '20.00' ) 29/05/2025 12:34:47 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 ( '97372' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '14.3' , '14.3' , '0' , '0' , '14.30' ) 29/05/2025 03:38:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1907' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 03:38: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' , '1907' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 29/05/2025 03:38: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 = '97455' 29/05/2025 03:38:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '97455' 29/05/2025 03:38: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 ( '97455' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '20' , '-20' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '6.00' ) 29/05/2025 03:38: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 ( '97455' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '20' , '-20' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '20.00' ) 29/05/2025 03:42:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1908' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 03:42:13 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' , '1908' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 29/05/2025 03:42: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 = '97456' 29/05/2025 03:42:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '97456' 29/05/2025 03:42: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 ( '97456' , '23260' , 'COPRI LEGGIO MARIANO LUREX - 671' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 29/05/2025 03:43:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1909' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 03:43:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1909' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 29/05/2025 03:43: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 = '97457' 29/05/2025 03:43:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '97457' 29/05/2025 03:43: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 ( '97457' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 29/05/2025 04:02:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1910' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 04:02:09 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' , '1910' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '7.00' , NOW() , NOW() ) 29/05/2025 04:02:09 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 = '97458' 29/05/2025 04:02:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '97458' 29/05/2025 04:02:09 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 ( '97458' , '22145' , 'UN GIORNO DA RICORDARE - PRIMA COMUNIONE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 29/05/2025 04:53:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1911' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 04:53:51 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' , '1911' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '32.22' , NOW() , NOW() ) 29/05/2025 04:53: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 = '97459' 29/05/2025 04:53:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '97459' 29/05/2025 04:53: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 ( '97459' , '22614' , 'CROCE ARG - CRM-010S' , '1' , '-1' , '1' , '15.50' , '12.704918032787' , '22' , '0' , '15.50' ) 29/05/2025 04:53: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 ( '97459' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '19.1' , '15.655737704918' , '22' , '0' , '19.10' ) 29/05/2025 04:53: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 ( '97459' , '22410' , 'CONFEZIONE COLLANINA PADRE NOSTRO - 4300-T07' , '1' , '-1' , '1' , '2.60' , '2.1311475409836' , '22' , '0' , '2.60' ) 29/05/2025 04:53: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 ( '97459' , '7106' , 'NOVENA A SANTANTONIO ' , '1' , '-1' , '3' , '1.80' , '1.7307692307692' , '4' , '0' , '1.80' ) 29/05/2025 05:18:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1912' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 05:18:40 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' , '1912' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 29/05/2025 05:18:40 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 = '97460' 29/05/2025 05:18:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '97460' 29/05/2025 05:18:40 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 ( '97460' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 29/05/2025 05:18:40 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 ( '97460' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 29/05/2025 06:01:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1913' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 06:01:22 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' , '1913' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.90' , '13.03' , NOW() , NOW() ) 29/05/2025 06:01:22 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 = '97461' 29/05/2025 06:01:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97461' 29/05/2025 06:01:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97461' , '13609' , 'APPENDICHIAVI 12X12 - RAQ' , '1' , '-1' , '1' , '15.90' , '13.032786885246' , '22' , '0' , '15.90' ) 29/05/2025 06:11:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1914' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 06:11:40 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' , '1914' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 29/05/2025 06:11:40 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 = '97462' 29/05/2025 06:11:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '97462' 29/05/2025 06:11:40 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 ( '97462' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 29/05/2025 06:13:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1915' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 06:13: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' , '1915' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 29/05/2025 06:13: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 = '97463' 29/05/2025 06:13:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '97463' 29/05/2025 06:13: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 ( '97463' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '12' , '12' , '0' , '0' , '12.00' ) 29/05/2025 07:29:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1916' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 07:29:13 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' , '1916' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '54.56' , NOW() , NOW() ) 29/05/2025 07:29: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 = '97464' 29/05/2025 07:29:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '97464' 29/05/2025 07:29: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 ( '97464' , '22352' , 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K' , '40' , '-40' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '56.00' ) 29/05/2025 07:29: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 ( '97464' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 29/05/2025 07:39:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1917' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 29/05/2025 07:39:38 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' , '1917' , '2025-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '95.00' , NOW() , NOW() ) 29/05/2025 07:39:38 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 = '97465' 29/05/2025 07:39:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '97465' 29/05/2025 07:39:38 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 ( '97465' , '16154' , 'SULLA TUA PAROLA - TONINO BELLO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 29/05/2025 07:39:38 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 ( '97465' , '22745' , 'VANGELO DEL CORAGGIO - TONINO BELLO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 29/05/2025 07:39:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97465' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '30.49' , '30.49' , '0' , '' , '30.49' ) 29/05/2025 07:39:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97465' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 29/05/2025 07:39:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97465' , '23055' , 'NOVISSIMI - M.A. BENEDETTELLI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' )