02/02/2024 09:43:37 am >> SELECT document_num FROM ps_document WHERE document_num = '16/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 09:43: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 ( '24' , '16/A' , '2024-02-02' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '107.10' , '88.68' , NOW() , NOW() ) 02/02/2024 09:43: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 = '90205' 02/02/2024 09:43:37 am >> DELETE FROM ps_document_detail WHERE id_document = '90205' 02/02/2024 09:43: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 ( '90205' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '75.00' ) 02/02/2024 09:43: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 ( '90205' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 02/02/2024 09:43: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 ( '90205' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/02/2024 09:43: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 ( '90205' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 02/02/2024 09:43: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 ( '90205' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 02/02/2024 09:49:22 am >> SELECT document_num FROM ps_document WHERE document_num = '343' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 09:49:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '343' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 02/02/2024 09:49:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90206' 02/02/2024 09:49:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90206' 02/02/2024 09:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90206' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 02/02/2024 09:50:28 am >> SELECT document_num FROM ps_document WHERE document_num = '344' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 09:50:28 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' , '344' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 02/02/2024 09:50:28 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 = '90207' 02/02/2024 09:50:28 am >> DELETE FROM ps_document_detail WHERE id_document = '90207' 02/02/2024 09:50:28 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 ( '90207' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 02/02/2024 09:51:22 am >> SELECT document_num FROM ps_document WHERE document_num = '345' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 09:51:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '345' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.29' , NOW() , NOW() ) 02/02/2024 09:51:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90208' 02/02/2024 09:51:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90208' 02/02/2024 09:51:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90208' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/02/2024 09:51:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90208' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 02/02/2024 10:07:13 am >> SELECT document_num FROM ps_document WHERE document_num = '337' AND id_document != '90199' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-01') 02/02/2024 10:07:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '337', document_date = '2024-02-01', 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 = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '90199' 02/02/2024 10:07:13 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 = '90199' 02/02/2024 10:07:13 am >> DELETE FROM ps_document_detail WHERE id_document = '90199' 02/02/2024 10:07: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 ( '90199' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '0.92' , '0.92' , '0' , '0' , '0.92' ) 02/02/2024 10:07: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 ( '90199' , '22111' , 'PREGARE OGGI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 02/02/2024 10:07: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 ( '90199' , '22115' , 'ATTRAVERSO IL DESERTO - MESSAGGIO QUARESIMA 2024' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 02/02/2024 10:08:50 am >> SELECT document_num FROM ps_document WHERE document_num = '17/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 10:08:50 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' , '17/A' , '2024-02-02' , 'A' , '1148' , '0' , '1148' , 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA' , '' , 'x santuario' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.00' , '75.41' , NOW() , NOW() ) 02/02/2024 10:08:50 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 = '90209' 02/02/2024 10:08:50 am >> DELETE FROM ps_document_detail WHERE id_document = '90209' 02/02/2024 10:08:50 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 ( '90209' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 02/02/2024 10:08:50 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 ( '90209' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '24.00' ) 02/02/2024 11:03:22 am >> SELECT document_num FROM ps_document WHERE document_num = '346' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 11:03:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '346' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.88' , '11.19' , NOW() , NOW() ) 02/02/2024 11:03:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90210' 02/02/2024 11:03:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90210' 02/02/2024 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90210' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 02/02/2024 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90210' , '22111' , 'PREGARE OGGI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 02/02/2024 11:15:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '14/24' , '2024-01-31' , '24' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '343.20' , '330.00' , NOW() , NOW() ) 02/02/2024 11:15:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90211' 02/02/2024 11:15:42 am >> DELETE FROM ps_document_detail WHERE id_document = '90211' 02/02/2024 11:15:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90211' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '200' , '0' , '3' , '0.55' , '0.52884615384615' , '4' , '0' , '114.4000' ) 02/02/2024 11:15:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '22053' AND id_supplier = '145' 02/02/2024 11:15:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22053' , '145' , '1' ) 02/02/2024 11:15:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90211' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '400' , '0' , '3' , '0.55' , '0.52884615384615' , '4' , '0' , '228.8000' ) 02/02/2024 11:15:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '22053' AND id_supplier = '145' 02/02/2024 11:15:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22053' , '145' , '1' ) 02/02/2024 11:21:50 am >> SELECT document_num FROM ps_document WHERE document_num = '347' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 11:21:50 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' , '347' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.40' , '91.15' , NOW() , NOW() ) 02/02/2024 11:21:50 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 = '90212' 02/02/2024 11:21:50 am >> DELETE FROM ps_document_detail WHERE id_document = '90212' 02/02/2024 11:21:50 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 ( '90212' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '15' , '15' , '0' , '0' , '90.00' ) 02/02/2024 11:21:50 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 ( '90212' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 02/02/2024 11:44:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3474' AND id_document != '88747' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-06') 02/02/2024 11:44:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3474', document_date = '2023-11-06', 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 = '265.00', price_tax_excluded = '217.21', date_upd = NOW() WHERE id_document = '88747' 02/02/2024 11:44:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88747' 02/02/2024 11:44:53 am >> DELETE FROM ps_document_detail WHERE id_document = '88747' 02/02/2024 11:44:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88747' , '19432' , 'QUADRO DECORATO 35X25 - R35' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 02/02/2024 11:44:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88747' , '18370' , 'CAMICE MISTO LANA - 70/000214' , '1' , '-1' , '1' , '205' , '168.03278688525' , '22' , '0' , '205.00' ) 02/02/2024 11:45:21 am >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '89783' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-03') 02/02/2024 11:45:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '14', document_date = '2024-01-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '658.00', price_tax_excluded = '557.02', date_upd = NOW() WHERE id_document = '89783' 02/02/2024 11:45:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89783' 02/02/2024 11:45:21 am >> DELETE FROM ps_document_detail WHERE id_document = '89783' 02/02/2024 11:45:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89783' , '3590' , 'DIZIONARIO DEI CONCETTI BIBLICI DEL NUOVO TESTAMENTO' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 02/02/2024 11:45:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89783' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 02/02/2024 11:45:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89783' , '15541' , 'STOLA LINO/POL CON GIGLIUCCIO A MANO' , '1' , '-1' , '1' , '175.0000' , '143.44262295082' , '22' , '0' , '175.00' ) 02/02/2024 11:45:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89783' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 02/02/2024 11:46:18 am >> SELECT document_num FROM ps_document WHERE document_num = '4211' AND id_document != '89747' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-29') 02/02/2024 11:46:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4211', document_date = '2023-12-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 = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '89747' 02/02/2024 11:46:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89747' 02/02/2024 11:46:18 am >> DELETE FROM ps_document_detail WHERE id_document = '89747' 02/02/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89747' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 02/02/2024 11:47:00 am >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '89783' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-03') 02/02/2024 11:47:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '14', document_date = '2024-01-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '658.00', price_tax_excluded = '557.02', date_upd = NOW() WHERE id_document = '89783' 02/02/2024 11:47:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89783' 02/02/2024 11:47:00 am >> DELETE FROM ps_document_detail WHERE id_document = '89783' 02/02/2024 11:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89783' , '3590' , 'DIZIONARIO DEI CONCETTI BIBLICI DEL NUOVO TESTAMENTO' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 02/02/2024 11:47:01 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 ( '89783' , '15541' , 'STOLA LINO/POL CON GIGLIUCCIO A MANO' , '1' , '-1' , '1' , '175.0000' , '143.44262295082' , '22' , '0' , '175.00' ) 02/02/2024 11:47:01 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 ( '89783' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '385' , '315.5737704918' , '22' , '0' , '385.00' ) 02/02/2024 11:49:30 am >> SELECT document_num FROM ps_document WHERE document_num = '4113' AND id_document != '89638' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 02/02/2024 11:49:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4113', document_date = '2023-12-22', 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 = '34.30', price_tax_excluded = '29.32', date_upd = NOW() WHERE id_document = '89638' 02/02/2024 11:49:30 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 = '89638' 02/02/2024 11:49:30 am >> DELETE FROM ps_document_detail WHERE id_document = '89638' 02/02/2024 11:49:30 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 ( '89638' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '2.80' ) 02/02/2024 11:49:30 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 ( '89638' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 02/02/2024 11:49:30 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 ( '89638' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/02/2024 11:49:30 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 ( '89638' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '8.5000' , '8.1730769230769' , '4' , '0' , '8.50' ) 02/02/2024 11:50:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4031' AND id_document != '89542' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 02/02/2024 11:50:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4031', document_date = '2023-12-18', 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 = '350.00', price_tax_excluded = '291.07', date_upd = NOW() WHERE id_document = '89542' 02/02/2024 11:50: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 = '89542' 02/02/2024 11:50:14 am >> DELETE FROM ps_document_detail WHERE id_document = '89542' 02/02/2024 11:50: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 ( '89542' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 02/02/2024 11:50: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 ( '89542' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 02/02/2024 11:50: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 ( '89542' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 02/02/2024 11:50: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 ( '89542' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '210.5' , '172.54098360656' , '22' , '0' , '210.50' ) 02/02/2024 11:50: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 ( '89542' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '60' , '-60' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '90.00' ) 02/02/2024 11:53:04 am >> SELECT document_num FROM ps_document WHERE document_num = '4031' AND id_document != '89542' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 02/02/2024 11:53:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4031', document_date = '2023-12-18', 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 = '350.00', price_tax_excluded = '291.07', date_upd = NOW() WHERE id_document = '89542' 02/02/2024 11:53: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 = '89542' 02/02/2024 11:53:04 am >> DELETE FROM ps_document_detail WHERE id_document = '89542' 02/02/2024 11:53: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 ( '89542' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 02/02/2024 11:53: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 ( '89542' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 02/02/2024 11:53: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 ( '89542' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 02/02/2024 11:53: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 ( '89542' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '80.5' , '65.983606557377' , '22' , '0' , '80.50' ) 02/02/2024 11:53: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 ( '89542' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '60' , '-60' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '90.00' ) 02/02/2024 11:53: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 ( '89542' , '12749' , 'DALMATICA - 3512/TP' , '1' , '-1' , '1' , '130.00' , '106.55737704918' , '22' , '0' , '130.00' ) 02/02/2024 11:53:26 am >> SELECT document_num FROM ps_document WHERE document_num = '91' AND id_document != '89882' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-09') 02/02/2024 11:53:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '91', document_date = '2024-01-09', 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 = '130.00', price_tax_excluded = '106.56', date_upd = NOW() WHERE id_document = '89882' 02/02/2024 11:53: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 = '89882' 02/02/2024 11:53:26 am >> DELETE FROM ps_document_detail WHERE id_document = '89882' 02/02/2024 11:53:27 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 ( '89882' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 02/02/2024 11:55:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3946' AND id_document != '89440' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-12') 02/02/2024 11:55:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3946', document_date = '2023-12-12', 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 = '16.30', price_tax_excluded = '13.36', date_upd = NOW() WHERE id_document = '89440' 02/02/2024 11:55:05 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 = '89440' 02/02/2024 11:55:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89440' 02/02/2024 11:55: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 ( '89440' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '1' , '-1' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '3.30' ) 02/02/2024 11:55: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 ( '89440' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 02/02/2024 11:55: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 ( '89440' , '20526' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A' , '5' , '-5' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '6.00' ) 02/02/2024 11:55:48 am >> SELECT document_num FROM ps_document WHERE document_num = '4161' AND id_document != '89692' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-23') 02/02/2024 11:55:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4161', document_date = '2023-12-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '580.00', price_tax_excluded = '480.95', date_upd = NOW() WHERE id_document = '89692' 02/02/2024 11:55:48 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 = '89692' 02/02/2024 11:55:48 am >> DELETE FROM ps_document_detail WHERE id_document = '89692' 02/02/2024 11:55:48 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 ( '89692' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/02/2024 11:55:48 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 ( '89692' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/02/2024 11:55:48 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 ( '89692' , '1203' , 'BIBBIA TUTTA MIA' , '1' , '-1' , '4' , '12.3000' , '12.3' , '0' , '0' , '12.30' ) 02/02/2024 11:55:48 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 ( '89692' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 02/02/2024 11:55:48 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 ( '89692' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '12' , '-12' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '2.40' ) 02/02/2024 11:55:48 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 ( '89692' , '10957' , 'UNIFORMITÀ ALLA VOLONTÀ DI DIO - 8549' , '1' , '-1' , '4' , '6.7000' , '6.7' , '0' , '0' , '6.70' ) 02/02/2024 11:55:48 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 ( '89692' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 02/02/2024 11:55:48 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 ( '89692' , '2764' , 'CORONA EMATITE TONDA ' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 02/02/2024 11:55:48 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 ( '89692' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '36.00' ) 02/02/2024 11:55:48 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 ( '89692' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '143.0000' , '117.2131147541' , '22' , '0' , '143.00' ) 02/02/2024 11:55:48 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 ( '89692' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.8500' , '0.85' , '0' , '0' , '0.85' ) 02/02/2024 11:55:48 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 ( '89692' , '15541' , 'STOLA LINO/POL CON GIGLIUCCIO A MANO' , '2' , '-2' , '1' , '175.0000' , '143.44262295082' , '22' , '0' , '350.00' ) 02/02/2024 11:55:48 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 ( '89692' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/02/2024 11:57:31 am >> SELECT document_num FROM ps_document WHERE document_num = '4188' AND id_document != '89721' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-28') 02/02/2024 11:57:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4188', document_date = '2023-12-28', 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 = '13.80', price_tax_excluded = '12.12', date_upd = NOW() WHERE id_document = '89721' 02/02/2024 11:57:31 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 = '89721' 02/02/2024 11:57:31 am >> DELETE FROM ps_document_detail WHERE id_document = '89721' 02/02/2024 11:57:31 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 ( '89721' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 02/02/2024 11:57:31 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 ( '89721' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '5' , '-5' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '1.50' ) 02/02/2024 11:57:31 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 ( '89721' , '20067' , 'CATENINA CON MED. SAN BENEDETTO - NS047' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 02/02/2024 11:57:31 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 ( '89721' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 02/02/2024 11:57:31 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 ( '89721' , '20026' , 'CANDELA VOTIVA 20X40' , '8' , '-8' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '4.00' ) 02/02/2024 11:58:34 am >> SELECT document_num FROM ps_document WHERE document_num = '4210' AND id_document != '89745' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-29') 02/02/2024 11:58:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4210', document_date = '2023-12-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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '89745' 02/02/2024 11:58:34 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 = '89745' 02/02/2024 11:58:34 am >> DELETE FROM ps_document_detail WHERE id_document = '89745' 02/02/2024 11:58:34 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 ( '89745' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '4' , '-4' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '14.00' ) 02/02/2024 11:58:34 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 ( '89745' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '4' , '-4' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '14.00' ) 02/02/2024 11:58:34 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 ( '89745' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '8' , '-8' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.00' ) 02/02/2024 11:58:34 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 ( '89745' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 02/02/2024 11:59:28 am >> SELECT document_num FROM ps_document WHERE document_num = '4115' AND id_document != '89640' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 02/02/2024 11:59:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4115', document_date = '2023-12-22', 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 = '57.40', price_tax_excluded = '50.13', date_upd = NOW() WHERE id_document = '89640' 02/02/2024 11:59:29 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 = '89640' 02/02/2024 11:59:29 am >> DELETE FROM ps_document_detail WHERE id_document = '89640' 02/02/2024 11:59:29 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 ( '89640' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '6' , '-6' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '30.00' ) 02/02/2024 11:59:29 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 ( '89640' , '21839' , 'NATIVITA IN RESINA CM 8 - P725' , '1' , '-1' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '4.70' ) 02/02/2024 11:59:29 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 ( '89640' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 02/02/2024 11:59:29 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 ( '89640' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '5' , '-5' , '1' , '1.12' , '0.91803278688525' , '22' , '0' , '5.60' ) 02/02/2024 12:00:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '4116' AND id_document != '89641' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 02/02/2024 12:00:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4116', document_date = '2023-12-22', 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 = '5.40', price_tax_excluded = '4.43', date_upd = NOW() WHERE id_document = '89641' 02/02/2024 12:00:26 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 = '89641' 02/02/2024 12:00:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '89641' 02/02/2024 12:00:26 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 ( '89641' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 02/02/2024 12:00:26 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 ( '89641' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '4' , '-4' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '5.20' ) 02/02/2024 12:00:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '4215' AND id_document != '89751' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-30') 02/02/2024 12:00:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4215', document_date = '2023-12-30', 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 = '115.00', price_tax_excluded = '99.19', date_upd = NOW() WHERE id_document = '89751' 02/02/2024 12:00:59 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 = '89751' 02/02/2024 12:00:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '89751' 02/02/2024 12:00:59 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 ( '89751' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/02/2024 12:00:59 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 ( '89751' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 02/02/2024 12:00:59 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 ( '89751' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '10' , '-10' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '13.00' ) 02/02/2024 12:00:59 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 ( '89751' , '13805' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024' , '1' , '-1' , '1' , '11.9000' , '9.7540983606557' , '22' , '0' , '11.90' ) 02/02/2024 12:00:59 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 ( '89751' , '21196' , 'CALENDARIO LITURGICO 2024' , '4' , '-4' , '4' , '0.5000' , '0.5' , '0' , '0' , '2.00' ) 02/02/2024 12:00:59 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 ( '89751' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '3' , '-3' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '14.70' ) 02/02/2024 12:00:59 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 ( '89751' , '20219' , 'MEDAGLIA SAN BENEDETTO CM 4 - 400/N0216' , '10' , '-10' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '30.00' ) 02/02/2024 12:00:59 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 ( '89751' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '8.05' , '6.5983606557377' , '22' , '0' , '8.05' ) 02/02/2024 12:00:59 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 ( '89751' , '20833' , 'SEGNO E LA CARNE - L. BRUNI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 02/02/2024 12:07:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/A' AND id_document != '89980' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-17') 02/02/2024 12:07:18 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '10/A', document_date = '2024-01-17', document_letter = 'A', id_customer = '189', id_supplier = '', id_address = '4679063', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = 'spedite', price_shipping = '7.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 = '193.00', price_tax_excluded = '193.00', date_upd = NOW() WHERE id_document = '89980' 02/02/2024 12:07:18 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 = '89980' 02/02/2024 12:07:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '89980' 02/02/2024 12:07:18 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 ( '89980' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '300' , '-300' , '4' , '1.0000' , '1' , '0' , '38' , '186.00' ) 02/02/2024 12:08:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 12:08: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 ( '24' , '18/A' , '2024-02-02' , 'A' , '0' , '11' , '2606' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '498.00' , '441.74' , NOW() , NOW() ) 02/02/2024 12:08: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 = '90213' 02/02/2024 12:08:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90213' 02/02/2024 12:08: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 ( '90213' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '35' , '312.00' ) 02/02/2024 12:08:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12815' AND id_supplier = '11' 02/02/2024 12:08:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12815' , '11' , '1' ) 02/02/2024 12:08: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 ( '90213' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '300' , '-300' , '4' , '1.00' , '1' , '0' , '38' , '186.00' ) 02/02/2024 12:08:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16665' AND id_supplier = '11' 02/02/2024 12:08:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16665' , '11' , '1' ) 02/02/2024 12:13:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '348' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 12:13:35 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' , '348' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 02/02/2024 12:13:35 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 = '90214' 02/02/2024 12:13:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '90214' 02/02/2024 12:13:35 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 ( '90214' , '22117' , 'MORTE E DI VITALE IMPORTANZA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 02/02/2024 12:18:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 12:18:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '3' , '2024-02-02' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4410.00' , '4410.00' , NOW() , NOW() ) 02/02/2024 12:18:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90215' 02/02/2024 12:18:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '90215' 02/02/2024 12:18:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90215' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '50' , '-50' , '4' , '2.10' , '2.1' , '0' , '0' , '105.00' ) 02/02/2024 12:18:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90215' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '110' , '-110' , '4' , '6.00' , '6' , '0' , '0' , '660.00' ) 02/02/2024 12:18:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90215' , '16667' , 'VIA CRUCIS' , '300' , '-300' , '4' , '3.00' , '3' , '0' , '0' , '900.00' ) 02/02/2024 12:18:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90215' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE - PADRE G. VALSECCHI' , '20' , '-20' , '4' , '10.00' , '10' , '0' , '0' , '200.00' ) 02/02/2024 12:18:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90215' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '90' , '-90' , '4' , '2.50' , '2.5' , '0' , '0' , '225.00' ) 02/02/2024 12:18:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90215' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '480' , '-480' , '4' , '2.50' , '2.5' , '0' , '0' , '1200.00' ) 02/02/2024 12:18:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90215' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1120' , '-1120' , '4' , '1.00' , '1' , '0' , '0' , '1120.00' ) 02/02/2024 12:33:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '349' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 12:33:40 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' , '349' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.80' , '29.34' , NOW() , NOW() ) 02/02/2024 12:33:40 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 = '90216' 02/02/2024 12:33:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '90216' 02/02/2024 12:33:40 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 ( '90216' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 02/02/2024 12:43:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '350' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 12:43:42 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' , '350' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '136.00' , '111.48' , NOW() , NOW() ) 02/02/2024 12:43:42 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 = '90217' 02/02/2024 12:43:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '90217' 02/02/2024 12:43:42 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 ( '90217' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '136.00' ) 02/02/2024 12:49:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '351' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 12:49:26 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' , '351' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '55.74' , NOW() , NOW() ) 02/02/2024 12:49:26 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 = '90218' 02/02/2024 12:49:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '90218' 02/02/2024 12:49:26 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 ( '90218' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 02/02/2024 05:02:13 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' , '2400000' , '2024-02-02' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , 'cambiare numero' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '290.46' , '238.08' , NOW() , NOW() ) 02/02/2024 05:02:13 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 = '90219' 02/02/2024 05:02:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90219' 02/02/2024 05:02:13 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 ( '90219' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '3' , '3' , '1' , '17.5' , '14.344262295082' , '22' , '8' , '58.9260' ) 02/02/2024 05:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '137' 02/02/2024 05:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '137' , '1' ) 02/02/2024 05:02:13 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 ( '90219' , '18947' , 'CLERGY MISTO 80-20 ML - COM' , '1' , '1' , '1' , '19.25' , '15.77868852459' , '22' , '0' , '23.4850' ) 02/02/2024 05:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18947' AND id_supplier = '137' 02/02/2024 05:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18947' , '137' , '1' ) 02/02/2024 05:02:13 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 ( '90219' , '19607' , 'CLERGY F/F ML - C03' , '2' , '2' , '1' , '18.9' , '15.491803278689' , '22' , '6' , '43.3490' ) 02/02/2024 05:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19607' AND id_supplier = '137' 02/02/2024 05:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19607' , '137' , '1' ) 02/02/2024 05:02:13 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 ( '90219' , '22045' , 'CLERGY REGULAR ML - C 24' , '4' , '4' , '1' , '22.5' , '18.44262295082' , '22' , '10' , '98.8200' ) 02/02/2024 05:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22045' AND id_supplier = '137' 02/02/2024 05:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22045' , '137' , '1' ) 02/02/2024 05:02:13 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 ( '90219' , '19605' , 'CLERGY SU MISURA - COCOCLER' , '2' , '2' , '1' , '27' , '22.131147540984' , '22' , '0' , '65.8800' ) 02/02/2024 05:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19605' AND id_supplier = '137' 02/02/2024 05:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19605' , '137' , '1' ) 02/02/2024 05:04:43 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '28', document_date = '2024-01-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670816', address1 = 'VIA G. BATTISTA VICO 73 80010 VILLARICCA', 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 = '290.47', price_tax_excluded = '238.09', date_upd = NOW() WHERE id_document = '90219' 02/02/2024 05:04:43 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 = '90219' 02/02/2024 05:04:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90219' 02/02/2024 05:04: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 ( '90219' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '3' , '3' , '1' , '17.5000' , '14.344262295082' , '22' , '8' , '58.93' ) 02/02/2024 05:04: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 ( '90219' , '18947' , 'CLERGY MISTO 80-20 ML - COM' , '1' , '1' , '1' , '19.2500' , '15.77868852459' , '22' , '0' , '23.49' ) 02/02/2024 05:04: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 ( '90219' , '19607' , 'CLERGY F/F ML - C03' , '2' , '2' , '1' , '18.9000' , '15.491803278689' , '22' , '6' , '43.35' ) 02/02/2024 05:04: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 ( '90219' , '22045' , 'CLERGY REGULAR ML - C 24' , '4' , '4' , '1' , '22.5000' , '18.44262295082' , '22' , '10' , '98.82' ) 02/02/2024 05:04: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 ( '90219' , '19605' , 'CLERGY SU MISURA - COCOCLER' , '2' , '2' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '65.88' ) 02/02/2024 05:04:54 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '28', document_date = '2024-01-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670816', address1 = 'VIA G. BATTISTA VICO 73 80010 VILLARICCA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '290.47', price_tax_excluded = '238.09', date_upd = NOW() WHERE id_document = '90219' 02/02/2024 05:04:55 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 = '90219' 02/02/2024 05:04:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90219' 02/02/2024 05:04:55 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 ( '90219' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '3' , '3' , '1' , '17.5000' , '14.344262295082' , '22' , '8' , '58.93' ) 02/02/2024 05:04:55 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 ( '90219' , '18947' , 'CLERGY MISTO 80-20 ML - COM' , '1' , '1' , '1' , '19.2500' , '15.77868852459' , '22' , '0' , '23.49' ) 02/02/2024 05:04:55 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 ( '90219' , '19607' , 'CLERGY F/F ML - C03' , '2' , '2' , '1' , '18.9000' , '15.491803278689' , '22' , '6' , '43.35' ) 02/02/2024 05:04:55 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 ( '90219' , '22045' , 'CLERGY REGULAR ML - C 24' , '4' , '4' , '1' , '22.5000' , '18.44262295082' , '22' , '10' , '98.82' ) 02/02/2024 05:04:55 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 ( '90219' , '19605' , 'CLERGY SU MISURA - COCOCLER' , '2' , '2' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '65.88' ) 02/02/2024 06:03:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '352' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 06:03:40 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' , '352' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.30' , NOW() , NOW() ) 02/02/2024 06:03:40 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 = '90220' 02/02/2024 06:03:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '90220' 02/02/2024 06:03:40 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 ( '90220' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 02/02/2024 06:03:40 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 ( '90220' , '1937' , 'CERETTI DIAM. 40X400 - ART.500 - 4040' , '1' , '-1' , '1' , '4.40' , '3.6065573770492' , '22' , '0' , '4.40' ) 02/02/2024 06:05:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '353' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 06:05:07 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' , '353' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.30' , '18.28' , NOW() , NOW() ) 02/02/2024 06:05: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 = '90221' 02/02/2024 06:05:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '90221' 02/02/2024 06:05: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 ( '90221' , '1937' , 'CERETTI DIAM. 40X400 - ART.500 - 4040' , '1' , '-1' , '1' , '4.3' , '3.5245901639344' , '22' , '0' , '4.30' ) 02/02/2024 06:05: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 ( '90221' , '6809' , 'MOCCOLO 60X165' , '2' , '-2' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '9.00' ) 02/02/2024 06:05: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 ( '90221' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 02/02/2024 06:16:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '4031' AND id_document != '89542' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 02/02/2024 06:16:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4031', document_date = '2023-12-18', 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 = '350.00', price_tax_excluded = '291.07', date_upd = NOW() WHERE id_document = '89542' 02/02/2024 06:16:49 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 = '89542' 02/02/2024 06:16:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89542' 02/02/2024 06:16:49 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 ( '89542' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 02/02/2024 06:16:49 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 ( '89542' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 02/02/2024 06:16:50 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 ( '89542' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 02/02/2024 06:16:50 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 ( '89542' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '30.5' , '25' , '22' , '0' , '30.50' ) 02/02/2024 06:16:50 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 ( '89542' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '60' , '-60' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '90.00' ) 02/02/2024 06:16:50 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 ( '89542' , '12749' , 'DALMATICA - 3512/TP' , '1' , '-1' , '1' , '130.0000' , '106.55737704918' , '22' , '0' , '130.00' ) 02/02/2024 06:16:50 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 ( '89542' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '50' , '-50' , '1' , '1' , '0.81967213114754' , '22' , '0' , '50.00' ) 02/02/2024 06:45:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '354' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 06:45: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' , '354' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 02/02/2024 06:45: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 = '90222' 02/02/2024 06:45:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '90222' 02/02/2024 06:45: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 ( '90222' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/02/2024 06:45: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 ( '90222' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/02/2024 07:23:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '355' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 02/02/2024 07:23: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' , '355' , '2024-02-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 02/02/2024 07:23: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 = '90223' 02/02/2024 07:23:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '90223' 02/02/2024 07:23: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 ( '90223' , '11677' , 'MEDAGLIA MIRACOLOSA - 1311L' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 02/02/2024 07:23: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 ( '90223' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 02/02/2024 07:51:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '264/MTP' AND id_product != '12740' AND ean13 != '' 02/02/2024 07:51:51 pm >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '264/MTP', date_upd = NOW() WHERE id_product = '12740' 02/02/2024 07:51:51 pm >> UPDATE ps_product_lang SET name = 'STOLA DIACONALE MARIANA - 264/MTP', description = '' WHERE id_product = '12740' 02/02/2024 07:51:51 pm >> UPDATE ps_product SET wholesale_price = '30.40', on_sale = '0', price = '69.67213114754098' WHERE id_product = '12740' 02/02/2024 07:51:51 pm >> UPDATE ps_product_shop SET wholesale_price = '30.40', price = '69.67213114754098', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12740' 02/02/2024 07:51:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '12740' 02/02/2024 07:52:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '264/MTP' AND id_product != '12740' AND ean13 != '' 02/02/2024 07:52:11 pm >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '264/MTP', date_upd = NOW() WHERE id_product = '12740' 02/02/2024 07:52:11 pm >> UPDATE ps_product_lang SET name = 'STOLA DIACONALE MARIANA - 264/MTP', description = '' WHERE id_product = '12740' 02/02/2024 07:52:11 pm >> UPDATE ps_product SET wholesale_price = '30.40', on_sale = '0', price = '73.77049180327869' WHERE id_product = '12740' 02/02/2024 07:52:11 pm >> UPDATE ps_product_shop SET wholesale_price = '30.40', price = '73.77049180327869', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12740' 02/02/2024 07:52:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '12740' 02/02/2024 07:52:42 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' , '41' , '2024-02-02' , '' , '0' , '89' , '2729' , 'VIA COLLE DI NAVA, 127D 12060 MAGLIANO ALPI' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '258.88' , '212.20' , NOW() , NOW() ) 02/02/2024 07:52:42 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 = '90224' 02/02/2024 07:52:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '90224' 02/02/2024 07:52:42 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 ( '90224' , '12749' , 'DALMATICA - 3512/TP' , '1' , '1' , '1' , '53.7' , '44.016393442623' , '22' , '0' , '65.5140' ) 02/02/2024 07:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12749' AND id_supplier = '89' 02/02/2024 07:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12749' , '89' , '1' ) 02/02/2024 07:52:42 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 ( '90224' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '1' , '1' , '31' , '25.409836065574' , '22' , '0' , '37.8200' ) 02/02/2024 07:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12742' AND id_supplier = '89' 02/02/2024 07:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12742' , '89' , '1' ) 02/02/2024 07:52:42 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 ( '90224' , '13929' , 'COPRILEGGIO - 317/TP' , '1' , '1' , '1' , '28.3' , '23.196721311475' , '22' , '0' , '34.5260' ) 02/02/2024 07:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13929' AND id_supplier = '89' 02/02/2024 07:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13929' , '89' , '1' ) 02/02/2024 07:52:42 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 ( '90224' , '12744' , 'COPRILEGGIO MARIANO - 364/TP' , '1' , '1' , '1' , '30.8' , '25.245901639344' , '22' , '0' , '37.5760' ) 02/02/2024 07:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12744' AND id_supplier = '89' 02/02/2024 07:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12744' , '89' , '1' ) 02/02/2024 07:52:42 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 ( '90224' , '12740' , 'STOLA DIACONALE MARIANA - 264/MTP' , '1' , '1' , '1' , '37.4' , '30.655737704918' , '22' , '0' , '45.6280' ) 02/02/2024 07:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12740' AND id_supplier = '89' 02/02/2024 07:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12740' , '89' , '1' ) 02/02/2024 07:52:42 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 ( '90224' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '10' , '10' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '23.1800' ) 02/02/2024 07:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20537' AND id_supplier = '89' 02/02/2024 07:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20537' , '89' , '1' )