19/09/2023 08:34:23 am >> SELECT document_num FROM ps_document WHERE document_num = '118' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 08:34:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '118' , '2023-09-19' , '' , '3570' , '0' , '4671075' , 'PIAZZA RAFFAELLO DELLE NOCCHE 2 75019 TRICARICO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '210.48' , '208.55' , NOW() , NOW() ) 19/09/2023 08:34:23 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 = '87337' 19/09/2023 08:34:23 am >> DELETE FROM ps_document_detail WHERE id_document = '87337' 19/09/2023 08:34:23 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 ( '87337' , '2679' , 'CONOSCERE GESU\'' , '8' , '-8' , '4' , '3.50' , '3.5' , '0' , '5' , '26.60' ) 19/09/2023 08:34:23 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 ( '87337' , '4154' , 'FESTA DEL PERDONO' , '8' , '-8' , '4' , '3.00' , '3' , '0' , '5' , '22.80' ) 19/09/2023 08:34:23 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 ( '87337' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/09/2023 08:34:23 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 ( '87337' , '8408' , 'PRENDETE E MANGIATE' , '14' , '-14' , '4' , '3.00' , '3' , '0' , '5' , '39.90' ) 19/09/2023 08:34:23 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 ( '87337' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/09/2023 08:34:23 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 ( '87337' , '8855' , 'REGISTRO DEL CATECHISTA' , '15' , '-15' , '1' , '0.75' , '0.61475409836066' , '22' , '5' , '10.69' ) 19/09/2023 08:34:23 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 ( '87337' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '2' , '-2' , '4' , '18.50' , '18.5' , '0' , '5' , '35.15' ) 19/09/2023 08:34:23 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 ( '87337' , '9675' , 'SARETE MIEI TESTIMONI' , '11' , '-11' , '4' , '3.50' , '3.5' , '0' , '5' , '36.58' ) 19/09/2023 08:34:23 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 ( '87337' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 19/09/2023 08:34:23 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 ( '87337' , '12253' , 'MIO LIBRO DI PREGHIERE' , '6' , '-6' , '4' , '2.80' , '2.8' , '0' , '5' , '15.96' ) 19/09/2023 08:34:23 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 ( '87337' , '14031' , 'SEGNO DELLA CROCE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 19/09/2023 08:34:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '14499' , 'COMUNIONE AI MALATI' , '10' , '-10' , '0' , '0.30' , '0.3' , '' , '5' , '2.85' ) 19/09/2023 09:07:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2855' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 09:07:29 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' , '2855' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '20.08' , NOW() , NOW() ) 19/09/2023 09:07:29 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 = '87338' 19/09/2023 09:07:29 am >> DELETE FROM ps_document_detail WHERE id_document = '87338' 19/09/2023 09:07:29 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 ( '87338' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 19/09/2023 09:08:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2856' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 09:08: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' , '2856' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 19/09/2023 09:08: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 = '87339' 19/09/2023 09:08:42 am >> DELETE FROM ps_document_detail WHERE id_document = '87339' 19/09/2023 09:08: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 ( '87339' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/09/2023 09:43:24 am >> SELECT document_num FROM ps_document WHERE document_num = '118' AND id_document != '87337' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 09:43:24 am >> UPDATE ps_document SET id_document_type = '21', document_num = '118', document_date = '2023-09-19', document_letter = '', id_customer = '3570', id_supplier = '', id_address = '4671075', address1 = 'PIAZZA RAFFAELLO DELLE NOCCHE 2 75019 TRICARICO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '215.47', price_tax_excluded = '213.54', date_upd = NOW() WHERE id_document = '87337' 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87337' 19/09/2023 09:43:24 am >> DELETE FROM ps_document_detail WHERE id_document = '87337' 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '2679' , 'CONOSCERE GESU\'' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '5' , '26.60' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '4154' , 'FESTA DEL PERDONO' , '8' , '-8' , '4' , '3.0000' , '3' , '0' , '5' , '22.80' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '8408' , 'PRENDETE E MANGIATE' , '14' , '-14' , '4' , '3.0000' , '3' , '0' , '5' , '39.90' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '8855' , 'REGISTRO DEL CATECHISTA' , '15' , '-15' , '1' , '0.7500' , '0.61475409836066' , '22' , '5' , '10.69' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '2' , '-2' , '4' , '18.5000' , '18.5' , '0' , '5' , '35.15' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '9675' , 'SARETE MIEI TESTIMONI' , '11' , '-11' , '4' , '3.50' , '3.5' , '0' , '5' , '36.58' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '12253' , 'MIO LIBRO DI PREGHIERE' , '6' , '-6' , '4' , '2.8000' , '2.8' , '0' , '5' , '15.96' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '14031' , 'SEGNO DELLA CROCE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '14499' , 'COMUNIONE AI MALATI' , '10' , '-10' , '0' , '0.3000' , '0.3' , '0' , '5' , '2.85' ) 19/09/2023 09:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87337' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '4.99' , '4.99' , '0' , '0' , '4.99' ) 19/09/2023 11:37:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2857' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 11:37:34 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' , '2857' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.40' , '31.44' , NOW() , NOW() ) 19/09/2023 11:37:34 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 = '87340' 19/09/2023 11:37:34 am >> DELETE FROM ps_document_detail WHERE id_document = '87340' 19/09/2023 11:37:34 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 ( '87340' , '16818' , 'INCENSO ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 19/09/2023 11:37:34 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 ( '87340' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/09/2023 11:37:34 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 ( '87340' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 19/09/2023 11:37:34 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 ( '87340' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 19/09/2023 11:37:34 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 ( '87340' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 19/09/2023 11:54:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2858' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 11:54:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2858' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 19/09/2023 11:54: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 = '87341' 19/09/2023 11:54:13 am >> DELETE FROM ps_document_detail WHERE id_document = '87341' 19/09/2023 11:54: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 ( '87341' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 19/09/2023 11:54:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2859' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 11:54:20 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' , '2859' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.50' , NOW() , NOW() ) 19/09/2023 11:54:20 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 = '87342' 19/09/2023 11:54:20 am >> DELETE FROM ps_document_detail WHERE id_document = '87342' 19/09/2023 11:54:20 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 ( '87342' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 19/09/2023 12:26:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '119' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 12:26:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '119' , '2023-09-19' , '' , '1832' , '0' , '4670920' , 'C.DA PANTANO 85010 PIGNOLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '101.15' , '101.15' , NOW() , NOW() ) 19/09/2023 12:26:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87343' 19/09/2023 12:26:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '87343' 19/09/2023 12:26:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '12' , '-12' , '4' , '2.50' , '2.5' , '0' , '15' , '25.50' ) 19/09/2023 12:26:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '4154' , 'FESTA DEL PERDONO' , '13' , '-13' , '4' , '3.00' , '3' , '0' , '15' , '33.15' ) 19/09/2023 12:26:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '4120' , 'FEDE NELLO ZAINETTO' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '15' , '42.50' ) 19/09/2023 12:33:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2860' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 12:33:51 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' , '2860' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '14.50' , NOW() , NOW() ) 19/09/2023 12:33:51 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 = '87344' 19/09/2023 12:33:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '87344' 19/09/2023 12:33:51 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 ( '87344' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '14.5' , '14.5' , '0' , '0' , '14.50' ) 19/09/2023 12:38:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '119' AND id_document != '87343' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 12:38:00 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '119', document_date = '2023-09-19', document_letter = '', id_customer = '1832', id_supplier = '', id_address = '4670920', address1 = 'C.DA PANTANO 85010 PIGNOLA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '143.27', price_tax_excluded = '143.27', date_upd = NOW() WHERE id_document = '87343' 19/09/2023 12:38:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87343' 19/09/2023 12:38:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '87343' 19/09/2023 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '12' , '-12' , '4' , '2.5000' , '2.5' , '0' , '15' , '25.50' ) 19/09/2023 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '4154' , 'FESTA DEL PERDONO' , '13' , '-13' , '4' , '3.0000' , '3' , '0' , '15' , '33.15' ) 19/09/2023 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '4120' , 'FEDE NELLO ZAINETTO' , '10' , '-10' , '4' , '5.0000' , '5' , '0' , '15' , '42.50' ) 19/09/2023 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '12' , '-12' , '4' , '3.40' , '3.4' , '0' , '15' , '34.68' ) 19/09/2023 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 19/09/2023 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '8855' , 'REGISTRO DEL CATECHISTA' , '5' , '-5' , '0' , '0.75' , '0.75' , '' , '15' , '3.19' ) 19/09/2023 01:00:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2861' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 01:00: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' , '2861' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.80' , '6.54' , NOW() , NOW() ) 19/09/2023 01:00: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 = '87345' 19/09/2023 01:00:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '87345' 19/09/2023 01:00: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 ( '87345' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 19/09/2023 01:00: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 ( '87345' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 19/09/2023 03:58:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2862' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 03:58:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2862' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.00' , '75.41' , NOW() , NOW() ) 19/09/2023 03:58:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87346' 19/09/2023 03:58:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '87346' 19/09/2023 03:58:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87346' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '63.00' , '51.639344262295' , '22' , '0' , '63.00' ) 19/09/2023 03:58:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87346' , '20644' , 'STOLA - PST022' , '1' , '-1' , '1' , '28.50' , '23.360655737705' , '22' , '0' , '28.50' ) 19/09/2023 03:58:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87346' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 19/09/2023 04:39:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2863' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 04:39:25 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' , '2863' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 19/09/2023 04:39:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87347' 19/09/2023 04:39:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '87347' 19/09/2023 04:39:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87347' , '12689' , 'IMMAGINI 50X70' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 19/09/2023 05:10:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2864' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 05:10:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2864' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3800.00' , '3114.75' , NOW() , NOW() ) 19/09/2023 05:10:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87348' 19/09/2023 05:10:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '87348' 19/09/2023 05:10:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87348' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '-1' , '1' , '1495.00' , '1225.4098360656' , '22' , '0' , '1495.00' ) 19/09/2023 05:10:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87348' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '-1' , '1' , '110.00' , '90.16393442623' , '22' , '0' , '110.00' ) 19/09/2023 05:10:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87348' , '' , 'palla mariana 50/372' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 19/09/2023 05:10:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87348' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '-1' , '1' , '305.00' , '250' , '22' , '0' , '305.00' ) 19/09/2023 05:10:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87348' , '8166' , 'PORTACALICE - 18X35 - 726' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 19/09/2023 05:10:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87348' , '' , 'pisside 099PA' , '1' , '-1' , '1' , '1600' , '1311.4754098361' , '22' , '0' , '1600.00' ) 19/09/2023 05:27:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 19/09/2023 05:27:40 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '92.60', price_tax_excluded = '92.60', date_upd = NOW() WHERE id_document = '81317' 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81317' 19/09/2023 05:27:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21293' , 'GRIDO DELLA PACE - A. RICCARDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21345' , 'buio oltre la siepe - h. lee' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21433' , 'PAROLA E PREGHIERA - OTT 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21495' , 'AMARE ED ESSERE AMATI - J. TOWEY' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21539' , 'PAROLA E PREGHIERA - NOV. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21538' , 'AMEN - NOV. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21537' , 'AMEN - DIC. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 19/09/2023 05:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 19/09/2023 06:35:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '91/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 06:35:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '91/A' , '2023-09-19' , 'A' , '3892' , '0' , '4674532' , 'OGLIARA 84100 OGLIARA' , '' , 'ACCONTO € 220' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3800.00' , '3114.75' , NOW() , NOW() ) 19/09/2023 06:35:07 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 = '87349' 19/09/2023 06:35:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '87349' 19/09/2023 06:35:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '-1' , '1' , '1495.00' , '1225.4098360656' , '22' , '0' , '1495.00' ) 19/09/2023 06:35:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '-1' , '1' , '110.00' , '90.16393442623' , '22' , '0' , '110.00' ) 19/09/2023 06:35:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '' , 'PALLA MARIANA - 50/372' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 19/09/2023 06:35:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '-1' , '1' , '305.00' , '250' , '22' , '0' , '305.00' ) 19/09/2023 06:35:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '8166' , 'PORTACALICE - 18X35 - 726' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 19/09/2023 06:35:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '' , 'PISSIDE 099PA' , '1' , '-1' , '1' , '1600' , '1311.4754098361' , '22' , '0' , '1600.00' ) 19/09/2023 07:25:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2865' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 19/09/2023 07:25:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2865' , '2023-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '184.90' , '154.89' , NOW() , NOW() ) 19/09/2023 07:25: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 = '87350' 19/09/2023 07:25:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '87350' 19/09/2023 07:25: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 ( '87350' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 19/09/2023 07:25: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 ( '87350' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 19/09/2023 07:25: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 ( '87350' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 19/09/2023 07:25: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 ( '87350' , '21503' , 'LAMPADA ELETTRICA - 305' , '1' , '-1' , '1' , '105.00' , '86.065573770492' , '22' , '0' , '105.00' ) 19/09/2023 07:25:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2672' AND id_document != '87113' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-31') 19/09/2023 07:25:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2672', document_date = '2023-08-31', 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 = '111.54', price_tax_excluded = '103.43', date_upd = NOW() WHERE id_document = '87113' 19/09/2023 07:25:53 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 = '87113' 19/09/2023 07:25:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '87113' 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '21146' , 'PARROCCHIE: MEMORIA E CAMBIAMENTO - F. ZACCARIA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '18176' , 'ANTIQUUM MINISTERIUM ' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '1' , '-1' , '4' , '11.9000' , '11.9' , '0' , '5' , '11.31' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '1' , '-1' , '4' , '2.85' , '2.85' , '0' , '0' , '2.85' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '10751' , 'TU MI PERDONI' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 19/09/2023 07:25:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87113' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 19/09/2023 07:31:20 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '19800' 19/09/2023 07:31:20 pm >> UPDATE ps_stock_available SET quantity = quantity + '-9' WHERE id_product = '19800'