17/06/2023 09:03:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2094' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-17') 17/06/2023 09:03:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2094' , '2023-06-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.70' , '6.31' , NOW() , NOW() ) 17/06/2023 09:03:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86398' 17/06/2023 09:03:05 am >> DELETE FROM ps_document_detail WHERE id_document = '86398' 17/06/2023 09:03:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86398' , '19560' , 'PERGAMENA 17X25' , '11' , '-11' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.70' ) 17/06/2023 10:49:52 am >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '75504' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-01') 17/06/2023 10:49:52 am >> UPDATE ps_document SET id_document_type = '24', document_num = '105/A', document_date = '2022-12-01', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = 'sordina ACC- 200,00 - 27/12 € 200,00 + € 100 20/3/23 + 300,00 17/06/23', 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 = '2700.00', price_tax_excluded = '2700.00', date_upd = NOW() WHERE id_document = '75504' 17/06/2023 10:49:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75504' 17/06/2023 10:49:52 am >> DELETE FROM ps_document_detail WHERE id_document = '75504' 17/06/2023 10:49:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '7306' , 'OSTENSORIO - OTTONE BAGNO ORO ' , '1' , '-1' , '0' , '2700.0000' , '2700' , '' , '0' , '2700.00' ) 17/06/2023 10:49:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '0' , 'ACCONTO 220€' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/06/2023 10:49:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '0' , 'acconto € 200 27/12/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/06/2023 10:49:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '0' , 'acconto € 100,00 20/03/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/06/2023 10:49:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '' , 'acconto € 300,00 - 17/06/2023' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 17/06/2023 10:51:49 am >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '75504' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-01') 17/06/2023 10:51:49 am >> UPDATE ps_document SET id_document_type = '24', document_num = '105/A', document_date = '2022-12-01', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = 'sordina ACC- 200,00 - 27/12 € 200,00 + € 100 20/3/23 + 300,00 17/06/23', 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 = '2700.00', price_tax_excluded = '2213.11', date_upd = NOW() WHERE id_document = '75504' 17/06/2023 10:51: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 = '75504' 17/06/2023 10:51:49 am >> DELETE FROM ps_document_detail WHERE id_document = '75504' 17/06/2023 10:51: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 ( '75504' , '7306' , 'OSTENSORIO - OTTONE BAGNO ORO ' , '1' , '-1' , '1' , '2700.0000' , '2213.1147540984' , '22' , '0' , '2700.00' ) 17/06/2023 10:51: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 ( '75504' , '0' , 'ACCONTO 220€' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/06/2023 10:51: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 ( '75504' , '0' , 'acconto € 200 27/12/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/06/2023 10:51: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 ( '75504' , '0' , 'acconto € 100,00 20/03/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/06/2023 10:51: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 ( '75504' , '0' , 'acconto € 300,00 - 17/06/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/06/2023 11:17:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2095' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-17') 17/06/2023 11:17:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2095' , '2023-06-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 17/06/2023 11:17:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86399' 17/06/2023 11:17:17 am >> DELETE FROM ps_document_detail WHERE id_document = '86399' 17/06/2023 11:17:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86399' , '19600' , 'ROSARIO SPIRITO SANTO' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 17/06/2023 11:27:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2096' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-17') 17/06/2023 11:27:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2096' , '2023-06-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.90' , '24.51' , NOW() , NOW() ) 17/06/2023 11:27:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86400' 17/06/2023 11:27:11 am >> DELETE FROM ps_document_detail WHERE id_document = '86400' 17/06/2023 11:27:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86400' , '20707' , 'LUME LEGNO' , '1' , '-1' , '1' , '29.90' , '24.508196721311' , '22' , '0' , '29.90' ) 17/06/2023 11:30:33 am >> SELECT document_num FROM ps_document WHERE document_num = '977' AND id_document != '82471' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 17/06/2023 11:30:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '977', document_date = '2023-03-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 = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '82471' 17/06/2023 11:30:33 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 = '82471' 17/06/2023 11:30:33 am >> DELETE FROM ps_document_detail WHERE id_document = '82471' 17/06/2023 11:30:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82471' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13.5' , '11.065573770492' , '22' , '0' , '13.50' ) 17/06/2023 11:30:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82471' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.5000' , '29.918032786885' , '22' , '0' , '36.50' ) 17/06/2023 11:30:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82471' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 17/06/2023 11:46:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2097' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-17') 17/06/2023 11:46:16 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' , '2097' , '2023-06-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 17/06/2023 11:46:16 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 = '86401' 17/06/2023 11:46:16 am >> DELETE FROM ps_document_detail WHERE id_document = '86401' 17/06/2023 11:46:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86401' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 17/06/2023 12:13:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-17') 17/06/2023 12:13:18 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' , '68/A' , '2023-06-17' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '118.40' , '97.83' , NOW() , NOW() ) 17/06/2023 12:13:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86402' 17/06/2023 12:13:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '86402' 17/06/2023 12:13:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86402' , '19311' , 'BRACCIALE MADREPERLA COMUNIONE - 1906/K126' , '17' , '-17' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '47.60' ) 17/06/2023 12:13:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86402' , '20516' , 'CROCE COMUNIONE - 42/08' , '16' , '-16' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '20.80' ) 17/06/2023 12:13:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86402' , '15028' , 'ROSARIO CRISTALLO E ARGENTO - 17800' , '1' , '-1' , '1' , '14.50' , '11.885245901639' , '22' , '0' , '14.50' ) 17/06/2023 12:13:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86402' , '15097' , 'CORONA MATRIMONIO - ORO' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 17/06/2023 12:13:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86402' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 17/06/2023 12:13:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86402' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 17/06/2023 12:31:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2098' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-17') 17/06/2023 12:31:46 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' , '2098' , '2023-06-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.13' , '3.99' , NOW() , NOW() ) 17/06/2023 12:31:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86403' 17/06/2023 12:31:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '86403' 17/06/2023 12:31:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86403' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 17/06/2023 12:31:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86403' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 17/06/2023 12:45:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2099' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-17') 17/06/2023 12:45:37 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' , '2099' , '2023-06-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '390.00' , '319.67' , NOW() , NOW() ) 17/06/2023 12:45:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86404' 17/06/2023 12:45:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '86404' 17/06/2023 12:45:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86404' , '16040' , 'STOLA ROMANA S/MOIRE\' - 7336S' , '1' , '-1' , '1' , '390.00' , '319.67213114754' , '22' , '0' , '390.00' )