Toolbox

Main Page

Upload file

What links here

Recent changes

Help

Search

Participate

Screenshot:Financial Account

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.

Back to Screens_Reference

1 Financial Account

Financial Account

A Financial Account represents an account at a financial institution such as a bank account, a credit card issuer, an electronic payment service, as well as a cash or petty cash register.

Account

The financial account window contains essential information such as the bank account number and allows to perform a set of processes such as to add deposit or withdrawal transactions to the financial account or to import and match a bank statement file.

Organization : Organizational entity within client
Name : A non-unique identifier for a record/document often used as a search tool.
Currency : An accepted medium of monetary exchange that may vary across countries.
Type : A distinct item characteristic used for processes and sometimes grouped within a category.
Description : A space to write additional related information.
Location / Address : A specific place or residence.
Business Partner : Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Active : A flag indicating whether this record is available for use or de-activated.
Default : A value that is shown whenever a record is created.
Current Balance : Current Balance
Credit Limit : Amount of Credit allowed
Initial Balance : Initial balance of the financial account. Amount of the account at the time of registering the financial account.
Matching Algorithm : Identifies the algorithm used to match the imported bank statement lines
Funds Transfer Enabled : Funds Transfer Enabled flag is used to show/hide funds transfer button process.
GL Item Difference : GL Item Difference
Generic Account No. : Bank account number in a generic format.
IBAN : International standard for identifying bank accounts across national borders
SWIFT Code : SWIFT Code (Society of Worldwide Interbank Financial Telecommunications)
INE No. : INE Number.
Country : A state or a nation.
Bank Account Format : Bank Account Format used for generating the Displayed Account No
Type Write-off Limit : Holds the type of write off limit configured for the financial account.
Write-off Limit : Value for the Write-off limit in a payment.
Import Statement : ImportBankFile
Match Transactions Force
Match Statement
Reconcile : Manual reconciliation from Financial Account window
Add Multiple Payments : User can select multiple payments at the same time. The system will create a separate transaction per selected payment
Last reconciliation
Last reconciliation balance
Bank Code : Code of the bank
Branch Code : Code of the branch
Bank Control Digit
Account control digit
Partial Account No. : Code of the account
Displayed Account : Text that will identify this bank account
Add transaction process definition : Add transaction process definition
EM_Aprm_Findtransactionspd
Funds Transfer : Transfer funds between Financial Accounts
Routing No : Bank Routing Number
Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
Client : Client for this installation.

Transaction

Transaction Type : Type of credit card transaction
Reconciliation : Reconciliation events related to the financial account
Line No. : A line stating the position of this request in the document.
Status : A defined state or position of a payment.
CreatedByAlgorithm : Document created by algorithm in matching process
Transaction Date : The date the transaction is carried out and registered in the cash journal.
Active : A flag indicating whether this record is available for use or de-activated.
Accounting Date : The date this transaction is recorded for in the general ledger.
Payment No. : Document NO of the related payment
Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
Payment : Payment event
G/L Item : An alias for the Account Combination which can be commonly used in daily operations.
Description : A space to write additional related information.
Origin Financial Account : Financial Account from where the funds were transferred
Currency : An accepted medium of monetary exchange that may vary across countries.
Deposit Amount
Withdrawal Amount
Foreign Currency : The currency that transaction was made in if it was different to the account currency
Processed : A confirmation that the associated documents or requests are processed.
Process Now : A request to process the respective document or task.
Foreign Amount : Amount of transaction in foreign currency
Posted : An accounting status button that indicates if the transaction has already been posted to the general ledger or not.
Foreign Conversion Rate : Conversion rate between foreign currency & financial account currency
Organization : Organizational entity within client
Business Partner : Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Product : An item produced by a process.
Project : Identifier of a project defined within the Project & Service Management module.
Cost Center : Division that adds to the cost of an organization
Sales Campaign : An advertising effort aimed at increasing sales.
Activity : A distinct activity defined and used in activity based management.
Sales Region : A defined section of the world where sales efforts will be focused.
1st Dimension : A display of optional elements that are previously defined for this account combination.
2nd Dimension : A display of optional elements that are previously defined for this account combination.
Transaction Process
Financial account transaction
Client : Client for this installation.

Exchange rates

This tab allows to define an exchange rate to use while posting the financial account transaction to the ledger whenever the currency of the financial account is not the same as the general ledger currency.

Organization : Organizational entity within client
Active : A flag indicating whether this record is available for use or de-activated.
Currency : An accepted medium of monetary exchange that may vary across countries.
To Currency : Target currency
Invoice : A document listing products, quantities and prices, payment terms, etc.
Payment : Payment event
Financial Account Transaction
Rate : The percentage to be multiplied by the source to arrive at the tax or exchange amount.
Foreign Amount : Amount of transaction in foreign currency
Financial account transaction
Client : Client for this installation.
C_Conversion_Rate_Document_ID

Accounting History

This tab shows the accounting history of a given transaction.

Active : A flag indicating whether this record is available for use or de-activated.
Financial account transaction
General Ledger : The book containing all financial transactions recorded for the legal entity.
Financial Account Transaction
Period : A specified time period.
Accounting Date : The date this transaction is recorded for in the general ledger.
Account Element : A identification code for an account type.
Value : Value of the account used in the entry.
Accounting entry Description : Description of the accounting entry
Currency : An accepted medium of monetary exchange that may vary across countries.
Debit : The amount debited to an account, converted to the organization default currency.
Credit : The amount credited to an account, converted to the organization default currency.
Description : A space to write additional related information.
Business Partner : Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Product : An item produced by a process.
Asset : An item which is owned and exchangeable for cash.
Project : Identifier of a project defined within the Project & Service Management module.
Sales Region : A defined section of the world where sales efforts will be focused.
Activity : A distinct activity defined and used in activity based management.
Withholding : Withholding
Sales Campaign : An advertising effort aimed at increasing sales.
Cost Center : Division that adds to the cost of an organization
UOM : A non monetary unit of measure.
Type : Type of entry (Normal, Closing, Opening, Regularization)
Trx Organization : The organization which performs or initiates the transaction.
Transaction Date : The date that a specified transaction is entered into the application.
Tax : The percentage of money requested by the government for this specified product or transaction.
Table : A dictionary table used for this tab that points to the database table.
Storage Bin : A set of coordinates (x, y, z) which help locate an item in a warehouse.
Sequence Number : The order of records in a specified document.
Quantity : The number of a certain item.
Posting Type : A distinct posting amount characteristic used for processes and sometimes grouped within a category.
Organization : Organizational entity within client
Location to Address : The location where items are sent to.
Location from Address : The location where items are sent from.
Group ID : Accounting entry group ID
G/L Category : A classification used to group lines in the general ledger.
Foreign Currency Debit : The amount debited from the account, given in provider currency.
Foreign Currency Credit : The amount credited from the account, given in provider currency.
Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
FIN_Finacc_Transaction_Acct_ID
Document Category : A classification of document types that are shown and processed in the same window.
Client : Client for this installation.
2nd Dimension : A display of optional elements that are previously defined for this account combination.
1st Dimension : A display of optional elements that are previously defined for this account combination.

Accounting Configuration

The accounting configuration tab is used to define the accounts of a General Ledger to use while posting transactions such as a bank fee or a deposit.

General Ledger : The book containing all financial transactions recorded for the legal entity.
Active : A flag indicating whether this record is available for use or de-activated.
Bank Revaluation Gain Account : Account used for posting currency revaluation gains
Bank Revaluation Loss Account : Account used for posting currency revaluation losses
Bank Fee Account : Account used for posting Bank Fees
Enable Bank Statement : Enable Bank Statement Accounting
Bank Asset Account : Bank Asset Account used for bank statement accounting
Bank Transitory Account : Bank Transitory Account used for bank statement accounting
In Transit Payment IN Account : Account used for in transit status of incoming payments
Deposit Account : Deposit Account used by the financial account
Cleared Payment Account : Account used for payment IN when clearing
In Transit Payment OUT Account : Account used for in transit status of outgoing payments
Withdrawal Account : Withdrawal Account used by the financial account
Cleared Payment Account : Account used for status cleared of outgoing payments
Receive Payment Account : Receive Payment Account used by financial account
Organization : Organizational entity within client
Make Payment Account : Make Payment Account used by financial account
Financial Account Accounts : Financial Account Accounts
Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
Debit Account : Debit Account used by the financial account
Credit Account : Credit Account used by the financial account
Client : Client for this installation.

Payment Method

This tab lists all the payment methods assigned to the financial account. A payment can either be deposited in or withdrawn from the financial account if the payment method used is assigned to the financial account.

Payment Method : It is the method by which payment is expected to be made or received.
Active : A flag indicating whether this record is available for use or de-activated.
Default : A value that is shown whenever a record is created.
Payment In Allowed
Automatic Receipt
Automatic Deposit
Receive Payments in Multiple Currencies
Execution Type
Execution Process
Deferred
Upon Receipt Use : Account used upon receipt
Upon Deposit Use : Account used upon deposit
Upon Reconciliation Use : Account used upon reconciliation
Invoice Paid Status : State in which a invoice is considered paid. This state can be configured for each payment method and financial account.
Payment Out Allowed
Automatic Payment
Automatic Withdrawn
Make Payments in Multiple Currencies
Execution Type
Execution Process
Deferred
Upon Payment Use : Account used upon payment
Upon Withdrawal Use : Account used upon withdrawal
Upon Reconciliation Use : Account to be used upon reconciliation
Invoice Paid Status : State in which a invoice is considered paid. This state can be configured for each payment method and financial account.
Organization : Organizational entity within client
Financial Account's Payment Method
Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
Client : Client for this installation.

Imported Bank Statements

The tab lists the imported bank statement files as well as the bank statements created manually.

Document No. : An often automatically generated identifier for all documents.
Document Type : A value defining what sequence and process setup are used to handle this document.
Name : A non-unique identifier for a record/document often used as a search tool.
Active : A flag indicating whether this record is available for use or de-activated.
Import Date : Import date of the bank file
Transaction Date : The date the transaction is carried out and registered in the cash journal.
File Name
Notes
Posted : An accounting status button that indicates if the transaction has already been posted to the general ledger or not.
Bank Statement Process Force
Bank Statement Process
Processed : A confirmation that the associated documents or requests are processed.
Process Now : A request to process the respective document or task.
Organization : Organizational entity within client
Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
Client : Client for this installation.
Bank Statement : Bank statements related to a financial account

Bank Statement Lines

This tab list all the lines of a bank statement.

Active : A flag indicating whether this record is available for use or de-activated.
Line No. : A line stating the position of this request in the document.
Transaction Date : The date that a specified transaction is entered into the application.
Reference No. : The number for a specific reference.
Business Partner Name : Business Partner Name
Business Partner : Anyone who takes part in daily business operations by acting as a customer, employee, etc.
G/L Item : An alias for the Account Combination which can be commonly used in daily operations.
Amount OUT : Amount Debited. Reflects the amount OUT
Amount IN : Amount credited. Reflects amount IN
Financial account transaction
Matching Type : Type of matching for the given line
Description : A space to write additional related information.
Organization : Organizational entity within client
Client : Client for this installation.
Bank Statement Line : Line related to the bank statement
Bank Statement : Bank statements related to a financial account

Reconciliations old

Document No. : An often automatically generated identifier for all documents.
Document Type : A value defining what sequence and process setup are used to handle this document.
Transaction Date : The date the transaction is carried out and registered in the cash journal.
Ending Date : A parameter stating the ending time range related for a specified request, query, etc.
Starting Balance : Starting Balance
Ending Balance : Ending or closing balance
Reconciled Items
Reconciled Items Amount
Unreconciled Bank Statement Lines
Unreconciled Bank Statement Lines Amount
Outstanding Payments
Outstanding Payments Amount
Outstanding Deposits
Outstanding Deposit Amount
Document Status : The Document Status indicates the status of a document at this time.
Reconcile : Manages processing of reconciliation documents
Posted : An accounting status button that indicates if the transaction has already been posted to the general ledger or not.
Reconciliation Details
Reconciliation Summary
Reconciliation : Reconciliation events related to the financial account
Processed : A confirmation that the associated documents or requests are processed.
Process Now : A request to process the respective document or task.
Organization : Organizational entity within client
Forced_Table_ID : Hidden column to set the source table id in views.
Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
Client : Client for this installation.
Aprm_Reconciliation_V
Active : A flag indicating whether this record is available for use or de-activated.

Reconciliations

The reconciliation tab shows the reconciliations created manually if no matching algorithm is assigned to the financial account as well as the ones created while matching an imported bank statement file otherwise.

Organization : Organizational entity within client
Active : A flag indicating whether this record is available for use or de-activated.
Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
Document No. : An often automatically generated identifier for all documents.
Document Type : A value defining what sequence and process setup are used to handle this document.
Ending Date : A parameter stating the ending time range related for a specified request, query, etc.
Transaction Date : The date the transaction is carried out and registered in the cash journal.
Starting Balance : Starting Balance
Reconciliation Details
Print Detailed : Print Detailed
Reconciliation Summary
Print Summary : Print Summary
Ending Balance : Ending or closing balance
Document Status : The Document Status indicates the status of a document at this time.
Process Now : A request to process the respective document or task.
Processed : A confirmation that the associated documents or requests are processed.
Posted : An accounting status button that indicates if the transaction has already been posted to the general ledger or not.
Reconcile : Manages processing of reconciliation documents
Reconcile : Manages processing of reconciliation documents
Reconciliation Process Force
Reconciled Item No.
Reconciled Items Amount
UnReconciled Item No
UnReconciled Items Amount
Outstanding Payments Item No
Outstanding Payment Items Amount
Outstanding Deposits Item No
Outstanding Deposit Items Amount
Reconciliation : Reconciliation events related to the financial account
Client : Client for this installation.

Cleared items

This tab shows the transactions cleared or set as matched in a reconciliation.

Accounting Date : The date this transaction is recorded for in the general ledger.
Transaction Date : The date the transaction is carried out and registered in the cash journal.
Description : A space to write additional related information.
Financial account transaction
Bank Statement Line : Line related to the bank statement
Transaction Type : Type of credit card transaction
Currency : An accepted medium of monetary exchange that may vary across countries.
Payment : Payment event
G/L Item : An alias for the Account Combination which can be commonly used in daily operations.
Deposit Amount
Withdrawal Amount
Project : Identifier of a project defined within the Project & Service Management module.
1st Dimension : A display of optional elements that are previously defined for this account combination.
2nd Dimension : A display of optional elements that are previously defined for this account combination.
Sales Campaign : An advertising effort aimed at increasing sales.
Reconciliation : Reconciliation events related to the financial account
Organization : Organizational entity within client
Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
FIN_Reconciliationline_V_ID
Client : Client for this installation.
Activity : A distinct activity defined and used in activity based management.
Active : A flag indicating whether this record is available for use or de-activated.

Accounting

The accounting tab is a read-only tab which showa every financial account transaction posting.

Organization : Organizational entity within client
General Ledger : The book containing all financial transactions recorded for the legal entity.
Accounting Date : The date this transaction is recorded for in the general ledger.
Document Category : A classification of document types that are shown and processed in the same window.
Value : Value of the account used in the entry.
Name : Description of the accounting entry
Active : A flag indicating whether this record is available for use or de-activated.
Debit : The amount debited to an account, converted to the organization default currency.
Credit : The amount credited to an account, converted to the organization default currency.
Account Element : A identification code for an account type.
Transaction Date : The date that a specified transaction is entered into the application.
Description : A space to write additional related information.
Period : A specified time period.
Financial account transaction
Table : A dictionary table used for this tab that points to the database table.
Reconciliation : Reconciliation events related to the financial account
Bank Statement : Bank statements related to a financial account
Line No. : A line stating the position of this request in the document.
Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
G/L Category : A classification used to group lines in the general ledger.
Tax : The percentage of money requested by the government for this specified product or transaction.
Storage Bin : A set of coordinates (x, y, z) which help locate an item in a warehouse.
Posting Type : A distinct posting amount characteristic used for processes and sometimes grouped within a category.
Currency : An accepted medium of monetary exchange that may vary across countries.
Foreign Currency Debit : The amount debited from the account, given in provider currency.
Foreign Currency Credit : The amount credited from the account, given in provider currency.
UOM : A non monetary unit of measure.
Quantity : The number of a certain item.
Product : An item produced by a process.
Business Partner : Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Trx Organization : The organization which performs or initiates the transaction.
Location from Address : The location where items are sent from.
Location to Address : The location where items are sent to.
Sales Region : A defined section of the world where sales efforts will be focused.
Project : Identifier of a project defined within the Project & Service Management module.
Sales Campaign : An advertising effort aimed at increasing sales.
Activity : A distinct activity defined and used in activity based management.
1st Dimension : A display of optional elements that are previously defined for this account combination.
2nd Dimension : A display of optional elements that are previously defined for this account combination.
Asset : An item which is owned and exchangeable for cash.
Group ID : Accounting entry group ID
Sequence Number : The order of records in a specified document.
Type : Type of entry (Normal, Closing, Opening, Regularization)
Withholding : Withholding
Client : Client for this installation.
Aprm_Finacc_Trx_Full_Acct_V_ID