06/12/2025 11:10:09 am >> SELECT document_num FROM ps_document WHERE document_num = '4096' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:10:09 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' , '4096' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '4.82' , NOW() , NOW() ) 06/12/2025 11:10:09 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 = '100314' 06/12/2025 11:10:09 am >> DELETE FROM ps_document_detail WHERE id_document = '100314' 06/12/2025 11:10:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100314' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 06/12/2025 11:10:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100314' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 06/12/2025 11:11:16 am >> SELECT document_num FROM ps_document WHERE document_num = '4097' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:11:16 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' , '4097' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.90' , '38.44' , NOW() , NOW() ) 06/12/2025 11:11:16 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 = '100315' 06/12/2025 11:11:16 am >> DELETE FROM ps_document_detail WHERE id_document = '100315' 06/12/2025 11:11:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100315' , '16588' , 'CLERGY DIAGONALE ML - C06' , '1' , '-1' , '1' , '46.90' , '38.44262295082' , '22' , '0' , '46.90' ) 06/12/2025 11:12:14 am >> SELECT document_num FROM ps_document WHERE document_num = '4098' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:12:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4098' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 06/12/2025 11:12: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 = '100316' 06/12/2025 11:12:14 am >> DELETE FROM ps_document_detail WHERE id_document = '100316' 06/12/2025 11:12: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 ( '100316' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '100' , '-100' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '25.00' ) 06/12/2025 11:12: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 ( '100316' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 06/12/2025 11:12:31 am >> SELECT document_num FROM ps_document WHERE document_num = '4099' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:12:31 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' , '4099' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '4.00' , NOW() , NOW() ) 06/12/2025 11:12: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 = '100317' 06/12/2025 11:12:31 am >> DELETE FROM ps_document_detail WHERE id_document = '100317' 06/12/2025 11:12: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 ( '100317' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 06/12/2025 11:12:56 am >> SELECT document_num FROM ps_document WHERE document_num = '4100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:12:56 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' , '4100' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 06/12/2025 11:12:56 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 = '100318' 06/12/2025 11:12:56 am >> DELETE FROM ps_document_detail WHERE id_document = '100318' 06/12/2025 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100318' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/12/2025 11:13:39 am >> SELECT document_num FROM ps_document WHERE document_num = '4101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:13:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4101' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 06/12/2025 11:13:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100319' 06/12/2025 11:13:39 am >> DELETE FROM ps_document_detail WHERE id_document = '100319' 06/12/2025 11:13:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100319' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 06/12/2025 11:13:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100319' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 06/12/2025 11:13:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100319' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 06/12/2025 11:14:05 am >> SELECT document_num FROM ps_document WHERE document_num = '4102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:14:05 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' , '4102' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 06/12/2025 11:14: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 = '100320' 06/12/2025 11:14:05 am >> DELETE FROM ps_document_detail WHERE id_document = '100320' 06/12/2025 11:14: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 ( '100320' , '24168' , 'AVVENTO 2025 GIORNO PER GIORNO' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 06/12/2025 11:14:52 am >> SELECT document_num FROM ps_document WHERE document_num = '4103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:14:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4103' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 06/12/2025 11:14: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 = '100321' 06/12/2025 11:14:52 am >> DELETE FROM ps_document_detail WHERE id_document = '100321' 06/12/2025 11:14: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 ( '100321' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 06/12/2025 11:19:17 am >> SELECT document_num FROM ps_document WHERE document_num = '143/A' AND id_document != '100002' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-19') 06/12/2025 11:19:17 am >> UPDATE ps_document SET id_document_type = '24', document_num = '143/A', document_date = '2025-11-19', document_letter = 'A', id_customer = '316', id_supplier = '', id_address = '4669506', address1 = 'VIA VITO LEMBO, 2 84020 PALOMONTE', 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 = '398.28', price_tax_excluded = '389.08', date_upd = NOW() WHERE id_document = '100002' 06/12/2025 11:19: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 = '100002' 06/12/2025 11:19:17 am >> DELETE FROM ps_document_detail WHERE id_document = '100002' 06/12/2025 11:19: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 ( '100002' , '13397' , 'MIO GESU' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 06/12/2025 11:19: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 ( '100002' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 06/12/2025 11:19: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 ( '100002' , '10751' , 'TU MI PERDONI' , '15' , '-15' , '4' , '6.9000' , '6.9' , '0' , '5' , '98.33' ) 06/12/2025 11:19: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 ( '100002' , '14719' , 'TU MI AMI DAVVERO' , '25' , '-25' , '4' , '6.9000' , '6.9' , '0' , '5' , '163.88' ) 06/12/2025 11:19: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 ( '100002' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '-1' , '1' , '51.0000' , '41.803278688525' , '22' , '0' , '51.00' ) 06/12/2025 11:19: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 ( '100002' , '' , '06/12' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 06/12/2025 11:19: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 ( '100002' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '15' , '5.95' ) 06/12/2025 11:19: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 ( '100002' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 06/12/2025 11:19: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 ( '100002' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 06/12/2025 11:20:55 am >> SELECT document_num FROM ps_document WHERE document_num = '247' AND id_document != '99990' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-19') 06/12/2025 11:20:55 am >> UPDATE ps_document SET id_document_type = '21', document_num = '247', document_date = '2025-11-19', document_letter = '', id_customer = '1083', id_supplier = '', id_address = '4674059', address1 = 'VIA CREMONA, 1 83020 S. MICHELE DI SERINO', 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 = '217.09', price_tax_excluded = '217.09', date_upd = NOW() WHERE id_document = '99990' 06/12/2025 11:20:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99990' 06/12/2025 11:20:55 am >> DELETE FROM ps_document_detail WHERE id_document = '99990' 06/12/2025 11:20:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99990' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 06/12/2025 11:20:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99990' , '11183' , 'VENITE CON ME - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 06/12/2025 11:20:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99990' , '11192' , 'VENITE CON ME 2 PARTE' , '23' , '-23' , '4' , '2.8000' , '2.8' , '0' , '15' , '54.74' ) 06/12/2025 11:20:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99990' , '11191' , 'VENITE CON ME 1 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 06/12/2025 11:20:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99990' , '2679' , 'CONOSCERE GESU' , '26' , '-26' , '4' , '3.5000' , '3.5' , '0' , '15' , '77.35' ) 06/12/2025 11:29:25 am >> SELECT document_num FROM ps_document WHERE document_num = '4104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:29:25 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' , '4104' , '2025-12-06' , '' , '3712' , '0' , '4671443' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '263.73' , NOW() , NOW() ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100322' 06/12/2025 11:29:25 am >> DELETE FROM ps_document_detail WHERE id_document = '100322' 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '30' , '-30' , '1' , '0.7000' , '0.5738' , '22' , '0' , '21.00' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '22240' , 'PERGAMENA CRESIMA' , '15' , '-15' , '1' , '0.7000' , '0.5738' , '22' , '0' , '10.50' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '29' , '-29' , '4' , '3.5000' , '3.5' , '0' , '15' , '86.28' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9231' , '4' , '0' , '2.00' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.459' , '22' , '0' , '6.00' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2951' , '22' , '0' , '8.90' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2951' , '22' , '0' , '8.90' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2951' , '22' , '0' , '8.90' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8689' , '22' , '0' , '7.00' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.459' , '22' , '0' , '3.00' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2951' , '22' , '0' , '8.90' ) 06/12/2025 11:29:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '15387' , 'VESTINA BATTESIMALE ' , '1' , '-1' , '1' , '1.82' , '1.4918032786885' , '22' , '' , '1.82' ) 06/12/2025 11:31:05 am >> DELETE FROM ps_document WHERE id_document = '96750' 06/12/2025 11:31:05 am >> DELETE FROM ps_document_detail WHERE id_document = '96750' 06/12/2025 11:33:03 am >> SELECT document_num FROM ps_document WHERE document_num = '4104' AND id_document != '100322' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:33:03 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4104', document_date = '2025-12-06', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA DALMAZIA 6 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 = '300.00', price_tax_excluded = '263.73', date_upd = NOW() WHERE id_document = '100322' 06/12/2025 11:33:03 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 = '100322' 06/12/2025 11:33:03 am >> DELETE FROM ps_document_detail WHERE id_document = '100322' 06/12/2025 11:33:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '30' , '-30' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '21.00' ) 06/12/2025 11:33:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '22240' , 'PERGAMENA CRESIMA' , '15' , '-15' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '10.50' ) 06/12/2025 11:33:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '29' , '-29' , '4' , '3.5000' , '3.5' , '0' , '15' , '86.28' ) 06/12/2025 11:33:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 06/12/2025 11:33:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 06/12/2025 11:33:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100322' , '15387' , 'VESTINA BATTESIMALE ' , '1' , '-1' , '1' , '1.8200' , '1.4918032786885' , '22' , '' , '1.82' ) 06/12/2025 11:42:38 am >> SELECT document_num FROM ps_document WHERE document_num = '4105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:42:38 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' , '4105' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.70' , '10.41' , NOW() , NOW() ) 06/12/2025 11:42:38 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 = '100323' 06/12/2025 11:42:38 am >> DELETE FROM ps_document_detail WHERE id_document = '100323' 06/12/2025 11:42:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100323' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 06/12/2025 11:42:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100323' , '15096' , 'CORONA MATRIMONIO ARG - 197/35' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 06/12/2025 11:42:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100323' , '21795' , 'GRUPPO NATIVITA CM 10 LEGNO - PB19888' , '1' , '-1' , '1' , '4.20' , '3.4426229508197' , '22' , '0' , '4.20' ) 06/12/2025 11:45:40 am >> SELECT document_num FROM ps_document WHERE document_num = '4106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:45:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4106' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.49' , '34.49' , NOW() , NOW() ) 06/12/2025 11:45:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100324' 06/12/2025 11:45:40 am >> DELETE FROM ps_document_detail WHERE id_document = '100324' 06/12/2025 11:45:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100324' , '24221' , 'DILEXI TE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 06/12/2025 11:45:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100324' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 06/12/2025 11:45:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100324' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 06/12/2025 11:47:36 am >> SELECT document_num FROM ps_document WHERE document_num = '4107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:47:36 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' , '4107' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '82.11' , NOW() , NOW() ) 06/12/2025 11:47:36 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 = '100325' 06/12/2025 11:47:36 am >> DELETE FROM ps_document_detail WHERE id_document = '100325' 06/12/2025 11:47:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100325' , '19357' , 'DALMATICA ROSA - AEDA01' , '1' , '-1' , '1' , '99.2' , '81.311475409836' , '22' , '0' , '99.20' ) 06/12/2025 11:47:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100325' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 06/12/2025 11:48:25 am >> SELECT document_num FROM ps_document WHERE document_num = '4108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:48:25 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' , '4108' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 06/12/2025 11:48:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100326' 06/12/2025 11:48:25 am >> DELETE FROM ps_document_detail WHERE id_document = '100326' 06/12/2025 11:48:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100326' , '24298' , 'DISEGNARE NUOVE MAPPE DI SPERANZA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 06/12/2025 11:48:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100326' , '24215' , 'DILEXI TE - 8429' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 06/12/2025 11:52:18 am >> SELECT document_num FROM ps_document WHERE document_num = '4109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:52:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4109' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 06/12/2025 11:52:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100327' 06/12/2025 11:52:18 am >> DELETE FROM ps_document_detail WHERE id_document = '100327' 06/12/2025 11:52:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100327' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 06/12/2025 11:52:59 am >> SELECT document_num FROM ps_document WHERE document_num = '4109' AND id_document != '100327' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 11:52:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4109', document_date = '2025-12-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.00', price_tax_excluded = '2.46', date_upd = NOW() WHERE id_document = '100327' 06/12/2025 11:52: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 = '100327' 06/12/2025 11:52:59 am >> DELETE FROM ps_document_detail WHERE id_document = '100327' 06/12/2025 11:52: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 ( '100327' , '18137' , 'CROCE RILIEVO MARRONE - CR197' , '3' , '-3' , '1' , '1' , '0.81967213114754' , '22' , '0' , '3.00' ) 06/12/2025 12:01:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '4110' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 12:01:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4110' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '6.00' , NOW() , NOW() ) 06/12/2025 12:01:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100328' 06/12/2025 12:01:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '100328' 06/12/2025 12:01:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100328' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '' , '6.00' ) 06/12/2025 12:02:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '4111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 12:02:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4111' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.93' , '66.93' , NOW() , NOW() ) 06/12/2025 12:02:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100329' 06/12/2025 12:02:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '100329' 06/12/2025 12:02:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100329' , '' , 'IO SONO CON VOI - CAT' , '5' , '-5' , '4' , '5.5' , '5.5' , '0' , '0' , '27.50' ) 06/12/2025 12:02:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100329' , '23571' , 'PERCORSI SPONSALI - P. GUSMITTA' , '1' , '-1' , '4' , '27.50' , '27.5' , '0' , '5' , '26.13' ) 06/12/2025 12:02:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100329' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 06/12/2025 12:36:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '4112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 12:36:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4112' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 06/12/2025 12:36:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100330' 06/12/2025 12:36:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '100330' 06/12/2025 12:36:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100330' , '22463' , 'CAMICE LEGGERO - 020/06' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 06/12/2025 12:47:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '4113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-06') 06/12/2025 12:47: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' , '4113' , '2025-12-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 06/12/2025 12:47: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 = '100331' 06/12/2025 12:47:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '100331' 06/12/2025 12:47: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 ( '100331' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 06/12/2025 12:47: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 ( '100331' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' )