03/06/2025 09:45:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1944' AND id_document != '97494' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-31') 03/06/2025 09:45:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1944', document_date = '2025-05-31', 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 = '20.70', price_tax_excluded = '16.97', date_upd = NOW() WHERE id_document = '97494' 03/06/2025 09:45: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 = '97494' 03/06/2025 09:45:14 am >> DELETE FROM ps_document_detail WHERE id_document = '97494' 03/06/2025 09:45: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 ( '97494' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15.8' , '12.950819672131' , '22' , '0' , '15.80' ) 03/06/2025 09:45: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 ( '97494' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 03/06/2025 09:48:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831540315' AND id_product != '4933' AND ean13 != '' 03/06/2025 09:48:00 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/3', ean13 = '9788831540315', date_upd = NOW() WHERE id_product = '4933' 03/06/2025 09:48:00 am >> UPDATE ps_product_lang SET name = 'ILDEGARDA DI BINGEN', description = '' WHERE id_product = '4933' 03/06/2025 09:48:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.0000' WHERE id_product = '4933' 03/06/2025 09:48:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4933' 03/06/2025 09:48:00 am >> DELETE FROM ps_specific_price WHERE id_product = '4933' 03/06/2025 10:04:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1949' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 10:04:17 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' , '1949' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.10' , '10.74' , NOW() , NOW() ) 03/06/2025 10:04:17 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 = '97500' 03/06/2025 10:04:17 am >> DELETE FROM ps_document_detail WHERE id_document = '97500' 03/06/2025 10:04:17 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 ( '97500' , '13335' , 'COLOMBA CON LACCIO' , '5' , '-5' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '8.00' ) 03/06/2025 10:04:17 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 ( '97500' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '5' , '-5' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '1.50' ) 03/06/2025 10:04:17 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 ( '97500' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 03/06/2025 10:56:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1950' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 10:56:12 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' , '1950' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.50' , '18.50' , NOW() , NOW() ) 03/06/2025 10:56:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97501' 03/06/2025 10:56:12 am >> DELETE FROM ps_document_detail WHERE id_document = '97501' 03/06/2025 10:56:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97501' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 03/06/2025 11:07:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1951' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 11:07:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1951' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 03/06/2025 11:07: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 = '97502' 03/06/2025 11:07:14 am >> DELETE FROM ps_document_detail WHERE id_document = '97502' 03/06/2025 11:07: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 ( '97502' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 03/06/2025 11:07: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 ( '97502' , '19857' , 'CINGOLO COL/ORO - CING 21' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 03/06/2025 11:07:52 am >> SELECT document_num FROM ps_document WHERE document_num = '84/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 11:07:52 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' , '84/A' , '2025-06-03' , 'A' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '460.00' , '377.05' , NOW() , NOW() ) 03/06/2025 11:07: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 = '97503' 03/06/2025 11:07:52 am >> DELETE FROM ps_document_detail WHERE id_document = '97503' 03/06/2025 11:07: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 ( '97503' , '22215' , 'CALICE MALTA - 341' , '1' , '-1' , '1' , '280.00' , '229.50819672131' , '22' , '0' , '280.00' ) 03/06/2025 11:07:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '22215' AND id_supplier = '7' 03/06/2025 11:07:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22215' , '7' , '1' ) 03/06/2025 11:07: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 ( '97503' , '22216' , 'CALICE CLASSICO - 885' , '1' , '-1' , '1' , '180.00' , '147.54098360656' , '22' , '0' , '180.00' ) 03/06/2025 11:07:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '22216' AND id_supplier = '7' 03/06/2025 11:07:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22216' , '7' , '1' ) 03/06/2025 11:08:18 am >> SELECT document_num FROM ps_document WHERE document_num = '84/A' AND id_document != '97503' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 11:08:18 am >> UPDATE ps_document SET id_document_type = '24', document_num = '84/A', document_date = '2025-06-03', document_letter = 'A', id_customer = '177', id_supplier = '0', id_address = '4670959', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', 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 = '460.00', price_tax_excluded = '377.05', date_upd = NOW() WHERE id_document = '97503' 03/06/2025 11:08: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 = '97503' 03/06/2025 11:08:18 am >> DELETE FROM ps_document_detail WHERE id_document = '97503' 03/06/2025 11:08: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 ( '97503' , '22215' , 'CALICE MALTA - 341' , '1' , '-1' , '1' , '280.0000' , '229.50819672131' , '22' , '0' , '280.00' ) 03/06/2025 11:08: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 ( '97503' , '22216' , 'CALICE CLASSICO - 885' , '1' , '-1' , '1' , '180.0000' , '147.54098360656' , '22' , '0' , '180.00' ) 03/06/2025 11:18:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1747' AND id_document != '97276' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-19') 03/06/2025 11:18:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1747', document_date = '2025-05-19', 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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '97276' 03/06/2025 11:18: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 = '97276' 03/06/2025 11:18:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97276' 03/06/2025 11:18: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 ( '97276' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 03/06/2025 11:18: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 ( '97276' , '23608' , 'QUADRO DECORATO 33X33 - PR-R' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 03/06/2025 11:23:10 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' , '25V602858' , '2025-05-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '20.28' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '757.06' , '755.04' , NOW() , NOW() ) 03/06/2025 11:23:10 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 = '97504' 03/06/2025 11:23:10 am >> DELETE FROM ps_document_detail WHERE id_document = '97504' 03/06/2025 11:23:10 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 ( '97504' , '23737' , 'CANTI LATINI DELLA CHIESA' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 03/06/2025 11:23:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '23737' AND id_supplier = '7' 03/06/2025 11:23:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23737' , '7' , '1' ) 03/06/2025 11:23:10 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 ( '97504' , '23738' , 'VITA ETERNA - R. PASOLINI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 03/06/2025 11:23:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '23738' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23738' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23739' , 'GIUSEPPE, IL FRATELLO RITROVATO - C. DI CAVE' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23739' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23739' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23732' , 'PALESTRINA JUBILAEUM - A MONTEPAONE' , '1' , '0' , '1' , '12.7000' , '10.4098' , '22' , '30' , '10.85' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23732' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23732' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23736' , 'GIARDINO DEL CIELO - M. SORANZO' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '33' , '16.75' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23736' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23736' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23741' , 'DELLA STESSA SOSTANZA DEL PADRE - A. PERATONER' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23741' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23741' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23734' , 'PIU BELLO DEVE ANCORA VENIRE - A. COMASTRI' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '30' , '4.20' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23734' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23734' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23733' , 'PREGHIERE DI OGNI GIORNO' , '3' , '0' , '4' , '2.0000' , '2' , '0' , '33' , '4.02' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23733' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23733' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23735' , 'E ORA DI PREGARE - F. TARTAGLIA' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23735' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23735' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23742' , 'MAGNIFICAT' , '1' , '0' , '4' , '19.0000' , '19' , '0' , '30' , '13.30' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23742' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23742' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23740' , 'SIGNORE CI TIENE PER MANO - BENEDETTO XVI' , '1' , '0' , '4' , '23.0000' , '23' , '0' , '30' , '16.10' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23740' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23740' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23749' , 'EUCARISTIA CUORE DELLA CHIESA - PAPA FRANCESCO' , '2' , '0' , '4' , '8.9000' , '8.9' , '0' , '33' , '11.93' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23749' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23749' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23750' , 'SPIRITO SANTO - PAPA FRANCESCO' , '2' , '0' , '4' , '9.9000' , '9.9' , '0' , '33' , '13.27' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23750' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23750' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '23752' AND id_supplier = '7' 03/06/2025 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23752' , '7' , '1' ) 03/06/2025 11:23:11 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 ( '97504' , '7442' , 'PANE QUOTIDIANO' , '1' , '0' , '4' , '4.5000' , '4.5' , '0' , '30' , '3.15' ) 03/06/2025 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '7442' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7442' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '9017' , 'RITO DELLA PENITENZA' , '1' , '0' , '4' , '10.3300' , '10.33' , '0' , '15' , '8.78' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '9017' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9017' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21173' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21173' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '18057' , 'ROSARIO CON PAPA FRANCESCO' , '1' , '0' , '4' , '4.9000' , '4.9' , '0' , '33' , '3.28' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '18057' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18057' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '1' , '0' , '4' , '3.9000' , '3.9' , '0' , '30' , '2.73' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '22813' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22813' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '24' , '0' , '4' , '1.9000' , '1.9' , '0' , '35' , '29.64' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '11644' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11644' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '2' , '0' , '4' , '1.9000' , '1.9' , '0' , '100' , '0.00' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '11644' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11644' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '2' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '16.80' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '20804' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20804' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '1116' , 'BIBBIA DEI BAMBINI' , '1' , '0' , '4' , '12.9000' , '12.9' , '0' , '30' , '9.03' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '1116' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1116' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '23751' , 'GESU VERAMENTE - L.M. EPICOCO' , '5' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '53.60' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '23751' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23751' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '23765' , 'FUOCO DENTRO - A. GRUN' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '23765' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23765' , '7' , '1' ) 03/06/2025 11:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97504' , '23768' , 'ANCHIO CREDO! - M. MALACRIDA' , '1' , '0' , '4' , '8.5000' , '8.5' , '0' , '30' , '5.95' ) 03/06/2025 11:23:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '23768' AND id_supplier = '7' 03/06/2025 11:23:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23768' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23769' , 'LOURDES - R. LAURENTIN' , '1' , '0' , '4' , '28.0000' , '28' , '0' , '33' , '18.76' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23769' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23769' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23767' , 'PROMESSE DEL SACRO CUORE A CARATTERI GRANDI' , '2' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '16.80' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23767' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23767' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23772' , 'BREVE STORIA DEI CONCILI - A. GUASCO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23772' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23772' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23775' , 'FIGLIO DELLUOMO BOCCA DI DIO - A. CANOPI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23775' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23775' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23773' , 'BRIGIDA DI SVEZIA - M. MASCIARELLI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23773' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23773' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23774' , 'PREGHIERA NELLA BIBBIA - G. RAVASI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23774' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23774' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23766' , 'MIA VITA PER LA CHIESA E LE TEOLOGIA - W. KASPER' , '1' , '0' , '4' , '19.0000' , '19' , '0' , '30' , '13.30' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23766' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23766' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23771' , 'INSIEME NELLA MESSA - AGO 25' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23771' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23771' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23770' , 'PAROLA E PREGHIERA - AGO 25' , '2' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '3.89' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23770' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23770' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '2' , '0' , '4' , '110.0000' , '110' , '0' , '15' , '187.00' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '4488' , 'GESÙ NEL CUORE - LA MIA PRIMA COMUNIONE' , '12' , '0' , '4' , '1.9000' , '1.9' , '0' , '35' , '14.82' ) 03/06/2025 11:23:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '4488' AND id_supplier = '7' 03/06/2025 11:23:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4488' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '4488' , 'GESÙ NEL CUORE - LA MIA PRIMA COMUNIONE' , '1' , '0' , '4' , '1.9000' , '1.9' , '0' , '100' , '0.00' ) 03/06/2025 11:23:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '4488' AND id_supplier = '7' 03/06/2025 11:23:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4488' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23764' , 'EUCARISTIA - V. MOLINARO' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 03/06/2025 11:23:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '23764' AND id_supplier = '7' 03/06/2025 11:23:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23764' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23783' , 'LEONE XIV - A. PREZIOSI' , '12' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '120.60' ) 03/06/2025 11:23:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '23783' AND id_supplier = '7' 03/06/2025 11:23:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23783' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '100' , '0.00' ) 03/06/2025 11:23:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '23783' AND id_supplier = '7' 03/06/2025 11:23:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23783' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '23784' , 'SANTA FAUSTINA KOWALSKA' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 03/06/2025 11:23:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '23784' AND id_supplier = '7' 03/06/2025 11:23:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23784' , '7' , '1' ) 03/06/2025 11:23: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 ( '97504' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.3050' ) 03/06/2025 11:23:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 03/06/2025 11:23:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 03/06/2025 11:30:17 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' , '25V602857' , '2025-05-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.50' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.63' , '49.63' , NOW() , NOW() ) 03/06/2025 11:30:17 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 = '97505' 03/06/2025 11:30:17 am >> DELETE FROM ps_document_detail WHERE id_document = '97505' 03/06/2025 11:30:17 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 ( '97505' , '9017' , 'RITO DELLA PENITENZA' , '1' , '0' , '4' , '10.3300' , '10.33' , '0' , '15' , '8.78' ) 03/06/2025 11:30:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '9017' AND id_supplier = '7' 03/06/2025 11:30:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9017' , '7' , '1' ) 03/06/2025 11:30:17 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 ( '97505' , '3525' , 'DIO UNO E TRINO - P. CODA' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '33' , '13.40' ) 03/06/2025 11:30:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '3525' AND id_supplier = '7' 03/06/2025 11:30:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3525' , '7' , '1' ) 03/06/2025 11:30: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 ( '97505' , '23636' , 'GESU CRISTO FIGLIO DI DIO SALVATORE' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '30' , '7.00' ) 03/06/2025 11:30:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '23636' AND id_supplier = '7' 03/06/2025 11:30:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23636' , '7' , '1' ) 03/06/2025 11:30: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 ( '97505' , '23492' , 'AMEN - GIU 25' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '5.23' ) 03/06/2025 11:30:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '23492' AND id_supplier = '7' 03/06/2025 11:30:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23492' , '7' , '1' ) 03/06/2025 11:30: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 ( '97505' , '4933' , 'ILDEGARDA DI BINGEN' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 03/06/2025 11:30:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '4933' AND id_supplier = '7' 03/06/2025 11:30:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4933' , '7' , '1' ) 03/06/2025 11:48:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1952' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 11:48:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1952' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '228.40' , '204.38' , NOW() , NOW() ) 03/06/2025 11:48:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97506' 03/06/2025 11:48:35 am >> DELETE FROM ps_document_detail WHERE id_document = '97506' 03/06/2025 11:48: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 ( '97506' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 03/06/2025 11:48: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 ( '97506' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 03/06/2025 11:48: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 ( '97506' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 03/06/2025 11:48: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 ( '97506' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '25' , '-25' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '87.50' ) 03/06/2025 11:48: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 ( '97506' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '13.50' ) 03/06/2025 11:55:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1953' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 11:55:43 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' , '1953' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.83' , '31.83' , NOW() , NOW() ) 03/06/2025 11:55:43 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 = '97507' 03/06/2025 11:55:43 am >> DELETE FROM ps_document_detail WHERE id_document = '97507' 03/06/2025 11:55:43 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 ( '97507' , '23332' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 03/06/2025 11:55:43 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 ( '97507' , '16023' , 'SANTO VIAGGIO CON MARIA - 8966' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/06/2025 11:55:43 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 ( '97507' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 03/06/2025 11:55:43 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 ( '97507' , '8562' , 'PROMESSE DEL SACRO CUORE DI GESÙ' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 03/06/2025 12:12:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1954' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 12:12:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1954' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '86.60' , '76.36' , NOW() , NOW() ) 03/06/2025 12:12:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97508' 03/06/2025 12:12:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '97508' 03/06/2025 12:12:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97508' , '9241' , 'SACC. 100 PZ MICCIA PER ACCENDERE STREGA ' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/06/2025 12:12:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97508' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 03/06/2025 12:12:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97508' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 03/06/2025 12:12:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97508' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '44.00' , '36.065573770492' , '22' , '0' , '44.00' ) 03/06/2025 12:12: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 ( '97508' , '22809' , 'O LUCE BEATISSIMA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 03/06/2025 12:12: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 ( '97508' , '23521' , 'VERO BENE COMUNE - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 03/06/2025 12:22:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '85/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 12:22:45 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' , '85/A' , '2025-06-03' , 'A' , '3224' , '0' , '4669561' , 'VIALE CAPPUCCINI 71018 VICO DEL GARGANO' , '' , 'p. giuseppe castronuovo' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.00' , '40.12' , NOW() , NOW() ) 03/06/2025 12:22:45 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 = '97509' 03/06/2025 12:22:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '97509' 03/06/2025 12:22:45 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 ( '97509' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 03/06/2025 12:22:45 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 ( '97509' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 03/06/2025 12:23:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '85/A' AND id_document != '97509' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 12:23:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '85/A', document_date = '2025-06-03', document_letter = 'A', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIALE CAPPUCCINI 71018 VICO DEL GARGANO', address2 = '', note = 'p. giuseppe castronuovo', 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 = '41.00', price_tax_excluded = '40.12', date_upd = NOW() WHERE id_document = '97509' 03/06/2025 12:23:11 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 = '97509' 03/06/2025 12:23:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '97509' 03/06/2025 12:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97509' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '5' , '36.10' ) 03/06/2025 12:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97509' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 03/06/2025 12:24:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1955' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 12:24:38 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' , '1955' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 03/06/2025 12:24:38 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 = '97510' 03/06/2025 12:24:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '97510' 03/06/2025 12:24:38 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 ( '97510' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '0' , '38.00' ) 03/06/2025 12:30:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1956' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 12:30:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1956' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.50' , '26.64' , NOW() , NOW() ) 03/06/2025 12:30:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97511' 03/06/2025 12:30:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '97511' 03/06/2025 12:30: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 ( '97511' , '18895' , 'BRACCIALE DECINA COLORATA - B1757N' , '16' , '-16' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '32.00' ) 03/06/2025 12:30: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 ( '97511' , '21594' , 'CARTONCINO 16X23' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 03/06/2025 12:40:33 pm >> DELETE FROM ps_document WHERE id_document = '97509' 03/06/2025 12:40:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '97509' 03/06/2025 12:41:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1928' AND id_document != '97477' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-30') 03/06/2025 12:41:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1928', document_date = '2025-05-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 = '88.00', price_tax_excluded = '72.13', date_upd = NOW() WHERE id_document = '97477' 03/06/2025 12:41: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 = '97477' 03/06/2025 12:41:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '97477' 03/06/2025 12:41: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 ( '97477' , '17533' , 'CINGOLO ORO/COL - CING06' , '3' , '-3' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '57.00' ) 03/06/2025 12:41: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 ( '97477' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26.1' , '21.393442622951' , '22' , '0' , '26.10' ) 03/06/2025 12:41: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 ( '97477' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 03/06/2025 01:11:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1957' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 01:11:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1957' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.10' , '21.10' , NOW() , NOW() ) 03/06/2025 01:11:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97512' 03/06/2025 01:11:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '97512' 03/06/2025 01:11:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.3' , '2.3' , '0' , '0' , '2.30' ) 03/06/2025 01:11:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/06/2025 01:11:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 03/06/2025 01:11:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.2' , '3.2' , '0' , '0' , '3.20' ) 03/06/2025 01:11:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '15602' , 'AMICO GESU ALBUM' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 03/06/2025 01:11:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '475' , 'AMICO GESÙ - FIGURINE' , '12' , '-12' , '4' , '0.50' , '0.5' , '0' , '0' , '6.00' ) 03/06/2025 03:07:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1905' AND id_document != '97453' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 03/06/2025 03:07:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1905', document_date = '2025-05-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '61.90', price_tax_excluded = '51.52', date_upd = NOW() WHERE id_document = '97453' 03/06/2025 03:07:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97453' 03/06/2025 03:07:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '97453' 03/06/2025 03:07:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97453' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 03/06/2025 03:07:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97453' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 03/06/2025 03:07:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97453' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '3.5' , '3.3653846153846' , '4' , '0' , '3.50' ) 03/06/2025 03:07:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1815' AND id_document != '97353' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-23') 03/06/2025 03:07:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1815', document_date = '2025-05-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 = '230.00', price_tax_excluded = '201.79', date_upd = NOW() WHERE id_document = '97353' 03/06/2025 03:07:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97353' 03/06/2025 03:07:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '97353' 03/06/2025 03:07:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97353' , '21899' , 'SACRA BIBBIA cei/uelci ' , '2' , '-2' , '4' , '17.5000' , '17.5' , '0' , '' , '35.00' ) 03/06/2025 03:07:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97353' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 03/06/2025 03:07:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97353' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 03/06/2025 03:07:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97353' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '133.0000' , '109.01639344262' , '22' , '0' , '133.00' ) 03/06/2025 03:07:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97353' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '10' , '-10' , '3' , '3.5' , '3.3653846153846' , '4' , '0' , '35.00' ) 03/06/2025 03:08:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1893' AND id_document != '97438' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 03/06/2025 03:08:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1893', document_date = '2025-05-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 = '121.50', price_tax_excluded = '102.07', date_upd = NOW() WHERE id_document = '97438' 03/06/2025 03:08:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97438' 03/06/2025 03:08:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '97438' 03/06/2025 03:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97438' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '18' , '-18' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '9.00' ) 03/06/2025 03:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97438' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 03/06/2025 03:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97438' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 03/06/2025 03:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97438' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '5' , '-5' , '3' , '3.5' , '3.3653846153846' , '4' , '0' , '17.50' ) 03/06/2025 03:14:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '297' AND id_document != '27140' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2021-01-29') 03/06/2025 03:14:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '297', document_date = '2021-01-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 = '133.50', price_tax_excluded = '115.89', date_upd = NOW() WHERE id_document = '27140' 03/06/2025 03:14: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 = '27140' 03/06/2025 03:14:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '27140' 03/06/2025 03:14: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 ( '27140' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '1.6' , '1.5384615384615' , '4' , '0' , '16.00' ) 03/06/2025 03:14: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 ( '27140' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '6.00' ) 03/06/2025 03:14: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 ( '27140' , '1622' , 'CANDELE VOTIVE 14X27 KG 10' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '80.00' ) 03/06/2025 03:14: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 ( '27140' , '1706' , 'CARBONCINI BENEDICTUS' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/06/2025 03:14: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 ( '27140' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 03/06/2025 03:14: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 ( '27140' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '1.7500' , '1.75' , '0' , '0' , '3.50' ) 03/06/2025 03:14: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 ( '27140' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '2.8000' , '2.6923076923077' , '4' , '0' , '5.60' ) 03/06/2025 03:14: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 ( '27140' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '1.8000' , '1.7307692307692' , '4' , '0' , '5.40' ) 03/06/2025 03:14: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 ( '27140' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '3.00' ) 03/06/2025 03:14:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '271' AND id_document != '27102' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2021-01-27') 03/06/2025 03:14:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '271', document_date = '2021-01-27', 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 = '99.27', date_upd = NOW() WHERE id_document = '27102' 03/06/2025 03:14: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 = '27102' 03/06/2025 03:14:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '27102' 03/06/2025 03:14: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 ( '27102' , '17455' , 'PAROLA DI OGNI GIORNO 2021' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 03/06/2025 03:14: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 ( '27102' , '17583' , 'FRATELLI TUTTI' , '4' , '-4' , '4' , '2.9000' , '2.9' , '0' , '5' , '11.04' ) 03/06/2025 03:14: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 ( '27102' , '5570' , 'LAUDATO SÌ ' , '3' , '-3' , '4' , '1.9000' , '1.9' , '0' , '5' , '5.43' ) 03/06/2025 03:14: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 ( '27102' , '15580' , 'CHRISTUS VIVIT' , '3' , '-3' , '4' , '2.0000' , '2' , '0' , '5' , '5.70' ) 03/06/2025 03:14: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 ( '27102' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 03/06/2025 03:14: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 ( '27102' , '9217' , 'S. GIUSEPPE - 32 ' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 03/06/2025 03:14: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 ( '27102' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.23' , '2.1442307692308' , '4' , '0' , '2.23' ) 03/06/2025 03:14: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 ( '27102' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '6.00' ) 03/06/2025 03:14: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 ( '27102' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '1.8000' , '1.7307692307692' , '4' , '0' , '3.60' ) 03/06/2025 03:15:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1347' AND id_document != '24694' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2020-07-28') 03/06/2025 03:15:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1347', document_date = '2020-07-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 = '67.40', price_tax_excluded = '67.15', date_upd = NOW() WHERE id_document = '24694' 03/06/2025 03:15:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '24694' 03/06/2025 03:15:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '24694' 03/06/2025 03:15:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '24694' , '17028' , 'SULLA TUA PAROLA - SET/OTT 2020' , '16' , '-16' , '4' , '4.0000' , '4' , '0' , '5' , '60.80' ) 03/06/2025 03:15:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '24694' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.2' , '2.1153846153846' , '4' , '0' , '6.60' ) 03/06/2025 03:17:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1815' AND id_document != '97353' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-23') 03/06/2025 03:17:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1815', document_date = '2025-05-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 = '230.00', price_tax_excluded = '201.79', date_upd = NOW() WHERE id_document = '97353' 03/06/2025 03:17:05 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 = '97353' 03/06/2025 03:17:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '97353' 03/06/2025 03:17:05 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 ( '97353' , '21899' , 'SACRA BIBBIA cei/uelci ' , '2' , '-2' , '4' , '17.5000' , '17.5' , '0' , '' , '35.00' ) 03/06/2025 03:17:05 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 ( '97353' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 03/06/2025 03:17:05 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 ( '97353' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 03/06/2025 03:17:05 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 ( '97353' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '133.0000' , '109.01639344262' , '22' , '0' , '133.00' ) 03/06/2025 03:17:05 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 ( '97353' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 03/06/2025 03:17:05 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 ( '97353' , '16689' , 'OSTIA PAN DI CENA mm80' , '16' , '-16' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '32.00' ) 03/06/2025 03:17:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1893' AND id_document != '97438' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 03/06/2025 03:17:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1893', document_date = '2025-05-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 = '121.50', price_tax_excluded = '102.07', date_upd = NOW() WHERE id_document = '97438' 03/06/2025 03:17:50 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 = '97438' 03/06/2025 03:17:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '97438' 03/06/2025 03:17: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 ( '97438' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '18' , '-18' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '9.00' ) 03/06/2025 03:17: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 ( '97438' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 03/06/2025 03:17: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 ( '97438' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 03/06/2025 03:17: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 ( '97438' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '1.5' , '1.4423076923077' , '4' , '0' , '1.50' ) 03/06/2025 03:17: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 ( '97438' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 03/06/2025 03:18:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1905' AND id_document != '97453' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-29') 03/06/2025 03:18:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1905', document_date = '2025-05-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '61.90', price_tax_excluded = '51.52', date_upd = NOW() WHERE id_document = '97453' 03/06/2025 03:18:19 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 = '97453' 03/06/2025 03:18:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '97453' 03/06/2025 03:18:19 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 ( '97453' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 03/06/2025 03:18:19 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 ( '97453' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 03/06/2025 03:18:19 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 ( '97453' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '1.75' , '1.6826923076923' , '4' , '0' , '3.50' ) 03/06/2025 03:19:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1705' AND id_document != '19821' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2019-06-04') 03/06/2025 03:19:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1705', document_date = '2019-06-04', 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 = '28.80', price_tax_excluded = '27.99', date_upd = NOW() WHERE id_document = '19821' 03/06/2025 03:19: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 = '19821' 03/06/2025 03:19:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '19821' 03/06/2025 03:19:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '19821' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '6' , '-6' , '4' , '1.3000' , '1.3' , '0' , '0' , '7.80' ) 03/06/2025 03:19:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '19821' , '7673' , 'PARTICOLE MM38' , '5' , '-5' , '3' , '2.7000' , '2.5961538461538' , '4' , '0' , '13.50' ) 03/06/2025 03:19:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '19821' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '1.5' , '1.4423076923077' , '4' , '0' , '7.50' ) 03/06/2025 03:19:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1760' AND id_document != '19890' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2019-06-08') 03/06/2025 03:19:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1760', document_date = '2019-06-08', 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 = '6.90', price_tax_excluded = '6.63', date_upd = NOW() WHERE id_document = '19890' 03/06/2025 03:19: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 = '19890' 03/06/2025 03:19:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '19890' 03/06/2025 03:19: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 ( '19890' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '2.7000' , '2.5961538461538' , '4' , '0' , '5.40' ) 03/06/2025 03:19: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 ( '19890' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '1.5' , '1.4423076923077' , '4' , '0' , '1.50' ) 03/06/2025 03:20:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1951' AND id_document != '20114' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2019-06-25') 03/06/2025 03:20:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1951', document_date = '2019-06-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 = '68.70', price_tax_excluded = '60.52', date_upd = NOW() WHERE id_document = '20114' 03/06/2025 03:20: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 = '20114' 03/06/2025 03:20:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '20114' 03/06/2025 03:20:19 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 ( '20114' , '7673' , 'PARTICOLE MM38' , '6' , '-6' , '3' , '2.7000' , '2.5961538461538' , '4' , '0' , '16.20' ) 03/06/2025 03:20:19 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 ( '20114' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '1.5' , '1.4423076923077' , '4' , '0' , '4.50' ) 03/06/2025 03:20:19 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 ( '20114' , '7308' , 'OSTIA MAGNA - OM 50' , '3' , '-3' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '9.00' ) 03/06/2025 03:20:19 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 ( '20114' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 03/06/2025 03:21:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1634' AND id_document != '19730' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2019-05-29') 03/06/2025 03:21:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1634', document_date = '2019-05-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '68.90', price_tax_excluded = '61.84', date_upd = NOW() WHERE id_document = '19730' 03/06/2025 03:21:11 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 = '19730' 03/06/2025 03:21:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '19730' 03/06/2025 03:21:11 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 ( '19730' , '9042' , 'ROCCA STOPPINO MT 50 ' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 03/06/2025 03:21:11 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 ( '19730' , '7673' , 'PARTICOLE MM38' , '3' , '-3' , '3' , '2.7000' , '2.5961538461538' , '4' , '0' , '8.10' ) 03/06/2025 03:21:11 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 ( '19730' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '3' , '-3' , '3' , '1' , '0.96153846153846' , '4' , '0' , '3.00' ) 03/06/2025 03:21:11 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 ( '19730' , '9112' , 'ROSARIO FRANCESCANO - GRANI PICCOLI - 1535' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 03/06/2025 03:21:11 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 ( '19730' , '14780' , 'STATUA SAN PIO RESINA CM 30 - 1991/5' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 03/06/2025 03:21:11 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 ( '19730' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '1.80' ) 03/06/2025 03:21:11 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 ( '19730' , '8422' , 'PREPARIAMO LA MESSA - ANNO A' , '3' , '-3' , '4' , '7.0000' , '7' , '0' , '0' , '21.00' ) 03/06/2025 03:21:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1773' AND id_document != '19903' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2019-06-08') 03/06/2025 03:21:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1773', document_date = '2019-06-08', 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 = '39.15', price_tax_excluded = '35.80', date_upd = NOW() WHERE id_document = '19903' 03/06/2025 03:21: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 = '19903' 03/06/2025 03:21:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '19903' 03/06/2025 03:21: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 ( '19903' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '6' , '-6' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '16.80' ) 03/06/2025 03:21: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 ( '19903' , '9014' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA...' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '10' , '13.95' ) 03/06/2025 03:21: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 ( '19903' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '2.7000' , '2.5961538461538' , '4' , '0' , '5.40' ) 03/06/2025 03:21: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 ( '19903' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '3' , '-3' , '3' , '1' , '0.96153846153846' , '4' , '0' , '3.00' ) 03/06/2025 03:21:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1813' AND id_document != '19950' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2019-06-12') 03/06/2025 03:21:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1813', document_date = '2019-06-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 = '34.50', price_tax_excluded = '28.92', date_upd = NOW() WHERE id_document = '19950' 03/06/2025 03:21:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '19950' 03/06/2025 03:21:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '19950' 03/06/2025 03:21:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '19950' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '1.50' ) 03/06/2025 03:21:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '19950' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '3' , '-3' , '3' , '1' , '0.96153846153846' , '4' , '0' , '3.00' ) 03/06/2025 03:21:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '19950' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '13' , '-13' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '19.50' ) 03/06/2025 03:21:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '19950' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '10.50' ) 03/06/2025 03:22:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '785' AND id_document != '17771' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2019-03-23') 03/06/2025 03:22:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '785', document_date = '2019-03-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 = '500.00', price_tax_excluded = '419.37', date_upd = NOW() WHERE id_document = '17771' 03/06/2025 03:22:17 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 = '17771' 03/06/2025 03:22:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '17771' 03/06/2025 03:22:17 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 ( '17771' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '30' , '-30' , '3' , '1' , '0.96153846153846' , '4' , '0' , '30.00' ) 03/06/2025 03:22:17 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 ( '17771' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '10' , '-10' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '15.00' ) 03/06/2025 03:22:17 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 ( '17771' , '1914' , 'CERA DELLA LITURGIA' , '36' , '-36' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '126.00' ) 03/06/2025 03:22:17 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 ( '17771' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '3.5000' , '2.8688524590164' , '22' , '100' , '0.00' ) 03/06/2025 03:22:17 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 ( '17771' , '1951' , 'CERONI S.S. T60 - CARTA' , '75' , '-75' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '187.50' ) 03/06/2025 03:22:17 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 ( '17771' , '15056' , 'AMEN - MAR. 2019' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '10' , '7.02' ) 03/06/2025 03:22:17 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 ( '17771' , '15057' , 'AMEN - APR. 2019' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '10' , '7.02' ) 03/06/2025 03:22:17 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 ( '17771' , '15346' , 'DISCORSO AL TERMINE DELLINCONTRO...' , '2' , '-2' , '4' , '1.7000' , '1.7' , '0' , '0' , '3.40' ) 03/06/2025 03:22:17 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 ( '17771' , '11264' , 'VESTINA BATTESIMALE' , '5' , '-5' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '12.50' ) 03/06/2025 03:22:17 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 ( '17771' , '1709' , 'CARBONCINI LITURGICI' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 03/06/2025 03:22:17 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 ( '17771' , '5229' , 'INCENSO PONTIFICAL' , '2' , '-2' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '44.00' ) 03/06/2025 03:22:17 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 ( '17771' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 03/06/2025 03:22:17 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 ( '17771' , '9181' , 'ROSARIO S. BENEDETTO LEGNO PALISSANDRO - OGGETTI' , '1' , '-1' , '1' , '4.9600' , '4.0655737704918' , '22' , '0' , '4.96' ) 03/06/2025 03:22:17 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 ( '17771' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '3.60' ) 03/06/2025 03:22:17 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 ( '17771' , '13609' , 'APPENDICHIAVI DECORATO TONDO' , '1' , '-1' , '1' , '26.0000' , '21.311475409836' , '22' , '0' , '26.00' ) 03/06/2025 03:22:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2832' AND id_document != '21230' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2019-10-03') 03/06/2025 03:22:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2832', document_date = '2019-10-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 = '52.50', price_tax_excluded = '52.21', date_upd = NOW() WHERE id_document = '21230' 03/06/2025 03:22: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 = '21230' 03/06/2025 03:22:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '21230' 03/06/2025 03:22: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 ( '21230' , '14029' , 'ANGELO DI DIO' , '2' , '-2' , '4' , '1.7500' , '1.75' , '0' , '0' , '3.50' ) 03/06/2025 03:22: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 ( '21230' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '6.00' ) 03/06/2025 03:22: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 ( '21230' , '1040' , 'BENEDIZIONALE' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '10' , '31.50' ) 03/06/2025 03:22: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 ( '21230' , '14032' , 'AVE MARIA' , '5' , '-5' , '4' , '2.0000' , '2' , '0' , '0' , '10.00' ) 03/06/2025 03:22: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 ( '21230' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '1.5' , '1.4423076923077' , '4' , '0' , '1.50' ) 03/06/2025 03:24:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '291' AND id_document != '95478' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 03/06/2025 03:24:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '291', document_date = '2025-01-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 = '91.30', price_tax_excluded = '79.88', date_upd = NOW() WHERE id_document = '95478' 03/06/2025 03:24:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95478' 03/06/2025 03:24:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '95478' 03/06/2025 03:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95478' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '1' , '0.96153846153846' , '4' , '0' , '20.00' ) 03/06/2025 03:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95478' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 03/06/2025 03:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95478' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 03/06/2025 03:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95478' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5000' , '22.540983606557' , '22' , '0' , '55.00' ) 03/06/2025 03:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95478' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '3.30' ) 03/06/2025 03:24:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '540' AND id_document != '95812' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 03/06/2025 03:24:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '540', document_date = '2025-02-19', 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 = '159.04', price_tax_excluded = '148.34', date_upd = NOW() WHERE id_document = '95812' 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95812' 03/06/2025 03:24:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '95812' 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.92' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.92' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '4443' , 'GESÙ ENTRÒ PER RIMANERE CON LORO - A. FONTANA' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '1' , '0.96153846153846' , '4' , '0' , '20.00' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '23165' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '10' , '-10' , '4' , '1.9000' , '1.9' , '0' , '5' , '18.10' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '11.00' ) 03/06/2025 03:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '20301' , 'CREDIAMO - LE PRINCIPALI VERITA DI FEDE' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '0' , '0.90' ) 03/06/2025 03:25:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '796' AND id_document != '96139' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-10') 03/06/2025 03:25:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '796', document_date = '2025-03-10', 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 = '193.50', price_tax_excluded = '176.19', date_upd = NOW() WHERE id_document = '96139' 03/06/2025 03:25: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 = '96139' 03/06/2025 03:25:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '96139' 03/06/2025 03:25: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 ( '96139' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '22.50' ) 03/06/2025 03:25: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 ( '96139' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '1' , '0.96153846153846' , '4' , '0' , '20.00' ) 03/06/2025 03:25: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 ( '96139' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '70.00' ) 03/06/2025 03:25: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 ( '96139' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 03/06/2025 03:25: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 ( '96139' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '72.00' ) 03/06/2025 03:25:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3747' AND id_document != '94611' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 03/06/2025 03:25:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3747', document_date = '2024-11-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 = '265.90', price_tax_excluded = '239.54', date_upd = NOW() WHERE id_document = '94611' 03/06/2025 03:25: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 = '94611' 03/06/2025 03:25:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94611' 03/06/2025 03:25: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 ( '94611' , '23217' , 'SCATOLA PORTA OSTIA CON LUNETTA - 1355' , '1' , '-1' , '1' , '140.0000' , '114.75409836066' , '22' , '0' , '140.00' ) 03/06/2025 03:25: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 ( '94611' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 03/06/2025 03:25: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 ( '94611' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '5' , '39.90' ) 03/06/2025 03:25: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 ( '94611' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 03/06/2025 03:25: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 ( '94611' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '1' , '0.96153846153846' , '4' , '0' , '8.00' ) 03/06/2025 03:31:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1958' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 03:31:47 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' , '1958' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '23.36' , NOW() , NOW() ) 03/06/2025 03:31:47 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 = '97513' 03/06/2025 03:31:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '97513' 03/06/2025 03:31:47 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 ( '97513' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 03/06/2025 03:31:47 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 ( '97513' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 03/06/2025 04:13:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1959' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 04:13:21 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' , '1959' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '43.44' , NOW() , NOW() ) 03/06/2025 04:13:21 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 = '97514' 03/06/2025 04:13:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '97514' 03/06/2025 04:13:21 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 ( '97514' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 03/06/2025 04:13:21 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 ( '97514' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 03/06/2025 04:18:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1944' AND id_document != '97494' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-31') 03/06/2025 04:18:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1944', document_date = '2025-05-31', 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 = '20.70', price_tax_excluded = '16.97', date_upd = NOW() WHERE id_document = '97494' 03/06/2025 04:18:01 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 = '97494' 03/06/2025 04:18:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '97494' 03/06/2025 04:18:01 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 ( '97494' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11.8' , '9.672131147541' , '22' , '0' , '11.80' ) 03/06/2025 04:18:01 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 ( '97494' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 03/06/2025 04:18:01 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 ( '97494' , '21097' , 'BRACCIALE DECINA - BC1768N' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 03/06/2025 04:27:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1960' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 04:27:25 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' , '1960' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.80' , '12.95' , NOW() , NOW() ) 03/06/2025 04:27:25 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 = '97515' 03/06/2025 04:27:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '97515' 03/06/2025 04:27:25 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 ( '97515' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 03/06/2025 04:48:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1961' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 04:48: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' , '1961' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.80' , '18.69' , NOW() , NOW() ) 03/06/2025 04:48: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 = '97516' 03/06/2025 04:48:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '97516' 03/06/2025 04:48: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 ( '97516' , '20516' , 'CROCE COMUNIONE - 42/08' , '16' , '-16' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '19.20' ) 03/06/2025 04:48: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 ( '97516' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 03/06/2025 05:02:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1962' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 05:02:22 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' , '1962' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.50' , '6.50' , NOW() , NOW() ) 03/06/2025 05:02:22 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 = '97517' 03/06/2025 05:02:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97517' 03/06/2025 05:02:22 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 ( '97517' , '1826' , 'CATECHISMO DELLA CHIESA CATTOLICA COMPENDIO' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '0' , '6.50' ) 03/06/2025 05:35:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1963' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 05:35:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1963' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.80' , NOW() , NOW() ) 03/06/2025 05:35:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97518' 03/06/2025 05:35:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '97518' 03/06/2025 05:35:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97518' , '23666' , 'CARLO ACUTIS SENZA DI LUI' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 03/06/2025 05:35:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97518' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1' , '1' , '0' , '0' , '1.00' ) 03/06/2025 06:05:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1964' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 06:05: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 ( '11' , '1964' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.70' , '0.57' , NOW() , NOW() ) 03/06/2025 06:05: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 = '97519' 03/06/2025 06:05:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '97519' 03/06/2025 06:05: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 ( '97519' , '5536' , 'LACCIO' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 03/06/2025 07:01:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1965' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 07:01: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' , '1965' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.90' , '1.79' , NOW() , NOW() ) 03/06/2025 07:01: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 = '97520' 03/06/2025 07:01:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '97520' 03/06/2025 07:01: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 ( '97520' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '2' , '-2' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.60' ) 03/06/2025 07:01: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 ( '97520' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.3' , '1.3' , '0' , '0' , '1.30' ) 03/06/2025 07:12:50 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 ( '32' , '6025218686' , '2025-05-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.53' , '68.53' , NOW() , NOW() ) 03/06/2025 07:12:50 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 = '97521' 03/06/2025 07:12:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '97521' 03/06/2025 07:12: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 ( '97521' , '23746' , 'DIO CRISTO LA CHIESA - A. CATTANEO' , '1' , '0' , '4' , '15.4' , '15.4' , '0' , '0' , '15.4000' ) 03/06/2025 07:12:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23746' AND id_supplier = '109' 03/06/2025 07:12:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23746' , '109' , '1' ) 03/06/2025 07:12: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 ( '97521' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '0' , '4' , '27.23' , '27.23' , '0' , '0' , '27.2300' ) 03/06/2025 07:12:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '109' 03/06/2025 07:12:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '109' , '1' ) 03/06/2025 07:12: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 ( '97521' , '7182' , 'NUOVO TESTAMENTO - CAR. GRANDI' , '1' , '0' , '4' , '25.9' , '25.9' , '0' , '0' , '25.9000' ) 03/06/2025 07:12:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7182' AND id_supplier = '109' 03/06/2025 07:12:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7182' , '109' , '1' ) 03/06/2025 07:17: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 ( '32' , '6025218688' , '2025-05-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.69' , '83.69' , NOW() , NOW() ) 03/06/2025 07:17: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 = '97522' 03/06/2025 07:17:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '97522' 03/06/2025 07:17: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 ( '97522' , '23755' , 'VIAGGIO NEI MIRACOLI EUCARISTICI - M. BUIONI' , '2' , '0' , '4' , '11.625' , '11.625' , '0' , '0' , '23.2500' ) 03/06/2025 07:17:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23755' AND id_supplier = '109' 03/06/2025 07:17:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23755' , '109' , '1' ) 03/06/2025 07:17: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 ( '97522' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '1' , '0' , '4' , '21.26' , '21.26' , '0' , '0' , '21.2600' ) 03/06/2025 07:17:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22283' AND id_supplier = '109' 03/06/2025 07:17:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22283' , '109' , '1' ) 03/06/2025 07:17: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 ( '97522' , '7182' , 'NUOVO TESTAMENTO - CAR. GRANDI' , '1' , '0' , '4' , '25.9' , '25.9' , '0' , '0' , '25.9000' ) 03/06/2025 07:17:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7182' AND id_supplier = '109' 03/06/2025 07:17:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7182' , '109' , '1' ) 03/06/2025 07:17: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 ( '97522' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '0' , '4' , '13.28' , '13.28' , '0' , '0' , '13.2800' ) 03/06/2025 07:17:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17413' AND id_supplier = '109' 03/06/2025 07:17:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17413' , '109' , '1' ) 03/06/2025 07:18:55 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 ( '32' , '6025218687' , '2025-05-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.05' , '51.05' , NOW() , NOW() ) 03/06/2025 07:18: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 = '97523' 03/06/2025 07:18:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97523' 03/06/2025 07:18: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 ( '97523' , '23416' , 'CREDO COMPENDIO DELLA FEDE CATTOLICA - A. SCHNEIDER' , '1' , '0' , '4' , '18.65' , '18.65' , '0' , '0' , '18.6500' ) 03/06/2025 07:18:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23416' AND id_supplier = '109' 03/06/2025 07:18:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23416' , '109' , '1' ) 03/06/2025 07:18: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 ( '97523' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '0' , '4' , '18' , '18' , '0' , '0' , '18.0000' ) 03/06/2025 07:18:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23235' AND id_supplier = '109' 03/06/2025 07:18:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23235' , '109' , '1' ) 03/06/2025 07:18: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 ( '97523' , '23754' , 'CANTO DELLA RANA - G. RAVASI' , '1' , '0' , '4' , '8.64' , '8.64' , '0' , '0' , '8.6400' ) 03/06/2025 07:18:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23754' AND id_supplier = '109' 03/06/2025 07:18:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23754' , '109' , '1' ) 03/06/2025 07:18: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 ( '97523' , '2640' , 'CONFESSIONI - S. AGOSTINO ' , '1' , '0' , '4' , '5.76' , '5.76' , '0' , '0' , '5.7600' ) 03/06/2025 07:18:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2640' AND id_supplier = '109' 03/06/2025 07:18:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2640' , '109' , '1' ) 03/06/2025 07:32:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1966' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 07:32: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 ( '11' , '1966' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 03/06/2025 07:32: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 = '97524' 03/06/2025 07:32:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '97524' 03/06/2025 07:32: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 ( '97524' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 03/06/2025 07:32: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 ( '97524' , '20026' , 'CANDELA VOTIVA 20X40' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 03/06/2025 07:53:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1967' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 03/06/2025 07:53:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1967' , '2025-06-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.80' , '8.85' , NOW() , NOW() ) 03/06/2025 07:53:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97525' 03/06/2025 07:53:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '97525' 03/06/2025 07:53:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97525' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 03/06/2025 07:53:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97525' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.8' , '6.3934426229508' , '22' , '0' , '7.80' )