14/09/2023 09:13:19 am >> SELECT document_num FROM ps_document WHERE document_num = '35' AND id_document != '87280' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-09-13') 14/09/2023 09:13:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '35', document_date = '2023-09-13', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '4188.00', price_tax_excluded = '4188.00', date_upd = NOW() WHERE id_document = '87280' 14/09/2023 09:13: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 = '87280' 14/09/2023 09:13:20 am >> DELETE FROM ps_document_detail WHERE id_document = '87280' 14/09/2023 09:13: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 ( '87280' , '5446' , 'IO SONO CON VOI - GUIDA' , '60' , '-60' , '4' , '8.0000' , '8' , '0' , '0' , '480.00' ) 14/09/2023 09:13: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 ( '87280' , '11183' , 'VENITE CON ME - GUIDA' , '60' , '-60' , '4' , '8.0000' , '8' , '0' , '0' , '480.00' ) 14/09/2023 09:13: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 ( '87280' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '40' , '-40' , '4' , '8.0000' , '8' , '0' , '0' , '320.00' ) 14/09/2023 09:13: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 ( '87280' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '50' , '-50' , '4' , '5.0000' , '5' , '0' , '0' , '250.00' ) 14/09/2023 09:13: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 ( '87280' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '68' , '-68' , '4' , '6.0000' , '6' , '0' , '0' , '408.00' ) 14/09/2023 09:13: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 ( '87280' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '100' , '-100' , '4' , '5.0000' , '5' , '0' , '0' , '500.00' ) 14/09/2023 09:13: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 ( '87280' , '9675' , 'SARETE MIEI TESTIMONI' , '500' , '-500' , '4' , '3.5000' , '3.5' , '0' , '0' , '1750.00' ) 14/09/2023 11:00:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2815' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-14') 14/09/2023 11:00:38 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' , '2815' , '2023-09-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 14/09/2023 11:00:38 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 = '87285' 14/09/2023 11:00:38 am >> DELETE FROM ps_document_detail WHERE id_document = '87285' 14/09/2023 11:00:38 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 ( '87285' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 14/09/2023 11:43:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2816' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-14') 14/09/2023 11:43:37 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' , '2816' , '2023-09-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '34.19' , NOW() , NOW() ) 14/09/2023 11:43:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87286' 14/09/2023 11:43:37 am >> DELETE FROM ps_document_detail WHERE id_document = '87286' 14/09/2023 11:43:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87286' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '10' , '-10' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '3.00' ) 14/09/2023 11:43:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87286' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 14/09/2023 11:43:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87286' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 14/09/2023 12:27:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1960' AND id_document != '85716' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 14/09/2023 12:27:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1960', document_date = '2023-06-06', 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 = '187.80', price_tax_excluded = '153.93', date_upd = NOW() WHERE id_document = '85716' 14/09/2023 12:27:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85716' 14/09/2023 12:27:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '85716' 14/09/2023 12:27:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85716' , '1621' , 'CANDELE CONICHE 10 PZ' , '2' , '-2' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '15.80' ) 14/09/2023 12:27:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85716' , '8935' , 'RICAMBIO PER TORCIA NIKEL - DIAM. 4 - 32' , '2' , '-2' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '74.00' ) 14/09/2023 12:27:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85716' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 14/09/2023 12:27:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85716' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 14/09/2023 12:28:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2817' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-14') 14/09/2023 12:28:41 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' , '2817' , '2023-09-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.00' , '50.00' , NOW() , NOW() ) 14/09/2023 12:28:41 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 = '87287' 14/09/2023 12:28:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '87287' 14/09/2023 12:28:41 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 ( '87287' , '19432' , 'QUADRO DECORATO 35X25 - R35' , '1' , '-1' , '1' , '61.00' , '50' , '22' , '0' , '61.00' ) 14/09/2023 02:51:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2818' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-14') 14/09/2023 02:51:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2818' , '2023-09-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.30' , '19.88' , NOW() , NOW() ) 14/09/2023 02:51:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87288' 14/09/2023 02:51:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '87288' 14/09/2023 02:51:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87288' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 14/09/2023 02:51:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87288' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 14/09/2023 02:51:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87288' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 14/09/2023 02:55:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2467' AND id_document != '86854' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-24') 14/09/2023 02:55:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2467', document_date = '2023-07-24', 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 = '276.00', price_tax_excluded = '228.78', date_upd = NOW() WHERE id_document = '86854' 14/09/2023 02:55:44 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 = '86854' 14/09/2023 02:55:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '86854' 14/09/2023 02:55:44 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 ( '86854' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 14/09/2023 02:55:44 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 ( '86854' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '200' , '-200' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '60.00' ) 14/09/2023 02:55:44 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 ( '86854' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 14/09/2023 02:55:44 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 ( '86854' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 14/09/2023 02:55:44 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 ( '86854' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 14/09/2023 03:32:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2819' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-14') 14/09/2023 03:32:48 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' , '2819' , '2023-09-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '76.00' , NOW() , NOW() ) 14/09/2023 03:32: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 = '87289' 14/09/2023 03:32:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '87289' 14/09/2023 03:32:48 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 ( '87289' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/09/2023 03:32:48 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 ( '87289' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 14/09/2023 03:32:48 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 ( '87289' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/09/2023 03:32:48 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 ( '87289' , '14530' , 'PANE E VINO - GUIDA 3' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 14/09/2023 03:32:48 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 ( '87289' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/09/2023 03:32:48 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 ( '87289' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 14/09/2023 03:32:48 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 ( '87289' , '6620' , 'MIA IMPRONTA È TUA - GUIDA 1' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 14/09/2023 03:32:48 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 ( '87289' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/09/2023 03:49:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2820' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-14') 14/09/2023 03:49:17 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' , '2820' , '2023-09-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 14/09/2023 03:49:17 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 = '87290' 14/09/2023 03:49:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '87290' 14/09/2023 03:49:17 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 ( '87290' , '16761' , 'LAMPADA MARIANA - 096DP2K' , '2' , '-2' , '1' , '40' , '32.786885245902' , '22' , '0' , '80.00' ) 14/09/2023 04:52:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '20/S' AND id_document != '12146' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-14') 14/09/2023 04:52:55 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '20/S', document_date = '2023-09-14', document_letter = 'S', id_customer = '402', id_supplier = '', id_address = '4670248', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '435.50', price_tax_excluded = '435.50', date_upd = NOW() WHERE id_document = '12146' 14/09/2023 04:52:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12146' 14/09/2023 04:52:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '12146' 14/09/2023 04:52:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12146' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '20' , '-20' , '4' , '1.8000' , '1.8' , '0' , '35' , '23.40' ) 14/09/2023 04:52:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12146' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '20' , '-20' , '4' , '18.0000' , '18' , '0' , '35' , '234.00' ) 14/09/2023 04:52:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12146' , '17' , 'LA FEDE NELLO ZAINETTO' , '30' , '-30' , '4' , '6.0000' , '6' , '0' , '35' , '117.00' ) 14/09/2023 04:52:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12146' , '117' , 'La preghiera delle cinque dita n.e.' , '30' , '-30' , '4' , '1.8000' , '1.8' , '0' , '35' , '35.10' ) 14/09/2023 04:52:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12146' , '126' , 'SACRAMENTO DEL PERDONO' , '20' , '-20' , '4' , '2.0000' , '2' , '0' , '35' , '26.00' ) 14/09/2023 04:56:22 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 ( '31' , '20/S' , '2023-09-14' , 'S' , '0' , '127' , '4670004' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '435.50' , '435.50' , NOW() , NOW() ) 14/09/2023 04:56:22 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 = '87291' 14/09/2023 04:56:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '87291' 14/09/2023 04:56:22 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 ( '87291' , '15317' , 'SACRAMENTI SPIEGATI AI RAGAZZI - LA COMUNIONE' , '20' , '20' , '4' , '1.80' , '1.8' , '0' , '35' , '23.4000' ) 14/09/2023 04:56:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15317' AND id_supplier = '127' 14/09/2023 04:56:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15317' , '127' , '1' ) 14/09/2023 04:56:22 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 ( '87291' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '20' , '20' , '4' , '18.00' , '18' , '0' , '35' , '234.0000' ) 14/09/2023 04:56:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21524' AND id_supplier = '127' 14/09/2023 04:56:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21524' , '127' , '1' ) 14/09/2023 04:56:22 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 ( '87291' , '4120' , 'FEDE NELLO ZAINETTO' , '30' , '30' , '4' , '6' , '6' , '0' , '35' , '117.0000' ) 14/09/2023 04:56:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '127' 14/09/2023 04:56:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '127' , '1' ) 14/09/2023 04:56:23 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 ( '87291' , '14487' , 'PREGHIERA DELLE 5 DITA' , '30' , '30' , '4' , '1.80' , '1.8' , '0' , '35' , '35.1000' ) 14/09/2023 04:56:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14487' AND id_supplier = '127' 14/09/2023 04:56:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14487' , '127' , '1' ) 14/09/2023 04:56:23 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 ( '87291' , '17034' , 'SACRAMENTO DEL PERDONO' , '20' , '20' , '4' , '2.00' , '2' , '0' , '35' , '26.0000' ) 14/09/2023 04:56:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17034' AND id_supplier = '127' 14/09/2023 04:56:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17034' , '127' , '1' )