Skip to main content
J
OneStream Employee
jcooleyOneStream Employee
OneStream Employee
May 15, 2026

Tech Talks After Hours: Journal Entry Manager (JEM) Part 2

  • May 15, 2026
  • 0 replies
  • 0 views

Go beyond the basics of Journal Entry Manager and join Chris Morelli and Tom Linton dive deep into ERP setup, extract and format options, template configuration, and automation best practices.

Key Topics Covered

  • JEM is part of the OneStream Financial Close for Administrators package, which includes five elements: Account Recs, Transaction Matching, automating OFC, Journal Entry Manager, and readiness toolkits/micro course
  • ERP creation in JEM: setting up the ERP object, reviewing a fully built-out example, and understanding the field structure (no predefined fields — fully customizable per ERP system)
  • Defining ERP fields: each field is a text box named to match the source ERP, with configurable attributes per field
  • Extract format and format options: how JEM structures the extract file sent back to the source ERP after journal approval
  • Connection types: currently flat file-based (SFTP and similar); direct connect is a forward-looking statement; cybersecurity considerations kept in mind
  • Direct download fallback: if no connection is configured, JEM provides a manual download option so journals can still reach a posted state regardless of connection setup
  • Recommended approach for implementation: start with direct download during setup/testing to avoid hitting SFTP repeatedly, then switch to a live connection once formatting is confirmed correct
  • Template creation: building journal entry templates that define the structure and fields for entry
  • Posting response options: how JEM handles the response after a journal is posted to the ERP
  • Integration Controller: a relatively new capability that exposes JEM endpoints so custom assemblies can call JEM code (e.g., prepare journals, approve journals) outside of predefined data management jobs
  • Example automation: an auto-import and auto-approve assembly tied to a data management job, using the Integration Controller to run JEM's prepare and approve workflows programmatically
  • Resources: Navigator for JEM learning content, including the Financial Close for Administrators package, readiness toolkits, and upcoming micro course

 

 

Terms & ConditionsAccessibility statement