28/08/2024 08:53:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2486' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 08:53:46 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' , '2486' , '2024-08-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/08/2024 08:53:46 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 = '92895' 28/08/2024 08:53:46 am >> DELETE FROM ps_document_detail WHERE id_document = '92895' 28/08/2024 08:53: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 ( '92895' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/08/2024 08:56:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2487' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 08:56:04 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' , '2487' , '2024-08-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 28/08/2024 08:56:04 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 = '92896' 28/08/2024 08:56:04 am >> DELETE FROM ps_document_detail WHERE id_document = '92896' 28/08/2024 08:56: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 ( '92896' , '6075' , 'LOURDES BABY - 023 LDS/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 28/08/2024 09:30:24 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3980' 28/08/2024 09:30:24 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3980' , '10' , '183' , 'PARR. SANTUARIO S. GIUSEPPE' , 'AVINO' , 'P. ROSARIO' , 'P. ZZA RISORGIMENTO 1' , '' , '80047' , 'S. GIUSEPPE VESUVIANO' , 'Via San Leonardo 221\r\n80044 Ottaviano\r\nNapoli\r\n' , '' , '3334557671' , '' , '92001090635' , NOW() , NOW() ) 28/08/2024 09:30:24 am >> UPDATE ps_customer SET email = 'rosario.avino@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3980' 28/08/2024 09:31:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2488' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 09:31: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' , '2488' , '2024-08-28' , '' , '0' , '0' , '0' , 'VIA TORINO 84092 BELLIZZI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.70' , '213.71' , NOW() , NOW() ) 28/08/2024 09:31: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 = '92897' 28/08/2024 09:31:55 am >> DELETE FROM ps_document_detail WHERE id_document = '92897' 28/08/2024 09:31: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 ( '92897' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.3000' , '4.1346' , '4' , '0' , '12.90' ) 28/08/2024 09:31: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 ( '92897' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 28/08/2024 09:31: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 ( '92897' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3654' , '4' , '0' , '35.00' ) 28/08/2024 09:31: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 ( '92897' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8525' , '22' , '0' , '112.80' ) 28/08/2024 09:31: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 ( '92897' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0492' , '22' , '0' , '50.00' ) 28/08/2024 09:31: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 ( '92897' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.5000' , '1.2295' , '22' , '0' , '30.00' ) 28/08/2024 09:33:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2489' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 09:33:26 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' , '2489' , '2024-08-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 28/08/2024 09:33:26 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 = '92898' 28/08/2024 09:33:26 am >> DELETE FROM ps_document_detail WHERE id_document = '92898' 28/08/2024 09:33:26 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 ( '92898' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 28/08/2024 09:34:14 am >> DELETE FROM ps_document WHERE id_document = '92866' 28/08/2024 09:34:14 am >> DELETE FROM ps_document_detail WHERE id_document = '92866' 28/08/2024 09:41:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2490' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 09:41:59 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' , '2490' , '2024-08-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.80' , '32.63' , NOW() , NOW() ) 28/08/2024 09:41:59 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 = '92899' 28/08/2024 09:41:59 am >> DELETE FROM ps_document_detail WHERE id_document = '92899' 28/08/2024 09:41:59 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 ( '92899' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 28/08/2024 09:41:59 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 ( '92899' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 28/08/2024 09:58:25 am >> SELECT document_num FROM ps_document WHERE document_num = '16/L' AND id_document != '92886' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-08-27') 28/08/2024 09:58:25 am >> UPDATE ps_document SET id_document_type = '23', document_num = '16/L', document_date = '2024-08-27', document_letter = 'L', id_customer = '4112', id_supplier = '', id_address = '4679340', address1 = 'VIA ALLENDE 8 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '92886' 28/08/2024 09:58:25 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 = '92886' 28/08/2024 09:58:25 am >> DELETE FROM ps_document_detail WHERE id_document = '92886' 28/08/2024 09:58:25 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 ( '92886' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '18.00' ) 28/08/2024 10:22:03 am >> SELECT document_num FROM ps_document WHERE document_num = '90/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 10:22: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 ( '24' , '90/A' , '2024-08-28' , 'A' , '949' , '0' , '4679327' , 'VIA P. PALMIERI 39 10138 TORINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '688.15' , '688.15' , NOW() , NOW() ) 28/08/2024 10:22: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 = '92900' 28/08/2024 10:22:03 am >> DELETE FROM ps_document_detail WHERE id_document = '92900' 28/08/2024 10:22: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 ( '92900' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '0' , '4.30' , '4.3' , '' , '0' , '8.60' ) 28/08/2024 10:22: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 ( '92900' , '' , 'PAN DI CENA PARTICOLE' , '10' , '-10' , '0' , '3.5' , '3.5' , '' , '0' , '35.00' ) 28/08/2024 10:22: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 ( '92900' , '7311' , 'OSTIA SOTTILE 74MM' , '20' , '-20' , '0' , '2.00' , '2' , '' , '0' , '40.00' ) 28/08/2024 10:22: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 ( '92900' , '' , '1269 - QUADRETTO' , '25' , '-25' , '0' , '2.5' , '2.5' , '' , '0' , '62.50' ) 28/08/2024 10:22: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 ( '92900' , '22658' , 'CROCE PADRE NOSTRO - 646/PN' , '30' , '-30' , '0' , '1.80' , '1.8' , '' , '0' , '54.00' ) 28/08/2024 10:22: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 ( '92900' , '17257' , 'IO TI BATTEZZO ' , '30' , '-30' , '4' , '1.80' , '1.8' , '0' , '15' , '45.90' ) 28/08/2024 10:22: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 ( '92900' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '0' , '2.5' , '2.5' , '' , '0' , '100.00' ) 28/08/2024 10:22: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 ( '92900' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '0' , '1.50' , '1.5' , '' , '0' , '60.00' ) 28/08/2024 10:22: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 ( '92900' , '1090' , 'BIBBIA' , '30' , '-30' , '4' , '9.90' , '9.9' , '0' , '5' , '282.15' ) 28/08/2024 10:23:04 am >> SELECT document_num FROM ps_document WHERE document_num = '90/A' AND id_document != '92900' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 10:23:04 am >> UPDATE ps_document SET id_document_type = '24', document_num = '90/A', document_date = '2024-08-28', document_letter = 'A', id_customer = '949', id_supplier = '', id_address = '4679327', address1 = 'VIA P. PALMIERI 39 10138 TORINO', address2 = '', note = 'IBAN: IT 06 V 0834 2896 4001 2010 000 844', 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 = '688.15', price_tax_excluded = '688.15', date_upd = NOW() WHERE id_document = '92900' 28/08/2024 10:23:04 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 = '92900' 28/08/2024 10:23:05 am >> DELETE FROM ps_document_detail WHERE id_document = '92900' 28/08/2024 10:23:05 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 ( '92900' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '0' , '4.3000' , '4.3' , '0' , '0' , '8.60' ) 28/08/2024 10:23:05 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 ( '92900' , '0' , 'PAN DI CENA PARTICOLE' , '10' , '-10' , '0' , '3.5000' , '3.5' , '0' , '0' , '35.00' ) 28/08/2024 10:23:05 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 ( '92900' , '7311' , 'OSTIA SOTTILE 74MM' , '20' , '-20' , '0' , '2.0000' , '2' , '0' , '0' , '40.00' ) 28/08/2024 10:23:05 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 ( '92900' , '0' , '1269 - QUADRETTO' , '25' , '-25' , '0' , '2.5000' , '2.5' , '0' , '0' , '62.50' ) 28/08/2024 10:23:05 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 ( '92900' , '22658' , 'CROCE PADRE NOSTRO - 646/PN' , '30' , '-30' , '0' , '1.8000' , '1.8' , '0' , '0' , '54.00' ) 28/08/2024 10:23:05 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 ( '92900' , '17257' , 'IO TI BATTEZZO ' , '30' , '-30' , '4' , '1.8000' , '1.8' , '0' , '15' , '45.90' ) 28/08/2024 10:23:05 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 ( '92900' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '0' , '2.5000' , '2.5' , '0' , '0' , '100.00' ) 28/08/2024 10:23:05 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 ( '92900' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '0' , '1.5000' , '1.5' , '0' , '0' , '60.00' ) 28/08/2024 10:23:05 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 ( '92900' , '1090' , 'BIBBIA' , '30' , '-30' , '4' , '9.9000' , '9.9' , '0' , '5' , '282.15' ) 28/08/2024 11:52:12 am >> SELECT document_num FROM ps_document WHERE document_num = '90/A' AND id_document != '92900' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 11:52:12 am >> UPDATE ps_document SET id_document_type = '24', document_num = '90/A', document_date = '2024-08-28', document_letter = 'A', id_customer = '949', id_supplier = '', id_address = '4679327', address1 = 'VIA P. PALMIERI 39 10138 TORINO', address2 = '', note = 'IBAN: IT 06 V 0834 2896 4001 2010 000 844', 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 = '673.30', price_tax_excluded = '673.30', date_upd = NOW() WHERE id_document = '92900' 28/08/2024 11:52:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92900' 28/08/2024 11:52:12 am >> DELETE FROM ps_document_detail WHERE id_document = '92900' 28/08/2024 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92900' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '0' , '4.3000' , '4.3' , '0' , '0' , '8.60' ) 28/08/2024 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92900' , '0' , 'PAN DI CENA PARTICOLE' , '10' , '-10' , '0' , '3.5000' , '3.5' , '0' , '0' , '35.00' ) 28/08/2024 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92900' , '7311' , 'OSTIA SOTTILE 74MM' , '20' , '-20' , '0' , '2.0000' , '2' , '0' , '0' , '40.00' ) 28/08/2024 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92900' , '0' , '1269 - QUADRETTO' , '25' , '-25' , '0' , '2.5000' , '2.5' , '0' , '0' , '62.50' ) 28/08/2024 11:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92900' , '22658' , 'CROCE PADRE NOSTRO - 646/PN' , '30' , '-30' , '0' , '1.8000' , '1.8' , '0' , '0' , '54.00' ) 28/08/2024 11:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92900' , '17257' , 'IO TI BATTEZZO ' , '30' , '-30' , '4' , '1.8000' , '1.8' , '0' , '15' , '45.90' ) 28/08/2024 11:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92900' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '0' , '2.5000' , '2.5' , '0' , '0' , '100.00' ) 28/08/2024 11:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92900' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '0' , '1.5000' , '1.5' , '0' , '0' , '60.00' ) 28/08/2024 11:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92900' , '1090' , 'BIBBIA' , '30' , '-30' , '4' , '9.9000' , '9.9' , '0' , '10' , '267.30' ) 28/08/2024 11:57:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2491' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 11:57: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' , '2491' , '2024-08-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.52' , '64.52' , NOW() , NOW() ) 28/08/2024 11:57: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 = '92901' 28/08/2024 11:57:41 am >> DELETE FROM ps_document_detail WHERE id_document = '92901' 28/08/2024 11:57: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 ( '92901' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '0' , '40.00' ) 28/08/2024 11:57: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 ( '92901' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 28/08/2024 11:57: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 ( '92901' , '22717' , 'PAROLA E PREGHIERA - SETT 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 28/08/2024 11:57: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 ( '92901' , '22768' , 'PAROLA E PREGHIERA - OTT 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 28/08/2024 12:12:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2492' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 12:12:56 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' , '2492' , '2024-08-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/08/2024 12:12:56 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 = '92902' 28/08/2024 12:12:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '92902' 28/08/2024 12:12:56 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 ( '92902' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/08/2024 12:22:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '90/A' AND id_document != '92900' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 12:22:03 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '90/A', document_date = '2024-08-28', document_letter = 'A', id_customer = '949', id_supplier = '', id_address = '4679327', address1 = 'VIA P. PALMIERI 39 10138 TORINO', address2 = '', note = 'IBAN: IT 79 Z010 0515 2010 0000 0007 083 causale - acquisto materiale liturgico', 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 = '673.30', price_tax_excluded = '673.30', date_upd = NOW() WHERE id_document = '92900' 28/08/2024 12:22:03 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 = '92900' 28/08/2024 12:22:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '92900' 28/08/2024 12:22:03 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 ( '92900' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '0' , '4.3000' , '4.3' , '0' , '0' , '8.60' ) 28/08/2024 12:22:03 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 ( '92900' , '0' , 'PAN DI CENA PARTICOLE' , '10' , '-10' , '0' , '3.5000' , '3.5' , '0' , '0' , '35.00' ) 28/08/2024 12:22:03 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 ( '92900' , '7311' , 'OSTIA SOTTILE 74MM' , '20' , '-20' , '0' , '2.0000' , '2' , '0' , '0' , '40.00' ) 28/08/2024 12:22:03 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 ( '92900' , '0' , '1269 - QUADRETTO' , '25' , '-25' , '0' , '2.5000' , '2.5' , '0' , '0' , '62.50' ) 28/08/2024 12:22:03 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 ( '92900' , '22658' , 'CROCE PADRE NOSTRO - 646/PN' , '30' , '-30' , '0' , '1.8000' , '1.8' , '0' , '0' , '54.00' ) 28/08/2024 12:22:03 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 ( '92900' , '17257' , 'IO TI BATTEZZO ' , '30' , '-30' , '4' , '1.8000' , '1.8' , '0' , '15' , '45.90' ) 28/08/2024 12:22:03 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 ( '92900' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '0' , '2.5000' , '2.5' , '0' , '0' , '100.00' ) 28/08/2024 12:22:03 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 ( '92900' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '0' , '1.5000' , '1.5' , '0' , '0' , '60.00' ) 28/08/2024 12:22: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 ( '92900' , '1090' , 'BIBBIA' , '30' , '-30' , '4' , '9.9000' , '9.9' , '0' , '10' , '267.30' ) 28/08/2024 12:22:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2493' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-28') 28/08/2024 12:22: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' , '2493' , '2024-08-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 28/08/2024 12:22: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 = '92903' 28/08/2024 12:22:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '92903' 28/08/2024 12:22: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 ( '92903' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' )