IC Matching Summary Screen showing "NoData" rows
Hi Is it correct for OneStream to include “No Data” rows in the IC Matching Summary? The matching tolerance is set to 1000 and “Suppress Matches” is not selected (since matches need to be displayed). These accounts previously contained data but were cleared out.
The supplied Workflow Time is more than 3 periods after the last import period
We are currently in the process of upgrading to OFC PV840-SV112 and just applied the upgrade to our Customer Acceptance Testing Application where we have our imports and matching running daily. However, the amount of data imported is much less in this applicationas it is using a test database to import the data from and one of the matchsets has not imported any data for many months. The matching step for that matchset erred out a couple of days after the upgrade with the message "The supplied Workflow Time is more than 3 periods after the last import period". We discovered that if we loaded just one "dummy" row for the matchset that the error stopped happening. My questions are - has anyone else noticed this? And, if so, is there a setting somewhere to either turn this check on or off or increase the number of months that it looks back? Thanks for any information you can provide.
IC-Matching Confirmation Rule
Hi Everyone, We are trying to incorporate the status of the IC-Matching Report into the Confirmation rule. While reviewing discussions on the community board, I found the following object: brapi.DataQuality.Status.GetICMatchingStatusItems. However, I am having trouble getting it to work in a script. Could anyone share how they prevent users from confirming the workflow if the IC transactions do not match? Your insights would be greatly appreciated!
Intercompany Report for Non-consolidating entities
I am running into an issue with putting together intercompany reports. Basically, if an entity has an intercompany partner that is not a consolidating entity, no elimination would occur at the parent (as expected). However, this pair would still show up on my IC matching report. Has anyone dealt with this type of issue with the IC reporting and has any tips to put me in the right direction?Elimination Extract
Hi, I am trying to run an elimination export where I am trying to pull data for elimination under a hierarchy. If I am leaving the parent pov blank- I get the below error. Error processing Data Management Step 'Test'. Error processing data. The item was not found. Entity, Parent, -1. What should I do to dynamically pull elimination for a hierarchy.Show Partner Status in a Dashboard
Hi - Is there a way to override security to show the IC Partners' Workflow Statuses in a Dashboard so each workflow can view altogether the status of all Partners? I created a data adapter using a WorkflowAndEntityStatus Method Query but they can only see the Workflows they are in the Access Group of. Can I replicate what is happening behind the scenes in the IC Matching > Show Partner Workflow Status? Thanks in advance to anyone that can help!
How OneStream eliminates intercompany profit in the inventory?
Hello, I'm trying to figure out a way to have OneStream perform profit in inventory eliminations. Currently we manually compile data in excel to calculate how much profit sitting in the inventory and at what common parent we need to eliminate it. These manual eliminations are ultimately loaded in OneStream via upload files. One thought is to setup custom input form in the workflows that would collect ins-&-outs of profit in the inventory and utilize Flow dimensionality. But I'm not sure if there is a better approach to this problem.FX translation for Reporting Currency
Hi All, Need assistance in posting a journal to eliminate the difference. I tried posting a journal using reporting currency (ZAR) to eliminate the difference, but it's not going through. The translation should be periodic. Anyone have any idea what I'm missing?
