Forum Discussion

Krishna's avatar
Krishna
Valued Contributor
10 months ago

Balancesheet Period DataLoad

Hi All - I have a quick question on Periodic Data Load for Balance Sheet. If I load Periodic data to BS accounts, will it calculate YTD automatically? or we need to write a formula to get the YTD val...
Consolidation
Krishna's avatar
Krishna
Valued Contributor

Thanks JackLacava - I wanted to make sure you that I understand correctly, without any configuration in OS the below illustrations are correct. See the image below

 

 

JackLacava's avatar
JackLacava
Honored Contributor
9 months ago

Yes that's what you would expect in the database.

  • Krishna's avatar
    Krishna
    Valued Contributor
    9 months ago

    JackLacava  - I tried importing periodic data using Import WF and see the below results. It is not performing the same as the previous screenshot. Do I need to change anything in Scenario Settings ? or WF settings to calculate 

     

     

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      9 months ago

      There might be other factors at play, like rules and datasource settings. Feel free to get in touch with Support through the web portal to go through proper troubleshooting, doing it here would take too long.

      • Krishna's avatar
        Krishna
        Valued Contributor
        9 months ago

        Thanks JackLacava .  Here are my findings. I tried the below still the same behavior.  There is not an out of box functionality. As you mentioned we have to write a rule and set the scenario settings to periodic. I am going to test with the rule and update the same.

        1. I tried the Scenario settings with Periodic and load the data to Periodic. Trial and Error with different combination

        2. Setting the Flow Switch Type to True and Asset account is acting as Revenue. I don't think we need to perform this, but I just tried to see the outcome.

        3. Set the below WF Settings and tried loading the data.