Para inclusão de lançamentos contábeis via MILE utilizando a rotina automática seguir os passos abaixo: -Via configurador em Aceleradores / Mile / Layout - criar layout de importação para rotina CTBA102. Exemplo de XML que pode ser importado na rotina: <?xml version="1.0" encoding="UTF-8"?> <CFGA600 Operation="4" version="1.01"> <XZ1MASTER modeltype="FIELDS" > <XZ1_LAYOUT order="1"> <value>RMCT2</value> </XZ1_LAYOUT> <XZ1_TYPE order="2"> <value>1</value> </XZ1_TYPE> <XZ1_DESC order="3"> <value>MIGRACAO RM LANCAMENTOS CONTABEIS</value> </XZ1_DESC> <XZ1_ADAPT order="4"> <value>CTBA102</value> </XZ1_ADAPT> <XZ1_STRUC order="5"> <value>2</value> </XZ1_STRUC> <XZ1_SEPARA order="6"> <value>|</value> </XZ1_SEPARA> <XZ1_SEPINASP order="7"> <value>2</value> </XZ1_SEPINASP> <XZ1_TYPEXA order="8"> <value>2</value> </XZ1_TYPEXA> <XZ1_SEPINI order="9"> <value>1</value> </XZ1_SEPINI> <XZ1_SEPFIN order="10"> <value>1</value> </XZ1_SEPFIN> <XZ1_TABLE order="11"> <value>CT2</value> </XZ1_TABLE> <XZ1_DESTAB order="12"> <value>Lançamentos Contábeis</value> </XZ1_DESTAB> <XZ1_ORDER order="13"> <value>1</value> </XZ1_ORDER> <XZ1_SOURCE order="14"> <value>0001</value> </XZ1_SOURCE> <XZ1_TIPDAT order="18"> <value>1</value> </XZ1_TIPDAT> <XZ1_DECSEP order="19"> <value>1</value> </XZ1_DECSEP> <XZ1_EMULTC order="20"> <value>1</value> </XZ1_EMULTC> <XZ1_DETOPC order="21"> <value>2</value> </XZ1_DETOPC> <XZ1_IMPEXP order="23"> <value>1</value> </XZ1_IMPEXP> <XZ1_VERSIO order="24"> <value>1.0</value> </XZ1_VERSIO> <XZ1_MVCOPT order="25"> <value>1</value> </XZ1_MVCOPT> <XZ1_MVCMET order="26"> <value>1</value> </XZ1_MVCMET> <XZ1_NOCACHEMOD order="27"> <value>2</value> </XZ1_NOCACHEMOD> <XZ2DETAIL modeltype="GRID"> <struct> <XZ2_LAYOUT order="1"/> <XZ2_SEQ order="2"/> <XZ2_CHANEL order="3"/> <XZ2_SUPER order="4"/> </struct> <items> <item id="1" deleted="0" > <XZ2_SEQ>01</XZ2_SEQ> <XZ2_CHANEL>MASTER</XZ2_CHANEL> <XZ3DETAIL modeltype="FIELDS" > <XZ3_CHANEL order="2"> <value>MASTER</value> </XZ3_CHANEL> <XZ3_DESC order="3"> <value>CANAL MASTER</value> </XZ3_DESC> <XZ3_IDOUT order="4"> <value>MASTER</value> </XZ3_IDOUT> <XZ3_OCCURS order="5"> <value>1</value> </XZ3_OCCURS> </XZ3DETAIL> <XZ4DETAIL modeltype="GRID" optional="1"> <struct> <XZ4_LAYOUT order="1"/> <XZ4_CHANEL order="2"/> <XZ4_SEQ order="3"/> <XZ4_FIELD order="4"/> <XZ4_TYPFLD order="5"/> <XZ4_EXEC order="6"/> <XZ4_COND order="7"/> <XZ4_NOVAL order="8"/> <XZ4_DESC order="9"/> <XZ4_OBS order="10"/> <XZ4_SOURCE order="11"/> </struct> <items> <item id="1" deleted="0" > <XZ4_SEQ>001</XZ4_SEQ> <XZ4_FIELD>DDATALANC</XZ4_FIELD> <XZ4_TYPFLD>D</XZ4_TYPFLD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_SOURCE>0002</XZ4_SOURCE> </item> <item id="2" deleted="0" > <XZ4_SEQ>006</XZ4_SEQ> <XZ4_FIELD>CLOTE</XZ4_FIELD> <XZ4_TYPFLD>C</XZ4_TYPFLD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_SOURCE>0003</XZ4_SOURCE> </item> <item id="3" deleted="0" > <XZ4_SEQ>007</XZ4_SEQ> <XZ4_FIELD>CSUBLOTE</XZ4_FIELD> <XZ4_TYPFLD>C</XZ4_TYPFLD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_SOURCE>0004</XZ4_SOURCE> </item> <item id="4" deleted="0" > <XZ4_SEQ>008</XZ4_SEQ> <XZ4_FIELD>CDOC</XZ4_FIELD> <XZ4_TYPFLD>C</XZ4_TYPFLD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_SOURCE>0005</XZ4_SOURCE> </item> <item id="6" deleted="0" > <XZ4_SEQ>010</XZ4_SEQ> <XZ4_FIELD>NTOTINF</XZ4_FIELD> <XZ4_TYPFLD>N</XZ4_TYPFLD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_SOURCE>0007</XZ4_SOURCE> </item> <item id="7" deleted="0" > <XZ4_SEQ>011</XZ4_SEQ> <XZ4_FIELD>NTOTINFLOT</XZ4_FIELD> <XZ4_TYPFLD>N</XZ4_TYPFLD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_SOURCE>0008</XZ4_SOURCE> </item> </items> </XZ4DETAIL> <XZ5DETAIL modeltype="GRID" optional="1"> <struct> <XZ5_LAYOUT order="1"/> <XZ5_CHANEL order="2"/> <XZ5_SEQ order="3"/> <XZ5_FIELD order="4"/> <XZ5_TYPFLD order="5"/> <XZ5_EXEC order="6"/> <XZ5_COND order="7"/> <XZ5_OBS order="8"/> <XZ5_SOURCE order="9"/> </struct> </XZ5DETAIL> </item> <item id="2" deleted="0" > <XZ2_SEQ>02</XZ2_SEQ> <XZ2_CHANEL>DETAIL</XZ2_CHANEL> <XZ2_SUPER>MASTER</XZ2_SUPER> <XZ3DETAIL modeltype="FIELDS" > <XZ3_CHANEL order="2"> <value>DETAIL</value> </XZ3_CHANEL> <XZ3_DESC order="3"> <value>CANAL DETAIL</value> </XZ3_DESC> <XZ3_IDOUT order="4"> <value>DETAIL</value> </XZ3_IDOUT> <XZ3_OCCURS order="5"> <value>N</value> </XZ3_OCCURS> </XZ3DETAIL> <XZ4DETAIL modeltype="GRID" optional="1"> <struct> <XZ4_LAYOUT order="1"/> <XZ4_CHANEL order="2"/> <XZ4_SEQ order="3"/> <XZ4_FIELD order="4"/> <XZ4_TYPFLD order="5"/> <XZ4_EXEC order="6"/> <XZ4_COND order="7"/> <XZ4_NOVAL order="8"/> <XZ4_DESC order="9"/> <XZ4_OBS order="10"/> <XZ4_SOURCE order="11"/> </struct> <items> <item id="1" deleted="0" > <XZ4_SEQ>002</XZ4_SEQ> <XZ4_FIELD>CT2_FILIAL</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Filial do Sistema</XZ4_DESC> <XZ4_OBS>FILIAL DO SISTEMA</XZ4_OBS> <XZ4_SOURCE>0002</XZ4_SOURCE> </item> <item id="2" deleted="0" > <XZ4_SEQ>003</XZ4_SEQ> <XZ4_FIELD>CT2_LINHA</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Numero da Linha</XZ4_DESC> <XZ4_OBS>Numero da Linha</XZ4_OBS> <XZ4_SOURCE>0003</XZ4_SOURCE> </item> <item id="3" deleted="0" > <XZ4_SEQ>004</XZ4_SEQ> <XZ4_FIELD>CT2_MOEDLC</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Moeda do Lancamento</XZ4_DESC> <XZ4_OBS>Moeda do Lancamento</XZ4_OBS> <XZ4_SOURCE>0004</XZ4_SOURCE> </item> <item id="4" deleted="0" > <XZ4_SEQ>005</XZ4_SEQ> <XZ4_FIELD>CT2_DC</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Tipo do Lancamento</XZ4_DESC> <XZ4_OBS>Tipo do Lancamento</XZ4_OBS> <XZ4_SOURCE>0005</XZ4_SOURCE> </item> <item id="5" deleted="0" > <XZ4_SEQ>006</XZ4_SEQ> <XZ4_FIELD>CT2_DEBITO</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Conta Debito</XZ4_DESC> <XZ4_OBS>Conta Debito</XZ4_OBS> <XZ4_SOURCE>0006</XZ4_SOURCE> </item> <item id="6" deleted="0" > <XZ4_SEQ>007</XZ4_SEQ> <XZ4_FIELD>CT2_CREDIT</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Conta Credito</XZ4_DESC> <XZ4_OBS>Conta Credito</XZ4_OBS> <XZ4_SOURCE>0007</XZ4_SOURCE> </item> <item id="7" deleted="0" > <XZ4_SEQ>008</XZ4_SEQ> <XZ4_FIELD>CT2_VALOR</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Valor do Lancamento</XZ4_DESC> <XZ4_OBS>Valor do Lancamento</XZ4_OBS> <XZ4_SOURCE>0008</XZ4_SOURCE> </item> <item id="8" deleted="0" > <XZ4_SEQ>009</XZ4_SEQ> <XZ4_FIELD>CT2_ORIGEM</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Origem do Lancamento</XZ4_DESC> <XZ4_SOURCE>0009</XZ4_SOURCE> </item> <item id="9" deleted="0" > <XZ4_SEQ>010</XZ4_SEQ> <XZ4_FIELD>CT2_HP</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Historico Padrao</XZ4_DESC> <XZ4_SOURCE>0010</XZ4_SOURCE> </item> <item id="10" deleted="0" > <XZ4_SEQ>011</XZ4_SEQ> <XZ4_FIELD>CT2_CONVER</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Criterio de Conversao</XZ4_DESC> <XZ4_OBS>CRITERIO DE CONVERSAO</XZ4_OBS> <XZ4_SOURCE>0011</XZ4_SOURCE> </item> <item id="11" deleted="0" > <XZ4_SEQ>012</XZ4_SEQ> <XZ4_FIELD>CT2_HIST</XZ4_FIELD> <XZ4_NOVAL>2</XZ4_NOVAL> <XZ4_DESC>Historico Lcto</XZ4_DESC> <XZ4_OBS>Historico Lcto</XZ4_OBS> <XZ4_SOURCE>0012</XZ4_SOURCE> </item> </items> </XZ4DETAIL> <XZ5DETAIL modeltype="GRID" optional="1"> <struct> <XZ5_LAYOUT order="1"/> <XZ5_CHANEL order="2"/> <XZ5_SEQ order="3"/> <XZ5_FIELD order="4"/> <XZ5_TYPFLD order="5"/> <XZ5_EXEC order="6"/> <XZ5_COND order="7"/> <XZ5_OBS order="8"/> <XZ5_SOURCE order="9"/> </struct> </XZ5DETAIL> </item> </items> </XZ2DETAIL> </XZ1MASTER> </CFGA600> -Criar Arquivo Texto com as seguintes características: -Canal Master - Incluir data de lançamento, numero do lote, numero do sublote, numero do documento, valor informado e valor informado do lote |MASTER|12/05/16|333333|333|333333|2450.50|2450.50| -Canal Detail - Incluir dados do lançamento como filial, linha, moeda, tipo do lançamento, conta a debito, conta a credito, valor, origem do lançamento, critério de conversão e histórico, |DETAIL|D MG 01 |001|01|3|101010101|101010102|2450.50|TESTEPC||11|HISTORICO TESTE|
Exemplo de Arquivo Texto a ser Importado: |MASTER|12/05/16|333333|333|333333|2450.50|2450.50| |DETAIL|D MG 01 |001|01|3|101010101|101010102|2450.50|TESTEPC||11|HISTORICO TESTE| -Na própria rotina do MILE executar Processamento de TXT informando o layout e o nome do arquivo a ser importado. -Entrar em Contabilidade Gerencial e verificar se lançamento foi incluído na data informada no arquivo texto em lançamentos contábeis automáticos (CTBA102)
Este exemplo é para inclusão de novos lançamentos, portanto se necessitar rodar a rotina novamente tem que previamente excluir o lançamento ja processado. Caso copie este exemplo para testes deverá ser acertados os campos filiais e conta contábil de acordo com seus próprios cadastros.
|