04/01/2025 10:10:53 am >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 10:10:53 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' , '29' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 04/01/2025 10:10:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95149' 04/01/2025 10:10:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95149' 04/01/2025 10:10:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95149' , '17600' , 'STATUA S. MICHELE CM 20 BIANCA - 203SM' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 04/01/2025 10:21:00 am >> SELECT document_num FROM ps_document WHERE document_num = '30' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 10:21:00 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' , '30' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.20' , '32.58' , NOW() , NOW() ) 04/01/2025 10:21:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95150' 04/01/2025 10:21:00 am >> DELETE FROM ps_document_detail WHERE id_document = '95150' 04/01/2025 10:21:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95150' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 04/01/2025 10:21:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95150' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 04/01/2025 10:21:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95150' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 04/01/2025 10:21:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95150' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 04/01/2025 10:36:42 am >> SELECT document_num FROM ps_document WHERE document_num = '31' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 10:36:42 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' , '31' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 04/01/2025 10:36:42 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 = '95151' 04/01/2025 10:36:42 am >> DELETE FROM ps_document_detail WHERE id_document = '95151' 04/01/2025 10:36:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95151' , '22412' , 'SACRA BIBBIA - 8602' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 04/01/2025 10:42:53 am >> SELECT document_num FROM ps_document WHERE document_num = '32' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 10:42:53 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' , '32' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.50' , '27.46' , NOW() , NOW() ) 04/01/2025 10:42:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95152' 04/01/2025 10:42:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95152' 04/01/2025 10:42:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95152' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 04/01/2025 10:42:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95152' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 04/01/2025 10:42:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95152' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.1' , '5.8196721311475' , '22' , '0' , '7.10' ) 04/01/2025 11:10:00 am >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 11:10:00 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' , '33' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 04/01/2025 11:10:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95153' 04/01/2025 11:10:00 am >> DELETE FROM ps_document_detail WHERE id_document = '95153' 04/01/2025 11:10:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95153' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 04/01/2025 11:12:09 am >> SELECT document_num FROM ps_document WHERE document_num = '34' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 11:12:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '34' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '21.00' , NOW() , NOW() ) 04/01/2025 11:12:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95154' 04/01/2025 11:12:09 am >> DELETE FROM ps_document_detail WHERE id_document = '95154' 04/01/2025 11:12:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95154' , '2679' , 'CONOSCERE GESU' , '7' , '-7' , '4' , '3' , '3' , '0' , '0' , '21.00' ) 04/01/2025 11:28:23 am >> SELECT document_num FROM ps_document WHERE document_num = '35' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 11:28:23 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' , '35' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 04/01/2025 11:28:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95155' 04/01/2025 11:28:23 am >> DELETE FROM ps_document_detail WHERE id_document = '95155' 04/01/2025 11:28:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95155' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 04/01/2025 11:33:06 am >> SELECT document_num FROM ps_document WHERE document_num = '36' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 11:33: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' , '36' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.32' , NOW() , NOW() ) 04/01/2025 11:33: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 = '95156' 04/01/2025 11:33:06 am >> DELETE FROM ps_document_detail WHERE id_document = '95156' 04/01/2025 11:33: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 ( '95156' , '21016' , 'DAVIDE E GOLIA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/01/2025 11:33: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 ( '95156' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/01/2025 11:49:53 am >> SELECT document_num FROM ps_document WHERE document_num = '37' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 11:49:53 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' , '37' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 04/01/2025 11:49:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95157' 04/01/2025 11:49:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95157' 04/01/2025 11:49:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95157' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '50' , '-50' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '70.00' ) 04/01/2025 11:59:18 am >> SELECT document_num FROM ps_document WHERE document_num = '38' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 11: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' , '38' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.50' , '22.60' , NOW() , NOW() ) 04/01/2025 11: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 = '95158' 04/01/2025 11:59:18 am >> DELETE FROM ps_document_detail WHERE id_document = '95158' 04/01/2025 11:59:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95158' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 04/01/2025 11:59:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95158' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 04/01/2025 12:15:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '39' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 12:15:23 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' , '39' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '46.72' , NOW() , NOW() ) 04/01/2025 12:15:23 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 = '95159' 04/01/2025 12:15:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '95159' 04/01/2025 12:15:23 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 ( '95159' , '15917' , 'STOLA DIACONALE CROCE - AESP06' , '1' , '-1' , '1' , '57.00' , '46.72131147541' , '22' , '0' , '57.00' ) 04/01/2025 12:35:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '40' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 12:35:17 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' , '40' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '20.90' , NOW() , NOW() ) 04/01/2025 12:35:17 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 = '95160' 04/01/2025 12:35:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '95160' 04/01/2025 12:35:17 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 ( '95160' , '23069' , 'PAROLA DI OGNI GIORNO 2025' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 04/01/2025 12:41:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '41' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 12:41:16 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' , '41' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.75' , '99.75' , NOW() , NOW() ) 04/01/2025 12:41:16 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 = '95161' 04/01/2025 12:41:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '95161' 04/01/2025 12:41:16 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 ( '95161' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 04/01/2025 12:41:16 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 ( '95161' , '22112' , 'LITURGIA DELLE ORE VOL. III - N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 04/01/2025 12:41:16 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 ( '95161' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 04/01/2025 12:48:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '42' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-04') 04/01/2025 12:48:33 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' , '42' , '2025-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.80' , '1.80' , NOW() , NOW() ) 04/01/2025 12:48:33 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 = '95162' 04/01/2025 12:48:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '95162' 04/01/2025 12:48:34 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 ( '95162' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 04/01/2025 12:48:34 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 ( '95162' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' )