General Ledger & Intercompany
Discussion List
-
Multitier Intercompany OperationsSummary: Required setup and testing of Multitier Intercompany Operations Content (please ensure you mask any confidential information): New multitier functionality requi… -
INTER and INTRA Company Balancing Scenarios Examples M:1 and 1:M and M:MSummary: Attaching a document with examples of INTER and INTRA Company Balancing Scenarios as 1:M, M:1 and M:M to outline how balancing lines are generated for those exa…
-
💡It is possible to unassign a Legal Entity (LE) from a Ledger?Summary:💡It is possible to unassign a Legal Entity (LE) from a Ledger? Content: Once ledger completion status is confirmed, then Legal Entity (LE) cannot be disassociate… -
💡Do you know how granting user privileges to see output of all the ESS job processes?Summary: 💡Do you know how granting user privileges to see output of all the ESS job processes? Content: In this post we will provide an example for granting to a user pr…
-
💡Do you know how to delete old Essbase cubes after the P2T?💡Do you know how to delete old Essbase cubes after the P2T? Content: Please be informed that after P2T, if for example, you have a COA name different on TEST instance co…
-
ERP Event – Your Guide to Accounting Automation, March 13th, 9am PTRegistrations are open for the event Unlocking Efficiency: Your Guide to Accounting Automation If you have questions related to accounting automation, please post them h… -
Intercompany TAD setup exampleSummary: Attaching a document that provides example on how to setup Transaction Account Definition TAD for Intercompany Content (please ensure you mask any confidential …
-
💡It is possible to change the Ledger name/Description or Legal Entity name ?Summary: 💡It is possible to change the Ledger name/Description or Legal Entity name? Content: 1.1. Ledger Name: Yes, it is possible to rename the ledgers manually using …
-
💡 Do you know what are the essbase restricted characters and what is the impact of using them?💡 Do you know what are the essbase restricted characters and what is the impact of using them? Content: The following is a comprehensive list of characters and words tha…
-
The attachment does not gets copied to the autocopied Journal transaction when we copy a journal.Summary: The attachment does not gets copied to the autocopied Journal transaction when we copy a journal. Content (please ensure you mask any confidential information):…
-
how to delete bulk Journal Import errors data using templateSummary: User wants to delete the journals through ADFDI/spread sheet for bulk import errors. Is there a way other than delete journal import job(Passing mandatory param…
-
How to default the current month when creating a Manual JournalSummary: How to default the Accounting Period in a manual journal entry Content (please ensure you mask any confidential information):In my previous job we had the Accou…
-
how to update manage clearing account reconciliationWe have defined our account reconciliation before but business have requested to add new accounts to it, but when we try to update the list just blink and we are not abl…
-
Allocate Multiple Source Segments to multiple Target SegmentsSummary: Want to allocate an aggregated balance across several source dimensions with default Profit Center (0000). Target code combination would be based on Headcount b…
-
Do we have to update vendors to point to a new ledger and/or BU? If Yes, how to do this in MassSummary: We are in progress of trying to change our Fiscal Year to the Calendar Year and would like to know if we have to update vendors to point to a new ledger and/or …
-
Create a Consolidation Ledger for a legal requirementSummary: We need help to how to configure a consolidation ledger to supply a legal demand. We have 3 different ledger and we must consolidate all in a single ledger. We …
-
Issue with Run time Prompt variable in General Ledger Allocation RulesSummary: We have an issue where the Run time Prompt (Accounting Period in this case) is showing up twice when we are running Generate Allocations process. Content (pleas… -
Can I restrict the number of Post Journals submitted by a user using a Custom Data Security Policy?Summary: We would like to restrict users to limit the number of Journals they can submit for posting during any given session. We received the following suggestion at Op…
-
Approve and Reject Button on GL Journal UI are not visible to an ApproverWe have configured approval rules for GL Journals where in journals are routed to an Approval Group based on Journal Source. The approvers which are part of the Approval…
-
file-based data import process to import segment valuesHello I would like to use the following XLSM template ChartofAccountsSegmentValuesandHierarchiesImportTemplate.xlsm to massively modify the descriptions of 50 segment va…
-
While creating manual journals, system should not allow negative amount and zero amountHi All, The business requirement is that while creating the manual journal, the system should not allow the negative amount and zero amount lines to be posted. Could you…
-
What are the possible statuses returned by an ESS Job in REST APISummary: Content (please ensure you mask any confidential information): I am submitting an ESS job and checking the status. I want to understand what are all the possibl…
-
Document to identify seeded journal category used for journals coming from subledger transactionSummary: Document to identify seeded journal category used for journals coming from subledger transaction. Content (please ensure you mask any confidential information):…
-
How to make a parameter mandatory on a seeded ESS jobWhile running the seeded job "Transfer Intercompany Transactions to General Ledger we want to make the parameter "Provider Legal Entity" as a mandatory parameter, please…
-
Calendar Period Frequency - what does it doSummary: Does the calendar period frequency do anything other than default the period start/end dates? Is it OK to amend the auto-generated period dates or can this brea…
-
Intercompany accrual in current month and intercompany transaction in next monthThe Intercompany transactions (Entity A receives Invoice from External Supplier but the cost was originally for Entity B) are received almost towards the end of a month.…
-
COA segment value end dated and journal can be approved or postedSummary: COA segment value has been end dated. Enabled COA doesn't always show an error and when COA combo is disabled, a journal can still be approved Content (please e… -
The Value of the attribute Accounting Calendar isn't valid - ErrorSummary: Hi When I am trying to create Primary ledger, I am getting this error - "The Value of the attribute Accounting Calendar isn't valid" While creating calendar, th…
-
Purpose of 'Budget Execution' Journal CategorySummary: Hi all, We want to actually transfer some budget amount from one account combination to other. Will the Journal Category 'Budget Execution' serve the purpose? I…
-
Enterprise Structures Setup ReportSummary: Enterprise Structures Setup Report Content (please ensure you mask any confidential information): We created custom role for General Ledger Account manager role… -
How to restrict Journal Entry for Control Accounts?Summary: There is a business requirement in the cloud where only admin users should be permitted to create and post manual journals for control accounts, such as cash an…
-
Do you have to aggregate all years after you have closed a period to get the actuals?Summary: We have been told that every month when we close the period that all of the previous months, of the current financial year, and the previous financial years hav…
-
Caribbean Guilder - XCGSummary: The current currency of Curaçao and Sint Maarten - ANG (Antillean guilder) is being replaced by XCG (Caribbean Guilder) What are the impacts on GL? Content (ple…
-
Revaluation process required to hit the Gain and loss at the same time.Hello, We have the request to split the offset account for the revaluation process. This means that instead to netting the revaluation and affect a Gain or loss, custome…
-
Can CVR Rule Supersede Combination sets?We created a CVR Rule where all Balance Sheet accounts are only allowed to post with Department 0000. However there is an exception to this rule, for example a particula…
-
Moved: Restricting Schedule ProcessesThis discussion has been moved. -
Journals for Mexico report (XML) is failing while uploading into SAT PortalJournals for Mexico report is missing regional information hence showing errors while uploading to SAT portal. We have entered the regional information at header level a…
-
Why is the process "Post Journals for Single Ledger" blocked when posting a journal entry?Summary: Why is the process "Post Journals for Single Ledger" blocked when posting a journal entry?. Please your help!! Thanks Content (please ensure you mask any confid… -
journals accounting date tableDear All, Can anyone tell me where's the accounting date of the journal is stocked? I queried date_created column in the GL_JE_HEADERS table, but I noticed that I am obt…