1 Reply Latest reply on Jan 29, 2010 11:13 AM by COW8LI

    Integration Script SQL

    652244
      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?

      Thanks
      Kannan.