27/04/2024 09:04:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1309' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 09:04:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1309' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.40' , '13.40' , NOW() , NOW() ) 27/04/2024 09:04:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91462' 27/04/2024 09:04:40 am >> DELETE FROM ps_document_detail WHERE id_document = '91462' 27/04/2024 09:04:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91462' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 27/04/2024 09:04:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91462' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 27/04/2024 09:44:38 am >> SELECT document_num FROM ps_document WHERE document_num = '870' AND id_document != '90912' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-23') 27/04/2024 09:44:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '870', document_date = '2024-03-23', 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 = '51.50', price_tax_excluded = '42.21', date_upd = NOW() WHERE id_document = '90912' 27/04/2024 09:44: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 = '90912' 27/04/2024 09:44:38 am >> DELETE FROM ps_document_detail WHERE id_document = '90912' 27/04/2024 09:44: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 ( '90912' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '16.5' , '13.524590163934' , '22' , '0' , '16.50' ) 27/04/2024 09:44: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 ( '90912' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 27/04/2024 09:45:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1093' AND id_document != '91194' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 27/04/2024 09:45:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1093', document_date = '2024-04-10', 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 = '96.20', price_tax_excluded = '78.85', date_upd = NOW() WHERE id_document = '91194' 27/04/2024 09:45: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 = '91194' 27/04/2024 09:45:33 am >> DELETE FROM ps_document_detail WHERE id_document = '91194' 27/04/2024 09:45: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 ( '91194' , '15104' , 'ROSARIO BOTTIGLIA ' , '31' , '-31' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '68.20' ) 27/04/2024 09:45: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 ( '91194' , '20183' , 'TESTA ANGELI CM 8 - AR05' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 27/04/2024 09:45: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 ( '91194' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '1' , '-1' , '1' , '23' , '18.852459016393' , '22' , '0' , '23.00' ) 27/04/2024 09:47:45 am >> SELECT document_num FROM ps_document WHERE document_num = '987' AND id_document != '91044' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 27/04/2024 09:47:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '987', document_date = '2024-04-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.00', price_tax_excluded = '81.97', date_upd = NOW() WHERE id_document = '91044' 27/04/2024 09:47:45 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 = '91044' 27/04/2024 09:47:45 am >> DELETE FROM ps_document_detail WHERE id_document = '91044' 27/04/2024 09:47:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91044' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 27/04/2024 09:47:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91044' , '2222' , 'CLERGY F/F ML GRIGIO - 41' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 27/04/2024 09:47:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91044' , '11756' , 'VINO BIANCO SECCO - 14%' , '11' , '-11' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '55.00' ) 27/04/2024 09:47:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91044' , '3092' , 'CROCE SACERDOTALE - PIATTA ' , '5' , '-5' , '1' , '0.56' , '0.45901639344262' , '22' , '0' , '2.80' ) 27/04/2024 09:48:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1007' AND id_document != '91075' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-03') 27/04/2024 09:48:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1007', document_date = '2024-04-03', 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 = '9.10', price_tax_excluded = '7.46', date_upd = NOW() WHERE id_document = '91075' 27/04/2024 09:48:24 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 = '91075' 27/04/2024 09:48:24 am >> DELETE FROM ps_document_detail WHERE id_document = '91075' 27/04/2024 09:48: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 ( '91075' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/04/2024 09:48: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 ( '91075' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '3' , '-3' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.10' ) 27/04/2024 09:48: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 ( '91075' , '16312' , 'DECINA LEGNO CHIARO' , '1' , '-1' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '0.60' ) 27/04/2024 09:48: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 ( '91075' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.40' ) 27/04/2024 09:48:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1310' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 09:48:55 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' , '1310' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 27/04/2024 09:48:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91463' 27/04/2024 09:48:55 am >> DELETE FROM ps_document_detail WHERE id_document = '91463' 27/04/2024 09:48:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91463' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/04/2024 09:49:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1070' AND id_document != '91161' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-08') 27/04/2024 09:49:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1070', document_date = '2024-04-08', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '91161' 27/04/2024 09:49:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91161' 27/04/2024 09:49:51 am >> DELETE FROM ps_document_detail WHERE id_document = '91161' 27/04/2024 09:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91161' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.40' ) 27/04/2024 09:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91161' , '11756' , 'VINO BIANCO SECCO - 14%' , '8' , '-8' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '48.00' ) 27/04/2024 09:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91161' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 27/04/2024 09:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91161' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '3' , '-3' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.10' ) 27/04/2024 09:51:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1157' AND id_document != '91278' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-15') 27/04/2024 09:51:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1157', document_date = '2024-04-15', 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 = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '91278' 27/04/2024 09:51:21 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 = '91278' 27/04/2024 09:51:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91278' 27/04/2024 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91278' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/04/2024 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91278' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '2' , '-2' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.40' ) 27/04/2024 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91278' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '3' , '-3' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.10' ) 27/04/2024 10:19:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1311' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 10:19: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' , '1311' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.50' , '43.93' , NOW() , NOW() ) 27/04/2024 10:19: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 = '91464' 27/04/2024 10:19:43 am >> DELETE FROM ps_document_detail WHERE id_document = '91464' 27/04/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91464' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 27/04/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91464' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '21' , '-21' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '6.30' ) 27/04/2024 10:19:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91464' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '21' , '-21' , '1' , '1.7' , '1.3934426229508' , '22' , '0' , '35.70' ) 27/04/2024 10:21:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1312' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 10:21:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1312' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.50' , '15.50' , NOW() , NOW() ) 27/04/2024 10:21:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91465' 27/04/2024 10:21:15 am >> DELETE FROM ps_document_detail WHERE id_document = '91465' 27/04/2024 10:21:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91465' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/04/2024 10:21:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91465' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/04/2024 10:21:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91465' , '22111' , 'PREGARE OGGI - 1' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 27/04/2024 10:43:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1313' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 10:43:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1313' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 27/04/2024 10:43:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91466' 27/04/2024 10:43:51 am >> DELETE FROM ps_document_detail WHERE id_document = '91466' 27/04/2024 10:43:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91466' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 27/04/2024 10:54:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1314' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 10:54:35 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' , '1314' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '13.93' , NOW() , NOW() ) 27/04/2024 10: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 = '91467' 27/04/2024 10:54:35 am >> DELETE FROM ps_document_detail WHERE id_document = '91467' 27/04/2024 10:54:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91467' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 27/04/2024 10:55:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1315' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 10:55: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' , '1315' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.10' , '18.10' , NOW() , NOW() ) 27/04/2024 10:55: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 = '91468' 27/04/2024 10:55:38 am >> DELETE FROM ps_document_detail WHERE id_document = '91468' 27/04/2024 10:55: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 ( '91468' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '10' , '-10' , '4' , '1.90' , '1.9' , '0' , '5' , '18.10' ) 27/04/2024 10:56:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1316' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 10:56:24 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' , '1316' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 27/04/2024 10:56:24 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 = '91469' 27/04/2024 10:56:24 am >> DELETE FROM ps_document_detail WHERE id_document = '91469' 27/04/2024 10:56: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 ( '91469' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 27/04/2024 10:58:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1317' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 10:58:21 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' , '1317' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 27/04/2024 10:58:21 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 = '91470' 27/04/2024 10:58:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91470' 27/04/2024 10:58:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91470' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 27/04/2024 10:58:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91470' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 27/04/2024 11:12:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1318' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 11:12:22 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' , '1318' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 27/04/2024 11:12:22 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 = '91471' 27/04/2024 11:12:22 am >> DELETE FROM ps_document_detail WHERE id_document = '91471' 27/04/2024 11:12:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91471' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 27/04/2024 11:12:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1319' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 11:12:32 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' , '1319' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 27/04/2024 11:12:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91472' 27/04/2024 11:12:32 am >> DELETE FROM ps_document_detail WHERE id_document = '91472' 27/04/2024 11:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91472' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 27/04/2024 11:49:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1320' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 11:49:41 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' , '1320' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 27/04/2024 11:49:41 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 = '91473' 27/04/2024 11:49:41 am >> DELETE FROM ps_document_detail WHERE id_document = '91473' 27/04/2024 11:49:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91473' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 27/04/2024 12:34:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1321' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 12:34:54 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' , '1321' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '240.00' , '200.15' , NOW() , NOW() ) 27/04/2024 12:34:54 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 = '91474' 27/04/2024 12:34:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91474' 27/04/2024 12:34:54 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 ( '91474' , '17077' , 'IMMACOLATA DEL MURILLO CM 33 - 610' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 27/04/2024 12:34:54 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 ( '91474' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '108' , '-108' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '129.60' ) 27/04/2024 12:34:54 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 ( '91474' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 27/04/2024 12:34:54 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 ( '91474' , '10498' , 'TECA CON PLACCA - 504' , '1' , '-1' , '1' , '31.4' , '25.737704918033' , '22' , '0' , '31.40' ) 27/04/2024 12:38:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1322' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 12:38:00 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' , '1322' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.55' , '180.55' , NOW() , NOW() ) 27/04/2024 12:38:00 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 = '91475' 27/04/2024 12:38:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '91475' 27/04/2024 12:38:00 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 ( '91475' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '27' , '-27' , '4' , '5.00' , '5' , '0' , '5' , '128.25' ) 27/04/2024 12:38:00 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 ( '91475' , '22308' , 'MESSA MEDITAZIONE - MAG/GIU 2024' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 27/04/2024 12:38:00 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 ( '91475' , '22167' , 'AMEN - MAG. 2024' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 27/04/2024 12:38:00 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 ( '91475' , '22168' , 'AMEN - GIU. 2024' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 27/04/2024 12:38:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1323' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 12:38:45 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' , '1323' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.92' , '35.92' , NOW() , NOW() ) 27/04/2024 12:38:45 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 = '91476' 27/04/2024 12:38:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '91476' 27/04/2024 12:38:45 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 ( '91476' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 27/04/2024 12:38:45 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 ( '91476' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '100' , '0.00' ) 27/04/2024 12:38:45 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 ( '91476' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/04/2024 12:38:45 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 ( '91476' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/04/2024 12:39:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1324' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 27/04/2024 12:39:22 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' , '1324' , '2024-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.92' , '35.92' , NOW() , NOW() ) 27/04/2024 12:39:22 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 = '91477' 27/04/2024 12:39:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '91477' 27/04/2024 12:39:22 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 ( '91477' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 27/04/2024 12:39:22 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 ( '91477' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '100' , '0.00' ) 27/04/2024 12:39:22 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 ( '91477' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/04/2024 12:39:22 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 ( '91477' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' )