{"id":13240,"date":"2017-01-05T20:06:48","date_gmt":"2017-01-05T19:06:48","guid":{"rendered":"http:\/\/orabr.com\/?p=13240"},"modified":"2017-01-05T17:09:31","modified_gmt":"2017-01-05T19:09:31","slug":"-lancamento-gl","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=13240","title":{"rendered":"Lan\u00e7amento GL"},"content":{"rendered":"<p><HTML><HTML><\/p>\n<div>  <span style=\"display:none\">&nbsp;<\/span><!--~-|**|PrettyHtmlStartT|**|-~-->  <\/p>\n<div id=\"ygrp-mlmsg\" style=\"position:relative;\">\n<div id=\"ygrp-msg\" style=\"z-index: 1;\"><!--~-|**|PrettyHtmlEndT|**|-~-->  <\/p>\n<div id=\"ygrp-text\">\n<div id=\"divtagdefaultwrapper\" style=\"font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;\" dir=\"ltr\">\n<p>Oi Renato, tudo bem?<\/p>\n<p>  <\/p>\n<p>Como voc\u00ea mencionou, pode ser feito um fix no lan\u00e7amento corrigindo o valor, mas ser\u00e1 necess\u00e1rio executar o GLBALFIX para reconstruir a GL_BALANCES (sugiro abrir uma SR para solicitar o patch do GLBALFIX para sua vers\u00e3o). Al\u00e9m disso a headers e batches armazenam   o valor total do lan\u00e7amento \/ lote, ent\u00e3o teria que ajustar o valor l\u00e1 tamb\u00e9m.&nbsp;<\/p>\n<p>  <\/p>\n<p>Outra alternativa&nbsp;seria&nbsp;reverter este lote, o que vai anular o efeito na GL_BALANCES e ap\u00f3s isso fazer um fix para deletar&nbsp;estas linhas na lines, headers e batches.<\/p>\n<p>  <\/p>\n<p>Espero ter colaborado.<\/p>\n<p>abs<\/p>\n<p>  <\/p>\n<div id=\"Signature\">\n<p class=\"ecxMsoNormal\"><span class=\"ecxapple-style-span\"><b><span>Att.,<\/span><\/b><\/span><span style=\"font-size:10.0pt;\"><\/span><\/p>\n<p class=\"ecxMsoNormal\"><span style=\"font-size:10.0pt;\">&nbsp;<\/span><\/p>\n<p class=\"ecxMsoNormal\"><b><span style=\"background:white;\">Marcos Freitas<\/span><\/b><span style=\"font-size:11.0pt;\"><\/span><\/p>\n<p class=\"ecxMsoNormal\"><b><span style=\"font-size:10.0pt;background:white;\">Analista de Sistemas<\/span><\/b><span style=\"font-size:10.0pt;\"><\/span><\/p>\n<p class=\"ecxMsoNormal\"><b><span style=\"font-size:10.0pt;background:white;\">Consultor Funcional Oracle EBS<\/span><\/b><span><\/span><\/p>\n<p class=\"ecxMsoNormal\"><span class=\"ecxapple-style-span\"><span lang=\"EN-US\" style=\"font-size:8.5pt;background:white;\">phone.: (55|11) 98147-4684 ou (55 | 35) 98722-2304<br \/>  <\/span><\/span><\/p>\n<p class=\"ecxMsoNormal\"><span class=\"ecxapple-style-span\"><span style=\"font-size:8.5pt;background:white;\">mail:  <a href=\"mailto:marcosfreitasmb@live.com\" id=\"LPNoLP\">marcosfreitasmb@live.com<\/a><\/span><\/span><span style=\"font-size:10.0pt;\"><\/span><\/p>\n<p class=\"ecxMsoNormal\"><span style=\"font-size:8.5pt;\">skype: marcos.t.freitas<\/span><span style=\"font-size:10.0pt;\"><\/span><\/p>\n<p class=\"ecxMsoNormal\"><span lang=\"EN-US\" style=\"font-size:8.5pt;background:white;\">linkedIN:&nbsp;<a href=\"http:\/\/br.linkedin.com\/in\/marcosfreitasmb\/\" target=\"_blank\" id=\"LPNoLP\">br.linkedin.com\/in\/marcosfreitasmb<\/a><\/span><span><\/span><\/p>\n<\/p><\/div>\n<div style=\"color: rgb(0, 0, 0);\">\n<hr tabindex=\"-1\" style=\"width:98%;\">\n<div id=\"divRplyFwdMsg\" dir=\"ltr\"><font face=\"Calibri, sans-serif\" color=\"#000000\" style=\"font-size:11pt;\"><b>De:<\/b>  &lt;&gt; em nome de Renato Alves jordy2006@gmail.com  &lt;&gt;<br \/>  <b>Enviado:<\/b> quarta-feira, 4 de janeiro de 2017 15:54<br \/>  <b>Para:<\/b> <br \/>  <b>Assunto:<\/b>  Lan\u00e7amento GL<\/font>  <\/p>\n<div>&nbsp;<\/div>\n<\/p><\/div>\n<div><span>&nbsp;<\/span>  <\/p>\n<div id=\"ygrp-mlmsg\">\n<div id=\"ygrp-msg\">\n<div id=\"ygrp-text\">\n<div dir=\"ltr\">\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  Senhores, boa tarde e um otimo 2017 &nbsp;!<\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  <\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  <\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  Algu\u00e9m j\u00e1 passou por esta situa\u00e7\u00e3o &#8230;.<\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  <\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  <\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  O usuario efetuou um lcto no GL &nbsp;de &nbsp;(<span style=\"font-family:arial,sans-serif;font-size:small;\">1.815.700.001.731.476.480,00) &nbsp; rsss isso mesmo !!!&nbsp; Bom, s\u00f3 que alguns relat\u00f3rios, principalmente o balancete esta estourando os campos e ate mesmo dando diverg\u00eancias   nas somat\u00f3rias das contas PAI do balancete.<\/span><\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  <span style=\"font-family:arial,sans-serif;font-size:small;\"><br \/>  <\/span><\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  <span style=\"font-family:arial,sans-serif;font-size:small;\">Algu\u00e9m teria alguma solu\u00e7\u00e3o para isso ?<\/span><\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  <span style=\"font-family:arial,sans-serif;font-size:small;\"><br \/>  <\/span><\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  <span style=\"font-family:arial,sans-serif;font-size:small;\">Seria poss\u00edvel dar um update neste lacto direto na tabela definitiva para zerar este lacto ? &nbsp;ate porque terei impacto no Sped<\/span><\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  <\/div>\n<div class=\"gmail_default\" style=\"font-family:&quot;arial narrow&quot;,sans-serif;font-size:large;\">  <\/div>\n<div>\n<div class=\"gmail_signature\">\n<div dir=\"ltr\">\n<div>\n<div dir=\"ltr\">\n<div>\n<div dir=\"ltr\">\n<p><font color=\"#0D0D0D\"><b><\/b><\/font><\/p>\n<p>  <b>  <\/p>\n<p style=\"color:rgb(13,13,13);\"><b><\/b><\/p>\n<p>  <font color=\"#004c6f\" face=\"Calibri, sans-serif\"><span style=\"font-size:14.4px;\"><i>Atenciosamente<\/i><\/span><\/font><\/b>  <\/p>\n<div><b><font color=\"#004c6f\" face=\"Calibri, sans-serif\"><span style=\"font-size:14.4px;\"><i><br \/>  <\/i><\/span><\/font><\/b><\/div>\n<div><b><font color=\"#004c6f\" face=\"Calibri, sans-serif\"><span style=\"font-size:14.4px;\"><i><br \/>  <\/i><\/span><\/font><\/b><\/div>\n<div>\n<p style=\"margin:0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;background-color:rgb(255,255,255);\">  <b><span style=\"font-size:10pt;color:rgb(23,54,93);\">Renato Alves (Jordy)<\/span><\/b><span style=\"color:rgb(23,54,93);\"><u><\/u><u><\/u><\/span><\/p>\n<p style=\"margin:0px;color:rgb(34,34,34);font-size:12.8px;background-color:rgb(255,255,255);\">  <span style=\"font-size:9pt;color:rgb(23,54,93);\"><font face=\"verdana, sans-serif\">Consultor Oracle GL\/AP\/FA<\/font><\/span><\/p>\n<p style=\"margin:0px 0px 0px 0.4pt;color:rgb(34,34,34);font-size:12.8px;background-color:rgb(255,255,255);\">  <span style=\"font-size:9pt;color:rgb(23,54,93);\"><font face=\"verdana, sans-serif\">Cel.:&nbsp;<a value=\"&#43;13197373204\" style=\"color:rgb(17,85,204);\">(71) 99307-2582<\/a>&nbsp;(Tim)<\/font><\/span><\/p>\n<p style=\"margin:0px;color:rgb(34,34,34);font-size:12.8px;background-color:rgb(255,255,255);\">  <a href=\"mailto:cleton@una.edu.br\" target=\"_blank\" style=\"color:rgb(17,85,204);\"><font face=\"verdana, sans-serif\">jordy2006@gmail.com<\/font><\/a><\/p>\n<p style=\"margin:0px;color:rgb(34,34,34);font-size:12.8px;background-color:rgb(255,255,255);\">  <font face=\"verdana, sans-serif\">Skype:jordy2006sp<\/font><\/p>\n<p>  <b>  <\/p>\n<p style=\"color:rgb(34,34,34);margin:0px;font-size:12.8px;font-weight:normal;background-color:rgb(255,255,255);\">  <font face=\"verdana, sans-serif\"><span style=\"font-size:9pt;color:rgb(0,76,111);\"><\/span><\/font><\/p>\n<p style=\"color:rgb(34,34,34);margin:0px;font-family:arial,sans-serif;font-size:12.8px;font-weight:normal;background-color:rgb(255,255,255);\">  <\/p>\n<\/p>\n<p>  <\/b>  <\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div style=\"color:#fff;height:0;\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>  <\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Oi Renato, tudo bem? Como voc\u00ea mencionou, pode ser feito um fix no lan\u00e7amento corrigindo o valor, mas ser\u00e1 necess\u00e1rio executar o GLBALFIX para&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-13240","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/13240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13240"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/13240\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}