26/08/2025 08:37:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2721' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 08:37:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2721' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '197.40' , '161.80' , NOW() , NOW() ) 26/08/2025 08:37:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98435' 26/08/2025 08:37:55 am >> DELETE FROM ps_document_detail WHERE id_document = '98435' 26/08/2025 08:37:56 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 ( '98435' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 26/08/2025 08:37:56 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 ( '98435' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/08/2025 08:37:56 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 ( '98435' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 26/08/2025 09:03:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2722' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 09:03:34 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' , '2722' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '16.50' , NOW() , NOW() ) 26/08/2025 09:03: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 = '98436' 26/08/2025 09:03:34 am >> DELETE FROM ps_document_detail WHERE id_document = '98436' 26/08/2025 09:03: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 ( '98436' , '16294' , 'ALBUM DEL MIO BATTESIMO CELESTE' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 26/08/2025 09:03: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 ( '98436' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.2' , '3.2' , '0' , '0' , '3.20' ) 26/08/2025 09:18:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2476' AND id_document != '98128' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-17') 26/08/2025 09:18:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2476', document_date = '2025-07-17', 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 = '42.00', price_tax_excluded = '37.13', date_upd = NOW() WHERE id_document = '98128' 26/08/2025 09:18:52 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 = '98128' 26/08/2025 09:18:52 am >> DELETE FROM ps_document_detail WHERE id_document = '98128' 26/08/2025 09:18:52 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 ( '98128' , '8147' , 'POLO BASIC' , '1' , '-1' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '27.00' ) 26/08/2025 09:18:52 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 ( '98128' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '0' , '15.00' ) 26/08/2025 09:19:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2566' AND id_document != '98241' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-25') 26/08/2025 09:19:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2566', document_date = '2025-07-25', 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 = '151.90', price_tax_excluded = '128.82', date_upd = NOW() WHERE id_document = '98241' 26/08/2025 09:19:09 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 = '98241' 26/08/2025 09:19:09 am >> DELETE FROM ps_document_detail WHERE id_document = '98241' 26/08/2025 09:19:09 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 ( '98241' , '23168' , 'CAMICE IN MICROFIBRA COCOLLE - 434TPMA' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 26/08/2025 09:19:09 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 ( '98241' , '20644' , 'STOLA - PST022' , '2' , '-2' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '58.00' ) 26/08/2025 09:19:09 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 ( '98241' , '23767' , 'PROMESSE DEL SACRO CUORE A CARATTERI GRANDI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 26/08/2025 09:19:09 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 ( '98241' , '22951' , 'DA CUORE A CUORE - H. NOUWEN' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 26/08/2025 09:19:09 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 ( '98241' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '4.9' , '4.9' , '0' , '0' , '4.90' ) 26/08/2025 09:28:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2723' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 09:28:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2723' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.90' , '55.66' , NOW() , NOW() ) 26/08/2025 09:28:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98437' 26/08/2025 09:28:03 am >> DELETE FROM ps_document_detail WHERE id_document = '98437' 26/08/2025 09:28:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98437' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15.9' , '13.032786885246' , '22' , '0' , '15.90' ) 26/08/2025 09:28:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98437' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 26/08/2025 09:28:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98437' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/08/2025 09:28:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98437' , '14086' , 'CAMICIA PER TALARE 44 - MISTO' , '1' , '-1' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '39.00' ) 26/08/2025 09:38:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2724' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 09:38: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' , '2724' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '106.00' , '86.89' , NOW() , NOW() ) 26/08/2025 09:38: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 = '98438' 26/08/2025 09:38:50 am >> DELETE FROM ps_document_detail WHERE id_document = '98438' 26/08/2025 09:38: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 ( '98438' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 26/08/2025 09:38: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 ( '98438' , '2177' , 'CLERGY BASIC - MM - B&P' , '2' , '-2' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '70.00' ) 26/08/2025 09:48:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2725' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 09:48:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2725' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '221.60' , '195.83' , NOW() , NOW() ) 26/08/2025 09:48: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 = '98439' 26/08/2025 09:48:26 am >> DELETE FROM ps_document_detail WHERE id_document = '98439' 26/08/2025 09:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '5' , '19.00' ) 26/08/2025 09:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '6' , '-6' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '9.00' ) 26/08/2025 09:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '6' , '-6' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '6.60' ) 26/08/2025 09:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 26/08/2025 09:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 26/08/2025 09:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 26/08/2025 09:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '10' , '-10' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '45.00' ) 26/08/2025 09:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 26/08/2025 09:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 26/08/2025 09:48:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2726' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 09:48:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2726' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.20' , '3.20' , NOW() , NOW() ) 26/08/2025 09:48:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98440' 26/08/2025 09:48:46 am >> DELETE FROM ps_document_detail WHERE id_document = '98440' 26/08/2025 09:48:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98440' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.04' , '0.04' , '0' , '0' , '3.20' ) 26/08/2025 10:09:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2727' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 10:09:02 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' , '2727' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '123.00' , '108.80' , NOW() , NOW() ) 26/08/2025 10:09:02 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 = '98441' 26/08/2025 10:09:02 am >> DELETE FROM ps_document_detail WHERE id_document = '98441' 26/08/2025 10:09:02 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 ( '98441' , '23608' , 'QUADRO DECORATO 33X33 - PR-R' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 26/08/2025 10:09:02 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 ( '98441' , '22412' , 'SACRA BIBBIA - 8602' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 26/08/2025 10:09:02 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 ( '98441' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 26/08/2025 10:09:02 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 ( '98441' , '10475' , 'TEALIGHTS X 50 ' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 26/08/2025 10:11:50 am >> SELECT document_num FROM ps_document WHERE document_num = '110/A' AND id_document != '98409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-08') 26/08/2025 10:11:50 am >> UPDATE ps_document SET id_document_type = '24', document_num = '110/A', document_date = '2025-08-08', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = 'MATERIALE NOVIZI', 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 = '1062.00', price_tax_excluded = '987.34', date_upd = NOW() WHERE id_document = '98409' 26/08/2025 10:11: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 = '98409' 26/08/2025 10:11:50 am >> DELETE FROM ps_document_detail WHERE id_document = '98409' 26/08/2025 10:11: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 ( '98409' , '0' , 'SOTTOTALARE' , '6' , '-6' , '0' , '39.0000' , '39' , '0' , '0' , '234.00' ) 26/08/2025 10:11: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 ( '98409' , '0' , 'FASCIA PER TALARE' , '4' , '-4' , '0' , '90.0000' , '90' , '0' , '0' , '360.00' ) 26/08/2025 10:11: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 ( '98409' , '0' , 'POLO' , '1' , '-1' , '0' , '40.0000' , '40' , '0' , '0' , '40.00' ) 26/08/2025 10:11: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 ( '98409' , '0' , 'COLLETTO' , '4' , '-4' , '0' , '3.5000' , '3.5' , '0' , '0' , '14.00' ) 26/08/2025 10:11: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 ( '98409' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '4' , '-4' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '12.00' ) 26/08/2025 10:11: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 ( '98409' , '0' , 'PETTINA' , '4' , '-4' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '52.00' ) 26/08/2025 10:11: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 ( '98409' , '17408' , 'CAMICE MISTO COT. 70/001035' , '2' , '-2' , '1' , '175.00' , '143.44262295082' , '22' , '0' , '350.00' ) 26/08/2025 10:12:49 am >> DELETE FROM ps_document WHERE id_document = '98385' 26/08/2025 10:12:49 am >> DELETE FROM ps_document_detail WHERE id_document = '98385' 26/08/2025 10:13:58 am >> SELECT document_num FROM ps_document WHERE document_num = '89/A' AND id_document != '97713' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-14') 26/08/2025 10:13:58 am >> UPDATE ps_document SET id_document_type = '24', document_num = '89/A', document_date = '2025-06-14', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '+++ GIA\' SCALATI', 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 = '338.50', price_tax_excluded = '286.24', date_upd = NOW() WHERE id_document = '97713' 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97713' 26/08/2025 10:13:58 am >> DELETE FROM ps_document_detail WHERE id_document = '97713' 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '1077' , 'BERNADETTE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '0' , '15.00' ) 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '33.0000' , '27.049180327869' , '22' , '0' , '33.00' ) 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '20547' , 'MEDAGLIA LOURDES - OV22/L' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 26/08/2025 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '6' , '-6' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '10.80' ) 26/08/2025 10:13:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '2168' , 'CLERGY BASIC - ML - B&P' , '4' , '-4' , '1' , '36.0000' , '29.508196721311' , '22' , '0' , '144.00' ) 26/08/2025 10:13:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 26/08/2025 10:13:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '19906' , 'FASCIA PER TALARE' , '1' , '-1' , '1' , '90.0000' , '73.770491803279' , '22' , '0' , '90.00' ) 26/08/2025 10:13:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97713' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25 +++' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '0' , '10.00' ) 26/08/2025 10:21:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2728' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 10:21:05 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' , '2728' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 26/08/2025 10:21: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 = '98442' 26/08/2025 10:21:05 am >> DELETE FROM ps_document_detail WHERE id_document = '98442' 26/08/2025 10:21:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98442' , '20487' , 'STELLARIO PLEX CM 14 - ART. 70' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 26/08/2025 11:19:59 am >> SELECT document_num FROM ps_document WHERE document_num = '99/A' AND id_document != '98079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-14') 26/08/2025 11:19:59 am >> UPDATE ps_document SET id_document_type = '24', document_num = '99/A', document_date = '2025-07-14', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '366.90', price_tax_excluded = '308.37', date_upd = NOW() WHERE id_document = '98079' 26/08/2025 11:19:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98079' 26/08/2025 11:19:59 am >> DELETE FROM ps_document_detail WHERE id_document = '98079' 26/08/2025 11:19:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98079' , '8147' , 'POLO BASIC' , '4' , '-4' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '108.00' ) 26/08/2025 11:19:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98079' , '23864' , 'MARIOLOGIA BIBBLICA - S. MANELLI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 26/08/2025 11:20: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 ( '98079' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 26/08/2025 11:20: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 ( '98079' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '3' , '-3' , '4' , '2.80' , '2.8' , '0' , '0' , '8.40' ) 26/08/2025 11:20: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 ( '98079' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 26/08/2025 11:20: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 ( '98079' , '22970' , 'RELIQUIARIO H 25CM' , '1' , '-1' , '1' , '189.00' , '154.91803278689' , '22' , '0' , '189.00' ) 26/08/2025 11:20: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 ( '98079' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '26.70' ) 26/08/2025 11:25:42 am >> SELECT document_num FROM ps_document WHERE document_num = '99/A' AND id_document != '98079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-14') 26/08/2025 11:25:42 am >> UPDATE ps_document SET id_document_type = '24', document_num = '99/A', document_date = '2025-07-14', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '363.90', price_tax_excluded = '305.92', date_upd = NOW() WHERE id_document = '98079' 26/08/2025 11:25: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 = '98079' 26/08/2025 11:25:42 am >> DELETE FROM ps_document_detail WHERE id_document = '98079' 26/08/2025 11:25: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 ( '98079' , '8147' , 'POLO BASIC' , '4' , '-4' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '108.00' ) 26/08/2025 11:25: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 ( '98079' , '23864' , 'MARIOLOGIA BIBBLICA - S. MANELLI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 26/08/2025 11:25: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 ( '98079' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 26/08/2025 11:25: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 ( '98079' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '3' , '-3' , '4' , '2.8000' , '2.8' , '0' , '0' , '8.40' ) 26/08/2025 11:25: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 ( '98079' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 26/08/2025 11:25: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 ( '98079' , '22970' , 'RELIQUIARIO H 25CM' , '1' , '-1' , '1' , '189.0000' , '154.91803278689' , '22' , '0' , '189.00' ) 26/08/2025 11:25: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 ( '98079' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '23.70' ) 26/08/2025 11:26:04 am >> SELECT document_num FROM ps_document WHERE document_num = '99/A' AND id_document != '98079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-14') 26/08/2025 11:26:04 am >> UPDATE ps_document SET id_document_type = '24', document_num = '99/A', document_date = '2025-07-14', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '382.90', price_tax_excluded = '324.92', date_upd = NOW() WHERE id_document = '98079' 26/08/2025 11:26: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 = '98079' 26/08/2025 11:26:04 am >> DELETE FROM ps_document_detail WHERE id_document = '98079' 26/08/2025 11:26: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 ( '98079' , '8147' , 'POLO BASIC' , '4' , '-4' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '108.00' ) 26/08/2025 11:26: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 ( '98079' , '23864' , 'MARIOLOGIA BIBBLICA - S. MANELLI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 26/08/2025 11:26: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 ( '98079' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 26/08/2025 11:26: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 ( '98079' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '3' , '-3' , '4' , '2.8000' , '2.8' , '0' , '0' , '8.40' ) 26/08/2025 11:26: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 ( '98079' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 26/08/2025 11:26: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 ( '98079' , '22970' , 'RELIQUIARIO H 25CM' , '1' , '-1' , '1' , '189.0000' , '154.91803278689' , '22' , '0' , '189.00' ) 26/08/2025 11:26: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 ( '98079' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '23.70' ) 26/08/2025 11:26: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 ( '98079' , '22865' , 'CATECHISMO MAGGIORE - SAN PIO X' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 26/08/2025 11:28:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2725' AND id_document != '98439' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 11:28:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2725', document_date = '2025-08-26', 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 = '221.60', price_tax_excluded = '195.83', date_upd = NOW() WHERE id_document = '98439' 26/08/2025 11:28: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 = '98439' 26/08/2025 11:28:34 am >> DELETE FROM ps_document_detail WHERE id_document = '98439' 26/08/2025 11:28: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 ( '98439' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '5' , '19.00' ) 26/08/2025 11:28: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 ( '98439' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '6' , '-6' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '9.00' ) 26/08/2025 11:28: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 ( '98439' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '6' , '-6' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '6.60' ) 26/08/2025 11:28: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 ( '98439' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 26/08/2025 11:28:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 26/08/2025 11:28:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 26/08/2025 11:28:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '10' , '-10' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '45.00' ) 26/08/2025 11:28:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 26/08/2025 11:28:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98439' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 26/08/2025 11:39:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2729' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 11:39:29 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' , '2729' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 26/08/2025 11:39: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 = '98443' 26/08/2025 11:39:29 am >> DELETE FROM ps_document_detail WHERE id_document = '98443' 26/08/2025 11:39: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 ( '98443' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 26/08/2025 12:05:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2730' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 12:05:15 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' , '2730' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.90' , '16.91' , NOW() , NOW() ) 26/08/2025 12:05:15 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 = '98444' 26/08/2025 12:05:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '98444' 26/08/2025 12:05:15 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 ( '98444' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 26/08/2025 12:05:15 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 ( '98444' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 26/08/2025 12:05:15 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 ( '98444' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 26/08/2025 12:05:15 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 ( '98444' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 26/08/2025 12:09:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810821466' AND id_product != '22331' AND ean13 != '' 26/08/2025 12:09:08 pm >> UPDATE ps_product SET id_supplier = '109', reference = '10/1', ean13 = '9788810821466', date_upd = NOW() WHERE id_product = '22331' 26/08/2025 12:09:08 pm >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME - BOTTONE', description = '' WHERE id_product = '22331' 26/08/2025 12:09:08 pm >> UPDATE ps_product SET wholesale_price = '19.86', on_sale = '0', price = '42' WHERE id_product = '22331' 26/08/2025 12:09:08 pm >> UPDATE ps_product_shop SET wholesale_price = '19.86', price = '42', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22331' 26/08/2025 12:09:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '22331' 26/08/2025 12:15:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2731' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 12:15:14 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' , '2731' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '50.00' , NOW() , NOW() ) 26/08/2025 12:15:14 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 = '98445' 26/08/2025 12:15:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '98445' 26/08/2025 12:15:14 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 ( '98445' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 26/08/2025 12:15:14 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 ( '98445' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 26/08/2025 12:39:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2732' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-26') 26/08/2025 12:39:58 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' , '2732' , '2025-08-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.90' , '47.34' , NOW() , NOW() ) 26/08/2025 12:39:58 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 = '98446' 26/08/2025 12:39:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '98446' 26/08/2025 12:39:58 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 ( '98446' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 26/08/2025 12:39:58 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 ( '98446' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 26/08/2025 12:39:58 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 ( '98446' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '23.70' ) 26/08/2025 12:39:58 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 ( '98446' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' )