Demonstrate the bank transactions from my branch or my company.
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.
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" |
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. |
Consider Branch | All: For environments with corporate management, |
Convert Initial Balance | This defines the conversion rule for the initial balance row. This rule can be: |
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. |
Name | Description |
F470ALLF | Signal for handling the statement |
Transactions canceled or deleted from table SE5 should not appear on the report.
IMPORTANT!
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).
