27/08/2025 09:17:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2733' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 09:17:29 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' , '2733' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 27/08/2025 09:17:29 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 = '98447' 27/08/2025 09:17:29 am >> DELETE FROM ps_document_detail WHERE id_document = '98447' 27/08/2025 09:17:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98447' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '1' , '-1' , '1' , '6.70' , '5.4918032786885' , '22' , '0' , '6.70' ) 27/08/2025 09:17:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98447' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '1' , '-1' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '7.80' ) 27/08/2025 09:17:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98447' , '11624' , 'PALLA 16X16 - SERV 3 ' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 27/08/2025 09:17:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98447' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 27/08/2025 09:17:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98447' , '13523' , 'COPPIA AMPOLLINE 50 CC - 508' , '1' , '-1' , '1' , '32.00' , '26.229508196721' , '22' , '0' , '32.00' ) 27/08/2025 09:17:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98447' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '37.1' , '30.409836065574' , '22' , '0' , '37.10' ) 27/08/2025 09:17:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98447' , '22962' , 'VINO BIANCO DOLCE MIGNON' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 27/08/2025 09:36:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2258' AND id_document != '97865' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-25') 27/08/2025 09:36:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2258', document_date = '2025-06-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 = '45.00', price_tax_excluded = '43.27', date_upd = NOW() WHERE id_document = '97865' 27/08/2025 09:36: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 = '97865' 27/08/2025 09:36:44 am >> DELETE FROM ps_document_detail WHERE id_document = '97865' 27/08/2025 09:36: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 ( '97865' , '17518' , 'MARIA MADRE DEL SIGNORE - M FRISINA' , '1' , '-1' , '3' , '10.5' , '10.096153846154' , '4' , '0' , '10.50' ) 27/08/2025 09:36: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 ( '97865' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 27/08/2025 09:36: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 ( '97865' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 27/08/2025 09:36: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 ( '97865' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '9.00' ) 27/08/2025 10:02:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2734' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 10:02: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' , '2734' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.45' , '29.45' , NOW() , NOW() ) 27/08/2025 10:02: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 = '98448' 27/08/2025 10:02:49 am >> DELETE FROM ps_document_detail WHERE id_document = '98448' 27/08/2025 10:02: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 ( '98448' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 27/08/2025 10:02: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 ( '98448' , '23004' , 'DONNE SENZA NOME - R. MANDIROLA' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 27/08/2025 10:07:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2735' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 10:07:50 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' , '2735' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 27/08/2025 10:07:50 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 = '98449' 27/08/2025 10:07:50 am >> DELETE FROM ps_document_detail WHERE id_document = '98449' 27/08/2025 10:07:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98449' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 27/08/2025 10:18:24 am >> SELECT document_num FROM ps_document WHERE document_num = '22/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 10:18:24 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 ( '23' , '22/L' , '2025-08-27' , 'L' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '353.00' , '353.00' , NOW() , NOW() ) 27/08/2025 10:18: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 = '98450' 27/08/2025 10:18:24 am >> DELETE FROM ps_document_detail WHERE id_document = '98450' 27/08/2025 10:18: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 ( '98450' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '20' , '56.00' ) 27/08/2025 10:18: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 ( '98450' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '10' , '18.90' ) 27/08/2025 10:18: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 ( '98450' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '10' , '81.00' ) 27/08/2025 10:18: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 ( '98450' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '23' , '-23' , '4' , '3.00' , '3' , '0' , '10' , '62.10' ) 27/08/2025 10:18: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 ( '98450' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '10' , '81.00' ) 27/08/2025 10:18: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 ( '98450' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '10' , '54.00' ) 27/08/2025 10:49:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2736' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 10:49:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2736' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '460.00' , '377.05' , NOW() , NOW() ) 27/08/2025 10:49:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98451' 27/08/2025 10:49:58 am >> DELETE FROM ps_document_detail WHERE id_document = '98451' 27/08/2025 10:49:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98451' , '16461' , 'CLERGY NIDO D\'APE ML - C22' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' ) 27/08/2025 10:49:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98451' , '23162' , 'SERVIZIO MESSA - 5837' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 27/08/2025 10:49:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98451' , '19351' , 'SERVIZIO MESSA MISTO LINO - 7050' , '1' , '-1' , '1' , '52.00' , '42.622950819672' , '22' , '0' , '52.00' ) 27/08/2025 10:49:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98451' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '51.1' , '41.885245901639' , '22' , '0' , '51.10' ) 27/08/2025 10:49:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98451' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '-1' , '1' , '99.00' , '81.147540983607' , '22' , '0' , '99.00' ) 27/08/2025 10:49:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98451' , '22464' , 'CASULA LEGGERA - 1212' , '2' , '-2' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '150.00' ) 27/08/2025 10:55:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2737' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 10:55:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2737' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '151.10' , '128.61' , NOW() , NOW() ) 27/08/2025 10:55:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98452' 27/08/2025 10:55:51 am >> DELETE FROM ps_document_detail WHERE id_document = '98452' 27/08/2025 10:55:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98452' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '117.60' ) 27/08/2025 10:55:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98452' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 27/08/2025 10:55:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98452' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 27/08/2025 11:03:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2738' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 11:03:59 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' , '2738' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 27/08/2025 11:03:59 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 = '98453' 27/08/2025 11:03:59 am >> DELETE FROM ps_document_detail WHERE id_document = '98453' 27/08/2025 11:03:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98453' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 27/08/2025 11:03:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98453' , '5230' , 'INCENSO RAPHAEL ' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 27/08/2025 11:03:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98453' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 27/08/2025 11:08:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2739' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 11:08:21 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' , '2739' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.61' , '17.61' , NOW() , NOW() ) 27/08/2025 11:08:21 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 = '98454' 27/08/2025 11:08:21 am >> DELETE FROM ps_document_detail WHERE id_document = '98454' 27/08/2025 11:08:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98454' , '20301' , 'CREDIAMO - LE PRINCIPALI VERITA DI FEDE' , '5' , '-5' , '4' , '0.90' , '0.9' , '0' , '5' , '4.30' ) 27/08/2025 11:08:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98454' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '5' , '3.80' ) 27/08/2025 11:08:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98454' , '6703' , 'MIO GRAZIE A GESÙ' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '5' , '2.86' ) 27/08/2025 11:08:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98454' , '9586' , 'SANTA MESSA - CATALINA RIVAS' , '5' , '-5' , '4' , '1.40' , '1.4' , '0' , '5' , '6.65' ) 27/08/2025 11:10:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2487' AND id_document != '98140' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-18') 27/08/2025 11:10:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2487', document_date = '2025-07-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '520.50', price_tax_excluded = '431.05', date_upd = NOW() WHERE id_document = '98140' 27/08/2025 11:10: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 = '98140' 27/08/2025 11:10:52 am >> DELETE FROM ps_document_detail WHERE id_document = '98140' 27/08/2025 11:10: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 ( '98140' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '25' , '-25' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '60.00' ) 27/08/2025 11:10: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 ( '98140' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '18' , '-18' , '4' , '0.7000' , '0.7' , '0' , '0' , '12.60' ) 27/08/2025 11:10: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 ( '98140' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/08/2025 11:10: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 ( '98140' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 27/08/2025 11:10: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 ( '98140' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '145.00' ) 27/08/2025 11:10: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 ( '98140' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 27/08/2025 11:10: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 ( '98140' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 27/08/2025 11:10: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 ( '98140' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.3400' , '2.7377049180328' , '22' , '0' , '10.02' ) 27/08/2025 11:10: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 ( '98140' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 27/08/2025 11:10: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 ( '98140' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 27/08/2025 11:10: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 ( '98140' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 27/08/2025 11:10: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 ( '98140' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '1' , '-1' , '3' , '2.0800' , '2' , '4' , '0' , '2.08' ) 27/08/2025 11:10: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 ( '98140' , '23052' , 'DALMATICA MORELLO - PDA004' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 27/08/2025 11:11:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2740' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 11:11:29 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' , '2740' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 27/08/2025 11:11:29 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 = '98455' 27/08/2025 11:11:29 am >> DELETE FROM ps_document_detail WHERE id_document = '98455' 27/08/2025 11:11:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98455' , '18068' , 'SACCO PORTA ELEMOSINA - 1751' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 27/08/2025 11:21:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2334' AND id_document != '97952' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 27/08/2025 11:21:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2334', document_date = '2025-07-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 = '12.70', price_tax_excluded = '11.49', date_upd = NOW() WHERE id_document = '97952' 27/08/2025 11:21:42 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 = '97952' 27/08/2025 11:21:42 am >> DELETE FROM ps_document_detail WHERE id_document = '97952' 27/08/2025 11:21: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 ( '97952' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 27/08/2025 11:21: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 ( '97952' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 27/08/2025 11:21: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 ( '97952' , '4406' , 'GESÙ CONFIDO IN TE - ARS 70' , '10' , '-10' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '1.50' ) 27/08/2025 11:21: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 ( '97952' , '7481' , 'PAPA FRANCESCO' , '2' , '-2' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.40' ) 27/08/2025 11:21: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 ( '97952' , '9478' , 'SAN MATTEO - OGGETTI' , '2' , '-2' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.30' ) 27/08/2025 11:21: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 ( '97952' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 27/08/2025 11:40:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2741' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 11:40:59 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' , '2741' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.50' , '29.33' , NOW() , NOW() ) 27/08/2025 11:40:59 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 = '98456' 27/08/2025 11:40:59 am >> DELETE FROM ps_document_detail WHERE id_document = '98456' 27/08/2025 11:40:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98456' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '25' , '25' , '0' , '0' , '25.00' ) 27/08/2025 11:40:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98456' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 27/08/2025 12:01:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2742' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 12:01:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2742' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 27/08/2025 12:01:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98457' 27/08/2025 12:01:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '98457' 27/08/2025 12:01:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98457' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 27/08/2025 12:07:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2743' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 12:07:49 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' , '2743' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.80' , '53.59' , NOW() , NOW() ) 27/08/2025 12:07:49 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 = '98458' 27/08/2025 12:07:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '98458' 27/08/2025 12:07:49 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 ( '98458' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 27/08/2025 12:07:49 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 ( '98458' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 27/08/2025 12:07:49 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 ( '98458' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 27/08/2025 12:07:49 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 ( '98458' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 27/08/2025 12:08:43 pm >> DELETE FROM ps_document WHERE id_document = '98450' 27/08/2025 12:08:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '98450' 27/08/2025 12:13:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2744' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 12:13:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2744' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '202.22' , '202.22' , NOW() , NOW() ) 27/08/2025 12:13:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98459' 27/08/2025 12:13:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '98459' 27/08/2025 12:13:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98459' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '30' , '-30' , '4' , '5.00' , '5' , '0' , '5' , '142.50' ) 27/08/2025 12:13:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98459' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '100' , '0.00' ) 27/08/2025 12:13:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98459' , '23867' , 'MESSA MEDITAZIONE - SETT/OTT 25' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 27/08/2025 12:13:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98459' , '23823' , 'AMEN - SET 25' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 27/08/2025 12:13:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98459' , '23822' , 'AMEN - OTT 25' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 27/08/2025 12:14:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2745' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 12:14:34 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' , '2745' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 27/08/2025 12:14:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98460' 27/08/2025 12:14:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '98460' 27/08/2025 12:14:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98460' , '23573' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT/25' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 27/08/2025 12:20:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2746' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 12:20:17 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' , '2746' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.80' , '12.73' , NOW() , NOW() ) 27/08/2025 12:20: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 = '98461' 27/08/2025 12:20:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '98461' 27/08/2025 12:20: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 ( '98461' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 27/08/2025 12:20: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 ( '98461' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 27/08/2025 12:20: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 ( '98461' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 27/08/2025 12:22:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2747' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 12:22:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2747' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 27/08/2025 12:22: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 = '98462' 27/08/2025 12:22:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '98462' 27/08/2025 12:22: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 ( '98462' , '19104' , 'LUMINELLI A OLIO' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 27/08/2025 12:22: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 ( '98462' , '13110' , 'S. PAOLO BABY - 023 SGD 9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 27/08/2025 12:22: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 ( '98462' , '14624' , 'SANTA TERESA BABY - 023 STH/9 BB' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 27/08/2025 12:34:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2748' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 27/08/2025 12:34: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' , '2748' , '2025-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.50' , '76.50' , NOW() , NOW() ) 27/08/2025 12:34: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 = '98463' 27/08/2025 12:34:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '98463' 27/08/2025 12:34: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 ( '98463' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '14' , '-14' , '4' , '5.00' , '5' , '0' , '5' , '66.50' ) 27/08/2025 12:34: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 ( '98463' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' )