Validation step only checks mappings. The trial balance report you want will be run in Check Step. You will need to define the validation rules to check the TB and then attach it to the location.
But irrespective of the TB balance value, Export step will run and load the data even if the Check report fails as this step will take place after Export.
Thanks for the reply.
But is there anyway to stop the export if the TB is not tallying? The file should not load if the TB is not tallyin right. So we want that restrictin while doing the data load.
There are various options you can use e.g. Create logic accounts to do the accumulation of totals then in the AftValidate script do a check on them, or do a SQL call to do the totalling. In the AftValidate script investigate the lngProcState variable - have a look in the FDM API guide you should be able to work it out from the examples and information provided.
Exactly, you can use Logic accounts to get the TB balance and check the same in AftValidate event script. You can use accelerators to check lngProcState variable.