14/06/2025 09:36:00 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 14/06/2025 09:36:00 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = 'ACCONTO: 13/06 € 283,50', 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 = '805.07', price_tax_excluded = '671.28', date_upd = NOW() WHERE id_document = '95409' 14/06/2025 09:36:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95409' 14/06/2025 09:36:00 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 14/06/2025 09:36:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '90.00' ) 14/06/2025 09:36:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '9/3/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/06/2025 09:36:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '25' , '-25' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '60.00' ) 14/06/2025 09:36:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '27/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '18' , '-18' , '4' , '0.7000' , '0.7' , '0' , '0' , '12.60' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '26/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '11/04' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '145.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.3400' , '2.7377049180328' , '22' , '0' , '10.02' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '7202' , 'ARTICOLI RELIGIOSI buste palma' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '56.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '30/04/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '24/05' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '4/6/25' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '15463' , 'PICCOLO CATECHISMO DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '7202' , 'ARTICOLI RELIGIOSI PLACCA COMUNIONE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '25' , '-25' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '55.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '06/06' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '6019' , 'LUMINO ROSSO - 10B' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '5312' , 'INNO ALLO SPIRITO SANTO' , '50' , '-50' , '4' , '0.2000' , '0.2' , '0' , '0' , '10.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '20516' , 'CROCE COMUNIONE - 42/08' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '' , '14/06' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '7.50' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '10' , '-10' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '22.00' ) 14/06/2025 09:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 14/06/2025 09:43:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 09:43:08 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' , '2129' , '2025-06-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.15' , '16.15' , NOW() , NOW() ) 14/06/2025 09:43:08 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 = '97712' 14/06/2025 09:43:08 am >> DELETE FROM ps_document_detail WHERE id_document = '97712' 14/06/2025 09:43:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97712' , '23654' , 'MARIA LA PIU BELLA DEL MONDO - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 14/06/2025 09:56:50 am >> SELECT document_num FROM ps_document WHERE document_num = '89/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 09:56: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 ( '24' , '89/A' , '2025-06-14' , 'A' , '2739' , '0' , '4671014' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '10.32' , NOW() , NOW() ) 14/06/2025 09:56: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 = '97713' 14/06/2025 09:56:50 am >> DELETE FROM ps_document_detail WHERE id_document = '97713' 14/06/2025 09:56: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 ( '97713' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 14/06/2025 09:56: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 ( '97713' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 14/06/2025 10:48:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 10:48:18 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' , '2130' , '2025-06-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 14/06/2025 10:48: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 = '97714' 14/06/2025 10:48:18 am >> DELETE FROM ps_document_detail WHERE id_document = '97714' 14/06/2025 10:48: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 ( '97714' , '20026' , 'CANDELA VOTIVA 20X40' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 14/06/2025 11:15:23 am >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '96242' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-15') 14/06/2025 11:15:23 am >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2025-03-15', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'PRIME COMUNIONI', 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 = '504.50', price_tax_excluded = '413.52', date_upd = NOW() WHERE id_document = '96242' 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96242' 14/06/2025 11:15:23 am >> DELETE FROM ps_document_detail WHERE id_document = '96242' 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '20516' , 'CROCE COMUNIONE - 42/08' , '24' , '-24' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '28.80' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '30' , '-30' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '60.00' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '0' , '27/05' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '' , '14/06' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '16730' , 'TUNICA AVORIO BORDO ORO - AETA03B05' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 14/06/2025 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '14919' , 'CASULA - POLIESTERE - PCA022' , '2' , '-2' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '158.00' ) 14/06/2025 11:15:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2131' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 11:15:43 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' , '2131' , '2025-06-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 14/06/2025 11:15:43 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 = '97715' 14/06/2025 11:15:43 am >> DELETE FROM ps_document_detail WHERE id_document = '97715' 14/06/2025 11:15:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97715' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 14/06/2025 11:30:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2132' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 11:30: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' , '2132' , '2025-06-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '14.59' , NOW() , NOW() ) 14/06/2025 11:30: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 = '97716' 14/06/2025 11:30:52 am >> DELETE FROM ps_document_detail WHERE id_document = '97716' 14/06/2025 11:30: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 ( '97716' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 14/06/2025 11:38:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 11:38:40 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' , '2133' , '2025-06-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.16' , '14.16' , NOW() , NOW() ) 14/06/2025 11:38: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 = '97717' 14/06/2025 11:38:40 am >> DELETE FROM ps_document_detail WHERE id_document = '97717' 14/06/2025 11:38: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 ( '97717' , '17186' , 'MIA PRIMA COMUNIONE - ALBUM' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 14/06/2025 11:48:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2134' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 11:48: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' , '2134' , '2025-06-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 14/06/2025 11:48: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 = '97718' 14/06/2025 11:48:49 am >> DELETE FROM ps_document_detail WHERE id_document = '97718' 14/06/2025 11:48: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 ( '97718' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 14/06/2025 12:01:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2135' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 12:01:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2135' , '2025-06-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '148.00' , '128.16' , NOW() , NOW() ) 14/06/2025 12:01:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97719' 14/06/2025 12:01:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '97719' 14/06/2025 12:01:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97719' , '15019' , 'PREGHIAMO CON MARIA' , '50' , '-50' , '4' , '0.80' , '0.8' , '0' , '5' , '38.00' ) 14/06/2025 12:01:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97719' , '15104' , 'ROSARIO BOTTIGLIA ' , '50' , '-50' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '110.00' ) 14/06/2025 12:04:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2136' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 12:04:01 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' , '2136' , '2025-06-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.70' , '11.36' , NOW() , NOW() ) 14/06/2025 12:04: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 = '97720' 14/06/2025 12:04:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '97720' 14/06/2025 12:04: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 ( '97720' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 14/06/2025 12:04: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 ( '97720' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.7' , '0.7' , '0' , '0' , '0.70' ) 14/06/2025 12:08:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2135' AND id_document != '97719' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 12:08:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2135', document_date = '2025-06-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 = '148.00', price_tax_excluded = '128.16', date_upd = NOW() WHERE id_document = '97719' 14/06/2025 12:08:54 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 = '97719' 14/06/2025 12:08:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '97719' 14/06/2025 12:08:54 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 ( '97719' , '15019' , 'PREGHIAMO CON MARIA' , '50' , '-50' , '4' , '0.8000' , '0.8' , '0' , '5' , '38.00' ) 14/06/2025 12:08:54 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 ( '97719' , '15104' , 'ROSARIO BOTTIGLIA ' , '15' , '-15' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '33.00' ) 14/06/2025 12:08:54 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 ( '97719' , '15105' , 'ROSARIO BOTTIGLIA - 187' , '15' , '-15' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '33.00' ) 14/06/2025 12:08:54 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 ( '97719' , '15106' , 'ROSARIO BOTTIGLIA - 192/08' , '20' , '-20' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '44.00' ) 14/06/2025 12:34:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2137' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 12:34:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2137' , '2025-06-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 14/06/2025 12:34:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97721' 14/06/2025 12:34:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '97721' 14/06/2025 12:34:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97721' , '2756' , 'CORONA ANGELICA - 8197' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 14/06/2025 12:39:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2138' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-14') 14/06/2025 12:39: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' , '2138' , '2025-06-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 14/06/2025 12:39: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 = '97722' 14/06/2025 12:39:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97722' 14/06/2025 12:39: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 ( '97722' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' )