To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Account Reconciliation
Discussion List
-
Fixing Columns on Drill Through.Content Hi All, Is it possible to fix the columns on the Drill Through of the Source and Subsystem Ending balances? Currently the only options I have is to select the op… -
Creating a Report which displays User InformationSummary Creating a Report which displays User InformationContent Hi Expert, I want to create a report which fetches the user details. If a user is preparer or reviewer o… -
Comparing Ending Balance of Recon of Prior Period from Current Period Ending BalanceSummary Comparing Ending Balance of Recon of Prior Period from Current Period Ending BalanceContent Hi All, I have a query regarding reconciliation . I have created a pr…
-
ARCS Account Analysis for Detailed GL TransactionsSummary Account Analysis with detailed GL transactions as Balance ExplanationsContent Hello, We are thinking to use account analysis for accounts from third party sub le… -
Locked Through Date and Closed Through DateSummary Locked Through and closed through Date error while approving the matchesContent In ARCS, we are getting the attached error in the TM, while approving the suggest… -
Ability to update metadata into ARCS.Summary ARCS metadata can be refreshed if one of the GL dimensions is updated.Content Hi All, Can we update the metadata in ARCS when one of the members of the GL dimens…
-
Convert Functional Currencies into reporting currency of loaded balances in source/sub systemContent Dear Team We have a requirement to convert functional currencies loaded balance into Reporting currencies using exchange rate with help of rate type. We tried us…
-
Drill through on AP/AR data imported through OOTB ERP adaptorsContent Hi, For AP/AR reconciliations, we are planning to use the Out of the box cloud ERP adaptors from Data Management. It pulls in transactional data which I do not t…
-
New Job ID Column Added to Reconciliation Compliance Jobs already existing in the 20.11.70Summary Job ID column added to Reconciliation Compliance Jobs came out as an update in the recent December release but already exiting in the 20.11.70 versionContent Hi …
-
ARCS Data ManagementSummary Unable to retrieve members in mappingContent Hi, I am trying to set up data management in ARM. While I try to create mappings in Data load Mapping I get error sa…
-
Data Mapping with Transaction MatchingSummary Issue with more than 20 source columnsContent Hi All, My client has 25 columns they want to bring in for reference in transaction matching. When I create the loc…
-
Drillback from GL to ARCSSummary Is there native G/L to functionality for Drilling Down from a Journal Entry in the Fusion GLContent Hello - We are trying to trace back journal entries to ARCS t…
-
Export Transactions View from Transactions TabSummary Is there a way were we can export transactions from the Transactions Tab under Matching Card?Content Hello, Is there a way were we can export transactions view f…
-
Currency TranslationSummary Currency Translating for Adjustments but not for the balance amount.Content I loaded balance data through pre-mapped format, manual entry and also from data mana…
-
Data Manager load with Replace failsSummary Loading any datafile for Transaction Matching where data already exists fails when exportingContent This is a general question about how ARCS is working. We have…
-
Migrate ARCS Transaction Matching Reports from TEST to PRODSummary Migrate ARCS Transaction Matching Reports from TEST to PRODContent Is there a way to migrate Transaction Matching custom reports from one instance to another? Lo… -
Redwood Theme IssueSummary Redwood Theme IssueContent If i select the new redwood theme, the card icons are not visible on the home page. I just see the text / title of each card, but not …
-
Prevent Duplicate Data - Transaction MatchingContent Is there any way to prevent duplicate data from being loaded to Transaction Matching through Data Management? If my client were to load data daily, but not compl…
-
How does send email on update rule worksSummary How does send email on update rule worksContent Hi All, We are trying to achieve one requirement where if for any reconciliation there is an unexplained differen…
-
Automate Copy transaction from prior reconciliation automaticallySummary Automate Copy transaction from prior reconciliation automaticallyContent Hi All, Is there any way through which we can automate copy transaction from prior recon…
-
Reconciliation between AP Subledger and Open AP InvoicesSummary Unable to do Transaction Matching due to the nature of data sourcesContent We have two levels of reconciliation for Account Payables. One is between GL and Suble… -
Examples of Summary and Group ReconciliationsSummary I need Examples of Summary and Group ReconciliationsContent I need real Examples of Summary and Group Reconciliations so that I can differentiate between the bot… -
Transform a field to UPPERCASE in Data ManagementSummary Transform a field to UPPERCASE in Data ManagementContent How can we transform the a field in the file to upper case in data management? Or can we? Thanks, Arun V…
-
Removing merged rows in Custom Excel xlsx reportSummary Have merged rows in a Custom Excel xlsx report - wish to removeContent Hi All I have an SR (3-22383956631) where I had issues with merged columns which I have so…
-
Reconciliation Assignments - Team vs Primary Team UserSummary Rec not getting assigned to primary user of teamContent Good afternoon We have many of our profiles assigned to teams (both preparer and approver teams), and the…
-
Recon is getting closed even after there is balance in it.Summary Recon is getting closed even without zero balance for all currencies except oneContent Hi All, I am creating recons for the period of August in RM , but a strang…
-
mapping a date field when some records are blankSummary trying to map a posted date field from a bank file, but since some lines don't have posted date, it fails validation (issue date is brought in - that is the requ… -
How does the Auto Reconciliation Method work with Balance Comparison with Transaction Matching?Summary We are not getting the expected results from setting the 'Balance is Zero' Auto Reconciliation Method from our Balance Comparison with Transaction MatchingConten… -
View Only AccessSummary Is it possible for a user to have viewer access, but only view reconciliations for specific companies?Content This seems like such an easy question, but I can't …
-
Journal Entry - Best PracticesSummary What is the best method for reclassing transactions?Content We have a case where there are multiple reclasses being made in a customer's home-grown account recon…