INDEX

01. OVERVIEW

Demonstrate the bank transactions from my branch or my company.

02. EXAMPLE OF USE

1 – I added a banking transaction to the FINA100 (Bank transaction) routine. It will appear on my statement.

But I have used the wrong bank, and I need to delete this transaction and redo it.
At this time, no bank reversal will be generated, but the cancellation will be made because the transaction will not be registered in the checking account's actual statement since it was an operational failure, not an actual reversal.
With that, the Bank Statement Report (FINR470) will not show a reversal row, since no actual transaction happened in the checking account.

2 - I performed a manual post payable in the FINA080 (Manual posts payable) routine with a posting reason that generates a bank transaction.

This must appear on my bank statement as an outflow transaction from the checking account.
But I noticed that I performed the posting at the wrong bank, and I need to delete this transaction and redo it.
After the post is deleted, this transaction should not appear on my Bank Statement (FINR470) since no actual reversal was made on my bank account. I just fixed a process that had an operational failure.

3 - I posted a bill using a bank in Dollars, but I want to view values in my Bank Statement (FINR470) in Euro.

As the system currency conversion rates refer to the strong currency, the value posted in Dollar will be handled for display in two steps:

1) The value is converted to the strong currency based on the transaction rate (E5_TXMOEDA), regardless of the conversion option selected in the report questions (1=Rate of the day/2=Transaction rate);

2) The value is converted to Euro according to the "Convert values by?" question and following the rules below:

a) "Rate of the day" option: This will consider the conversion rate from the currency file (table SM2) of the day logged in the system (database);

b) "Transaction rate" option: This will consider the conversion rate from the currency file (table SM2) of the posting day. If the bill has a hired date (E1_TXMOEDA/E2_TXMOEDA) and is in the same currency for report display, the bill rate will be considered.

03. QUESTIONS

Question	Help
Bank	Select the code of the bank that generated the check. If you fill in the parameter "From Bank?" using the [F3] key, the next parameters "From Bank Branch?" and "From Account?" will be automatically filled in according to the banks' file.
Bank Branch	Enter the code of the bank branch that generated the check.
Account	Enter the code of the desired account.
From Date	Enter the start date of the date interval to get the desired result in the bank statement.
To Date	Enter the end date of the date interval to get the desired result in the bank statement.
Which Currency	Select the currency to be considered when issuing the statement.
Reconciliation	Select if the bank statement must contain "All", "Reconciled" or "Unreconciled" values. "Reconciled" will display all transactions already checked with the bank statement. "Unreconciled" will display only values not checked with the bank statement. "All" will display reconciled and unreconciled values.
Rows per page	Enter the number of rows to be printed.
Convert Values By	Select the rate to be used for converting the values.
First page balance to	Considered for composing the Start Balance. 1 - Branch: Branch's bank transactions 2 = Bank: All transactions from the selected bank.
Consider Branch	All: For environments with corporate management, this option is relevant when the bank transaction (SE5) is exclusive per branch, and the bank (SA6, SE8) is shared by the branches. Thus, the report will display the bank transactions from all the BRANCHES that share the same bank. For environments without corporate management, the report will display all bank transactions from all branches. Current Branch: The report will display only the bank transactions for the logged-in branch, respecting the sharing settings for bank transactions (SE5).
Convert Initial Balance	This defines the conversion rule for the initial balance row. This rule can be: Balance date rate = This converts the balance with the currency rate (SM2) registered on the initial balance generation date (E8_DTSALAT) Base date rate = This converts the balance with the currency rate (SM2) registered on the report's issue date Start Date Rate = This converts the balance using the currency rate (SM2) registered on the date of the initial interval for report issuance (MV_PAR04) End date rate = This converts the balance using the currency rate (SM2) registered on the date of the report's final interval (MV_PAR05)

04. PARAMETERS USED

Main Parameters

Name	Description
MV_CENT	Number of decimal places used to print amounts in currency 1.
MV_MOEDBCO	This defines if documents can be posted in a foreign bank, even if the bill has a different currency.

05. ENTRY POINTS

Name	Description
F470ALLF	Signal for handling the statement

06. TABLES USED

SE5 - Bank Transactions
SE8 - Bank Balances
SA6 - Banks
SM2 – Currency File

IMPORTANT!

Transactions canceled or deleted from table SE5 should not appear on the report.

CURRENCY CONVERSION

The Bank Statement (FINR470) routine has questions "Convert values by?", that allows you to convert the bank transaction values to the currency selected in the report.

The conversion is only performed when the currency selected in the report is different from the bank currency (ex: The bank currency is Real, and the report must be in Dollar).

Below is the behavior for each option in this question:

Transaction rate:

This considers the conversion rate linked to the bank transaction or bill post (E5_TXMOEDA).

If the transaction does not have a rate, the rate of the currency file (table SM2) for the date of the transaction/posting will be considered (E5_DATA).

Rate of the day:

This considers the conversion rate from the currency file (table SM2) of the day logged in the system (database).

Páginas filhas

Bank Statement - FINR470 - Financial P12