17/09/2022 09:26:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2762' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 09:26:27 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' , '2762' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.95' , '38.95' , NOW() , NOW() ) 17/09/2022 09:26:27 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 = '61836' 17/09/2022 09:26:27 am >> DELETE FROM ps_document_detail WHERE id_document = '61836' 17/09/2022 09:26:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61836' , '19894' , 'NON HO FATTO NIENTE DI MALE - C. DALLARI' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 17/09/2022 09:26:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19894' AND id_supplier = '' 17/09/2022 09:26:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19894' , '' , '1' ) 17/09/2022 09:26:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61836' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 17/09/2022 09:26:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '17827' AND id_supplier = '' 17/09/2022 09:26:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17827' , '' , '1' ) 17/09/2022 09:26:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61836' , '14005' , 'DIECI COSE CHE PAPA FRANCESCO PROPONE AI SACERDOTI - D. FARES' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 17/09/2022 09:26:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '14005' AND id_supplier = '' 17/09/2022 09:26:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14005' , '' , '1' ) 17/09/2022 09:40:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2763' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 09:40:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2763' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.15' , '8.07' , NOW() , NOW() ) 17/09/2022 09:40:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61837' 17/09/2022 09:40:59 am >> DELETE FROM ps_document_detail WHERE id_document = '61837' 17/09/2022 09:40:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61837' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 17/09/2022 09:40:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '1912' AND id_supplier = '' 17/09/2022 09:40:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1912' , '' , '1' ) 17/09/2022 09:40:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61837' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 17/09/2022 09:40:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '7098' AND id_supplier = '' 17/09/2022 09:40:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7098' , '' , '1' ) 17/09/2022 09:40:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61837' , '8254' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.65' , '0.65' , '0' , '0' , '0.65' ) 17/09/2022 09:40:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '8254' AND id_supplier = '' 17/09/2022 09:40:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8254' , '' , '1' ) 17/09/2022 09:56:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2764' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 09:56:01 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' , '2764' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.40' , '4.43' , NOW() , NOW() ) 17/09/2022 09:56:01 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 = '61838' 17/09/2022 09:56:01 am >> DELETE FROM ps_document_detail WHERE id_document = '61838' 17/09/2022 09:56:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61838' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '2' , '-2' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '5.40' ) 17/09/2022 09:56:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = '' 17/09/2022 09:56:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '' , '1' ) 17/09/2022 09:59:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2765' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 09:59:39 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' , '2765' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '12.05' , NOW() , NOW() ) 17/09/2022 09:59:39 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 = '61839' 17/09/2022 09:59:39 am >> DELETE FROM ps_document_detail WHERE id_document = '61839' 17/09/2022 09:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61839' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 17/09/2022 09:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 17/09/2022 09:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 17/09/2022 10:00:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2766' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 10:00:11 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' , '2766' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '19.23' , NOW() , NOW() ) 17/09/2022 10:00:11 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 = '61840' 17/09/2022 10:00:11 am >> DELETE FROM ps_document_detail WHERE id_document = '61840' 17/09/2022 10:00: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 ( '61840' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 17/09/2022 10:00:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 17/09/2022 10:00:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 17/09/2022 10:00: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 ( '61840' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 17/09/2022 10:00:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 17/09/2022 10:00:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 17/09/2022 10:01:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2767' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 10:01:15 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' , '2767' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.69' , NOW() , NOW() ) 17/09/2022 10:01:15 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 = '61841' 17/09/2022 10:01:15 am >> DELETE FROM ps_document_detail WHERE id_document = '61841' 17/09/2022 10:01:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61841' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 17/09/2022 10:01:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 17/09/2022 10:01:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 17/09/2022 10:19:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2768' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 10:19:30 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' , '2768' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '13.52' , NOW() , NOW() ) 17/09/2022 10:19:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61842' 17/09/2022 10:19:30 am >> DELETE FROM ps_document_detail WHERE id_document = '61842' 17/09/2022 10:19:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61842' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '16.50' ) 17/09/2022 10:19:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 17/09/2022 10:19:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 17/09/2022 10:38:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2769' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 10:38:01 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' , '2769' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '42.62' , NOW() , NOW() ) 17/09/2022 10:38:01 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 = '61843' 17/09/2022 10:38:01 am >> DELETE FROM ps_document_detail WHERE id_document = '61843' 17/09/2022 10:38:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61843' , '18222' , 'ROSARIO COLORATO - R316' , '80' , '-80' , '1' , '0.65' , '0.5327868852459' , '22' , '0' , '52.00' ) 17/09/2022 10:38:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 17/09/2022 10:38:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 17/09/2022 11:13:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2770' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 11:13:08 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' , '2770' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.50' , '37.50' , NOW() , NOW() ) 17/09/2022 11:13:08 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 = '61844' 17/09/2022 11:13:08 am >> DELETE FROM ps_document_detail WHERE id_document = '61844' 17/09/2022 11:13:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61844' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '37.5' , '37.5' , '0' , '0' , '37.50' ) 17/09/2022 11:13:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 17/09/2022 11:13:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 17/09/2022 11:39:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2771' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 11:39:47 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' , '2771' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '106.50' , '87.30' , NOW() , NOW() ) 17/09/2022 11:39:47 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 = '61845' 17/09/2022 11:39:47 am >> DELETE FROM ps_document_detail WHERE id_document = '61845' 17/09/2022 11:39:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61845' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '5' , '-5' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '32.50' ) 17/09/2022 11:39:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '11623' AND id_supplier = '' 17/09/2022 11:39:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11623' , '' , '1' ) 17/09/2022 11:39:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61845' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '10' , '-10' , '1' , '7.40' , '6.0655737704918' , '22' , '0' , '74.00' ) 17/09/2022 11:39:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '11626' AND id_supplier = '' 17/09/2022 11:39:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11626' , '' , '1' ) 17/09/2022 11:41:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2772' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 11:41: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' , '2772' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.99' , '46.59' , NOW() , NOW() ) 17/09/2022 11:41: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 = '61846' 17/09/2022 11:41:43 am >> DELETE FROM ps_document_detail WHERE id_document = '61846' 17/09/2022 11:41: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 ( '61846' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35.5' , '29.098360655738' , '22' , '0' , '35.50' ) 17/09/2022 11:41:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 17/09/2022 11:41:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 17/09/2022 11:41: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 ( '61846' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 17/09/2022 11:41:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = '' 17/09/2022 11:41:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' ) 17/09/2022 11:41: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 ( '61846' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 17/09/2022 11:41:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '' 17/09/2022 11:41:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '' , '1' ) 17/09/2022 11:41: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 ( '61846' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 17/09/2022 11:41:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '14330' AND id_supplier = '' 17/09/2022 11:41:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14330' , '' , '1' ) 17/09/2022 12:07:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2773' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 12:07:28 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' , '2773' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 17/09/2022 12:07:28 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 = '61847' 17/09/2022 12:07:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '61847' 17/09/2022 12:07:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61847' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 17/09/2022 12:07:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 17/09/2022 12:07:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 17/09/2022 12:13:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2773' AND id_document != '61847' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 12:13:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2773', document_date = '2022-09-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '61847' 17/09/2022 12:13:57 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 = '61847' 17/09/2022 12:13:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '61847' 17/09/2022 12:13:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61847' , '3020' , 'CROCE LEGNO MDF STILIZZ. VERDE - AN 092-V - OGGETTI' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 17/09/2022 12:13:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3020' AND id_supplier = '' 17/09/2022 12:13:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3020' , '' , '1' ) 17/09/2022 12:14:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1939' AND id_document != '58783' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 17/09/2022 12:14:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1939', document_date = '2022-06-15', 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 = '140.00', price_tax_excluded = '123.32', date_upd = NOW() WHERE id_document = '58783' 17/09/2022 12:14:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58783' 17/09/2022 12:14:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '58783' 17/09/2022 12:14:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '3018' , 'CROCE LEGNO MDF STILIZZ. ROSA - AN 092-R - OGGETTI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 17/09/2022 12:14:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3018' AND id_supplier = '' 17/09/2022 12:14:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3018' , '' , '1' ) 17/09/2022 12:14:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '6058' , 'MADONNA DEL CARMINE - 117 BIS ' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 17/09/2022 12:14:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6058' AND id_supplier = '' 17/09/2022 12:14:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6058' , '' , '1' ) 17/09/2022 12:14:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '20' , '-20' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '22.00' ) 17/09/2022 12:14:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 17/09/2022 12:14:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 17/09/2022 12: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 ( '58783' , '19644' , 'CHIESA CHE VERRA - A. MATTEO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 17/09/2022 12:14:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19644' AND id_supplier = '' 17/09/2022 12:14:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19644' , '' , '1' ) 17/09/2022 12: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 ( '58783' , '19334' , 'INSEGNACI A PREGARE - J. MARTIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 17/09/2022 12:14:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19334' AND id_supplier = '' 17/09/2022 12:14:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19334' , '' , '1' ) 17/09/2022 12: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 ( '58783' , '19131' , 'VIVI CRESCI AMA - M. DANIELI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 17/09/2022 12:14:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19131' AND id_supplier = '' 17/09/2022 12:14:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19131' , '' , '1' ) 17/09/2022 12: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 ( '58783' , '19597' , 'MEDAGLIA SAN BENEDETTO ARG. RA631' , '1' , '-1' , '1' , '15.8000' , '12.950819672131' , '22' , '0' , '15.80' ) 17/09/2022 12:14:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19597' AND id_supplier = '' 17/09/2022 12:14:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19597' , '' , '1' ) 17/09/2022 12: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 ( '58783' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA630' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 17/09/2022 12:14:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19596' AND id_supplier = '' 17/09/2022 12:14:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19596' , '' , '1' ) 17/09/2022 12: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 ( '58783' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 17/09/2022 12:14:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 17/09/2022 12:14:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 17/09/2022 12: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 ( '58783' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 17/09/2022 12:14:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19301' AND id_supplier = '' 17/09/2022 12:14:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19301' , '' , '1' ) 17/09/2022 12: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 ( '58783' , '19629' , 'SEGNALIBRO sacro cuore - 109' , '78' , '-78' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '11.70' ) 17/09/2022 12:14:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19629' AND id_supplier = '' 17/09/2022 12:14:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19629' , '' , '1' ) 17/09/2022 12: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 ( '58783' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 17/09/2022 12:14:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = '' 17/09/2022 12:14:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '' , '1' ) 17/09/2022 12:39:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2774' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 17/09/2022 12:39: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' , '2774' , '2022-09-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.40' , '6.89' , NOW() , NOW() ) 17/09/2022 12:39: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 = '61848' 17/09/2022 12:39:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '61848' 17/09/2022 12:39: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 ( '61848' , '13136' , 'ANGELI IN RESINA CM 9 - P322' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 17/09/2022 12:39:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13136' AND id_supplier = '' 17/09/2022 12:39:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13136' , '' , '1' ) 17/09/2022 12:39: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 ( '61848' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 17/09/2022 12:39:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18005' AND id_supplier = '' 17/09/2022 12:39:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18005' , '' , '1' ) 17/09/2022 12:41:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2289' AND id_document != '59711' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 17/09/2022 12:41:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2289', document_date = '2022-07-16', 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 = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '59711' 17/09/2022 12:41:37 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 = '59711' 17/09/2022 12:41:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '59711' 17/09/2022 12:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59711' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 17/09/2022 12:41:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 17/09/2022 12:41:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 17/09/2022 12:41: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 ( '59711' , '19413' , 'CARI SPOSI E SPOSE SCRIVO A VOI' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 17/09/2022 12:41:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19413' AND id_supplier = '' 17/09/2022 12:41:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19413' , '' , '1' ) 17/09/2022 12:41: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 ( '59711' , '10293' , 'STORIA DI SAN FRANCESCO' , '1' , '-1' , '4' , '1.95' , '1.95' , '0' , '0' , '1.95' ) 17/09/2022 12:41:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10293' AND id_supplier = '' 17/09/2022 12:41:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10293' , '' , '1' )