24/05/2025 09:03:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1819' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 09:03: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 ( '11' , '1819' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.80' , '14.92' , NOW() , NOW() ) 24/05/2025 09:03: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 = '97357' 24/05/2025 09:03:07 am >> DELETE FROM ps_document_detail WHERE id_document = '97357' 24/05/2025 09:03: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 ( '97357' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 24/05/2025 09:03: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 ( '97357' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10.9' , '10.9' , '0' , '0' , '10.90' ) 24/05/2025 09:50:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1820' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 09:50:28 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' , '1820' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 24/05/2025 09:50:28 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 = '97358' 24/05/2025 09:50:28 am >> DELETE FROM ps_document_detail WHERE id_document = '97358' 24/05/2025 09:50:28 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 ( '97358' , '4488' , 'GESÙ NEL CUORE - LA MIA PRIMA COMUNIONE' , '10' , '-10' , '4' , '1.90' , '1.9' , '0' , '0' , '19.00' ) 24/05/2025 10:03:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1821' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 10:03: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' , '1821' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 24/05/2025 10:03: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 = '97359' 24/05/2025 10:03:08 am >> DELETE FROM ps_document_detail WHERE id_document = '97359' 24/05/2025 10:03: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 ( '97359' , '14308' , 'ALLA SCOPERTA DELLA BIBBIA' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 24/05/2025 10:03: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 ( '97359' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '100' , '0.00' ) 24/05/2025 10:07:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1822' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 10:07: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' , '1822' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 24/05/2025 10:07: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 = '97360' 24/05/2025 10:07:26 am >> DELETE FROM ps_document_detail WHERE id_document = '97360' 24/05/2025 10:07: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 ( '97360' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 24/05/2025 10:08:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1823' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 10:08: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' , '1823' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 24/05/2025 10:08: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 = '97361' 24/05/2025 10:08:58 am >> DELETE FROM ps_document_detail WHERE id_document = '97361' 24/05/2025 10:08: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 ( '97361' , '22464' , 'CASULA LEGGERA - 1212' , '2' , '-2' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '150.00' ) 24/05/2025 10:46:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1824' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 10:46:50 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' , '1824' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '158.00' , '129.51' , NOW() , NOW() ) 24/05/2025 10:46:50 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 = '97362' 24/05/2025 10:46:50 am >> DELETE FROM ps_document_detail WHERE id_document = '97362' 24/05/2025 10:46:50 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 ( '97362' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '125' , '102.45901639344' , '22' , '0' , '125.00' ) 24/05/2025 10:46:50 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 ( '97362' , '920' , 'BALZA RICAMATA CM 9,6 - BIANCA - KOM/030 - OGGETTI' , '1.5' , '-1.5' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '33.00' ) 24/05/2025 10:48:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1825' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 10:48:39 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' , '1825' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 24/05/2025 10:48:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97363' 24/05/2025 10:48:39 am >> DELETE FROM ps_document_detail WHERE id_document = '97363' 24/05/2025 10:48:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97363' , '23384' , 'DECINA LEGNO - FR07' , '7' , '-7' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.90' ) 24/05/2025 11:18:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1826' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 11:18:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1826' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '204.92' , NOW() , NOW() ) 24/05/2025 11:18:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97364' 24/05/2025 11:18:05 am >> DELETE FROM ps_document_detail WHERE id_document = '97364' 24/05/2025 11:18:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97364' , '12540' , 'COMPLETO AMPOLLE 5 PEZZI - ATD729' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 24/05/2025 11:18:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1827' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 11:18:45 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' , '1827' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.50' , '32.38' , NOW() , NOW() ) 24/05/2025 11:18:45 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 = '97365' 24/05/2025 11:18:45 am >> DELETE FROM ps_document_detail WHERE id_document = '97365' 24/05/2025 11:18: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 ( '97365' , '2178' , 'CLERGY BASIC EXTRA - MM - B&P' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 24/05/2025 11:24:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1828' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 11:24:03 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' , '1828' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 24/05/2025 11:24:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97366' 24/05/2025 11:24:03 am >> DELETE FROM ps_document_detail WHERE id_document = '97366' 24/05/2025 11:24:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97366' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 24/05/2025 11:33:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1829' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 11:33: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 ( '11' , '1829' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 24/05/2025 11:33: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 = '97367' 24/05/2025 11:33:12 am >> DELETE FROM ps_document_detail WHERE id_document = '97367' 24/05/2025 11:33: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 ( '97367' , '22353' , 'CROCE COMUNIONE - 646' , '10' , '-10' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '18.00' ) 24/05/2025 11:33:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1830' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 11:33:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1830' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 24/05/2025 11:33:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97368' 24/05/2025 11:33:22 am >> DELETE FROM ps_document_detail WHERE id_document = '97368' 24/05/2025 11:33:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97368' , '22353' , 'CROCE COMUNIONE - 646' , '5' , '-5' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '9.00' ) 24/05/2025 11:36:41 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 24/05/2025 11:36:41 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '615.42', price_tax_excluded = '509.13', date_upd = NOW() WHERE id_document = '95409' 24/05/2025 11:36:41 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 = '95409' 24/05/2025 11:36:42 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 24/05/2025 11:36:42 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 ( '95409' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '90.00' ) 24/05/2025 11:36:42 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 ( '95409' , '0' , '9/3/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 24/05/2025 11:36:42 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 ( '95409' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '25' , '-25' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '60.00' ) 24/05/2025 11:36:42 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 ( '95409' , '0' , '27/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 24/05/2025 11:36:42 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 ( '95409' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '18' , '-18' , '4' , '0.7000' , '0.7' , '0' , '0' , '12.60' ) 24/05/2025 11:36:42 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 ( '95409' , '0' , '26/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 24/05/2025 11:36:42 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 ( '95409' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 24/05/2025 11:36:42 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 ( '95409' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 24/05/2025 11:36:42 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 ( '95409' , '0' , '11/04' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 24/05/2025 11:36:42 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 ( '95409' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '145.00' ) 24/05/2025 11:36:42 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 ( '95409' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 24/05/2025 11:36:42 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 ( '95409' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 24/05/2025 11:36:42 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 ( '95409' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.3400' , '2.7377049180328' , '22' , '0' , '10.02' ) 24/05/2025 11:36:42 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 ( '95409' , '7202' , 'ARTICOLI RELIGIOSI buste palma' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 24/05/2025 11:36:42 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 ( '95409' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 24/05/2025 11:36:42 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 ( '95409' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 24/05/2025 11:36:42 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 ( '95409' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 24/05/2025 11:36:42 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 ( '95409' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '56.00' ) 24/05/2025 11:36:42 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 ( '95409' , '0' , '30/04/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 24/05/2025 11:36:42 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 ( '95409' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 24/05/2025 11:36:42 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 ( '95409' , '' , '24/05' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 24/05/2025 11:36:42 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 ( '95409' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 24/05/2025 11:37:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1802' AND id_document != '97338' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 24/05/2025 11:37:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1802', document_date = '2025-05-22', 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 = '6.00', price_tax_excluded = '4.92', date_upd = NOW() WHERE id_document = '97338' 24/05/2025 11:37:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97338' 24/05/2025 11:37:19 am >> DELETE FROM ps_document_detail WHERE id_document = '97338' 24/05/2025 11:37:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97338' , '23757' , 'MEDAGLIA SAN BENEDETTO - M244/A SM' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 24/05/2025 11:37:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1770' AND id_document != '97300' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 24/05/2025 11:37:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1770', document_date = '2025-05-21', 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 = '47.80', price_tax_excluded = '43.22', date_upd = NOW() WHERE id_document = '97300' 24/05/2025 11:37:37 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 = '97300' 24/05/2025 11:37:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97300' 24/05/2025 11:37:37 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 ( '97300' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '15.80' ) 24/05/2025 11:37:37 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 ( '97300' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 24/05/2025 11:37:37 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 ( '97300' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '9.00' ) 24/05/2025 11:37:37 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 ( '97300' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 24/05/2025 11:37:37 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 ( '97300' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 24/05/2025 11:37:37 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 ( '97300' , '23757' , 'MEDAGLIA SAN BENEDETTO - M244/A SM' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 24/05/2025 11:39:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1641' AND id_document != '97153' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-13') 24/05/2025 11:39:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1641', document_date = '2025-05-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 = '48.00', price_tax_excluded = '39.81', date_upd = NOW() WHERE id_document = '97153' 24/05/2025 11:39: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 = '97153' 24/05/2025 11:39:26 am >> DELETE FROM ps_document_detail WHERE id_document = '97153' 24/05/2025 11:39: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 ( '97153' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.6000' , '2.6' , '0' , '0' , '2.60' ) 24/05/2025 11:39: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 ( '97153' , '22299' , 'BRUCIA INCENSO PADELLA CM 17 - 12-750' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 24/05/2025 11:39: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 ( '97153' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 24/05/2025 11:39: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 ( '97153' , '23383' , 'BRACCIALE DECINA - BD020' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 24/05/2025 11:39: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 ( '97153' , '20063' , 'BRACCIALE EMATITE - BC2023S' , '1' , '-1' , '1' , '7.2' , '5.9016393442623' , '22' , '0' , '7.20' ) 24/05/2025 11:41:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1831' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 11:41:41 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' , '1831' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.90' , '6.90' , NOW() , NOW() ) 24/05/2025 11:41:41 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 = '97369' 24/05/2025 11:41:41 am >> DELETE FROM ps_document_detail WHERE id_document = '97369' 24/05/2025 11:41:41 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 ( '97369' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.9' , '6.9' , '0' , '0' , '6.90' ) 24/05/2025 12:02:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1832' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 12:02:11 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' , '1832' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '4.00' , NOW() , NOW() ) 24/05/2025 12:02:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97370' 24/05/2025 12:02:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '97370' 24/05/2025 12:02:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97370' , '23650' , 'PREGHIAMO IL ROSARIO CON CARLO ACUTIS' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 24/05/2025 12:08:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1833' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 12:08:42 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' , '1833' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '62.44' , NOW() , NOW() ) 24/05/2025 12:08:42 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 = '97371' 24/05/2025 12:08:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '97371' 24/05/2025 12:08:42 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 ( '97371' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '52' , '42.622950819672' , '22' , '0' , '52.00' ) 24/05/2025 12:08:42 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 ( '97371' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 24/05/2025 12:08:42 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 ( '97371' , '11882' , '365 GIORNI CON LA BIBBIA - 8827' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 24/05/2025 12:26:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1834' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 12:26:05 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' , '1834' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.30' , '30.69' , NOW() , NOW() ) 24/05/2025 12:26:05 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 = '97372' 24/05/2025 12:26:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '97372' 24/05/2025 12:26:05 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 ( '97372' , '11151' , 'LIBRI' , '10' , '-10' , '4' , '1.5' , '1.5' , '0' , '5' , '14.30' ) 24/05/2025 12:26:05 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 ( '97372' , '18895' , 'BRACCIALE DECINA COLORATA - B1757N' , '10' , '-10' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '20.00' ) 24/05/2025 12:29:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '96750' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-17') 24/05/2025 12:29:14 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '63/A', document_date = '2025-04-17', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '197.70', price_tax_excluded = '167.79', date_upd = NOW() WHERE id_document = '96750' 24/05/2025 12:29: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 = '96750' 24/05/2025 12:29:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '96750' 24/05/2025 12:29: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 ( '96750' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '17.80' ) 24/05/2025 12:29: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 ( '96750' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '8' , '-8' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '28.00' ) 24/05/2025 12:29: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 ( '96750' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 24/05/2025 12:29: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 ( '96750' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 24/05/2025 12:29: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 ( '96750' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 24/05/2025 12:29: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 ( '96750' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '17.50' ) 24/05/2025 12:29:15 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 ( '96750' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 24/05/2025 12:29:15 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 ( '96750' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 24/05/2025 12:29:15 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 ( '96750' , '6014' , 'LUMINO BIANCO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 24/05/2025 12:29:15 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 ( '96750' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 24/05/2025 12:29:15 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 ( '96750' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 24/05/2025 12:29:15 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 ( '96750' , '' , '24/05' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 24/05/2025 12:29:15 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 ( '96750' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 24/05/2025 12:44:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1835' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 12:44:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1835' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 24/05/2025 12:44:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97373' 24/05/2025 12:44:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '97373' 24/05/2025 12:44:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97373' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 24/05/2025 12:52:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1836' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 24/05/2025 12:52:47 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' , '1836' , '2025-05-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '10.44' , NOW() , NOW() ) 24/05/2025 12:52:47 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 = '97374' 24/05/2025 12:52:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '97374' 24/05/2025 12:52:47 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 ( '97374' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 24/05/2025 12:52:47 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 ( '97374' , '1312' , 'BRACCIALE DECINA' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 24/05/2025 12:52:47 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 ( '97374' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.1' , '6.1' , '0' , '0' , '6.10' )