30/07/2022 09:09:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '50074' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-01-12') 30/07/2022 09:09:45 am >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2022-01-12', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 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 = '72.80', price_tax_excluded = '72.80', date_upd = NOW() WHERE id_document = '50074' 30/07/2022 09:09:45 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 = '50074' 30/07/2022 09:09:45 am >> DELETE FROM ps_document_detail WHERE id_document = '50074' 30/07/2022 09:09:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19686' , 'PAROLA E PREGHIERA - SET 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 30/07/2022 09:09:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19686' AND id_supplier = '' 30/07/2022 09:09:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19686' , '' , '1' ) 30/07/2022 09:09:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19741' , 'PARLARE CON DIO - J. MARTIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 30/07/2022 09:09:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19741' AND id_supplier = '' 30/07/2022 09:09:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19741' , '' , '1' ) 30/07/2022 09:09:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19850' , 'CANTO DI BERNADETTE' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 30/07/2022 09:09:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19850' AND id_supplier = '' 30/07/2022 09:09:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19850' , '' , '1' ) 30/07/2022 09:09:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19837' , 'ABBANDONATEVI A CRISTO - F. SHEEN' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 30/07/2022 09:09:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19837' AND id_supplier = '' 30/07/2022 09:09:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19837' , '' , '1' ) 30/07/2022 09:34:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2407' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-30') 30/07/2022 09:34:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2407' , '2022-07-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 30/07/2022 09:34: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 = '59860' 30/07/2022 09:34:08 am >> DELETE FROM ps_document_detail WHERE id_document = '59860' 30/07/2022 09:34: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 ( '59860' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 30/07/2022 09:34:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '1425' AND id_supplier = '' 30/07/2022 09:34:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1425' , '' , '1' ) 30/07/2022 09:43:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2408' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-30') 30/07/2022 09:43: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' , '2408' , '2022-07-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 30/07/2022 09:43: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 = '59861' 30/07/2022 09:43:54 am >> DELETE FROM ps_document_detail WHERE id_document = '59861' 30/07/2022 09:43: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 ( '59861' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 30/07/2022 09:43:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 30/07/2022 09:43:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 30/07/2022 09:48:57 am >> SELECT document_num FROM ps_document WHERE document_num = '57/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-30') 30/07/2022 09:48:57 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' , '57/A' , '2022-07-30' , 'A' , '3030' , '0' , '4671709' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 30/07/2022 09:48:57 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 = '59862' 30/07/2022 09:48:57 am >> DELETE FROM ps_document_detail WHERE id_document = '59862' 30/07/2022 09:48: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 ( '59862' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 30/07/2022 10:25:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2409' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-30') 30/07/2022 10:25:56 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' , '2409' , '2022-07-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 30/07/2022 10:25: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 = '59863' 30/07/2022 10:25:56 am >> DELETE FROM ps_document_detail WHERE id_document = '59863' 30/07/2022 10:25: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 ( '59863' , '10501' , 'TECA STANDARD IHS ' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 30/07/2022 10:25:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '10501' AND id_supplier = '' 30/07/2022 10:25:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10501' , '' , '1' ) 30/07/2022 11:12:00 am >> SELECT document_num FROM ps_document WHERE document_num = '58/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-30') 30/07/2022 11:12:00 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' , '58/A' , '2022-07-30' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '240.00' , '196.72' , NOW() , NOW() ) 30/07/2022 11:12:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59864' 30/07/2022 11:12:00 am >> DELETE FROM ps_document_detail WHERE id_document = '59864' 30/07/2022 11:12:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59864' , '19214' , 'CAMICE AVORIO COREANA MISTO COT.- 70/003698' , '1' , '-1' , '1' , '165.00' , '135.24590163934' , '22' , '0' , '165.00' ) 30/07/2022 11:12:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59864' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 30/07/2022 11:12:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59864' , '19818' , 'INCENSO NATURALE 3A KG 1' , '2' , '-2' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '46.00' ) 30/07/2022 11:25:24 am >> SELECT document_num FROM ps_document WHERE document_num = '106' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-07-30') 30/07/2022 11:25:24 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 ( '21' , '106' , '2022-07-30' , '' , '3549' , '0' , '4671010' , 'PIAZZA SAN MARCO 03037 PONTECORVO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.80' , '65.54' , NOW() , NOW() ) 30/07/2022 11:25:24 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 = '59865' 30/07/2022 11:25:24 am >> DELETE FROM ps_document_detail WHERE id_document = '59865' 30/07/2022 11:25:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59865' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '22.80' ) 30/07/2022 11:25:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59865' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 30/07/2022 11:25:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59865' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '45.00' ) 30/07/2022 11:26:59 am >> DELETE FROM ps_document WHERE id_document = '59865' 30/07/2022 11:26:59 am >> DELETE FROM ps_document_detail WHERE id_document = '59865' 30/07/2022 11:28:23 am >> SELECT document_num FROM ps_document WHERE document_num = '59/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-30') 30/07/2022 11:28:23 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' , '59/A' , '2022-07-30' , 'A' , '3549' , '0' , '4671010' , 'PIAZZA SAN MARCO 03037 PONTECORVO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '61.60' , NOW() , NOW() ) 30/07/2022 11:28:23 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 = '59866' 30/07/2022 11:28:23 am >> DELETE FROM ps_document_detail WHERE id_document = '59866' 30/07/2022 11:28:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59866' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '22.80' ) 30/07/2022 11:28:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59866' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 30/07/2022 11:28:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59866' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 30/07/2022 11:28:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59866' , '' , 'sconto' , '1' , '-1' , '1' , '-4.8' , '-3.9344262295082' , '22' , '0' , '-4.80' ) 30/07/2022 11:30:49 am >> SELECT document_num FROM ps_document WHERE document_num = '58/A' AND id_document != '59864' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-30') 30/07/2022 11:30:49 am >> UPDATE ps_document SET id_document_type = '24', document_num = '58/A', document_date = '2022-07-30', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '378.00', price_tax_excluded = '309.84', date_upd = NOW() WHERE id_document = '59864' 30/07/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 = '59864' 30/07/2022 11:30:49 am >> DELETE FROM ps_document_detail WHERE id_document = '59864' 30/07/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 ( '59864' , '19214' , 'CAMICE AVORIO COREANA MISTO COT.- 70/003698' , '1' , '-1' , '1' , '165.0000' , '135.24590163934' , '22' , '0' , '165.00' ) 30/07/2022 11:30:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19214' AND id_supplier = '' 30/07/2022 11:30:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19214' , '' , '1' ) 30/07/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 ( '59864' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 30/07/2022 11:30:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 30/07/2022 11:30:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 30/07/2022 11:30: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 ( '59864' , '19818' , 'INCENSO NATURALE 3A KG 1' , '2' , '-2' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '46.00' ) 30/07/2022 11:30:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 30/07/2022 11:30:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 30/07/2022 11:30: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 ( '59864' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '138.00' , '113.11475409836' , '22' , '0' , '138.00' ) 30/07/2022 11:30:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '17408' AND id_supplier = '' 30/07/2022 11:30:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17408' , '' , '1' ) 30/07/2022 11:50:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2306' AND id_document != '59733' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-19') 30/07/2022 11:50:10 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2306', document_date = '2022-07-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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '59733' 30/07/2022 11:50:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59733' 30/07/2022 11:50:10 am >> DELETE FROM ps_document_detail WHERE id_document = '59733' 30/07/2022 11:50:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59733' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/07/2022 11:50:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/07/2022 11:50:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/07/2022 11:50:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59733' , '19818' , 'INCENSO NATURALE 3A KG 1' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 30/07/2022 11:50:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 30/07/2022 11:50:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 30/07/2022 11:51:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1529' AND id_document != '57269' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-14') 30/07/2022 11:51:03 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1529', document_date = '2022-05-14', 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 = '33.50', price_tax_excluded = '29.17', date_upd = NOW() WHERE id_document = '57269' 30/07/2022 11:51:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57269' 30/07/2022 11:51:03 am >> DELETE FROM ps_document_detail WHERE id_document = '57269' 30/07/2022 11:51:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57269' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 30/07/2022 11:51:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '13034' AND id_supplier = '' 30/07/2022 11:51:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13034' , '' , '1' ) 30/07/2022 11:51:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57269' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 30/07/2022 11:51:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 30/07/2022 11:51:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 30/07/2022 11:53:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1551' AND id_document != '57806' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-17') 30/07/2022 11:53:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1551', document_date = '2022-05-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 = '435.00', price_tax_excluded = '356.56', date_upd = NOW() WHERE id_document = '57806' 30/07/2022 11:53: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 = '57806' 30/07/2022 11:53:21 am >> DELETE FROM ps_document_detail WHERE id_document = '57806' 30/07/2022 11:53: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 ( '57806' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 30/07/2022 11:53:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '' 30/07/2022 11:53:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '' , '1' ) 30/07/2022 11:53: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 ( '57806' , '18282' , 'CINGOLO - CING05ORO' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 30/07/2022 11:53:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '18282' AND id_supplier = '' 30/07/2022 11:53:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18282' , '' , '1' ) 30/07/2022 11:53: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 ( '57806' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '130.0000' , '106.55737704918' , '22' , '0' , '130.00' ) 30/07/2022 11:53:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '17408' AND id_supplier = '' 30/07/2022 11:53:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17408' , '' , '1' ) 30/07/2022 11:53: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 ( '57806' , '16068' , 'CAMICE PIEGONI 2 INSERTI - AECM17B05' , '1' , '-1' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 30/07/2022 11:53:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '16068' AND id_supplier = '' 30/07/2022 11:53:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16068' , '' , '1' ) 30/07/2022 11:53: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 ( '57806' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '7' , '-7' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '23.10' ) 30/07/2022 11:53:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 30/07/2022 11:53:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 30/07/2022 11:53: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 ( '57806' , '19214' , 'CAMICE AVORIO COREANA MISTO COT.- 70/003698' , '1' , '-1' , '1' , '143.4' , '117.54098360656' , '22' , '0' , '143.40' ) 30/07/2022 11:53:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19214' AND id_supplier = '' 30/07/2022 11:53:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19214' , '' , '1' ) 30/07/2022 11:54:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1942' AND id_document != '58786' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 30/07/2022 11:54:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1942', document_date = '2022-06-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '258.00', price_tax_excluded = '211.48', date_upd = NOW() WHERE id_document = '58786' 30/07/2022 11:54: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 = '58786' 30/07/2022 11:54:13 am >> DELETE FROM ps_document_detail WHERE id_document = '58786' 30/07/2022 11:54: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 ( '58786' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '2' , '-2' , '1' , '69.9000' , '57.295081967213' , '22' , '0' , '139.80' ) 30/07/2022 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17101' AND id_supplier = '' 30/07/2022 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17101' , '' , '1' ) 30/07/2022 11:54: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 ( '58786' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '118.2' , '96.885245901639' , '22' , '0' , '118.20' ) 30/07/2022 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17408' AND id_supplier = '' 30/07/2022 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17408' , '' , '1' ) 30/07/2022 11:54:29 am >> DELETE FROM ps_document WHERE id_document = '59864' 30/07/2022 11:54:29 am >> DELETE FROM ps_document_detail WHERE id_document = '59864' 30/07/2022 12:22:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2410' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-30') 30/07/2022 12:22: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 ( '11' , '2410' , '2022-07-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '68.85' , NOW() , NOW() ) 30/07/2022 12:22: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 = '59867' 30/07/2022 12:22:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '59867' 30/07/2022 12:22: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 ( '59867' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '38' , '31.147540983607' , '22' , '0' , '76.00' ) 30/07/2022 12:22:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/07/2022 12:22:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/07/2022 12:22: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 ( '59867' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 30/07/2022 12:22:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/07/2022 12:22:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/07/2022 12:51:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2411' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-30') 30/07/2022 12:51:10 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' , '2411' , '2022-07-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '140.03' , NOW() , NOW() ) 30/07/2022 12:51:10 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 = '59868' 30/07/2022 12:51:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '59868' 30/07/2022 12:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59868' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 30/07/2022 12:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/07/2022 12:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/07/2022 12:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59868' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '151.2' , '123.93442622951' , '22' , '0' , '151.20' ) 30/07/2022 12:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/07/2022 12:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/07/2022 12:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59868' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 30/07/2022 12:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 30/07/2022 12:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 30/07/2022 12:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59868' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 30/07/2022 12:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 30/07/2022 12:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' )