25/03/2023 09:02:13 am >> SELECT document_num FROM ps_document WHERE document_num = '970' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 09:02: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' , '970' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.60' , '5.41' , NOW() , NOW() ) 25/03/2023 09:02: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 = '82461' 25/03/2023 09:02:13 am >> DELETE FROM ps_document_detail WHERE id_document = '82461' 25/03/2023 09:02: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 ( '82461' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '6' , '-6' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '6.60' ) 25/03/2023 09:27:00 am >> SELECT document_num FROM ps_document WHERE document_num = '971' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 09:27:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '971' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '13.93' , NOW() , NOW() ) 25/03/2023 09:27:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82462' 25/03/2023 09:27:00 am >> DELETE FROM ps_document_detail WHERE id_document = '82462' 25/03/2023 09:27:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82462' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 25/03/2023 09:41:44 am >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 09:41:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '37/A' , '2023-03-25' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.50' , '87.03' , NOW() , NOW() ) 25/03/2023 09:41:44 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 = '82463' 25/03/2023 09:41:44 am >> DELETE FROM ps_document_detail WHERE id_document = '82463' 25/03/2023 09:41:44 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 ( '82463' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 25/03/2023 09:41:44 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 ( '82463' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 25/03/2023 09:41:44 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 ( '82463' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '51.00' ) 25/03/2023 09:41:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82463' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.70' , '0.7' , '0' , '0' , '17.50' ) 25/03/2023 09:41:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82463' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 25/03/2023 09:49:40 am >> SELECT document_num FROM ps_document WHERE document_num = '972' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 09:49:40 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' , '972' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.00' , '60.66' , NOW() , NOW() ) 25/03/2023 09:49:40 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 = '82464' 25/03/2023 09:49:40 am >> DELETE FROM ps_document_detail WHERE id_document = '82464' 25/03/2023 09:49:40 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 ( '82464' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '74.00' ) 25/03/2023 10:04:08 am >> SELECT document_num FROM ps_document WHERE document_num = '973' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 10:04:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '973' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '47.54' , NOW() , NOW() ) 25/03/2023 10:04:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82465' 25/03/2023 10:04:08 am >> DELETE FROM ps_document_detail WHERE id_document = '82465' 25/03/2023 10:04:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82465' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 25/03/2023 10:04:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82465' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 25/03/2023 10:23:24 am >> SELECT document_num FROM ps_document WHERE document_num = '974' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 10:23: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' , '974' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 25/03/2023 10:23: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 = '82466' 25/03/2023 10:23:24 am >> DELETE FROM ps_document_detail WHERE id_document = '82466' 25/03/2023 10:23: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 ( '82466' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '55' , '45.081967213115' , '22' , '0' , '110.00' ) 25/03/2023 10:49:16 am >> SELECT document_num FROM ps_document WHERE document_num = '38/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 10:49:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '38/A' , '2023-03-25' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2160.00' , '2160.00' , NOW() , NOW() ) 25/03/2023 10:49:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82467' 25/03/2023 10:49:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82467' 25/03/2023 10:49:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82467' , '20719' , 'CORONA DELL’ADDOLORATA' , '1200' , '-1200' , '4' , '1.80' , '1.8' , '0' , '0' , '2160.00' ) 25/03/2023 10:51:07 am >> SELECT document_num FROM ps_document WHERE document_num = '39/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 10:51:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '39/A' , '2023-03-25' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '433.30' , '433.30' , NOW() , NOW() ) 25/03/2023 10:51:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82468' 25/03/2023 10:51:07 am >> DELETE FROM ps_document_detail WHERE id_document = '82468' 25/03/2023 10:51:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '0' , '3.50' , '3.5' , '' , '0' , '210.00' ) 25/03/2023 10:51:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '0' , '4.90' , '4.9' , '' , '0' , '117.60' ) 25/03/2023 10:51:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '0' , '85.00' , '85' , '' , '0' , '85.00' ) 25/03/2023 10:51:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '' , 'GRANI' , '1' , '-1' , '0' , '13' , '13' , '' , '0' , '13.00' ) 25/03/2023 10:51:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '11' , '-11' , '4' , '0.70' , '0.7' , '0' , '0' , '7.70' ) 25/03/2023 10:53:21 am >> SELECT document_num FROM ps_document WHERE document_num = '39/A' AND id_document != '82468' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 10:53:21 am >> UPDATE ps_document SET id_document_type = '24', document_num = '39/A', document_date = '2023-03-25', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '451.30', price_tax_excluded = '448.05', date_upd = NOW() WHERE id_document = '82468' 25/03/2023 10:53:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82468' 25/03/2023 10:53:21 am >> DELETE FROM ps_document_detail WHERE id_document = '82468' 25/03/2023 10:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '0' , '3.5000' , '3.5' , '0' , '0' , '210.00' ) 25/03/2023 10:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '0' , '4.9000' , '4.9' , '0' , '0' , '117.60' ) 25/03/2023 10:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '0' , '85.0000' , '85' , '0' , '0' , '85.00' ) 25/03/2023 10:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '0' , 'GRANI' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 25/03/2023 10:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '11' , '-11' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.70' ) 25/03/2023 10:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '9133' , 'ROSARIO LEGNO ADDOLORATA - 01002 - 25' , '2' , '-2' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '18.00' ) 25/03/2023 11:02:55 am >> SELECT document_num FROM ps_document WHERE document_num = '39/A' AND id_document != '82468' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 11:02:55 am >> UPDATE ps_document SET id_document_type = '24', document_num = '39/A', document_date = '2023-03-25', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '528.30', price_tax_excluded = '511.17', date_upd = NOW() WHERE id_document = '82468' 25/03/2023 11:02:55 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 = '82468' 25/03/2023 11:02:55 am >> DELETE FROM ps_document_detail WHERE id_document = '82468' 25/03/2023 11:02:55 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 ( '82468' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '0' , '3.5000' , '3.5' , '0' , '0' , '210.00' ) 25/03/2023 11:02:55 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 ( '82468' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '0' , '4.9000' , '4.9' , '0' , '0' , '117.60' ) 25/03/2023 11:02:55 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 ( '82468' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '0' , '85.0000' , '85' , '0' , '0' , '85.00' ) 25/03/2023 11:02:55 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 ( '82468' , '0' , 'GRANI' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 25/03/2023 11:02:55 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 ( '82468' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '11' , '-11' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.70' ) 25/03/2023 11:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '9133' , 'ROSARIO LEGNO ADDOLORATA - 01002 - 25' , '2' , '-2' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '18.00' ) 25/03/2023 11:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 25/03/2023 11:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 25/03/2023 11:06:02 am >> SELECT document_num FROM ps_document WHERE document_num = '975' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 11:06:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '975' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 25/03/2023 11:06:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82469' 25/03/2023 11:06:02 am >> DELETE FROM ps_document_detail WHERE id_document = '82469' 25/03/2023 11:06:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82469' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 25/03/2023 11:08:31 am >> SELECT document_num FROM ps_document WHERE document_num = '976' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 11:08: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' , '976' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.00' , '64.75' , NOW() , NOW() ) 25/03/2023 11:08: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 = '82470' 25/03/2023 11:08:31 am >> DELETE FROM ps_document_detail WHERE id_document = '82470' 25/03/2023 11:08: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 ( '82470' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 25/03/2023 11:16:30 am >> SELECT document_num FROM ps_document WHERE document_num = '39/A' AND id_document != '82468' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 11:16:30 am >> UPDATE ps_document SET id_document_type = '24', document_num = '39/A', document_date = '2023-03-25', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '557.30', price_tax_excluded = '540.17', date_upd = NOW() WHERE id_document = '82468' 25/03/2023 11:16: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 = '82468' 25/03/2023 11:16:30 am >> DELETE FROM ps_document_detail WHERE id_document = '82468' 25/03/2023 11:16: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 ( '82468' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '0' , '3.5000' , '3.5' , '0' , '0' , '210.00' ) 25/03/2023 11:16: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 ( '82468' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '0' , '4.9000' , '4.9' , '0' , '0' , '117.60' ) 25/03/2023 11:16: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 ( '82468' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '0' , '85.0000' , '85' , '0' , '0' , '85.00' ) 25/03/2023 11:16: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 ( '82468' , '0' , 'GRANI' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 25/03/2023 11:16: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 ( '82468' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '11' , '-11' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.70' ) 25/03/2023 11:16: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 ( '82468' , '9133' , 'ROSARIO LEGNO ADDOLORATA - 01002 - 25' , '2' , '-2' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '18.00' ) 25/03/2023 11:16: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 ( '82468' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 25/03/2023 11:16: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 ( '82468' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 25/03/2023 11:16: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 ( '82468' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '0' , '20.00' ) 25/03/2023 11:16: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 ( '82468' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 25/03/2023 11:27:26 am >> SELECT document_num FROM ps_document WHERE document_num = '39/A' AND id_document != '82468' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 11:27:26 am >> UPDATE ps_document SET id_document_type = '24', document_num = '39/A', document_date = '2023-03-25', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '717.30', price_tax_excluded = '700.17', date_upd = NOW() WHERE id_document = '82468' 25/03/2023 11:27:26 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 = '82468' 25/03/2023 11:27:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82468' 25/03/2023 11:27:27 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 ( '82468' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '0' , '3.5000' , '3.5' , '0' , '0' , '210.00' ) 25/03/2023 11:27:27 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 ( '82468' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '0' , '4.9000' , '4.9' , '0' , '0' , '117.60' ) 25/03/2023 11:27:27 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 ( '82468' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '0' , '85.0000' , '85' , '0' , '0' , '85.00' ) 25/03/2023 11:27:27 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 ( '82468' , '0' , 'GRANI' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 25/03/2023 11:27:27 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 ( '82468' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '11' , '-11' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.70' ) 25/03/2023 11:27:27 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 ( '82468' , '9133' , 'ROSARIO LEGNO ADDOLORATA - 01002 - 25' , '2' , '-2' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '18.00' ) 25/03/2023 11:27:27 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 ( '82468' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 25/03/2023 11:27:27 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 ( '82468' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 25/03/2023 11:27:27 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 ( '82468' , '' , 'PADRE CARLO' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 25/03/2023 11:27:27 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 ( '82468' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 25/03/2023 11:27:27 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 ( '82468' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '0' , '20.00' ) 25/03/2023 11:27:27 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 ( '82468' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '0' , '37.00' , '37' , '' , '0' , '74.00' ) 25/03/2023 11:27:27 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 ( '82468' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '0' , '49.00' , '49' , '' , '0' , '49.00' ) 25/03/2023 11:27:27 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 ( '82468' , '2328' , 'CLERGY GRIGIO MM - COTONE 43 ' , '1' , '-1' , '0' , '37.00' , '37' , '' , '0' , '37.00' ) 25/03/2023 11:33:09 am >> SELECT document_num FROM ps_document WHERE document_num = '665' AND id_document != '82061' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28') 25/03/2023 11:33:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '665', document_date = '2023-02-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '112.80', price_tax_excluded = '96.57', date_upd = NOW() WHERE id_document = '82061' 25/03/2023 11:33:09 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 = '82061' 25/03/2023 11:33:09 am >> DELETE FROM ps_document_detail WHERE id_document = '82061' 25/03/2023 11:33:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82061' , '16657' , 'CLERGY JEANS - ML ' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 25/03/2023 11:33:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82061' , '19366' , 'DAL CENACOLO AL GIARDINO .. - E. DELLA CORTE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 25/03/2023 11:33:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82061' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 25/03/2023 11:33:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82061' , '18762' , 'BRACCIALE ARG. - 1568/1570' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 25/03/2023 11:50:47 am >> SELECT document_num FROM ps_document WHERE document_num = '103/A' AND id_document != '74912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 25/03/2023 11:50:47 am >> UPDATE ps_document SET id_document_type = '24', document_num = '103/A', document_date = '2022-11-26', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'parrocchia', 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 = '180.40', price_tax_excluded = '162.73', date_upd = NOW() WHERE id_document = '74912' 25/03/2023 11:50: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 = '74912' 25/03/2023 11:50:47 am >> DELETE FROM ps_document_detail WHERE id_document = '74912' 25/03/2023 11:50: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 ( '74912' , '0' , 'candele' , '1' , '-1' , '0' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 25/03/2023 11:50: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 ( '74912' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 25/03/2023 11:50: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 ( '74912' , '0' , 'CUSCINO' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 25/03/2023 11:50: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 ( '74912' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '960' , '-960' , '4' , '0.0400' , '0.04' , '0' , '0' , '38.40' ) 25/03/2023 11:50: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 ( '74912' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '30' , '-30' , '4' , '1.0000' , '1' , '0' , '15' , '25.50' ) 25/03/2023 11:50: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 ( '74912' , '13712' , 'SERIE VIA CRUCIS - 22X30 ' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 25/03/2023 11:50: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 ( '74912' , '20177' , 'ANGELO SU CUORE CM 6,5 - AR112' , '4' , '-4' , '1' , '3' , '2.4590163934426' , '22' , '0' , '12.00' ) 25/03/2023 12:14:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '977' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 12:14: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' , '977' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 25/03/2023 12:14: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 = '82471' 25/03/2023 12:14:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '82471' 25/03/2023 12:14: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 ( '82471' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 25/03/2023 12:22:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '978' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 12:22:03 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' , '978' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.30' , '5.16' , NOW() , NOW() ) 25/03/2023 12:22:03 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 = '82472' 25/03/2023 12:22:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '82472' 25/03/2023 12:22:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82472' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 25/03/2023 12:22:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82472' , '15334' , 'CANDELA VOTIVA 20X40' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 25/03/2023 12:47:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '979' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 12:47:28 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' , '979' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '320.00' , '262.30' , NOW() , NOW() ) 25/03/2023 12:47:28 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 = '82473' 25/03/2023 12:47:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '82473' 25/03/2023 12:47:28 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 ( '82473' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '-1' , '1' , '185' , '151.6393442623' , '22' , '0' , '185.00' ) 25/03/2023 12:47:28 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 ( '82473' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 25/03/2023 12:51:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '39/A' AND id_document != '82468' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 12:51:18 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '39/A', document_date = '2023-03-25', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '766.30', price_tax_excluded = '749.17', date_upd = NOW() WHERE id_document = '82468' 25/03/2023 12:51: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 = '82468' 25/03/2023 12:51:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '82468' 25/03/2023 12:51: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 ( '82468' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '0' , '3.5000' , '3.5' , '0' , '0' , '210.00' ) 25/03/2023 12:51: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 ( '82468' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '0' , '4.9000' , '4.9' , '0' , '0' , '117.60' ) 25/03/2023 12:51: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 ( '82468' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '0' , '85.0000' , '85' , '0' , '0' , '85.00' ) 25/03/2023 12:51: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 ( '82468' , '0' , 'GRANI' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 25/03/2023 12:51: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 ( '82468' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '11' , '-11' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.70' ) 25/03/2023 12:51: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 ( '82468' , '9133' , 'ROSARIO LEGNO ADDOLORATA - 01002 - 25' , '2' , '-2' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '18.00' ) 25/03/2023 12:51: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 ( '82468' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 25/03/2023 12:51: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 ( '82468' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 25/03/2023 12:51: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 ( '82468' , '0' , 'PADRE CARLO' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 25/03/2023 12:51: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 ( '82468' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 25/03/2023 12:51: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 ( '82468' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '0' , '20.00' ) 25/03/2023 12:51: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 ( '82468' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '0' , '37.0000' , '37' , '0' , '0' , '74.00' ) 25/03/2023 12:51: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 ( '82468' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '0' , '49.0000' , '49' , '0' , '0' , '49.00' ) 25/03/2023 12:51: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 ( '82468' , '2328' , 'CLERGY GRIGIO MM - COTONE 43 ' , '1' , '-1' , '0' , '37.0000' , '37' , '0' , '0' , '37.00' ) 25/03/2023 12:51: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 ( '82468' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '0' , '49.00' , '49' , '' , '0' , '49.00' ) 25/03/2023 12:57:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '980' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 12:57:54 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' , '980' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 25/03/2023 12:57:54 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 = '82474' 25/03/2023 12:57:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '82474' 25/03/2023 12:57:54 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 ( '82474' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 25/03/2023 01:07:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '981' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 01:07:02 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' , '981' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '7.16' , NOW() , NOW() ) 25/03/2023 01:07:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82475' 25/03/2023 01:07:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '82475' 25/03/2023 01:07:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82475' , '12255' , 'IN CAMMINO CON GESU' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '0' , '3.80' ) 25/03/2023 01:07:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82475' , '12467' , 'TAU PRIMA COMUNIONE' , '1' , '-1' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '1.60' ) 25/03/2023 01:07:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82475' , '13366' , 'CORONA VETRO MM 4 CON SCATOLA' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 25/03/2023 01:07:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '982' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 25/03/2023 01:07: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' , '982' , '2023-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 25/03/2023 01:07: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 = '82476' 25/03/2023 01:07:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82476' 25/03/2023 01:07: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 ( '82476' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 25/03/2023 01:10:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '786' AND id_document != '82227' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 25/03/2023 01:10:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '786', document_date = '2023-03-09', 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 = '3.40', price_tax_excluded = '3.13', date_upd = NOW() WHERE id_document = '82227' 25/03/2023 01:10:49 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 = '82227' 25/03/2023 01:10:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '82227' 25/03/2023 01:10:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82227' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 25/03/2023 01:10:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82227' , '20774' , 'MESSAGGIO PER LA QUARESIMA 2023' , '2' , '-2' , '4' , '0.95' , '0.95' , '0' , '0' , '1.90' )