Bank Statements and Reconciliation
Discussion List
-
CE | Foreign Currency Bank StatementSummary: Q1 ) What industry formats are supported by Oracle Cash Mgmt for FOREIGN CURRENCY BANK STATEMENTS i.e. ledger currency is AUD but bank account currency is INR. … -
How to display other journal sources from Cash Management "Review Journal Entries"Content (required): Hi all When searching for a journal source under the Review Journal Entries from Cash Management, only a handful of the journal sources are available…Daniel Lundsteen Minke 1 view 3 comments 0 points Most recent by Daniel Lundsteen Minke Payables, Payments & Cash Management -
Bank statement to multiple business unit reconcileSummary: Hi, We have requirement to reconcile one bank statement to multiple business units of different ledger. Our requirement is on Cross ledger Payments. We have req…User_RQ6RL 21 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
How to automate bank statement import for multiple filesSummary: How to automate bank statement import for multiple files Content (required): Hi Expert, Can we automate the bank statement import for multiple files using 'Proc…Pritam Das 1 view 4 comments 0 points Most recent by User_8ISNO Payables, Payments & Cash Management
-
Does the Cash Managment module is a Third Party Provider (TPP) ?Summary: Does the Cash Managment module is a Third Party Provider (TPP) ? Content (required): Hello As far as I know a ‘Third Party Provider’ is an authorised online ser…Cesar Saveedra 11 views 0 comments 1 point Started by Cesar Saveedra Payables, Payments & Cash Management
-
We are having some challenges in paying some invoices in NGN. Those invoices were booked in USD.Summary:Is there any workaround aside using payment currency. We can't use payment currency because invoice is fully approved in USD and we want to pay using another cur…David Sakeye 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to reconcile Debit Memo Reversals in Cash ManagementSummary: How do I enable Receivables Debit Memo Reversals in Cash Management? Content (required): Hi, In some cases I need to create a Debit Memo Reversal against a Stan…Arny Elfa 1 view 3 comments 0 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management
-
Auto recognition of Realized gain/loss in the bank statementSummary: Hi all, We have a scenario where a receipt is entered for the foreign currency ( $ Receipt ) and is remitted to the ledger currency bank account (LKR Bank accou…
-
User GUID populated for field Created byHi All, We would like to understand why user GUID is captured for few records in GL_CODE_COMBINATIONS table and for few records we have username populated. We could see …Swapnil Kashid 1 view 0 comments 0 points Started by Swapnil Kashid Payables, Payments & Cash Management -
Rejected reconciliation groups using 'Mass reconciliation in a spreadsheet'Summary: Auto reconciliation of transactions through 'mass reconciliation in a spreadsheet' functionality appears to be limited by the manual reconciliation tolerance ru…Clare Farris 1 view 5 comments 0 points Most recent by Clare Farris Payables, Payments & Cash Management
-
How to use/reconcile the journals in Cash ManagementSummary: How to use/reconcile the journals in Cash Management Content (required): Hello, We have requirement to have journals reconciled with bank statements in Cash Man…Mukund Kudrimoti 1 view 4 comments 0 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management
-
Can you have multiple conditions/scenarios in one parse ruleSummary: Currently, I am trying to extract related AR invoice numbers for a deposit/AR payment from the statement files. All the invoice related detail is in the Additio…
-
Can I import a check number reconciliation reference for payments made by a 3rd party system?Summary: We have an inhouse developed system that prints benefit checks. We import the transaction activity into our ledger using the excel journal entry upload template…Jeremy Pond 1 view 8 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Loading select accounts from a BAI into Cash ManagementWe are in the process of moving from on prem to the cloud. We are only planning on configuring a subset of our bank accounts in Cash Management in the cloud. Is there a …User_CJYXL 1 view 2 comments 0 points Most recent by SamRobinsonCT Payables, Payments & Cash Management
-
Cash Management Parse Rules for Customer (Counterparty) NameSummary: We're looking to parse the counterparty/customer name from additional entry into Reconciliation reference. The current rule notates text after BNF and parses th…Irene_UCSD 1 view 4 comments 0 points Most recent by Irene_UCSD Payables, Payments & Cash Management
-
Dynamic File name is not working In bank statement importSummary: Dynamic File name is not working In bank statement import Content (required): Hi All, I am automating bank statement import using Process Electronic Bank statem…Pritam Das 1 view 2 comments 0 points Most recent by Ram M Pillai-Oracle Payables, Payments & Cash Management
-
Reconcilation of Oracle ERP entries in Cash Management via Bank StatementsSummary: We are reconciling payables, receivables and cash management entries in the general ledger with bank and credit card statements in ARCS. Now we also have a requ…Debargha Biswas 1 view 0 comments 0 points Started by Debargha Biswas Payables, Payments & Cash Management
-
Unclear a paymentSummary: Payment cleared the bank and auto reconciled. Bank then issued a return but the original bank statement line is still cleared. EBS used to allow manual uncleari…Anthony Cambria 1 view 2 comments 0 points Most recent by Jeremy Pond Payables, Payments & Cash Management
-
Multiple Bank Statement Files - Load &Import all at onceSummary: Investigating options to import multiple bank statement files in one iteration program run Content (required): My client receives multiple bank statement files,…User381170 1 view 2 comments 0 points Most recent by User381170 Payables, Payments & Cash Management
-
How to perform Supplier Refund?Summary: Our organization created a payment refund process in Payments. But the process we created based off How to Close a Credit Memo with a Refund Payment Type ( Doc …Jeremy Taylor 1 view 0 comments 0 points Started by Jeremy Taylor Payables, Payments & Cash Management
-
Attributes that get copied from bank statement line to external transaction during autoreconcileSummary: What other columns other than reconciliation reference gets copied to external transaction? Content (required): We have a requirement to copy 150 Char from adde…
-
Transaction codes from the banking formatContent (required): Hi all I'm currently trying to set up auto reconciliation for a customer. But, I have problems with the transaction codes. We are using CAMT053.001.0…Daniel Lundsteen Minke 11 views 8 comments 0 points Most recent by Daniel Lundsteen Minke Payables, Payments & Cash Management
-
What should be entered in *External Recon ReferenceSummary: 21D introduced Mass Bank Reconciliation option which I am testing. What data should be entered in the column External Recon Reference? Content (required): Versi…SarahL 11 views 4 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
Can we map a 937 transation as a Debt vs a Credit?Summary: We have switched banks and the new bank sends a BAI2 file with the 937 as a Debt. But Cash Management has it as a credit. Content (required): Where are the flow…Pdhogan 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Bank Statement Reconciliation - Parse Rule SetSummary: Content (required): Hi Experts, I would like to know the purpose of creating a parse rule set and if we are to upload bank statements using an excel, is parse r…231094 1 view 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Supplier is uploading non invoice document in the AP invoice image mail idSummary: Supplier is uploading non invoice document in the AP invoice image mail id and which are getting loaded too in incomplete status, how can we ensure that only in…Sam Samaddar 1 view 2 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management -
How to Join ce_statement_lines table into Ap_checks_allDear , I want to join ce_statement_lines or ce_statement_headers tables into Ap_checks_all tables Means i want to join cash management tables into payables table kindly …Mirza Adeel 1 view 6 comments 0 points Most recent by Mirza Adeel 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 11 views 4 comments 1 point Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Cloud implementations for MT940 Bank Statement format with Allied Irish Bank?Summary: Allied Irish Bank MT940 format provides tag15 account number in format which oracle doesn't accept. Content (required): Has anyone done a Cash Management Cloud …User_XIB5H 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management
-
What is the simplest bank statement format Oracle CE support ?Hello Experts We have a clearing bank account being used to manually pay some invoices, what is the simplest bank statement format supported by Oracle to reconcile the c…Murthy Kodavati 1 view 3 comments 0 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management