Índice | ||||||
---|---|---|---|---|---|---|
|
Informações | ||
---|---|---|
| ||
|
Through its routines and processes, Protheus controls the banking account inflows and outflows. It is possible to add transactions and to transfer values among banks.
The first stage of implementing bank transactions is in the registration of bank information where your company transacts. Several banks can be registered.
Procedure manually performed through the Bank Transactions routine (FINA100), with the display of the screens involved in the process - actions/commands from the user are required
Procedure automatically performed in the Bank Transactions routine (FINA100) without the display of screen - no interaction from the user required.
Used in customizations in which the process does not required user's interactions (MSEXECAUTO)
Aviso | ||
---|---|---|
| ||
As this is an internal control, the field "Type of Transaction" (E5_TIPODOC) has these features:
From 11/04/2020, this field began to be recorded as "DH". |
Bloco de código | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
#INCLUDE "Protheus.ch" User Function TST100() Local nOpc := 0 Local aFINA100 := {} Private lMsErroAuto := .F. While .T. nOpc := 0 nOpc := Aviso("TESTE EXECAUTO DO FINA100", "Choose the menue option of the FINA100 routine to be executed via EXECAUTO",{"PAY","RECEIVE","DELETE","CANCEL","TRANSF.","ST. TRANSF."}) If nOpc == 1 aFINA100 := { {"E5_DATA" ,dDataBase ,Nil},; {"E5_MOEDA" ,"M1" ,Nil},; {"E5_VALOR" ,500 ,Nil},; {"E5_NATUREZ" ,"001" ,Nil},; {"E5_BANCO" ,"001" ,Nil},; {"E5_AGENCIA" ,"001" ,Nil},; {"E5_CONTA" ,"001" ,Nil},; {"E5_BENEF" ,"TESTE AUTO - BENEF" ,Nil},; {"E5_HISTOR" ,"TESTE AUTO - AUTO" ,Nil},; {"NCTBONLINE" ,1 ,Nil}} //1=Sim;2=Não MSExecAuto({|x,y,z| FinA100(x,y,z)},0,aFINA100,3) If lMsErroAuto MostraErro() Else MsgAlert("Bank Transfer Pay successfully added !!!") EndIf ElseIf nOpc == 2 aFINA100 := { {"E5_DATA" ,dDataBase ,Nil},; {"E5_MOEDA" ,"M1" ,Nil},; {"E5_VALOR" ,1500 ,Nil},; {"E5_NATUREZ" ,"001" ,Nil},; {"E5_BANCO" ,"001" ,Nil},; {"E5_AGENCIA" ,"001" ,Nil},; {"E5_CONTA" ,"001" ,Nil},; {"E5_HISTOR" ,"TESTE AUTO - AUTO" ,Nil},} {"NCTBONLINE" ,1 ,Nil}} //1=Sim;2=Não MSExecAuto({|x,y,z| FinA100(x,y,z)},0,aFINA100,4) If lMsErroAuto MostraErro() Else MsgAlert("Bank Transfer Receive successfully added !!!") EndIf ElseIf nOpc == 3 dbSelectArea("SE5") SE5->(dbSetOrder(1)) SE5->(dbSeek(xFilial("SE5")+DToS(dDataBase) )) aFINA100 := { {"E5_DATA" ,SE5->E5_DATA ,Nil},; {"E5_MOEDA" ,SE5->E5_MOEDA ,Nil},; {"E5_VALOR" ,SE5->E5_VALOR ,Nil},; {"E5_NATUREZ" ,SE5->E5_NATUREZ ,Nil},; {"E5_BANCO" ,SE5->E5_BANCO ,Nil},; {"E5_AGENCIA" ,SE5->E5_AGENCIA ,Nil},; {"E5_CONTA" ,SE5->E5_CONTA ,Nil},; {"E5_HISTOR" ,SE5->E5_HISTOR ,Nil},; {"E5_TIPOLAN" ,SE5->E5_TIPOLAN ,Nil} } MSExecAuto({|x,y,z| FinA100(x,y,z)},0,aFINA100,5) If lMsErroAuto MostraErro() Else MsgAlert("Deletion successfully executed !!!") EndIf ElseIf nOpc == 4 dbSelectArea("SE5") SE5->(dbSetOrder(1)) SE5->(dbSeek(xFilial("SE5")+DToS(dDataBase) )) dbSkip() //added only for this tests sequence aFINA100 := { {"E5_DATA" ,SE5->E5_DATA ,Nil},; {"E5_MOEDA" ,SE5->E5_MOEDA ,Nil},; {"E5_VALOR" ,SE5->E5_VALOR ,Nil},; {"E5_NATUREZ" ,SE5->E5_NATUREZ ,Nil},; {"E5_BANCO" ,SE5->E5_BANCO ,Nil},; {"E5_AGENCIA" ,SE5->E5_AGENCIA ,Nil},; {"E5_CONTA" ,SE5->E5_CONTA ,Nil},; {"E5_HISTOR" ,SE5->E5_HISTOR ,Nil},; {"E5_TIPOLAN" ,SE5->E5_TIPOLAN ,Nil} } MSExecAuto({|x,y,z| FinA100(x,y,z)},0,aFINA100,6) If lMsErroAuto MostraErro() Else MsgAlert("Cancellation successfully executed !!!") EndIf ElseIf nOpc == 5 aFINA100 := { {"CBCOORIG" ,"001" ,Nil},; {"CAGENORIG" ,"001" ,Nil},; {"CCTAORIG" ,"001" ,Nil},; {"CNATURORI" ,"001" ,Nil},; {"CBCODEST" ,"002" ,Nil},; {"CAGENDEST" ,"002" ,Nil},; {"CCTADEST" ,"002" ,Nil},; {"CNATURDES" ,"002" ,Nil},; {"CTIPOTRAN" ,"CH" ,Nil},; {"CDOCTRAN" ,"123456" ,Nil},; {"NVALORTRAN" ,2500 ,Nil},; {"CHIST100" ,"TESTE TRF VIA EXECAUTO" ,Nil},; {"CBENEF100" ,"TESTE TRF VIA EXECAUTO" ,Nil},; {"NAGLUTINA" ,2 ,Nil},; //1=Sim;2=Não {"NCTBONLINE" ,1 ,Nil}; //1=Sim;2=Não } MSExecAuto({|x,y,z| FinA100(x,y,z)},0,aFINA100,7) If lMsErroAuto MostraErro() Else MsgAlert("Transferência executada com sucesso !!!") EndIf //Transfer Reversal ElseIf nOpc == 6 aFINA100 := { {"AUTNRODOC" ,"123456" ,Nil},; {"AUTDTMOV" ,dDataBase ,Nil},; {"AUTBANCO" ,"001" ,Nil},; {"AUTAGENCIA" ,"001" ,Nil},; {"AUTCONTA" ,"001" ,Nil} } MSExecAuto({|x,y,z| FinA100(x,y,z)},0,aFINA100,8) If lMsErroAuto MostraErro() Else MsgAlert("Transfer successfully canceled !!!") EndIf EndIf If nOpc == 0 Exit Endif Enddo Return(Nil) |
This option allows adding an amount payable to the bank transactions.
This option allows adding amounts receivable to the bank transaction.
This option allows to view the bank transaction registered, both payable or receivable.
It displays the query with the transaction accounting entry, if this has been accounted.
It displays the caption chart and meanings related to the transaction status
This operation allows to delete the bank transaction both payable and receivable, deleting the database record
This operation performs the counterpart of the transaction, which means reversing the value paid or received.
This operation allows to view the accounting apportionment applied to the bank transaction.
Research the transaction in the bank transactions file, resulting in the transaction placed and highlighted int he browser.
It executes two bank transactions in a single operation: outflow from the source account and inflow into the target account.
It reverses the transfer executed, returning the values to the source accounts
This option allows accounting of a bank transaction.
List of parameters applied to FINA100 and its processing
Deck of Cards | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Bank Transaction is used to perform entries between accounts by feeding the balance in the SE8 - Bank Balances table, and by registering the transactions in the SE5 = Bank Transaction table. This basic characteristic does not generate revenues and expenses for the company, only controlling inflows and outflows of values between accounts.
Deck of Cards | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
LP | Generator Fact | On | Off (CTBAFIN) |
516 | Addition of bank transaction payable with apportionment | X | X |
517 | Addition of bank transaction receivable with apportionment | X | X |
557 | Cancellation of bank transaction payable with apportionment | X | X |
558 | Cancellation of bank transaction receivable with apportionment | X | X |
560 | Bank transfer - source bank outflow | X | X |
561 | Financial transfer - source bank inflow | X | X |
562 | Bank transaction payable | X | X |
563 | Bank transaction receivable | X | X |
564 | Cancellation bank transaction payable | X | X |
565 | Cancellation bank transaction receivable | X | X |
Configuration of standard entries for this routine
Entry point | Description |
F100BROW | The entry point is executed before the bank transaction browser. |
FA100PAG | The entry point will be used after the recording of the accounting data of accounts payable in the bank transaction. |
FA100REC | The entry point is used after the recording of data and the accounting of the accounts receivable in the bank transaction. |
FINATROC | Executed after the recording of all transactions receivable and accounting data. Used only by the SIGALOJA environment. Document: FINATROC - Recording of transaction receivable data – 12069 |
FA100VLD | Allows the user to create validations in relation to access to deletion and cancellation of bank transaction. |
FA100CA2 | executed after the confirmation of Deletion of Bank Transaction, before the deletion and accounting. |
FA100CAN | The entry point will be used after the deletion of bank transactions before the accounting. |
FA100Get | allows the customer to fill out the bank transfer screen data automatically. |
FA100TRF | executed before the transfer and returns .T. to record the transfer or .F. otherwise. |
F100DOC | used to edit the check number during the transfer between banks and bank branches. |
A100BL01 | executed after the recording of bank transfer data. |
FA100DOC | Is used to manipulate the variable cDocTran. Return: value that must be in cDocTran Parameters: cBcoOrig, cAgenOrig,cCtaOrig,cTipoTran |
A100TR01 | used in the recording of bank transaction transfer. |
A100TRA | A100TRA entry point complements the A100TR01 entry point. This entry points receives a parameters array with this content: lEstorno, cBcoOrig, cBcoDest, cAgenOrig, cAgenDest, cCtaOrig, cCtaDest, cNaturOri, cNaturDes, cDocTran,cHist100. |
A100TR02 | used during the recording of bank transfer data |
A100TRB | A100TRB entry point complements the A100TR02 entry point.This entry point receives a parameters array with this content: lEstorno, cBcoOrig,cBcoDest, cAgenOrig, cAgenDest,cCtaOrig,cCtaDest,cNaturOri,cNaturDes,cDocTran, cHist100. |
A100TR03 | executed after the recording of the bank transfer data. After recording the SE5 of Source/Target banks after the accounting. |
A100TRC | A100TRC entry point complements the A100TR03 entry point.This entry point receives a parameters array with this content: lEstorno, cBcoOrig, cBcoDest, cAgenOrig, cAgenDest, cCtaOrig, cCtaDest, cNaturOri, cNaturDes, cDocTran, cHist100. |
F100TOK | Validates the bank transaction data. |
FA100TRF | The entry point FA100TFR is executed before the transfer and returns .T. To record the transfer or .F. otherwise. |
FA100ROT | Allows the addition of customized buttons in theEnchoiceBar of the Bank Transaction routine. |
FA100OKP | Used to block the addition of transactions payable in the Bank Transactions routine. If it returns true, the transaction is regularly performed, otherwise, there will not be addition of transaction. Logic return. |
FA100OKR | Used to block the addition of transactions payable in the Bank Transactions routine. In case the return is true, the transaction is regularly executed, otherwise, the transaction will not be added. Logic return. |
A85CHPDT | Allows the user to perform the own treatment to select the third party checks that may be used in the type of payment entered in the option differentiated payment. |
F100FBRW | The entry point is executed before the bank transaction browser. |
Deck of Cards | |||||||||
---|---|---|---|---|---|---|---|---|---|
| |||||||||
|