Forum Stats

  • 3,780,524 Users
  • 2,254,407 Discussions
  • 7,879,373 Comments

Discussions

creating a closing balance in FDM

786797
786797 Member Posts: 83
edited Jun 5, 2014 4:17AM in Financial Data Management

Hi,

the IT department is only able to provide periodic transaction from their GL.

While it is not a problem to load periodic values for a P&L account, it is for a Balance Sheet one.

now i managed to import all data into the first year last period to create a closing (last period first year) and subsequently opening balance (first period, second year).

so what is left is to create (meaning import) following closing balance.

one idea is would be to collect the previous period (by account and dimensions, not transaction) and add the current transaction to that, in a Befimport script.

so my question is as following: would it be possible to retrieve, maybe from the tdataseg table, a sum by HFM dimension of the previous period? or would it potentially create performance issue?

or is there any other smart way / best practice to do this?

thanks for any help

Tagged:

Best Answer

  • 786797
    786797 Member Posts: 83
    edited Jun 5, 2014 2:08AM Accepted Answer

    Hi Francisco,

    actually the above would not solve the issue. What i had to do is configure FDM to Periodic and then retrieve information from the previous period for the BS (from the TdataSeg) to create a closing balance. a little tricky but it works.

    thank you in any case.

    How do i close a thread?

Answers

  • Francisco Amores
    Francisco Amores Member Posts: 1,694 Bronze Crown

    If I understood well, you have one file for P&L and BS? or are they different files?

    If you source data is PERIODIC for both P&L and BS, you can configure FDM to import/export to PERIODIC Data View instead of YTD (which is the default value), HFM will calculate YTD automatically.

    Would it solve your issue?

  • 786797
    786797 Member Posts: 83
    edited Jun 5, 2014 2:08AM Accepted Answer

    Hi Francisco,

    actually the above would not solve the issue. What i had to do is configure FDM to Periodic and then retrieve information from the previous period for the BS (from the TdataSeg) to create a closing balance. a little tricky but it works.

    thank you in any case.

    How do i close a thread?

  • Francisco Amores
    Francisco Amores Member Posts: 1,694 Bronze Crown

    You can do it so by using event script BefImport/AftImport to ensure your previous data is also mapped.

    You can close the thread by marking as correct/helpful.

    Regards

This discussion has been closed.