18/06/2024 09:40:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2015' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 09:40:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2015' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.50' , '93.03' , NOW() , NOW() ) 18/06/2024 09:40:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92321' 18/06/2024 09:40:03 am >> DELETE FROM ps_document_detail WHERE id_document = '92321' 18/06/2024 09:40:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92321' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 18/06/2024 09:40:04 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 ( '92321' , '20081' , 'BRACCIALE ARGENTO' , '1' , '-1' , '1' , '23.50' , '19.262295081967' , '22' , '0' , '23.50' ) 18/06/2024 09:43:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2016' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 09:43:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2016' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 18/06/2024 09:43:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92322' 18/06/2024 09:43:03 am >> DELETE FROM ps_document_detail WHERE id_document = '92322' 18/06/2024 09:43:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92322' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '11' , '-11' , '4' , '5.00' , '5' , '0' , '5' , '52.25' ) 18/06/2024 09:43:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92322' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '11' , '-11' , '4' , '5.00' , '5' , '0' , '5' , '52.25' ) 18/06/2024 10:23:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2017' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 10:23: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' , '2017' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '43.44' , NOW() , NOW() ) 18/06/2024 10:23: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 = '92323' 18/06/2024 10:23:35 am >> DELETE FROM ps_document_detail WHERE id_document = '92323' 18/06/2024 10:23: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 ( '92323' , '21150' , 'QUADRO - BD15X15' , '1' , '-1' , '1' , '19' , '15.573770491803' , '22' , '0' , '19.00' ) 18/06/2024 10:23:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92323' , '20705' , 'CANDELA CUBO' , '2' , '-2' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '34.00' ) 18/06/2024 10:26:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2018' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 10:26: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' , '2018' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.66' , NOW() , NOW() ) 18/06/2024 10:26: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 = '92324' 18/06/2024 10:26:58 am >> DELETE FROM ps_document_detail WHERE id_document = '92324' 18/06/2024 10:26: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 ( '92324' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 18/06/2024 11:30:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2019' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 11:30:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2019' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 18/06/2024 11:30:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92325' 18/06/2024 11:30:37 am >> DELETE FROM ps_document_detail WHERE id_document = '92325' 18/06/2024 11:30:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92325' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 18/06/2024 12:21:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '20/A' AND id_document != '90245' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-06') 18/06/2024 12:21:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '20/A', document_date = '2024-02-06', document_letter = 'A', id_customer = '1237', id_supplier = '', id_address = '4679207', address1 = 'VIA MILANO 11 97019 VITTORIA', address2 = '', note = 'pagato', 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 = '525.00', price_tax_excluded = '525.00', date_upd = NOW() WHERE id_document = '90245' 18/06/2024 12:21: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 = '90245' 18/06/2024 12:21:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '90245' 18/06/2024 12:21: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 ( '90245' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '350' , '-350' , '4' , '1.5000' , '1.5' , '0' , '0' , '525.00' ) 18/06/2024 12:33:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2020' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 12:33: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' , '2020' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '16.47' , NOW() , NOW() ) 18/06/2024 12:33: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 = '92326' 18/06/2024 12:33:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '92326' 18/06/2024 12:33:33 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 ( '92326' , '22337' , 'CROCE IN POLIMERO - 2748' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 18/06/2024 12:33:33 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 ( '92326' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 18/06/2024 12:33:33 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 ( '92326' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 18/06/2024 04:27:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2021' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 04:27:32 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' , '2021' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 18/06/2024 04:27:32 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 = '92327' 18/06/2024 04:27:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '92327' 18/06/2024 04:27:32 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 ( '92327' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 18/06/2024 04:51:48 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 ( '31' , '24FP00671' , '2024-06-12' , '' , '0' , '63' , '2658' , 'P.ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '252.00' , '252.00' , NOW() , NOW() ) 18/06/2024 04:51:48 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 = '92328' 18/06/2024 04:51:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '92328' 18/06/2024 04:51:48 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 ( '92328' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '450' , '450' , '4' , '0.56' , '0.56' , '0' , '0' , '252.0000' ) 18/06/2024 04:51:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '63' 18/06/2024 04:51:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '63' , '1' ) 18/06/2024 06:40:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2022' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 06:40:52 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' , '2022' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.90' , '16.31' , NOW() , NOW() ) 18/06/2024 06:40:52 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 = '92329' 18/06/2024 06:40:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '92329' 18/06/2024 06:40:52 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 ( '92329' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '19.90' , '16.311475409836' , '22' , '0' , '19.90' ) 18/06/2024 06:47:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2023' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 06:47:46 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' , '2023' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.70' , '0.70' , NOW() , NOW() ) 18/06/2024 06:47:46 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 = '92330' 18/06/2024 06:47:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '92330' 18/06/2024 06:47:46 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 ( '92330' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 18/06/2024 06:48:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 18/06/2024 06:48:29 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '94.40', price_tax_excluded = '94.40', date_upd = NOW() WHERE id_document = '89846' 18/06/2024 06:48:29 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 = '89846' 18/06/2024 06:48:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 18/06/2024 06:48:29 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 ( '89846' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 18/06/2024 06:48:29 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 ( '89846' , '19892' , 'SALVE, REGINA - S. HAHN' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/06/2024 06:48:30 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 ( '89846' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 18/06/2024 06:48:30 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 ( '89846' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/06/2024 06:48:30 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 ( '89846' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/06/2024 06:48:30 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 ( '89846' , '22557' , 'PAROLA E PREGHIERA - AGO 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 18/06/2024 06:48:30 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 ( '89846' , '22568' , 'CUORE EUCARISTICO DI GESU - S. LONGOBARDI' , '1' , '-1' , '4' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 18/06/2024 06:48:30 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 ( '89846' , '22567' , 'CUORE DI CRISTO - L. TORRUSIO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/06/2024 06:48:30 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 ( '89846' , '22685' , 'LAZZARO VIENI FUORI - J. MARTIN' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 18/06/2024 06:48:30 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 ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 18/06/2024 07:40:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2024' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 07:40: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' , '2024' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.90' , '17.06' , NOW() , NOW() ) 18/06/2024 07:40: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 = '92331' 18/06/2024 07:40:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '92331' 18/06/2024 07:40: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 ( '92331' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 18/06/2024 07:40: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 ( '92331' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 18/06/2024 07:40: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 ( '92331' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 18/06/2024 07:40: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 ( '92331' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '3.00' ) 18/06/2024 07:40: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 ( '92331' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '5' , '-5' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '1.50' ) 18/06/2024 07:40: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 ( '92331' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 18/06/2024 07:40: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 ( '92331' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 18/06/2024 07:40: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 ( '92331' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 18/06/2024 07:42:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2025' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 18/06/2024 07:42:12 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' , '2025' , '2024-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 18/06/2024 07:42:12 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 = '92332' 18/06/2024 07:42:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '92332' 18/06/2024 07:42:12 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 ( '92332' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' )