Bank Statements and Reconciliation
Discussion List
-
Can bank account balances held in Cash Management be linked through to ARCS reconciliations?Summary Can the bank statement balances at the end of the month that are held in cash management be linked through to the ARCS reconciliations for the associated GL acco…Jason Goody 62 views 2 comments 1 point Most recent by Vaishnavi Laguduva Payables, Payments & Cash Management -
Unreconciled cash management at a point in timeSummary: I have a client that wants to be able to report on their unreconciled items at a point in time. I've tried using the cash to GL reconciliation report at a point…Maria Smith- de Novo Solutions 11 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Check the opening and closing balances manually created bankstatementSummary: Is there a way to let Oracle do a check on a manually created bankstatement to see if the opening and closing balance is correct. Content (please ensure you mas…JoostBroekhuis 1 view 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
How to exclude old unreconciled transactions from the Cash In Transit ReportSummary: We have just implemented the Oracle Fusion Cash Management Cloud Service module recently but our Oracle Fusion Payables and Payments Cloud Service, in addition …
-
Manual GL entries with cashclearing account are not showing as system transactions during bank reconSummary: Journals entered in GL manually with cash clearing accounts are not showing as system transactions when doing bank recon. Content (please ensure you mask any co…Maria Theresa 13 views 5 comments 0 points Most recent by Maria Theresa Payables, Payments & Cash Management
-
Updated receipt does not allow reconciliation with cash managementSummary: When manually updating an accounted receipt and adding a parameter, this is the message that appears: "The dates of the selected zero amount system transactions…Patricia Vargas 11 views 4 comments 1 point Most recent by Patricia Vargas Receivables & Collections -
Is there a Capability to programmatically Unreconcile Cash Management Payment Lines. (API?)Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nauman Khan 2 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Bank Statement Automatic Reconciliation for AR, AP, and External TransactionsI'm currently working on setting up the automatic reconciliation process for bank statements that include transactions from Accounts Receivable (AR), Accounts Payable (A…Omran Zeaiter 26 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Can the CM Bank Transaction detail box size be expanded through sandbox configuration?Summary: The CM Bank Transaction detail box is very small and I'd like to expand the box size so all detail is able to be seen. Is it possible to utilize a sandbox confi…Ben Mossman 1 view 1 comment 0 points Most recent by Ben Mossman Payables, Payments & Cash Management
-
How to write a parsing rule for the text FXAMT=602,56Summary: Importing a BAI2 bank statement into Oracle Cash Management. Bank is giving the original currency amount as FXAMT=602,56 in the additional information field. We…
-
Fees and Charges on statement lineGood day, What is the purpose of the Fees and Charges section on the create bank statement line page and how I can use it? RegardsAhmed Abdelaziz 4 views 2 comments 0 points Most recent by Ahmed Abdelaziz Payables, Payments & Cash Management
-
How do I mark old expense report invoices for corporate credit card charges as paid?Summary: We are not able to submit the PPR because of the error reason "The external bank account is inactive. Either the bank account or the assignment of the bank acco…
-
DFF is defined in AP Invoice level – Same DFF info to be passedSummary: DFF is defined in AP Invoice level – Same DFF info to be passed into the Reconciliation Reference Field which is under clearing Account manually option for the …Baskara Sateesh-Oracle 11 views 2 comments 0 points Most recent by Brian Burns Payables, Payments & Cash Management
-
Why am I getting ERROR: No records read from InboundFile while trying to receive ARP Recon file?I'm a novice here. Trying to receive a file called ARP Recon from the bank via sFTP transmission in fusion. When I run the Process Electronic Bank Statements process, it…Johnny'sDaddy 14 views 2 comments 0 points Most recent by Johnny'sDaddy Payables, Payments & Cash Management
-
Do Oracle Fusion supports ISO20022 CAMT053 V8 - camt.053.001.08Hello Currently our Banking partner supports ISO20022 CAMT053 V8 - camt.053.001.08 Bank Statements and I am unable to see them in the drop down. Can we import v8 version…Sujith Kandukuri 31 views 2 comments 0 points Most recent by Vinod Mohan Raj Payables, Payments & Cash Management
-
Unable to Generate Bank Statement SequencesDear Oracle Community, I am unable to generate bank statement sequences in Oracle Cloud Cash Management. This is impacting my reporting to the authorities. Please advise…Patrick Chrabieh 1 view 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Oracle Best Practices for Payments, Bank Statement and Receipts IntegrationSummary: Hi, Can someone share Oracle Best Practices for Payments, Bank Statement and Receipts Integration? My client is located in middle east region and want to have B…PratikL 31 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Receipt accounting date different than clearing dateSummary: The receipt has been cleared on 30/09 while the accounting date results to be 01/10, postponing the accounting from September to October. Also, I can see that t…
-
Best Practice for integrating Credit Card Statements to Oracle Fusion ExpensesHello Greetings! Can anyone suggest the best practice of Integrating Credit Card Statements to Oracle Fusion in UK Region a. Getting the statements stored in a SFTP Serv…Sujith Kandukuri 22 views 2 comments 0 points Most recent by Rahul K Khandelwal-Oracle Payables, Payments & Cash Management
-
Transaction Type Mapping In cash managementAny documentation for this topic. Regards.Omran Zeaiter 4 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Bank Statement Transaction Rules - Intercompany TransfersSummary: Hi We have noticed an issue with our bank statement transaction rules, relating to inter-entity cash transfers. Our current rules record the offset of the cash …Gifty Jose 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Loading multiple bank statements for same bank account on same day.Summary: Bank is sending multiple bank statements for same bank account in one day. Content (please ensure you mask any confidential information): Bank statement 1 for B…Anukirat_Bedi 11 views 4 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Cash Management - Journal Reconciliation - Change of Legal EntityWe have a bank account for which only journal transactions were recorded. 2 years back the legal entity associated with the bank account got merged with another legal en…
-
Error processing a Bank Statement:No active reconciliation rules exist for the selected bank accountOne of our bank statements is still showing in the Incomplete status after the create accounting process ran. The below is a summary of the log file error information. W…Sheila Alabrudzinski 16 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Not able to get unreconciliation date in cash management user interfaceSummary: HI, we are not able to drive unreconciliation date in cash management user interface, when the particular reconciled bank statement was unreconciled in cash man…Tushar Ghosh 1 view 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
How do you properly write parse rules to remove leading zeros only?Summary: Per this article - I created a cascading parse rule on transaction type 475 to remove leading zeros. If it’s known how many leading zeros needs to be eliminated…Denise with Penn Entertainment 44 views 2 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
CM - Bank Reconciliation - Opening Unreconciled TransactionsSummary: We are planning to implement cash management module in an instance where GL, AP and AR are already implemented and gone live. We are planning to add the Reconci…
-
Bank Statement CSVOne of my client's banks sends the bank statement in Excel or CSV format. Can this statement (in excel / csv) be directly interfaced into Oracle Cash Management? If not,…Dhanachandran K 11 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Best Practices for Integrating Payment Status Report (PSR) from Barclays with FusionHello Greetings! Can anyone suggest the best practice of Integrating Barclays Payments Status Reports to Oracle Fusion Finance in UK Region a. Getting the statements sto…Sujith Kandukuri 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Change accounting date of a unreconcileI need to reconcile a receipt sent on 09-30-2024. The remittance date is 08-05-2024, so the accounting on the reverse side is on that date and I need it to be 09-30-24. …