20/12/2025 09:18:05 am >> SELECT document_num FROM ps_document WHERE document_num = '4332' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 09:18: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' , '4332' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.50' , '68.69' , NOW() , NOW() ) 20/12/2025 09:18: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 = '100600' 20/12/2025 09:18:05 am >> DELETE FROM ps_document_detail WHERE id_document = '100600' 20/12/2025 09:18: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 ( '100600' , '21791' , 'BAMBINELLO CM 21 - PB15943' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 20/12/2025 09:18: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 ( '100600' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/12/2025 09:18: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 ( '100600' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/12/2025 09:18: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 ( '100600' , '7202' , 'ARTICOLI RELIGIOSI' , '100' , '-100' , '1' , '0.45' , '0.36885245901639' , '22' , '0' , '45.00' ) 20/12/2025 09:39:12 am >> SELECT document_num FROM ps_document WHERE document_num = '4333' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 09:39:12 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' , '4333' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 20/12/2025 09:39:12 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 = '100601' 20/12/2025 09:39:12 am >> DELETE FROM ps_document_detail WHERE id_document = '100601' 20/12/2025 09:39: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 ( '100601' , '19351' , 'SERVIZIO MESSA MISTO LINO - 7050' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 20/12/2025 09:40:26 am >> SELECT document_num FROM ps_document WHERE document_num = '4334' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 09:40:27 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' , '4334' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 20/12/2025 09:40:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100602' 20/12/2025 09:40:27 am >> DELETE FROM ps_document_detail WHERE id_document = '100602' 20/12/2025 09:40:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100602' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 20/12/2025 09:48:50 am >> SELECT document_num FROM ps_document WHERE document_num = '4335' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 09:48:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4335' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.65' , '17.75' , NOW() , NOW() ) 20/12/2025 09:48:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100603' 20/12/2025 09:48:50 am >> DELETE FROM ps_document_detail WHERE id_document = '100603' 20/12/2025 09:48:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100603' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 20/12/2025 09:48:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100603' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '4' , '-4' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '8.80' ) 20/12/2025 09:48:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100603' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 20/12/2025 09:48:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100603' , '13316' , 'SEGNALIBRI E NATALE - 120' , '25' , '-25' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '3.75' ) 20/12/2025 09:53:12 am >> SELECT document_num FROM ps_document WHERE document_num = '4335' AND id_document != '100603' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 09:53:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4335', document_date = '2025-12-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '21.65', price_tax_excluded = '17.75', date_upd = NOW() WHERE id_document = '100603' 20/12/2025 09:53:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100603' 20/12/2025 09:53:13 am >> DELETE FROM ps_document_detail WHERE id_document = '100603' 20/12/2025 09:53:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100603' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '5.50' ) 20/12/2025 09:53:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100603' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '4' , '-4' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '8.80' ) 20/12/2025 09:53:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100603' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 20/12/2025 09:53:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100603' , '20758' , 'SEGNALIBRO 5X15' , '25' , '-25' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '3.75' ) 20/12/2025 09:54:35 am >> SELECT document_num FROM ps_document WHERE document_num = '4011' AND id_document != '100201' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-02') 20/12/2025 09:54:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4011', document_date = '2025-12-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.50', price_tax_excluded = '85.92', date_upd = NOW() WHERE id_document = '100201' 20/12/2025 09:54: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 = '100201' 20/12/2025 09:54:36 am >> DELETE FROM ps_document_detail WHERE id_document = '100201' 20/12/2025 09:54: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 ( '100201' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 20/12/2025 09:54: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 ( '100201' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/12/2025 09:54: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 ( '100201' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 20/12/2025 09:54: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 ( '100201' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '17.50' ) 20/12/2025 09:54: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 ( '100201' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 20/12/2025 09:54: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 ( '100201' , '13316' , 'SEGNALIBRI E NATALE - 120' , '5' , '-5' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.75' ) 20/12/2025 09:54: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 ( '100201' , '20758' , 'SEGNALIBRO 5X15' , '25' , '-25' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '3.75' ) 20/12/2025 09:59:30 am >> SELECT document_num FROM ps_document WHERE document_num = '4336' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 09:59: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' , '4336' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.30' , '43.69' , NOW() , NOW() ) 20/12/2025 09:59: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 = '100604' 20/12/2025 09:59:31 am >> DELETE FROM ps_document_detail WHERE id_document = '100604' 20/12/2025 09:59: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 ( '100604' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '50' , '-50' , '1' , '1' , '0.81967213114754' , '22' , '0' , '50.00' ) 20/12/2025 09:59: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 ( '100604' , '22963' , 'VINO ROSSO DOLCE MIGNON' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 20/12/2025 10:03:47 am >> SELECT document_num FROM ps_document WHERE document_num = '4337' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 10:03:47 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' , '4337' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.80' , '26.13' , NOW() , NOW() ) 20/12/2025 10:03:47 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 = '100605' 20/12/2025 10:03:47 am >> DELETE FROM ps_document_detail WHERE id_document = '100605' 20/12/2025 10:03:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100605' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 20/12/2025 10:03:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100605' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 20/12/2025 10:03:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100605' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/12/2025 10:03:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100605' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/12/2025 10:09:14 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') 20/12/2025 10:09:14 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 = '390.12', price_tax_excluded = '380.92', date_upd = NOW() WHERE id_document = '100002' 20/12/2025 10:09: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 = '100002' 20/12/2025 10:09:14 am >> DELETE FROM ps_document_detail WHERE id_document = '100002' 20/12/2025 10:09: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 ( '100002' , '10751' , 'TU MI PERDONI' , '15' , '-15' , '4' , '6.9000' , '6.9' , '0' , '5' , '98.33' ) 20/12/2025 10:09: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 ( '100002' , '14719' , 'TU MI AMI DAVVERO' , '25' , '-25' , '4' , '6.9000' , '6.9' , '0' , '5' , '163.88' ) 20/12/2025 10:09: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 ( '100002' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '-1' , '1' , '51.0000' , '41.803278688525' , '22' , '0' , '51.00' ) 20/12/2025 10:09: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 ( '100002' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 20/12/2025 10:09: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 ( '100002' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '5' , '19.00' ) 20/12/2025 10:09: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 ( '100002' , '' , 'bambinello' , '79' , '-79' , '0' , '0.65' , '0.65' , '' , '0' , '51.35' ) 20/12/2025 10:19:37 am >> SELECT document_num FROM ps_document WHERE document_num = '4338' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 10:19: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' , '4338' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.40' , '46.19' , NOW() , NOW() ) 20/12/2025 10:19: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 = '100606' 20/12/2025 10:19:37 am >> DELETE FROM ps_document_detail WHERE id_document = '100606' 20/12/2025 10:19: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 ( '100606' , '5999' , 'LUME VETRO SOFFIATO MELOGRANO - 1021' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '28.00' ) 20/12/2025 10:19: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 ( '100606' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '13.00' ) 20/12/2025 10:19: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 ( '100606' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 20/12/2025 10:19: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 ( '100606' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/12/2025 10:19: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 ( '100606' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 20/12/2025 10:39:58 am >> SELECT document_num FROM ps_document WHERE document_num = '4339' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 10:39:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4339' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '194.80' , '194.80' , NOW() , NOW() ) 20/12/2025 10:39:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100607' 20/12/2025 10:39:58 am >> DELETE FROM ps_document_detail WHERE id_document = '100607' 20/12/2025 10:39: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 ( '100607' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '30' , '-30' , '4' , '5.00' , '5' , '0' , '5' , '142.50' ) 20/12/2025 10:39: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 ( '100607' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '100' , '0.00' ) 20/12/2025 10:39: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 ( '100607' , '24351' , 'AMEN - GEN 26' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 20/12/2025 10:39: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 ( '100607' , '24352' , 'AMEN - FEB 26' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 20/12/2025 10:39: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 ( '100607' , '24232' , 'MESSA MEDITAZIONE - GEN/FEB 26' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 20/12/2025 10:42:06 am >> SELECT document_num FROM ps_document WHERE document_num = '4340' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 10:42:06 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' , '4340' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/12/2025 10:42:06 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 = '100608' 20/12/2025 10:42:06 am >> DELETE FROM ps_document_detail WHERE id_document = '100608' 20/12/2025 10:42:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100608' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/12/2025 10:59:18 am >> SELECT document_num FROM ps_document WHERE document_num = '4341' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 10:59: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' , '4341' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.50' , '38.75' , NOW() , NOW() ) 20/12/2025 10:59: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 = '100609' 20/12/2025 10:59:18 am >> DELETE FROM ps_document_detail WHERE id_document = '100609' 20/12/2025 10:59: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 ( '100609' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 20/12/2025 10:59: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 ( '100609' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 20/12/2025 10:59: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 ( '100609' , '16806' , 'EVANGELII NUNTIANDI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 20/12/2025 11:20:52 am >> SELECT document_num FROM ps_document WHERE document_num = '155/A' AND id_document != '100541' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-17') 20/12/2025 11:20:52 am >> UPDATE ps_document SET id_document_type = '24', document_num = '155/A', document_date = '2025-12-17', document_letter = 'A', 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 = '2140.00', price_tax_excluded = '2140.00', date_upd = NOW() WHERE id_document = '100541' 20/12/2025 11:20: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 = '100541' 20/12/2025 11:20:52 am >> DELETE FROM ps_document_detail WHERE id_document = '100541' 20/12/2025 11:20: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 ( '100541' , '0' , 'SET 3 PEZZI NATIVITA\' CM 105' , '1' , '-1' , '0' , '1590.0000' , '1590' , '0' , '0' , '1590.00' ) 20/12/2025 11:20: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 ( '100541' , '0' , 'BAMBINELLO IN TERRACOTTA CM 40' , '1' , '-1' , '0' , '550.0000' , '550' , '0' , '0' , '550.00' ) 20/12/2025 11:32:59 am >> SELECT document_num FROM ps_document WHERE document_num = '4342' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 11:32: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' , '4342' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 20/12/2025 11:32: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 = '100610' 20/12/2025 11:32:59 am >> DELETE FROM ps_document_detail WHERE id_document = '100610' 20/12/2025 11:32: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 ( '100610' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 20/12/2025 11:34:30 am >> SELECT document_num FROM ps_document WHERE document_num = '4343' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 11:34:30 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' , '4343' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '149.00' , '136.03' , NOW() , NOW() ) 20/12/2025 11:34:30 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 = '100611' 20/12/2025 11:34:30 am >> DELETE FROM ps_document_detail WHERE id_document = '100611' 20/12/2025 11:34:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100611' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 20/12/2025 11:34:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100611' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '28' , '-28' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '98.00' ) 20/12/2025 11:37:25 am >> SELECT document_num FROM ps_document WHERE document_num = '4344' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 11:37: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' , '4344' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '35.25' , NOW() , NOW() ) 20/12/2025 11:37: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 = '100612' 20/12/2025 11:37:25 am >> DELETE FROM ps_document_detail WHERE id_document = '100612' 20/12/2025 11:37: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 ( '100612' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 20/12/2025 11:37: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 ( '100612' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '28.00' ) 20/12/2025 11:56:37 am >> SELECT document_num FROM ps_document WHERE document_num = '4345' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 11:56: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' , '4345' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.40' , '12.58' , NOW() , NOW() ) 20/12/2025 11:56: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 = '100613' 20/12/2025 11:56:38 am >> DELETE FROM ps_document_detail WHERE id_document = '100613' 20/12/2025 11:56: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 ( '100613' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/12/2025 11:56: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 ( '100613' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 20/12/2025 11:56: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 ( '100613' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 20/12/2025 12:01:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '4346' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 12:01: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' , '4346' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '161.00' , '131.97' , NOW() , NOW() ) 20/12/2025 12:01: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 = '100614' 20/12/2025 12:01:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '100614' 20/12/2025 12:01: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 ( '100614' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '10' , '-10' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '15.00' ) 20/12/2025 12:01: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 ( '100614' , '24433' , 'LITURGICO CARTA - KING CELLOPHANE' , '25' , '-25' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '92.50' ) 20/12/2025 12:01: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 ( '100614' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 20/12/2025 12:01: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 ( '100614' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 20/12/2025 12:01:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '4347' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 12:01:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4347' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 20/12/2025 12:01:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100615' 20/12/2025 12:01:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '100615' 20/12/2025 12:01:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100615' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '10' , '18.00' ) 20/12/2025 12:06:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '4130' AND id_document != '100354' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 20/12/2025 12:06:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4130', document_date = '2025-12-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '50.30', date_upd = NOW() WHERE id_document = '100354' 20/12/2025 12:06:25 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 = '100354' 20/12/2025 12:06:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '100354' 20/12/2025 12:06:25 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 ( '100354' , '18276' , 'CINGOLO CON NODI - 3280' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 20/12/2025 12:06:25 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 ( '100354' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 20/12/2025 12:06:25 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 ( '100354' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '4' , '-4' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '8.00' ) 20/12/2025 12:06:25 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 ( '100354' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '10' , '-10' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '11.00' ) 20/12/2025 12:06:25 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 ( '100354' , '17432' , 'SANTA LUCIA' , '1' , '-1' , '4' , '3.7000' , '3.7' , '0' , '0' , '3.70' ) 20/12/2025 12:06:25 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 ( '100354' , '21690' , 'PRESEPE 12X15' , '2' , '-2' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '25.00' ) 20/12/2025 12:06:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '156/A' AND id_document != '100599' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-19') 20/12/2025 12:06:50 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '156/A', document_date = '2025-12-19', document_letter = 'A', id_customer = '1175', id_supplier = '', id_address = '4679143', address1 = 'VIA BUONSERVIZI, 25 84135 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 = '67.40', price_tax_excluded = '67.40', date_upd = NOW() WHERE id_document = '100599' 20/12/2025 12:06:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100599' 20/12/2025 12:06:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '100599' 20/12/2025 12:06:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100599' , '21690' , 'PRESEPE 12X15' , '3' , '-3' , '0' , '12.5000' , '12.5' , '' , '0' , '37.50' ) 20/12/2025 12:06:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100599' , '0' , 'SFERA IN VETRO CON PRESEPE' , '1' , '-1' , '0' , '29.9000' , '29.9' , '0' , '0' , '29.90' ) 20/12/2025 12:07:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-19') 20/12/2025 12:07:24 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-19', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679682', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 20/12/2025 12:07:24 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 = '100593' 20/12/2025 12:07:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '100593' 20/12/2025 12:07:24 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 ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri. Progetto PNNR (M.C3-INVESTIMENTO 2.2) ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/12/2025 12:07:24 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 ( '100593' , '0' , 'finanziato dall\'Unione Europea- nextGenerationEu \"Restauro e consolidamento struttura della chiesa ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/12/2025 12:07:24 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 ( '100593' , '0' , 'della Madonna della Salute\" ID: PNNR-MC--2022-007500 CUP B97B22001270004.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/12/2025 12:07:24 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 ( '100593' , '24439' , 'ALTARE IN LEGNO - 358' , '1' , '-1' , '1' , '1480.0000' , '1213.1147540984' , '22' , '0' , '1480.00' ) 20/12/2025 12:07:25 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 ( '100593' , '24440' , 'LEGGIO LEGNO - 333/L ' , '1' , '-1' , '1' , '200.0000' , '163.93442622951' , '22' , '0' , '200.00' ) 20/12/2025 12:07:25 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 ( '100593' , '24441' , 'LEGGIO A STELO - 196' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 20/12/2025 12:07:25 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 ( '100593' , '24442' , 'CROCIFISSO LEGNO CORPO CM 80 - 180' , '1' , '-1' , '1' , '870.0000' , '713.11475409836' , '22' , '0' , '870.00' ) 20/12/2025 12:07:25 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 ( '100593' , '24443' , 'BASE PER CROCE IN LEGNO 60X40 - 1890' , '1' , '-1' , '1' , '280.0000' , '229.50819672131' , '22' , '0' , '280.00' ) 20/12/2025 12:07:25 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 ( '100593' , '24444' , 'POLTRONA IN VELLOTO - 7101' , '1' , '-1' , '1' , '760.0000' , '622.95081967213' , '22' , '0' , '760.00' ) 20/12/2025 12:07:25 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 ( '100593' , '24445' , 'SGABELLO IN NOCE - 7102' , '2' , '-2' , '1' , '270.0000' , '221.31147540984' , '22' , '0' , '540.00' ) 20/12/2025 12:12:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '40/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 12:12:36 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 ( '23' , '40/L' , '2025-12-20' , 'L' , '949' , '0' , '4679327' , 'VIA P. PALMIERI 39 10138 TORINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '152.00' , '146.15' , NOW() , NOW() ) 20/12/2025 12:12:36 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 = '100616' 20/12/2025 12:12:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '100616' 20/12/2025 12:12:36 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 ( '100616' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '32' , '-32' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '112.00' ) 20/12/2025 12:12:36 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 ( '100616' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 20/12/2025 12:23:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 12:23:18 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-20', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679682', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 20/12/2025 12:23:18 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 = '100593' 20/12/2025 12:23:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '100593' 20/12/2025 12:23:19 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 ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri. Progetto PNNR (M.C3-INVESTIMENTO 2.2) ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/12/2025 12:23:19 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 ( '100593' , '0' , 'finanziato dall\'Unione Europea- nextGenerationEu \"Restauro e consolidamento struttura della chiesa ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/12/2025 12:23:19 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 ( '100593' , '0' , 'della Madonna della Salute\" ID: PNNR-MC--2022-007500 CUP B97B22001270004.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/12/2025 12:23:19 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 ( '100593' , '24439' , 'ALTARE IN LEGNO - 358' , '1' , '-1' , '1' , '1480.0000' , '1213.1147540984' , '22' , '0' , '1480.00' ) 20/12/2025 12:23:19 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 ( '100593' , '24440' , 'LEGGIO LEGNO - 333/L ' , '1' , '-1' , '1' , '200.0000' , '163.93442622951' , '22' , '0' , '200.00' ) 20/12/2025 12:23:19 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 ( '100593' , '24441' , 'LEGGIO A STELO - 196' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 20/12/2025 12:23:19 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 ( '100593' , '24442' , 'CROCIFISSO LEGNO CORPO CM 80 - 180' , '1' , '-1' , '1' , '870.0000' , '713.11475409836' , '22' , '0' , '870.00' ) 20/12/2025 12:23:19 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 ( '100593' , '24443' , 'BASE PER CROCE IN LEGNO 60X40 - 1890' , '1' , '-1' , '1' , '280.0000' , '229.50819672131' , '22' , '0' , '280.00' ) 20/12/2025 12:23:19 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 ( '100593' , '24444' , 'POLTRONA IN VELLOTO - 7101' , '1' , '-1' , '1' , '760.0000' , '622.95081967213' , '22' , '0' , '760.00' ) 20/12/2025 12:23:19 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 ( '100593' , '24445' , 'SGABELLO IN NOCE - 7102' , '2' , '-2' , '1' , '270.0000' , '221.31147540984' , '22' , '0' , '540.00' ) 20/12/2025 12:26:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '4348' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 12:26: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' , '4348' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.70' , '46.50' , NOW() , NOW() ) 20/12/2025 12:26: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 = '100617' 20/12/2025 12:26:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '100617' 20/12/2025 12:26: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 ( '100617' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '100' , '-100' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '35.00' ) 20/12/2025 12:26: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 ( '100617' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 20/12/2025 12:26: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 ( '100617' , '24400' , 'MATER POPULI FIDELIS' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 20/12/2025 12:26: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 ( '100617' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 20/12/2025 12:27:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '4349' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 12:27:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4349' , '2025-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 20/12/2025 12:27:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100618' 20/12/2025 12:27:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '100618' 20/12/2025 12:27:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100618' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 20/12/2025 12:32:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '157/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-20') 20/12/2025 12:32: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 ( '24' , '157/A' , '2025-12-20' , 'A' , '1656' , '0' , '4679422' , 'VIA NAZIONALE 84060 OMIGNANO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.70' , '35.70' , NOW() , NOW() ) 20/12/2025 12:32: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 = '100619' 20/12/2025 12:32:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '100619' 20/12/2025 12:32: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 ( '100619' , '4120' , 'FEDE NELLO ZAINETTO' , '7' , '-7' , '4' , '6.00' , '6' , '0' , '15' , '35.70' )