Journal Entry Attachment Records/Audit
Hi All, We have a client who is concerned about users being able to delete and reload journal entry attachments. From what I can see there is no audit record of this, the items show up in the ‘Attachment’ table when posted but once deleted there is no record of this being deleted. From what I can tell there isn’t a separate audit table associated with this. Does anyone know if there is way to prevent users from being able to delete an attachment or a way to provide an audit of items that were changed? I also was trying to find where attachments for Journals get stored to see if changing security on a folder was possible (maybe the only record is the table itself and this isn’t an option). Another idea was an event handler but it doesn’t seem like deleting an attachment is considered an event. Any thoughts or suggestions would be appreciated!
How to convert a raw Excel file into multiple upload-ready OneStream journals. (3 quick steps)
Use case: You generated several journal lines in Excel. You saved it as a CSV file, and the upload to OneStream failed. Here’s how to clean it up and get it posted. 1) Paste your raw lines into Excel: Paste your raw journal lines into column A as above. Go to Data → Text to Columns → Delimited → Comma → Finish. You should now see the first column as H and the next two as D, D, with each field in its column. 2) Clean the values (common blockers) ConsName must be a valid Consolidation member in your app (e.g., Entity or Local). Leave ParentName blank unless you’re 100% sure of the direct parent. Don’t type literal None unless it’s a real member; leave IC/UD blank or use your member when required. Make sure Scenario → Cube mapping matches your CubeName. If JournalBalanceType=Balanced, totals of Debits = Credits per journal. 2) Save as CSV (UTF-8) Keep only the upload rows on the active sheet (no notes above/beside them). File → Save As → CSV UTF-8 (Comma delimited) (.csv). Accept “only the active sheet will be saved.” 3) Import & post in OneStream OnePlace → Journals → Import (or your Workflow step). Choose File Type = CSV, select your file, and Import. Open the journal, Validate/Balance, then Post. Run Consolidation and verify in a Cube View. Hope this helps some people within the OneStream Universe 😊.
Security - Posting an auto-reversing journal entry
A user approves an auto-reversing journal entry - security also allows the user to post. The user is unable to post. HOWEVER, in the subsequent period, the user is able to post the auto-generated reversal journal entry. Has anyone seen this and thoughts on resolution?Journal posting with alternative input currency flows
Dear community, I'm creating a very simple balanced journal template, with the exception that this journal will have to use "alternative input currency" flows. For that, I have set 2 flows like below : Input_USD : Input_CNY (chinese yuan): My journal is of "balanced" type. However, I have input done in both USD and Chinese Yuan and the Journal doesn't seem to care ? In the exemple below, I have 20 USD booked, and 20 CNY booked, and OneStream considers the journal posting as "balanced" : Am I missing something ? Regards,
Post Consolidation Adjs (OwnerPostAdj) on locked companies?
1. We have a very basic "standard entity workflow" with Import, Forms and Adjs. 2. Local uses does his job and lock the workflow and the related entity assigned to that workflow. Fine. .... And now we are lost. How the consolidator can post central adjs OwnerPostAdj? If we try to post the journal we receive: "Data validation error. Workflow Profile 'BlaBlaBla' is locked for 'Actual', '2023M4', 'AdjInput', and Workflow Channel 'Standard'." Is there a native configuration to enable "OwnerPostAdj" on a locked company? Or, if it is not a standard Onestream feature, are you aware of any a basic workaround to enable it ? Thanks in advance Marcello
