Skip to main content
S
Sergey
November 14, 2023
Solved

Journal posting with alternative input currency flows

  • November 14, 2023
  • 3 replies
  • 1 view

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,

 

 

 

    Best answer by chul

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

    3 replies

    C
    chulAnswer
    November 14, 2023

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

    S
    SergeyAuthor
    November 14, 2023

    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,

    C
    chul
    November 15, 2023

    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.

    S
    SergeyAuthor
    November 16, 2023

    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