20/04/2024 08:22:00 am >> SELECT document_num FROM ps_document WHERE document_num = '52/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 08:22:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '52/A' , '2024-04-20' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '156.00' , '156.00' , NOW() , NOW() ) 20/04/2024 08:22:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91347' 20/04/2024 08:22:00 am >> DELETE FROM ps_document_detail WHERE id_document = '91347' 20/04/2024 08:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91347' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '4' , '-4' , '0' , '39.00' , '39' , '' , '0' , '156.00' ) 20/04/2024 09:12:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 09:12:42 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' , '1219' , '2024-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 20/04/2024 09:12:42 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 = '91348' 20/04/2024 09:12:42 am >> DELETE FROM ps_document_detail WHERE id_document = '91348' 20/04/2024 09:12: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 ( '91348' , '11151' , 'LIBRI' , '30' , '-30' , '4' , '0.15' , '0.15' , '0' , '0' , '4.50' ) 20/04/2024 09:24:21 am >> SELECT document_num FROM ps_document WHERE document_num = '52/A' AND id_document != '91347' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 09:24:21 am >> UPDATE ps_document SET id_document_type = '24', document_num = '52/A', document_date = '2024-04-20', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '195.00', price_tax_excluded = '195.00', date_upd = NOW() WHERE id_document = '91347' 20/04/2024 09:24:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91347' 20/04/2024 09:24:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91347' 20/04/2024 09:24:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91347' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '5' , '-5' , '0' , '39.0000' , '39' , '' , '0' , '195.00' ) 20/04/2024 09:25:42 am >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 09:25:42 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' , '53/A' , '2024-04-20' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , 'padre Gian Mario' , 'per PADRE GIAN MARIO - FRANCIA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.60' , '165.60' , NOW() , NOW() ) 20/04/2024 09:25:42 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 = '91349' 20/04/2024 09:25:42 am >> DELETE FROM ps_document_detail WHERE id_document = '91349' 20/04/2024 09:25: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 ( '91349' , '11756' , 'VINO BIANCO SECCO - 14%' , '24' , '-24' , '0' , '6.90' , '6.9' , '' , '0' , '165.60' ) 20/04/2024 09:28:06 am >> DELETE FROM ps_document WHERE id_document = '91347' 20/04/2024 09:28:06 am >> DELETE FROM ps_document_detail WHERE id_document = '91347' 20/04/2024 09:30:30 am >> SELECT document_num FROM ps_document WHERE document_num = '898' AND id_document != '90948' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-26') 20/04/2024 09:30:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '898', document_date = '2024-03-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.50', price_tax_excluded = '83.87', date_upd = NOW() WHERE id_document = '90948' 20/04/2024 09:30:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90948' 20/04/2024 09:30:30 am >> DELETE FROM ps_document_detail WHERE id_document = '90948' 20/04/2024 09:30:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90948' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 20/04/2024 09:30:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90948' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 20/04/2024 09:30:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90948' , '11756' , 'VINO BIANCO SECCO - 14%' , '4' , '-4' , '1' , '5' , '4.0983606557377' , '22' , '0' , '20.00' ) 20/04/2024 09:30:59 am >> SELECT document_num FROM ps_document WHERE document_num = '987' AND id_document != '91044' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 20/04/2024 09:30:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '987', document_date = '2024-04-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.00', price_tax_excluded = '81.97', date_upd = NOW() WHERE id_document = '91044' 20/04/2024 09:30: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 = '91044' 20/04/2024 09:30:59 am >> DELETE FROM ps_document_detail WHERE id_document = '91044' 20/04/2024 09:30: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 ( '91044' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 20/04/2024 09:30: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 ( '91044' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '2.80' ) 20/04/2024 09:30: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 ( '91044' , '2222' , 'CLERGY F/F ML GRIGIO - 41' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 20/04/2024 09:30: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 ( '91044' , '11756' , 'VINO BIANCO SECCO - 14%' , '11' , '-11' , '1' , '5' , '4.0983606557377' , '22' , '0' , '55.00' ) 20/04/2024 09:31:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1029' AND id_document != '91103' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 20/04/2024 09:31:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1029', document_date = '2024-04-05', 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 = '20.50', price_tax_excluded = '17.16', date_upd = NOW() WHERE id_document = '91103' 20/04/2024 09:31: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 = '91103' 20/04/2024 09:31:16 am >> DELETE FROM ps_document_detail WHERE id_document = '91103' 20/04/2024 09:31:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91103' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 20/04/2024 09:31:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91103' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 20/04/2024 09:31:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91103' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 20/04/2024 09:32:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1070' AND id_document != '91161' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-08') 20/04/2024 09:32:10 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1070', document_date = '2024-04-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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '91161' 20/04/2024 09:32:10 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 = '91161' 20/04/2024 09:32:10 am >> DELETE FROM ps_document_detail WHERE id_document = '91161' 20/04/2024 09:32:10 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 ( '91161' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 20/04/2024 09:32:10 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 ( '91161' , '11756' , 'VINO BIANCO SECCO - 14%' , '8' , '-8' , '1' , '6' , '4.9180327868852' , '22' , '0' , '48.00' ) 20/04/2024 09:33:43 am >> DELETE FROM ps_document WHERE id_document = '91349' 20/04/2024 09:33:43 am >> DELETE FROM ps_document_detail WHERE id_document = '91349' 20/04/2024 09:34:13 am >> SELECT document_num FROM ps_document WHERE document_num = '308' AND id_document != '89327' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-04') 20/04/2024 09:34:13 am >> UPDATE ps_document SET id_document_type = '21', document_num = '308', document_date = '2023-12-04', document_letter = '', id_customer = '1237', id_supplier = '', id_address = '4679207', address1 = 'VIA MILANO 11 97019 VITTORIA', address2 = '', note = '', price_shipping = '7.30', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '315.00', price_tax_excluded = '315.00', date_upd = NOW() WHERE id_document = '89327' 20/04/2024 09:34: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 = '89327' 20/04/2024 09:34:13 am >> DELETE FROM ps_document_detail WHERE id_document = '89327' 20/04/2024 09:34: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 ( '89327' , '3511' , 'DIO PARLA ALL\'UOMO' , '10' , '-10' , '4' , '12.0000' , '12' , '0' , '15' , '102.00' ) 20/04/2024 09:34: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 ( '89327' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '10' , '-10' , '4' , '9.0000' , '9' , '0' , '15' , '76.50' ) 20/04/2024 09:34: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 ( '89327' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '15' , '21.25' ) 20/04/2024 09:34: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 ( '89327' , '12253' , 'MIO LIBRO DI PREGHIERE' , '40' , '-40' , '4' , '2.8000' , '2.8' , '0' , '15' , '95.20' ) 20/04/2024 09:34: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 ( '89327' , '9996' , 'SIGNORE, TI PREGO' , '3' , '-3' , '4' , '4.2500' , '4.25' , '0' , '' , '12.75' ) 20/04/2024 09:57:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 09:57:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1220' , '2024-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 20/04/2024 09:57:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91350' 20/04/2024 09:57:00 am >> DELETE FROM ps_document_detail WHERE id_document = '91350' 20/04/2024 09:57:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91350' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '1' , '-1' , '1' , '12.5' , '10.245901639344' , '22' , '0' , '12.50' ) 20/04/2024 09:57:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91350' , '22286' , 'COLLETTO DOPPIO MISTO LINO - CD01/C' , '1' , '-1' , '1' , '17.50' , '14.344262295082' , '22' , '0' , '17.50' ) 20/04/2024 10:12:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 10:12: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' , '1221' , '2024-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/04/2024 10:12: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 = '91351' 20/04/2024 10:12:39 am >> DELETE FROM ps_document_detail WHERE id_document = '91351' 20/04/2024 10:12: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 ( '91351' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/04/2024 10:51:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 10:51:43 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' , '1222' , '2024-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.70' , '7.50' , NOW() , NOW() ) 20/04/2024 10:51:43 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 = '91352' 20/04/2024 10:51:43 am >> DELETE FROM ps_document_detail WHERE id_document = '91352' 20/04/2024 10:51:43 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 ( '91352' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 20/04/2024 10:51:43 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 ( '91352' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 20/04/2024 10:51:43 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 ( '91352' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '1.2' , '1.2' , '0' , '0' , '2.40' ) 20/04/2024 10:54:43 am >> SELECT document_num FROM ps_document WHERE document_num = '52/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 10:54:43 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' , '52/A' , '2024-04-20' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , 'BRASILE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '327.80' , '327.80' , NOW() , NOW() ) 20/04/2024 10:54:43 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 = '91353' 20/04/2024 10:54:43 am >> DELETE FROM ps_document_detail WHERE id_document = '91353' 20/04/2024 10:54:43 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 ( '91353' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '0' , '170.00' , '170' , '' , '0' , '170.00' ) 20/04/2024 10:54:43 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 ( '91353' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '0' , '49.90' , '49.9' , '' , '0' , '49.90' ) 20/04/2024 10:54:43 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 ( '91353' , '16461' , 'CLERGY NIDO D\'APE ML - C 22' , '1' , '-1' , '0' , '58.00' , '58' , '' , '0' , '58.00' ) 20/04/2024 10:54:43 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 ( '91353' , '22196' , 'CLERGY VERSUS ML - C25' , '1' , '-1' , '0' , '49.90' , '49.9' , '' , '0' , '49.90' ) 20/04/2024 11:20:00 am >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 11:20:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '53/A' , '2024-04-20' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , 'BURUNDI' , 'BURUNDI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1534.60' , '1534.60' , NOW() , NOW() ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91354' 20/04/2024 11:20:00 am >> DELETE FROM ps_document_detail WHERE id_document = '91354' 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '21377' , 'CASULA POLIESTERE IHS' , '1' , '-1' , '0' , '63.00' , '63' , '' , '0' , '63.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '1' , '-1' , '0' , '65.00' , '65' , '' , '0' , '65.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '0' , '59.00' , '59' , '' , '0' , '59.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '18764' , 'STELLARIO PLEX CM 18/20' , '1' , '-1' , '0' , '15.50' , '15.5' , '' , '0' , '15.50' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '0' , '170.00' , '170' , '' , '0' , '170.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '' , 'COPRILEGGIO MARIANO' , '1' , '-1' , '0' , '110' , '110' , '' , '0' , '110.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '2735' , 'COPRILEGGIO - OGGETTI' , '1' , '-1' , '0' , '75' , '75' , '' , '0' , '75.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '13929' , 'COPRILEGGIO - 317/TP' , '1' , '-1' , '0' , '70.00' , '70' , '' , '0' , '70.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '' , 'COPRILEGGIO VERDE' , '1' , '-1' , '0' , '55' , '55' , '' , '0' , '55.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '11265' , 'COPRILEGGIO - 881' , '1' , '-1' , '0' , '75.00' , '75' , '' , '0' , '75.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '16070' , 'CASULA - PCA020' , '4' , '-4' , '0' , '79.00' , '79' , '' , '0' , '316.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '20983' , 'CLERGY MM LIMITED 80/20' , '3' , '-3' , '0' , '40.00' , '40' , '' , '0' , '120.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '0' , '36.00' , '36' , '' , '0' , '36.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '0' , '36.50' , '36.5' , '' , '0' , '36.50' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '0' , '40.00' , '40' , '' , '0' , '40.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '22304' , 'TURIBOLO PLACCATO ARG. CM 17' , '1' , '-1' , '0' , '70.00' , '70' , '' , '0' , '70.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '18022' , 'TURIBOLO H 24' , '1' , '-1' , '0' , '155.00' , '155' , '' , '0' , '155.00' ) 20/04/2024 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '0' , '3.60' , '3.6' , '' , '0' , '3.60' ) 20/04/2024 11:25:26 am >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '91354' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 11:25:26 am >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2024-04-20', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = 'BURUNDI', note = 'BURUNDI', 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 = '1630.60', price_tax_excluded = '1630.60', date_upd = NOW() WHERE id_document = '91354' 20/04/2024 11:25: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 = '91354' 20/04/2024 11:25:26 am >> DELETE FROM ps_document_detail WHERE id_document = '91354' 20/04/2024 11:25: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 ( '91354' , '21377' , 'CASULA POLIESTERE IHS' , '1' , '-1' , '0' , '63.0000' , '63' , '0' , '0' , '63.00' ) 20/04/2024 11:25: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 ( '91354' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '1' , '-1' , '0' , '65.0000' , '65' , '0' , '0' , '65.00' ) 20/04/2024 11:25: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 ( '91354' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '0' , '59.0000' , '59' , '0' , '0' , '59.00' ) 20/04/2024 11:25: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 ( '91354' , '18764' , 'STELLARIO PLEX CM 18/20' , '1' , '-1' , '0' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 20/04/2024 11:25: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 ( '91354' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '0' , '170.0000' , '170' , '0' , '0' , '170.00' ) 20/04/2024 11:25: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 ( '91354' , '0' , 'COPRILEGGIO MARIANO' , '1' , '-1' , '0' , '110.0000' , '110' , '0' , '0' , '110.00' ) 20/04/2024 11:25: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 ( '91354' , '2735' , 'COPRILEGGIO - OGGETTI' , '1' , '-1' , '0' , '75.0000' , '75' , '0' , '0' , '75.00' ) 20/04/2024 11:25: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 ( '91354' , '13929' , 'COPRILEGGIO - 317/TP' , '1' , '-1' , '0' , '70.0000' , '70' , '0' , '0' , '70.00' ) 20/04/2024 11:25: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 ( '91354' , '0' , 'COPRILEGGIO VERDE' , '1' , '-1' , '0' , '55.0000' , '55' , '0' , '0' , '55.00' ) 20/04/2024 11:25: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 ( '91354' , '11265' , 'COPRILEGGIO - 881' , '1' , '-1' , '0' , '75.0000' , '75' , '0' , '0' , '75.00' ) 20/04/2024 11:25: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 ( '91354' , '16070' , 'CASULA - PCA020' , '4' , '-4' , '0' , '79.0000' , '79' , '0' , '0' , '316.00' ) 20/04/2024 11:25: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 ( '91354' , '20983' , 'CLERGY MM LIMITED 80/20' , '3' , '-3' , '0' , '40.0000' , '40' , '0' , '0' , '120.00' ) 20/04/2024 11:25: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 ( '91354' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '0' , '36.0000' , '36' , '0' , '0' , '36.00' ) 20/04/2024 11:25: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 ( '91354' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '0' , '36.5000' , '36.5' , '0' , '0' , '36.50' ) 20/04/2024 11:25: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 ( '91354' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '0' , '40.0000' , '40' , '0' , '0' , '40.00' ) 20/04/2024 11:25: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 ( '91354' , '22304' , 'TURIBOLO PLACCATO ARG. CM 17' , '1' , '-1' , '0' , '70.0000' , '70' , '0' , '0' , '70.00' ) 20/04/2024 11:25: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 ( '91354' , '18022' , 'TURIBOLO H 24' , '1' , '-1' , '0' , '155.0000' , '155' , '0' , '0' , '155.00' ) 20/04/2024 11:25:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '0' , '3.6000' , '3.6' , '0' , '0' , '3.60' ) 20/04/2024 11:25:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91354' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '48' , '-48' , '0' , '2.00' , '2' , '' , '0' , '96.00' ) 20/04/2024 11:44:06 am >> SELECT document_num FROM ps_document WHERE document_num = '1223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 11:44:06 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' , '1223' , '2024-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '490.00' , '401.64' , NOW() , NOW() ) 20/04/2024 11:44:06 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 = '91355' 20/04/2024 11:44:06 am >> DELETE FROM ps_document_detail WHERE id_document = '91355' 20/04/2024 11:44:06 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 ( '91355' , '1364' , 'BROCCA E PIATTINO - CM 23 PALLADIATI - 680' , '1' , '-1' , '1' , '190' , '155.73770491803' , '22' , '0' , '190.00' ) 20/04/2024 11:44: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 ( '91355' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 20/04/2024 11:52:00 am >> DELETE FROM ps_document WHERE id_document = '91091' 20/04/2024 11:52:00 am >> DELETE FROM ps_document_detail WHERE id_document = '91091' 20/04/2024 11:58:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1198' AND id_document != '91325' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-18') 20/04/2024 11:58:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1198', document_date = '2024-04-18', 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 = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '91325' 20/04/2024 11:58:42 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 = '91325' 20/04/2024 11:58:42 am >> DELETE FROM ps_document_detail WHERE id_document = '91325' 20/04/2024 11:58: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 ( '91325' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 20/04/2024 11:58: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 ( '91325' , '22181' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2024' , '7' , '-7' , '4' , '6.00' , '6' , '0' , '0' , '42.00' ) 20/04/2024 12:29:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 12:29: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' , '1224' , '2024-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 20/04/2024 12:29: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 = '91356' 20/04/2024 12:29:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '91356' 20/04/2024 12:29: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 ( '91356' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 20/04/2024 12:35:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '910' AND id_document != '90962' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-26') 20/04/2024 12:35:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '910', document_date = '2024-03-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.60', price_tax_excluded = '22.62', date_upd = NOW() WHERE id_document = '90962' 20/04/2024 12:35: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 = '90962' 20/04/2024 12:35:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90962' 20/04/2024 12:35: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 ( '90962' , '1294' , 'BRACCIALE ANGELO DI DIO ROSA - CM 48 - OGGETTI' , '1' , '-1' , '1' , '27.6' , '22.622950819672' , '22' , '0' , '27.60' ) 20/04/2024 12:35:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1219' AND id_document != '91348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 12:35:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1219', document_date = '2024-04-20', 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 = '4.50', price_tax_excluded = '4.50', date_upd = NOW() WHERE id_document = '91348' 20/04/2024 12:35:48 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 = '91348' 20/04/2024 12:35:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '91348' 20/04/2024 12:35:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91348' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.5' , '0.5' , '0' , '0' , '0.50' ) 20/04/2024 12:35:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91348' , '22368' , 'UN FIORETTO PER MARIA' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 20/04/2024 12:39:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 12:39:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1225' , '2024-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.38' , NOW() , NOW() ) 20/04/2024 12:39:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91357' 20/04/2024 12:39:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '91357' 20/04/2024 12:39: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 ( '91357' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 20/04/2024 12:41:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1224' AND id_document != '91356' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 12:41:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1224', document_date = '2024-04-20', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91356' 20/04/2024 12:41: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 = '91356' 20/04/2024 12:41:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '91356' 20/04/2024 12:41: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 ( '91356' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '37.6' , '30.819672131148' , '22' , '0' , '37.60' ) 20/04/2024 12:41: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 ( '91356' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 20/04/2024 12:41: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 ( '91356' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 20/04/2024 12:47:12 pm >> DELETE FROM ps_document WHERE id_document = '91354' 20/04/2024 12:47:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '91354' 20/04/2024 12:47:14 pm >> DELETE FROM ps_document WHERE id_document = '91353' 20/04/2024 12:47:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '91353' 20/04/2024 12:48:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1223' AND id_document != '91355' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 20/04/2024 12:48:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1223', document_date = '2024-04-20', 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 = '490.00', price_tax_excluded = '401.64', date_upd = NOW() WHERE id_document = '91355' 20/04/2024 12:48:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91355' 20/04/2024 12:48:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '91355' 20/04/2024 12:48:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91355' , '1364' , 'BROCCA E PIATTINO - CM 23 PALLADIATI - 680' , '1' , '-1' , '1' , '190.0000' , '155.73770491803' , '22' , '0' , '190.00' ) 20/04/2024 12:48:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91355' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 20/04/2024 12:48:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91355' , '12635' , 'COPRI AMBONE MIRACOLOSA' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' )