ManPageW BankStatement
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Window: Bank Statement
Description : Process Bank Statements
Help : The Process Bank Statements window allows you to reconcile your Bank Statements. You can either enter the line items from the statement in the Statement Line tab or select the 'Create From' button to automatically generate the statement from all unreconciled payments to this bank account. Once you have completed reconciling, select the 'Process Statement' button to mark the payments as reconciled and update the appropriate GL accounts.
Tab: Bank Statement
Description : Bank Statement
Help : The Bank Statement Tab defines the Bank Statement to be reconciled.
Table Name : C_BankStatement
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Bank Account | Account at the Bank | The Bank Account identifies an account at this Bank. | C_BankAccount_ID
NUMBER(10) TableDir |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
| Statement date | Date of the statement | The Statement Date field defines the date of the statement. | StatementDate
DATE Date |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
| Manual | This is a manual process | The Manual check box indicates if the process will done manually. | IsManual
CHAR(1) YesNo |
| Beginning Balance | Balance prior to any transactions | The Beginning Balance is the balance prior to making any adjustments for payments or disbursements. | BeginningBalance
NUMBER Amount |
| Create lines from | Process which will generate a new document lines based on an existing document | The Create From process will create a new document based on information in an existing document selected by the user. | CreateFrom
CHAR(1) Button |
| Statement difference | Difference between statement ending balance and actual ending balance | The Statement Difference reflects the difference between the Statement Ending Balance and the Actual Ending Balance. | StatementDifference
NUMBER Amount |
| Match Bank Statement | Match Bank Statement Info to Business Partners, Invoices and Payments | MatchStatement
CHAR(1) Button | |
| Ending balance | Ending or closing balance | The Ending Balance is the result of adjusting the Beginning Balance by any payments or disbursements. | EndingBalance
NUMBER Amount |
| EFT Statement Reference | Electronic Funds Transfer Statement Reference | Information from EFT media | EftStatementReference
NVARCHAR2(60) String |
| EFT Statement Date | Electronic Funds Transfer Statement Date | Information from EFT media | EftStatementDate
DATE Date |
| Document Status | The current status of the document | The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field | DocStatus
CHAR(2) List |
| Process Statement | DocAction
CHAR(2) Button | ||
| Approved | Indicates if this document requires approval | The Approved checkbox indicates if this document requires approval before it can be processed. | IsApproved
CHAR(1) YesNo |
| Posted | Posting status | The Posted field indicates the status of the Generation of General Ledger Accounting Lines | Posted
CHAR(1) Button |
Tab: Statement Line
Description : Statement Line
Help : The Statement Line Tab defines the individual line items on the Bank Statement. They can be entered manually or generated from payments entered.
For Posting, the bank account organization is used, if it is not a charge.
Table Name : C_BankStatementLine
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Bank Statement | Bank Statement of account | The Bank Statement identifies a unique Bank Statement for a defined time period. The statement defines all transactions that occurred | C_BankStatement_ID
NUMBER(10) TableDir |
| Line No | Unique line for this document | Indicates the unique line for a document. It will also control the display order of the lines within a document. | Line
NUMBER(10) Integer |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
| Manual | This is a manual process | The Manual check box indicates if the process will done manually. | IsManual
CHAR(1) YesNo |
| Statement Line Date | Date of the Statement Line | StatementLineDate
DATE Date | |
| Account Date | Accounting Date | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. | DateAcct
DATE Date |
| Effective date | Date when money is available | The Effective Date indicates the date that money is available from the bank. | ValutaDate
DATE Date |
| Statement amount | Statement Amount | The Statement Amount indicates the amount of a single statement line. | StmtAmt
NUMBER Amount |
| Payment | Payment identifier | The Payment is a unique identifier of this payment. | C_Payment_ID
NUMBER(10) Search |
| Transaction Amount | Amount of a transaction | The Transaction Amount indicates the amount for a single transaction. | TrxAmt
NUMBER Amount |
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID
NUMBER(10) TableDir |
| Charge amount | Charge Amount | The Charge Amount indicates the amount for an additional charge. | ChargeAmt
NUMBER Amount |
| Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | C_Charge_ID
NUMBER(10) TableDir |
| Interest Amount | Interest Amount | The Interest Amount indicates any interest charged or received on a Bank Statement. | InterestAmt
NUMBER Amount |
| Reference No | Your customer or vendor number at the Business Partner's site | The reference number can be printed on orders and invoices to allow your business partner to faster identify your records. | ReferenceNo
NVARCHAR2(40) String |
| Memo | Memo Text | Memo
NVARCHAR2(255) String | |
| Match Bank Statement | Match Bank Statement Info to Business Partners, Invoices and Payments | MatchStatement
CHAR(1) Button | |
| Create Payment | Create Payment from Bank Statement Info | CreatePayment
CHAR(1) Button | |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID
NUMBER(10) Search |
| Invoice | Invoice Identifier | The Invoice Document. | C_Invoice_ID
NUMBER(10) Search |
| EFT Trx ID | Electronic Funds Transfer Transaction ID | Information from EFT media | EftTrxID
NVARCHAR2(40) String |
| EFT Trx Type | Electronic Funds Transfer Transaction Type | Information from EFT media | EftTrxType
NVARCHAR2(20) String |
| EFT Check No | Electronic Funds Transfer Check No | Information from EFT media | EftCheckNo
NVARCHAR2(20) String |
| EFT Reference | Electronic Funds Transfer Reference | Information from EFT media | EftReference
NVARCHAR2(60) String |
| EFT Memo | Electronic Funds Transfer Memo | Information from EFT media | EftMemo
NVARCHAR2(2000) String |
| EFT Payee | Electronic Funds Transfer Payee information | Information from EFT media | EftPayee
NVARCHAR2(255) String |
| EFT Payee Account | Electronic Funds Transfer Payyee Account Information | Information from EFT media | EftPayeeAccount
NVARCHAR2(40) String |
| EFT Statement Line Date | Electronic Funds Transfer Statement Line Date | Information from EFT media | EftStatementLineDate
DATE Date |
| EFT Effective Date | Electronic Funds Transfer Valuta (effective) Date | Information from EFT media | EftValutaDate
DATE Date |
| EFT Currency | Electronic Funds Transfer Currency | Information from EFT media | EftCurrency
NVARCHAR2(20) String |
| EFT Amount | Electronic Funds Transfer Amount | EftAmt
NUMBER Amount |
