26/11/2022 09:17:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3631' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 09:17:49 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' , '3631' , '2022-11-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 26/11/2022 09:17:49 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 = '74900' 26/11/2022 09:17:49 am >> DELETE FROM ps_document_detail WHERE id_document = '74900' 26/11/2022 09:17:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74900' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 26/11/2022 09:17:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '2436' AND id_supplier = '' 26/11/2022 09:17:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2436' , '' , '1' ) 26/11/2022 09:21:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3632' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 09:21:19 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' , '3632' , '2022-11-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 26/11/2022 09:21:19 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 = '74901' 26/11/2022 09:21:19 am >> DELETE FROM ps_document_detail WHERE id_document = '74901' 26/11/2022 09:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74901' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 26/11/2022 09:21:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 26/11/2022 09:21:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 26/11/2022 09:34:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002039' AND id_product != '20156' AND ean13 != '' 26/11/2022 09:34:55 am >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002039', date_upd = NOW() WHERE id_product = '20156' 26/11/2022 09:34:55 am >> UPDATE ps_product_lang SET name = 'PALLA CON CARTONCINO - 23/64NAT03', description = '' WHERE id_product = '20156' 26/11/2022 09:34:55 am >> UPDATE ps_product SET wholesale_price = '0.49', on_sale = '0', price = '1.0655737704918034' WHERE id_product = '20156' 26/11/2022 09:34:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.49', price = '1.0655737704918034', id_tax_rules_group = '1', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20156' 26/11/2022 09:34:55 am >> DELETE FROM ps_specific_price WHERE id_product = '20156' 26/11/2022 09:36:07 am >> SELECT document_num FROM ps_document WHERE document_num = '98/A' AND id_document != '74838' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-24') 26/11/2022 09:36:07 am >> UPDATE ps_document SET id_document_type = '24', document_num = '98/A', document_date = '2022-11-24', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'catechismo', 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 = '56.52', price_tax_excluded = '56.52', date_upd = NOW() WHERE id_document = '74838' 26/11/2022 09:36:07 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 = '74838' 26/11/2022 09:36:07 am >> DELETE FROM ps_document_detail WHERE id_document = '74838' 26/11/2022 09:36:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74838' , '2679' , 'CONOSCERE GESU' , '19' , '-19' , '4' , '3.5000' , '3.5' , '0' , '15' , '56.52' ) 26/11/2022 09:36:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 26/11/2022 09:36:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 26/11/2022 09:36:16 am >> DELETE FROM ps_document WHERE id_document = '74831' 26/11/2022 09:36:16 am >> DELETE FROM ps_document_detail WHERE id_document = '74831' 26/11/2022 09:36:46 am >> SELECT document_num FROM ps_document WHERE document_num = '78/A' AND id_document != '67994' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 26/11/2022 09:36:46 am >> UPDATE ps_document SET id_document_type = '24', document_num = '78/A', document_date = '2022-10-20', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', 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 = '211.20', price_tax_excluded = '193.17', date_upd = NOW() WHERE id_document = '67994' 26/11/2022 09:36:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67994' 26/11/2022 09:36:46 am >> DELETE FROM ps_document_detail WHERE id_document = '67994' 26/11/2022 09:36:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67994' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '4' , '-4' , '4' , '14.8000' , '14.8' , '0' , '0' , '59.20' ) 26/11/2022 09:36:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20150' AND id_supplier = '' 26/11/2022 09:36:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20150' , '' , '1' ) 26/11/2022 09:36:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67994' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '0' , '26.00' ) 26/11/2022 09:36:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '2072' AND id_supplier = '' 26/11/2022 09:36:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2072' , '' , '1' ) 26/11/2022 09:36:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67994' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '0' , '26.00' ) 26/11/2022 09:36:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '2073' AND id_supplier = '' 26/11/2022 09:36:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2073' , '' , '1' ) 26/11/2022 09:36:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67994' , '20159' , 'NATIVITA STELLA CON BASE - 22/194-10NAT04' , '50' , '-50' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '100.00' ) 26/11/2022 09:36:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20159' AND id_supplier = '' 26/11/2022 09:36:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20159' , '' , '1' ) 26/11/2022 09:48:38 am >> SELECT document_num FROM ps_document WHERE document_num = '78/A' AND id_document != '67994' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 26/11/2022 09:48:38 am >> UPDATE ps_document SET id_document_type = '24', document_num = '78/A', document_date = '2022-10-20', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', 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 = '243.10', price_tax_excluded = '225.07', date_upd = NOW() WHERE id_document = '67994' 26/11/2022 09:48:38 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 = '67994' 26/11/2022 09:48:38 am >> DELETE FROM ps_document_detail WHERE id_document = '67994' 26/11/2022 09:48: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 ( '67994' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '4' , '-4' , '4' , '14.8000' , '14.8' , '0' , '0' , '59.20' ) 26/11/2022 09:48:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '20150' AND id_supplier = '' 26/11/2022 09:48:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20150' , '' , '1' ) 26/11/2022 09:48: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 ( '67994' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '0' , '26.00' ) 26/11/2022 09:48:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '2072' AND id_supplier = '' 26/11/2022 09:48:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2072' , '' , '1' ) 26/11/2022 09:48: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 ( '67994' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '0' , '26.00' ) 26/11/2022 09:48:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '2073' AND id_supplier = '' 26/11/2022 09:48:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2073' , '' , '1' ) 26/11/2022 09:48: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 ( '67994' , '19228' , 'DIO CE ED E BELLISSIMO - P. CURTAZ' , '1' , '-1' , '4' , '15.90' , '15.9' , '0' , '0' , '15.90' ) 26/11/2022 09:48:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19228' AND id_supplier = '' 26/11/2022 09:48:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19228' , '' , '1' ) 26/11/2022 09:48: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 ( '67994' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 26/11/2022 09:48:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 26/11/2022 09:48:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 26/11/2022 09:48: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 ( '67994' , '20159' , 'NATIVITA STELLA CON BASE - 22/194-10NAT04' , '50' , '-50' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '100.00' ) 26/11/2022 09:48:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '20159' AND id_supplier = '' 26/11/2022 09:48:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20159' , '' , '1' ) 26/11/2022 10:22:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3633' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 10:22: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' , '3633' , '2022-11-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.50' , '5.42' , NOW() , NOW() ) 26/11/2022 10:22: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 = '74902' 26/11/2022 10:22:30 am >> DELETE FROM ps_document_detail WHERE id_document = '74902' 26/11/2022 10:22: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 ( '74902' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 26/11/2022 10:22:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '2436' AND id_supplier = '' 26/11/2022 10:22:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2436' , '' , '1' ) 26/11/2022 10:22: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 ( '74902' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.5' , '0.5' , '0' , '0' , '0.50' ) 26/11/2022 10:22:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 26/11/2022 10:22:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 26/11/2022 10:25:02 am >> SELECT document_num FROM ps_document WHERE document_num = '102/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 10:25:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '102/A' , '2022-11-26' , 'A' , '27' , '0' , '4677541' , 'P.ZZA PIRONTI 83025 PIANO DI MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '100.00' , NOW() , NOW() ) 26/11/2022 10:25:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74903' 26/11/2022 10:25:02 am >> DELETE FROM ps_document_detail WHERE id_document = '74903' 26/11/2022 10:25:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74903' , '' , 'coprimessale ' , '1' , '-1' , '0' , '100' , '100' , '' , '0' , '100.00' ) 26/11/2022 10:25:50 am >> SELECT document_num FROM ps_document WHERE document_num = '102/A' AND id_document != '74903' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 10:25:50 am >> UPDATE ps_document SET id_document_type = '24', document_num = '102/A', document_date = '2022-11-26', document_letter = 'A', id_customer = '27', id_supplier = '', id_address = '4677541', address1 = 'P.ZZA PIRONTI 83025 PIANO DI MONTORO', 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 = '100.00', price_tax_excluded = '94.59', date_upd = NOW() WHERE id_document = '74903' 26/11/2022 10:25:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74903' 26/11/2022 10:25:50 am >> DELETE FROM ps_document_detail WHERE id_document = '74903' 26/11/2022 10:25:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74903' , '0' , 'coprimessale ' , '1' , '-1' , '0' , '70' , '70' , '' , '0' , '70.00' ) 26/11/2022 10:25:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 26/11/2022 10:25:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 26/11/2022 10:25:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74903' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 26/11/2022 10:25:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 26/11/2022 10:25:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 26/11/2022 10:27:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2924' AND id_document != '64635' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 26/11/2022 10:27:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2924', document_date = '2022-10-05', 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 = '452.88', price_tax_excluded = '377.00', date_upd = NOW() WHERE id_document = '64635' 26/11/2022 10:27: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 = '64635' 26/11/2022 10:27:30 am >> DELETE FROM ps_document_detail WHERE id_document = '64635' 26/11/2022 10:27: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 ( '64635' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '138' , '113.11475409836' , '22' , '0' , '138.00' ) 26/11/2022 10:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '' 26/11/2022 10:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '' , '1' ) 26/11/2022 10:27: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 ( '64635' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 26/11/2022 10:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '' 26/11/2022 10:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '' , '1' ) 26/11/2022 10:27: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 ( '64635' , '19799' , 'CAMICE MARIANO IN LANA - 0774/06' , '1' , '-1' , '1' , '265.0000' , '217.2131147541' , '22' , '0' , '265.00' ) 26/11/2022 10:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19799' AND id_supplier = '' 26/11/2022 10:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19799' , '' , '1' ) 26/11/2022 10:27: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 ( '64635' , '8260' , 'PREGHIAMO INSIEME E DICIAMO - M. BARZIZZA' , '1' , '-1' , '4' , '32.5000' , '32.5' , '0' , '5' , '30.88' ) 26/11/2022 10:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '8260' AND id_supplier = '' 26/11/2022 10:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8260' , '' , '1' ) 26/11/2022 10:27: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 ( '64635' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '1' , '-1' , '4' , '1.2000' , '1.2' , '0' , '0' , '1.20' ) 26/11/2022 10:27:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 26/11/2022 10:27:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 26/11/2022 10:27:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64635' , '18102' , 'CROCE ULIVO DELLAMICIZIA - PG748 ' , '1' , '-1' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '1.80' ) 26/11/2022 10:27:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '18102' AND id_supplier = '' 26/11/2022 10:27:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18102' , '' , '1' ) 26/11/2022 10:27:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64635' , '11683' , 'CROCE CON COLOMBA E LACCIO - 0872/09' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 26/11/2022 10:27:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11683' AND id_supplier = '' 26/11/2022 10:27:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11683' , '' , '1' ) 26/11/2022 10:56:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3634' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 10:56:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3634' , '2022-11-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.80' , NOW() , NOW() ) 26/11/2022 10:56:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74904' 26/11/2022 10:56:04 am >> DELETE FROM ps_document_detail WHERE id_document = '74904' 26/11/2022 10:56:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74904' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 26/11/2022 10:56:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '' 26/11/2022 10:56:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '' , '1' ) 26/11/2022 11:26:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3635' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 11:26:21 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' , '3635' , '2022-11-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 26/11/2022 11:26:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74905' 26/11/2022 11:26:21 am >> DELETE FROM ps_document_detail WHERE id_document = '74905' 26/11/2022 11:26:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74905' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '200' , '-200' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '40.00' ) 26/11/2022 11:26:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '' 26/11/2022 11:26:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '' , '1' ) 26/11/2022 11:26:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74905' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 26/11/2022 11:26:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 26/11/2022 11:26:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 26/11/2022 11:27:34 am >> SELECT document_num FROM ps_document WHERE document_num = '80/A' AND id_document != '68007' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 26/11/2022 11:27:34 am >> UPDATE ps_document SET id_document_type = '24', document_num = '80/A', document_date = '2022-10-20', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4675734', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '44.00', price_tax_excluded = '44.00', date_upd = NOW() WHERE id_document = '68007' 26/11/2022 11:27:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68007' 26/11/2022 11:27:34 am >> DELETE FROM ps_document_detail WHERE id_document = '68007' 26/11/2022 11:27:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68007' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '5' , '-5' , '4' , '1.2000' , '1.2' , '0' , '0' , '6.00' ) 26/11/2022 11:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 26/11/2022 11:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 26/11/2022 11:27:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68007' , '17014' , 'COME GIOISCE LO SPOSO ... - GUIDA - S. MURATORE' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 26/11/2022 11:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '17014' AND id_supplier = '' 26/11/2022 11:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17014' , '' , '1' ) 26/11/2022 11:27:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68007' , '17015' , 'COME GIOISCE LO SPOSO ... - SUSSIDIO - S. MURATORE' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 26/11/2022 11:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '17015' AND id_supplier = '' 26/11/2022 11:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17015' , '' , '1' ) 26/11/2022 11:28:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3636' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 11:28:54 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' , '3636' , '2022-11-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.60' , '15.35' , NOW() , NOW() ) 26/11/2022 11:28:54 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 = '74906' 26/11/2022 11:28:54 am >> DELETE FROM ps_document_detail WHERE id_document = '74906' 26/11/2022 11:28:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74906' , '12908' , 'Y BIBBIA' , '1' , '-1' , '4' , '14.2' , '14.2' , '0' , '0' , '14.20' ) 26/11/2022 11:28:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '12908' AND id_supplier = '' 26/11/2022 11:28:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12908' , '' , '1' ) 26/11/2022 11:28:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74906' , '18274' , 'BRACCIALE A NODI - 2610' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 26/11/2022 11:28:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '18274' AND id_supplier = '' 26/11/2022 11:28:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18274' , '' , '1' ) 26/11/2022 11:30:49 am >> SELECT document_num FROM ps_document WHERE document_num = '80/A' AND id_document != '68007' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 26/11/2022 11:30:49 am >> UPDATE ps_document SET id_document_type = '24', document_num = '80/A', document_date = '2022-10-20', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4675734', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '77.25', price_tax_excluded = '77.25', date_upd = NOW() WHERE id_document = '68007' 26/11/2022 11:30:49 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 = '68007' 26/11/2022 11:30:49 am >> DELETE FROM ps_document_detail WHERE id_document = '68007' 26/11/2022 11:30:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68007' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '5' , '-5' , '4' , '1.2000' , '1.2' , '0' , '0' , '6.00' ) 26/11/2022 11:30:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 26/11/2022 11:30:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 26/11/2022 11:30:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68007' , '17014' , 'COME GIOISCE LO SPOSO ... - GUIDA - S. MURATORE' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 26/11/2022 11:30:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '17014' AND id_supplier = '' 26/11/2022 11:30:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17014' , '' , '1' ) 26/11/2022 11:30:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68007' , '17015' , 'COME GIOISCE LO SPOSO ... - SUSSIDIO - S. MURATORE' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 26/11/2022 11:30:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '17015' AND id_supplier = '' 26/11/2022 11:30:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17015' , '' , '1' ) 26/11/2022 11:30:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68007' , '20394' , 'TEOLOGIA LITURGICA DEI SACRAMENTI - EUCARISTIA - A. MIRALLES' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 26/11/2022 11:30:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '20394' AND id_supplier = '' 26/11/2022 11:30:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20394' , '' , '1' ) 26/11/2022 11:34:19 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1656' 26/11/2022 11:34:19 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1656' , '10' , '210' , 'PARROCCHIA S. ANTONIO DA PADOVA' , 'MARONE ' , ' DON LUIGI' , 'VIA NAZIONALE' , '' , '84060' , 'OMIGNANO SCALO' , '' , '333 3078088' , '' , '' , '' , NOW() , NOW() ) 26/11/2022 11:34:19 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1656' 26/11/2022 11:34:34 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1656' 26/11/2022 11:34:34 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1656' , '10' , '210' , 'PARROCCHIA S. ANTONIO DA PADOVA' , 'MARONE ' , ' DON LUIGI' , 'VIA NAZIONALE' , '' , '84060' , 'OMIGNANO SCALO' , '' , '333 3078088' , '' , '' , '' , NOW() , NOW() ) 26/11/2022 11:34:34 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1656' 26/11/2022 11:36:30 am >> SELECT document_num FROM ps_document WHERE document_num = '103/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 11:36:31 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' , '103/A' , '2022-11-26' , 'A' , '1656' , '0' , '4677544' , 'VIA NAZIONALE 84060 OMIGNANO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '267.75' , '267.75' , NOW() , NOW() ) 26/11/2022 11:36:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74907' 26/11/2022 11:36:31 am >> DELETE FROM ps_document_detail WHERE id_document = '74907' 26/11/2022 11:36:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74907' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 26/11/2022 11:36:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74907' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 26/11/2022 11:36:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74907' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '15' , '63.75' ) 26/11/2022 11:36:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74907' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 26/11/2022 11:36:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74907' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '15' , '76.50' ) 26/11/2022 11:36:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74907' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 26/11/2022 11:50:07 am >> SELECT document_num FROM ps_document WHERE document_num = '104/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 11:50:07 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' , '104/A' , '2022-11-26' , 'A' , '1656' , '0' , '4677544' , 'VIA NAZIONALE 84060 OMIGNANO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '275.45' , '236.15' , NOW() , NOW() ) 26/11/2022 11:50:07 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 = '74908' 26/11/2022 11:50:07 am >> DELETE FROM ps_document_detail WHERE id_document = '74908' 26/11/2022 11:50:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '5' , '19.95' ) 26/11/2022 11:50:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '14649' , 'COMPENDIO AL CATECHISMO DI PIO X' , '5' , '-5' , '4' , '1.60' , '1.6' , '0' , '5' , '7.60' ) 26/11/2022 11:50:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 26/11/2022 11:50:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '7673' , 'PARTICOLE MM38' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 26/11/2022 11:50:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 26/11/2022 11:50:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 26/11/2022 11:50:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 26/11/2022 11:50:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '9241' , 'SACC. 100 PZ MICCIA PER ACCENDERE STREGA ' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/11/2022 11:50:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '200' , '-200' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '80.00' ) 26/11/2022 11:50:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/11/2022 11:51:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3637' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 11:51:13 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' , '3637' , '2022-11-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 26/11/2022 11:51:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74909' 26/11/2022 11:51:13 am >> DELETE FROM ps_document_detail WHERE id_document = '74909' 26/11/2022 11:51: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 ( '74909' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 26/11/2022 11:51:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '' 26/11/2022 11:51:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '' , '1' ) 26/11/2022 11:52:56 am >> SELECT document_num FROM ps_document WHERE document_num = '104/A' AND id_document != '74908' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 11:52:56 am >> UPDATE ps_document SET id_document_type = '24', document_num = '104/A', document_date = '2022-11-26', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', 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 = '340.45', price_tax_excluded = '289.43', date_upd = NOW() WHERE id_document = '74908' 26/11/2022 11:52:56 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 = '74908' 26/11/2022 11:52:56 am >> DELETE FROM ps_document_detail WHERE id_document = '74908' 26/11/2022 11:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '7' , '-7' , '4' , '3.0000' , '3' , '0' , '5' , '19.95' ) 26/11/2022 11:52:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '1833' AND id_supplier = '' 26/11/2022 11:52:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1833' , '' , '1' ) 26/11/2022 11:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '14649' , 'COMPENDIO AL CATECHISMO DI PIO X' , '5' , '-5' , '4' , '1.6000' , '1.6' , '0' , '5' , '7.60' ) 26/11/2022 11:52:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '14649' AND id_supplier = '' 26/11/2022 11:52:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14649' , '' , '1' ) 26/11/2022 11:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 26/11/2022 11:52:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 26/11/2022 11:52:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 26/11/2022 11:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '7673' , 'PARTICOLE MM38' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 26/11/2022 11:52:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 26/11/2022 11:52:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 26/11/2022 11:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 26/11/2022 11:52:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = '' 26/11/2022 11:52:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' ) 26/11/2022 11:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 26/11/2022 11:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 26/11/2022 11:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 26/11/2022 11:52:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 26/11/2022 11:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 26/11/2022 11:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 26/11/2022 11:52:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '9241' , 'SACC. 100 PZ MICCIA PER ACCENDERE STREGA ' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/11/2022 11:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '9241' AND id_supplier = '' 26/11/2022 11:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9241' , '' , '1' ) 26/11/2022 11:52:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '200' , '-200' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '80.00' ) 26/11/2022 11:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 26/11/2022 11:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 26/11/2022 11:52:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/11/2022 11:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 26/11/2022 11:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 26/11/2022 11:52:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '18880' , 'COPRILEGGIO MORELLO' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 26/11/2022 11:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '18880' AND id_supplier = '' 26/11/2022 11:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18880' , '' , '1' ) 26/11/2022 11:54:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3628' AND id_document != '74897' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 26/11/2022 11:54:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3628', document_date = '2022-11-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 = '215.00', price_tax_excluded = '176.23', date_upd = NOW() WHERE id_document = '74897' 26/11/2022 11:54: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 = '74897' 26/11/2022 11:54:08 am >> DELETE FROM ps_document_detail WHERE id_document = '74897' 26/11/2022 11:54: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 ( '74897' , '13506' , 'SANTO ROSARIO' , '60' , '-60' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '18.00' ) 26/11/2022 11:54:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = '' 26/11/2022 11:54:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' ) 26/11/2022 11:54: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 ( '74897' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 26/11/2022 11:54:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 26/11/2022 11:54:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 26/11/2022 11:54: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 ( '74897' , '13363' , 'CORONA MM 6 ' , '60' , '-60' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '174.00' ) 26/11/2022 11:54:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '13363' AND id_supplier = '' 26/11/2022 11:54:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13363' , '' , '1' ) 26/11/2022 11:54:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '13365' , 'SCATOLA 6x4' , '60' , '-60' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '15.00' ) 26/11/2022 11:54:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '13365' AND id_supplier = '' 26/11/2022 11:54:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13365' , '' , '1' ) 26/11/2022 11:54:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 26/11/2022 11:54:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '20089' AND id_supplier = '' 26/11/2022 11:54:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20089' , '' , '1' ) 26/11/2022 12:02:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '104/A' AND id_document != '74908' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 12:02:42 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '104/A', document_date = '2022-11-26', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', 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 = '320.00', price_tax_excluded = '269.58', date_upd = NOW() WHERE id_document = '74908' 26/11/2022 12:02:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74908' 26/11/2022 12:02:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '74908' 26/11/2022 12:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '7' , '-7' , '4' , '3.0000' , '3' , '0' , '5' , '19.95' ) 26/11/2022 12:02:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1833' AND id_supplier = '' 26/11/2022 12:02:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1833' , '' , '1' ) 26/11/2022 12:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 26/11/2022 12:02:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 26/11/2022 12:02:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 26/11/2022 12:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '7673' , 'PARTICOLE MM38' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 26/11/2022 12:02:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 26/11/2022 12:02:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 26/11/2022 12:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 26/11/2022 12:02:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = '' 26/11/2022 12:02:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' ) 26/11/2022 12:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 26/11/2022 12:02:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 26/11/2022 12:02:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 26/11/2022 12:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '9241' , 'SACC. 100 PZ MICCIA PER ACCENDERE STREGA ' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/11/2022 12:02:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9241' AND id_supplier = '' 26/11/2022 12:02:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9241' , '' , '1' ) 26/11/2022 12:02:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '200' , '-200' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '80.00' ) 26/11/2022 12:02:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 26/11/2022 12:02:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 26/11/2022 12:02:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/11/2022 12:02:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 26/11/2022 12:02:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 26/11/2022 12:02:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74908' , '18880' , 'COPRILEGGIO MORELLO' , '1' , '-1' , '1' , '61.65' , '50.532786885246' , '22' , '0' , '61.65' ) 26/11/2022 12:02:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18880' AND id_supplier = '' 26/11/2022 12:02:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18880' , '' , '1' ) 26/11/2022 12:03:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 12:03: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 ( '24' , '105/A' , '2022-11-26' , 'A' , '1656' , '0' , '4677544' , 'VIA NAZIONALE 84060 OMIGNANO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '150.00' , NOW() , NOW() ) 26/11/2022 12:03: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 = '74910' 26/11/2022 12:03:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '74910' 26/11/2022 12:03: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 ( '74910' , '' , 'GESU\' BAMBINO CON CAMPANA' , '1' , '-1' , '0' , '150' , '150' , '' , '0' , '150.00' ) 26/11/2022 12:06:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '103/A' AND id_document != '74907' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 12:06:06 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '103/A', document_date = '2022-11-26', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', 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 = '385.33', price_tax_excluded = '385.33', date_upd = NOW() WHERE id_document = '74907' 26/11/2022 12:06: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 = '74907' 26/11/2022 12:06:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '74907' 26/11/2022 12:06: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 ( '74907' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 26/11/2022 12:06:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 26/11/2022 12:06:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 26/11/2022 12:06: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 ( '74907' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 26/11/2022 12:06:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 26/11/2022 12:06:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 26/11/2022 12:06: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 ( '74907' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 26/11/2022 12:06:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 26/11/2022 12:06:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 26/11/2022 12:06: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 ( '74907' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 26/11/2022 12:06:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 26/11/2022 12:06:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 26/11/2022 12:06: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 ( '74907' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '15' , '76.50' ) 26/11/2022 12:06:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 26/11/2022 12:06:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 26/11/2022 12:06: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 ( '74907' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 26/11/2022 12:06:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8409' AND id_supplier = '' 26/11/2022 12:06:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8409' , '' , '1' ) 26/11/2022 12:06: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 ( '74907' , '14649' , 'COMPENDIO AL CATECHISMO DI PIO X' , '30' , '-30' , '4' , '1.60' , '1.6' , '0' , '10' , '43.20' ) 26/11/2022 12:06:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14649' AND id_supplier = '' 26/11/2022 12:06:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14649' , '' , '1' ) 26/11/2022 12:06:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74907' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 26/11/2022 12:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 26/11/2022 12:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 26/11/2022 12:06:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74907' , '4120' , 'FEDE NELLO ZAINETTO' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '15' , '42.50' ) 26/11/2022 12:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 26/11/2022 12:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 26/11/2022 12:18:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3638' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 12:18:48 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' , '3638' , '2022-11-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '182.73' , NOW() , NOW() ) 26/11/2022 12:18:48 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 = '74911' 26/11/2022 12:18:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '74911' 26/11/2022 12:18:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '100' , '-100' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '20.00' ) 26/11/2022 12:18:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '' 26/11/2022 12:18:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '' , '1' ) 26/11/2022 12:18:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 26/11/2022 12:18:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 26/11/2022 12:18:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 26/11/2022 12:18:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 26/11/2022 12:18:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14362' AND id_supplier = '' 26/11/2022 12:18:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14362' , '' , '1' ) 26/11/2022 12:18:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 26/11/2022 12:18:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '' 26/11/2022 12:18:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '' , '1' ) 26/11/2022 12:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '100' , '0.00' ) 26/11/2022 12:18:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19911' AND id_supplier = '' 26/11/2022 12:18:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19911' , '' , '1' ) 26/11/2022 12:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '19923' , 'AGENDA LITURGICO PASTORALE 2023 - 40807' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 26/11/2022 12:18:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19923' AND id_supplier = '' 26/11/2022 12:18:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19923' , '' , '1' ) 26/11/2022 12:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '18962' , 'POLO MISTO VISCOSA ML ' , '1' , '-1' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '50.00' ) 26/11/2022 12:18:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18962' AND id_supplier = '' 26/11/2022 12:18:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18962' , '' , '1' ) 26/11/2022 12:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '20301' , 'CREDIAMO - LE PRINCIPALI VERITA DI FEDE' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 26/11/2022 12:18:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20301' AND id_supplier = '' 26/11/2022 12:18:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20301' , '' , '1' ) 26/11/2022 12:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '14473' , 'TU SEI CRISTIANO? - A. FONTANA' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 26/11/2022 12:18:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14473' AND id_supplier = '' 26/11/2022 12:18:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14473' , '' , '1' ) 26/11/2022 12:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '11379' , 'VIENI SPIRITO SANTO - 35 ' , '25' , '-25' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '3.75' ) 26/11/2022 12:18:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11379' AND id_supplier = '' 26/11/2022 12:18:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11379' , '' , '1' ) 26/11/2022 12:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74911' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '1.55' , '1.2704918032787' , '22' , '0' , '1.55' ) 26/11/2022 12:18:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 26/11/2022 12:18:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 26/11/2022 12:20:48 pm >> DELETE FROM ps_document WHERE id_document = '74910' 26/11/2022 12:20:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '74910' 26/11/2022 12:20:56 pm >> DELETE FROM ps_document WHERE id_document = '74907' 26/11/2022 12:20:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '74907' 26/11/2022 12:21:11 pm >> DELETE FROM ps_document WHERE id_document = '74908' 26/11/2022 12:21:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '74908' 26/11/2022 12:25:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3497' AND id_document != '73178' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-18') 26/11/2022 12:25:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3497', document_date = '2022-11-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.40', price_tax_excluded = '8.40', date_upd = NOW() WHERE id_document = '73178' 26/11/2022 12:25:00 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 = '73178' 26/11/2022 12:25:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '73178' 26/11/2022 12:25:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73178' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '40' , '-40' , '4' , '0.0300' , '0.03' , '0' , '0' , '1.20' ) 26/11/2022 12:25:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 26/11/2022 12:25:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 26/11/2022 12:25:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73178' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '2' , '-2' , '4' , '3.6' , '3.6' , '0' , '0' , '7.20' ) 26/11/2022 12:25:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 26/11/2022 12:25:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 26/11/2022 12:25:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3497' AND id_document != '73178' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-18') 26/11/2022 12:25:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3497', document_date = '2022-11-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.40', price_tax_excluded = '8.40', date_upd = NOW() WHERE id_document = '73178' 26/11/2022 12:25:36 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 = '73178' 26/11/2022 12:25:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '73178' 26/11/2022 12:25:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73178' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '40' , '-40' , '4' , '0.0300' , '0.03' , '0' , '0' , '1.20' ) 26/11/2022 12:25:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 26/11/2022 12:25:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 26/11/2022 12:25:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73178' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.2' , '7.2' , '0' , '0' , '7.20' ) 26/11/2022 12:25:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 26/11/2022 12:25:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 26/11/2022 12:26:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2959' AND id_document != '65200' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 26/11/2022 12:26:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2959', document_date = '2022-10-07', 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 = '38.00', price_tax_excluded = '31.15', date_upd = NOW() WHERE id_document = '65200' 26/11/2022 12:26:23 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 = '65200' 26/11/2022 12:26:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '65200' 26/11/2022 12:26:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65200' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 26/11/2022 12:26:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = '' 26/11/2022 12:26:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' ) 26/11/2022 12:27:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3496' AND id_document != '73177' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-18') 26/11/2022 12:27:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3496', document_date = '2022-11-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '125.00', price_tax_excluded = '112.38', date_upd = NOW() WHERE id_document = '73177' 26/11/2022 12:27: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 = '73177' 26/11/2022 12:27:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '73177' 26/11/2022 12:27: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 ( '73177' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 26/11/2022 12:27:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 26/11/2022 12:27:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 26/11/2022 12:27: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 ( '73177' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13.6' , '11.147540983607' , '22' , '0' , '13.60' ) 26/11/2022 12:27:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 26/11/2022 12:27:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 26/11/2022 12:27: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 ( '73177' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '1800' , '-1800' , '4' , '0.0300' , '0.03' , '0' , '0' , '54.00' ) 26/11/2022 12:27:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 26/11/2022 12:27:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 26/11/2022 12:27: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 ( '73177' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/11/2022 12:27:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 26/11/2022 12:27:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 26/11/2022 12:28:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3509' AND id_document != '73195' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-18') 26/11/2022 12:28:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3509', document_date = '2022-11-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '73195' 26/11/2022 12:28: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 = '73195' 26/11/2022 12:28:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '73195' 26/11/2022 12:28: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 ( '73195' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 26/11/2022 12:28:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 26/11/2022 12:28:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 26/11/2022 12:28: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 ( '73195' , '9241' , 'SACC. 100 PZ MICCIA PER ACCENDERE STREGA ' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/11/2022 12:28:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9241' AND id_supplier = '' 26/11/2022 12:28:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9241' , '' , '1' ) 26/11/2022 12:28:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3509' AND id_document != '73195' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-18') 26/11/2022 12:28:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3509', document_date = '2022-11-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '73195' 26/11/2022 12:28:51 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 = '73195' 26/11/2022 12:28:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '73195' 26/11/2022 12:28: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 ( '73195' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 26/11/2022 12:28:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 26/11/2022 12:28:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 26/11/2022 12:28: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 ( '73195' , '9241' , 'SACC. 100 PZ MICCIA PER ACCENDERE STREGA ' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/11/2022 12:28:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9241' AND id_supplier = '' 26/11/2022 12:28:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9241' , '' , '1' ) 26/11/2022 12:30:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '4386' AND id_document != '49906' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2021-12-28') 26/11/2022 12:30:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4386', document_date = '2021-12-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.00', price_tax_excluded = '25.33', date_upd = NOW() WHERE id_document = '49906' 26/11/2022 12:30:30 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 = '49906' 26/11/2022 12:30:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '49906' 26/11/2022 12:30:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '49906' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '2.7' , '2.5961538461538' , '4' , '0' , '5.40' ) 26/11/2022 12:30:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 26/11/2022 12:30:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 26/11/2022 12:30:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '49906' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 26/11/2022 12:30:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 26/11/2022 12:30:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 26/11/2022 12:30:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '49906' , '18927' , 'PAROLA E PREGHIERA - FEB 2022' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 26/11/2022 12:30:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18927' AND id_supplier = '' 26/11/2022 12:30:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18927' , '' , '1' ) 26/11/2022 12:30:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '49906' , '19080' , 'PAROLA E PREGHIERA - MAR 2022' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 26/11/2022 12:30:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19080' AND id_supplier = '' 26/11/2022 12:30:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19080' , '' , '1' ) 26/11/2022 12:30:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '49906' , '18829' , 'PAROLA E PREGHIERA - GEN. 2022' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 26/11/2022 12:30:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18829' AND id_supplier = '' 26/11/2022 12:30:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18829' , '' , '1' ) 26/11/2022 12:30:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '49906' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 26/11/2022 12:30:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 26/11/2022 12:30:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 26/11/2022 12:32:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3492' AND id_document != '73172' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 26/11/2022 12:32:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3492', document_date = '2022-11-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 = '129.80', price_tax_excluded = '113.24', date_upd = NOW() WHERE id_document = '73172' 26/11/2022 12:32: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 = '73172' 26/11/2022 12:32:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '73172' 26/11/2022 12:32: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 ( '73172' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 26/11/2022 12:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 26/11/2022 12:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 26/11/2022 12:32: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 ( '73172' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 26/11/2022 12:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 26/11/2022 12:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 26/11/2022 12:32: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 ( '73172' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 26/11/2022 12:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 26/11/2022 12:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 26/11/2022 12:32: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 ( '73172' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 26/11/2022 12:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 26/11/2022 12:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 26/11/2022 12:32: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 ( '73172' , '5854' , 'LIBRO DELLE NOVENE N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '5' , '28.50' ) 26/11/2022 12:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5854' AND id_supplier = '' 26/11/2022 12:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5854' , '' , '1' ) 26/11/2022 12:32: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 ( '73172' , '20108' , 'AVVENTO 2022' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 26/11/2022 12:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20108' AND id_supplier = '' 26/11/2022 12:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20108' , '' , '1' ) 26/11/2022 12:32: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 ( '73172' , '19873' , 'CROCE CM 25 TOPAZIO - 3726/789' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 26/11/2022 12:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19873' AND id_supplier = '' 26/11/2022 12:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19873' , '' , '1' ) 26/11/2022 12:33:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3523' AND id_document != '73726' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-19') 26/11/2022 12:33:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3523', document_date = '2022-11-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 = '27.00', price_tax_excluded = '22.13', date_upd = NOW() WHERE id_document = '73726' 26/11/2022 12:33: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 = '73726' 26/11/2022 12:33:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '73726' 26/11/2022 12:33: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 ( '73726' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '90' , '-90' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '27.00' ) 26/11/2022 12:33:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 26/11/2022 12:33:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 26/11/2022 12:34:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3544' AND id_document != '74276' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-22') 26/11/2022 12:34:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3544', document_date = '2022-11-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '251.90', price_tax_excluded = '216.19', date_upd = NOW() WHERE id_document = '74276' 26/11/2022 12:34:02 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 = '74276' 26/11/2022 12:34:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '74276' 26/11/2022 12:34:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '8197' , 'PORTATECA - 059' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 26/11/2022 12:34:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8197' AND id_supplier = '' 26/11/2022 12:34:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8197' , '' , '1' ) 26/11/2022 12:34:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '18045' , 'TECA INCISA - 515' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '' , '28.00' ) 26/11/2022 12:34:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18045' AND id_supplier = '' 26/11/2022 12:34:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18045' , '' , '1' ) 26/11/2022 12:34:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '11154' , 'VASETTO BASSO CON ANELLO - 820' , '1' , '-1' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '17.00' ) 26/11/2022 12:34:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11154' AND id_supplier = '' 26/11/2022 12:34:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11154' , '' , '1' ) 26/11/2022 12:34:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '17.00' ) 26/11/2022 12:34:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 26/11/2022 12:34:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 26/11/2022 12:34:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '7673' , 'PARTICOLE MM38' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 26/11/2022 12:34:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 26/11/2022 12:34:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 26/11/2022 12:34:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '5.70' ) 26/11/2022 12:34:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 26/11/2022 12:34:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 26/11/2022 12:34:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '960' , '-960' , '4' , '0.0400' , '0.04' , '0' , '0' , '38.40' ) 26/11/2022 12:34:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 26/11/2022 12:34:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 26/11/2022 12:34:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '17520' , 'LUMINO SMERALDO' , '30' , '-30' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '12.00' ) 26/11/2022 12:34:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17520' AND id_supplier = '' 26/11/2022 12:34:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17520' , '' , '1' ) 26/11/2022 12:34:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 26/11/2022 12:34:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2436' AND id_supplier = '' 26/11/2022 12:34:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2436' , '' , '1' ) 26/11/2022 12:34:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 26/11/2022 12:34:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 26/11/2022 12:34:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 26/11/2022 12:34:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 26/11/2022 12:34:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 26/11/2022 12:34:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 26/11/2022 12:34:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '13079' , 'COPPIA CANDELIERI IN LEGNO - 033' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 26/11/2022 12:34:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13079' AND id_supplier = '' 26/11/2022 12:34:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13079' , '' , '1' ) 26/11/2022 12:34:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '6011' , 'LUMINELLO VETRO - 474/25' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 26/11/2022 12:34:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6011' AND id_supplier = '' 26/11/2022 12:34:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6011' , '' , '1' ) 26/11/2022 12:34:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '90' , '-90' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '27.00' ) 26/11/2022 12:34:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 26/11/2022 12:34:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 26/11/2022 12:34:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3583' AND id_document != '74839' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-24') 26/11/2022 12:34:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3583', document_date = '2022-11-24', 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 = '84.00', price_tax_excluded = '68.85', date_upd = NOW() WHERE id_document = '74839' 26/11/2022 12:34: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 = '74839' 26/11/2022 12:34:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '74839' 26/11/2022 12:34:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74839' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 26/11/2022 12:34:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 26/11/2022 12:34:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 26/11/2022 12:34:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74839' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '50' , '-50' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '20.00' ) 26/11/2022 12:34:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 26/11/2022 12:34:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 26/11/2022 12:34:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74839' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '50' , '-50' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '10.00' ) 26/11/2022 12:34:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18618' AND id_supplier = '' 26/11/2022 12:34:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18618' , '' , '1' ) 26/11/2022 12:34:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74839' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 26/11/2022 12:34:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 26/11/2022 12:34:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 26/11/2022 12:34:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74839' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 26/11/2022 12:34:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 26/11/2022 12:34:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 26/11/2022 12:36:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3566' AND id_document != '74815' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 26/11/2022 12:36:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3566', document_date = '2022-11-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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '74815' 26/11/2022 12:36:23 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 = '74815' 26/11/2022 12:36:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '74815' 26/11/2022 12:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74815' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3' , '2.4590163934426' , '22' , '0' , '9.00' ) 26/11/2022 12:36:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 26/11/2022 12:36:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 26/11/2022 12:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74815' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 26/11/2022 12:36:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 26/11/2022 12:36:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 26/11/2022 12:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74815' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '5' , '-5' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '1.00' ) 26/11/2022 12:36:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 26/11/2022 12:36:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 26/11/2022 12:36:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3417' AND id_document != '71516' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-11') 26/11/2022 12:36:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3417', document_date = '2022-11-11', 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 = '325.00', price_tax_excluded = '271.53', date_upd = NOW() WHERE id_document = '71516' 26/11/2022 12:36:51 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 = '71516' 26/11/2022 12:36:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '71516' 26/11/2022 12:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71516' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '1.0000' , '1' , '0' , '0' , '3.00' ) 26/11/2022 12:36:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 26/11/2022 12:36:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 26/11/2022 12:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71516' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '9.50' ) 26/11/2022 12:36:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 26/11/2022 12:36:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 26/11/2022 12:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71516' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/11/2022 12:36:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 26/11/2022 12:36:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 26/11/2022 12:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71516' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/11/2022 12:36:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 26/11/2022 12:36:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 26/11/2022 12:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71516' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 26/11/2022 12:36:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 26/11/2022 12:36:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 26/11/2022 12:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71516' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 26/11/2022 12:36:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 26/11/2022 12:36:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 26/11/2022 12:36: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 ( '71516' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '100' , '0.00' ) 26/11/2022 12:36:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19911' AND id_supplier = '' 26/11/2022 12:36:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19911' , '' , '1' ) 26/11/2022 12:36: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 ( '71516' , '18880' , 'COPRILEGGIO MORELLO' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 26/11/2022 12:36:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18880' AND id_supplier = '' 26/11/2022 12:36:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18880' , '' , '1' ) 26/11/2022 12:36: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 ( '71516' , '16461' , 'CLERGY NIDO D\'APE ML - C 22' , '1' , '-1' , '1' , '52.1000' , '42.704918032787' , '22' , '0' , '52.10' ) 26/11/2022 12:36:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16461' AND id_supplier = '' 26/11/2022 12:36:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16461' , '' , '1' ) 26/11/2022 12:36: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 ( '71516' , '15648' , 'CLERGY CELESTE - 100% - 43 - 160/10' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 26/11/2022 12:36:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15648' AND id_supplier = '' 26/11/2022 12:36:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15648' , '' , '1' ) 26/11/2022 12:36: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 ( '71516' , '20329' , 'GIOCARE CON DIO - ALBINO LUCIANI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '' , '18.00' ) 26/11/2022 12:36:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20329' AND id_supplier = '' 26/11/2022 12:36:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20329' , '' , '1' ) 26/11/2022 01:03:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '103/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 26/11/2022 01:03:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '103/A' , '2022-11-26' , 'A' , '371' , '0' , '4670910' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , 'parrocchia' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.50' , '23.50' , NOW() , NOW() ) 26/11/2022 01:03: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 = '74912' 26/11/2022 01:03:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '74912' 26/11/2022 01:03: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 ( '74912' , '' , 'candele' , '1' , '-1' , '0' , '23.5' , '23.5' , '' , '0' , '23.50' )