28/06/2025 09:00:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2290' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 09:00:03 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' , '2290' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.10' , '2.10' , NOW() , NOW() ) 28/06/2025 09:00: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 = '97902' 28/06/2025 09:00:03 am >> DELETE FROM ps_document_detail WHERE id_document = '97902' 28/06/2025 09:00: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 ( '97902' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 28/06/2025 09:03:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2291' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 09:03: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' , '2291' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 28/06/2025 09:03: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 = '97903' 28/06/2025 09:03:14 am >> DELETE FROM ps_document_detail WHERE id_document = '97903' 28/06/2025 09:03: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 ( '97903' , '21095' , 'QUADRETTO DA POGGIO EFFETTO PIETRA - 2950' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 28/06/2025 09:03: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 ( '97903' , '9702' , 'SCAPOLARE TIPO GRANDE - 1216/ITA ' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 28/06/2025 09:06:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2292' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 09:06: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' , '2292' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.69' , NOW() , NOW() ) 28/06/2025 09:06: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 = '97904' 28/06/2025 09:06:36 am >> DELETE FROM ps_document_detail WHERE id_document = '97904' 28/06/2025 09:06: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 ( '97904' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 28/06/2025 09:10:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2293' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 09:10: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' , '2293' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/06/2025 09:10: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 = '97905' 28/06/2025 09:10:12 am >> DELETE FROM ps_document_detail WHERE id_document = '97905' 28/06/2025 09:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97905' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/06/2025 09:38:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2294' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 09:38:57 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' , '2294' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '12.67' , NOW() , NOW() ) 28/06/2025 09:38:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97906' 28/06/2025 09:38:57 am >> DELETE FROM ps_document_detail WHERE id_document = '97906' 28/06/2025 09:38:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97906' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 28/06/2025 09:38:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97906' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 28/06/2025 09:38: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 ( '97906' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 28/06/2025 09:38: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 ( '97906' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 28/06/2025 09:51:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2295' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 09:51: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' , '2295' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.83' , '32.50' , NOW() , NOW() ) 28/06/2025 09:51: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 = '97907' 28/06/2025 09:51:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97907' 28/06/2025 09:51: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 ( '97907' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 28/06/2025 09:51: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 ( '97907' , '6640' , 'MIA PRIMA COMUNIONE' , '1' , '-1' , '4' , '13.50' , '13.5' , '0' , '5' , '12.83' ) 28/06/2025 10:08:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2296' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 10:08: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' , '2296' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 28/06/2025 10:08: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 = '97908' 28/06/2025 10:08:05 am >> DELETE FROM ps_document_detail WHERE id_document = '97908' 28/06/2025 10:08: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 ( '97908' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 28/06/2025 10:08: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 ( '97908' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 28/06/2025 10:25:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2297' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 10:25:33 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' , '2297' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 28/06/2025 10:25:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97909' 28/06/2025 10:25:33 am >> DELETE FROM ps_document_detail WHERE id_document = '97909' 28/06/2025 10:25:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97909' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/06/2025 10:44:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2298' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 10:44:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2298' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 28/06/2025 10:44:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97910' 28/06/2025 10:44:10 am >> DELETE FROM ps_document_detail WHERE id_document = '97910' 28/06/2025 10:44:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97910' , '22919' , 'STOLA GIUBILEO 2025' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 28/06/2025 10:56:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2097' AND id_document != '97676' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-12') 28/06/2025 10:56:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2097', document_date = '2025-06-12', 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 = '47.80', price_tax_excluded = '44.37', date_upd = NOW() WHERE id_document = '97676' 28/06/2025 10:56: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 = '97676' 28/06/2025 10:56:13 am >> DELETE FROM ps_document_detail WHERE id_document = '97676' 28/06/2025 10:56: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 ( '97676' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '5' , '19.00' ) 28/06/2025 10:56: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 ( '97676' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 28/06/2025 10:56: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 ( '97676' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '-1' , '4' , '24.05' , '24.05' , '0' , '0' , '24.05' ) 28/06/2025 11:05:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2299' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 11:05:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2299' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 28/06/2025 11:05:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97911' 28/06/2025 11:05:43 am >> DELETE FROM ps_document_detail WHERE id_document = '97911' 28/06/2025 11:05:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97911' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 28/06/2025 11:07:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2300' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 11:07: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' , '2300' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 28/06/2025 11:07: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 = '97912' 28/06/2025 11:07:39 am >> DELETE FROM ps_document_detail WHERE id_document = '97912' 28/06/2025 11:07: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 ( '97912' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 28/06/2025 11:40:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2301' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 11:40:01 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' , '2301' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '214.88' , '181.70' , NOW() , NOW() ) 28/06/2025 11:40:01 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 = '97913' 28/06/2025 11:40:01 am >> DELETE FROM ps_document_detail WHERE id_document = '97913' 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '19866' , 'CASULA CROCE UVA - CSL111' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '22464' , 'CASULA LEGGERA - 1212' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '15000' , 'TECA ALTA IHS - 825' , '1' , '-1' , '1' , '32.00' , '26.229508196721' , '22' , '0' , '32.00' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '22152' , 'A TE RICORRIAMO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '23347' , 'PREGHIERA DEL ROSARIO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '23776' , 'ROSARIO LEGNO 10MM - R987' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '19304' , 'VIA CRUCIS - 8076' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '5' , '1.14' ) 28/06/2025 11:40:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97913' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '5' , '0.95' ) 28/06/2025 12:25:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2302' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 28/06/2025 12:25:08 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' , '2302' , '2025-06-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.85' , '20.09' , NOW() , NOW() ) 28/06/2025 12:25:08 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 = '97914' 28/06/2025 12:25:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '97914' 28/06/2025 12:25:08 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 ( '97914' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '6' , '-6' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.20' ) 28/06/2025 12:25:08 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 ( '97914' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '5' , '-5' , '4' , '3.50' , '3.5' , '0' , '5' , '16.65' )