25/05/2024 08:26:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1754' AND id_document != '92006' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-24') 25/05/2024 08:26:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1754', document_date = '2024-05-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '980.00', price_tax_excluded = '803.28', date_upd = NOW() WHERE id_document = '92006' 25/05/2024 08:26:51 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 = '92006' 25/05/2024 08:26:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92006' 25/05/2024 08:26:51 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 ( '92006' , '20901' , 'CASULA P/LANA AGNUS DEI - 8219-8249L' , '1' , '-1' , '1' , '980.0000' , '803.27868852459' , '22' , '0' , '980.00' ) 25/05/2024 08:33:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1741' AND id_document != '91986' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-24') 25/05/2024 08:33:03 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1741', document_date = '2024-05-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '91986' 25/05/2024 08:33: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 = '91986' 25/05/2024 08:33:03 am >> DELETE FROM ps_document_detail WHERE id_document = '91986' 25/05/2024 08:33: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 ( '91986' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 25/05/2024 09:25:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000466' AND id_product != '17841' AND ean13 != '' 25/05/2024 09:25:49 am >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = '000466', date_upd = NOW() WHERE id_product = '17841' 25/05/2024 09:25:49 am >> UPDATE ps_product_lang SET name = 'QUADRO DECORATO 42X32', description = '' WHERE id_product = '17841' 25/05/2024 09:25:49 am >> UPDATE ps_product SET wholesale_price = '20.00', on_sale = '0', price = '49.18032786885246' WHERE id_product = '17841' 25/05/2024 09:25:49 am >> UPDATE ps_product_shop SET wholesale_price = '20.00', price = '49.18032786885246', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17841' 25/05/2024 09:25:49 am >> DELETE FROM ps_specific_price WHERE id_product = '17841' 25/05/2024 09:27:39 am >> SELECT document_num FROM ps_document WHERE document_num = '67/A' AND id_document != '91998' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-24') 25/05/2024 09:27:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '67/A', document_date = '2024-05-24', document_letter = 'A', id_customer = '1175', id_supplier = '', id_address = '4679143', address1 = 'VIA 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 = '105.00', price_tax_excluded = '86.07', date_upd = NOW() WHERE id_document = '91998' 25/05/2024 09:27:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91998' 25/05/2024 09:27:39 am >> DELETE FROM ps_document_detail WHERE id_document = '91998' 25/05/2024 09:27:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91998' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 25/05/2024 09:27:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91998' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 25/05/2024 09:35:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1758' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 09:35:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1758' , '2024-05-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.50' , '52.92' , NOW() , NOW() ) 25/05/2024 09:35:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92010' 25/05/2024 09:35:47 am >> DELETE FROM ps_document_detail WHERE id_document = '92010' 25/05/2024 09:35:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92010' , '22353' , 'CROCE COMUNIONE - 646' , '15' , '-15' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '27.00' ) 25/05/2024 09:35:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92010' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 25/05/2024 09:35:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92010' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 25/05/2024 09:35:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92010' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 25/05/2024 09:35:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92010' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 25/05/2024 09:53:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1759' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 09:53:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1759' , '2024-05-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.70' , '21.89' , NOW() , NOW() ) 25/05/2024 09:53: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 = '92011' 25/05/2024 09:53:31 am >> DELETE FROM ps_document_detail WHERE id_document = '92011' 25/05/2024 09:53: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 ( '92011' , '11389' , 'VINO ROSSO DOLCE - 103' , '3' , '-3' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '26.70' ) 25/05/2024 10:46:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1760' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 10:46: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 ( '11' , '1760' , '2024-05-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 25/05/2024 10:46: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 = '92012' 25/05/2024 10:46:24 am >> DELETE FROM ps_document_detail WHERE id_document = '92012' 25/05/2024 10:46: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 ( '92012' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 25/05/2024 10:46:25 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 ( '92012' , '10495' , 'TECA IHS CM 9 - 881' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 25/05/2024 10:47:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1761' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 10:47: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' , '1761' , '2024-05-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.29' , NOW() , NOW() ) 25/05/2024 10:47: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 = '92013' 25/05/2024 10:47:22 am >> DELETE FROM ps_document_detail WHERE id_document = '92013' 25/05/2024 10:47: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 ( '92013' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 25/05/2024 10:47: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 ( '92013' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 25/05/2024 10:56:28 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '949' 25/05/2024 10:56:28 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 ( '949' , '10' , '219' , 'PARROCCHIA GESU\' NAZARENO' , '' , 'PADRI DOTTRINARI' , 'VIA P. PALMIERI 39' , '' , '10138' , 'TORINO' , '' , '011/4474262' , '' , '' , '97522300017' , NOW() , NOW() ) 25/05/2024 10:56:28 am >> UPDATE ps_customer SET email = 'parrocchia@gesunazareno.it', sdi = '0000000', pec = '', date_upd = NOW() WHERE id_customer = '949' 25/05/2024 10:56:53 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '949' 25/05/2024 10:56:53 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 ( '949' , '10' , '219' , 'PARROCCHIA GESU\' NAZARENO' , '' , 'PADRI DOTTRINARI' , 'VIA P. PALMIERI 39' , '' , '10138' , 'TORINO' , '' , '011/4474262' , '' , '' , '97522300017' , NOW() , NOW() ) 25/05/2024 10:56:53 am >> UPDATE ps_customer SET email = 'parrocchia@gesunazareno.it', sdi = '0000000', pec = '', date_upd = NOW() WHERE id_customer = '949' 25/05/2024 10:56:59 am >> SELECT document_num FROM ps_document WHERE document_num = '12/L' AND id_document != '92003' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-24') 25/05/2024 10:56:59 am >> UPDATE ps_document SET id_document_type = '23', document_num = '12/L', document_date = '2024-05-24', document_letter = 'L', id_customer = '949', id_supplier = '0', id_address = '4679326', address1 = 'VIA P. PALMIERI 39 10138 TORINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '227.10', price_tax_excluded = '202.36', date_upd = NOW() WHERE id_document = '92003' 25/05/2024 10:56:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92003' 25/05/2024 10:56:59 am >> DELETE FROM ps_document_detail WHERE id_document = '92003' 25/05/2024 10:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92003' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '70.00' ) 25/05/2024 10:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92003' , '7311' , 'OSTIA SOTTILE 74MM' , '20' , '-20' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '40.00' ) 25/05/2024 10:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92003' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 25/05/2024 10:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92003' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 25/05/2024 11:18:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1762' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 11:18:32 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' , '1762' , '2024-05-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.30' , '24.83' , NOW() , NOW() ) 25/05/2024 11:18:32 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 = '92014' 25/05/2024 11:18:32 am >> DELETE FROM ps_document_detail WHERE id_document = '92014' 25/05/2024 11:18:32 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 ( '92014' , '22352' , 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K' , '2' , '-2' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '2.80' ) 25/05/2024 11:18:32 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 ( '92014' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 25/05/2024 11:18:32 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 ( '92014' , '13613' , 'SCATOLA DECORATA VANGELO' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 25/05/2024 11:48:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1763' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 11:48:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1763' , '2024-05-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 25/05/2024 11:48:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92015' 25/05/2024 11:48:19 am >> DELETE FROM ps_document_detail WHERE id_document = '92015' 25/05/2024 11:48:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92015' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 25/05/2024 11:48:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92015' , '19310' , 'SACCHETTO CON CORONCINA E SEGNALIBRO - 1315/K182' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 25/05/2024 12:08:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1763' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 12:08:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1764' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 12:08: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' , '1764' , '2024-05-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 25/05/2024 12:08: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 = '92016' 25/05/2024 12:08:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '92016' 25/05/2024 12:08: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 ( '92016' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '15' , '-15' , '1' , '10' , '8.1967213114754' , '22' , '0' , '150.00' ) 25/05/2024 12:25:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1764' AND id_document != '92016' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 12:25:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1764', document_date = '2024-05-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 = '150.00', price_tax_excluded = '122.95', date_upd = NOW() WHERE id_document = '92016' 25/05/2024 12:25:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92016' 25/05/2024 12:25:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '92016' 25/05/2024 12:25:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92016' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '11' , '-11' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '110.00' ) 25/05/2024 12:25:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92016' , '20706' , 'ANGELO PENDENTE - AM' , '4' , '-4' , '1' , '10' , '8.1967213114754' , '22' , '0' , '40.00' ) 25/05/2024 12:35:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1765' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 12:35:40 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' , '1765' , '2024-05-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.80' , '18.72' , NOW() , NOW() ) 25/05/2024 12:35:40 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 = '92017' 25/05/2024 12:35:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '92017' 25/05/2024 12:35:40 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 ( '92017' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 25/05/2024 12:35:40 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 ( '92017' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 25/05/2024 12:47:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1532' AND id_document != '91735' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 25/05/2024 12:47:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1532', document_date = '2024-05-10', 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 = '187.61', price_tax_excluded = '159.80', date_upd = NOW() WHERE id_document = '91735' 25/05/2024 12:47:20 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 = '91735' 25/05/2024 12:47:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '91735' 25/05/2024 12:47:20 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 ( '91735' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 25/05/2024 12:47:20 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 ( '91735' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 25/05/2024 12:47:20 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 ( '91735' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '14.00' ) 25/05/2024 12:47:20 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 ( '91735' , '10471' , 'TAVOLETTE SAGOMATE 10X15 - S. PIO' , '4' , '-4' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '8.80' ) 25/05/2024 12:47:20 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 ( '91735' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 25/05/2024 12:47:20 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 ( '91735' , '22511' , 'VIVE - CD' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.06' ) 25/05/2024 12:47:20 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 ( '91735' , '22513' , 'VIVE - SPARTITO' , '1' , '-1' , '3' , '12.0000' , '11.538461538462' , '4' , '5' , '11.40' ) 25/05/2024 12:47:20 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 ( '91735' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 25/05/2024 12:47:20 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 ( '91735' , '19781' , 'BRACCIALE ARGENTO/EMATITE - 1793/CAV' , '1' , '-1' , '1' , '14.9' , '12.213114754098' , '22' , '0' , '14.90' ) 25/05/2024 12:47:21 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 ( '91735' , '14136' , 'MADONNA DEL ROSARIO DI POMPEI - 125' , '3' , '-3' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '9.00' ) 25/05/2024 12:47:21 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 ( '91735' , '4991' , 'SAN PIO DA PIETRELCINA - 315' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 25/05/2024 12:48:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1724' AND id_document != '91963' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-23') 25/05/2024 12:48:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1724', document_date = '2024-05-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '69.19', price_tax_excluded = '68.96', date_upd = NOW() WHERE id_document = '91963' 25/05/2024 12:48:11 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 = '91963' 25/05/2024 12:48:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '91963' 25/05/2024 12:48:11 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 ( '91963' , '22111' , 'PREGARE OGGI - 1' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 25/05/2024 12:48:11 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 ( '91963' , '22191' , 'PREGARE CON I SALMI - 2' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 25/05/2024 12:48:11 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 ( '91963' , '22192' , 'PREGHIERA DI GESU - 3' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 25/05/2024 12:48:11 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 ( '91963' , '22446' , 'PREGARE CON SANTI E PECCATORI - 4' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 25/05/2024 12:48:11 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 ( '91963' , '22445' , 'PARABOLE DELLA PREGHIERA - 5' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 25/05/2024 12:48:12 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 ( '91963' , '22290' , 'CHIESA IN PREGHIERA - 6' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 25/05/2024 12:48:12 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 ( '91963' , '22448' , 'PREGHIERA DI MARIA - 7' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 25/05/2024 12:48:12 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 ( '91963' , '22449' , 'PREGHIERA CHE GESU CI HA INSEGNATO - 8' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 25/05/2024 12:48:12 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 ( '91963' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '1' , '-1' , '4' , '2.25' , '2.25' , '0' , '0' , '2.25' ) 25/05/2024 12:48:12 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 ( '91963' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 25/05/2024 12:48:12 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 ( '91963' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 25/05/2024 12:48:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '995' AND id_document != '91056' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 25/05/2024 12:48:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '995', document_date = '2024-04-02', 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 = '48.00', price_tax_excluded = '42.95', date_upd = NOW() WHERE id_document = '91056' 25/05/2024 12:48: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 = '91056' 25/05/2024 12:48:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '91056' 25/05/2024 12:48: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 ( '91056' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '6' , '-6' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '12.00' ) 25/05/2024 12:48: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 ( '91056' , '21099' , 'BRACCIALE DECINA - BD008' , '6' , '-6' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '12.00' ) 25/05/2024 12:48: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 ( '91056' , '15744' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '3' , '-3' , '4' , '1.5000' , '1.5' , '0' , '5' , '4.29' ) 25/05/2024 12:48: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 ( '91056' , '21201' , 'PREGHIERA DEI 14 GRAZIE - PAPA FRANCESCO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 25/05/2024 12:48: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 ( '91056' , '15740' , 'PREGHIERA - MEDICINA DELLANIMA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 25/05/2024 12:48: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 ( '91056' , '14503' , 'GIOVANI LIBERI DI AMARE' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 25/05/2024 12:48: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 ( '91056' , '4134' , 'FELICI DI CREDERE - ANNO DELLA FEDE' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 25/05/2024 12:48: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 ( '91056' , '16790' , 'MAMMA E PAPA' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 25/05/2024 12:48: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 ( '91056' , '19745' , 'BUON COMPLEANNO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 25/05/2024 12:48: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 ( '91056' , '6546' , 'MESSAGGIO DI TENEREZZA' , '3' , '-3' , '4' , '1.5000' , '1.5' , '0' , '5' , '4.29' ) 25/05/2024 12:48: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 ( '91056' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '1' , '-1' , '4' , '2.28' , '2.28' , '0' , '0' , '2.28' ) 25/05/2024 12:48: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 ( '91056' , '20758' , 'SEGNALIBRO 5X15' , '20' , '-20' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '4.00' ) 25/05/2024 12:51:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1766' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 12:51:17 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' , '1766' , '2024-05-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.30' , '63.36' , NOW() , NOW() ) 25/05/2024 12:51:17 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 = '92018' 25/05/2024 12:51:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '92018' 25/05/2024 12:51:17 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 ( '92018' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 25/05/2024 12:51:17 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 ( '92018' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 25/05/2024 12:51:17 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 ( '92018' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 25/05/2024 12:53:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1767' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 12:53:04 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' , '1767' , '2024-05-25' , '' , '3712' , '0' , '4671443' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '256.70' , '218.60' , NOW() , NOW() ) 25/05/2024 12:53:04 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 = '92019' 25/05/2024 12:53:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '92019' 25/05/2024 12:53:04 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 ( '92019' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '70.0000' , '57.377' , '22' , '0' , '70.00' ) 25/05/2024 12:53:04 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 ( '92019' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 25/05/2024 12:53:04 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 ( '92019' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 25/05/2024 12:53:04 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 ( '92019' , '6019' , 'LUMINO ROSSO - 10B' , '27' , '-27' , '1' , '0.5000' , '0.4098' , '22' , '0' , '13.50' ) 25/05/2024 12:53:04 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 ( '92019' , '6014' , 'LUMINO BIANCO - 10B' , '18' , '-18' , '1' , '0.5000' , '0.4098' , '22' , '0' , '9.00' ) 25/05/2024 12:53:04 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 ( '92019' , '20437' , 'LUMINO BIANCO 10BTS000' , '9' , '-9' , '1' , '0.5000' , '0.4098' , '22' , '0' , '4.50' ) 25/05/2024 12:53:04 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 ( '92019' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269' , '4' , '0' , '4.50' ) 25/05/2024 12:53:04 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 ( '92019' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 25/05/2024 12:53:04 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 ( '92019' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2951' , '22' , '0' , '8.90' ) 25/05/2024 12:53:04 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 ( '92019' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.5000' , '0.4098' , '22' , '0' , '10.00' ) 25/05/2024 12:53:04 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 ( '92019' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '26' , '-26' , '1' , '0.7000' , '0.5738' , '22' , '0' , '18.20' ) 25/05/2024 12:53:04 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 ( '92019' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346' , '4' , '0' , '4.30' ) 25/05/2024 12:53:04 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 ( '92019' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2951' , '22' , '0' , '8.90' ) 25/05/2024 12:53:04 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 ( '92019' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.0000' , '8.1967' , '22' , '0' , '10.00' ) 25/05/2024 12:55:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1767' AND id_document != '92019' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-25') 25/05/2024 12:55:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1767', document_date = '2024-05-25', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA DALMAZIA 6 84121 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 = '256.70', price_tax_excluded = '218.60', date_upd = NOW() WHERE id_document = '92019' 25/05/2024 12:55:50 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 = '92019' 25/05/2024 12:55:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '92019' 25/05/2024 12:55:50 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 ( '92019' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 25/05/2024 12:55:50 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 ( '92019' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 25/05/2024 12:55:50 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 ( '92019' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 25/05/2024 12:55:50 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 ( '92019' , '6019' , 'LUMINO ROSSO - 10B' , '27' , '-27' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.50' ) 25/05/2024 12:55:50 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 ( '92019' , '6014' , 'LUMINO BIANCO - 10B' , '18' , '-18' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '9.00' ) 25/05/2024 12:55:50 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 ( '92019' , '20437' , 'LUMINO BIANCO 10BTS000' , '9' , '-9' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '4.50' ) 25/05/2024 12:55:50 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 ( '92019' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 25/05/2024 12:55:50 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 ( '92019' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 25/05/2024 12:55:50 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 ( '92019' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 25/05/2024 12:55:50 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 ( '92019' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 25/05/2024 12:55:50 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 ( '92019' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '26' , '-26' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '18.20' ) 25/05/2024 12:55:50 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 ( '92019' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 25/05/2024 12:55:50 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 ( '92019' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 25/05/2024 12:55:50 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 ( '92019' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 25/05/2024 01:06: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('2024-05-25') 25/05/2024 01:06: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' , '2024-05-25' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.50' , '24.18' , NOW() , NOW() ) 25/05/2024 01:06: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 = '92020' 25/05/2024 01:06:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '92020' 25/05/2024 01:06: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 ( '92020' , '15497' , 'CROCE PLEX - 086' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 25/05/2024 01:06: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 ( '92020' , '15094' , 'BRACCIALE DECINA CORDA TAU' , '15' , '-15' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '19.50' )