Bank Statements and Reconciliation
Discussion List
-
Can the bank suspense recorded in the GL be reconciled using a rule in CM?Summary: Can the bank suspense recorded in the GL be reconciled using a rule in CM? We want to post the Bank Suspense account to a JV, and then perform reconciliation in…Sarinee.p 11 views 0 comments 0 points Most recent by Sarinee.p Payables, Payments & Cash Management -
How is payment accounting done if option "at payment clearing" is set and there's no reconciliation?Content Hello In Romania, payment need to be accounted only after receiving the bank statement as a proof of payment (legal requirement).In order to do so, we set the Pa…Didier Rascle 83 views 6 comments 0 points Most recent by Santhosh_Krishnan123 Payables, Payments & Cash Management -
Many to Many Reconciliation Rule not working for bank statement with two days to one payment transacSummary: Manage Bank Statement Reconciliation Matching Rules Transaction Sources Payables Matching Type: Many to Many Statement Line Grouping Attributes: Reconciliation …Denise with Penn Entertainment 51 views 0 comments 0 points Most recent by Denise with Penn Entertainment Payables, Payments & Cash Management -
Auto reconciliation Exclude few linesSummary: We have encountered an issue during reconciliation. In manual reconciliation, we can skip lines that we do not wish to reconcile. However, in auto reconciliatio…Chandrakant W 12 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Accounting Error for non-reconciled External transactionHi All, Reaching out to Oracle community to suggest for the question as There is an accounting issue for unreconciled external transactions. Due to an Auto External rule… -
Need to set up Offset Account for funds transfer between account under same legal entitySummary: Need to set up Offset Account for funds transfer between account under same legal entity We need to set up Offset account when use transfer fund but using bank …Christian Leon 544 views 2 comments 0 points Most recent by User_1CIXV Payables, Payments & Cash Management -
How to reconcile one bank account to multiple business unitsSummary: The client has a requirement to switch from a shared service model to a service provider model. This will involve making supplier payments from a single bank ac…Abi Osborn 72 views 2 comments 0 points Most recent by MManduva Payables, Payments & Cash Management -
Hello All, Need help on Oracle Fusion Cash Management partial reversalsSummary: Hello All, Need help on Oracle Fusion Cash Management partial reversals. EX : If Bank send 100 usd then in oracle fusion cash management reconciled and reversed…User_NR5C8 11 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Duplicate bank statement importedSummary: Duplicate bank statement imported after loading the same file twice Content (please ensure you mask any confidential information): We imported the same CAMT053 …KHI_1009 1 view 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Defining new transaction codes in "Manage Bank Statement Transaction Codes"Summary: I am working on defining new bank transaction codes that exceed 30 characters. However, the "Transaction Code" field currently only accepts up to 30 characters.…S Mahapatra 31 views 4 comments 0 points Most recent by User_YJC0S Payables, Payments & Cash Management -
Rest API for Unreconciliation in oracle erp cloud cash management moduleSummary: Any REST API to update Bank Reconciliation status in Oracle Fusion Financials Cloud Cash Management Version (include the version you are using, if applicable): …User_NR5C8 65 views 7 comments 0 points Most recent by User_NR5C8 Payables, Payments & Cash Management -
BICC PVO "FscmTopModelAM.FinCeBankRelationshipsAM.BankAccountPVO" is not pulling any dataBICC PVO "FscmTopModelAM.FinCeBankRelationshipsAM.BankAccountPVO" is not pulling any data from BICC application but when we try from issue SQL its giving us the data. Ar…MaheshT 33 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
receipt creation in Receivables from Cash ManagementSummary: is there any way to create receipt in receivable from cash management in oracle fusion? Content (please ensure you mask any confidential information): Version (…Abhijit.tarsekar 61 views 0 comments 0 points Most recent by Abhijit.tarsekar Receivables & Collections -
Source field 'Proprietary Reference' not working in the parse ruleSummary: We are trying to import a CAM53 statement using the Process Electronic Bank Statements job. We have created parse rule to move data from the proprietary referen…Riddhi Todi 11 views 0 comments 0 points Most recent by Riddhi Todi Payables, Payments & Cash Management -
Prevent CM from unreconciling/unmatching against transactions in a closed periodWe're running into issues where CM is allowing unreconciling of transactions within a closed period, wondering if anyone knows if there's a way to prevent this?cheathsmith 1 view 2 comments 0 points Most recent by cheathsmith Payables, Payments & Cash Management -
Unable to reconcile system transactions that have matching positive and negative amountsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Emaar Description (Required): Unable …PochaveniRamesh 52 views 1 comment 1 point Most recent by Pavankumar Dosi-Oracle Payables, Payments & Cash Management -
Virtual Card ReconciliationWe use a virtual card through Paymode-X and they have a reconciliation file they can provide. It has the below specifications. Has anyone integrated similar type v-card …Mike Geak 41 views 0 comments 0 points Most recent by Mike Geak Payables, Payments & Cash Management -
How to prevent external transaction creation based upon certain string in MT940 fileSummary: Business don't want to get the external transactions to be created (and no reconciliation should happen) if certain string is present in MT940 statement file. F…Samiya Siddiqui 1 view 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Cash Management- Best Practice with Older TransactionsSummary: We have been live with Oracle ERP Cloud (Financials/Fusion) since 2016 and have recently started implementing/using the Cash Management module specifically for …Maria Trejo 31 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management