Bank Transactions - FINA100 - Financial - P12

• 01. OVERVIEW
• 02. EXECUTION 
• 03. OPERATIONS
• 04. PARAMETERS APPLIED
• 05. FINANCIAL RULE
• 06. MAIN PROCESSES
• 07. ACCOUNTING
• 08. ENTRY POINTS
• 09. TABLES

...

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) 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)

Important
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".
Example of automatic routine  Expandir origem
#INCLUDE "Protheus.ch"
User Function TST100()
Local nOpc := 0
Local aFINA100 := {}
Private lMsErroAuto := .F.
While .T.
nOpc := 0
nOpc := Warning("FINA100 EXECAUTO TEST", "Choose the menu option of the routine FINA100 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=Yes;2=No
MSExecAuto({|x,y,z| FinA100(x,y,z)},0,aFINA100,3)
If lMsErroAuto
MostraErro()
Else
MsgAlert(" Bank transaction payable included successfully !!!")
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=Yes;2=No
MSExecAuto({|x,y,z| FinA100(x,y,z)},0,aFINA100,4)
If lMsErroAuto
MostraErro()
Else
MsgAlert(" Bank transaction receivable included successfully !!!")
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("Deleted successfully!!!")
EndIf
ElseIf nOpc == 4
dbSelectArea("SE5")
SE5->(dbSetOrder(1))
SE5->(dbSeek(xFilial("SE5")+DToS(dDataBase) ))
dbSkip() //placed only for this test 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("Canceled successfully!!!")
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=No
NCTBONLINE" ,1 ,Nil}} //1=Yes;2=No
}
MSExecAuto({|x,y,z| FinA100(x,y,z)},0,aFINA100,7)
If lMsErroAuto
MostraErro()
Else
MsgAlert("Transfer successfully executed!!!")
EndIf
// Reversal of Transfer
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 canceled successfully!!!")
EndIf
EndIf
If nOpc == 0
Exit
Endif
Enddo
Return(Nil)

03. OPERATIONS

• Pay

This option allows adding an amount payable to the bank transactions.

...

List of parameters applied to FINA100 and its processing

Parameters (SX6)

05. FINANCIAL RULE

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.

...

Tip
a. In case of a Bank Transfer, and the value is wrong, enter an opposite entry. All of the transfers in "Bank Transfer" are registered for information safety.
b. For any option chosen in the Tp.Trans. (Type of Transfer) there will be bank transaction, updating the SE5 (Bank Balance), SE5 (Bank Transaction), FK5 (Bank Transactions) and FKA (Transactions Tracking) tables. 
c. Characteristics of bank transfer transactions between Checking Account:

d. Only the use of asterisk ( *** ) is allowed when typing the document number for "Trans Type" equal to "TB" or "CH". 
For example: 

...

1. In the bank transactions browser, click Transfer Reversal. 
2. The system displays the parameters screen. 
3. Fill in the parameters requested according to the help description and confirm it.
4. The bill requests was reversed from the system, returning the value to the source bank account.

07. ACCOUNTING

Configuration of standard entries for this routine

• Accounting - Bank Transaction Payable - Lps 562 and 664

08. ENTRY POINTS

09. TABLES

• SE5 – Bank Transaction 
• SE1 - Accounts receivable 
• SE2 - Accounts payable 
• SE3 - Sales Commissions
• SEF - Checks 
• SI1 - Chart of Accounts. 
• SI2 - Accounting Entries
• SI5 - Standardized Entries.
• SI6 - Totals Batches 
• SM2 - Currencies
• FJU - Saves bills deleted  
• FK1 - Posting Payment receivable
• FK2 - Posting Payment Payable
• FK3 - Calculated taxes
• FK4 - Withheld taxes 
• SE5 – Bank Transaction
• FK6 - Accessory values
• FK8 - Accounting Data
• FK9 - Transaction complement
• FKA - Transaction tracking  

...