Dynamics Community Forum Thread Details

Validation on Form level for multiple expenses on total sum of amount

Hi team,

Please help me in this solution.

I have a expense category as OPD expenses and i wanted to put validation on form if expense amount is more than 5000 INR. I can add multiple expenses in 1 expense report so I have used on validating method but it not calculating the sum. Please help

[FormControlEventHandler(formControlStr(TrvExpenses, TrvExpTrans_AmountMST), FormControlEventType::Validating)]
public static void TrvExpTrans_AmountMST_OnValidating(FormControl sender, FormControlEventArgs e)
{
FormRun formRun = sender.formRun();

FormDataSource formDataSource = formRun.dataSource(formDataSourceStr(TrvExpenses,TrvExpTrans ));

TrvExpTrans TrvExpTrans = formDataSource.cursor();

real totalamt;

if(fieldNum(TrvExpTrans, AmountCurr))
{
select sum(AmountCurr) from trvExpTrans where
trvExpTrans.CostType == 'OPD Expenses'
&& trvexptrans.CreatedBy == curUserId() ;

totalamt = trvexptrans.AmountCurr;

if( totalamt >5000 && trvExpTrans.CostType == 'OPD Expenses' && trvexptrans.CreatedBy == curUserId())
{
throw Error ("OPD Expense cannot be claimed more than 5000 in a year");
}
}
}

Quick Links