29/05/2024 09:42:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 09:42:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1789' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.53' , '30.76' , NOW() , NOW() ) 29/05/2024 09:42:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92051' 29/05/2024 09:42:58 am >> DELETE FROM ps_document_detail WHERE id_document = '92051' 29/05/2024 09:42: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 ( '92051' , '22527' , 'ROSARIO CON PAPA FRANCESCO - N.E.' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '5' , '37.53' ) 29/05/2024 11:02:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1790' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 11:02: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' , '1790' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '107.00' , '87.70' , NOW() , NOW() ) 29/05/2024 11:02: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 = '92052' 29/05/2024 11:02:38 am >> DELETE FROM ps_document_detail WHERE id_document = '92052' 29/05/2024 11:02: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 ( '92052' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '107' , '87.704918032787' , '22' , '0' , '107.00' ) 29/05/2024 11:11:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1791' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 11:11: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' , '1791' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '31.97' , NOW() , NOW() ) 29/05/2024 11:11: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 = '92053' 29/05/2024 11:11:15 am >> DELETE FROM ps_document_detail WHERE id_document = '92053' 29/05/2024 11:11: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 ( '92053' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 29/05/2024 11:12:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1792' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 11:12: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' , '1792' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 29/05/2024 11:12: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 = '92054' 29/05/2024 11:12:06 am >> DELETE FROM ps_document_detail WHERE id_document = '92054' 29/05/2024 11:12: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 ( '92054' , '22476' , 'AMEN - AGO 2024' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 29/05/2024 11:12: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 ( '92054' , '22475' , 'AMEN - LUG. 2024' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 29/05/2024 11:16:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1793' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 11:16: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' , '1793' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '139.82' , '118.71' , NOW() , NOW() ) 29/05/2024 11:16: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 = '92055' 29/05/2024 11:16:32 am >> DELETE FROM ps_document_detail WHERE id_document = '92055' 29/05/2024 11:16: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 ( '92055' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 29/05/2024 11:16: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 ( '92055' , '22475' , 'AMEN - LUG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 29/05/2024 11:16: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 ( '92055' , '22476' , 'AMEN - AGO 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 29/05/2024 11:16: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 ( '92055' , '7930' , 'PERGAMENE - BATTESIMO MOD. D' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 29/05/2024 11:16: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 ( '92055' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 29/05/2024 11:16: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 ( '92055' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 29/05/2024 11:16: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 ( '92055' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 29/05/2024 11:16: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 ( '92055' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 29/05/2024 11:16: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 ( '92055' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '10' , '-10' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '35.00' ) 29/05/2024 11:27:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1794' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 11:27:54 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' , '1794' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.00' , '54.72' , NOW() , NOW() ) 29/05/2024 11:27:54 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 = '92056' 29/05/2024 11:27:54 am >> DELETE FROM ps_document_detail WHERE id_document = '92056' 29/05/2024 11:27:54 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 ( '92056' , '6663' , 'MIE PREGHIERE - 8783' , '9' , '-9' , '4' , '2.00' , '2' , '0' , '5' , '17.10' ) 29/05/2024 11:27:54 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 ( '92056' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '5' , '-5' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '10.00' ) 29/05/2024 11:27:54 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 ( '92056' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '23' , '-23' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '29.90' ) 29/05/2024 11:27:54 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 ( '92056' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '5' , '-5' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '6.00' ) 29/05/2024 11:28:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1795' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 11:28: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' , '1795' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.25' , '54.34' , NOW() , NOW() ) 29/05/2024 11:28: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 = '92057' 29/05/2024 11:28:14 am >> DELETE FROM ps_document_detail WHERE id_document = '92057' 29/05/2024 11:28: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 ( '92057' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 29/05/2024 11:28: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 ( '92057' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 29/05/2024 11:28: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 ( '92057' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/05/2024 11:31:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1796' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 11:31: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' , '1796' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.30' , '5.30' , NOW() , NOW() ) 29/05/2024 11:31: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 = '92058' 29/05/2024 11:31:14 am >> DELETE FROM ps_document_detail WHERE id_document = '92058' 29/05/2024 11:31: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 ( '92058' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 29/05/2024 11:31: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 ( '92058' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 29/05/2024 12:14:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 12:14:06 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' , '1797' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 29/05/2024 12:14:06 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 = '92059' 29/05/2024 12:14:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '92059' 29/05/2024 12:14:06 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 ( '92059' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '20' , '-20' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '6.00' ) 29/05/2024 12:29:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 12:29:44 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' , '1798' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '8.11' , NOW() , NOW() ) 29/05/2024 12:29:44 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 = '92060' 29/05/2024 12:29:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '92060' 29/05/2024 12:29:44 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 ( '92060' , '18276' , 'CINGOLO CON NODI - 3280' , '3' , '-3' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '7.50' ) 29/05/2024 12:29:44 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 ( '92060' , '20516' , 'CROCE COMUNIONE - 42/08' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 29/05/2024 12:30:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1799' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 12:30: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' , '1799' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.90' , NOW() , NOW() ) 29/05/2024 12:30: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 = '92061' 29/05/2024 12:30:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '92061' 29/05/2024 12:30: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 ( '92061' , '21055' , 'MIA PRIMA EUCARISTIA ' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 29/05/2024 12:37:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 12:37:53 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' , '1800' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '8.69' , NOW() , NOW() ) 29/05/2024 12:37:53 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 = '92062' 29/05/2024 12:37:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '92062' 29/05/2024 12:37:53 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 ( '92062' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 29/05/2024 12:37:53 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 ( '92062' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 29/05/2024 12:37:53 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 ( '92062' , '22546' , 'ROSARIO LEGNO - MM5 - R944' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 29/05/2024 01:08:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1801' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 01:08:31 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' , '1801' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 29/05/2024 01:08:31 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 = '92063' 29/05/2024 01:08:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92063' 29/05/2024 01:08:31 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 ( '92063' , '4887' , 'ICONA LEGNO 10X15 - 1222 ' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 29/05/2024 02:38:54 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '4887' 29/05/2024 02:38:54 pm >> UPDATE ps_stock_available SET quantity = quantity + '-6' WHERE id_product = '4887' 29/05/2024 02:41:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1794' AND id_document != '92056' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 02:41:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1794', document_date = '2024-05-29', 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 = '63.00', price_tax_excluded = '54.72', date_upd = NOW() WHERE id_document = '92056' 29/05/2024 02:41:20 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 = '92056' 29/05/2024 02:41:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '92056' 29/05/2024 02:41:20 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 ( '92056' , '6663' , 'MIE PREGHIERE - 8783' , '9' , '-9' , '4' , '2.0000' , '2' , '0' , '5' , '17.10' ) 29/05/2024 02:41:20 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 ( '92056' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/05/2024 02:41:20 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 ( '92056' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '23' , '-23' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '29.90' ) 29/05/2024 02:41:20 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 ( '92056' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '5' , '-5' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '6.00' ) 29/05/2024 02:43:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '92020' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-25') 29/05/2024 02:43:31 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '68/A', document_date = '2024-05-25', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '29.50', price_tax_excluded = '24.18', date_upd = NOW() WHERE id_document = '92020' 29/05/2024 02:43:31 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 = '92020' 29/05/2024 02:43:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92020' 29/05/2024 02:43:31 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 ( '92020' , '15497' , 'CROCE PLEX - 086' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/05/2024 02:43:31 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 ( '92020' , '15094' , 'BRACCIALE DECINA CORDA TAU' , '15' , '-15' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '19.50' ) 29/05/2024 03:54:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1802' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 03:54: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' , '1802' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.90' , '60.80' , NOW() , NOW() ) 29/05/2024 03:54: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 = '92064' 29/05/2024 03:54:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '92064' 29/05/2024 03:54: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 ( '92064' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '12.90' ) 29/05/2024 03:54: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 ( '92064' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/05/2024 03:54: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 ( '92064' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 29/05/2024 03:54: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 ( '92064' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 29/05/2024 03:54: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 ( '92064' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 29/05/2024 03:58:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1803' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 03:58:09 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' , '1803' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '10.82' , NOW() , NOW() ) 29/05/2024 03:58:09 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 = '92065' 29/05/2024 03:58:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '92065' 29/05/2024 03:58:09 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 ( '92065' , '20516' , 'CROCE COMUNIONE - 42/08' , '11' , '-11' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '13.20' ) 29/05/2024 04:09:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '60/A' AND id_document != '91773' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-13') 29/05/2024 04:09:07 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '60/A', document_date = '2024-05-13', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '575.50', price_tax_excluded = '471.72', date_upd = NOW() WHERE id_document = '91773' 29/05/2024 04:09:07 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 = '91773' 29/05/2024 04:09:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '91773' 29/05/2024 04:09:07 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 ( '91773' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 29/05/2024 04:09:07 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 ( '91773' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 29/05/2024 04:09:07 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 ( '91773' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '100.00' ) 29/05/2024 04:09:07 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 ( '91773' , '17005' , 'BIGLIETTO AUGURALE medio' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 29/05/2024 04:09:07 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 ( '91773' , '22569' , 'MITRIA AVORIO - 86/000890' , '1' , '-1' , '1' , '329.00' , '269.67213114754' , '22' , '0' , '329.00' ) 29/05/2024 04:09:07 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 ( '91773' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '3' , '-3' , '1' , '17.50' , '14.344262295082' , '22' , '0' , '52.50' ) 29/05/2024 04:28:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1804' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 04:28:28 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' , '1804' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.73' , '15.73' , NOW() , NOW() ) 29/05/2024 04:28:28 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 = '92066' 29/05/2024 04:28:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '92066' 29/05/2024 04:28:28 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 ( '92066' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '11' , '-11' , '4' , '1.50' , '1.5' , '0' , '5' , '15.73' ) 29/05/2024 06:26:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1805' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 29/05/2024 06:26:04 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' , '1805' , '2024-05-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 29/05/2024 06:26:04 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 = '92067' 29/05/2024 06:26:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '92067' 29/05/2024 06:26:04 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 ( '92067' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 29/05/2024 06:37:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '14212' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-06') 29/05/2024 06:37:09 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '21', document_date = '2024-05-06', document_letter = '', id_customer = '7084', id_supplier = '', id_address = '172691778', address1 = 'VIA DEI CILIEGI 44/E QUARTIERE TERMINETTO 55049 VIAREGGIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '61.75', price_tax_excluded = '61.75', date_upd = NOW() WHERE id_document = '14212' 29/05/2024 06:37:09 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 = '14212' 29/05/2024 06:37:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '14212' 29/05/2024 06:37:09 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 ( '14212' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '25' , '-25' , '4' , '1.8000' , '1.8' , '0' , '5' , '42.75' ) 29/05/2024 06:37:09 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 ( '14212' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '16' , '-16' , '4' , '1.2' , '1.2' , '0' , '0' , '19.20' ) 29/05/2024 06:37:09 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 ( '14212' , '' , 'arrotondamento' , '1' , '-1' , '4' , '-0.2' , '-0.2' , '0' , '0' , '-0.20' ) 29/05/2024 06:37:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '14468' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-09') 29/05/2024 06:37:41 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '22', document_date = '2024-05-09', document_letter = '', id_customer = '7084', id_supplier = '', id_address = '172691778', address1 = 'VIA DEI CILIEGI 44/E QUARTIERE TERMINETTO 55049 VIAREGGIO', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '142.90', price_tax_excluded = '142.90', date_upd = NOW() WHERE id_document = '14468' 29/05/2024 06:37:41 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 = '14468' 29/05/2024 06:37:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '14468' 29/05/2024 06:37:41 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 ( '14468' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '50' , '-50' , '4' , '1.8000' , '1.8' , '0' , '5' , '85.50' ) 29/05/2024 06:37:41 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 ( '14468' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '5' , '47.50' ) 29/05/2024 06:37:41 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 ( '14468' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' )