This business function is used only when the processing options of the R are set to process BAI2 format. This function reads the text file as input, parses out the data and calls the B to write records to the staging tables. The system logs all errors that this function encounters in the jdedebug. This function writes the formatted data to the staging tables.
Use this processing option to specify the format you are using to process bank statements. Use this processing option to specify the name of the electronic bank statement text file submitted for processing from the bank. Use this processing option to specify the location of the bank statement text file. The system uses this value to locate the file so that it can process bank statement information.
Use this processing option to specify the location where the text file is moved if the file is not deleted due to processing errors.
Use this processing option to specify whether the system deletes the bank-submitted text file after it has been processed and data has been written to the automatic bank statement staging tables. Values are:. Use this processing option to specify the date format that the system uses for dates in the electronic bank statement files.
Values, used in combination, include:. If you have data that did not map correctly from the flat files to the staging tables F and F when you ran the Process Automatic Bank Statements Flat File program R , perform one of these tasks:. Some fields in the staging tables are disabled and the system does not allow you to revise data.
Other fields in the staging tables can be revised. You use a processing option to control which of these fields can be revised. You can only revise data in the staging tables; you cannot add or delete records. When you revise data that is in error, the Revise Electronic Bank Statement Staging program validates the data to ensure that the beginning balance and transaction amounts equal the ending balance for a bank statement. The staging tables include audit fields that are used for tracking and security purposes.
Records that are revised in the staging tables are tracked for internal audit purposes. Use these processing options to restrict users from revising certain fields on the Revise Electronic Bank Statement Staging form.
The processing options for this program correspond to these fields on the Revise Electronic Bank Statement Staging form:. If the closing balance is not in the bank flat file for the BAI2 format, the system calculates the closing balance in this field but it does not update any tables. This enables the staging tables to remain pristine, exactly as the data appeared in the bank flat file.
If you revise records that have not been loaded from the staging tables to the bank statement tables, run the Load Bank Statement program again so that the bank statement tables reflect the revisions. Processing option settings control whether you can revise certain fields in the detail area of this form.
Identifies a reference that appears on the electronic bank statement. This could be a deposit number for receipts or a payment number. Displays the date that the payment amount was debited or credited to the bank account. The transaction value date is not the date the bank reconciled the payment. If you change the Electronic Transaction Type field and the bank format is BAI2, the system supplies the default value for this field.
In a multicurrency environment, if the bank account currency is foreign, the foreign currency is the transaction currency. This field is always disabled. This program formats data according to the type of electronic format used BAI2 or SWIFT and edits values in the bank statement tables to ensure that they are valid.
The Load Bank Statement report R shows the number of records loaded and, if applicable, not loaded. If data was successfully mapped to the bank statement tables, the system sets a flag in the header record in the F table that allows the record to be purged.
You can set a processing option to purge the data from the staging tables when you run the Load Bank Statement program or you can purge the data at a later time.
If a bank statement does not contain transactions, the bank statement is not mapped to the bank statement tables because no detail records exist. The statement is, however, mapped to the staging tables to provide an exact duplicate of the bank flat file. Use this processing option to specify whether to purge records after running the Load Bank Statement program.
Specify whether to purge staging records that have been loaded successfully into the bank statement tables. The system runs the Purge Electronic Bank Statement Staging program after it successfully loads the staging records into the bank statement tables. This section provides an overview of data revisions to the bank statement tables and discusses how to:.
If errors occur when you run the Load Bank Statement program, you can use the Revise Automatic Bank Statement program to correct the errors in the bank statement tables F and F Some fields in the bank statement tables are disabled and the system does not allow you to revise data. Other fields in the bank statement tables can be revised. The bank statement tables include audit fields that are used for tracking and security purposes.
Records that are revised in the bank statement tables are tracked for internal audit purposes. Use these processing options to restrict users from revising certain fields on the Revise Auto Bank Statement form.
This form accesses records in the bank statement tables. The processing options for this program correspond to these fields on the Revise Auto Bank Statement form:. The system displays transactions by the date they cleared the bank in descending order, with the most recent transaction first.
If a data error exists, the system displays a warning message at the top of the Revise Auto Bank Statement form. For BAI2 electronic format, the system performs an integrity check that validates the data that you revise on this form. The integrity check ensures that the opening balance and the total debit and credit amounts equal the closing balance for an electronic bank statement. If there is a discrepancy in the amounts, the program displays a warning message, such as Closing balance is incorrect.
If the bank statement does not include a closing balance, the amount calculated in the Closing Balance field becomes the closing balance.
Displays the bank account number from the F staging table. You can revise this field, if necessary. Select this check box to display CR transactions that are missing a customer number. When the system processes automatic bank statements, it requires a customer number to create automatic batch receipts and apply them to invoices. If the customer number is blank, the system creates the automatic batch receipts as logged receipts. These receipts are not applied to invoices.
The value date is not the date the bank reconciled the payment. Displays a reference number of up to 16 alphanumeric characters and is typically used for receipts, payments, and bank wire transfers. This form displays CR transactions only.
The customer number is required to create automatic batch receipts and apply them to invoices; it is not required for all CR transactions. If the customer number is blank and the reconciliation rules are set up to create automatic batch receipts, the system creates a logged receipt and does not apply it to invoices.
Select this option to display CR transactions in which the customer number is missing. This section provides overviews of the automatic bank statement program and the automatic bank statement reports and messages and discusses how to:. After you run the Load Bank Statement program and, if necessary, revise data in the bank statement tables, you can run the Process Automatic Bank Statement program.
This program reconciles data that has cleared your bank against data that has been entered in the JD Edwards EnterpriseOne General Accounting system.
Specifically, the Process Automatic Bank Statement program:. Processes the transactions in the F and F tables and reconciles them to the transactions in the F table. Runs the Automatic Batch Receipt program R03B to create batch receipts for CR transactions that are marked for automatic batch receipts. The system creates automatic batch receipts and attempts to apply the receipts to invoices if a customer number is assigned to a transaction.
If the customer number is blank, the system creates a logged receipt, which is not applied to invoices. The Process Automatic Bank Statement program populates the GLR3 Reference 3 field in the F table with the batch number of the bank statement, not the batch number of the receipt or deposit number.
If you want the bank statement number to appear on transactions, you must select a check box for the reconciliation rule on the Revise Auto Reconciliation Group form.
For multicurrency processing, the program creates batch receipts only if the receipt and invoice currencies are the same. For transactions with customer numbers, runs the Apply Receipts to Invoices program R03B50 to apply the batch receipts to invoices.
Updates records in the staging tables as reconciled, unless the records were purged earlier in the process. In a multicurrency environment, the bank account format uses the transaction currency of the bank account. If the bank account currency is foreign not in the base currency of the company , the foreign currency is the transaction currency.
The Process Automatic Bank Statement program cannot calculate gains and losses on foreign currency bank accounts because there are no domestic amounts on the transactions.
After you run the Process Automatic Bank Statement program, you can review transactions on the Reconcile Bank Statement Detail to Account Ledger form and manually reconcile any exceptions that did not reconcile and, if applicable, unreconcile reconciled transactions. For these transactions, the Automatic Bank Statement process does not create a duplicate transaction but, instead, reconciles the existing journal entry against the general ledger.
Typically, this transaction type code is used for bank transactions such as bank fees and transfer fees. Contains instruction information about preparing and loading data, the format of the template, submitting the Bank Statement Reconciliation Data Import process, and correcting import errors. Enter information about the grouping of bank statement lines and system transactions for bank statement reconciliation, such as a value that identifies the grouping of records, or the bank account ID.
The following values are the source codes used to identify the sources of the reconciled items:. The Source ID column is used to identify the reconciled bank statement line or the application transaction. The following table shows how the source IDs are mapped to the source codes:. The process automatically imports the reconciliation data from the. Review the automatic reconciliation output to review the successfully reconciled groups and the exceptions.
Previous Next JavaScript must be enabled to correctly display this content. BAI2 format is getting used by Corporates to import the Bank statements in the system and will be used for reconciliation. BAI2 file format is a standardized set of codes which comes in text format.
It contains the data related to AP Payments negotiable and void status and Receipts remittance status. Sample File Template The Audience:. To summarize, with digitization, reconciliation between Book Bank Balance and Bank Balance has become easy.
Standard Bank statement format such as BAI2, is a good option for the same. It is simple to implement, helps to reconcile and expedite the Period close and makes Accountants' life easy.
Solution Architect at Jade Global. Deovrat Patky hold a degree in information technology and is an associate analyst at Jade Global. He has worked on Fusion Implementations as a Technical analyst. Enter your keywords Apply. The Big Idea With digitization in every field, traditional methods of Banks have been drastically changed.
0コメント