24/12/2024 09:01:40 am >> SELECT document_num FROM ps_document WHERE document_num = '4073' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 09:01:40 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' , '4073' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 24/12/2024 09:01:40 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 = '95023' 24/12/2024 09:01:40 am >> DELETE FROM ps_document_detail WHERE id_document = '95023' 24/12/2024 09:01:40 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 ( '95023' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 24/12/2024 09:07:58 am >> SELECT document_num FROM ps_document WHERE document_num = '4074' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 09:07:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4074' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.65' , '44.65' , NOW() , NOW() ) 24/12/2024 09:07: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 = '95024' 24/12/2024 09:07:59 am >> DELETE FROM ps_document_detail WHERE id_document = '95024' 24/12/2024 09:07: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 ( '95024' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 24/12/2024 09:07: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 ( '95024' , '6417' , 'MESE DI MAGGIO CON LE GLORIE DI MARIA - 8463' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 24/12/2024 09:17:19 am >> SELECT document_num FROM ps_document WHERE document_num = '4075' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 09:17:19 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' , '4075' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.28' , '27.28' , NOW() , NOW() ) 24/12/2024 09:17:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95025' 24/12/2024 09:17:19 am >> DELETE FROM ps_document_detail WHERE id_document = '95025' 24/12/2024 09:17:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95025' , '22192' , 'PREGHIERA DI GESU - 3' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 24/12/2024 09:17:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95025' , '22290' , 'CHIESA IN PREGHIERA - 6' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 24/12/2024 09:17:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95025' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '5' , '2.09' ) 24/12/2024 09:17:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95025' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 24/12/2024 09:35:03 am >> SELECT document_num FROM ps_document WHERE document_num = '4076' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 09:35:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4076' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 24/12/2024 09:35:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95026' 24/12/2024 09:35:03 am >> DELETE FROM ps_document_detail WHERE id_document = '95026' 24/12/2024 09:35:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95026' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 24/12/2024 09:41:04 am >> SELECT document_num FROM ps_document WHERE document_num = '4076' AND id_document != '95026' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 09:41:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4076', document_date = '2024-12-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 = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '95026' 24/12/2024 09:41:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95026' 24/12/2024 09:41:05 am >> DELETE FROM ps_document_detail WHERE id_document = '95026' 24/12/2024 09:41:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95026' , '22638' , 'CATENINA CON CROCE ARG - ASK925-0935S' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 24/12/2024 10:06:55 am >> SELECT document_num FROM ps_document WHERE document_num = '4077' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 10:06:55 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' , '4077' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 24/12/2024 10:06:55 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 = '95027' 24/12/2024 10:06:55 am >> DELETE FROM ps_document_detail WHERE id_document = '95027' 24/12/2024 10:06:55 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 ( '95027' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 24/12/2024 10:13:20 am >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '94256' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-14') 24/12/2024 10:13:20 am >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2024-11-14', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'acconto 05/12 € 260,00', 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 = '828.32', price_tax_excluded = '797.38', date_upd = NOW() WHERE id_document = '94256' 24/12/2024 10: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 = '94256' 24/12/2024 10:13:20 am >> DELETE FROM ps_document_detail WHERE id_document = '94256' 24/12/2024 10: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 ( '94256' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 24/12/2024 10: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 ( '94256' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 24/12/2024 10: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 ( '94256' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '48' , '-48' , '4' , '3.8000' , '3.8' , '0' , '15' , '155.04' ) 24/12/2024 10: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 ( '94256' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.8000' , '3.8' , '0' , '15' , '164.73' ) 24/12/2024 10: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 ( '94256' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 24/12/2024 10: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 ( '94256' , '0' , 'natività campana ' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '0' , '110.00' ) 24/12/2024 10: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 ( '94256' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 24/12/2024 10: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 ( '94256' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 24/12/2024 10: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 ( '94256' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '30' , '-30' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '54.00' ) 24/12/2024 10: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 ( '94256' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '7.20' ) 24/12/2024 10: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 ( '94256' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '14.40' ) 24/12/2024 10:20:58 am >> SELECT document_num FROM ps_document WHERE document_num = '4078' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 10:20:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4078' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 24/12/2024 10:20:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95028' 24/12/2024 10:20:58 am >> DELETE FROM ps_document_detail WHERE id_document = '95028' 24/12/2024 10:20:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95028' , '21099' , 'BRACCIALE DECINA - BD008' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 24/12/2024 10:20:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95028' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 24/12/2024 10:23:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3966' AND id_document != '94889' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-17') 24/12/2024 10:23:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3966', document_date = '2024-12-17', 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 = '694.20', price_tax_excluded = '569.02', date_upd = NOW() WHERE id_document = '94889' 24/12/2024 10:23: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 = '94889' 24/12/2024 10:23:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94889' 24/12/2024 10:23: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 ( '94889' , '19626' , 'STATUA S .ESPEDITO CM 30 - 642 ' , '1' , '-1' , '1' , '88.0000' , '72.131147540984' , '22' , '0' , '88.00' ) 24/12/2024 10:23: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 ( '94889' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '-3' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '90.00' ) 24/12/2024 10:23: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 ( '94889' , '22920' , 'SERVIZIO MESSA GIUBILEO 2025' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 24/12/2024 10:23: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 ( '94889' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '2.3' , '1.8852459016393' , '22' , '0' , '2.30' ) 24/12/2024 10:23: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 ( '94889' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 24/12/2024 10:23:25 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 ( '94889' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 24/12/2024 10:23:25 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 ( '94889' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 24/12/2024 10:23:25 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 ( '94889' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 24/12/2024 10:23:25 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 ( '94889' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '2' , '-2' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '99.80' ) 24/12/2024 10:23:25 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 ( '94889' , '12749' , 'DALMATICA - 3512/TP' , '1' , '-1' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '100.00' ) 24/12/2024 10:23:25 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 ( '94889' , '23226' , 'STOLA GIUBILEO RICAMATA - ST15GBR' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 24/12/2024 10:23:25 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 ( '94889' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 24/12/2024 10:48:06 am >> SELECT document_num FROM ps_document WHERE document_num = '4079' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 10:48: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' , '4079' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.40' , '34.69' , NOW() , NOW() ) 24/12/2024 10:48: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 = '95029' 24/12/2024 10:48:06 am >> DELETE FROM ps_document_detail WHERE id_document = '95029' 24/12/2024 10:48: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 ( '95029' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '30' , '-30' , '4' , '0.70' , '0.7' , '0' , '0' , '21.00' ) 24/12/2024 10:48: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 ( '95029' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 24/12/2024 10:48: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 ( '95029' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 24/12/2024 10:48: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 ( '95029' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 24/12/2024 10:49:24 am >> SELECT document_num FROM ps_document WHERE document_num = '4080' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 10:49:24 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' , '4080' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.41' , '47.41' , NOW() , NOW() ) 24/12/2024 10:49: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 = '95030' 24/12/2024 10:49:24 am >> DELETE FROM ps_document_detail WHERE id_document = '95030' 24/12/2024 10:49:25 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 ( '95030' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 24/12/2024 10:49:25 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 ( '95030' , '23324' , 'PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/12/2024 10:49:25 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 ( '95030' , '23266' , 'FOLLOWERS 3 - CRESIMANDI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 24/12/2024 10:49:25 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 ( '95030' , '23332' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 24/12/2024 10:49:25 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 ( '95030' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 24/12/2024 10:54:35 am >> SELECT document_num FROM ps_document WHERE document_num = '4081' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 10:54:35 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' , '4081' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 24/12/2024 10:54:35 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 = '95031' 24/12/2024 10:54:35 am >> DELETE FROM ps_document_detail WHERE id_document = '95031' 24/12/2024 10:54:35 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 ( '95031' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '10.50' ) 24/12/2024 10:54:35 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 ( '95031' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 24/12/2024 11:00:48 am >> SELECT document_num FROM ps_document WHERE document_num = '4082' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 11:00:48 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' , '4082' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.10' , '0.90' , NOW() , NOW() ) 24/12/2024 11:00:48 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 = '95032' 24/12/2024 11:00:48 am >> DELETE FROM ps_document_detail WHERE id_document = '95032' 24/12/2024 11:00:48 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 ( '95032' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 24/12/2024 11:10:37 am >> SELECT document_num FROM ps_document WHERE document_num = '4083' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 11:10: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' , '4083' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 24/12/2024 11:10: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 = '95033' 24/12/2024 11:10:37 am >> DELETE FROM ps_document_detail WHERE id_document = '95033' 24/12/2024 11:10: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 ( '95033' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 24/12/2024 11:19:43 am >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '94951' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-19') 24/12/2024 11:19:43 am >> UPDATE ps_document SET id_document_type = '24', document_num = '137/A', document_date = '2024-12-19', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto € 50,00', 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 = '314.90', price_tax_excluded = '280.01', date_upd = NOW() WHERE id_document = '94951' 24/12/2024 11:19: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 = '94951' 24/12/2024 11:19:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94951' 24/12/2024 11:19: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 ( '94951' , '16795' , 'LUMINO 5F ROSSO' , '30' , '-30' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '9.00' ) 24/12/2024 11:19: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 ( '94951' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 24/12/2024 11:19: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 ( '94951' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '100' , '-100' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '40.00' ) 24/12/2024 11:19: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 ( '94951' , '23189' , 'GRUPPO NATIVITA STILIZZATA - PB18073' , '48' , '-48' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '86.40' ) 24/12/2024 11:19: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 ( '94951' , '' , '24/12' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 24/12/2024 11:19: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 ( '94951' , '' , 'campana vetro natività' , '1' , '-1' , '0' , '110' , '110' , '' , '0' , '110.00' ) 24/12/2024 11:19: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 ( '94951' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 24/12/2024 11:19: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 ( '94951' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 24/12/2024 11:19: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 ( '94951' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 24/12/2024 11:19: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 ( '94951' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 24/12/2024 11:59:28 am >> SELECT document_num FROM ps_document WHERE document_num = '4084' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 11:59:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4084' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '76.00' , NOW() , NOW() ) 24/12/2024 11:59:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95034' 24/12/2024 11:59:28 am >> DELETE FROM ps_document_detail WHERE id_document = '95034' 24/12/2024 11:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95034' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '16' , '-16' , '4' , '5.00' , '5' , '0' , '5' , '76.00' ) 24/12/2024 12:09:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4085' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 12:09:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4085' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '13.52' , NOW() , NOW() ) 24/12/2024 12:09:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95035' 24/12/2024 12:09:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '95035' 24/12/2024 12:09:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95035' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 24/12/2024 12:09:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95035' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '11.50' ) 24/12/2024 12:24:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '4086' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 12:24:01 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' , '4086' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.80' , '15.95' , NOW() , NOW() ) 24/12/2024 12:24:01 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 = '95036' 24/12/2024 12:24:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '95036' 24/12/2024 12:24:01 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 ( '95036' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 24/12/2024 12:24:01 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 ( '95036' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 24/12/2024 12:24:01 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 ( '95036' , '14029' , 'ANGELO DI DIO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '' , '3.00' ) 24/12/2024 12:24:01 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 ( '95036' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 24/12/2024 12:34:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4087' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 12:34:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4087' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.11' , '72.11' , NOW() , NOW() ) 24/12/2024 12:34: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 = '95037' 24/12/2024 12:34:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '95037' 24/12/2024 12:34: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 ( '95037' , '21116' , 'LIBERTA DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 24/12/2024 12:34: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 ( '95037' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 24/12/2024 12:34: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 ( '95037' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 24/12/2024 12:34: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 ( '95037' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 24/12/2024 12:34: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 ( '95037' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 24/12/2024 12:47:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '4088' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-24') 24/12/2024 12:47: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 ( '11' , '4088' , '2024-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 24/12/2024 12:47: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 = '95038' 24/12/2024 12:47:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '95038' 24/12/2024 12:47: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 ( '95038' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' )