Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Not under consideration
Created by Guest
Created on Jul 5, 2019

Created by currency conversion using D-rate, converted values exist to roll over to Retained earnings next year

For automatically generated journals type: “Created by currency conversion using D-rate, converted values exist” which do not have values in LC, and have values only in legal currency, to implement a mechanism that helps to roll retained earnings in legal currency to next year.  Currently the copy of the journal is deleted the next year when running the currency conversion, which is normal because there are no values in LC.

 

Current work around is that manual journals needs to be passed to adjust the Retained earning Opening balance which is for a lot of companies. Passing these manual journal on an implementation of more than 50+ foreign entities is time consuming especially if a normal LC journal does copy the IS portion to RE OB in the next year.

 

I have also logged a call and please refer to case  TS001779025 where it has been discussed in detail and has been sent to R&D for testing as well.

  • Admin
    Maximilien de Chestret
    Reply
    |
    Aug 20, 2019

    HI Jackie

    Yes sure .

    Regards

    Max

  • Guest
    Reply
    |
    Aug 20, 2019

    Hi Max

     

    Could we perhaps have a call middle of September once I am back from maternity leave to discuss?

     

    Kind Regards,

    Jackie

  • Admin
    Maximilien de Chestret
    Reply
    |
    Aug 12, 2019

    Hi Jackie

    In fact to solve your issue would be to create a new conversion code that will apply the rate of last year ( D rate) when the figures are related to REPO and takeover the value in Group currency ( C rate)when the figures are related to journals. We don't have such rate and honestly we have never received this type of request. It's more a process problem, for me the adjustment of the RE balance should be done via a journal in Controller ( perhaps can be downloaded from the ERP)and the EB on Repo must always be copied to the OB. An other possibility would be to add in Controller this adjustment to RE in a specific journal in the closing period and copy it in Repo in the next year .

    The OB on RE must use the C rate.

    If you want you can set-up a call to discuss it.

    Regards

    Max

  • Guest
    Reply
    |
    Jul 30, 2019

    Hi Max

     

    Apologies but I am on maternity leave. Please see below answers to your questions:

    "You mention that C code did not provide the correct values when the opening balance was not retrieved from Controller but rather loaded from a TB." yes to the RE balance in Controller be different that the OB in the ERP. New IFRS statement allows for adjusting the RE balance. So in this case the client is loading the ERP's OB and not deriving it from Controller.

     

    D-rate on IS accounts journals gets created by the system and are called "Created by currency conversion using D-rate" there are however no LC journal in month 12 associated to this converted (LE currency type). All IS REPO and journals should be copied across to the RE OB account in the new year. Controller only seems to be copying REPO and LC journals, but because there is no LC journal but only a LE journal Controller is not copying the converted journal to the new year. So we are currently sitting with a mismatch of CB to OB. 

     

    Hope this provides more feedback - else in the original idea I have added the case number for in depth detail as we did go forwards and backwards with R&D re the query, else let me know and I will provide more information

     

    Kind Regards,

    Jackie

     

  • Admin
    Maximilien de Chestret
    Reply
    |
    Jul 12, 2019

    Hi Jacqueline, i sent you an email but for some reasons he came back.

    Hi Jacqueline,

    We (OM) had a look to your request related to D rate.

    Clearly the currency conversion rate "I" ( using as rate the division of the converted value by the local value) is not appropriate for OB when using the D rate as it could create journals only in group currency.

    So in this case only the "C" rate can be used for the OB and that's what is used by our customers ( I believe that majority of them use D rate for P/L).

    You mention that C code did not provide the correct values when the opening balance was not retrieved from Controller but rather loaded from a TB.

    Could you explain what's the issue ( normally you should have values in the previous year in group currency) ?

    Also why you load OB and don't copy it from previous year as it will prevent from having OB/EB differences ?