Bank Statements and Reconciliation
Discussion List
-
Create Accounting failed for External TransactionSummary: Create Accounting failed for External Transaction Content (required): Create Accounting failed for External Transaction with Origin Reconciliation Difference Er…SarahL 41 views 8 comments 0 points Most recent by Nirav Vekaria Payables, Payments & Cash Management -
Bank Reconciliation Matching RuleSummary: Bank Reconciliation Matching Rule Content (required): How to reconcile 1 bank statement line to 4 system transaction line with similar reference. 66029 on Bank …SarahL 64 views 10 comments 0 points Most recent by Nirav Vekaria Payables, Payments & Cash Management
-
Cash Management Bank Reconciliation with GL JournalsSummary: The Doc ID 2373823.1 was followed to get a Bank Reconciliation versus GL Journals. Content (required): ¿Can someone help me with the following, please? I'll app…Marcos Tecpanecatl 44 views 5 comments 0 points Most recent by Marcos Tecpanecatl Payables, Payments & Cash Management -
Bank statement line reconcillation history tableSummary: To get table names which may store the history of bank statement line from reconciliation point of view Content (required):Hi All as you may notice the Cash to …Amit Kapoor 21 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Exchange Rate Type for Non Functional Currency Bank account TransfersSummary: Content (required): Hi Experts, Our Functional currency is LKR. When doing fund transfers across two USD Bank accounts, the 'Corporate' defaults as the exchange…231094 21 views 2 comments 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
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 21 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 31 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 42 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 26 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 3 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 32 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 -
QR Codes For Billing and PaymentsSummary QR Code Integration For Oracle PaymentsContent This summer (June 2020) Switzerland has announced that it will be switching from payment slips (orange and red) to…User_8O6L5 132 views 5 comments 3 points Most recent by Ashutosh_Srivastava 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 11 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 58 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 38 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…
-
Is it possible to configure the system transaction data fields that are available for reconciliationSummary: We would like to add data fields that are available on Receipt records to the data fields that are available to the system transaction UI on the manual reconcil…Adrian Townsend 1 view 0 comments 0 points Started by Adrian Townsend Payables, Payments & Cash Management -
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…Sheneli Fernando 2 views 0 comments 0 points Started by Sheneli Fernando Payables, Payments & Cash Management
-
Troubleshooting: intraday bank statements are causing import errors for US, EMEA, and APACSummary: When requesting intraday bank statements for US, EMEA, and APAC, the following import error message occurs: "The statement line availability amount is invalid b…Kathryn Santello 11 views 0 comments 0 points Started by Kathryn Santello Payables, Payments & Cash Management
-
External Transaction creation by Auto reconciliation for One to Many ruleSummary: We are looking to implement automatic reconciliation. Since amount in statement will have difference we are looking to use tolerance limit. As per oracle docs a…
-
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 11 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_ 1 view 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 22 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 1 view 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 11 views 5 comments 0 points Most recent by Phil Nibert Payables, Payments & Cash Management