Screenshot:Financial Account

From InfiniteERP Wiki
Jump to: navigation, search
Back button.png   Back to Screens Reference


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.
  • 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.

Transactions old

  • INE No. : INE Number.
  • Type : A distinct item characteristic used for processes and sometimes grouped within a category.
  • Displayed Account : Text that will identify this bank account
  • Bank Control Digit
  • Business Partner : Anyone who takes part in daily business operations by acting as a customer, employee, etc.
  • Currency : An accepted medium of monetary exchange that may vary across countries.
  • Location / Address : A specific place or residence.
  • Partial Account No. : Code of the account
  • Bank Code : Code of the bank
  • Branch Code : Code of the branch
  • Credit Limit : Amount of Credit allowed
  • Current Balance : Current Balance
  • Description : A space to write additional related information.
  • IBAN : International standard for identifying bank accounts across national borders
  • 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.
  • Name : A non-unique identifier for a record/document often used as a search tool.
  • Routing No : Bank Routing Number
  • SWIFT Code : SWIFT Code (Society of Worldwide Interbank Financial Telecommunications)
  • Account control digit
  • 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.

Transactions old 2

The transaction tab lists all the deposit and withdrawal transactions of the financial account.

  • Line No. : A line stating the position of this request in the document.
  • Transaction Date : The date the transaction is carried out and registered in the cash journal.
  • Payment : Payment event
  • Modify : Process to modify transactions GL Item type once they have been created
  • Payment No.
  • Status : A defined state or position of a payment.
  • Deposit Amount
  • Withdrawal Amount
  • Cleared
  • Currency : An accepted medium of monetary exchange that may vary across countries.
  • Transaction Type : Type of credit card transaction
  • Description : A space to write additional related information.
  • G/L Item : An alias for the Account Combination which can be commonly used in daily operations.
  • Accounting Date : The date this transaction is recorded for in the general ledger.
  • Posted : An accounting status button that indicates if the transaction has already been posted to the general ledger or not.
  • Reconciliation : Reconciliation events related to the financial account
  • Foreign Amount : Amount of transaction in foreign currency
  • CreatedByAlgorithm : Document created by algorithm in matching process
  • Foreign Currency : The currency that transaction was made in if it was different to the account currency
  • Delete
  • 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.
  • 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
  • Foreign Conversion Rate : Conversion rate between foreign currency & financial account currency
  • Forced_Table_ID : Hidden column to set the source table id in views.
  • Financial account transaction
  • Financial Account Transaction
  • Financial Account : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
  • Client : Client for this installation.
  • Active : A flag indicating whether this record is available for use or de-activated.

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
  • Processed : A confirmation that the associated documents or requests are processed.
  • Foreign Currency : The currency that transaction was made in if it was different to the account currency
  • 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.

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
Back button.png   Back to Screens Reference