Páginas filhas
  • Bank Statement - FINR470 - Financial P12

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

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.

...

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 http://tdn.totvs.com/x/FaVc


06. TABLES USED

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

...