13/03/2023 09:06:12 am >> SELECT document_num FROM ps_document WHERE document_num = '32/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 09:06:12 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' , '32/A' , '2023-03-13' , 'A' , '1175' , '0' , '4672789' , 'VIA BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 13/03/2023 09:06:12 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 = '82266' 13/03/2023 09:06:12 am >> DELETE FROM ps_document_detail WHERE id_document = '82266' 13/03/2023 09:06:12 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 ( '82266' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 13/03/2023 09:24:13 am >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 09:24: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 ( '21' , '12' , '2023-03-13' , '' , '7006' , '0' , '98016361' , 'Via Mastruccia , 164 03100 Frosinone' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '120.90' , '120.90' , NOW() , NOW() ) 13/03/2023 09:24: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 = '11057' 13/03/2023 09:24:13 am >> DELETE FROM ps_document_detail WHERE id_document = '11057' 13/03/2023 09:24: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 ( '11057' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '4' , '-4' , '4' , '30.00' , '30' , '0' , '5' , '114.00' ) 13/03/2023 09:46:26 am >> SELECT document_num FROM ps_document WHERE document_num = '815' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 09:46:26 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' , '815' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 13/03/2023 09:46: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 = '82267' 13/03/2023 09:46:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82267' 13/03/2023 09:46:26 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 ( '82267' , '10208' , 'STATUA MARIA CHE SCIOGLIE NODI CM 20' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 13/03/2023 09:48:16 am >> SELECT document_num FROM ps_document WHERE document_num = '815' AND id_document != '82267' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 09:48:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '815', document_date = '2023-03-13', 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 = '16.00', price_tax_excluded = '13.11', date_upd = NOW() WHERE id_document = '82267' 13/03/2023 09:48: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 = '82267' 13/03/2023 09:48:17 am >> DELETE FROM ps_document_detail WHERE id_document = '82267' 13/03/2023 09:48:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82267' , '10208' , 'STATUA MARIA CHE SCIOGLIE NODI CM 20' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 13/03/2023 09:48:45 am >> SELECT document_num FROM ps_document WHERE document_num = '815' AND id_document != '82267' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 09:48:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '815', document_date = '2023-03-13', 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 = '16.00', price_tax_excluded = '13.11', date_upd = NOW() WHERE id_document = '82267' 13/03/2023 09:48:46 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 = '82267' 13/03/2023 09:48:46 am >> DELETE FROM ps_document_detail WHERE id_document = '82267' 13/03/2023 09:48:46 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 ( '82267' , '10208' , 'STATUA MARIA CHE SCIOGLIE NODI CM 20' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 13/03/2023 10:12:57 am >> SELECT document_num FROM ps_document WHERE document_num = '816' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 10:12:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '816' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.00' , '327.87' , NOW() , NOW() ) 13/03/2023 10:12:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82268' 13/03/2023 10:12:57 am >> DELETE FROM ps_document_detail WHERE id_document = '82268' 13/03/2023 10:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82268' , '12238' , 'NAVETTA CLASSICA H13 CM' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 13/03/2023 10:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82268' , '12237' , 'TURIBOLO H28 CM' , '1' , '-1' , '1' , '180.00' , '147.54098360656' , '22' , '0' , '180.00' ) 13/03/2023 10:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82268' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' ) 13/03/2023 10:42:58 am >> SELECT document_num FROM ps_document WHERE document_num = '817' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 10:42:58 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' , '817' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '14.01' , NOW() , NOW() ) 13/03/2023 10:42:58 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 = '82269' 13/03/2023 10:42:58 am >> DELETE FROM ps_document_detail WHERE id_document = '82269' 13/03/2023 10:42:58 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 ( '82269' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 13/03/2023 10:42:58 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 ( '82269' , '20795' , 'SULLA TUA PAROLA MAG GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/03/2023 10:42:58 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 ( '82269' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/03/2023 10:42:58 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 ( '82269' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '0.60' ) 13/03/2023 11:03:59 am >> SELECT document_num FROM ps_document WHERE document_num = '818' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 11:03:59 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' , '818' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.18' , '23.41' , NOW() , NOW() ) 13/03/2023 11:03: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 = '82270' 13/03/2023 11:03:59 am >> DELETE FROM ps_document_detail WHERE id_document = '82270' 13/03/2023 11:03: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 ( '82270' , '529' , 'AMORIS LAETITIA' , '2' , '-2' , '4' , '2.20' , '2.2' , '0' , '5' , '4.18' ) 13/03/2023 11:03: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 ( '82270' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 13/03/2023 11:06:15 am >> SELECT document_num FROM ps_document WHERE document_num = '819' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 11:06:15 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' , '819' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.06' , '16.06' , NOW() , NOW() ) 13/03/2023 11:06:15 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 = '82271' 13/03/2023 11:06:15 am >> DELETE FROM ps_document_detail WHERE id_document = '82271' 13/03/2023 11:06:15 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 ( '82271' , '20794' , 'CERCA IL TUO ORIZZONTE ' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 13/03/2023 11:13:11 am >> SELECT document_num FROM ps_document WHERE document_num = '820' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 11:13:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '820' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.00' , '52.46' , NOW() , NOW() ) 13/03/2023 11:13:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82272' 13/03/2023 11:13:11 am >> DELETE FROM ps_document_detail WHERE id_document = '82272' 13/03/2023 11:13:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82272' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '60.00' ) 13/03/2023 11:13:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82272' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 13/03/2023 12:01:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '81297' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-09') 13/03/2023 12:01:06 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '21/A', document_date = '2023-02-09', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'OSP. S. LEONARDO', note = 'OSP. S. LEONARDO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '299.60', price_tax_excluded = '260.45', date_upd = NOW() WHERE id_document = '81297' 13/03/2023 12:01:06 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 = '81297' 13/03/2023 12:01:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '81297' 13/03/2023 12:01:06 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 ( '81297' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 13/03/2023 12:01:06 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 ( '81297' , '0' , '22/02/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 13/03/2023 12:01:06 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 ( '81297' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 13/03/2023 12:01:06 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 ( '81297' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 13/03/2023 12:01:06 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 ( '81297' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 13/03/2023 12:01:06 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 ( '81297' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 13/03/2023 12:01:06 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 ( '81297' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 13/03/2023 12:01:06 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 ( '81297' , '20068' , 'CORONA ROSARIO ACCIAIO - NS086' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 13/03/2023 12:01:06 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 ( '81297' , '0' , '01/03/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 13/03/2023 12:01:06 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 ( '81297' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 13/03/2023 12:01:06 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 ( '81297' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 13/03/2023 12:01:06 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 ( '81297' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 13/03/2023 12:01:06 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 ( '81297' , '0' , '07/03/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 13/03/2023 12:01:06 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 ( '81297' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 13/03/2023 12:01:06 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 ( '81297' , '0' , 'BUSTE PER PALME' , '1' , '-1' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '9.50' ) 13/03/2023 12:01:06 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 ( '81297' , '17880' , 'CROCE FAGGIO CORPO MET. CM 25 - 168' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 13/03/2023 12:01:06 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 ( '81297' , '17884' , 'CROCE MOGANO CORPO MET CM 25 - 168M' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 13/03/2023 12:01:06 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 ( '81297' , '' , '13/03' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 13/03/2023 12:01:06 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 ( '81297' , '' , 'BUSTE PER PALME' , '1' , '-1' , '0' , '9.5' , '9.5' , '' , '0' , '9.50' ) 13/03/2023 12:01:06 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 ( '81297' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.70' , '0.7' , '0' , '0' , '35.00' ) 13/03/2023 12:01:06 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 ( '81297' , '20071' , 'ROSARIO MISSIONARIO MM8' , '17' , '-17' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '20.40' ) 13/03/2023 12:23:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '821' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 12:23:06 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' , '821' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '579.90' , '482.70' , NOW() , NOW() ) 13/03/2023 12:23:06 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 = '82273' 13/03/2023 12:23:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '82273' 13/03/2023 12:23:06 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 ( '82273' , '16456' , 'CINGOLO - CING03' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '28.00' ) 13/03/2023 12:23:06 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 ( '82273' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 13/03/2023 12:23:06 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 ( '82273' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 13/03/2023 12:23:06 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 ( '82273' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 13/03/2023 12:23:07 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 ( '82273' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 13/03/2023 12:23:07 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 ( '82273' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 13/03/2023 12:23:07 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 ( '82273' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 13/03/2023 12:23:07 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 ( '82273' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 13/03/2023 12:23:07 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 ( '82273' , '11960' , 'PASSIO' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 13/03/2023 12:23:07 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 ( '82273' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20' , '16.393442622951' , '22' , '0' , '100.00' ) 13/03/2023 12:23:07 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 ( '82273' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 13/03/2023 12:23:07 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 ( '82273' , '1041' , 'BENEDIZIONI' , '1000' , '-1000' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '150.00' ) 13/03/2023 12:38:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '822' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 12:38:13 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' , '822' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 13/03/2023 12:38:13 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 = '82274' 13/03/2023 12:38:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82274' 13/03/2023 12:38:14 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 ( '82274' , '17160' , 'CARBONCINI ROSSI - CARRO' , '4' , '-4' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '40.00' ) 13/03/2023 12:44:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '823' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 12:44:43 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' , '823' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 13/03/2023 12:44:43 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 = '82275' 13/03/2023 12:44:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '82275' 13/03/2023 12:44:43 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 ( '82275' , '20826' , 'PADELLA CM 17' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 13/03/2023 12:49:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '824' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 12:49:30 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' , '824' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 13/03/2023 12:49:30 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 = '82276' 13/03/2023 12:49:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '82276' 13/03/2023 12:49:30 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 ( '82276' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 13/03/2023 02:42:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '816' AND id_document != '82268' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 02:42:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '816', document_date = '2023-03-13', 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 = '400.00', price_tax_excluded = '327.87', date_upd = NOW() WHERE id_document = '82268' 13/03/2023 02:42:25 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 = '82268' 13/03/2023 02:42:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '82268' 13/03/2023 02:42:25 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 ( '82268' , '12238' , 'NAVETTA CLASSICA H13 CM' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 13/03/2023 02:42:25 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 ( '82268' , '12237' , 'TURIBOLO H28 CM' , '1' , '-1' , '1' , '180.0000' , '147.54098360656' , '22' , '0' , '180.00' ) 13/03/2023 02:42:25 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 ( '82268' , '1041' , 'BENEDIZIONI' , '1000' , '-1000' , '1' , '0.13' , '0.10655737704918' , '22' , '0' , '130.00' ) 13/03/2023 02:42:25 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 ( '82268' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 13/03/2023 02:43:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '821' AND id_document != '82273' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 02:43:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '821', document_date = '2023-03-13', 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 = '579.90', price_tax_excluded = '482.70', date_upd = NOW() WHERE id_document = '82273' 13/03/2023 02:43:13 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 = '82273' 13/03/2023 02:43:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82273' 13/03/2023 02:43:13 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 ( '82273' , '16456' , 'CINGOLO - CING03' , '2' , '-2' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '28.00' ) 13/03/2023 02:43:13 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 ( '82273' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 13/03/2023 02:43:13 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 ( '82273' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 13/03/2023 02:43:13 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 ( '82273' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 13/03/2023 02:43:13 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 ( '82273' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 13/03/2023 02:43:13 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 ( '82273' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 13/03/2023 02:43:13 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 ( '82273' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 13/03/2023 02:43:13 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 ( '82273' , '11960' , 'PASSIO' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 13/03/2023 02:43:13 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 ( '82273' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '100.00' ) 13/03/2023 02:43:13 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 ( '82273' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '305' , '250' , '22' , '0' , '305.00' ) 13/03/2023 02:44:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '750' AND id_document != '82183' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 13/03/2023 02:44:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '750', document_date = '2023-03-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '82183' 13/03/2023 02:44: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 = '82183' 13/03/2023 02:44:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '82183' 13/03/2023 02:44: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 ( '82183' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 13/03/2023 02:44:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '821' AND id_document != '82273' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 02:44:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '821', document_date = '2023-03-13', 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 = '579.90', price_tax_excluded = '482.70', date_upd = NOW() WHERE id_document = '82273' 13/03/2023 02:44:58 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 = '82273' 13/03/2023 02:44:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '82273' 13/03/2023 02:44:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82273' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 13/03/2023 02:44:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82273' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 13/03/2023 02:44:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82273' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 13/03/2023 02:44:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82273' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 13/03/2023 02:44:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82273' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 13/03/2023 02:44:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82273' , '11960' , 'PASSIO' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 13/03/2023 02:44:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82273' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '100.00' ) 13/03/2023 02:44:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82273' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '401' , '328.68852459016' , '22' , '0' , '401.00' ) 13/03/2023 02:45:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '765' AND id_document != '82199' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-08') 13/03/2023 02:45:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '765', document_date = '2023-03-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '33.60', price_tax_excluded = '28.91', date_upd = NOW() WHERE id_document = '82199' 13/03/2023 02:45:27 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 = '82199' 13/03/2023 02:45:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '82199' 13/03/2023 02:45:27 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 ( '82199' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 13/03/2023 02:45:27 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 ( '82199' , '17876' , 'GIUSEPPE NON TEMERE! - M. GATTAFONI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 13/03/2023 02:45:27 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 ( '82199' , '16456' , 'CINGOLO - CING03' , '2' , '-2' , '1' , '13' , '10.655737704918' , '22' , '0' , '26.00' ) 13/03/2023 02:46:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '821' AND id_document != '82273' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 02:46:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '821', document_date = '2023-03-13', 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 = '579.90', price_tax_excluded = '482.70', date_upd = NOW() WHERE id_document = '82273' 13/03/2023 02:46:09 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 = '82273' 13/03/2023 02:46:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '82273' 13/03/2023 02:46:09 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 ( '82273' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 13/03/2023 02:46:09 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 ( '82273' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 13/03/2023 02:46:09 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 ( '82273' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 13/03/2023 02:46:09 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 ( '82273' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 13/03/2023 02:46:09 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 ( '82273' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 13/03/2023 02:46:09 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 ( '82273' , '11960' , 'PASSIO' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 13/03/2023 02:46:09 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 ( '82273' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '100.00' ) 13/03/2023 02:46:09 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 ( '82273' , '19447' , 'CASULA L/S MOIRE - RICAMO DIRETTO - 7976LS' , '1' , '-1' , '1' , '401' , '328.68852459016' , '22' , '0' , '401.00' ) 13/03/2023 03:18:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '28/A' AND id_document != '82094' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-02') 13/03/2023 03:18:04 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '28/A', document_date = '2023-03-02', document_letter = 'A', id_customer = '2624', id_supplier = '', id_address = '4670911', address1 = 'P. ZZA ANNUNZIATA 84095 GIFFONI VALLE PIANA', address2 = '', note = 'conto vendita presentazione libro', 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 = '840.00', price_tax_excluded = '840.00', date_upd = NOW() WHERE id_document = '82094' 13/03/2023 03:18: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 = '82094' 13/03/2023 03:18:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '82094' 13/03/2023 03:18: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 ( '82094' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '45' , '-45' , '4' , '14.0000' , '14' , '0' , '0' , '630.00' ) 13/03/2023 03:18: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 ( '82094' , '' , '13/03' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 13/03/2023 03:18: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 ( '82094' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '15' , '-15' , '4' , '14.00' , '14' , '0' , '0' , '210.00' ) 13/03/2023 03:18:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '825' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 03:18:24 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' , '825' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 13/03/2023 03:18:24 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 = '82277' 13/03/2023 03:18:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '82277' 13/03/2023 03:18:24 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 ( '82277' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 13/03/2023 03:18:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '826' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 03:18:34 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' , '826' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 13/03/2023 03:18:34 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 = '82278' 13/03/2023 03:18:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '82278' 13/03/2023 03:18:34 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 ( '82278' , '17853' , 'SAN GIUSEPPE, AFFIDAMENTO - A. COMASTRI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 13/03/2023 03:35:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '10027' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-13') 13/03/2023 03:35:54 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '7', document_date = '2023-02-13', document_letter = '', id_customer = '6949', id_supplier = '', id_address = '51344707', address1 = 'Via Pe Pretis , 2 38050 Roncegno Terme', address2 = '', note = '', price_shipping = '7', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '957.00', price_tax_excluded = '957.00', date_upd = NOW() WHERE id_document = '10027' 13/03/2023 03:35: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 = '10027' 13/03/2023 03:35:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '10027' 13/03/2023 03:35: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 ( '10027' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '50' , '-50' , '4' , '2.0000' , '2' , '0' , '5' , '95.00' ) 13/03/2023 03:35:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '10027' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '30' , '-30' , '4' , '30.0000' , '30' , '0' , '5' , '855.00' ) 13/03/2023 03:53:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '827' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 03:53:50 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' , '827' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.42' , '55.50' , NOW() , NOW() ) 13/03/2023 03:53: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 = '82279' 13/03/2023 03:53:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '82279' 13/03/2023 03:53: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 ( '82279' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 13/03/2023 03:53: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 ( '82279' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 13/03/2023 03:53: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 ( '82279' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 13/03/2023 03:53: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 ( '82279' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/03/2023 03:53: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 ( '82279' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/03/2023 03:53: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 ( '82279' , '20766' , 'AMEN - GIU 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 13/03/2023 03:53: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 ( '82279' , '20765' , 'AMEN - MAG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 13/03/2023 03:54:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '828' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 03:54:36 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' , '828' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 13/03/2023 03:54:36 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 = '82280' 13/03/2023 03:54:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '82280' 13/03/2023 03:54:36 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 ( '82280' , '20765' , 'AMEN - MAG 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 13/03/2023 03:54:36 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 ( '82280' , '20766' , 'AMEN - GIU 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 13/03/2023 03:57:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '829' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 03:57:26 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' , '829' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '36.07' , NOW() , NOW() ) 13/03/2023 03:57:26 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 = '82281' 13/03/2023 03:57:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '82281' 13/03/2023 03:57:26 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 ( '82281' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '44.00' ) 13/03/2023 04:03:58 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 ( '33' , '1290/00' , '2023-03-07' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 13/03/2023 04:03:58 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 = '82282' 13/03/2023 04:03:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '82282' 13/03/2023 04:03:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82282' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '6' , '6' , '4' , '2.00' , '2' , '0' , '0' , '12.0000' ) 13/03/2023 04:05: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 ( '33' , '1291/00' , '2023-03-01' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '410.00' , '410.00' , NOW() , NOW() ) 13/03/2023 04:05: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 = '11058' 13/03/2023 04:05:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '11058' 13/03/2023 04:05: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 ( '11058' , '17' , 'LA FEDE NELLO ZAINETTO' , '24' , '24' , '4' , '5' , '5' , '0' , '0' , '120.0000' ) 13/03/2023 04:05: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 ( '11058' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '116' , '116' , '4' , '2.50' , '2.5' , '0' , '0' , '290.0000' ) 13/03/2023 04:06:14 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '1291/00', document_date = '2023-03-01', document_letter = '00', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESO', 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 = '410.00', price_tax_excluded = '410.00', date_upd = NOW() WHERE id_document = '11058' 13/03/2023 04:06:14 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 = '11058' 13/03/2023 04:06:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '11058' 13/03/2023 04:06:14 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 ( '11058' , '17' , 'LA FEDE NELLO ZAINETTO' , '24' , '24' , '4' , '5.0000' , '5' , '0' , '0' , '120.00' ) 13/03/2023 04:06:14 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 ( '11058' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '116' , '116' , '4' , '2.5000' , '2.5' , '0' , '0' , '290.00' ) 13/03/2023 05:48:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '33/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 05:48:21 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' , '33/A' , '2023-03-13' , 'A' , '230' , '0' , '4668969' , 'VIA G. NICOTERA, 66 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.50' , NOW() , NOW() ) 13/03/2023 05:48:21 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 = '82283' 13/03/2023 05:48:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '82283' 13/03/2023 05:48: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 ( '82283' , '' , 'TEMPO DI QUARESIMA' , '10' , '-10' , '0' , '0.85' , '0.85' , '' , '0' , '8.50' ) 13/03/2023 06:52:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '830' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 06:52:00 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' , '830' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '390.00' , '341.00' , NOW() , NOW() ) 13/03/2023 06:52: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 = '82284' 13/03/2023 06:52:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '82284' 13/03/2023 06:52: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 ( '82284' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 13/03/2023 06:52: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 ( '82284' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 13/03/2023 06:52: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 ( '82284' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 13/03/2023 06:52: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 ( '82284' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 13/03/2023 06:52: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 ( '82284' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20' , '16.393442622951' , '22' , '0' , '100.00' ) 13/03/2023 06:52: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 ( '82284' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '75' , '75' , '0' , '0' , '75.00' ) 13/03/2023 06:53:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '831' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 06:53: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' , '831' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '910.00' , '745.90' , NOW() , NOW() ) 13/03/2023 06:53: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 = '82285' 13/03/2023 06:53:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '82285' 13/03/2023 06:53: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 ( '82285' , '13160' , 'CASULA MOD. CRISTOGRAMMA - cs12271' , '2' , '-2' , '1' , '385' , '315.5737704918' , '22' , '0' , '770.00' ) 13/03/2023 06:53: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 ( '82285' , '20273' , 'CASULA IHS - 220' , '2' , '-2' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '140.00' ) 13/03/2023 07:02:39 pm >> DELETE FROM ps_document WHERE id_document = '81372' 13/03/2023 07:02:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '81372' 13/03/2023 07:20:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '832' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 07:20:57 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' , '832' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 13/03/2023 07:20:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82286' 13/03/2023 07:20:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '82286' 13/03/2023 07:20:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82286' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 13/03/2023 07:29:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '833' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 13/03/2023 07:29:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '833' , '2023-03-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.80' , '25.90' , NOW() , NOW() ) 13/03/2023 07:29:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82287' 13/03/2023 07:29:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '82287' 13/03/2023 07:29:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 13/03/2023 07:29:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 13/03/2023 07:29:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 13/03/2023 07:29:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '6.80' , '5.5737704918033' , '22' , '0' , '6.80' )