Integration Script SQL

    Hi Experts,

    We are trying to load data to HFM using FDM. We have implemented logic accounts concept to check if the balances equal to zero. Since the users are loading for more than 20 entites, it is very difficult for the users to check all the logic account values once they load the data. Is there any way to create a report after Importing / Before validation to check the trial balance? We tried to implement this logic in BefValidate event using temperory variables, but it didnt work. Is there any way to do this by querying the FDM database and stopping the validation process if balances are not equla to zero? Can you also provide information on Integration Scripts?

      • 1. Re: Integration Script SQL

        I have the similar issue but fail to stop the export process when the source entity trial balance does not equal to 0.

        Does any one have any solution?

        Any suggestion would be appreciated.