Forum Stats

  • 3,759,064 Users
  • 2,251,495 Discussions
  • 7,870,478 Comments

Discussions

Journal loading to Entity Currency in FDM

user8452342
user8452342 Member Posts: 26
edited Mar 15, 2015 5:27PM in Financial Data Management

Hi Folks,

Recently I tried to load journals to HFM via FDM (11.1.2.1 , both classic applications). This is my first journal load and trying to prepare a POC.

I have enabled Journal load in FDM settings and successfully loaded sample excel journal template.

Problem is, output file created with <Entity Currency> instead of <Entity Curr Adjs>.

Some one please help me to rectify the issue.

Thank you.

Tagged:
user8452342

Answers

  • SH_INT
    SH_INT Member Posts: 3,187 Bronze Crown
    edited Mar 10, 2015 6:02AM

    Hi,

    Go to the location config screen for the locations you are loading the journals through and do the following:

    1)Click "Browse for Data Value" in the data value field

    2) Choose <Entity Currency>;<Entity Currency Adj.>

    This will ensure that any data loaded via the standard FDM workflow will be loaded to <Entity Currency> and any data loaded using the Journal template via the Journals load function will be loaded to  <Entity Currency Adj.>

  • user8452342
    user8452342 Member Posts: 26
    edited Mar 10, 2015 9:18AM

    Hi SH,

    I tried with updated location settings as specified.

    Still it is going to Entity Currency.

    Please find attached screen shots.integration settings.jpgLocation Settings.jpgOutput.jpg

  • SH_INT
    SH_INT Member Posts: 3,187 Bronze Crown
    edited Mar 10, 2015 9:32AM

    Are you submitting the templates via the Activities-->Journals screen?

  • user8452342
    user8452342 Member Posts: 26
    edited Mar 12, 2015 8:51AM

    Yes SH,

    I'm loading under Activities -> Journals only.

    It exports the file successfully but to <Entity Currency>

  • SH_INT
    SH_INT Member Posts: 3,187 Bronze Crown
    edited Mar 12, 2015 9:02AM

    Did you follow these steps in the Location screen?

    1) Click "Browse for Data Value" in the data value field

    2) Choose <Entity Currency>;<Entity Curr Adjs> as the Data Value option

    It's just your screenshot above is only showing <Entity Curr Adjs> in the Data Value selection

    user8452342
  • user8452342
    user8452342 Member Posts: 26
    edited Mar 15, 2015 11:52AM


    Thanks SH, that's helpful.

    1) Could you please differentiate <Entity Currency>;<Entity Curr Adjs>  and <Entity Curr Adjs>;<Entity Curr Adjs>

    2) Could you please provide me with a multiperiod flatfile(text) template.

  • SH_INT
    SH_INT Member Posts: 3,187 Bronze Crown
    edited Mar 15, 2015 5:27PM

    1) Data Value before ; used for datndard data loads after the ; used for journal loads

    2) It depends on how many periods you want to load but the header line format is well documented in the FDM admin guide so you can create your own template following the instructions held therein

This discussion has been closed.