December Journal Entry
I am trying to record an additional Depr Exp in December 2024. Db Depr Exp (P&L) Cr AD Machine &Equip. (BS) However, when I roll into January 2025, the effect of the December entry has been calculated into the BOP Retained Earnings, but my balance sheet does not balance. I can tell the AD Machine & Equip account does not reflect the additional amount recorded in the journal entry. I need to enter this JE into January of the following year, am I supposed to enter this as an unbalanced journal entry, hitting only AD Machine & Equip?
Cube Views Copying into Default Workspace
When we take an XML extract of an application with Cube Views built within Workspaces and load into a fresh application there are Cube View groups for each of the Workspace groups on the main Cube View screen/in the Default Cube Views. It is essentially making a second copy of all the Workspace Cube Views in Default. Some Data Adapters are then linking to the new Cube Views copies in Default that did not exist in the original application the XML was taken from. Has anyone else seen this behavior? Is this a known bug - doesn't seem like expected behavior?
Eliminations between Balance & P&L accounts
Hi everyone; we have an application using standard elimination, we have been used eliminations between balance account and P&L accounts, I created a new account in Balance sheet accounts with plug account as Assets, create another P&L account (Revenue) using the same plug Asset account; now when runs the consolidation & Eliminations, there is a difference with balance, is unbalancing. Is there an specific configuration that I need to setup into the accounts? Thanks in advance and best Regards. Mario GV
Data Audit Dashboard
Hi All, I am trying to create a dashboard to extract the data for the given point of intersection basically I have given all the dimension parameter for the user to select and click on the button download that runs the DataManagement job and will extract the data for the selected POV . I am able to achieve the above requirement just like an enhancement I want to also get the data of the user details who has loaded data into those point of intersection. Can some one help me with the lead how can I achieve the above user details that would be really great. Thank You
Cube View Group - Forms
Hi, I'm trying to figure out how can I make few rows as un editable. Example: highlighted rows in below screenshot. I remember this can be done through Row overrides but its not working. In column member filter, I defined two dimensions as below. What should I define in Row override to have 'Total Revenues', 'Total Expense' and 'Personal' rows un editable?Entity Consolidation status change for Forecast scenarios
Hi Folks, We have 12 forecast scenarios and 12 FX rate tables for each FC scenario. When we update the FX Rates in one table, it's upsetting the status in all other Forecast scenarios, but not Actual. We don't want other scenarios status getting affected when ever FX rates updated. and there is impact status rules exists in our application. Appreciate your advise. Thanks
Extracting Journals in a loadable format?
Hi, We're on 7.4. Is there a way to extract a posted journal from one application so that I can easily load it to another application. This would be super useful for investigating issues. At present, we can easily find imported data files, and load these into our test app. But I can't see any way to extract journals in the same way. The only options seem to be extracting a .csv file, which has the information but is not formatted in a way that can be loaded again.Attribute Members on Entity Dimension Do Not Translate ?
I'm using attribute members, unfortunately on the entity dimension, so the associated data is stored and not dynamically calculated on Parent Entities. These attributes members do not translate to foreign currencies during the consolidation process ! I'm using a 'Custom Translation', and when I execute the method 'Api.Data.Calculate()' or 'Api.Data.CalculateForTranslation()' the attribute cells do not translate. The only way I was able to actually convert them is by using Data Buffers and forcing the conversion. Is there a reason why ADC methods do not translate attributes ? Is there a hidden property to activate in order to take these members into account ? Should I use 'Api.Data.Translate()' instead of ADC ? ThanksExport Data of Selected Parameter
Hi All, I am trying to create the dashboard where I pass all dimension from combo box to button taht triggers the DM sequence that has the Export Data step. I get the following error mentioned below. FYI please see the screenshot of the export data step mentioned below. Can someone please help where I am going wrong please help me with the approach. Thank you
