01/10/2022 08:37:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2883' AND id_document != '63045' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-30') 01/10/2022 08:37:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2883', document_date = '2022-09-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '110.00', price_tax_excluded = '90.66', date_upd = NOW() WHERE id_document = '63045' 01/10/2022 08:37: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 = '63045' 01/10/2022 08:37:57 am >> DELETE FROM ps_document_detail WHERE id_document = '63045' 01/10/2022 08:37: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 ( '63045' , '18131' , 'TAU MEDIO CM3 - T6' , '100' , '-100' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '100.00' ) 01/10/2022 08:37:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '18131' AND id_supplier = '' 01/10/2022 08:37:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18131' , '' , '1' ) 01/10/2022 08:37: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 ( '63045' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 01/10/2022 08:37:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 01/10/2022 08:37:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 01/10/2022 08:37: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 ( '63045' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 01/10/2022 08:37:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 01/10/2022 08:37:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 01/10/2022 08:37: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 ( '63045' , '9423' , 'SAN FRANCESCO D\'ASSISI' , '2' , '-2' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '5.00' ) 01/10/2022 08:37:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '9423' AND id_supplier = '' 01/10/2022 08:37:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9423' , '' , '1' ) 01/10/2022 08:37: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 ( '63045' , '6356' , 'MEDAGLIA S.CUORE- MAD. CARMINE' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 01/10/2022 08:37:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '6356' AND id_supplier = '' 01/10/2022 08:37:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6356' , '' , '1' ) 01/10/2022 08:42:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2886' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-01') 01/10/2022 08:42: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' , '2886' , '2022-10-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.00' , '72.95' , NOW() , NOW() ) 01/10/2022 08:42: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 = '63048' 01/10/2022 08:42:30 am >> DELETE FROM ps_document_detail WHERE id_document = '63048' 01/10/2022 08:42: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 ( '63048' , '9184' , 'ROSARIO S. MICHELE IN CRISTALLO - RL 753/C' , '11' , '-11' , '1' , '4' , '3.2786885245902' , '22' , '0' , '44.00' ) 01/10/2022 08:42:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '9184' AND id_supplier = '' 01/10/2022 08:42:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9184' , '' , '1' ) 01/10/2022 08:42: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 ( '63048' , '9183' , 'ROSARIO S. MICHELE - LEGNO RL 753 ' , '11' , '-11' , '1' , '4' , '3.2786885245902' , '22' , '0' , '44.00' ) 01/10/2022 08:42:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '9183' AND id_supplier = '' 01/10/2022 08:42:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9183' , '' , '1' ) 01/10/2022 08:42: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 ( '63048' , '15094' , 'BRACCIALE DECINA CORDA TAU' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 01/10/2022 08:42:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '15094' AND id_supplier = '' 01/10/2022 08:42:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15094' , '' , '1' ) 01/10/2022 09:45:15 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3909' 01/10/2022 09:45:15 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 ( '3909' , '10' , '219' , 'PARR. S. GIOVANNI B.' , 'FOMA\'' , 'DON MATTEO' , 'PIAZZA GARIBALDI 17' , '' , '10089' , 'VALCHIUSA' , '' , '' , '3319190586' , '' , '93008430014' , NOW() , NOW() ) 01/10/2022 09:45:15 am >> UPDATE ps_customer SET email = 'don.matteo.foma@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3909' 01/10/2022 09:45:33 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3909' 01/10/2022 09:45:33 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 ( '3909' , '10' , '219' , 'PARR. S. GIOVANNI B.' , 'FOMA\'' , 'DON MATTEO' , 'PIAZZA GARIBALDI 17' , '' , '10089' , 'VALCHIUSA' , '' , '' , '3319190586' , '' , '93008430014' , NOW() , NOW() ) 01/10/2022 09:45:33 am >> UPDATE ps_customer SET email = 'don.matteo.foma@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3909' 01/10/2022 10:58:31 am >> SELECT document_num FROM ps_document WHERE document_num = '51/A' AND id_document != '59691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-15') 01/10/2022 10:58:31 am >> UPDATE ps_document SET id_document_type = '24', document_num = '51/A', document_date = '2022-07-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA BATTIPAGLIA', 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 = '183.10', price_tax_excluded = '170.82', date_upd = NOW() WHERE id_document = '59691' 01/10/2022 10:58: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 = '59691' 01/10/2022 10:58:31 am >> DELETE FROM ps_document_detail WHERE id_document = '59691' 01/10/2022 10:58: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 ( '59691' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 01/10/2022 10:58:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 01/10/2022 10:58:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 01/10/2022 10:58: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 ( '59691' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 01/10/2022 10:58:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 01/10/2022 10:58:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 01/10/2022 10:58: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 ( '59691' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 01/10/2022 10:58:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 01/10/2022 10:58:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 01/10/2022 10:58: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 ( '59691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.5600' , '0.56' , '0' , '0' , '14.00' ) 01/10/2022 10:58:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 01/10/2022 10:58:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 01/10/2022 10:58: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 ( '59691' , '0' , 'PREGHIERA DELL\'AMMALATO' , '200' , '-200' , '0' , '0.1000' , '0.1' , '0' , '0' , '20.00' ) 01/10/2022 10:58:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 01/10/2022 10:58:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 01/10/2022 10:58: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 ( '59691' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 01/10/2022 10:58:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 01/10/2022 10:58:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 01/10/2022 10:58: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 ( '59691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.56' , '0.56' , '0' , '0' , '14.00' ) 01/10/2022 10:58:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 01/10/2022 10:58:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 01/10/2022 10:58: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 ( '59691' , '' , 'LAMPADINE' , '50' , '-50' , '4' , '1.2' , '1.2' , '0' , '0' , '60.00' ) 01/10/2022 10:58:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 01/10/2022 10:58:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 01/10/2022 11:15:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2887' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-01') 01/10/2022 11:15:22 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' , '2887' , '2022-10-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 01/10/2022 11:15:22 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 = '63049' 01/10/2022 11:15:22 am >> DELETE FROM ps_document_detail WHERE id_document = '63049' 01/10/2022 11:15:22 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 ( '63049' , '1951' , 'CERONI S.S. T60 - CARTA ROSSO' , '25' , '-25' , '1' , '3' , '2.4590163934426' , '22' , '0' , '75.00' ) 01/10/2022 11:15:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '1951' AND id_supplier = '' 01/10/2022 11:15:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1951' , '' , '1' ) 01/10/2022 11:15:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2888' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-01') 01/10/2022 11:15:36 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' , '2888' , '2022-10-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 01/10/2022 11:15:36 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 = '63050' 01/10/2022 11:15:36 am >> DELETE FROM ps_document_detail WHERE id_document = '63050' 01/10/2022 11:15:36 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 ( '63050' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 01/10/2022 11:15:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '3419' AND id_supplier = '' 01/10/2022 11:15:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3419' , '' , '1' ) 01/10/2022 11:41:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2889' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-01') 01/10/2022 11:41: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' , '2889' , '2022-10-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '26.00' , NOW() , NOW() ) 01/10/2022 11:41: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 = '63051' 01/10/2022 11:41:13 am >> DELETE FROM ps_document_detail WHERE id_document = '63051' 01/10/2022 11:41: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 ( '63051' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '26' , '26' , '0' , '0' , '26.00' ) 01/10/2022 11:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 01/10/2022 11:41:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 01/10/2022 11:46:03 am >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '61817' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-15') 01/10/2022 11:46:03 am >> UPDATE ps_document SET id_document_type = '24', document_num = '70/A', document_date = '2022-09-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA SAN LEONARDO', 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 = '64.65', price_tax_excluded = '55.15', date_upd = NOW() WHERE id_document = '61817' 01/10/2022 11:46: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 = '61817' 01/10/2022 11:46:03 am >> DELETE FROM ps_document_detail WHERE id_document = '61817' 01/10/2022 11:46: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 ( '61817' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 01/10/2022 11:46:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 01/10/2022 11:46:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 01/10/2022 11:46: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 ( '61817' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 01/10/2022 11:46:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 01/10/2022 11:46:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 01/10/2022 11:46: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 ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 01/10/2022 11:46:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 01/10/2022 11:46:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 01/10/2022 11:46: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 ( '61817' , '12192' , 'CROCE BIANCA CM 11,5 - GAY MATTIOLO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 01/10/2022 11:46:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '12192' AND id_supplier = '' 01/10/2022 11:46:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12192' , '' , '1' ) 01/10/2022 11:46: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 ( '61817' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '-3' , '4' , '0.6500' , '0.65' , '0' , '0' , '1.95' ) 01/10/2022 11:46:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '8254' AND id_supplier = '' 01/10/2022 11:46:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8254' , '' , '1' ) 01/10/2022 11:46: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 ( '61817' , '' , 'SUPPLICA' , '1' , '-1' , '0' , '10' , '10' , '' , '0' , '10.00' ) 01/10/2022 11:46:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 01/10/2022 11:46:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 01/10/2022 11:46: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 ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 01/10/2022 11:46:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 01/10/2022 11:46:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 01/10/2022 11:52:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2890' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-01') 01/10/2022 11:52: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' , '2890' , '2022-10-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 01/10/2022 11:52: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 = '63052' 01/10/2022 11:52:54 am >> DELETE FROM ps_document_detail WHERE id_document = '63052' 01/10/2022 11:52: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 ( '63052' , '17553' , 'GRANDI SANTE AMICHE DI GESU' , '1' , '-1' , '4' , '9.5' , '9.5' , '0' , '0' , '9.50' ) 01/10/2022 11:52:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '17553' AND id_supplier = '' 01/10/2022 11:52:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17553' , '' , '1' ) 01/10/2022 12:13:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2891' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-01') 01/10/2022 12:13:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2891' , '2022-10-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 01/10/2022 12:13:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63053' 01/10/2022 12:13:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '63053' 01/10/2022 12:13:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63053' , '16461' , 'CLERGY NIDO D\'APE ML - C 22' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 01/10/2022 12:13:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16461' AND id_supplier = '' 01/10/2022 12:13:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16461' , '' , '1' ) 01/10/2022 12:15:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2892' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-01') 01/10/2022 12:15:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2892' , '2022-10-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.26' , '22.26' , NOW() , NOW() ) 01/10/2022 12:15:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63054' 01/10/2022 12:15:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '63054' 01/10/2022 12:15:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63054' , '19685' , 'AMEN - OTT 2022' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 01/10/2022 12:15:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 01/10/2022 12:15:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 01/10/2022 12:15:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63054' , '19925' , 'AMEN - NOV. 2022' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 01/10/2022 12:15:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 01/10/2022 12:15:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 01/10/2022 12:15: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 ( '63054' , '19926' , 'AMEN - DIC. 2022' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 01/10/2022 12:15:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 01/10/2022 12:15:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 01/10/2022 12:22:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2893' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-01') 01/10/2022 12:22:32 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' , '2893' , '2022-10-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '16.00' , NOW() , NOW() ) 01/10/2022 12:22:32 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 = '63055' 01/10/2022 12:22:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '63055' 01/10/2022 12:22:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63055' , '20017' , 'CHI DORME NON PIGLIA CRISTO - M. POZZA' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 01/10/2022 12:22:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20017' AND id_supplier = '' 01/10/2022 12:22:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20017' , '' , '1' ) 01/10/2022 12:26:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2894' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-01') 01/10/2022 12:26: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' , '2894' , '2022-10-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.70' , '6.31' , NOW() , NOW() ) 01/10/2022 12:26: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 = '63056' 01/10/2022 12:26:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '63056' 01/10/2022 12:26: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 ( '63056' , '18222' , 'ROSARIO COLORATO - R316' , '11' , '-11' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.70' ) 01/10/2022 12:26:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 01/10/2022 12:26:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 01/10/2022 12:49:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2655' AND id_document != '61188' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-06') 01/10/2022 12:49:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2655', document_date = '2022-09-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '28.00', price_tax_excluded = '26.20', date_upd = NOW() WHERE id_document = '61188' 01/10/2022 12:49:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61188' 01/10/2022 12:49:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '61188' 01/10/2022 12:49:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61188' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 01/10/2022 12:49:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 01/10/2022 12:49:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 01/10/2022 12:49:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61188' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '1.4' , '1.4' , '0' , '0' , '2.80' ) 01/10/2022 12:49:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 01/10/2022 12:49:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 01/10/2022 12:49:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61188' , '17073' , 'DIRETTORIO PER LA CATECHESI' , '1' , '-1' , '4' , '16' , '16' , '0' , '5' , '15.20' ) 01/10/2022 12:49:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17073' AND id_supplier = '' 01/10/2022 12:49:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17073' , '' , '1' ) 01/10/2022 12:50:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2839' AND id_document != '61942' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-26') 01/10/2022 12:50:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2839', document_date = '2022-09-26', 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 = '26.77', date_upd = NOW() WHERE id_document = '61942' 01/10/2022 12:50:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61942' 01/10/2022 12:50:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '61942' 01/10/2022 12:50:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61942' , '5458' , 'IO SONO CON VOI 2 PARTE' , '4' , '-4' , '4' , '1.45' , '1.45' , '0' , '0' , '5.80' ) 01/10/2022 12:50:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 01/10/2022 12:50:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 01/10/2022 12:50:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61942' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 01/10/2022 12:50:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 01/10/2022 12:50:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 01/10/2022 12:50:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61942' , '17073' , 'DIRETTORIO PER LA CATECHESI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 01/10/2022 12:50:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17073' AND id_supplier = '' 01/10/2022 12:50:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17073' , '' , '1' )