Bank Statements and Reconciliation
Discussion List
-
Parse rule not parsing as expected - unable to parse value into the customer reference field.Summary: Unable to parse a value into the customer reference field. Content (required): We are attempting to parse information from our BAI file, but it is not working l…Stacy Oelke 22 views 6 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
How to book a Supplier Refund in AP or Cash ManagementSummary: How to book a Supplier Refund in AP and Cash Management Content (required): Hello The company issue an invoice for $100 USD and the invoice were paid successful…Cesar Saveedra 42 views 5 comments 0 points Most recent by Cesar Saveedra Payables, Payments & Cash Management
-
Banking information not getting update on AP invoices.Summary: When we update the banking details for a supplier on the supplier site level then the existing invoices for that supplier does not get updated with the new bank…AkashAgarwal 62 views 5 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
How to setup to issue a 1099 in Oracle without issuing a payment ?Summary: We have come across a few unique situations where we wouldn't have a payment in oracle for a specific person or company, but we know we are required to send a 1…AkashAgarwal 22 views 3 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
Accounting date for reconciled checks is not the date the check cleared the bankSummary: Accounting date for reconciled checks is not the date the check cleared the bank when it crosses months Content (required): We currently have a situation where …Stacy Oelke 2 views 3 comments 1 point Most recent by Stacy Oelke Payables, Payments & Cash Management
-
How to use new 21D 'Mass Reconciliation of Bank Statement Lines and System Transactions' feature?Summary: How to use new 21D 'Mass Reconciliation of Bank Statement Lines and System Transactions' feature? Content (required): Can you please describe how the new featur…NLmenno 62 views 6 comments 1 point Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Is it possible to reconcile 2 different bank accounts statement lines with each otherContent (required): Hi all I got a customer which ask if it is possible to reconcile 2 different bank accounts' statement lines with each other. Is that possible? Or wha…Daniel Lundsteen Minke 12 views 2 comments 0 points Most recent by Daniel Lundsteen Minke Payables, Payments & Cash Management
-
user visibility on bank statements imported in errorSummary: I have a scenario where in Cash Management, Bank Statements and Reconciliation, Processing Warnings and Errors page, there are bank statements imported with err…Silvia Damiani-Oracle 12 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
BAI2 bank Statement import for two different BankSummary: BAI2 bank Statement import for two different Bank (Example:- ABC Bank and XYZ Bank) Content (required): I would like to know if there is a way to configure and …
-
Bank is rejecting payment file for payment of payables invoices with credit memo.Summary: We are using ISO20022 Common Global Implementation payment format to generate our payment file. Most of our invoices and credit memo are created from IDR. When …Zandro 53 views 5 comments 1 point Most recent by Kondaiah Mandadi-Oracle Payables, Payments & Cash Management
-
SWIFT MT940 row 25 file formatSummary Bank statement export in Swift MT940 format contains a dash (-) which is erroring on upload to CloudContent Our UK bank statement (Barclays) Swift MT940 exports …Tony Glennon 63 views 4 comments 2 points Most recent by Ashutosh_Srivastava Payables, Payments & Cash Management
-
Incoming WIRE recording in Cash ManagementSummary: Incoming WIRE recording in Cash Management Content (required): I would like to understand how to set up a incoming WIRE recording in Cash Management. This is pu…
-
Booking Date not within statement dateSummary: Bank Statement Upload error Content (required): Hi, We tried to upload a bank statement with the statement date from 01-Oct-2022 to 31-Oct-2022. The booking dat…
-
Service Provider BU concept in Oracle FusionSummary: The basic concept for Service provider model very clear that the Service provider BU provide the service on behalf of other BUs when it comes to centralize the …Jugander Kumar 12 views 2 comments 0 points Most recent by Jugander Kumar Payables, Payments & Cash Management
-
Need to get only the last 5 digits (highlighted) to be made available from the MT940 for Recon ReferSummary: Need inputs on getting only the last 5 digits (highlighted) to be made available from the MT940 statement as a Reconciliation Reference using Parse Rule to faci…Mansoor Mahmood-Oracle 12 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Reconcile multiples transactions source against a bank statement lineSummary: Reconcile multiples transactions source against a bank statement line - cash management module Content (required): Hi All, i have the following business case fo…CM_ 12 views 1 comment 0 points Most recent by Vijay K Beriwala-Oracle Payables, Payments & Cash Management
-
What is the Best Way to Reconcile in Cash Management to Third Party PaymentsSummary: We are a Health Insurance Company and we pay our claims out of a third party system. We have about 9,000 payments per week out of the third party system. We are…
-
How to Find/Retrieve/the Location of BAI2 File that the Bank Sends to Oracle Fusion-Cash ManagementSummary: We are unable to find out BAI2 file that the bank sends so as to import the bank statement into Oracle Financials Cloud – Cash Management and run Oracle Cash Ma…shivakumar.gurram 82 views 0 comments 0 points Started by shivakumar.gurram Payables, Payments & Cash Management
-
AP invoice calculating withholding in functional currency. Is there a way we can change it.Summary: Our functional currency is USD. We have lot of invoices that are in another currency, anytime those invoices are created, their withholding and VAT invoices are…David Sakeye 2 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Cash to GL recon report - Bank and book balance not matchingSummary: Content (required): Cash to GL recon report - Bank and Book balance not matching for the current month. There is no unreconciled transactions. All AP, CM and AR…DPM 14 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Validation to prevent a payment run making a payment to a country not serviced by the firm's bankSummary: Validation to prevent a payment run making a payment to a country not serviced by the firm's bank Content (required): We have an agreement with a bank to proces…Phil Nibert 12 views 5 comments 0 points Most recent by Phil Nibert Payables, Payments & Cash Management
-
bank ReconciliationSummary: How to reconcile a GL Journal in GBP with a Bank Statement Line which is in USD. Content (required): Version (include the version you are using, if applicable):…Ash000 12 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Best practice or process to handle a voided check that cleared the bankSummary: What is best practice or process to handle a voided check that cleared the bank Content (required): Version (include the version you are using, if applicable): …Anthony Cambria 11 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to modify the bank statement file from the bank for automatic processing of bank statement?Summary: We will need to process the bank statement file from the bank automatically in oracle cloud. Content (required): Hi Experts, We are using ISO20022 MX CAMT053.00…Zandro 42 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to autoreconcile One to Many EFT Payments in Cash ManagementSummary: How to autoreconcile One to Many EFT Payments in Cash Management when not all payments in the payment process request are cleared at the same time by the bank C…SChalam-Oracle 22 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
In reconciled tab for bank statement search is not working - what are the optionsSummary: In Bank statement reconciled tab , if there is a group of 100 records - when we are searching with particular amount/reference/ other field it is not sowing the…Jagadeesh Sukavasi 2 views 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
How can I clear system transactions where the cash nets to zero (no entry on bank statement)Summary: How can we clear/auto-reconcile net zero cash system transactions in the bank reconciliation. Content (required): We have many journal entries transferring cash…Tena Mose 62 views 10 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Query or Report to Extract Unreconciled Bank Bank Statement Lines & System TransactionsSummary: We would like to have a Query or Report to Extract Unreconciled Bank Bank Statement Lines & System Transactions. Content (required): One option to extract them …Ravi Kanth Vuddagiri 56 views 1 comment 0 points Most recent by Ravi Kanth Vuddagiri Payables, Payments & Cash Management
-
Reconciliation Reference is coming blank for BAI2Summary: Hi Team Reconciliation reference is coming blank when we upload bank statement. The line in bank statement is "16,466,10000,Z,123456789,000012345/" We have pars…Nidhi Chhajed 2 views 4 comments 0 points Most recent by JessicaSF Payables, Payments & Cash Management
-
Accounting Period Error for External Transactions while unreconciling bank statement lineSummary: We had a bank statement in April that was matched to a payment and the rounding off difference was released as an external transaction (external transaction was…Ashutosh_Srivastava 12 views 0 comments 0 points Started by Ashutosh_Srivastava Payables, Payments & Cash Management