Bank Statements and Reconciliation
Discussion List
-
How to retrieve all Manage Bank Statement Transaction Creation Rules to check the accounting setup?Summary: We have to recheck and review all setup of accounting of Cash account and Offset account on Manage Bank Statement Transaction Creation Rules. But we have many t…Sarinee.p 26 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
When doing Manual Reconciliation, how can I reconcile journal lines?When reversing and posting a journal, how can I reconcile the two transactions together? The button is greyed out. Thank you.OConsHD 51 views 2 comments 0 points Most recent by Daniel_Spritzer Payables, Payments & Cash Management
-
How can I clear system transactions where the amount nets to zero (no entry on bank statement)I want to reconcile System transactions manually/Automatically for all those transactions whose net amount is zero (just like it's available in bank statement transactio…Kaushal_G 82 views 5 comments 0 points Most recent by Daniel_Spritzer Payables, Payments & Cash Management
-
Customize CAMT.053 TemplateSummary: Hi All, We are looking to customize camt.053 template, and referring below document, but the instructions are not clear, do we have any better reference to cust…
-
Cash to General Ledger reconciliation report snapshotSummary: Understand that cash to general ledger reconciliation report shows latest positions always. Has someone developed a custom data model which shows snapshot posit…Vicky Adwani 11 views 2 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Automatic Reconciliation of Rejected Payments doesn't seem to work for Debit Memo reversalSummary: A reversal debit memo transaction is not end dated yet DM not created but if reversal method is changed to 'Reverse' this works Content (required): No rejected …Jonathan Adejokun 83 views 3 comments 0 points Most recent by LaurentDup Payables, Payments & Cash Management
-
Bank Statement Import Error iso:20022:tech:xsd:camt.053.001.02Hi, While importing the iso:20022:tech:xsd:camt.053.001.02 Bank statement file we are getting below error message. Can anyone help us what went wrong in the configuratio…Koteshwar Tippani 12 views 2 comments 0 points Most recent by Koteshwar Tippani Payables, Payments & Cash Management
-
Why Transaction number is not visible in matching type One to Many and Many to Many?Summary: Task name - Manage Bank Statement Reconciliation Matching Rule. In Advance criteria, Operand name - "Transaction.Transaction number" is visible only for matchin…Saikrishna Gajula 53 views 6 comments 0 points Most recent by Vinutha-Oracle 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 1.7K views 3 comments 0 points Most recent by Roman Havrylyak Payables, Payments & Cash Management
-
Display alternate supplier name in bank statement reconciliationSummary: We want to display supplier alternate name for AP transactions in manual reconciliation screen in cash management. Is there a way to do so? Content (please ensu…Richa Arora-Oracle 1 view 1 comment 0 points Most recent by KOTRAVI_IN-Oracle Payables, Payments & Cash Management
-
How to update Balance Date after creating bank statement in cash management ?User has wrongly entered the balance date when loading a bank statement. Now, there are differences between the bank statement and Trial balance. There are some lines th…Kirtee Jeetah-Naran 11 views 2 comments 1 point Most recent by Kirtee Jeetah-Naran Payables, Payments & Cash Management
-
create AP Invoice custom Inquiry role without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIVSummary: can we create role for AP invoice Inquiry and view report access without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIV" which Allows access to Oracle Fusion…manoj.kumar4 131 views 3 comments 0 points Most recent by Boying Payables, Payments & Cash Management
-
Guidelines from Oracle for implementation of CAMT statements instead of existing BAI2 statementsCurrently, BAI2 statements have been implemented for Cash Management bank statement load and reconciliation. Client is expected to change to IS020022 CAMT formats and we…
-
How to set up a Cash Management Bank Statement Reconciliation Rule SetsSummary: We have the case of many statement lines of different dates and one AR system transaction, and we need to reconciliate them running the autoreconciliation proce…Guillermo Tessore 51 views 4 comments 0 points Most recent by Guillermo Tessore Payables, Payments & Cash Management
-
Statement Line Grouping AttributeSummary: I am trying to get more information on statement line grouping attributes in terms of what data on bank statement is exactly used when these attributes are sele…Osman Farooq 62 views 6 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
is there a bulk delete of Duplicate Bank statementsCustomer has large number of duplicated bank statements and is wanting to be able to use a mass delete process instead of deleting them one by onePhillipJ 12 views 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Need suggestion on modifying the posted payments while reconciling against the bank statement.Our oracle fusion client sees there is a difference between posted payments amount and the bank statement amount while doing reconciliation due to conversion rates. Plea…Aishwarya gannoji 1 view 1 comment 0 points Most recent by Vijay.P-Oracle Payables, Payments & Cash Management
-
importing bank statement manuallySummary: Our company has created a new department which will be created as a separate business unit within our Cloud solution. the bank has advised that the ilink functi…Anne Cilia 11 views 2 comments 0 points Most recent by Anne Cilia Payables, Payments & Cash Management
-
It is possible to exclude from Cash Management one transaction source?Summary: I need to know if there is possible to exclude transactions with a determined source in order to this transactions not appear in the Cash Management screen? Con…Sara González-Gaggero 33 views 3 comments 0 points Most recent by Harry Zhu Payables, Payments & Cash Management
-
Accounting Entries for Bank Account Transfer ReconciliationSummary: We are doing Bank Account Transfer. It creates 2 external transactions, one for each bank account. We are reconciling these external transactions with the bank …Swapnil Mangnalikar 32 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Request SetIn Oracle Fusion Cloud, there is a business requirement to create the Request Set for running the Additional cash transactions for all the bank account records. At prese…JeganSiga_01 47 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Supplier initiated direct debitsHi - Looking for more information on Supplier Initiated Direct Debits process to the specifics of below? Can the AP Invoice be created automatically or is it manual proc…Pawan Deep Singh 21 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
How to set the External Transaction status as reconciled for Internal Bank TransfersSummary: How to set the status of the external cash transactions which are generated as part of Internal Bank Account Transfer in order to generate the accounting entrie…Sai Phani 31 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Parsing Rule for MT940Summary: Hi All, Below is the bit of MT940 statement and I want to capture the reference ‘HSBCR22023110722400000’ in reconciliation reference. Could you please let me kn…Pavan.K 45 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Which accounting date will be defaulted at reconciled payment journal?Summary: Given the accounting option is set at Summarize by General Date Example: Bank Statement Date is 13-Nov-2023 Payment date is 10-Nov-2023 Reconciled action done o…DSCSB-NG 21 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Significance of Text Colors in Payables to Ledger Reconciliation ReportSummary: When the Payables to Ledger Reconciliation report is ran, some of the numbers appear in red, while some appear in blue. The colors do not seem to be associated …Victor Grinberg 11 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Is it possible to create a bank statement transaction rule with an include and exclude?Summary: We would like to create a bank statement transaction rule to create an external transaction with an include and exclude. For example, the reconciliation referen…Marija A 32 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Bank Statement reference number coming/Importing with noneZeros prefix where as Payable documentSummary: Bank Statement reference number coming/Importing with nineZeros prefix (00000000371699) where as Payable document has 371699 it is not taking Prefix zero, becau…Veerasekhar Divvi 11 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Auto Reconciliation for UTR referenceSummary: Below is the Bit of MT940 Statement where HSBCR22023121222837219 is UTR Number. How can use this reference for Auto reconciliation? What conditions to be used i…Pavan.K 8 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Parse Rule Syntax for Extracting Additional Information requiredDear Team, We are receiving Reconciliation Reference number in Tag 86 of Bank statement. Need your help in deriving syntax for below information from Additional Referenc…Krishan Chugh 2 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management