Skip to main content
Employee - Guide
SergeyEmployee - Guide
Employee - Guide
Nov 14, 2023 8:44 AM UTC
Solved

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 :

Sergey_0-1699951188223.png

Input_CNY (chinese yuan):

Sergey_2-1699951226068.png

 

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" :

Sergey_3-1699951417713.png

Am I missing something ?

Regards,

 

 

 

    chulAnswer
    Employee - Guide
    Nov 14, 2023 4:41 PM UTC

    You're not missing anything. Translation on the database hasn't happened at this stage so it doesn't know the translated values.

    View in thread

    4 replies

    Employee - Guide
    chulEmployee - GuideAnswer
    Employee - Guide
    Nov 14, 2023 4:41 PM UTC

    You're not missing anything. Translation on the database hasn't happened at this stage so it doesn't know the translated values.

      Employee - Guide
      SergeyEmployee - GuideAuthor
      Employee - Guide
      Nov 14, 2023 4:48 PM UTC

      It makes sense, should the system provide a "balanced" information as these input should be in different currencies (based on the flow dimension elements) ? Or should we just use an "unbalanced" journal type, and manage the balancing information in a confirmation rule for instance ?

      Regards,

      Employee - Guide
      chulEmployee - Guide
      Employee - Guide
      Nov 15, 2023 8:12 PM UTC

      Are the users entering each side of a single journal in different currencies? For example:

      DR Accounts Receivable     100 EUR

      CR Sales                                                 87 GBP

      I haven't come across this use case. You would have no choice but to create the template as unbalanced as it will never balance if this is what the user is entering.

      If you add a confirmation rule, I would assume that due to the fluctuation in exchange rates, you would need to also build in an acceptable threshold. In which case, that is also simply a number. But you can write code to translate on the fly in the confirmation rule.

        Employee - Guide
        SergeyEmployee - GuideAuthor
        Employee - Guide
        Nov 16, 2023 8:02 AM UTC

        Well, it's more like I would allow the user to input in both in Euros, or Both in GBP. In any case, it seems it doesn't balance at this stage, but would require a confirmation rule in the next workflow step, So "unbalanced" it is 🙂

        Thanks !

        Terms & ConditionsAccessibility statement