02/01/2025 09:15:53 am >> SELECT document_num FROM ps_document WHERE document_num = '263' AND id_document != '94801' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-11') 02/01/2025 09:15:53 am >> UPDATE ps_document SET id_document_type = '21', document_num = '263', document_date = '2024-12-11', document_letter = '', id_customer = '65', id_supplier = '', id_address = '4679378', address1 = 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '116.16', price_tax_excluded = '116.16', date_upd = NOW() WHERE id_document = '94801' 02/01/2025 09:15:53 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 = '94801' 02/01/2025 09:15:54 am >> DELETE FROM ps_document_detail WHERE id_document = '94801' 02/01/2025 09:15: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 ( '94801' , '23247' , 'ASCOLTARLO ERA RIMANERE ACCESI - ANNO C - E. RONCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 02/01/2025 09:15: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 ( '94801' , '23108' , 'SUB TUUM PRAESIDIUM' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 02/01/2025 09:15: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 ( '94801' , '22984' , 'GIUBILEO DELLA SPERANZA - D. COSO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 02/01/2025 09:15: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 ( '94801' , '22979' , 'SCOPRIAMO INSIEME IL GIUBILEO' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 02/01/2025 09:15: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 ( '94801' , '21440' , 'MIO LIBRO DI PREGHIERE A MARIA - L. FANZAGA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 02/01/2025 09:15: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 ( '94801' , '23207' , 'GESU, ECO LUOMO - B. SESBOUE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 02/01/2025 09:15: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 ( '94801' , '22676' , 'MI STAI A CUORE - M. SEBASTIANI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 02/01/2025 09:15: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 ( '94801' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 02/01/2025 09:15: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 ( '94801' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '1.6' , '1.6' , '0' , '0' , '3.20' ) 02/01/2025 09:22:52 am >> SELECT document_num FROM ps_document WHERE document_num = '268' AND id_document != '94921' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-18') 02/01/2025 09:22:52 am >> UPDATE ps_document SET id_document_type = '21', document_num = '268', document_date = '2024-12-18', document_letter = '', id_customer = '321', id_supplier = '', id_address = '4672782', address1 = 'VIA LUIGI ANGRISANI 36 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '545.00', price_tax_excluded = '545.00', date_upd = NOW() WHERE id_document = '94921' 02/01/2025 09:22: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 = '94921' 02/01/2025 09:22:52 am >> DELETE FROM ps_document_detail WHERE id_document = '94921' 02/01/2025 09:22: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 ( '94921' , '2679' , 'CONOSCERE GESU\'' , '21' , '-21' , '4' , '3.5000' , '3.5' , '0' , '15' , '62.48' ) 02/01/2025 09:22: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 ( '94921' , '5457' , 'IO SONO CON VOI 1 PARTE' , '17' , '-17' , '4' , '2.8000' , '2.8' , '0' , '15' , '40.46' ) 02/01/2025 09:22: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 ( '94921' , '5444' , 'IO SONO CON VOI - CAT.' , '17' , '-17' , '4' , '5.5000' , '5.5' , '0' , '5' , '88.82' ) 02/01/2025 09:22: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 ( '94921' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '23' , '-23' , '4' , '3.4000' , '3.4' , '0' , '15' , '66.47' ) 02/01/2025 09:22: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 ( '94921' , '8408' , 'PRENDETE E MANGIATE' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 02/01/2025 09:22: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 ( '94921' , '8408' , 'PRENDETE E MANGIATE' , '21' , '-21' , '4' , '3.0000' , '3' , '0' , '15' , '53.55' ) 02/01/2025 09:22: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 ( '94921' , '11192' , 'VENITE CON ME 2 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 02/01/2025 09:22: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 ( '94921' , '0' , 'arrotondamento ' , '1' , '-1' , '4' , '-0.5300' , '-0.53' , '0' , '0' , '-0.53' ) 02/01/2025 09:22: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 ( '94921' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '3' , '-3' , '4' , '11.00' , '11' , '0' , '15' , '28.05' ) 02/01/2025 09:22: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 ( '94921' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '15' , '25.50' ) 02/01/2025 09:22: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 ( '94921' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '2' , '-2' , '4' , '25.00' , '25' , '0' , '15' , '42.50' ) 02/01/2025 09:22: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 ( '94921' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '15' , '25.50' ) 02/01/2025 09:22: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 ( '94921' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.85' , '0.85' , '0' , '0' , '0.85' ) 02/01/2025 09:59:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 09:59:37 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' , '1' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 02/01/2025 09:59:37 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 = '95114' 02/01/2025 09:59:37 am >> DELETE FROM ps_document_detail WHERE id_document = '95114' 02/01/2025 09:59:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95114' , '6049' , 'MADONNA CON BAMBINO - VERDE - PL4011V' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 02/01/2025 10:06:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:06: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' , '2' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.90' , '1.90' , NOW() , NOW() ) 02/01/2025 10:06: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 = '95115' 02/01/2025 10:06:29 am >> DELETE FROM ps_document_detail WHERE id_document = '95115' 02/01/2025 10:06: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 ( '95115' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 02/01/2025 10:19:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3730' AND id_document != '94594' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 02/01/2025 10:19:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3730', document_date = '2024-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.90', price_tax_excluded = '6.72', date_upd = NOW() WHERE id_document = '94594' 02/01/2025 10:19:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94594' 02/01/2025 10:19:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94594' 02/01/2025 10:19:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94594' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 02/01/2025 10:19:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94594' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '1.00' ) 02/01/2025 10:19:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94594' , '23068' , 'PAROLA E PREGHIERA - GEN 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 02/01/2025 10:19:41 am >> DELETE FROM ps_document WHERE id_document = '89846' 02/01/2025 10:19:41 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 02/01/2025 10:22:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '90734' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:22:57 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = 'DDT DEL 13/03/2024 - ACCONTO € 165,00 / 25-10-2024 - € 100,00 07/11/2024 + 60,00 27/12', 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 = '688.16', price_tax_excluded = '581.46', date_upd = NOW() WHERE id_document = '90734' 02/01/2025 10:22:57 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 = '90734' 02/01/2025 10:22:58 am >> DELETE FROM ps_document_detail WHERE id_document = '90734' 02/01/2025 10:22: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 ( '90734' , '19106' , 'FRAGRANZA NARDO' , '3' , '-3' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '48.00' ) 02/01/2025 10:22: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 ( '90734' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '5' , '-5' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '10.00' ) 02/01/2025 10:22: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 ( '90734' , '6629' , 'MIA PREGHIERA' , '3' , '-3' , '4' , '0.9000' , '0.9' , '0' , '0' , '2.70' ) 02/01/2025 10:22: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 ( '90734' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 02/01/2025 10:22: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 ( '90734' , '22099' , 'YOUCAT' , '2' , '-2' , '4' , '18.0000' , '18' , '0' , '5' , '34.20' ) 02/01/2025 10:22: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 ( '90734' , '22810' , 'SULLA VALIDITA DEI SACRAMENTI - A. LAMERI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 02/01/2025 10:22: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 ( '90734' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 02/01/2025 10:22: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 ( '90734' , '23003' , 'SANTA MESSA - M. MIRTILLI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 02/01/2025 10:22: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 ( '90734' , '13086' , 'VENTI SABATI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/01/2025 10:22: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 ( '90734' , '22981' , 'CALENDARIO PARROCCHIALE 2025' , '1' , '-1' , '1' , '11.9000' , '9.7540983606557' , '22' , '5' , '11.31' ) 02/01/2025 10:22: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 ( '90734' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '4' , '-4' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '32.00' ) 02/01/2025 10:22: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 ( '90734' , '1515' , 'CALICE CM 15 INT.ORO IHS' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 02/01/2025 10:22: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 ( '90734' , '1251' , 'BOLO CM 14 INT. ORO IHS ' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 02/01/2025 10:22: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 ( '90734' , '8048' , 'PISSIDE CM 14 INT. ORO IHS ' , '1' , '-1' , '1' , '169.0000' , '138.52459016393' , '22' , '0' , '169.00' ) 02/01/2025 10:22: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 ( '90734' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 02/01/2025 10:22: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 ( '90734' , '7730' , 'PATENA CM 15 IHS - 015BIZ0575' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 02/01/2025 10:24:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '92378' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:24:13 am >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '96', id_supplier = '', id_address = '96', address1 = 'VIA D. CHIESA, 18 24026 LEFFE', address2 = '', note = 'DDT/A DEL 23/05/2022', 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 = '222.00', price_tax_excluded = '222.00', date_upd = NOW() WHERE id_document = '92378' 02/01/2025 10:24: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 = '92378' 02/01/2025 10:24:13 am >> DELETE FROM ps_document_detail WHERE id_document = '92378' 02/01/2025 10:24: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 ( '92378' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 02/01/2025 10:24: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 ( '92378' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 02/01/2025 10:24: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 ( '92378' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 02/01/2025 10:24: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 ( '92378' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 02/01/2025 10:24: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 ( '92378' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 02/01/2025 10:24: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 ( '92378' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 02/01/2025 10:24: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 ( '92378' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 02/01/2025 10:25:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:25:07 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' , '3' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '103.55' , '103.55' , NOW() , NOW() ) 02/01/2025 10:25:07 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 = '95116' 02/01/2025 10:25:07 am >> DELETE FROM ps_document_detail WHERE id_document = '95116' 02/01/2025 10:25:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95116' , '16702' , 'EVANGELIARIO' , '1' , '-1' , '4' , '109.00' , '109' , '0' , '5' , '103.55' ) 02/01/2025 10:25:59 am >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:25: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' , '4' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 02/01/2025 10:25: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 = '95117' 02/01/2025 10:25:59 am >> DELETE FROM ps_document_detail WHERE id_document = '95117' 02/01/2025 10:25: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 ( '95117' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 02/01/2025 10:27:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3/A' AND id_document != '92988' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:27:32 am >> UPDATE ps_document SET id_document_type = '24', document_num = '3/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '1138', id_supplier = '', id_address = '4672220', address1 = 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO', address2 = '', note = 'DDT 93/A DEL 04/09/2024 DA RITIRARE APPENA ARRIVA - CAS. BI PCA 022', 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 = '75.00', price_tax_excluded = '61.48', date_upd = NOW() WHERE id_document = '92988' 02/01/2025 10:27: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 = '92988' 02/01/2025 10:27:32 am >> DELETE FROM ps_document_detail WHERE id_document = '92988' 02/01/2025 10:27: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 ( '92988' , '22464' , 'CASULA LEGGERA - 1212' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 02/01/2025 10:28:17 am >> SELECT document_num FROM ps_document WHERE document_num = '4/A' AND id_document != '93084' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:28:17 am >> UPDATE ps_document SET id_document_type = '24', document_num = '4/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679343', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', address2 = '', note = 'DDT 95/A DEL 10/09/2024 - 45 già pagati e scontrinati', 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 = '171.38', price_tax_excluded = '171.38', date_upd = NOW() WHERE id_document = '93084' 02/01/2025 10:28: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 = '93084' 02/01/2025 10:28:17 am >> DELETE FROM ps_document_detail WHERE id_document = '93084' 02/01/2025 10:28: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 ( '93084' , '23169' , 'DILEXIT NOS ' , '82' , '-82' , '4' , '2.2000' , '2.2' , '0' , '5' , '171.38' ) 02/01/2025 10:28:59 am >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '93247' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:28:59 am >> UPDATE ps_document SET id_document_type = '24', document_num = '5/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '3547', id_supplier = '', id_address = '4679359', address1 = 'SAN LEONARDO 84090 GIFFONI SEI CASALI', address2 = '', note = 'DDT 100/A DEL 23/09/2024', 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 = '184.90', price_tax_excluded = '157.78', date_upd = NOW() WHERE id_document = '93247' 02/01/2025 10:28: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 = '93247' 02/01/2025 10:28:59 am >> DELETE FROM ps_document_detail WHERE id_document = '93247' 02/01/2025 10:28: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 ( '93247' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 02/01/2025 10:28: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 ( '93247' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 02/01/2025 10:28: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 ( '93247' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '25.00' ) 02/01/2025 10:28: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 ( '93247' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '24' , '-24' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '24.00' ) 02/01/2025 10:28: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 ( '93247' , '19231' , 'CARD CARLO ACUTIS - RN93' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 02/01/2025 10:28: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 ( '93247' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 02/01/2025 10:28: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 ( '93247' , '18131' , 'TAU MEDIO CM3 - T6/t5' , '12' , '-12' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '12.00' ) 02/01/2025 10:28: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 ( '93247' , '22923' , 'ROLL UP GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 02/01/2025 10:29:31 am >> SELECT document_num FROM ps_document WHERE document_num = '6/A' AND id_document != '93254' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:29:31 am >> UPDATE ps_document SET id_document_type = '24', document_num = '6/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '31', id_supplier = '', id_address = '4670717', address1 = 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI', address2 = '', note = 'DDT 2024', 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 = '636.00', price_tax_excluded = '521.31', date_upd = NOW() WHERE id_document = '93254' 02/01/2025 10:29:31 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 = '93254' 02/01/2025 10:29:31 am >> DELETE FROM ps_document_detail WHERE id_document = '93254' 02/01/2025 10:29:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '12816' , 'LIBRO DEI DEFUNTI' , '6' , '-6' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '144.00' ) 02/01/2025 10:29:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '12814' , 'LIBRO DEI BATTEZZATI' , '6' , '-6' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '144.00' ) 02/01/2025 10:29:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 02/01/2025 10:29:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '0' , '06/11/2024' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 02/01/2025 10:29:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 02/01/2025 10:29:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 02/01/2025 10:29:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '0' , '11/12' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 02/01/2025 10:29:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '12849' , 'LIBRO DELLE SS. MESSE' , '9' , '-9' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '108.00' ) 02/01/2025 10:30:11 am >> SELECT document_num FROM ps_document WHERE document_num = '7/A' AND id_document != '93699' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:30:11 am >> UPDATE ps_document SET id_document_type = '24', document_num = '7/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = 'CATECHESI - DDT 109/A DEL 18/10/2024', 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 = '189.35', price_tax_excluded = '189.35', date_upd = NOW() WHERE id_document = '93699' 02/01/2025 10:30:11 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 = '93699' 02/01/2025 10:30:11 am >> DELETE FROM ps_document_detail WHERE id_document = '93699' 02/01/2025 10:30:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93699' , '2679' , 'CONOSCERE GESU' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 02/01/2025 10:30:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93699' , '13397' , 'MIO GESU' , '22' , '-22' , '4' , '3.5000' , '3.5' , '0' , '15' , '65.45' ) 02/01/2025 10:30:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93699' , '7543' , 'PARABOLE DI GESÙ' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '15' , '25.50' ) 02/01/2025 10:30:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93699' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 02/01/2025 10:30:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93699' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 02/01/2025 10:30:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93699' , '11193' , 'VENITE CON ME CAT.' , '12' , '-12' , '4' , '5.5000' , '5.5' , '0' , '5' , '62.70' ) 02/01/2025 10:31:57 am >> SELECT document_num FROM ps_document WHERE document_num = '8/A' AND id_document != '93939' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:31:57 am >> UPDATE ps_document SET id_document_type = '24', document_num = '8/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', address2 = '', note = 'DDT 116/A DEL 29/10/2024', 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 = '473.70', price_tax_excluded = '473.70', date_upd = NOW() WHERE id_document = '93939' 02/01/2025 10:31:57 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 = '93939' 02/01/2025 10:31:57 am >> DELETE FROM ps_document_detail WHERE id_document = '93939' 02/01/2025 10:31:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '0' , '5.50' ) 02/01/2025 10:31:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '9675' , 'SARETE MIEI TESTIMONI' , '28' , '-28' , '4' , '3.5000' , '3.5' , '0' , '0' , '98.00' ) 02/01/2025 10:31:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '0' , '11.00' ) 02/01/2025 10:31:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '11192' , 'VENITE CON ME 2 PARTE' , '25' , '-25' , '4' , '2.8000' , '2.8' , '0' , '0' , '70.00' ) 02/01/2025 10:31:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '11191' , 'VENITE CON ME 1 PARTE' , '14' , '-14' , '4' , '2.8000' , '2.8' , '0' , '0' , '39.20' ) 02/01/2025 10:31:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '5444' , 'IO SONO CON VOI - CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '0' , '11.00' ) 02/01/2025 10:31:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '5457' , 'IO SONO CON VOI 1 PARTE' , '23' , '-23' , '4' , '2.8000' , '2.8' , '0' , '0' , '64.40' ) 02/01/2025 10:31: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 ( '93939' , '5458' , 'IO SONO CON VOI 2 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '0' , '53.20' ) 02/01/2025 10:31: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 ( '93939' , '13397' , 'MIO GESU' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '0' , '70.00' ) 02/01/2025 10:31: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 ( '93939' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.4000' , '2.4' , '0' , '0' , '2.40' ) 02/01/2025 10:31: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 ( '93939' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 02/01/2025 10:31: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 ( '93939' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 02/01/2025 10:31: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 ( '93939' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 02/01/2025 10:31: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 ( '93939' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 02/01/2025 10:31: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 ( '93939' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 02/01/2025 10:32:35 am >> SELECT document_num FROM ps_document WHERE document_num = '9/A' AND id_document != '94084' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:32:35 am >> UPDATE ps_document SET id_document_type = '24', document_num = '9/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'LEPORE MIMMO - DDT 117/A DEL 06/11/2024', 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 = '48.90', price_tax_excluded = '40.08', date_upd = NOW() WHERE id_document = '94084' 02/01/2025 10:32:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94084' 02/01/2025 10:32:35 am >> DELETE FROM ps_document_detail WHERE id_document = '94084' 02/01/2025 10:32:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94084' , '20074' , 'ROSARIO ARG/PERLA/EMATITE ' , '1' , '-1' , '1' , '48.9000' , '40.081967213115' , '22' , '0' , '48.90' ) 02/01/2025 10:33:07 am >> SELECT document_num FROM ps_document WHERE document_num = '10/A' AND id_document != '94115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:33:07 am >> UPDATE ps_document SET id_document_type = '24', document_num = '10/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '1213', id_supplier = '', id_address = '4679403', address1 = 'VIA CONVENTO 83025 MONTORO', address2 = '', note = 'DDT 119/A DEL 07/11/2024', 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 = '275.00', price_tax_excluded = '225.41', date_upd = NOW() WHERE id_document = '94115' 02/01/2025 10:33:07 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 = '94115' 02/01/2025 10:33:07 am >> DELETE FROM ps_document_detail WHERE id_document = '94115' 02/01/2025 10:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '20227' , 'BAMBINELLO GESSO CM 40 STILE ANTICO - J202/40' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 02/01/2025 10:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '23223' , 'COPRILEGGIO - CL10' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 02/01/2025 10:33:53 am >> SELECT document_num FROM ps_document WHERE document_num = '11/A' AND id_document != '94256' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:33:53 am >> UPDATE ps_document SET id_document_type = '24', document_num = '11/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'DDT 124/A DEL 14/11/2024 - acconto 05/12 € 260,00', 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 = '828.32', price_tax_excluded = '797.38', date_upd = NOW() WHERE id_document = '94256' 02/01/2025 10:33:53 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 = '94256' 02/01/2025 10:33:53 am >> DELETE FROM ps_document_detail WHERE id_document = '94256' 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '48' , '-48' , '4' , '3.8000' , '3.8' , '0' , '15' , '155.04' ) 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.8000' , '3.8' , '0' , '15' , '164.73' ) 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '0' , 'natività campana ' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '0' , '110.00' ) 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '30' , '-30' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '54.00' ) 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '7.20' ) 02/01/2025 10:33:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '14.40' ) 02/01/2025 10:34:33 am >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '94688' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:34:33 am >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '3029', id_supplier = '', id_address = '4669124', address1 = 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO', address2 = '', note = 'DDT 131/A DEL 04/12/2025', 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 = '410.80', price_tax_excluded = '338.00', date_upd = NOW() WHERE id_document = '94688' 02/01/2025 10:34:33 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 = '94688' 02/01/2025 10:34:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94688' 02/01/2025 10:34:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94688' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '300' , '-300' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '75.00' ) 02/01/2025 10:34:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94688' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 02/01/2025 10:34:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94688' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '180.00' ) 02/01/2025 10:34:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94688' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 02/01/2025 10:34:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94688' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 02/01/2025 10:34:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94688' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/01/2025 10:34:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94688' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 02/01/2025 10:34:55 am >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:34:55 am >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '143.90', price_tax_excluded = '118.23', date_upd = NOW() WHERE id_document = '94912' 02/01/2025 10:34:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94912' 02/01/2025 10:34:55 am >> DELETE FROM ps_document_detail WHERE id_document = '94912' 02/01/2025 10:34: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 ( '94912' , '22907' , 'AGENDINA 2025 - 40827' , '2' , '-2' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '14.00' ) 02/01/2025 10:34: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 ( '94912' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '60' , '-60' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '120.00' ) 02/01/2025 10:34: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 ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/01/2025 10:34: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 ( '94912' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 02/01/2025 10:35:14 am >> SELECT document_num FROM ps_document WHERE document_num = '14/A' AND id_document != '94924' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:35:14 am >> UPDATE ps_document SET id_document_type = '24', document_num = '14/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '4150', id_supplier = '', id_address = '4679449', address1 = 'VIA LUIGI ANGRISANI 36 84100 SALERNO', address2 = '', note = 'E C 268', 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 = '300.00', price_tax_excluded = '245.90', date_upd = NOW() WHERE id_document = '94924' 02/01/2025 10:35:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94924' 02/01/2025 10:35:14 am >> DELETE FROM ps_document_detail WHERE id_document = '94924' 02/01/2025 10:35:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94924' , '18371' , 'CAMICE MISTO LANA - 70/000403' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 02/01/2025 10:35:31 am >> SELECT document_num FROM ps_document WHERE document_num = '15/A' AND id_document != '94983' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:35:31 am >> UPDATE ps_document SET id_document_type = '24', document_num = '15/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4679440', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '23.50', price_tax_excluded = '22.73', date_upd = NOW() WHERE id_document = '94983' 02/01/2025 10:35:31 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 = '94983' 02/01/2025 10:35:31 am >> DELETE FROM ps_document_detail WHERE id_document = '94983' 02/01/2025 10:35:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 02/01/2025 10:35:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 02/01/2025 10:36:05 am >> SELECT document_num FROM ps_document WHERE document_num = '16/A' AND id_document != '95048' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:36:05 am >> UPDATE ps_document SET id_document_type = '24', document_num = '16/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4679091', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'DDT 140 DEL 27/12/2024', 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 = '335.83', price_tax_excluded = '301.57', date_upd = NOW() WHERE id_document = '95048' 02/01/2025 10:36:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95048' 02/01/2025 10:36:05 am >> DELETE FROM ps_document_detail WHERE id_document = '95048' 02/01/2025 10:36:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23298' , 'RIMETTI A NOI I NOSTRI DEBITI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 02/01/2025 10:36:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23332' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 02/01/2025 10:36:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '5' , '9.03' ) 02/01/2025 10:36:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23300' , 'DOMENICA DELLA PAROLA 2025' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.75' ) 02/01/2025 10:36:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23324' , 'PELLEGRINI DI SPERANZA' , '2' , '-2' , '4' , '3.0000' , '3' , '0' , '5' , '5.70' ) 02/01/2025 10:36:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '3' , '-3' , '4' , '42.0000' , '42' , '0' , '5' , '119.70' ) 02/01/2025 10:36:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 02/01/2025 10:36:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '140.00' ) 02/01/2025 10:36:55 am >> SELECT document_num FROM ps_document WHERE document_num = '17/A' AND id_document != '95077' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:36:55 am >> UPDATE ps_document SET id_document_type = '24', document_num = '17/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = 'DDT 141/A DEL 28/12/2024', 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 = '196.25', price_tax_excluded = '172.45', date_upd = NOW() WHERE id_document = '95077' 02/01/2025 10:36:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95077' 02/01/2025 10:36:55 am >> DELETE FROM ps_document_detail WHERE id_document = '95077' 02/01/2025 10:36: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 ( '95077' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 02/01/2025 10:36: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 ( '95077' , '0' , 'SACRA FAMIGLIA' , '3' , '-3' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '15.00' ) 02/01/2025 10:36: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 ( '95077' , '0' , 'buono' , '1' , '-1' , '0' , '50.0000' , '50' , '0' , '0' , '50.00' ) 02/01/2025 10:36: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 ( '95077' , '23326' , 'ASCOLTARE, CONDIVIDERE, ORIENTARSI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 02/01/2025 10:36: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 ( '95077' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '102.00' ) 02/01/2025 10:37:49 am >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '94993' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 10:37:49 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'C/ VISIONE DON FRANCO BELLIZZI - DDT 139/A DEL 21/12/2024', 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 = '150.00', price_tax_excluded = '150.00', date_upd = NOW() WHERE id_document = '94993' 02/01/2025 10:37: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 = '94993' 02/01/2025 10:37:49 am >> DELETE FROM ps_document_detail WHERE id_document = '94993' 02/01/2025 10:37: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 ( '94993' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '150.0000' , '150' , '0' , '0' , '150.00' ) 02/01/2025 11:29:29 am >> SELECT document_num FROM ps_document WHERE document_num = '5' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 11:29: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' , '5' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.10' , '2.10' , NOW() , NOW() ) 02/01/2025 11:29: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 = '95118' 02/01/2025 11:29:29 am >> DELETE FROM ps_document_detail WHERE id_document = '95118' 02/01/2025 11:29: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 ( '95118' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 02/01/2025 11:38:15 am >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 11:38:15 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' , '6' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 02/01/2025 11:38:15 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 = '95119' 02/01/2025 11:38:15 am >> DELETE FROM ps_document_detail WHERE id_document = '95119' 02/01/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95119' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 02/01/2025 11:44:19 am >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 11:44:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '158.90', price_tax_excluded = '133.23', date_upd = NOW() WHERE id_document = '94912' 02/01/2025 11:44:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94912' 02/01/2025 11:44:19 am >> DELETE FROM ps_document_detail WHERE id_document = '94912' 02/01/2025 11:44:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '22907' , 'AGENDINA 2025 - 40827' , '2' , '-2' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '14.00' ) 02/01/2025 11:44:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '60' , '-60' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '120.00' ) 02/01/2025 11:44:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/01/2025 11:44:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 02/01/2025 11:44:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '0' , '15.00' ) 02/01/2025 11:51:10 am >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 11:51:10 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' , '7' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 02/01/2025 11:51:10 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 = '95120' 02/01/2025 11:51:10 am >> DELETE FROM ps_document_detail WHERE id_document = '95120' 02/01/2025 11:51:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95120' , '23068' , 'PAROLA E PREGHIERA - GEN 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 02/01/2025 11:51:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95120' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 02/01/2025 11:56:51 am >> SELECT document_num FROM ps_document WHERE document_num = '8' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 11:56:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '8' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '7.90' , NOW() , NOW() ) 02/01/2025 11:56:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95121' 02/01/2025 11:56:51 am >> DELETE FROM ps_document_detail WHERE id_document = '95121' 02/01/2025 11:56:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95121' , '22915' , 'CINQUE PANI DORZO 2025' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 02/01/2025 12:08:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 12:08: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' , '9' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 02/01/2025 12:08: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 = '95122' 02/01/2025 12:08:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '95122' 02/01/2025 12:08: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 ( '95122' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 02/01/2025 12:08: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 ( '95122' , '20026' , 'CANDELA VOTIVA 20X40' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 02/01/2025 12:15:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 12:15:35 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' , '10' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 02/01/2025 12:15:35 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 = '95123' 02/01/2025 12:15:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '95123' 02/01/2025 12:15:35 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 ( '95123' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 02/01/2025 12:35:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '11' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 12:35:20 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' , '11' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.10' , '5.82' , NOW() , NOW() ) 02/01/2025 12:35:20 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 = '95124' 02/01/2025 12:35:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '95124' 02/01/2025 12:35:20 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 ( '95124' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 02/01/2025 12:35:20 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 ( '95124' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 02/01/2025 03:01:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 03:01:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '12' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '940.00' , '775.46' , NOW() , NOW() ) 02/01/2025 03:01:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95125' 02/01/2025 03:01:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '95125' 02/01/2025 03:01:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95125' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '850' , '696.72131147541' , '22' , '0' , '850.00' ) 02/01/2025 03:01:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95125' , '1914' , 'CERA DELLA LITURGIA' , '11' , '-11' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '51.70' ) 02/01/2025 03:01:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95125' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '3.30' ) 02/01/2025 03:01:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95125' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 02/01/2025 03:12:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 03:12: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' , '13' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 02/01/2025 03:12: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 = '95126' 02/01/2025 03:12:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '95126' 02/01/2025 03:12: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 ( '95126' , '23147' , 'SPILLA PORTA CIUCCIO ROSA' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 02/01/2025 03:22:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 03:22:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '14' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 02/01/2025 03:22:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95127' 02/01/2025 03:22:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '95127' 02/01/2025 03:22:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95127' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/01/2025 04:00:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 04:00:42 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' , '15' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 02/01/2025 04:00:42 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 = '95128' 02/01/2025 04:00:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '95128' 02/01/2025 04:00:42 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 ( '95128' , '17569' , 'BAMBINO IN RESINA - PB6277' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 02/01/2025 05:16:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 05:16:03 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' , '16' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '19.50' , NOW() , NOW() ) 02/01/2025 05:16:03 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 = '95129' 02/01/2025 05:16:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '95129' 02/01/2025 05:16:03 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 ( '95129' , '23292' , 'SPERANZA NON DELUDE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 02/01/2025 05:16:03 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 ( '95129' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 02/01/2025 06:49:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 02/01/2025 06:49:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '17' , '2025-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.90' , '5.90' , NOW() , NOW() ) 02/01/2025 06:49:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95130' 02/01/2025 06:49:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '95130' 02/01/2025 06:49:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95130' , '16931' , 'ROSARIO CON SAN PIO DA PIETRELCINA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 02/01/2025 06:49:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95130' , '7105' , 'NOVENA A SAN PIO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' )