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
-
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… -
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… -
Using Date Condition in Transaction Matching Custom ReportSummary Using Date Condition in Transaction Matching Custom ReportContent I want to restrict the data by a condition like "Transaction Created Date = SYSDATE". How can I…
-
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… -
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…
-
Drill in ERP is not workingSummary Drill in ERP is not workingContent Hi All, After doing the drill through option in the ARCS. It is saying that member XXXX is not found . Though the member is th…
-
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 …
-
Understanding Balance Comparison with Transaction MatchingContent My client would like to utilize reconciliation compliance and transaction matching to replace their current Payroll rec process. They would like to use rec compl…
-
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… -
Drill thru operation not workingSummary Drill thru operation not workingContent Hi All, I am getting null pointer exception after clicking the hyperlink on the Amount in the reconcile item, Attaching t…
-
Subledger Transaction data can be used for both Transaction Matching and Balance Comparison(Recon CoSummary We have periodic Transaction level data extract for all subledgers(AP,AR,FA,Cost,Cash), can we use same extract for both Transaction Matching and reconciling the…
-
Loading Daily Balance from GLSummary Automatically scheduling Daily load of balances from GL to ARCS -Balance ReconcilitationContent Hi All Need your suggestion on the configuration Scenario- Client… -
Pulling in Accounts Payable (AP) and Accounts Receivable (AR) transaction detail into ARCSSummary Trying to load AP and AR Subledger Transactions into ARCS systemically via Data ManagementContent I am attempting to leverage the systemic ability to load subled… -
ERROR_INVALID_PERIOD.............. Invalid period specified in the file.Summary Loaded Data into FDMEE, the log file has the error, "ERROR_INVALID_PERIOD.............. Invalid period specified in the file."Content Looking for what I am missi…
-
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… -
Data load rule by Power userSummary Data load rule by Power userContent How a power user can trigger a data load rule in the ARCS.
-
Error when importing template to a report definition - Data managementContent I am trying to load a custom template to a report definition in Data Management but receive an error (see screenshot). The template I am trying to load is in rtf…
-
Mapping to IGNORE in Data Management showing in ARC as Invalid MappingContent My client has certain accounts that they would like to map to IGNORE in ARC. We loaded data for the first time since the new release and all of the ignored accou…
-
DATEDIFF attribute functionSummary DATEDIFF attribute function are counting weekendsContent Hello, We are using the DATEDIFF attribute function to calculate the difference between two dates in ARC… -
Currency Buckets and Category MappingSummary If we change the label of any currency bucket, system does not allow renaming category mapping in data managementContent We have renamed reporting currency bucke…
-
Transaction Matching Audit ReportsSummary Looking for TM Audit report for changes made to the TM configurationContent Hi, we are in the process of configuring Transaction Matching for a client and their …
-
Using DM to bring Bank Transactions into ARCSSummary Using DM to bring Bank Transactions into ARCSContent Hi, I am configuring matching for the first time. Customer has the Swift bank format. I have DM working but …
-
Transaction Matching with a Single Source where need to exclude transactions from Exact MatchSummary Transaction Matching with a Single Source where need to exclude transactions from Exact MatchContent While defining Match type with a Single source (Clearing Acc…
-
Change in the language of the applicationSummary Change in the language of the applicationContent Hello, There is a requirement of the language change of the application. Currently, the default language of the … -
Period created for 365 days in a year for Transactions and Balance load from GL but Reconciliation aSummary Period created for 365 days in a year for Transactions and Balance load from GL but Reconciliation activity to happen on Workdays onlyContent 1. A flat file with…
-
Blank ReconsSummary Right way to handle Blank reconsContent Our ARCS solution is defined based on a global Chart of Accounts. Not all the ledgers may necessarily use all of the acco…
-
DELAY IN DATA LOADINGSummary to restart data loadContent Hi, we have loaded the data in the application and the loading process has already been 4 hours duration. We would like to restart ch… -
Data Management TM Data Load IssuesSummary I have been having issues trying to map data for a transaction matching processContent I have been trying to load a file for a TM process when the file does not … -
Account Mapping doesn't have impact on the profile mappingSummary While Ignoring some accounts in the Account Mapping, Do we need to ignore the same Accounts in profile while doing the profile mapping?Content Please consider yo…
-
Calculated Attribute for Quarter Activity does not show any valueSummary Calculated Attribute for Quarter Activity does not show any valueContent All - I am trying to bring activity between quarters with calculated attribute using 'sc…