30/11/2024 08:16:25 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 ( '33' , '00342542' , '2024-11-29' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '420.00' , '420.00' , NOW() , NOW() ) 30/11/2024 08:16:25 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 = '94590' 30/11/2024 08:16:25 am >> DELETE FROM ps_document_detail WHERE id_document = '94590' 30/11/2024 08:16: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 ( '94590' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '10' , '10' , '4' , '42.00' , '42' , '0' , '0' , '420.0000' ) 30/11/2024 08:16:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '23256' AND id_supplier = '109' 30/11/2024 08:16:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23256' , '109' , '1' ) 30/11/2024 08:16:50 am >> UPDATE ps_document SET id_document_type = '33', document_num = '00342542', document_date = '2024-11-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '252.00', price_tax_excluded = '252.00', date_upd = NOW() WHERE id_document = '94590' 30/11/2024 08:16:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94590' 30/11/2024 08:16:50 am >> DELETE FROM ps_document_detail WHERE id_document = '94590' 30/11/2024 08:16:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94590' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '10' , '10' , '4' , '42.0000' , '42' , '0' , '40' , '252.0000' ) 30/11/2024 08:34:38 am >> SELECT document_num FROM ps_document WHERE document_num = '257' AND id_document != '94513' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-27') 30/11/2024 08:34:38 am >> UPDATE ps_document SET id_document_type = '21', document_num = '257', document_date = '2024-11-27', document_letter = '', id_customer = '4147', id_supplier = '', id_address = '4679443', address1 = 'VIA BELLAVISTA 1 88060 ARGUSTO', address2 = '', note = '', price_shipping = '0.2', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '143.80', price_tax_excluded = '143.80', date_upd = NOW() WHERE id_document = '94513' 30/11/2024 08:34: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 = '94513' 30/11/2024 08:34:39 am >> DELETE FROM ps_document_detail WHERE id_document = '94513' 30/11/2024 08:34:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94513' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '5' , '39.90' ) 30/11/2024 08:34:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94513' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '2' , '-2' , '4' , '11.00' , '11' , '0' , '15' , '18.70' ) 30/11/2024 08:34:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94513' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 30/11/2024 08:34:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94513' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 30/11/2024 08:34:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94513' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '15' , '51.00' ) 30/11/2024 08:35:09 am >> SELECT document_num FROM ps_document WHERE document_num = '258' AND id_document != '94523' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-27') 30/11/2024 08:35:09 am >> UPDATE ps_document SET id_document_type = '21', document_num = '258', document_date = '2024-11-27', document_letter = '', id_customer = '4034', id_supplier = '', id_address = '4679121', address1 = 'P. ZZA SAN MARCO 84039 TEGGIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '98.60', price_tax_excluded = '98.60', date_upd = NOW() WHERE id_document = '94523' 30/11/2024 08:35:09 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 = '94523' 30/11/2024 08:35:10 am >> DELETE FROM ps_document_detail WHERE id_document = '94523' 30/11/2024 08:35:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94523' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 30/11/2024 08:35:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94523' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '16' , '-16' , '4' , '3.00' , '3' , '0' , '15' , '40.80' ) 30/11/2024 08:35:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94523' , '8408' , 'PRENDETE E MANGIATE' , '16' , '-16' , '4' , '3.0000' , '3' , '0' , '15' , '40.80' ) 30/11/2024 08:35:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94523' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 30/11/2024 08:36:13 am >> SELECT document_num FROM ps_document WHERE document_num = '259' AND id_document != '94528' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-27') 30/11/2024 08:36:13 am >> UPDATE ps_document SET id_document_type = '21', document_num = '259', document_date = '2024-11-27', document_letter = '', id_customer = '3805', id_supplier = '', id_address = '4672214', address1 = 'VIA S. MARIA DELLE GRAZIE 84030 PERTOSA', 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 = '183.86', price_tax_excluded = '183.86', date_upd = NOW() WHERE id_document = '94528' 30/11/2024 08:36: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 = '94528' 30/11/2024 08:36:13 am >> DELETE FROM ps_document_detail WHERE id_document = '94528' 30/11/2024 08:36: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 ( '94528' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 30/11/2024 08:36: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 ( '94528' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 30/11/2024 08:36: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 ( '94528' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '3' , '-3' , '4' , '3.4000' , '3.4' , '0' , '15' , '8.67' ) 30/11/2024 08:36: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 ( '94528' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 30/11/2024 08:36: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 ( '94528' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 30/11/2024 08:36: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 ( '94528' , '4154' , 'FESTA DEL PERDONO' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '15' , '7.65' ) 30/11/2024 08:36: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 ( '94528' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 30/11/2024 08:36: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 ( '94528' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 30/11/2024 08:36: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 ( '94528' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 30/11/2024 08:36: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 ( '94528' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 30/11/2024 08:36: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 ( '94528' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 30/11/2024 08:36: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 ( '94528' , '21530' , 'PRIMA COMUNIONE' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 30/11/2024 08:36: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 ( '94528' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 30/11/2024 08:36: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 ( '94528' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 30/11/2024 08:37:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3671' AND id_document != '94522' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 30/11/2024 08:37:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3671', document_date = '2024-11-27', 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 = '249.68', price_tax_excluded = '229.34', date_upd = NOW() WHERE id_document = '94522' 30/11/2024 08:37:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94522' 30/11/2024 08:37:12 am >> DELETE FROM ps_document_detail WHERE id_document = '94522' 30/11/2024 08:37:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94522' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '23.70' ) 30/11/2024 08:37:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94522' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 30/11/2024 08:37:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94522' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 30/11/2024 08:37: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 ( '94522' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 30/11/2024 08:37: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 ( '94522' , '23198' , 'CINQUE MINUTI DELLO SPIRITO SANTO - V.M. FERNANDEZ' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 30/11/2024 08:37: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 ( '94522' , '23016' , 'MISTICA DELLARATRO - A. ASCENSO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 30/11/2024 08:37: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 ( '94522' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 30/11/2024 08:37: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 ( '94522' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 30/11/2024 08:37: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 ( '94522' , '21788' , 'MADONNA DEL CARMINE CM 22 - 345' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 30/11/2024 08:37: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 ( '94522' , '11193' , 'VENITE CON ME CAT.' , '16' , '-16' , '4' , '5.5000' , '5.5' , '0' , '5' , '83.68' ) 30/11/2024 08:37: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 ( '94522' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '1' , '42' , '34.426229508197' , '22' , '0' , '42.00' ) 30/11/2024 08:37:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3673' AND id_document != '94525' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 30/11/2024 08:37:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3673', document_date = '2024-11-27', 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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '94525' 30/11/2024 08:37:56 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 = '94525' 30/11/2024 08:37:56 am >> DELETE FROM ps_document_detail WHERE id_document = '94525' 30/11/2024 08:37:56 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 ( '94525' , '16657' , 'CLERGY DENIM - ML ' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 30/11/2024 09:02:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3727' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 09:02: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' , '3727' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 30/11/2024 09:02: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 = '94591' 30/11/2024 09:02:48 am >> DELETE FROM ps_document_detail WHERE id_document = '94591' 30/11/2024 09:02: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 ( '94591' , '18764' , 'STELLARIO PLEX CM 18/20' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 30/11/2024 09:04:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3728' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 09:04:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3728' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 30/11/2024 09:04:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94592' 30/11/2024 09:04:41 am >> DELETE FROM ps_document_detail WHERE id_document = '94592' 30/11/2024 09:04:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94592' , '18580' , 'ORAZIONALE PER LA PREGHIERA UNIVERSALE - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 30/11/2024 09:25:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3567' AND id_document != '94388' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 30/11/2024 09:25:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3567', document_date = '2024-11-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '94388' 30/11/2024 09:25:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94388' 30/11/2024 09:25:41 am >> DELETE FROM ps_document_detail WHERE id_document = '94388' 30/11/2024 09:25:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94388' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 30/11/2024 09:25:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94388' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 30/11/2024 09:34:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3729' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 09:34:46 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' , '3729' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.50' , '5.51' , NOW() , NOW() ) 30/11/2024 09:34:46 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 = '94593' 30/11/2024 09:34:46 am >> DELETE FROM ps_document_detail WHERE id_document = '94593' 30/11/2024 09:34:46 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 ( '94593' , '22917' , 'FOULARD GIUBILEO PICCOLO' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 30/11/2024 09:34:46 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 ( '94593' , '23270' , 'PINO 3D - P172' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 30/11/2024 09:34:46 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 ( '94593' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 30/11/2024 09:41:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3730' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 09:41:47 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' , '3730' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.90' , '6.72' , NOW() , NOW() ) 30/11/2024 09:41:47 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 = '94594' 30/11/2024 09:41:47 am >> DELETE FROM ps_document_detail WHERE id_document = '94594' 30/11/2024 09:41:47 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 ( '94594' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.9' , '5.9' , '0' , '0' , '5.90' ) 30/11/2024 09:41:47 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 ( '94594' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 30/11/2024 09:59:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3731' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 09:59:53 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' , '3731' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 30/11/2024 09:59:53 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 = '94595' 30/11/2024 09:59:53 am >> DELETE FROM ps_document_detail WHERE id_document = '94595' 30/11/2024 09:59:53 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 ( '94595' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 30/11/2024 10:09:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3732' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 10:09: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' , '3732' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '37.79' , NOW() , NOW() ) 30/11/2024 10:09: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 = '94596' 30/11/2024 10:09:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94596' 30/11/2024 10:09: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 ( '94596' , '22998' , 'CALENDARIO FRATE INDOVINO 2025' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 30/11/2024 10:09: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 ( '94596' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 30/11/2024 10:16:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3733' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 10:16:52 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' , '3733' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.80' , '41.80' , NOW() , NOW() ) 30/11/2024 10:16:52 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 = '94597' 30/11/2024 10:16:52 am >> DELETE FROM ps_document_detail WHERE id_document = '94597' 30/11/2024 10:16:52 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 ( '94597' , '23169' , 'DILEXIT NOS ' , '20' , '-20' , '4' , '2.20' , '2.2' , '0' , '5' , '41.80' ) 30/11/2024 10:20:08 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') 30/11/2024 10:20:08 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 = '', 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 = '1312.72', price_tax_excluded = '1295.41', date_upd = NOW() WHERE id_document = '94256' 30/11/2024 10:20:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94256' 30/11/2024 10:20:08 am >> DELETE FROM ps_document_detail WHERE id_document = '94256' 30/11/2024 10:20:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 30/11/2024 10:20:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 30/11/2024 10:20:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '48' , '-48' , '4' , '3.8000' , '3.8' , '0' , '15' , '155.04' ) 30/11/2024 10:20:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.8000' , '3.8' , '0' , '15' , '164.73' ) 30/11/2024 10:20:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 30/11/2024 10:20:09 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' , '20085' , 'CARTA FORBICI E ... - D. MAZZOLI' , '40' , '-40' , '4' , '14.0000' , '14' , '0' , '0' , '560.00' ) 30/11/2024 10:20:09 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' ) 30/11/2024 10:20:09 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' ) 30/11/2024 10:20:09 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.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 30/11/2024 10:25:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3734' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 10:25: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' , '3734' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.52' , '22.35' , NOW() , NOW() ) 30/11/2024 10:25: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 = '94598' 30/11/2024 10:25:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94598' 30/11/2024 10:25: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 ( '94598' , '22482' , 'AVE MARIA - E. RONCHI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 30/11/2024 10:25: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 ( '94598' , '4040' , 'FAMIGLIA FA LA DIFFERENZA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 30/11/2024 10:25: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 ( '94598' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 30/11/2024 10:25: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 ( '94598' , '23139' , 'SAI COSE IL NATALE - A. COMASTRI' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 30/11/2024 10:25: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 ( '94598' , '21796' , 'SET NATIVITA CON CAPANNA CM 15 - PB19889' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 30/11/2024 10:42:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3735' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 10:42: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' , '3735' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.80' , '8.80' , NOW() , NOW() ) 30/11/2024 10:42: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 = '94599' 30/11/2024 10:42:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94599' 30/11/2024 10:42: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 ( '94599' , '18804' , 'NOVENA AL NATALE - 8045' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 30/11/2024 10:42: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 ( '94599' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '2' , '-2' , '4' , '2.9' , '2.9' , '0' , '0' , '5.80' ) 30/11/2024 11:21:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3736' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 11:21:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3736' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 30/11/2024 11:21:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94600' 30/11/2024 11:21:12 am >> DELETE FROM ps_document_detail WHERE id_document = '94600' 30/11/2024 11:21:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94600' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 30/11/2024 11:31:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3737' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 11:31:32 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' , '3737' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 30/11/2024 11:31:32 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 = '94601' 30/11/2024 11:31:32 am >> DELETE FROM ps_document_detail WHERE id_document = '94601' 30/11/2024 11:31:32 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 ( '94601' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 30/11/2024 11:34:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3738' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 11:34:14 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' , '3738' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 30/11/2024 11:34:14 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 = '94602' 30/11/2024 11:34:14 am >> DELETE FROM ps_document_detail WHERE id_document = '94602' 30/11/2024 11:34:14 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 ( '94602' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 30/11/2024 11:52:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3739' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 11:52:10 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' , '3739' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '7.54' , NOW() , NOW() ) 30/11/2024 11:52:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94603' 30/11/2024 11:52:10 am >> DELETE FROM ps_document_detail WHERE id_document = '94603' 30/11/2024 11:52:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94603' , '23014' , 'GIUBILEO 2025 - SUSSIDIO RAGAZZI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 30/11/2024 11:52:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94603' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 30/11/2024 11:52:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94603' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 30/11/2024 11:53:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3740' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 11:53:30 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' , '3740' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '175.00' , '143.44' , NOW() , NOW() ) 30/11/2024 11:53:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94604' 30/11/2024 11:53:30 am >> DELETE FROM ps_document_detail WHERE id_document = '94604' 30/11/2024 11:53:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94604' , '16456' , 'CINGOLO - CING03' , '5' , '-5' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '75.00' ) 30/11/2024 11:53:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94604' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '50' , '40.983606557377' , '22' , '0' , '100.00' ) 30/11/2024 12:01:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3741' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 12:01:38 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' , '3741' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.40' , '56.89' , NOW() , NOW() ) 30/11/2024 12:01:38 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 = '94605' 30/11/2024 12:01:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '94605' 30/11/2024 12:01:38 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 ( '94605' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 30/11/2024 12:01:38 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 ( '94605' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 30/11/2024 12:05:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3742' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 12:05:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3742' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 30/11/2024 12:05:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94606' 30/11/2024 12:05:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '94606' 30/11/2024 12:05:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94606' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 30/11/2024 12:06:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3743' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 12:06: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 ( '11' , '3743' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 30/11/2024 12:06: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 = '94607' 30/11/2024 12:06:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94607' 30/11/2024 12:06: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 ( '94607' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 30/11/2024 12:12:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3744' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 12:12: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' , '3744' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.05' , '34.05' , NOW() , NOW() ) 30/11/2024 12:12: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 = '94608' 30/11/2024 12:12:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '94608' 30/11/2024 12:12: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 ( '94608' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 30/11/2024 12:12: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 ( '94608' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 30/11/2024 12:19:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3745' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 12:19: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 ( '11' , '3745' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '180.33' , NOW() , NOW() ) 30/11/2024 12:19: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 = '94609' 30/11/2024 12:19:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '94609' 30/11/2024 12:19: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 ( '94609' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '220' , '180.32786885246' , '22' , '0' , '220.00' ) 30/11/2024 12:29:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3746' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 12:29:43 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' , '3746' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.00' , '127.05' , NOW() , NOW() ) 30/11/2024 12:29:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94610' 30/11/2024 12:29:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '94610' 30/11/2024 12:29:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94610' , '17400' , 'STATUA MIRACOLOSA CM 40 - 805' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 30/11/2024 12:29:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94610' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 30/11/2024 12:29:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94610' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '38' , '31.147540983607' , '22' , '0' , '38.00' ) 30/11/2024 12:57:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3747' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 12:57:32 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' , '3747' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '265.90' , '239.54' , NOW() , NOW() ) 30/11/2024 12:57:32 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 = '94611' 30/11/2024 12:57:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '94611' 30/11/2024 12:57:33 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 ( '94611' , '23217' , 'SCATOLA PORTA OSTIA CON LUNETTA - 1355' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 30/11/2024 12:57:33 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 ( '94611' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 30/11/2024 12:57:33 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 ( '94611' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '5' , '39.90' ) 30/11/2024 12:57:33 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 ( '94611' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 30/11/2024 12:57:33 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 ( '94611' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 30/11/2024 01:02:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3748' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 01:02:14 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' , '3748' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 30/11/2024 01:02:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94612' 30/11/2024 01:02:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '94612' 30/11/2024 01:02:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94612' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 30/11/2024 01:02:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94612' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 30/11/2024 01:22:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3749' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 30/11/2024 01:22:31 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' , '3749' , '2024-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '368.60' , '305.94' , NOW() , NOW() ) 30/11/2024 01:22:31 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 = '94613' 30/11/2024 01:22:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94613' 30/11/2024 01:22:31 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 ( '94613' , '21137' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 30/11/2024 01:22:31 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 ( '94613' , '1616' , 'CANDELABRO MOD. 700 FINITURA ORO - CM 30 DM169R' , '2' , '-2' , '1' , '170' , '139.34426229508' , '22' , '0' , '340.00' ) 30/11/2024 01:22:31 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 ( '94613' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 30/11/2024 01:22:31 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 ( '94613' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 30/11/2024 01:22:31 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 ( '94613' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 30/11/2024 01:22:31 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 ( '94613' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 30/11/2024 01:22:31 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 ( '94613' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 30/11/2024 01:22:31 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 ( '94613' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 30/11/2024 01:28:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3646' AND id_document != '94493' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 30/11/2024 01:28:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3646', document_date = '2024-11-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '94493' 30/11/2024 01:28:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94493' 30/11/2024 01:28:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94493' 30/11/2024 01:28:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94493' , '22870' , 'AGENDA SAN PAOLO 2025' , '2' , '-2' , '1' , '9' , '7.3770491803279' , '22' , '0' , '18.00' )